行合并:[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])