Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Please help, data science class using python3 jupyter 2. Faculty salaries In the next cell, we load a dataset created by the Daily Cal which
Please help, data science class using python3 jupyter
2. Faculty salaries In the next cell, we load a dataset created by the Daily Cal which contains Berkeley faculty, their departments, their positions, and their gross salaries in 2015 [12]: raw-profs profs profs = Table .read-table( "faculty .csv").where ("year ", raw_profs.relabel ("title_category, "position") In are . equal-to (2015)).drop ("year ", "title") Out [12] position gross salary 64450 184998 3466 138775 100300 319693 191162 14779 101567 182288 name CYNTHIA ABAN PIETER ABBEEL SALLY ABEL ELIZABETH ABEL DOR ABRAHAMSON KATHRYN ABRAMS BARBARA ABRAMS SARAH ACCOMAZZO CHARISMA ACEY DAVID ACKERLY South & Southeast Asian Studies Computer Science Law English Education Law Public Health Social Welfare City and Regional Planning Biology lecturer associate professor lecturer professor associate professor professor lecturer assistant professor ...(2049 rows omitted) Question 1. Set prof_names to a table with two columns. The first column should be called department and have the name of every department once and the second column should be called faculty and contain an array of the names of all faculty members in that department. Hint: Think about how group works: it collects values into an array and then applies a function to that array. We have defined two functions below for you, and you will need to use one of them in your call to group In [26]: # Pick one of the two functions defined below in your call to group. def identity (array): return array def first (array): return array.item(0) In [27]: prof-names prof_names = File "Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started