擅长:python、mysql、java
<p>您还可以尝试使用<a href="https://docs.python.org/3/library/csv.html" rel="nofollow noreferrer">^{<cd1>}</a>库的纯python解决方案:</p>
<pre><code>from csv import reader
from csv import writer
with open('A.csv') as fileA, \
open('B.csv') as fileB, \
open('B_filtered.csv', 'w') as outB:
csv_writer = writer(outB)
readerA = reader(fileA)
readerB = reader(fileB)
# store first two columns of every row in file A
A_map = {(col1, col2) for col1, col2, *_ in readerA}
for col1, col2, *rest in readerB:
# only write to csv if columns exist in map
if (col1, col2) in A_map:
csv_writer.writerow([col1, col2, *rest])
</code></pre>