Skip to content
Python interface to the Airtable's REST API
Python Jupyter Notebook
Branch: master
Clone or download
Pull request Compare This branch is 3 commits ahead of josephbestjames:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
airtable
notebooks
.DS_Store
.gitignore
.travis.yml
Airtable.py-Doc.md
README.md
requirements.txt
setup.py
test_airtable.py

README.md

Getting started

Airtable Python uses Requests, which you can install by running:

conda install -c anaconda requests -y

Note that you will need to generate an API key for your account if you haven't already. You can do this in your Airtable account settings. It is bad practice to have your API keys hard-coded in your script. Instead, we can export a global variable in our ~/.bash_profile. Copy your API key to the clipboard.

Open your bash profile in your preferred editor and enter the following:

export 'AIRTABLE_API_KEY' = "API_KEY"

replacing "API_KEY" with the string you just copied.

From the command line, run:

source ~/.bash_profile

For when you want to visualise the data

Install required packages

At Kyso, we work a lot with Plotly. For use in JupyterLab, we need to install the jupyterlab and ipywidgets packages:

conda install -c conda-forge jupyterlab-plotly-extension -y

Plotly has a wrapper for pandas (data manipulation library) called Cufflinks, which is currently having compatibility issues with plotly's latest version. A workaround for this at the moment is to downgrade plotly and install cufflinks with the following commands. Once you see how easy it is to generate graphs with Cufflinks, you'll understand why we go through this hassle. The Cufflinks guys have been working on the fix for sometime, but it's yet to emerge.

As of September 2019 this will get you up and running:

conda install -c conda-forge plotly=2.7.0 -y
conda install -c conda-forge cufflinks-py -y
You can’t perform that action at this time.