/plushcap/analysis/aiven/the-pursuit-of-happiness-with-python-and-postgresql

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

Hacker News points
None found.

Language
English


By Matt Makai. 2021-2024.