#
# µû¶óÇÏ¸ç ¹è¿ì´Â ÆÄÀ̽ã°ú µ¥ÀÌÅÍ°úÇÐ(»ý´ÉÃâÆÇ»ç 2020)
# LAB 12-5 ´Ù¾çÇÑ ¹æ¹ýÀ¸·Î merge Àû¿ëÇØ º¸±â, 333ÂÊ
#
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 = ['´Ù', '¶ó', '¸¶'] )
print('left outer \n' , df_1.merge(df_2, how='left', on='B' ) )
print('right outer \n' ,df_1.merge(df_2, how='right', on='B' ) )
print('full outer \n' ,df_1.merge(df_2, how='outer', on='B' ) )
print('inner \n' ,df_1.merge(df_2, how='inner', on='B' ) )