{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Antoine Database\n",
"\n",
"The purpose of this notebook is to demonstrate the use of Google Sheets as a data repository for use within a Jupyter notebook."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"### Read Google Sheet"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"import requests\n",
"r = requests.get('https://docs.google.com/spreadsheets/d/1lqIWdnmjiZX2LwHZ_5TdPXDOEn8hp-ZkdONlbjA-P1k/export?format=csv&id')\n",
"data = r.content"
]
},
{
"cell_type": "code",
"execution_count": 42,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
"
\n",
" \n",
" \n",
" | \n",
" Tmin | \n",
" Tmax | \n",
" A | \n",
" B | \n",
" C | \n",
"
\n",
" \n",
" | Species | \n",
" | \n",
" | \n",
" | \n",
" | \n",
" | \n",
"
\n",
" \n",
" \n",
" \n",
" | Acetaldehyde | \n",
" -45 | \n",
" 70 | \n",
" 8.00550 | \n",
" 1600.000 | \n",
" 291.800 | \n",
"
\n",
" \n",
" | Acetic Acid | \n",
" NaN | \n",
" NaN | \n",
" 7.38782 | \n",
" 1533.313 | \n",
" 222.309 | \n",
"
\n",
" \n",
" | Benzene | \n",
" 8 | \n",
" 103 | \n",
" 6.90565 | \n",
" 1211.033 | \n",
" 220.790 | \n",
"
\n",
" \n",
"
\n",
"