Crime Demographic Trends in Chicago
→
Summary
To uncover patterns and correlations in violent crime, informing more targeted violence reduction strategies by analyzing how offender age and race relate to domestic violence incidents, victimization rates, and crime severity. The crime-demographic-trends-chicago project used Python for data cleaning, visualization, and correlation analysis; R for statistical testing and additional visualizations; and SQL (with AWS RDS and MySQL) for database management, aggregation, and querying. Additionally, AWS Glue DataBrew was leveraged for data exploration and profiling, while AWS RDS provided scalable cloud database storage. This multi-tool approach enabled comprehensive data handling, from raw data collection to advanced statistical and visual analysis, supporting evidence-based insights into violent crime trends by offender demographics.