Analysis of a large reltional database through various queries and data visualization libraries. The database is called 'Urban Unrest', and hosts contains data from civil unrest events globally throughout history. Made with SQL and Python on a Jupyter Notebook.
Winter 2023
Devised 5 intriguing questions to analyze an extensive relational database, crafting & deploying complex nested queries for each.
Connected to a MySQL server that hosted the database to send query requests & receive the results within a python host.
Visually represented results using Matplotlib and Pygal libraries, allowing each subsequent question to build off any observations.
"Awesome work, very intriguing results!"
Written by
Your #3 Fan
on 12/22/2023 at 1:49 AM