Python 合并多个csv文件内容；pandas.DataFrame.columns写入标题

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