Mounting Google Drive Locally
```
from google.colab import drive
drive.mount('/content/drive')

with open('/content/drive/My Drive/foo.txt', 'w') as f:
  f.write('Hello Google Drive!')
!cat /content/drive/My\ Drive/foo.txt

drive.flush_and_unmount()
```
This allows the user to read, write, and move files in Google Drive.

University of Michigan - Ann Arbor

Google Colab allows for easy access to data within the Google suite. 

- Local files
- Google Drive
- Google Sheets

Working with External Data within Colab

https://research.google.com/colaboratory/faq.html#resource-limits

Google Colab FAQ

Uploading files from local system
```
from google.colab import files

uploaded = files.upload()

for fn in uploaded.keys():
  print('User uploaded file "{name}" with length {length} bytes'.format(
      name=fn, length=len(uploaded[fn])))
```
```files.upload()``` returns a dictionary of the files that were uploaded. Upon running this code snippet, the user can select a file to upload.

Downloading files from local system
```
from google.colab import files

with open('example.txt', 'w') as f:
  f.write('some content')

files.download('example.txt')
```
```files.download()``` will invoke a browser download of the file to the local computer.

Local file system

Google Drive

The open-source gspread library allows the user to interact with Google sheets.

```
from google.colab import auth
auth.authenticate_user()

import gspread
from oauth2client.client import GoogleCredentials

gc = gspread.authorize(GoogleCredentials.get_application_default())
```
This imports the library and creates the interface to Sheets.

To create and update a new sheet, use: 
```
sh = gc.create('My cool spreadsheet')
worksheet = gc.open('My cool spreadsheet').sheet1
worksheet.update_cells(cell_list)
```


Learn Before

Related