This project analyzes the last 20 years of real crimes committed in the City of Austin, Texas. The purpose of this project is to explore real data and gain insights using Tableau.
The raw data was downloaded from the Austin government website. The dataset contains more than 2 million rows of crime data.
- Downloaded raw crime data from the Austin government website.
- Used Jupyter Notebook in the Anaconda environment to clean the data.
- Performed data cleaning operations using Python libraries such as pandas and numpy.
- Conducted EDA to understand the data distribution, trends, and patterns.
- Utilized various Python libraries like matplotlib and seaborn for data visualization.
- Filtered the data to focus on the last 5 years (2019 to 2023).
- Selected the 15 most recurrent crimes for detailed analysis.
- Used the Folium library to create interactive maps in Jupyter Notebook to visualize the geographical distribution of crimes.
- Created interactive dashboards using Tableau Desktop to visualize the crime data and derive insights.
- Due to the heaviness of the data, shared an extract of the data on Tableau Public for easy access.
The analysis helped in understanding the crime trends in Austin over the past 5 years, focusing on the most recurrent crimes. The Tableau dashboards provide an interactive way to explore the data and gain meaningful insights.
- Python: Data cleaning, EDA, and mapping
- Jupyter Notebook: Environment for data analysis
- Folium: Library for creating interactive maps
- Tableau Desktop: Data visualization and dashboard creation
- Tableau Public: Platform for deploying dashboards
- Clone the repository:
git clone https://github.com/yourusername/austin-crime-analysis.git - Navigate to the project directory:
cd austin-crime-analysis - Open the Jupyter notebooks in the
notebooksfolder to explore the data cleaning, EDA process, and mapping. - Access the Tableau dashboards in the
dashboardsfolder or via the provided Tableau Public links to visualize the data.
data/: Contains the raw and cleaned data files.notebooks/: Jupyter notebooks for data cleaning, EDA, and mapping.dashboards/: Tableau dashboard files.README.md: Project documentation.new_presentations/: A PDF presentation of the project.
The interactive dashboards are deployed on Tableau Public and can be accessed via the following links:
This project demonstrates the process of data cleaning, analysis, mapping, and visualization using real-world crime data from Austin, Texas. The insights gained from this analysis can help in understanding crime trends and making informed decisions.
For any questions or suggestions, please contact j.ceballos.alvarez@gmail.com.