Working with Google Sheets Colab allows you to save your work to Google Drive or even directly to your GitHub repository.
Here's an example of using a FUSE Drive interface to access your Drive files like local files: https://colab.research.google.com/notebook#fileId=1srw_HFWQ2SMgmWIawucXfusGzrj1_U0q
In short:
# Load the Drive helper and mount
from google.colab import drive
drive.mount('/content/drive')
After executing the code above, your Drive files will be present in /content/drive/My Drive
.
I'm guessing you also found the bundled example I/O notebook, which shows how to use Python APIs to access files as well. (This requires a bit less configuration.) https://colab.research.google.com/notebook#fileId=/v2/external/notebooks/io.ipynb&scrollTo=c2W5A2px3doP
To mount your Google drive to Colab:
from google.colab import drive
drive.mount('/content/drive')
and then to cd
to any directory in the Google drive:
import os
os.chdir("drive/My Drive/<your-folder>")
and to list all items in the directory that Colab is working on (to make sure it's the right dir):
!ls
Please follow 3 simple steps in colab notebook to access folder or a file in google drive,
Step :1 Run this snippet
!apt-get install -y -qq software-properties-common python-software-properties module-init-tools
!add-apt-repository -y ppa:alessandro-strada/ppa 2>&1 > /dev/null
!apt-get update -qq 2>&1 > /dev/null
!apt-get -y install -qq google-drive-ocamlfuse fuse
from google.colab import auth
auth.authenticate_user()
from oauth2client.client import GoogleCredentials
creds = GoogleCredentials.get_application_default()
import getpass
!google-drive-ocamlfuse -headless -id={creds.client_id} -secret={creds.client_secret} < /dev/null 2>&1 | grep URL
vcode = getpass.getpass()
!echo {vcode} | google-drive-ocamlfuse -headless -id={creds.client_id} -secret={creds.client_secret}
At this step you will be asked two times to click on a link to allow access to your drive, at each step code will be generated:(eg:4/AACN9EZG2AU0dRsV0BupjAc107ugSvT_pmr4YPElX7VkoWru6mNmqc8).Paste this code and click enter.
Step:2 To create directory
!mkdir -p drive
!google-drive-ocamlfuse drive
Step:3 Access your file
import pandas as pd
trainDf = pd.read_csv("drive/app/Sample/train.csv");//Here is your file
After success run Drive FUSE program, you can access your drive at /content/drive with using command
import os
os.chdir("/content/drive/")
!ls
Yes you can do that.
follow the below steps.
Run the below code and complete the authentication
!apt-get install -y -qq software-properties-common python-software-properties module-init-tools
!add-apt-repository -y ppa:alessandro-strada/ppa 2>&1 > /dev/null
!apt-get update -qq 2>&1 > /dev/null
!apt-get -y install -qq google-drive-ocamlfuse fuse
from google.colab import auth
auth.authenticate_user()
from oauth2client.client import GoogleCredentials
creds = GoogleCredentials.get_application_default()
import getpass
!google-drive-ocamlfuse -headless -id={creds.client_id} -secret={creds.client_secret} < /dev/null 2>&1 | grep URL
vcode = getpass.getpass()
!echo {vcode} | google-drive-ocamlfuse -headless -id={creds.client_id} -secret={creds.client_secret}
**Run the below code **
!mkdir -p drive
!google-drive-ocamlfuse drive
**import file to notebook **
import pandas as pd
pd.read_csv("drive/Colab_Notebooks/4k_without_spcl.csv")
Colab_Notebooks is folder in google drive
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With