The dataset, provided by the City and County of Denver, records crimes from the previous five calendar years and until the current calendar date. The data was obtained on December 1, 2016 making the dataset cover five years and 11 months time. It is updated five days a week (Monday to Friday), which provides a bit of a hurdle in terms of this project being up to date, although for the purposes of this project there really isn’t a huge difference between data from one week ago compared to data today; most of the queries and visual representations should stay fairly accurate, at least proportionally.
Install and Requirements
The application, written in Python and utilizing Tkinter and Matplotlib, displays a variety of graphs based on SQL queries of the data; the graphs range from entry-dependent to pre-made for especially interesting queries
All Python dependencies can be installed with pip:
pip install matplotlib pg8000 tkinter