by Sheri Rosalia | Oct 15, 2020
Cash for COVID The data pipeline Wrangling the data Over 50 CSV files were merged using a Python programming script to automate the process. Spark was leveraged to speed up processing 5 million loan records and application of random forest machine learning algorithm...
by Sheri Rosalia | Oct 15, 2020
Business types and ethnic background Cash for COVID Visualization Business and ethnicity This chart accesses data from across all loans from the 500k respondents. Health care being the top category for those who self identified as Black was third for Asians and came...
by Sheri Rosalia | Oct 15, 2020
California loans above $150,000 Cash for COVID Visualization California Select the filtering options and zoom levels to explore loans over 150K by bank and location. All project code and notes Fork or clone from the GitHub repository. Load times and viewing...
by Sheri Rosalia | Oct 15, 2020
Where did the Paycheck Protection Program money go? Cash for COVID Visualization Gender, jobs saved and other people features The default on this map is set to select gender “Female” and the business category “Construction”. The primary reason...
by Sheri Rosalia | Oct 15, 2020
Large loans across the United States Cash for COVID Visualization Over 150k, U.S.A. The vast majority of the P.P.P money went to a relatively small percentage of borrowers. Each dot on the map represents one of these loans and the pop up tooltip provides the name,...
