行合并:
即数据以上下形式合并
方法一:
import pandas as pd
f1 = pd.read_csv('1.csv', error_bad_lines=False) # 跳过错误行
f2 = pd.read_csv('2.csv', error_bad_lines=False)
f3 = pd.read_csv('3.csv', error_bad_lines=False)
file = [f1, f2, f3]
test = pd.concat(file)
方法二:
with open('1.csv','ab') as f:
f.write(open('2.csv','rb').read())
列合并:
即数据以左右形式合并
方法一:
import pandas as pd
f1 = pd.read_csv('1.csv')
f2 = pd.read_csv('2.csv')
file = [f1, f2]
test = pd.concat(file,axis=1)
test.to_csv("test.csv", index=0, sep=',')
方法二:
import csv
aFile = open('train_Data.csv', 'r')
aInfo = csv.reader(aFile)
bfile = open('train_label.csv', 'r')
bInfo = csv.reader(bfile)
cfile = open('traindata.csv', 'w', newline='') # 不加newline=''会间隔性出现空行
abcsv = csv.writer(cfile, dialect='excel')
a=[]
b=[]
for info in aInfo:
a.append(info)
for info in bInfo:
b.append(info)
for index in range(len(b)):
a[index].extend(b[index]) # 将b的第i行添加到a的第i行后
abcsv.writerow(a[index])
转载:https://blog.csdn.net/qq_43797817/article/details/105908184