with open('test.csv') as f:
line_values = [line.strip().split(',') for line in f.readlines()]
transposed_values = dict([(v.strip(), k) for k, v in line_values])
with open('test2.csv') as fi:
with open('out.csv', 'w') as fo:
for line in fi.readlines():
B = line.strip()
try:
print >>fo, '{}, {}'.format(B, transposed_values[B])
except KeyError:
print >>fo, '{}, ?'.format(B)
import csv
d = {}
with open('toread.csv') as f:
r = csv.reader(f)
for a, b in r:
d[b] = a
with open('towrite.csv', 'w') as f:
w = csv.writer(f)
for a in As:
w.writerow(a, d[a])
好吧。。。如果您有两个csv文件,而第二个文件有一列B值:
输入文件
test.csv
:输入文件
test2.csv
:输出文件
out.csv
:我不知道您从哪里得到要编写的CSV文件的
A
列,但我们假设这些值按顺序排列在一个As
列表中。然后:相关问题 更多 >
编程相关推荐