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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!