使用pandas读取成数据框,append到一个新数据框,写入csv即可。
比如读取每个csv中无表头的数据第3行写入一个新csv中:
import pandas as pd
import os
df=pd.DataFrame()
path='test_csv'
for f in os.listdir(path):
d=pd.read_csv(os.path.join(path,f),encoding='utf-8',header=None)
df=df.append(d.iloc[2,:],ignore_index=False)
df.to_csv('test_new.csv',index=False,header=False)
import linecache as lc
import os
import csv
files = os.listdir(dirname)
with open(dirname + "\\newx.csv", 'w', newline ='', encoding ='utf-8') as f:
writ = csv.writer(f)
for i in files:
if os.path.splitext(i)[1] == '.csv':
row = lc.getline(dirname + '\\' + i, 100)
row1 = row.replace("\n", '')
lst = list(map(str, row1.split(",")))
writ.writerow(lst)