功能:将某个目录下的CSV文件合并成一个
import pandas as pd
import os
def merge_csv():
input_path = r'/Users/***/Documents/codes/python/pythonProject/raw4/'
result_path =r'/Users/***/Desktop/临时文件随时可删除/'
result_name= r'merged_result.csv'
os.chdir(input_path)
file_list = os.listdir()
df = pd.read_csv(input_path + file_list[0], encoding="gbk")
df.to_csv(result_path + result_name, encoding="gbk", index=False)
for i in range(1, len(file_list)):
if not file_list[i].startswith("."):
df = pd.read_csv(input_path + file_list[i], encoding="gbk")
df.to_csv(result_path + result_name, encoding="gbk", index=False, header=False, mode='a+')