源代码
import pandas as pd
import os
target_dir='C:/Users/Kinglake/Desktop/Downloads/'
print("合并",target_dir,"路径文件:")
for root,dirs,files in os.walk(target_dir):
print("共",len(files),"个")
columns=files
columns=[]+files
for index in range(len(files)):
files[index]=target_dir+files[index]
for index in range(len(files)):
if index==0:
dfs=pd.read_table(files[index],index_col=0,usecols=[0, 1])
else:
df=pd.read_table(files[index],index_col=0,usecols=[0, 1])
dfs=pd.concat([dfs,df],join='outer',ignore_index=True,axis=1)
print('_______表头__________',len(columns),columns)
dfs.columns=columns
dfs.sort_values("出版年",inplace=True,ascending=False)
dfs.to_excel("C:/Users/Kinglake/Desktop/output.xlsx")
print('\n完成!\n')