Practice #1 Merge

1. Read the excel file : read_excel()

import pandas as pd

df1 = pd.read_excel("E01EXAMPLE.xlsx", sheet_name=1)
df1

	Name	Drink
0	Louis	IcedTea
1	Harvey	Lemonade
2	G-dragon	Americano
3	Lola	Lemonade
4	Jorge	IcedTea
5	Piona	Americano
6	Mitchy	Lemonade
7	Fibio	VanillaLatte
8	Kim	Americano
9	Stacy	IcedTea
10	Grace	EarlGrey
11	TL	YuzaTea
12	Sanchez	VanillaLatte
13	Zhen	JamongTea
14	James	VanillaLatte
15	Coline	VanillaLatte
16	Gorila	Americano
17	Sunny	YuzaTea
18	Conner	Lemonade

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

	Drink	Price
0	Americano	3900
1	VanillaLatte	3900
2	CafeLatte	3900
3	IcedTea	4400
4	EarlGrey	3800
5	YuzaTea	3500
6	Einspanner	3500
7	JamongTea	4100
8	Lemonade	4400
9	OrangeJuice	3600

2. Merge Dataframe : merge()

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

	Name	Drink	Price
0	Louis	IcedTea	4400
1	Harvey	Lemonade	4400
2	G-dragon	Americano	3900
3	Lola	Lemonade	4400
4	Jorge	IcedTea	4400
5	Piona	Americano	3900
6	Mitchy	Lemonade	4400
7	Fibio	VanillaLatte	3900
8	Kim	Americano	3900
9	Stacy	IcedTea	4400
10	Grace	EarlGrey	3800
11	TL	YuzaTea	3500
12	Sanchez	VanillaLatte	3900
13	Zhen	JamongTea	4100
14	James	VanillaLatte	3900
15	Coline	VanillaLatte	3900
16	Gorila	Americano	3900
17	Sunny	YuzaTea	3500
18	Conner	Lemonade	4400

3. Copy to Clipboard : to_clipboard()

df3.to_clipboard(index=False)

4. Total Code

import pandas as pd

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

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

df3.to_clipboard(index=False)