擅长:python、mysql、java
<p>您可以提取第二个文件中的所有ID,并在每次检查第一个文件的某一行时进行查找。在</p>
<p>例如:</p>
<pre><code># extract ID column from CSV file 2 into a set
Ids = { row[1] for row in smartee }
# pick only rows whose ID is in Ids
filtered_rows = [item for item in aeries if item[1] in Ids]
</code></pre>