Search for question
Question

In this homework, you will create a java program to read the student_dataset.csv file

and find the answers for the following questions

1) How many advisors do we have? Display their names.

2) What is the full information of the students whose GPA is less than 2.75?

3) What are the average credit hours of the college?

4) What is the average GPA of the students whose department is Computer Science?

5) Display the list of departments along with the total number of advisors.

For ex:

Computer Science: 7

Biology: 9

• It is your task to decide the most suitable data structures to solve these questions. Do

not hard code any information, your code should be able to find these values for any

given similar .csv file