Skip to content

This is a exploratory data analysis project of crimes in Chicago 2016 using MySQL and python.

Notifications You must be signed in to change notification settings

rabbiya987/CrimeView360

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

33 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

CrimeView360

CrimeView360 is a comprehensive data analysis platform designed to analyze crime data and provide actionable insights. By leveraging powerful data visualization and database management techniques, this project aims to support public safety, research, and policy-making.


Project Overview

CrimeView360 focuses on analyzing crime-related data from Chicago in 2016, enabling users to:

  • Identify crime patterns and hotspots.
  • Visualize trends over time.
  • Facilitate informed decision-making for law enforcement, researchers, and policymakers.

Features

  • Data Analysis: Exploratory Data Analysis (EDA) using Python libraries like Pandas, Matplotlib, sqlalchemy, and Seaborn.
  • Interactive Visualizations: Dashboards with Plotly and streamlit for dynamic crime data exploration.
  • Database Management: Structured and normalized crime data in MySQL for efficient querying.
  • Crime Hotspot Identification: Pinpoints high-crime areas for targeted interventions.
  • Trend Tracking: Monitors changes in crime rates and patterns over time.

Data Source

  • Dataset: Crime data from Chicago (2016) sourced from Kaggle.
  • Data Attributes: Includes crime type, location, date, time, FBI codes, arrest status, and community area etc.

Objectives

  1. To develop a comprehensive system that effectively organizes and visualizes crime data for better understanding.​
  2. To leverage data analysis techniques to identify crime patterns and trends in Chicago.​
  3. To contribute to public safety by enabling the development of informed and actionable crime reduction strategies.​
  4. To utilize advanced visualization tools for presenting crime trends in a clear and impactful manner.​

Key Queries Addressed

  • What are the most frequent crime categories?
  • Which locations and times see the highest crime rates?
  • How have crime rates changed over time?
  • What trends can be identified in arrest rates?

Results

CrimeView360 transforms raw data into meaningful visualizations and insights, providing users with:

  • Intuitive crime trend analysis over time.
  • Comprehensive understanding of crime patterns.
  • Tools to explore and monitor crime hotspots.

Conclusion

CrimeView360 is an innovative tool that bridges the gap between complex datasets and actionable insights. It empowers stakeholders to create safer communities by leveraging data-driven strategies. This project highlights the potential of technology and data analysis in addressing societal challenges.

About

This is a exploratory data analysis project of crimes in Chicago 2016 using MySQL and python.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Contributors 4

  •  
  •  
  •  
  •  

Languages