This analysis focuses on Alcohol Profile (Scotland). The data is [here][Pandas plotting]
Alcohol Profile (Scotland) |
Correlation
Command used: ver.corr() ------------------- Alcohol-related hospital stays \ Alcohol-related hospital stays 1.000000 Alcohol-related mortality 0.679360 Weekly drinkers (pupils age 15) 0.135732 Child protection with parental alcohol misuse 0.205224 Child protection with parental alcohol or drug ... 0.148638 Attempted murder & Serious assault 0.694055 Common assault 0.330717 Vandalism 0.548325 Breach of the Peace 0.771119 % people perceiving rowdy behaviour very/fairly... 0.406658 Premise licences in force - On trade -0.089187 Premise licences in force - Off trade 0.098989 Premise licences in force - Total -0.046025 Personal licences in force 0.064915 Alcohol treatment waiting times -0.117069 Alcohol-related mortality \ Alcohol-related hospital stays 0.679360 Alcohol-related mortality 1.000000 Weekly drinkers (pupils age 15) -0.237900 Child protection with parental alcohol misuse -0.021880 Child protection with parental alcohol or drug ... -0.021586 Attempted murder & Serious assault 0.456158 Common assault 0.224459 Vandalism 0.383494 Breach of the Peace 0.553927 % people perceiving rowdy behaviour very/fairly... 0.282451 Premise licences in force - On trade -0.194265 Premise licences in force - Off trade -0.098347 Premise licences in force - Total -0.177258 Personal licences in force -0.135466 Alcohol treatment waiting times -0.030516 Weekly drinkers (pupils age 15) \ Alcohol-related hospital stays 0.135732 Alcohol-related mortality -0.237900 Weekly drinkers (pupils age 15) 1.000000 Child protection with parental alcohol misuse 0.302720 Child protection with parental alcohol or drug ... 0.112314 Attempted murder & Serious assault -0.067495 Common assault -0.339307 Vandalism -0.204055 Breach of the Peace -0.104137 % people perceiving rowdy behaviour very/fairly... -0.172655 Premise licences in force - On trade 0.203091 Premise licences in force - Off trade 0.385495 Premise licences in force - Total 0.255241 Personal licences in force 0.144506 Alcohol treatment waiting times -0.318355 Child protection with parental alcohol misuse \ Alcohol-related hospital stays 0.205224 Alcohol-related mortality -0.021880 Weekly drinkers (pupils age 15) 0.302720 Child protection with parental alcohol misuse 1.000000 Child protection with parental alcohol or drug ... 0.898074 Attempted murder & Serious assault 0.481135 Common assault 0.285124 Vandalism 0.428617 Breach of the Peace 0.307272 % people perceiving rowdy behaviour very/fairly... 0.287948 Premise licences in force - On trade -0.321714 Premise licences in force - Off trade -0.055824 Premise licences in force - Total -0.273116 Personal licences in force -0.189218 Alcohol treatment waiting times -0.248514 Child protection with parental alcohol or drug misuse \ Alcohol-related hospital stays 0.148638 Alcohol-related mortality -0.021586 Weekly drinkers (pupils age 15) 0.112314 Child protection with parental alcohol misuse 0.898074 Child protection with parental alcohol or drug ... 1.000000 Attempted murder & Serious assault 0.364560 Common assault 0.391609 Vandalism 0.326166 Breach of the Peace 0.201132 % people perceiving rowdy behaviour very/fairly... 0.282581 Premise licences in force - On trade -0.147307 Premise licences in force - Off trade -0.020465 Premise licences in force - Total -0.121312 Personal licences in force -0.088035 Alcohol treatment waiting times -0.048965 Attempted murder & Serious assault \ Alcohol-related hospital stays 0.694055 Alcohol-related mortality 0.456158 Weekly drinkers (pupils age 15) -0.067495 Child protection with parental alcohol misuse 0.481135 Child protection with parental alcohol or drug ... 0.364560 Attempted murder & Serious assault 1.000000 Common assault 0.618500 Vandalism 0.847319 Breach of the Peace 0.813907 % people perceiving rowdy behaviour very/fairly... 0.584780 Premise licences in force - On trade -0.411824 Premise licences in force - Off trade -0.322230 Premise licences in force - Total -0.403245 Personal licences in force -0.255298 Alcohol treatment waiting times -0.037091 Common assault Vandalism \ Alcohol-related hospital stays 0.330717 0.548325 Alcohol-related mortality 0.224459 0.383494 Weekly drinkers (pupils age 15) -0.339307 -0.204055 Child protection with parental alcohol misuse 0.285124 0.428617 Child protection with parental alcohol or drug ... 0.391609 0.326166 Attempted murder & Serious assault 0.618500 0.847319 Common assault 1.000000 0.771277 Vandalism 0.771277 1.000000 Breach of the Peace 0.658947 0.823312 % people perceiving rowdy behaviour very/fairly... 0.617965 0.804656 Premise licences in force - On trade -0.175017 -0.365974 Premise licences in force - Off trade -0.171821 -0.290107 Premise licences in force - Total -0.180477 -0.359512 Personal licences in force -0.051437 -0.233196 Alcohol treatment waiting times 0.141936 0.106600 Breach of the Peace \ Alcohol-related hospital stays 0.771119 Alcohol-related mortality 0.553927 Weekly drinkers (pupils age 15) -0.104137 Child protection with parental alcohol misuse 0.307272 Child protection with parental alcohol or drug ... 0.201132 Attempted murder & Serious assault 0.813907 Common assault 0.658947 Vandalism 0.823312 Breach of the Peace 1.000000 % people perceiving rowdy behaviour very/fairly... 0.710851 Premise licences in force - On trade -0.216826 Premise licences in force - Off trade -0.162399 Premise licences in force - Total -0.211249 Personal licences in force -0.127360 Alcohol treatment waiting times -0.011381 % people perceiving rowdy behaviour very/fairly common in their neighbourhood \ Alcohol-related hospital stays 0.406658 Alcohol-related mortality 0.282451 Weekly drinkers (pupils age 15) -0.172655 Child protection with parental alcohol misuse 0.287948 Child protection with parental alcohol or drug ... 0.282581 Attempted murder & Serious assault 0.584780 Common assault 0.617965 Vandalism 0.804656 Breach of the Peace 0.710851 % people perceiving rowdy behaviour very/fairly... 1.000000 Premise licences in force - On trade -0.194575 Premise licences in force - Off trade -0.171027 Premise licences in force - Total -0.195703 Personal licences in force -0.175301 Alcohol treatment waiting times 0.285348 Premise licences in force - On trade \ Alcohol-related hospital stays -0.089187 Alcohol-related mortality -0.194265 Weekly drinkers (pupils age 15) 0.203091 Child protection with parental alcohol misuse -0.321714 Child protection with parental alcohol or drug ... -0.147307 Attempted murder & Serious assault -0.411824 Common assault -0.175017 Vandalism -0.365974 Breach of the Peace -0.216826 % people perceiving rowdy behaviour very/fairly... -0.194575 Premise licences in force - On trade 1.000000 Premise licences in force - Off trade 0.831774 Premise licences in force - Total 0.990304 Personal licences in force 0.827658 Alcohol treatment waiting times 0.078599 Premise licences in force - Off trade \ Alcohol-related hospital stays 0.098989 Alcohol-related mortality -0.098347 Weekly drinkers (pupils age 15) 0.385495 Child protection with parental alcohol misuse -0.055824 Child protection with parental alcohol or drug ... -0.020465 Attempted murder & Serious assault -0.322230 Common assault -0.171821 Vandalism -0.290107 Breach of the Peace -0.162399 % people perceiving rowdy behaviour very/fairly... -0.171027 Premise licences in force - On trade 0.831774 Premise licences in force - Off trade 1.000000 Premise licences in force - Total 0.900810 Personal licences in force 0.856901 Alcohol treatment waiting times -0.011556 Premise licences in force - Total \ Alcohol-related hospital stays -0.046025 Alcohol-related mortality -0.177258 Weekly drinkers (pupils age 15) 0.255241 Child protection with parental alcohol misuse -0.273116 Child protection with parental alcohol or drug ... -0.121312 Attempted murder & Serious assault -0.403245 Common assault -0.180477 Vandalism -0.359512 Breach of the Peace -0.211249 % people perceiving rowdy behaviour very/fairly... -0.195703 Premise licences in force - On trade 0.990304 Premise licences in force - Off trade 0.900810 Premise licences in force - Total 1.000000 Personal licences in force 0.861839 Alcohol treatment waiting times 0.059143 Personal licences in force \ Alcohol-related hospital stays 0.064915 Alcohol-related mortality -0.135466 Weekly drinkers (pupils age 15) 0.144506 Child protection with parental alcohol misuse -0.189218 Child protection with parental alcohol or drug ... -0.088035 Attempted murder & Serious assault -0.255298 Common assault -0.051437 Vandalism -0.233196 Breach of the Peace -0.127360 % people perceiving rowdy behaviour very/fairly... -0.175301 Premise licences in force - On trade 0.827658 Premise licences in force - Off trade 0.856901 Premise licences in force - Total 0.861839 Personal licences in force 1.000000 Alcohol treatment waiting times -0.008346 Alcohol treatment waiting times Alcohol-related hospital stays -0.117069 Alcohol-related mortality -0.030516 Weekly drinkers (pupils age 15) -0.318355 Child protection with parental alcohol misuse -0.248514 Child protection with parental alcohol or drug ... -0.048965 Attempted murder & Serious assault -0.037091 Common assault 0.141936 Vandalism 0.106600 Breach of the Peace -0.011381 % people perceiving rowdy behaviour very/fairly... 0.285348 Premise licences in force - On trade 0.078599 Premise licences in force - Off trade -0.011556 Premise licences in force - Total 0.059143 Personal licences in force -0.008346 Alcohol treatment waiting times 1.000000