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