Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Question 1 (10 points) Suppose that you have been given a text file unis.csv containing lines of comma- separated data about some universities, and how

image text in transcribed

Question 1 (10 points) Suppose that you have been given a text file unis.csv containing lines of comma- separated data about some universities, and how their graduates report on outcomes from the education. Here are the data fields (also called data attributes): Field name Description UniName Abbreviation of the University's name State Abbreviation of the state where the University is mostly located Employment(2018) Percentage of 2018 graduates in full-time employment, three months after graduation Employment(2019) Percentage of 2019 graduates in full-time employment, three months after graduation The first few lines look like this (note that the first line is a header, and also note that the fields do not themselves contain any commas): UniName, State , Employment (2018) , Employment (2019) CQU, QLD, 79.1,79.6 Curtin, WA, 72.4,71.4 Deakin, VIC, 72.8,73.4 Suppose that you are part of a team whose task is to analyse the data in unis.csv to calculate the following: place the values for Employment(2018) into bins, with each bin representing a range of 5 (for example, 70 to 75, 75 to 80, etc). For each bin, find how many states contain universities whose Employment(2018) score is within that bin. Provide well-commented Python code that will perform this calculation. You do not need to deal with misformatted files or other errors. You are allowed to use a library like Pandas, but this is not required. It is important that your comments should clearly describe the structure used for storing the data in your program (eg if you use a dictionary, you must explain what the keys and values represent; if you use Pandas, you must indicate the indices of the dataframes your code refers to, etc)

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

Object Oriented Databases Prentice Hall International Series In Computer Science

Authors: John G. Hughes

1st Edition

0136298745, 978-0136298748

More Books

Students also viewed these Databases questions

Question

Perception in a Diverse World Cognition: Perceiving Ourselves

Answered: 1 week ago

Question

What is paper chromatography?

Answered: 1 week ago

Question

Explain the cost of capital.

Answered: 1 week ago

Question

Define capital structure.

Answered: 1 week ago