-
Notifications
You must be signed in to change notification settings - Fork 0
/
Chicago_Crime_EDA_Analysis.Rmd
95 lines (70 loc) · 2 KB
/
Chicago_Crime_EDA_Analysis.Rmd
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
---
title: "Exploratory Data Analysis of Chicago Crime Data"
output: html_document
---
## Introduction
This document presents an exploratory data analysis (EDA) of a subset of Chicago's crime dataset.
## Setup
```{r setup, include=FALSE}
library(tidyverse)
library(lubridate)
library(ggplot2)
library(sf)
```
## Data Loading
```{r load-data}
# Convert 'Date' to datetime for easier manipulation
crimes$Date <- as.Date(crimes$Date, format="%m/%d/%Y %H:%M:%S")
```
## 1. Yearly Trends with Plot
```{r yearly-trends-plot}
# Yearly Trends
yearly_trends <- crimes %>%
mutate(Year = year(Date)) %>%
count(Year) %>%
arrange(Year)
# Plotting
ggplot(yearly_trends, aes(x = Year, y = n)) +
geom_line() +
geom_point() +
labs(title = "Yearly Crime Trends in Chicago", x = "Year", y = "Number of Crimes")
```
## 2. Seasonal and Monthly Trends
```{r monthly-trends}
# Monthly Trends
monthly_trends <- crimes %>%
mutate(Month = month(Date)) %>%
count(Month) %>%
arrange(Month)
monthly_trends
```
## 3. Day of the Week Analysis
```{r day-of-week-analysis}
# Day of the Week Analysis
day_of_week_trends <- crimes %>%
mutate(DayOfWeek = wday(Date, label = TRUE)) %>%
count(DayOfWeek) %>%
arrange(DayOfWeek)
day_of_week_trends
```
## 4. Spatial Analysis
```{r spatial-analysis}
# Assuming Latitude and Longitude are available in the dataset
crimes_sf <- st_as_sf(crimes, coords = c("Longitude", "Latitude"), crs = 4326)
# Plot
ggplot(data = crimes_sf) +
geom_sf() +
coord_sf(xlim = c(-87.94011, -87.52414), ylim = c(41.64454, 42.02304)) +
theme_minimal()
```
## 5. Crime Type Analysis
```{r crime-type-analysis}
# Crime Type Analysis
crime_type_analysis <- crimes %>%
group_by(Primary.Type) %>%
summarise(Count = n()) %>%
arrange(desc(Count))
crime_type_analysis
```
## Conclusion
This document provided a detailed exploratory data analysis of the Chicago crimes dataset, including yearly trends, seasonal variations, day of the week patterns, spatial distribution, and crime type frequencies.