Advertisement
elena1234

Excel sheets to Dataframe in Python

May 21st, 2022 (edited)
731
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.34 KB | None | 0 0
  1. df_all_sheets = pd.read_excel('imdb.xlsx', sheet_name = [0, 1, 2])
  2. df_countries =  df_all_sheets[1]
  3. df_directors  = df_all_sheets[2]
  4.  
  5. ###########################################
  6. df = pd.read_excel('maven_ski_shop_data.xlsx', sheet_name = 'ski', index_col = 'name', header = 0, skiprows = 2, parse_dates = ['Order_Date'], usecols= 'A, C:E')
  7.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement