<p>我希望你做得很好,这个逻辑是基本的,但是正如你上面提到的,你是python新手,所以我已经为你的参考做了一些代码,附在下面</p>
<pre><code> import csv
newColumn = ''
genderDict = {}
with open('CSVB.csv') as csv_file:
csv_reader = csv.reader(csv_file, delimiter=',')
line_count = 0
for row in csv_reader:
if line_count == 0:
newColumn = row[1]
line_count = line_count+1
else:
genderDict[row[0]] = row[1]
with open('CSVA.csv') as csv_file:
csv_reader = csv.reader(csv_file, delimiter=',')
line_count = 0
for row in csv_reader:
if line_count == 0:
with open('OUTPUT.csv', mode='w') as employee_file:
output_writer = csv.writer(employee_file, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
row.append(newColumn)
output_writer.writerow(row)
line_count += 1
else:
with open('OUTPUT.csv', mode='a') as employee_file:
output_writer = csv.writer(employee_file, delimiter=',', quotechar='"', quoting=csv.QUOTE_MINIMAL)
row.append(genderDict[row[0]])
output_writer.writerow(row)
line_count += 1
</code></pre>