合并数据 – 基于Python Pandas
Inner Join
-
基本形式:
able = left_table.merge(right_table, on = ‘common_key’, how = ‘inner’)
table = pd.merger(left_table, right_table, left_on = ‘left_key’, right_on = ‘right_key’, how = ‘inner’) -
参数:
- left/right_table: DataFrame or named Series
merge来自pd.DataFrame.merge, 所以该函数下引用的数据应为Dataframe或Series
- on / left_on / right_on:
这个参数是用来指明合并的依据,如果两表中,key的列明一样,那只写on就可以,如果名称不一致,则使用left_on/right_on, 分别指明key所在列的名称
- how: {‘left’, ‘right’, ‘outer’, ‘inner’, ‘cross’}, default ‘inner’
内连接中不需要指明how, 默认是inner
- suffixes: list-like, default is (“_x”, “_y”)