This analysis focuses on Gun Crime in US. The data is [here][Pandas plotting]
Gun Crime in US |
Data
The data used is [here]
State,Population,Population density,Gun ownership,Murders per 100K,Gun murders per 100K,Firearms murders as % of all murders,"Firearms murders per 100,000 population","Firearms robberies per 100,000 pop","Firearms assaults per 100,000 population" Alaska,710231.00,1.26,61.70,4.40,2.70,55.00,2.24,18.19,80.47 Arizona,6392017.00,57.05,32.30,5.50,3.60,65.00,3.53,50.24,57.36 Arkansas,2915918.00,56.43,57.90,4.50,3.20,72.00,4.39,45.45,100.56 California,37253956.00,244.20,20.10,4.90,3.40,68.00,3.25,42.97,45.39 Colorado,5029196.00,49.33,34.30,2.30,1.30,50.00,1.51,25.74,45.72 Connecticut,3574097.00,741.40,16.60,3.70,2.70,73.00,2.71,34.85,20.06 Delaware,897934.00,470.70,5.20,5.30,4.20,68.00,3.09,69.67,81.36 District of Columbia,601723.00,10298.00,25.90,21.80,16.50,71.00,12.46,242.56,87.70 Georgia,9920000.00,165.00,31.60,5.30,3.80,71.00,3.93,72.48,58.64 Hawaii,1360301.00,216.80,45.10,1.80,0.50,14.00,0.07,0.00,0.00 Idaho,1567582.00,19.50,56.90,1.30,0.80,53.00,1.14,3.41,23.43 Illinois,12830632.00,231.90,26.20,5.50,2.80,83.00,2.93,2.26,5.26 Indiana,6483802.00,182.50,33.80,3.10,2.20,64.00,3.29,53.14,29.91 Iowa,3046355.00,54.81,33.80,1.20,0.70,43.00,0.71,7.31,21.95 Kansas,2853118.00,35.09,32.20,3.50,2.20,66.00,2.78,24.86,76.87 Kentucky,4339367.00,110.00,42.40,4.50,2.70,67.00,2.36,39.77,25.14 Louisiana,4533372.00,105.00,44.50,9.60,7.70,83.00,10.16,63.48,99.51 Maine,1328361.00,43.04,22.60,1.80,0.80,48.00,0.90,5.80,4.52 Maryland,5773552.00,606.20,20.70,7.30,5.10,68.00,4.70,79.71,41.18 Massachusetts,6547629.00,852.10,22.60,3.20,1.80,67.00,2.02,27.84,33.19 Michigan,9883640.00,174.80,28.80,5.60,4.20,73.00,5.06,55.95,86.41 Minnesota,5303925.00,67.14,36.70,1.70,1.00,61.00,0.82,20.11,22.52 Mississippi,2967297.00,63.50,42.80,5.60,4.00,74.00,7.46,60.07,51.69 Missouri,5988927.00,87.26,27.10,7.00,5.40,76.00,4.64,52.47,88.90 Montana,989415.00,6.86,52.30,2.10,1.20,39.00,0.76,3.78,29.03 Nebraska,1826341.00,23.97,19.80,2.80,1.80,65.00,2.50,25.44,33.84 Nevada,2700551.00,24.80,37.50,5.90,3.10,58.00,3.07,69.77,53.30 New Hampshire,1316470.00,147.00,14.40,1.00,0.40,38.00,0.53,9.83,15.14 New Jersey,8791894.00,1189.00,11.30,4.10,2.80,71.00,3.07,49.87,26.94 New Mexico,2059179.00,17.16,49.90,5.70,3.30,50.00,2.98,34.96,87.26 New York,19378102.00,415.30,10.30,4.40,2.70,57.00,4.12,23.28,20.06 North Carolina,9535483.00,200.60,28.70,4.70,3.00,69.00,3.87,48.72,67.44 North Dakota,672591.00,9.92,47.90,1.30,0.60,50.00,0.93,4.79,4.79 Ohio,11536504.00,282.50,19.60,4.00,2.70,70.00,3.54,65.45,37.97 Oklahoma,3751351.00,55.22,31.20,5.00,3.00,64.00,3.64,42.81,58.07 Oregon,3831074.00,40.33,26.60,2.00,0.90,52.00,1.05,14.57,17.55 Pennsylvania,12702379.00,285.30,27.10,5.10,3.60,74.00,3.97,54.69,39.44 Rhode Island,1052567.00,1006.00,5.80,2.80,1.50,36.00,0.57,12.71,17.86 South Carolina,4625364.00,157.10,44.40,6.10,4.50,70.00,5.41,52.93,127.88 South Dakota,814180.00,10.86,35.00,1.70,1.00,33.00,0.68,4.91,20.60 Tennessee,6346105.00,156.60,39.40,5.60,3.50,65.00,3.92,72.88,137.58 Texas,25145561.00,98.07,35.70,5.00,3.20,64.00,2.91,50.21,58.28 Utah,2763885.00,34.30,31.90,1.90,0.80,51.00,0.97,10.98,21.32 Vermont,625741.00,67.73,28.80,1.10,0.30,50.00,0.75,4.32,12.60 Virginia,8001024.00,207.30,29.30,4.60,3.10,69.00,2.58,35.40,21.35 Washington,6724540.00,102.60,27.70,2.20,1.40,49.00,1.25,20.72,28.44 West Virginia,1852994.00,77.06,54.20,3.00,1.50,58.00,2.87,16.08,52.04 Wisconsin,5686986.00,105.20,34.70,2.70,1.70,59.00,1.47,43.86,27.40 Wyoming,563626.00,5.85,53.80,1.40,0.90,73.00,2.01,3.65,20.44
Code
An outline of the code is:
import numpy as np import pandas as pd import sys import statsmodels.api as sm
Outline
Correlations
Command used: ver.corr() ------------------- Population Population density \ Population 1.000000 0.156720 Population density 0.156720 1.000000 Gun ownership -0.304947 -0.627322 Murders per 100K 0.316685 0.135872 Gun murders per 100K 0.298006 0.142674 Firearms murders as % of all murders 0.342894 0.130875 Firearms murders per 100K population 0.241669 0.039569 Firearms robberies per 100K pop 0.299289 0.196958 Firearms assaults per 100K population 0.052625 -0.145447 Gun ownership Murders per 100K \ Population -0.304947 0.316685 Population density -0.627322 0.135872 Gun ownership 1.000000 -0.044996 Murders per 100K -0.044996 1.000000 Gun murders per 100K -0.061059 0.975627 Firearms murders as % of all murders -0.084212 0.669726 Firearms murders per 100K population 0.055085 0.873306 Firearms robberies per 100K pop -0.181681 0.792622 Firearms assaults per 100K population 0.259925 0.677097 Gun murders per 100K \ Population 0.298006 Population density 0.142674 Gun ownership -0.061059 Murders per 100K 0.975627 Gun murders per 100K 1.000000 Firearms murders as % of all murders 0.700888 Firearms murders per 100K population 0.908727 Firearms robberies per 100K pop 0.808776 Firearms assaults per 100K population 0.693818 Firearms murders as % of all murders \ Population 0.342894 Population density 0.130875 Gun ownership -0.084212 Murders per 100K 0.669726 Gun murders per 100K 0.700888 Firearms murders as % of all murders 1.000000 Firearms murders per 100K population 0.729513 Firearms robberies per 100K pop 0.625751 Firearms assaults per 100K population 0.440115 Firearms murders per 100K population \ Population 0.241669 Population density 0.039569 Gun ownership 0.055085 Murders per 100K 0.873306 Gun murders per 100K 0.908727 Firearms murders as % of all murders 0.729513 Firearms murders per 100K population 1.000000 Firearms robberies per 100K pop 0.726269 Firearms assaults per 100K population 0.649112 Firearms robberies per 100K pop \ Population 0.299289 Population density 0.196958 Gun ownership -0.181681 Murders per 100K 0.792622 Gun murders per 100K 0.808776 Firearms murders as % of all murders 0.625751 Firearms murders per 100K population 0.726269 Firearms robberies per 100K pop 1.000000 Firearms assaults per 100K population 0.631109 Firearms assaults per 100K population Population 0.052625 Population density -0.145447 Gun ownership 0.259925 Murders per 100K 0.677097 Gun murders per 100K 0.693818 Firearms murders as % of all murders 0.440115 Firearms murders per 100K population 0.649112 Firearms robberies per 100K pop 0.631109 Firearms assaults per 100K population 1.000000