Ontario Provincial Election Results Tool

Last Update: October 20th, 2020.

 

1) Project Goal

 
  • Build a user-friendly, visually appealing, and informative dashboard which allows users to look up historical elections trends in their districts.

2) Data Source & Preparation

 

Data Preparation

  • I needed to join 4 geographic .shp (shape) files so that different electoral riding boundaries could be visualized on the map widget.

    • Used Python GeoPandas to analyze the data structure of each file and discovered discrepancies in the number of fields.

    • Identified most relevant fields, dropped others. 

    • Performed ETL to align content and format of common fields in each file and then appended all files together into a single table.

    • Joined the actual election results and the appended shape file so that only one file would be required to import into Tableau. Exported this joined table as a shape file.

  • Imported final shape file into Tableau for visualization.

Data Sources