Group 7 Project

Meeting via: Zoom

Meeting Date: 11/29/2020

Attendees

• Ashley Jaiprashad
• Petros Papadakos
• Ksenia Bochkova

Discussion Points

• is ETL completed/any points from ETL
• any issues/changes needed to be made from ETL process
• plan for dashboard programming

Action Items / Decisions Made

• updated blog with our ETL process (transformation, step metrics, sample data)
• set next team deadline for Dashboard programming

Meeting via: Zoom

Meeting Date: 11/14/2020

Attendees

• Ashley Jaiprashad
• Petros Papadakos
• Ksenia Bochkova

Discussion Points

• how is the ETL process going
• any issues we see arising for the remaining steps
• progress towards group deadline

Action Items / Decisions Made

• added steps to our ETL process
• set up next meeting to speak about dashboard programming

Meeting via: Zoom

Meeting Date: 11/04/2020

Attendees

• Ashley Jaiprashad
• Petros Papadakos
• Ksenia Bochkova

Discussion Points

• how can we finalize our DM
• next steps for tackling the ETL
• goals of our project

Action Items / Decisions Made

• made final changes to our DM
• updated our blog page
• delegated ETL process
• set deadlines within our group

Meeting via: Zoom

Meeting Date: 10/24/2020

Attendees

• Ashley Jaiprashad
• Petros Papadakos
• Ksenia Bochkova

Discussion Points

• what topics should we do for this project
• what are some datasets we can use
• which business problem are we aiming to solve

Action Items / Decisions Made

• found the datasets
• we decided on the topic of correlation between weather and crime
• start to work on our model
• start to build our works in the blog

Transformation Screen

Step Metrics

Sample of Table (first columns)

Sample of Table (last columns)

Data Sources

NYPD Arrest Data (Year-to-Date)-https://data.cityofnewyork.us/Public-Safety/NYPD-Arrest-Data-Year-to-Date-/uip8-fykc

2020 Weather Data – https://www.wunderground.com/history/daily/us/ny/new-york-city/date/2020-11

KPIs

• Amount of crimes by month in 2020
• Amount of crimes categorized by temperature
• Most frequent crime types based on temperature
• Most frequent age group of perpetrators
• Most frequent age group of perpetrators based on temperature
• Amount of crimes categorized by precipitation
• Most frequent crime types by perpetrator age

Meet our Group 7 Project Team Members

Bochkova, Ksenia – [email protected]

Jaiprashad, Ashley – [email protected]

Papadakos, Petros – [email protected]

Read our Project Proposal

How Does Different Elements of the Weather Dictate Crimes Being Committed in NYC

NYC is notorious for its unusual crime spikes and fluctuating crime activity. Though there were high crime rates in the 1980s-1990s, NYC has seen very strong crime spikes during 2020. For the month of August 2020, there were 242 shooting incidents across the city compared to the same time period last year when the city saw 91 shooting incidents. This reflects a 166% percent increase in shooting crimes. Though we recognize 2020 has been a very different year and other factors may have been at play here, there is no doubt that weather may play a very important role in crime activity. We aim to investigate a possible correlation between weather and crime. Within our analysis, we hope to gain a better understanding of, but not limited to, the following:

• Does weather affect the types of crimes committed?
• What type of weather has the highest crime rate?
• What types of crime occur in which types of weather?
• What is the frequency of crime type based on temperature?
• Is crime seasonal?