Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import pandas as pd
- df1=pd.read_excel('Example players 2019.xlsx')
- df2=pd.read_excel('Example players 2018.xlsx')
- header2019 = df1.iloc[0]
- df1 = df1[1:]
- df1.columns = header2019
- header2018 = df2.iloc[0]
- df2 = df2[1:]
- df2.columns = header2018
- print('df1')
- print(df1)
- print('df2')
- print(df2)
- columnLength2019=df1.shape[1]
- columnLength2018=df2.shape[1]
- rowLength2019=df1.shape[0]
- rowLength2018=df2.shape[0]
- for i in range (1, rowLength2019):
- for j in range (1, rowLength2018):
- if df1['Player'] == df2['Player']:
- print(df1['Player'])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement