CSV文件合并方法整理：行合并、列合并

行合并：[A,B]’ 上下形式

【1】python

import pandas as pd
f1=pd.read_csv('11.csv')
f2=pd.read_csv('22.csv')
file=[f1,f2]
train=pd.concat(file)
train.to_csv('train.csv',index=0,sep=',')

【2】python

with open('11.csv','ab') as f:
    f.write(open('22.csv','rb').read())

【3】cmd命令行

将11.csv,22.csv...放置在同一文件夹中
在cmd中进入该文件夹合并为`newname.csv`：

copy *.csv newname.csv

列合并：[A,B] 左右形式

【1】python

import pandas as pd
f1 = pd.read_csv('11.csv')
f2 = pd.read_csv('22.csv')
file = [f1,f2]
train = pd.concat(file,axis=1)
train.to_csv("train.csv", index=0, sep=',')

【2】python

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])