我总是
join在索引上使用:
import pandas as pdleft = pd.Dataframe({'key': ['foo', 'bar'], 'val': [1, 2]}).set_index('key')right = pd.Dataframe({'key': ['foo', 'bar'], 'val': [4, 5]}).set_index('key')left.join(right, lsuffix='_l', rsuffix='_r') val_l val_rkey foo 1 4bar 2 5
通过
merge在以下各列上使用,可以具有相同的功能:
left = pd.Dataframe({'key': ['foo', 'bar'], 'val': [1, 2]})right = pd.Dataframe({'key': ['foo', 'bar'], 'val': [4, 5]})left.merge(right, on=('key'), suffixes=('_l', '_r')) key val_l val_r0 foo 1 41 bar 2 5
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)