From Pandas Dataframe To SQL Table using Psycopg2
Full functionning example associated to my blog post.
The data for this tutorial is freely available from the World Bank website https://data.worldbank.org/indicator/en.atm.co2e.pc. The version stored in the data/ directory of this repo is a simplified version of that zip file.
Step-by-step Jupyter notebook
See notebooks/CompleteExample.ipynb
(Optional) Setup your Python 3 virtualenv. For step by step instructions on Linux click here.
Install the required libraries using pip.
pip install -r requirements.txt
Run the main program
This project is licensed under the GPL V3 licence.