prep dependencies:

# libraries for the files in google drive
from pydrive.auth import GoogleAuth
from google.colab import drive
from pydrive.drive import GoogleDrive
from google.colab import auth
from oauth2client.client import GoogleCredentials

prep googledrive connection:

import pandas as pd
auth.authenticate_user()
gauth = GoogleAuth()
gauth.credentials = GoogleCredentials.get_application_default()
drive = GoogleDrive(gauth)
#https://drive.google.com/file/d/1lbDi1pPmvrWiL8MQLbaLpMl15HjNbz1j/view?usp=share_link
file_id = '1lbDi1pPmvrWiL8MQLbaLpMl15HjNbz1j' #<-- You add in here the id from you google drive file, you can find it


f = drive.CreateFile({'id': file_id })
f.FetchMetadata(fetch_all=True)
print(f['title'])

output:

read using pandas:

# Download the file to a local disc
f.GetContentFile(f['title'])
df  = pd.read_csv(f['title'])
df.head()

output:

colab notebook:

https://colab.research.google.com/drive/1Kt8YSX_WxaMoE5Aw7vnwstXry-iaVK5R?usp=sharing