1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 | # # µû¶óÇÏ¸ç ¹è¿ì´Â ÆÄÀ̽ã°ú µ¥ÀÌÅͰúÇÐ(»ý´ÉÃâÆÇ»ç 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' ) ) | cs |