Does perpetrator know the victim Predictive data analysis

Does perpetrator know the victim? Predictive data analysis, Gun Violence dataset DS 250 Spring 2018 Johnson Community College Author: Xiaowen Ao

Dataset overview: URL: Click https: //www. kaggle. com/jameslko/gun-violence-data to edit Master text styles Comprehensive record of over 260 k US gun violence incidents from 2013 -2018

Data Exploration: Click to edit Master text styles California and Texas has largest number of gun violence casualties in the country -----We know that already, since long ago.

“Gold Mines” of this dataset: Click to edit Master text styles keys If exacted properly, we will know how many victim/suspect involved in the incident, each individual’s gender, age, etc. values

A True Detective Click to edit Master text styles If we can find whether perpetrator knows the victim, our search range will be drastically reduced.

Feature Engineering Click to edit Master text styles

Feature Engineering Click to edit Master text styles

Explore Dataset with Engineered Features Records with. Master no values participant_relationship were removed, only 15774 rows left. Click to edit textfor styles

Features have high correlations with Target: males+females+suspect+victim+n_killed

Logistic Regression Predictive Model Click to edit Master text styles (608+1899)/(608+189 9+114+534) =79. 46% !!!!!! Baseline: 10065/(10065+570 9) = 63. 81%

Sidekicks Word Cloud of Incident Click to edit Master text Notes styles on Gun Violence between Significant Others The Most Dangerous Address in US: 8 out of the top 10 addresses with largest number of gun violence incidents look like around airport just by their street names. But why are average number of killed 0? I checked the original file, 2375 International Pkwy are TSA actions. Therefore, no gang fight fantasies in airport but people do seem like to sneak in guns via airports a lot, especially in Dallas.

Gun Law VS Number of People Killed in Gun Violence Will strict gun law lead to less in gun violence? Click to edit Master text styles • I aggregated number of people killed by year and state, then merge with firearmdatabase. csv(https: //www. statefirearmlaws. org/table. html). • • Linear regression model has R square over 0. 91 , but it’s not the number of laws that are significant to number of gun violence incidents, it’s the name of states (like CA, FL, TX)has three stars! • States tend to vote for Democratic Party(blue states) have more gun laws than “red states”, but not necessary has less gun violence

Click to • edit Master text styles Images credits: • https: //www. nationofchange. org/2017/10/25/psychology-mass-killers-causes-canprevent/ • http: //metro. co. uk/2016/12/20/matthew-mcconaughey-says-he-would-not-hesitate-for-asecond-before-returning-to-true-detective-6334859/

Click to edit Master text styles The End Thank you! Xiaowen Ao