Question: I need a python code for this question please as soon as possible! Find each type of hate crimes percentage that happened in Cities. (Agency
I need a python code for this question please as soon as possible! Find each type of hate crimes percentage that happened in Cities. (Agency type is Cities.)
[{"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
Get step-by-step solutions from verified subject matter experts
