So I uploaded a csv from my local drive and set up the map, but I would like to update a column of data every day and re-upload the csv, but keep map settings.
The dataset is very simple: one column for country names and one with values. Only the values change every day, not the country names
You have two different approaches here:
- Using Sync tables with your local file being synchronized from a Dropbox/GDrive folder. Countries will be automatically georeferenced each time.
- Using an automatic script in your end that updates your table with the new information via the SQL API: http://docs.cartodb.com/cartodb-platform/sql-api.html
You can sync your data with Google Drive or Dropbox. Here is a tutorial about it.
For doing that, you need a John Snow account (at least).