A petl extension for spatial data
pip install git+https://github.com/CityOfPhiladelphia/geopetl
cd geopetl
pip install -r requirements.txt
Also, make sure you have libraries for the data sources you'll be using. For example:
pip install cx_Oracle cartodb
import petl as etl
import geopetl
(etl.read('oraclesde://user:pass@db', 'gis_streets.bike_stations')
.rename('id', 'station_id')
.convert('num_docks', int)
.write('carto://domain?apikey=api_key')
)