Answered step by step
Verified Expert Solution
Link Copied!
Question
1 Approved Answer

Dataset City of Chicago Salary information https://data.cityofchicago.org/Administration-Finance/Current-Employee-Names-Salaries-and-Position-Title/xzkq-xp2w/data For this assignment, you need to create a program that does the job of finding the answers for

Dataset

City of Chicago Salary information

https://data.cityofchicago.org/Administration-Finance/Current-Employee-Names-Salaries-and-Position-Title/xzkq-xp2w/data

For this assignment, you need to create a program that does the job of finding the answers for the following three questions. You only are allowed to use Python programming language (no mapreduce, no java, no hadoop...).

Questions

With this dataset, you need to implement Python program that find answers for the following three questions.

1. Identify how many employees in each department?

2. Identify how many position titles in the City of Chicago?

3. Identify average salary for each position title?

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_2

Step: 3

blur-text-image_step3

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

More Books

Students explore these related Databases questions