1.合并多个csv文件内容
#----------------导包----------------------
import pandas as pd
import os
"""
inputfile_dir 是多个csv文件的目录路径
outputfile 是合并内容后输出的csv文件
"""
inputfile_dir = ".\input"
outputfile = "all.csv"
for inputfile in os.listdir(inputfile_dir):
print(inputfile)
df = pd.read_csv(inputfile_dir + "\\" + inputfile, encoding="GB18030",header=None)
df.to_csv(outputfile, mode='a', index=False,encoding="GB18030",header=False)
2.pandas 写入标题
data = pd.read_csv('../香港.csv',encoding="GB18030",header=None)
data.columns = ["日期","地區","屋苑","成交價","建築面積","實用面積","建築面積/呎價","實用面積/呎價",
"單位地址","合約形式","上手賺蝕"]
data.to_csv('香港.csv',index=False,encoding="GB18030")
Renaming columns in pandas: https://stackoverflow.com/questions/11346283/renaming-columns-in-pandas