擅长:python、mysql、java
<p>按你的第一列数据排序。
之后,您就不需要将数据存储在内存中,只需使用如下两个迭代器:</p>
<pre><code>import csv, sys
it1 = (csv.reader(open("df_ns", "r")))
it2 = (csv.reader(open("df_ip", "r")))
# skip the headers
it1.next()
it2.next()
try:
dm1, ns = it1.next() # first row
except StopIteration:
sys.exit(0)
try:
dm2, ip = it2.next()
except StopIteration:
sys.exit(0)
while True:
if dm1 == dm2:
print dm1, ns, ip
if dm1 < dm2:
try:
dm1, ns = it1.next()
except StopIteration:
break
continue
try:
dm2, ip = it2.next()
except StopIteration:
break
</code></pre>