Search code examples
python-3.xgoogle-colaboratory

Where can I find the path of my excel file in colab?


I upload a excel file in the homepage of colab enter image description here

However, when I want to read this file in my code, it always shows " No such file or directory" no matter I change the path of file

df = pd.read_excel('/content/drive/My Drive/thesis_bio/0419_combined_biodyes.xlsx', header=0)

How to find the correct path of my file, I check most directory, but havent found yet... enter image description here


Solution

  • Just connect to google drive from colab if you have not and go to that location where file is present and hover on to that file. You will see 3 dots next to the file, just click on it and you will see an option "copy path", click it and it will be copied to your clipboard.