擅长:python、mysql、java
<p><strong>编辑:</strong>当我的解决方案正常工作时,请查看下面Martijn的答案以获得更有效的解决方案。</p>
<p>您可以找到python CSV模块<a href="http://docs.python.org/library/csv.html" rel="noreferrer">here</a>的文档。</p>
<p>你要找的是这样的东西:</p>
<pre><code>import csv
f1 = file('hosts.csv', 'r')
f2 = file('masterlist.csv', 'r')
f3 = file('results.csv', 'w')
c1 = csv.reader(f1)
c2 = csv.reader(f2)
c3 = csv.writer(f3)
masterlist = list(c2)
for hosts_row in c1:
row = 1
found = False
for master_row in masterlist:
results_row = hosts_row
if hosts_row[3] == master_row[1]:
results_row.append('FOUND in master list (row ' + str(row) + ')')
found = True
break
row = row + 1
if not found:
results_row.append('NOT FOUND in master list')
c3.writerow(results_row)
f1.close()
f2.close()
f3.close()
</code></pre>