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

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.

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)
```


Google Sheets

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

- Local files
- Google Drive
- Google Sheets

University of Michigan - Ann Arbor

Google Colab is a free, browser-based product from Google Research. It allows users to create, edit, and share Jupyter notebook .ipynb files without any intallation or set up. Colab notebooks allow you to combine executable code and rich text in a single document, along with images, HTML, LaTeX and more. You can easily share your Colab notebooks with co-workers or friends, allowing them to comment on your notebooks or even edit them. 


One of the biggest advantages of Colab is the ability to tap into the power of hardware accelerators such as GPUs and TPUs. You can not choose which accelerator you connect to, but they often include Nvidia K80s, T4s, P4s and P100s. 


While this is pretty impressive for a free product, the resources available fluctuate in accommodation with demand. This means that you can not guarantee the computing power you will have access to each time you use Colab. Those looking for more reliable options will have to look towards paid options, such as Colab pro. 


Colab notebooks are stored in Google Drive and can be shared just like any other Google document. 

Google Colaboratory

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

Google Colab FAQ

Jupyter is the open source project on which Colab is based. Colab allows you to use and share Jupyter notebooks with others without having to download, install, or run anything.

What is the difference Jupyter and Google Colab then?

Working with External Data within Colab

A type of prompt directed at a language model to perform a code completion task. The example, 'Complete the rest of the sequence, making sure that the parentheses are closed properly. Input: [ {', tests the model's ability to understand natural language instructions and apply knowledge of formal syntax, such as that of JSON, to generate a correct continuation.

Learn Before

Related

Learn After