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.