BridgeYear: Visualizing Data through Heatmaps!

Hello, BridgeYear and community. My goal is to create heatmaps and other data visualizations to understand more about how our training programs offered on MorePathways.Org serve the Houston community with an internal audit. I do my work in Python (you may need to download python 3)!
Note: I've also written a blogpost using this material as a marketing piece!
Overtime, I plan to upload instructions for all the data visualizations I do at BridgeYear. So far, I've created

• a heatmap of opportunity youth compared to training program density
• a map of the schools BY serves compared to training programs locations

Making a heatmap of Opportunity Youth in Houston and MorePathways.Org training data:

Look at the map here!

What you need:

• OY Data pulled from American Community Surveys (data cleaning code has specific instructions)
• Training Programs data by Zipcode (I pulled it from Salesforce)
• JSON File with Zipcode shapes (I pulled it from City of Houston GIS Database)
• Pandas, folium, geopandas, and numpy libraries (may need to download if not already on your computer)

Instructions:

• On the Data Cleaning python file, upload your data for OY by Zipcode and Training Programs by Zipcode. Save the cleaned files. Specific instructions in code document.
• On the OY_Trainings_Reproducible, input your cleaned datasets and run the code. Specific instructions in code document.

Data I Used:

• Opportunity Youth, American Community Surveys, 2020. I will note again that the ACS data limits us to those ages 16-19 rather than 16-24.
• Training Programs from MorePathways.Org database on Salesforce
• Houston Geoshape JSON from COH GIS

Coordinates of Schools BY Serves (CTD Fair Locations) and MorePathways.Org training data:

Look at the map here!

What you need:

• Training Programs data by longitude, latitude (pulled from Salesforce, more details in code)
• Schools where BY has hosted a CTD Fair by longitude, latitude (pulled from Salesforce, more details in code)
• Pandas, folium, and geopy libraries (may need to download if not already on your computer)

Instructions:

• On the Reproducible Trainings School Code, upload your CSVs with training programs and schools and run the code cell by cell. Specific instructions in code document.
• This code is the one I used to make the external report (it's basically the same thing except I include industry when you hover over)

Data I Used:

• Training Programs from MorePathways.Org database on Salesforce
• CTD Fair/Labs/Kits Hosts: The Schools We Serve from Salesforce