擅长:python、mysql、java
<p>这可以使用标准库中的<a href="https://docs.python.org/3/library/csv.html" rel="nofollow noreferrer">csv</a>模块完成</p>
<p>首先,使用字典理解将每个文件读入字典(可以使用<a href="https://docs.python.org/3/library/stdtypes.html#str.lstrip" rel="nofollow noreferrer">str.lstrip</a>方法删除前导零)</p>
<p>接下来,利用dictionary键视图支持<a href="https://docs.python.org/3/library/stdtypes.html#frozenset.intersection" rel="nofollow noreferrer">intersection</a>等集合操作这一事实来查找公共键</p>
<p>最后,将公共密钥和关联值写入新的csv文件</p>
<pre class="lang-py prettyprint-override"><code>import csv
with open('csv1.csv', newline='') as f:
reader = csv.reader(f)
data1 = {col1.lstrip('0'): col2 for col1, col2 in reader}
with open('csv2.csv', newline='') as f:
reader = csv.reader(f)
data2 = {col1: col2 for col1, col2 in reader}
common_keys = data1.keys() & data2.keys()
with open('merge.csv', 'w', newline='') as f:
writer = csv.writer(f)
for key in common_keys:
writer.writerow([key, data1[key], data2[key]])
</code></pre>