我想用‘关键词’来帮助我过滤csv数据

Question

我必须从给定的信息中筛选出csv数据并打印出来。我对python很陌生，我脑子里想的是，我会在列表中创建关键字，而不是写一些函数，如果它在csv数据中包含了这些单词，它就会打印出我的数据。

这就是我试过的

keywords = ("AIG","Baylor","CGG","Citi","EcconMobil","Flow-Cal Inc.",
       "Global SHop Solutions","Harris Count CTS","HCSS",
       "Hitachi Consulting", "HP Inc.","INT Inc.","JPMorgan Chase & Co",
       "Leidos","McKesson","MRE Consulting Ltd.","NetIQ","PROS",
       "San Jacinto College","SAS","Smartbridge","Sogeti USA",
       "Southwest Research Institute","The Reynolds and Reynolds Company",
       "UH Enterprise Systems","U.S. Marine Corps","ValuD Consuting LLC","Wipro")

pattern = (" ".join(keywords))
with f as filterf:
    for line in filterf:
        if not re.search(pattern,line):
            print(line.strip())

print(pattern)

这就是我需要打印出来的

0 AIG,10,,,,Yes,,,Jr,,,MS,,
1 Baylor College of Medicine,19,Yes,Yes,,,,,,,,,,Recent
2 CGG,17,Yes,Yes,,,,,,,,MS,PhD,Recent
3 Citi,27/28,Yes,,,Yes,,,Jr,Sr,,,,
4 ExxonMobil,11,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,,,
5 Flow-Cal Inc.,16,Yes,,,Yes,,,Jr,Sr,,,,All
6 Global Shop Solutions,18,Yes,,,Yes,,,,Sr,PB,,,All
7 Harris County CTS,22,Yes,,,Yes,,,Jr,Sr,PB,MS,PhD,All
8 HCSS,29,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,Recent
9 Hitachi Consulting,13,Yes,,,,,,,Sr,,MS,,
10 HP Inc.,1,Yes,,,Yes,,,Jr,,,MS,,Recent
11 INT Inc.,20,Yes,Yes,,Yes,,,Jr,Sr,,MS,PhD,
12 JPMorgan Chase & Co,3,Yes,,,Yes,,,Jr,Sr,,,,
13 Leidos,390,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,
14 McKesson,26,Yes,,,,,,,Sr,,,,
15 MRE Consulting Ltd.,2,Yes,,,,,,,Sr,PB,MS,,All
16 NetIQ,7,,,,Yes,,Soph,Jr,Sr,PB,,,
17 PROS,21,Yes,,,,,,,Sr,,MS,PhD,All
18 San Jacinto College ,14,,,,Yes,,Soph,Jr,Sr,PB,MS,,
19 SAS,4,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,Recent
20 Smartbridge,8,Yes,,,,,,,Sr,PB,MS,,
21 Sogeti USA,15,Yes,,,,,,,Sr,PB,MS,,
22 Southwest Research Institute,12,Yes,,,Yes,,,Jr,Sr,PB,MS,PhD,All
23 The Reynolds and Reynolds Company,23,Yes,Yes,,Yes,Fr,Soph,Jr,Sr,PB,,,All
24 UH Enterprise Systems,9,Yes,Yes,Yes,Yes,Fr,Soph,Jr,Sr,PB,MS,PhD,All
25 U.S. Marine Corps,25,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,All
26 ValuD Consuting LLC,5,Yes,,,,,,,Sr,PB,,,All
27 Wipro,24,Yes,,,,,,,Sr,PB,,,

这是我的csv数据

>   ALPHABETICAL ORDER,,,,,,,,,,,,,
> ,,Positions,,,,Classifications,,,,,,,
> Company,Booth,Full-Time,"Full-Time Visa
> Sponsor",Part-Time,Internship,Freshman,Sophomore,Junior,Senior,Post-Bacs,MS,PhD,Alumni
> AIG,10,,,,Yes,,,Jr,,,MS,,
> Baylor�College�of�Medicine,19,Yes,Yes,,,,,,,,,,Recent
> CGG,17,Yes,Yes,,,,,,,,MS,PhD,Recent Citi,27/28,Yes,,,Yes,,,Jr,Sr,,,,
> ExxonMobil,11,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,,, ,...
> Flow-Cal�Inc.,16,Yes,,,Yes,,,Jr,Sr,,,,All
> Global�Shop�Solutions,18,Yes,,,Yes,,,,Sr,PB,,,All
> Harris�County�CTS,22,Yes,,,Yes,,,Jr,Sr,PB,MS,PhD,All
> HCSS,29,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,Recent
> Hitachi�Consulting,13,Yes,,,,,,,Sr,,MS,,
> HP�Inc.,1,Yes,,,Yes,,,Jr,,,MS,,Recent
> INT�Inc.,20,Yes,Yes,,Yes,,,Jr,Sr,,MS,PhD,
> JPMorgan�Chase�&�Co,3,Yes,,,Yes,,,Jr,Sr,,,,
> Leidos,390,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,
> McKesson,26,Yes,,,,,,,Sr,,,, ,,,,,,,,,,,,,
> MRE�Consulting�Ltd.,2,Yes,,,,,,,Sr,PB,MS,,All
> NetIQ,7,,,,Yes,,Soph,Jr,Sr,PB,,, PROS,21,Yes,,,,,,,Sr,,MS,PhD,All
> San�Jacinto�College��,14,,,,Yes,,Soph,Jr,Sr,PB,MS,,
> SAS,4,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,Recent
> Smartbridge,8,Yes,,,,,,,Sr,PB,MS,, Sogeti�USA,15,Yes,,,,,,,Sr,PB,MS,,
> Southwest�Research�Institute,12,Yes,,,Yes,,,Jr,Sr,PB,MS,PhD,All
> The�Reynolds�and�Reynolds�Company,23,Yes,Yes,,Yes,Fr,Soph,Jr,Sr,PB,,,All
> UH�Enterprise�Systems,9,Yes,Yes,Yes,Yes,Fr,Soph,Jr,Sr,PB,MS,PhD,All
> U.S.�Marine�Corps,25,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,All
> ValuD�Consuting�LLC,5,Yes,,,,,,,Sr,PB,,,All
> Wipro,24,Yes,,,,,,,Sr,PB,,, BOOTH ORDER,,,,,,,,,,,,,
> ,Booth,Positions,,,,Classifications,,,,,,,
> Company,#,Full-Time,"Full-Time Visa
> Sponsor",Part-Time,Internship,Freshman,Sophomore,Junior,Senior,Post-Bacs,MS,PhD,Alumni
> HP�Inc.,1,Yes,,,Yes,,,Jr,,,MS,,Recent
> "MRE�Consulting,�Ltd.",2,Yes,,,,,,,Sr,PB,MS,,All
> JPMorgan�Chase�&�Co,3,Yes,,,Yes,,,Jr,Sr,,,,
> SAS,4,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,Recent
> ValuD�Consuting�LLC,5,Yes,,,,,,,Sr,PB,,,All
> NetIQ,7,,,,Yes,,Soph,Jr,Sr,PB,,, Smartbridge,8,Yes,,,,,,,Sr,PB,MS,,
> UH�Enterprise�Systems,9,Yes,Yes,Yes,Yes,Fr,Soph,Jr,Sr,PB,MS,PhD,All
> AIG,10,,,,Yes,,,Jr,,,MS,, ExxonMobil,11,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,,,
> Southwest�Research�Institute,12,Yes,,,Yes,,,Jr,Sr,PB,MS,PhD,All
> Hitachi�Consulting,13,Yes,,,,,,,Sr,,MS,,
> San�Jacinto�College��,14,,,,Yes,,Soph,Jr,Sr,PB,MS,,
> Sogeti�USA,15,Yes,,,,,,,Sr,PB,MS,,
> "Flow-Cal,�Inc.",16,Yes,,,Yes,,,Jr,Sr,,,,All
> CGG,17,Yes,Yes,,,,,,,,MS,PhD,Recent
> Global�Shop�Solutions,18,Yes,,,Yes,,,,Sr,PB,,,All
> Baylor�College�of�Medicine,19,Yes,Yes,,,,,,,,,,Recent
> "INT,�Inc.",20,Yes,Yes,,Yes,,,Jr,Sr,,MS,PhD,
> PROS,21,Yes,,,,,,,Sr,,MS,PhD,All
> Harris�County�CTS,22,Yes,,,Yes,,,Jr,Sr,PB,MS,PhD,All
> The�Reynolds�and�Reynolds�Company,23,Yes,Yes,,Yes,Fr,Soph,Jr,Sr,PB,,,All
> Wipro,24,Yes,,,,,,,Sr,PB,,,
> U.S.�Marine�Corps,25,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,All
> McKesson,26,Yes,,,,,,,Sr,,,, Citi,27/28,Yes,,,Yes,,,Jr,Sr,,,,
> HCSS,29,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,Recent
> Leidos,30,Yes,,,Yes,Fr,Soph,Jr,Sr,PB,MS,,

我一直在网上看东西，花了那么多时间看东西。我是全新的，它是如此的压倒性。如有任何建议或想法，将不胜感激。

这就是指纹

AIG Baylor CGG Citi EcconMobil Flow-Cal Inc. Global SHop Solutions Harris Count CTS HCSS Hitachi Consulting HP Inc. INT Inc. JPMorgan Chase & Co Leidos McKesson MRE Consulting Ltd. NetIQ PROS San Jacinto College SAS Smartbridge Sogeti USA Southwest Research Institute The Reynolds and Reynolds Company UH Enterprise Systems U.S. Marine Corps ValuD Consuting LLC Wipro

Answer 1

你只是在打印你的图案价值。搜索和打印没有打印任何内容。尝尝这个。

with f as filterf:
    output_line_counter = 0
    for line in filterf:
        if any(keyword in line for keyword in keywords):
            print(output_line_counter, line.strip())
            output_line_counter += 1

之后移除print(pattern)行