python将多表按列合并
时间: 2023-05-11 07:02:06 浏览: 62
可以使用 pandas 库中的 merge() 函数来将多个表按列合并。具体的代码实现可以参考以下示例:
import pandas as pd
# 定义多个表
df1 = pd.DataFrame({'key': ['A', 'B', 'C', 'D'], 'value1': [1, 2, 3, 4]})
df2 = pd.DataFrame({'key': ['B', 'D', 'E', 'F'], 'value2': [5, 6, 7, 8]})
df3 = pd.DataFrame({'key': ['C', 'F', 'G', 'H'], 'value3': [9, 10, 11, 12]})
# 将多个表按列合并
df_merge = pd.merge(df1, df2, on='key', how='outer')
df_merge = pd.merge(df_merge, df3, on='key', how='outer')
# 输出合并后的结果
print(df_merge)
输出结果如下:
key value1 value2 value3
0 A 1.0 NaN NaN
1 B 2.0 5.0 NaN
2 C 3.0 NaN 9.0
3 D 4.0 6.0 NaN
4 E NaN 7.0 NaN
5 F NaN 8.0 10.0
6 G NaN NaN 11.0
7 H NaN NaN 12.0