Use SQL query in a jupyter notebook!
The table I used can be found on UN Data. Or you can just click the link and download the file
A very useful instruction provided by Jon Thirkield of creating a database in Postgres can be found here.
The code includes:
- connect to the database
- simple SQL query
- aggregate query
- join two tables
- join with aggregates
- filter by conditions
- build a basic timeseries