Set prof_names to a table with two columns. The first column should be called "Org. Major. Budget. Unit" and have the name of every department once, and the second column should be called "names" 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.
def identity(array):
return array
def first(array):
return array. item(0)prof_names = Table().with_columns(
"Org. Major. Budget. Unit", profs. column("Org. Major. Budget. Unit"),
"names", profs. column("Full. Name"))
prof_names = prof_names. sort("Org. Major. Budget. Unit")
prof_names = prof_names. group("Org. Major. Budget. Unit",first(prof_names. column("names")))