Practice #2 Merge with multiple criteria

1. Read an excel file : read_excel()

import pandas as pd
df1 = pd.read_excel("E02EXAMPLE.xlsx", sheet_name=1)
df1 

	Name	Menu	Restaurants
0	Louis	Bibimbob	JongaLunchBox
1	Harvey	Chicken	TingLunchBox
2	G-dragon	Dongaz	TingLunchBox
3	Lola	Bibimbob	TingLunchBox
4	Jorge	Bibimbob	TingLunchBox
5	Piona	Bibimbob	TingLunchBox
6	Mitchy	Chicken	JongaLunchBox
7	Fibio	Chicken	JongaLunchBox
8	Kim	Dongaz	JongaLunchBox
9	Stacy	Dongaz	JongaLunchBox
10	Grace	Chicken	TingLunchBox
11	TL	Chicken	TingLunchBox
12	Sanchez	Chicken	TingLunchBox
13	Zhen	Bibimbob	JongaLunchBox
14	James	Dongaz	JongaLunchBox
15	Coline	Chicken	TingLunchBox
16	Gorila	Chicken	JongaLunchBox
17	Sunny	Dongaz	TingLunchBox
18	Conner	Chicken	TingLunchBox

df2 = pd.read_excel("E02EXAMPLE.xlsx", sheet_name = 2)
df2

	Restaurants	Menu	Price
0	TingLunchBox	Dongaz	5700
1	TingLunchBox	Bibimbob	5200
2	TingLunchBox	Chicken	6300
3	JongaLunchBox	Dongaz	6600
4	JongaLunchBox	Bibimbob	6700
5	JongaLunchBox	Chicken	5600

2. Merging Dataframes : merge()

df3 = df1.merge(df2, how="left")
df3

	Name	Menu	Restaurants	Price
0	Louis	Bibimbob	JongaLunchBox	6700
1	Harvey	Chicken	TingLunchBox	6300
2	G-dragon	Dongaz	TingLunchBox	5700
3	Lola	Bibimbob	TingLunchBox	5200
4	Jorge	Bibimbob	TingLunchBox	5200
5	Piona	Bibimbob	TingLunchBox	5200
6	Mitchy	Chicken	JongaLunchBox	5600
7	Fibio	Chicken	JongaLunchBox	5600
8	Kim	Dongaz	JongaLunchBox	6600
9	Stacy	Dongaz	JongaLunchBox	6600
10	Grace	Chicken	TingLunchBox	6300
11	TL	Chicken	TingLunchBox	6300
12	Sanchez	Chicken	TingLunchBox	6300
13	Zhen	Bibimbob	JongaLunchBox	6700
14	James	Dongaz	JongaLunchBox	6600
15	Coline	Chicken	TingLunchBox	6300
16	Gorila	Chicken	JongaLunchBox	5600
17	Sunny	Dongaz	TingLunchBox	5700
18	Conner	Chicken	TingLunchBox	6300

3. Copy to Cliboard : to_clipboard()

df3.to_clipboard(index=False)

4. Total Code

import pandas as pd

df1 = pd.read_excel("E02EXAMPLE.xlsx", sheet_name=1)
df2 = pd.read_excel("E02EXAMPLE.xlsx", sheet_name=2)

df3 = df1.merge(df2, how = "left")

df3.to_clipboard(index=False)