#!/usr/bin/env python
# coding: utf-8

# ## Upload data to CARTO
# 
# This example illustrates how to upload local data to a CARTO account.
# 
# _Note: You'll need [CARTO Account](https://carto.com/signup) credentials to reproduce this example._

# In[1]:


from cartoframes.auth import set_default_credentials

set_default_credentials('creds.json')


# In[2]:


from cartoframes import read_carto

gdf = read_carto("SELECT * FROM starbucks_brooklyn WHERE revenue > 1200000")
gdf.head()


# In[3]:


from cartoframes import to_carto

to_carto(gdf, 'starbucks_brooklyn_filtered', if_exists='replace')