# left์ ์กด์ฌํ๋ Key๊ฐ ์๋ ๋ฐ์ดํฐ๋ง merge
df_merge_how_left = pd.merge(df_left, df_right, how='left', on='KEY')
# right์ ์กด์ฌํ๋ Key๊ฐ ์๋ ๋ฐ์ดํฐ๋ง merge
df_merge_how_right = pd.merge(df_left, df_right, how='right', on='KEY')
# left ๋ฐ right ์์ชฝ์ ์กด์ฌํ๋ Key๊ฐ ์๋ ๋ฐ์ดํฐ๋ง merge
df_merge_how_inner = pd.merge(df_left, df_right, how='inner', on='KEY')
# ์์ชฝ์ ์กด์ฌํ๋ ๋ชจ๋ Key๊ธฐ์ค merge
df_merge_how_outer = pd.merge(df_left, df_right, how='outer', on='KEY')
# ๊ฐ ๋ฐ์ดํฐ๊ฐ left, right ๋๋ ์์ชฝ์ ์ถ์ฒ์ธ์ง ํ์(_merge๋ ์ปฌ๋ผ์ ํ์)
pd.merge(df_left, df_right, how='outer', on='KEY', indicator=True)
#์์ชฝ์ ์ปฌ๋ผ๋ช
์ด ์ค๋ณต๋ ๋ _left๋ _right๋ฅผ ์ปฌ๋ผ๋ช
์ ์ถ๊ฐํจ
pd.merge(df_left_2, df_right_2, how='inner', on='KEY', suffixes=('_left', '_right'))
Dataframe Join
2019. 11. 4. 16:10