Rittenhouse Political stopped by Code for Philly in September 2015 to ask for help with a data set in CSV. Their goal is to outline the difference between male and female political representation in Pennsylvania based on election results between 2000-2014. They would like to visually display the data in tables, graphs, and ultimately a "heat map" to show how women have been represented in PA during those years. We are working in JavaScript to display this data in a palatable manner for end users.
There are two separate maps to display for the heat map. One shows the House of Representatives district lines, while the other shows the Senate District lines. See the links for the map outlines:
http://www.redistricting.state.pa.us/Maps/Congressional.cfm
Senate Map pdf - http://aws.redistricting.state.pa.us/Redistricting/Resources/GISData/Districts/Legislative/Senate/2011-Revised-Final/PDF/FinalSenatePlan2012.pdf
The original csv file is available here on github. We also have some Excel files with further analysis to help get ideas for displaying the data.
- Data processing to ignore , inside quotes while splitting
- Pivot table css for dropdowns
- Legend for bar chart
- Legend for line chart
- Update heat map to use district lines (create two maps - one for House and one for Senate)
- Ayushman Khazanchi
- Candace Worthen
- Matthew Farley
- Tom Ryan
- Waqqas Farooq