The 25-Ward Model: A Representation Gap
Last Update: February 9th, 2020.
1) Project Goal
Visualize the past 4 years of election Toronto City Council elections data to determine the impacts (e.g. on representation) of moving to a 25 ward model.
2) Data Source & Preparation
Data is from the Toronto Government's Open Data portal: open.toronto.ca.
Since the data was spread out over multiple Excel files covering multiple years, the files were first checked to determine whether the data structure was consistent for each one.
Then, the Python glob and Pandas libraries were used to go through each file and combine them into a single data source file.
In addition, multiple Ward Boundary spacial files (one for each of the 4 election years analyzed) were combined into one.
Finally, the data was then imported into Tableau for visualization.