Python - Google Colab read csv

It is possible to read csv into Google Colab by several ways. For reading csv from online folder basic read w/o permission is enough, but for usage of Google Drive File System, authorisation is needed. E.g.

1. basic csv read - use pandas, os, csv, etc.

2. read csv from Google Drive with Mount Authorisation

1.

# use pandas

import pandas as pd

# use os to work with mac file system

import os

os.getcwd()

os.chdir('/datalab')

# get current work directory by pwd

pwd

'/content'

# get current work directory by pwd

df = pd.read_csv('survey_results_public.csv')

schema_df = pd.read_csv('survey_results_schema.csv')

2.

# Upload csv to google colab and read csv

from google.colab import drive drive.mount('/content/gdrive')

# Click the generated link and go to the URL below

Go to this URL in a browser: https://accounts.google.com/o/oauth2/auth?client_id=947318989803-6bn6qk8qdgf4n4g3pfee6491hc0brc4i.apps.googleusercontent.com&redirect_uri=urn%3aietf%3awg%3aoauth%3a2.0%3aoob&scope=email%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdocs.test%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive.photos.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fpeopleapi.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fdrive.activity.readonly%20https%3a%2f%2fwww.googleapis.com%2fauth%2fexperimentsandconfigs%20https%3a%2f%2fwww.googleapis.com%2fauth%2fphotos.native&response_type=code

Enter your authorization code: xxxxxxxxxxxxxxxxxxx

Mounted at /content/gdrive

# or get current work directory by os

import os

os.getcwd()

os.listdir()

'/content'

['.config',

'survey_results_public.csv',

'gdrive',

'survey_results_schema.csv',

'sample_data']

# Read dataset to data frame

from google.colab import drive

import pandas as pd df=pd.read_csv('gdrive/MyDrive/Dataset_for_Colab/fake_job_postings.csv') df

# Training csv file has been found here: https://www.kaggle.com/shivamb/real-or-fake-fake-jobposting-prediction?select=fake_job_postings.csv

#google colab #read csv