我想使用 'keywords' 来帮助我筛选 csv 数据



我必须从给定的信息中过滤掉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

你只是在打印你的模式值。搜索和打印不打印任何内容。试试这个。

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)

最新更新