# -*- coding: utf-8 -*-
"""
Created on Mon May 17 14:55:12 2021

@author: Sim
"""

import pandas as pd

df1 = pd.DataFrame({'name': ['김철수', '이수진', '박영호', '남상희', '이재호'],
                   'grade': [1, 1, 3, 4, 2]})
df2 = pd.DataFrame({'name': ['이수진', '김철수', '박귀남'],
                    'gender': ['여', '남', '여']})

mydf1 = df1.join(df2, lsuffix='_df1', rsuffix='_df2' )
print('mydf1:\n', mydf1)

mydf2 = df1.join(df2.set_index('name'), on='name') 
print('mydf2:\n', mydf2)

mydf3 = df1.join(df2.set_index('name'), on='name', how='outer', sort=True).reset_index(drop=True)
print('mydf3:\n', mydf3)

mydf4 = df1.join(df2.set_index('name'), on='name', how='inner') 
print('mydf4:\n', mydf4)


'''
##############################################################

import pandas as pd

df1 = pd.DataFrame([[1, 2], [3, 4]], columns=list('AB'))
df2 = pd.DataFrame([[5, 6], [7, 8]], columns=list('AB'))

mydf1 = df1.append(df2)
print('mydf1:\n', mydf1)

df1 = pd.DataFrame([[1, 2], [3, 4]], columns=list('BA'))
mydf2 = df1.append(df2, ignore_index=True) 
print('mydf2:\n', mydf2)

mydf3 = df1.append(df2, ignore_index=True, sort=True) 
print('mydf3:\n', mydf3)

mydf4 = df1.append(df2, sort=True) 
print('mydf4:\n', mydf4)
'''