???♂?The Shadows??: A Crime Story in the City of Angels????
Rakshit Bhadoria
Information technology student | Data Analyst | Power BI | Tableau | Python | RPA Developer | Power Automate | UiPath
Los Angeles, the City of Angels, is renowned for its glitz and glamour, with Hollywood's dazzling lights and palm-lined streets. Yet, beneath the surface, the city grapples with the complexities of crime. In an effort to decipher the patterns within this vast metropolis, the Los Angeles Police Department (LAPD) enlisted the help of data analysis.
?
Our trip into the dark side of Los Angeles starts now that we have a complete set of data. Let's find out what story is hidden in the columns of "crimes.csv."
The 10 crimes that happen most often in Los Angeles
As we look deeper into the information, a group of events that keep happening stand out. The well-known "BATTERY – SIMPLE ASSAULT" is at the top of the list, followed by the sneaky "THEFT OF IDENTITY" and the cunning "BURGLARY FROM VEHICLE." The city will never be the same because of these crimes and their unique scripts.
?
Victim Ages Are Unveiled
Our search for understanding makes us look at the victims. The numbers show a lot of different things. The mysterious age "0" is at the top of the list, which suggests that age is still unknown or missing?in some cases. The ages "30" and "35" are right behind them, giving us a glimpse into the lives of people who have been touched by crime.
Revealing the Age Groups
A picture starts to form as we look more closely at the age groups. The age '0,' which stands for unknown or unreported ages, gets the most attention. Still, among the known ages, the main targets seem to be people between the ages of 26 and 35, with 30 and 35-year-olds taking the most damage. Fewer incidents happen at the extremes of youth and age, showing a more complex story of victimization.
?
Age and Crime Severity: A Dance
The connection between age and crime level is also something we are looking into. The weave is complicated, with different median intensity numbers. This dance of numbers shows the differences in how bad crimes are, which helps police decide how to use their resources.
?
Bringing Gender in the Light
The stage now shifts to gender dynamics. "Male" protagonists dominate the crime victim narrative, outnumbering their "Female" counterparts. Yet, the shadows cast by "X" and "H" genders hint at a diverse narrative, urging a deeper understanding.
Unmasking Gender Disparities
The top 10 crimes in Los Angeles are not evenly split between men and women. More women are victims of crimes like "BATTERY - SIMPLE ASSAULT" and "BURGLARY FROM VEHICLE." More men are victims of crimes like "THEFT OF IDENTITY" and "INTIMATE PARTNER - SIMPLE ASSAULT."
领英推荐
Differentiation and Descent
The story goes on to talk about victim descent, which is as different as Los Angeles itself. Among them, "HISPANIC" is the most important, followed by "WHITE" and "BLACK." These small differences point to deeper problems that need to be looked into more closely.
Learn More: The Top 5 Victim Descent Groups
As our investigation goes deeper, we find the victim descent groups that are most linked to crime. In crimes like "BATTERY - SIMPLE ASSAULT," "H" (Hispanic), "W" (White), and "B" (Black) play the lead roles. Each one has its own plot. These trends call for more research so that a more targeted response can be made.
A History of Crime: Premises and Predilections
The scene changes to a background of crimes. Setting wise, "Single Family Dwelling" stands out as the most important one, followed by the busy "Street" and the safe-looking "Parking Lot." It's clear that we need to improve security after reading these crime records.?
Premises and a History of Crime
As we look at the top three crimes, we see that they are all connected to different types of locations. When it comes to "Single Family Dwelling" and "Street," "BATTERY - SIMPLE ASSAULT" does well, while "THEFT OF IDENTITY" is mostly set in residences. "BURGLARY FROM VEHICLE" shows its drama on the streets, but it also has an effect on the residential areas.
?Crime Timeline
We look into the timeline of crime as the last act plays out. There are ups and downs in the story, with a break in the early morning. The buildup starts in the afternoon and reaches its peak around noon.
Swells and Dips in Crime Time
The most exciting part of our investigation is when the top three crimes happen the most. "BATTERY - SIMPLE ASSAULT" does best in the daytime, while "BURGLARY FROM VEHICLE" does best in the evening. The story of "THEFT OF IDENTITY" starts in the quiet of the morning.
?
?
In the end, our trip through Los Angeles's crime fabric shows a story that is as varied and complicated as the city itself. The data, like pages in a mystery book, gives police hints that they can use to figure out what's going on. It's like a road map for planned actions and raising awareness in the community. As the City of Angels keeps dancing with shadows, one data point at a time, the search for a better tomorrow takes shape.
?
GitHub Link - Los Angeles Crime 2020 - 2023