使用pandas合并两个csv文件 [英] Combining two csv files using pandas

问题描述

任何人都可以帮我检查我的代码有什么问题. 我希望将两个csv文件合并为一个csv文件.

Can anyone check for me what's wrong with my code. I want it merge two csv file into one csv file.

我曾经尝试过使用google，但仍然无法合并，它将创建新文件，但内部将不显示任何内容.

a.csv

ID    User
A1    Fi
A2    Ki

b.csv

ID    User
A4    Fsdi
A5    Kisd

我想要的输出将如下所示

The output that I want will look like this

combined.csv

ID    User
A1    Fi
A2    Ki
A4    Fsdi
A5    Kisd

test.py

import pandas, sys
import pandas as pd


a = pd.read_csv("C:/JIRA Excel File/a.csv")
b = pd.read_csv("C:/JIRA Excel File/b.csv")

merged = a.merge(b, on='ID')

merged.to_csv('C:/JIRA Excel File/result.csv', index=False)

推荐答案

使用df.append:

out = df1.append(df2)
print(out)

   ID  User
0  A1    Fi
1  A2    Ki
0  A4  Fsdi
1  A5  Kisd

with open('C:/JIRA Excel File/result.csv', 'w', encoding='utf-8') as f:
    out.to_csv(f, index=False)

这篇关于使用pandas合并两个csv文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！