Question
i need a python code for this question please as soon as possible! Find the percentage of the Annual crime happened in each of the
i need a python code for this question please as soon as possible!
Find the percentage of the Annual crime happened in each of the four Quarters when aggregated at Agency type level.
[{"State":"Alabama", "Agency_type":"Cities", "Agency_name":"Florence", "quarter_1":0, "quarter_2":1, "quarter_3":0, "quarter_4":1, "Population":39481}, {"State":"Alabama", "Agency_type":"Cities", "Agency_name":"Hoover", "quarter_1":0, "quarter_2":1, "quarter_3":0, "quarter_4":0, "Population":84139}, {"State":"Alabama", "Agency_type":"Cities", "Agency_name":"Prattville", "quarter_1":1, "quarter_2":0, "quarter_3":1, "quarter_4":0, "Population":35154}, {"State":"Alabama", "Agency_type":"Cities", "Agency_name":"Tuscaloosa", "quarter_1":0, "quarter_2":0, "quarter_3":1, "quarter_4":0, "Population":94126}, {"State":"Alaska", "Agency_type":"Cities", "Agency_name":"Anchorage", "quarter_1":2, "quarter_2":3, "quarter_3":3, "quarter_4":0, "Population":299455}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Apache Junction", "quarter_1":1, "quarter_2":0, "quarter_3":0, "quarter_4":0, "Population":36626}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Avondale", "quarter_1":1, "quarter_2":1, "quarter_3":3, "quarter_4":0, "Population":78905}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Eagar", "quarter_1":0, "quarter_2":1, "quarter_3":0, "quarter_4":0, "Population":5034}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"El Mirage", "quarter_1":0, "quarter_2":0, "quarter_3":1, "quarter_4":0, "Population":32837}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Gilbert", "quarter_1":1, "quarter_2":0, "quarter_3":0, "quarter_4":0, "Population":225232}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Glendale", "quarter_1":2, "quarter_2":0, "quarter_3":3, "quarter_4":2, "Population":234006}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Goodyear", "quarter_1":1, "quarter_2":0, "quarter_3":1, "quarter_4":0, "Population":71048}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Maricopa", "quarter_1":0, "quarter_2":0, "quarter_3":0, "quarter_4":1, "Population":44871}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Mesa", "quarter_1":2, "quarter_2":0, "quarter_3":0, "quarter_4":0, "Population":456155}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Phoenix", "quarter_1":25, "quarter_2":21, "quarter_3":35, "quarter_4":0, "Population":1502139}, {"State":"Arizona", "Agency_type":"Cities", "Agency_name":"Prescott", "quarter_1":0, "quarter_2":0, "quarter_3":0, "quarter_4":1, "Population":40752},
Data.csv file
State | Agency_type | Agency_name | Ethnicity | Disability | Gender | Gender_Identity | |
Alabama | Cities | Florence | 0 | 0 | 0 | 0 | |
Alabama | Cities | Hoover | 0 | 0 | 0 | 0 | |
Alabama | Cities | Prattville | 0 | 0 | 0 | 0 | |
Alabama | Cities | Tuscaloosa | 0 | 0 | 0 | 0 | |
Alaska | Cities | Anchorage | 0 | 0 | 0 | 0 | |
Arizona | Cities | Apache Junction | 0 | 0 | 0 | 0 | |
Arizona | Cities | Avondale | 1 | 0 | 0 | 0 | |
Arizona | Cities | Eagar | 1 | 0 | 0 | 0 | |
Arizona | Cities | El Mirage | 0 | 0 | 0 | 0 | |
Arizona | Cities | Gilbert | 0 | 0 | 0 | 0 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started