在线观看不卡亚洲电影_亚洲妓女99综合网_91青青青亚洲娱乐在线观看_日韩无码高清综合久久

鍍金池/ 問答/Python/ 用python迭代循環(huán)讀取文本出現問題?

用python迭代循環(huán)讀取文本出現問題?

手頭兩個csv表格(樣本的內容貼在最下面),一大一小,大的有將近7萬行,小的4千多行,需要找出其中大文件ic.csv的第6列中包含小文件ga.csv的第2列值的行。
我自己嘗試寫了如下代碼:


file0 = 'ic.csv'
file1 = 'ga.csv'

ic = open(file0)
ga = open(file1)
count_ga = 0
for ga_line in ga:
    count_ic = 0
    #獲取GA第2列的值
    ga_str  = ga_line.split(',')[1]
    for ic_line in ic:
        #獲取IC第6列的值
        ic_str = ic_line.split(',')[5]
        #如果IC第6列包含GA第2列中的值,則打印出各自的行號
        if ga_str in ic_str:
            print('GA第%d行與IC第%d行匹配'%(count_ga,count_ic))
            continue
        count_ic += 1            
    count_ga += 1

運行上述代碼只有這一條結果,不知道哪里出問題了,結果如下:

GA第0行與IC第0行匹配

將代碼中的continue改成break后的結果如下:


GA第0行與IC第0行匹配
GA第1行與IC第8行匹配
GA第2行與IC第0行匹配
GA第3行與IC第0行匹配
GA第4行與IC第0行匹配
GA第5行與IC第0行匹配
GA第6行與IC第0行匹配
GA第7行與IC第0行匹配
GA第8行與IC第0行匹配
GA第9行與IC第0行匹配

ga.csv內容:

sdfsk,網站域名,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,bmyxiao.com;,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,xpjoyu.com;,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,bwp.com;,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,cscai.com;,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,jodu.com;,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,csd168.com;,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf
sdfsk,hnpx.com;,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf,skdf

ic.csv內容:

序號,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,網站域名
1,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,yazu.com;
2,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,benyz.com;benkz.com;
3,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,tahucy.cn;taochy.com;
4,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,zgtzs.com;
5,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,csjt.com;
6,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,hoa.cc;
7,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,cslzc.com;
8,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,dykm.com;sxdw.com;
9,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,bmyxiao.com;
10,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,xpjoyu.com;
,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,
11,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,bwp.com;
12,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,cscai.com;
,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,
13,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,jodu.com;
14,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,csd168.com;
15,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,hnpx.com;
16,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,stkj.com;
17,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,hnpjx.com;
18,skdlsldjfl,skdfjavsdk,sfadfrt,dsflskdjf,zhanjy.com;
回答
編輯回答
孤客

因為file只打開了一次
你要把file seek到開頭從頭找吧
還有,你的ga_str是空字符串,在你的業(yè)務里算不算匹配?

2017年7月14日 22:37