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 Sources
-
Data is from the Toronto Government's Open Data portal: open.toronto.ca.
Data Preparation
-
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.