9. MSE 3114 Data Files#

9.2. Direct read code#

The data can also be downloaded directly into your notebook using the file url in place of the file path in our read statements. Examples for different types of files are shown below.

Remember to make sure that you have run: import pandas as pd also these files must be shared on google drive.

  • Excel file:
    pd.read_excel("https://drive.google.com/uc?id=14uBqZM8ekl1RoFgx3nwCJM7fe9N144RI")

  • CSV file:
    pd.read_csv("https://drive.google.com/uc?id=1ELCvnr0WjQcglNlmxhqzsAOK8DnPaHW_)

  • Compressed (ZIP) CSV file:
    pd.read_csv("https://drive.google.com/uc?id=1uBJd4eIZgYL38YyG4AZsbpGvBuH9KCsQ",compression='zip')

  • Google Sheet e.g. google form data responses: pd.read_csv(https://docs.google.com/spreadsheets/d/13PLZ2N8txdPGn9P19VINPAMDup7ExLsh_Dso9_qLw0c/export?format=csv)