import pandas as pd
import os
path = input('请输入文件夹路径: ')
files = os.listdir(path)
csv_list = []
for f in files:
if os.path.splitext(f)[1] == '.csv':
csv_list.append(path + '\\' + f)
else:
pass
df = pd.read_csv(csv_list[0], low_memory=False)
for i in range(1, len(csv_list)):
df_i = pd.read_csv(csv_list[i], low_memory=False)
pieces = [df[:], df_i[:]]
df = pd.concat(pieces).drop_duplicates()
df = df.iloc[:, [1, 6, 7]] #想保留的列的编号。0为起点
df.to_csv(path +'\\csv_merge.csv', index=None, encoding='gbk')
利用Python批量合并csv
最新推荐文章于 2024-05-15 13:58:42 发布