text: #!/usr/bin/env python3
  # -*- coding: utf-8 -*-
  """
  Created on Tue Aug 11 22:19:36 2020
  
  @author: arti
  """
  
  import pandas as pd
  
  pd.set_option('display.max_columns', 10)
  pd.set_option('display.max_colwidth', 20)
  pd.set_option('display.unicode.east_asian_width', True)
  
  df1 = pd.read_excel('./stock price.xlsx')
  df2 = pd.read_excel('./stock valuation.xlsx')
  
  print(df1.head())
  print('--')
  print(df2.head())
  print('--')
  
  merge_inner = pd.merge(df1, df2)
  print(merge_inner)
  print('--')
  
  merge_outer = pd.merge(df1, df2, how='outer', on='id')
  print(merge_outer)
  print('--')
  
  merge_left = pd.merge(df1, df2, how='left',
                        left_on='stock_name', right_on='name')
  print(merge_left)
  print('--')
  
  merge_right = pd.merge(df1, df2, how='right',
                        left_on='stock_name', right_on='name')
  print(merge_right)
  print('--')
  
  price = df1[df1['price'] < 50000]
  print(price.head())
  print('--')
  
  value = pd.merge(price, df2)
  print(value)
  
  
  
  