Practice # 10 broadcasting

import pandas as pd

df1 = pd.read_excel("E11EXAMPLE.xlsx").set_index("Stock")
df2 = pd.read_excel("E11EXAMPLE.xlsx", sheet_name=1)

df1.mul(df2.iloc[-1, 1:],axis=0).dropna().head(3)

	A	B	C	D	E
KT	31800000.0	25440000.0	6360000.0	0.0	38160000.0
SK	640000000.0	800000000.0	0.0	960000000.0	320000000.0
Samsung	16140000.0	32280000.0	16140000.0	8070000.0	8070000.0

df1.mul(df2.iloc[-1, 1:],axis=0).dropna().to_clipboard()