If you'd like to use the bitdotio python package (https://github.com/bitdotioinc/python-bitdotio) to query the API, you can download an example iPython notebook from the Connect menu to get started quickly.

Otherwise, refer to Connecting with Pandas or Connecting via psycopg2 and the bit.io Python SDK.

Using Deepnote

Deepnote doesn't have Postgres installed, so we use a different package installation:

pip install bitdotio[psycopg2-binary]

Everything else should work as expected.

Using Kaggle

If you want to run the notebook on Kaggle, make sure you enable internet access so the notebook can install the bitdotio package and connect to the database.

This ensures we can use the bitdotio package with the psycopg2-binary dependency instead, which is already installed for any Deepnote notebook environment.

Using JupyterLab

JupyterLab doesn't support outgoing connections to a remote database so you will be unable to obtain a direct connection. All other API methods should work properly though.