python - 如何使用python将两个数据csv合并到一个文件中

Question

这个问题已经有答案了:

Pandas Merging 101 (8 个回答)

已关闭 3 年前。

我有两个数据 csv

第一个:

v1,v2,v3,....v100
-0.6662942866484324,-1.0799718232204516,1.843649258216222,....1.0950462520122528
0.7452152929104426,-0.6032845087431591,0.7041161138126079,....-0.41362931908053513

第二个:

c1,c2,c3,c4,c5
4,1,0,0,1
14,2,2,0,13

当我使用我的代码组合时，结果如下:

v1,v2,v3..v100,c1,c2,c3,c4,c5
0.0,1.0,2,...0,0,0,1,0,0

我的代码是这样的..

import pandas as pd
vector = pd.read_csv('../data/vector_data.csv',encoding = "ISO-8859-1")
cluster= pd.read_csv('../data/data_cluster.csv',encoding = "ISO-8859-1")
data=vector.merge(cluster, left_on='v1', right_on='c1')
export_csv = data.to_csv (r'../data/merge_label.csv',index=False)

结果应该是这样的

v1,v2,v3..v100,c1,c2,c3,c4,c5
-0.6662942866484324,-1.0799718232204516,1.843649258216222,....1.0950462520122528,4,1,0,0,1

请帮助我...

Answer 1

不需要 Pandas

with open('third.csv', 'w') as fh:
    for f, s in zip(*map(open, ['first.csv', 'second.csv'])):
        fh.write(f.rstrip('\n') + ',' + s)