擅长:python、mysql、java
<pre><code>with open('outfile.txt', 'w') as outfile:
with open('file1.txt', 'r') as f1:
with open('file2.txt', 'r') as f2:
for f1line in f1:
for f2line in f2:
## remove new line character at end of each line
f1line = f1line.rstrip()
f2line = f2line.rstrip()
## extract column fields
f1col3 = f1line.split('\t')[2]
f2col1 = f2line.split('\t')[0]
## test if fields are equal
if (f1col3 == f2col1 ):
outfile.write('%s\t%s\n' % (f1line,
f2line.split('\t')[1]))
else:
outfile.write('%s\t\n' % (f1line))
break
</code></pre>
<ul>
<li>此脚本将比较文件1&2的第1行,然后比较文件1&2的第2行、第3行。。。等。。。在</li>
<li>适用于大文件;不应加载内存:)</li>
</ul>