第四章: 多表的合并(merge, append的使用)
字段方向上的拓展(更多列) — merge
import pandas as pd
filepath_01 = r"file01.xlsx"
filepath_02 = r"file02.xlsx"
df_table_01 = pd.read_excel(filepath_01)
df_table_02 = pd.read_excel(filepath_02)
need_column = ["x1", "x2", "y1", "y2"]
df_table_merge = pd.merge(left = df_table_01, right = df_table_02,
left_on = ["x3"], right_on = ["y3"],
how = "left",
suffixes = ("_delete", ""))
result = df_table_merge[need_column]
元组方向的拓展(更多行) — append
import pandas as pd
filepath_01 = r"file01.xlsx"
filepath_02 = r"file02.xlsx"
df_table_01 = pd.read_excel(filepath_01)
df_table_02 = pd.read_excel(filepath_02)
df_table_01 = df_table_01.append(df_table_02, ignore_index = True)