Content Deep Dive
The pursuit of happiness with Python and PostgreSQL®
Blog post from Aiven
Post Details
Company
Date Published
Author
Francesco Tisiot
Word Count
2,240
Language
English
Hacker News Points
-
Summary
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.