Hannah Huston, Emily Manfred, Elizabeth Rhee, Manuela Roca, Mariam Jafri
This video goes through the process our team went through to load and concatenate multiple CSV's into a single dataframe and to extract data insights from.
This graph which shows the tract to msamd income by year which is averaged. So, this shows that consistently, there is a discrepancy between African American and White residents and their average income. This creates problems when it comes to applying for loans based on income status.
This graph shows that while there was a higher loan origination rate for White residents, the loan application being denied was still higher for African American residents. This is a key insight to further study and could be connected to the income graph above.
The above 2 paragraphs show interesting insights for gender. For example we can see that females have a slightly higher count of application being denied.
It is interesting to see at which points different genders had higher counts of loan applications throughout the years. Some interesting switches were from 2013, 2015, and 2016.
The main goal for this semester was to help the Civil Rights Heritage Center create visualizations that they could upload in their webpage to help visualize trends that are occurring here in South Bend with respect to the different committees. As we started working on this goal we realized it wasn’t realistic given the lack of information available to us and the extent of the project so we simplified it to focus only on the housing committee, we divided our work into two main goals.
Effective communication is a must. Everyone always attended meetings and contributed in some way, but if they were not able, they let everyone on the team know, which was important so teammates were aware if they needed to help out or know that something would get done. Initially we had trouble finding the data we needed to be able to make our visualizations specially since we were trying to find information for all of the committees. Therefore, we were forced to make our main goal more obtainable and we decided to focus only on housing..
The next steps for the project include expanding the creation of visualizations to other committees. To do this, first we will need to collect information and find databases. After that the group will be able to start constructing new visualizations.