Nov-16-2020, 01:01 PM
Here is a snippet where I read an excel spreadsheet stored on my google drive, using colab. Adjust as needed.
from google.colab import drive drive.mount('/content/drive') column_names = ['Rank','Interview_Score','Scale','Name','ID','Degree','MedSchool','Zone','Grad','Step1','Step2','Sex','Couples','Couple_Prog','NA','Comment'] df = pd.read_excel(r'/content/drive/My Drive/ia1.xlsx', header=None)