擅长:python、mysql、java
<p>根据您计划如何处理相关的数据行,您可能可以使用Python的内置<a href="https://docs.python.org/2/library/functions.html?highlight=filter#filter" rel="nofollow">^{<cd1>}</a>函数来完成您需要的操作:</p>
<pre><code>import csv
# first get the ids
with open('Smartee.csv', 'rb') as smarteeCSV: # CSV2
ids = set(row['ID'] for row in csv.DictReader(smarteeCSV, delimiter=','))
with open('aeriesEditable.csv', 'rb') as aeriesCSV: # CSV1
relevant = filter(lambda row: if row['ID'] in ids,
csv.DictReader(aeriesCSV, delimiter=','))
# relevant will be a list containing the desired rows from CSV1
</code></pre>
<p>如果您想迭代处理这些行,对于第二部分,您可以在调用<a href="https://docs.python.org/2/library/itertools.html#itertools.ifilter" rel="nofollow">^{<cd3>}</a>函数的结果上使用<code>for</code>循环。在</p>