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

Running the code

(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

python src/main.py

Author

• Naysan Saran - Link to my blog

License

This project is licensed under the GPL V3 licence.