Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Management An Organizational Perspective

Authors: Richard T. Watson

1st Edition

0471305340, 978-0471305347

More Books

Students also viewed these Databases questions

Question

The amount of work I am asked to do is reasonable.

Answered: 1 week ago

Question

The company encourages a balance between work and personal life.

Answered: 1 week ago