Crime_analyser

🕵️ Crime and Murder Data Analyzer - India

A comprehensive Python-based data analysis tool to explore crime and murder statistics in India. It supports both CLI-based interaction and graphical data visualization.

🚀 Features

• Analyze crime trends across Indian states and years (2001–2012).
• Breakdown of crimes by gender and age groups.
• Murder analysis by state, gender, and age.
• Data visualization using matplotlib (line & bar graphs).
• Optional data storage in MySQL.
• Rich CLI experience with rich module.

🧠 Technologies Used

• Python
• Pandas
• Matplotlib
• Rich (for beautiful terminal UI)
• MySQL Connector (can be replaced with SQLite)
• CSV files (crimes.csv, murder.csv)

---

🗂️ Project Structure

├── main.py            # Main script
├── crimes.csv         # Crime dataset (2001–2012)
├── murder.csv         # Murder dataset (2013)
├── README.md          # Project documentation
├── requirements.txt

---

🛠️ Setup Instructions

1. 🔁 Clone the Repository

git clone https://github.com/GAURAV-RAYAT/crime_analyser.git
cd crime_analyser

2. 📦 Install Dependencies

Make sure Python is installed. Run:

pip install -r requirements.txt

If requirements.txt is not present, install manually:

pip install pandas matplotlib rich mysql-connector-python

3. 🏃 Run the Application

python main.py

Follow the interactive menu in the terminal.

---

💾 MySQL Database Option

To store data in MySQL:

• Ensure MySQL is installed and running.
• Choose the “5. Entry Of Data To Database” option in the app.
• Follow prompts to create/connect a database and insert crime or murder data.

💡 Want to use SQLite instead? Update the database logic in main.py to use sqlite3 instead of mysql.connector.

---

👨‍💻 Author

Gaurav Rayat
Portfolio | GitHub