import pandas as pd
import numpy as np
df1 = pd.DataFrame({'A':1,'B':2,'人名':'李山'},index=[0])
df2 = pd.DataFrame({'C':3,'D':4,'人名':'王五'},index=[0])
df3 = pd.DataFrame({'A':5,'C':6,'人名':'王五'},index=[0])
df4 = pd.DataFrame({'B':7,'C':8,'人名':'赵六'},index=[0])
dfs = [df1,df2,df3,df4]
# df1.values.flatten().tolist()
#读取每个表,并转化为list,然后append
# final = list()
final = df1.copy()
for df in dfs[1:]:
# final.append(df.values.flatten().tolist())
final = final.append(df,ignore_index=True)
cols = (list(final.columns))
cols.remove('人名')
# pd.DataFrame(final,columns=['from','to','nodes'])
final = final.reindex(['人名']+sorted(cols), axis=1)