python将多个csv合并为一个_python 使用pandas包实现将多个csv合并到一个csv里面

内容说明

合并表格要用到pandas包，因此一定用记得安装

pd.read_csv()读我们路径下csv

pd.concat()把我们的result_table列表合并起来

result_data.to_csv()把合并的数据再保存到指定csv文件中import os

import pandas as pd

import time

start_time = time.time()

result_table = []

for file in os.walk("E:/excel"):

print(file)

for table in file[2]:

path = file[0] + "/" +table

data = pd.read_csv(path, header = 0, encoding = "utf-8", engine = "python")

#print(data)

result_table.append(data)

print("当前执行表格:", table)

result_data = pd.concat(result_table)

result_data.to_csv("E:/result_data.csv", encoding = "utf_8_sig" ,index = 0)

end_time = time.time()

use_time = start_time - end_time

use_time = round(use_time, 2)

print("用时" + str(use_time) + "秒,表格已合并")

运行结果图片：