将多个csv数据合并,需要所有csv的格式一样,列数一致
我的数据存在时间列,所以解析为时间
import pandas as pd
import numpy as np
import os
folder_path = 'F:/202405_6/'
file_list = os.listdir(folder_path)
all_data = []
i=0
for file_name in file_list:
if file_name.endswith("csv"):
file_path = os.path.join(folder_path,file_name)
df = pd.read_csv(file_path, index_col=None, encoding='gbk', parse_dates=['time'])
all_data.append(df)
i += 1
print(i)
data = pd.concat(all_data)
data.to_csv('F:/6.csv',index = True)