Import csv files from local directory
pandas tutorial: pandas.read_csv
#Uplocad csv file from your local directoryfrom google.colab import filesuploaded = files.upload()import pandas as pddf = pd.read_csv('FILENAME.csv')#The filename of the uplpaded csv file#df.shapedf.head()
#Uplocad Excel file from your local directoryfrom google.colab import filesuploaded = files.upload()import pandas as pddf = pd.read_excel('FILENAME.xlsx')#The filename of the uplpaded csv file#df.shapedf.head()
Import data from URL
#Example: NYT Github COVID-19 data#https://raw.githubusercontent.com/nytimes/covid-19-data/master/live/us-counties.csvurl ='The URL of data'df = pd.read_csv(url)#df.shapedf.head()
Google Drive Import
Read data by Google Sheets Name
#gspread setup!pip install --upgrade gspread#Authenticate access to your Google Drivefrom google.colab import authauth.authenticate_user()import gspreadfrom oauth2client.client import GoogleCredentialsgc = gspread.authorize(GoogleCredentials.get_application_default())import pandas as pdworksheet = gc.open('Google Sheets NAME').sheet1 rows = worksheet.get_all_values()# get_all_values gives a list of rows.df = pd.DataFrame.from_records(rows)# Convert to a DataFrame and render.df.head()
Read data by Google Sheets ID
#gspread setup!pip install --upgrade gspread#Authenticate access to your Google Drivefrom google.colab import authauth.authenticate_user()import gspreadfrom oauth2client.client import GoogleCredentialsgc = gspread.authorize(GoogleCredentials.get_application_default())worksheet = gc.open_by_key('Google Sheets ID').worksheet('NAME OF A SHEET TAB')#Call by Sheet ID & Namerows = worksheet.get_all_values()# get_all_values gives a list of rows.df = pd.DataFrame.from_records(rows[1:], columns=rows[0])# Convert to a DataFrame and render. 1st Row as Headersdf.head()
Read CSV file from Google Drive - by sharing link
!pip install -U -q PyDrive from pydrive.auth import GoogleAuth from pydrive.drive import GoogleDrive from google.colab import auth from oauth2client.client import GoogleCredentials # Authenticate and create the PyDrive client. auth.authenticate_user()gauth =GoogleAuth()gauth.credentials = GoogleCredentials.get_application_default()drive =GoogleDrive(gauth)#Copy and paste Google Authentication codelink ='SHARING LINK'#The sharing link of the data file stored on your Google Driveid= link.split("/")[-2]#print(id)downloaded = drive.CreateFile({'id':id})downloaded.GetContentFile('covid_county.csv')df = pd.read_csv('covid_county.csv')df.head()
Read CSV file from Google Drive - by mounting Google Drive
#Mount Google Drivefrom google.colab import drivedrive.mount('/content/drive')path ='/content/drive/PATH TO THE FILE'df = pd.read_csv(path)df.head()