The pursuit of happiness with Python and PostgreSQLĀ®
What's this blog post about?
This blog post explores three Python libraries - pandas, ddlgenerator, and psycopg2 - that can be used to clean a dataset and push it to a PostgreSQL database for further analysis. The author demonstrates the process using a happiness dataset from Kaggle, which is cleaned and then stored in a PostgreSQL table. Finally, the data is queried to find out where in the world one should move to have a joyful life.
Company
Aiven
Date published
June 23, 2021
Author(s)
Francesco Tisiot
Word count
2240
Language
English
Hacker News points
None found.