Advertisement
Guest User

Untitled

a guest
Aug 21st, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.56 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. df1=pd.read_excel('Example players 2019.xlsx')
  4. df2=pd.read_excel('Example players 2018.xlsx')
  5.  
  6. header2019 = df1.iloc[0]
  7. df1 = df1[1:]
  8. df1.columns = header2019
  9. header2018 = df2.iloc[0]
  10. df2 = df2[1:]
  11. df2.columns = header2018
  12.  
  13. print('df1')
  14. print(df1)
  15. print('df2')
  16. print(df2)
  17.  
  18. columnLength2019=df1.shape[1]
  19. columnLength2018=df2.shape[1]
  20.  
  21. rowLength2019=df1.shape[0]
  22. rowLength2018=df2.shape[0]
  23.  
  24. for i in range (1, rowLength2019):
  25. for j in range (1, rowLength2018):
  26. if df1['Player'] == df2['Player']:
  27. print(df1['Player'])
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement