with open('file1.csv', 'rb') as file_a, open('file2.csv', 'rb') as file_b:
data_a = csv.reader(file_a)
data_b = dict(csv.reader(file_b)) # <-- dict
with open('out.csv', 'wb') as file_out:
csv_out = csv.writer(file_out)
for word, num_a in data_a:
csv_out.writerow([word, num_a, data_b.get(word, '')]) # <-- edit
with open('file1.csv', 'rb') as f1, open('file2.csv', 'rb') as f2:
r1, r2 = csv.reader(f1), csv.reader(f2)
with open('out.csv', 'wb') as fout:
w = csv.writer(fout)
for row1, row2 in zip(r1, r2):
if row1[0] == row2[0]:
w.writerow([row1[0], row1[1], row2[1]])
对于
csv
,我总是访问数据分析库pandas
。http://pandas.pydata.org/使用听写:
(未测试)
我认为您需要的是^{} ,让您在锁步骤中迭代这两个csv:
我不知道如果他们不平等,你想发生什么。或者像这样插入两行?
相关问题 更多 >
编程相关推荐