- Which Atlanta neighborhoods have the highest median home values?
- Which Atlanta neighborhoods have the lowest median home values?
- Is there less crime in neighborhoods with highest median home values?
- Is there more crime in neighborhoods with lowest median home values?
- Is crime increasing or decreasing in neighborhoods with the highest and lowest median home values?
- Crime Data from Atlanta Police Department: https://www.atlantapd.org/i-want-to/crime-data-downloads
- Population Census data from atlantaga.gov: https://www.atlantaga.gov/government/departments/city-planning/office-of-zoning-development/population
- Home Value data collected by webscraping Niche.com: https://github.com/dmilestone/project-one/blob/master/Resources/niche.csv
- Pull each unique neighborhood from Atlanta crime data.
- Webscrape Niche.com for median home value price (or Niche Price) for each Atlanta neighborhood.
- Read population data, niche data, and crime data using pandas.
- Use datetime library to create new column with year from each crime occurrence record.
- Use loc method to issolate crime incidents for each year from 2014-2018.
- Ues count to calculate number of crime incidents for each year by neighborhood.
- Merge crime count by year, niche home value data, and population by neighborhood data into once dataframe.
- Calculate crime incident per capita (per 100,000 people) for each neighborhood by dividing crime count by population and then multiplying by 100,000.
- Drop null values that were created since some neighborhoods (NPUs) were combined in census data.
- Create new column for change in crime per capita by subtracting 2014 counts from 2018 counts.
- Create function to change Niche Price to float for calculation.
- Create scatter plot using matplotlib to show crime incident count vs. median home values.
- Use matplotlib to create line graph of crime trend from 2014 to 2018 for neighborhoods with top 5 median home values.
- Use matplotlib to create line graph of crime trend from 2014 to 2018 for neighborhoods with lowest 5 median home values.
- The 5 Atlanta neighborhoods with highest median home value were: Kingswood, Argonne Forest, Margaret Mitchell, Mt. Paran/Northside, and West Paces Ferry/Northside
- The 5 Atlanta neighborhoods with lowest median home values were: Carey Park, Almond Park, Pittsburgh, Hunter Hills, and Ashview Heights.
- The top 5 neighborhoods saw signifigant less crime incidents per capita (all under 4,000 for each of the 5 years) than the average for all neighborhoods which ranged from 6,000-7,000 incidents per capita over the 5 year period.
- Crime incidents had no correlation to median home value in the lowest 5 neighborhoods as crime rates were found to be above and below the average for all neighborhoods.
- Neighborhoods with the 5 lowest median home values all had downward trends in crime over the five year period, while no consistent upward or downward trends were found among the top five neighborhoods.
This project was published for educational purposes only. Copyright Trilogy Education Services © 2019. All Rights Reserved.