#
# µû¶óÇÏ¸ç ¹è¿ì´Â ÆÄÀ̽ã°ú µ¥ÀÌÅÍ°úÇÐ(»ý´ÉÃâÆÇ»ç 2020)
# 12.21 µ¥ÀÌÅͺ£À̽º join ¹æ½ÄÀÇ µ¥ÀÌÅÍ º´ÇÕ - merge, 331ÂÊ
#
import pandas as pd
df_1 = pd.DataFrame( {'A' : ['a10', 'a11', 'a12'],
'B' : ['b10', 'b11', 'b12'],
'C' : ['c10', 'c11', 'c12']} , index = ['°¡', '³ª', '´Ù'] )
df_2 = pd.DataFrame( {'B' : ['b23', 'b24', 'b25'],
'C' : ['c23', 'c24', 'c25'],
'D' : ['d23', 'd24', 'd25']} , index = ['´Ù', '¶ó', '¸¶'] )
df_3 = df_1.merge(df_2, how='outer', on='B')
print(df_3)