Instructions

Using the country.sqlite database, please perform the following tasks. The database can be downloaded via the following dropbox link.

You can use either the SQLite GUI used in lecture (DB Browser for SQLite) or the sqlite3 and pandas modules to answer the questions.

Questions

(1) Build a table that calculates the average `ln_gdppc`, `ln_pop`, `infant_mort`, and `polity` score by `continent`-`year`. Order this table in ascending order by average `polity` score. All `float` values should be rounded to the second decimal.

(2) Build a table that calculates the total number of `protests` and `riots` by `country`-`year`. Create a new variable called `popular_unrest` that sums together the total number of `protests` and `riots` by `country`-`year`. Add `regime_type` field to the table.

(3) Aggregate the data from Q2 to answer the following question: which regime type has the most `popular_unrest` events?

The following materials were generated for students enrolled in PPOL564. Please do not distribute without permission.

ed769@georgetown.edu | www.ericdunford.com