elena1234

from Excel sheets into Dataframe in Python

May 21st, 2022 (edited)
538
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. '''
  2. """ Q6:
  3. Import the "directors" and "countries" sheets into their own DataFrames, df_directors and df_countries.
  4. """
  5.  
  6. # your code here
  7. df_all_sheets = pd.read_excel('imdb.xlsx', sheet_name = [0, 1, 2])
  8. df_countries =  df_all_sheets[1]
  9. df_directors  = df_all_sheets[2]
  10.  
  11. '''
RAW Paste Data Copied