A pandas interface for integrating Carto into a data science workflow.
Get table from carto, make changes in pandas, sync updates with carto:
import pandas as pd
import carto
import cartoframes
cdb_auth_client = carto.auth.APIAuthClient(base_url, APIKEY)
df = pd.read_carto(cdb_auth_client, 'tablename')
# do fancy pandas operations (add/drop columns, change values, etc.)
df.sync_carto() # updates carto table with all changes from this session
The following will embed a CARTO map in a Jupyter notebook (interactive or static).
df = pd.read_carto(auth_client, 'tablename')
df.carto_map(interactive=True, stylecol='interesting_col')
Not yet implemented