Home /
Expert Answers /
Computer Science /
write-the-python-code-to-calculate-the-major-that-admitted-the-fewest-students-and-leave-a-single-pa340
(Solved):
Write the Python code to calculate the major that admitted the fewest students and leave a single ...
Write the Python code to calculate the major that admitted the fewest students and leave a single row of that major as the only row in the DataFrame df_applicants. Your solution must include only a single row for the major that admitted fewest students. That row must contain a Major variable (column). You can create extra columns if needed -- only Major will be graded. Dataset This problem uses the admission records from UC-Berkeley's graduate program in Fall 1973. This classical dataset has already been loaded into a variable df for you and contains the following variables (columns): - Year (number), A four digit year, ex: 1973 - Major (string), A major code, one of: "A", "B", "C", "D", "E", "F", or "Other" - Gender (string), The applicant self-identified gender, one of: "M" or "F" - Admission (string), The admissions decision, one of: "Accepted" or "Rejected" Variables The setup code gives the following variables: Your code snippet should define the following variables: Pandas Cheat Sheet Open the pandas cheat sheet in a new tab
You can just do as shown below. df_applicants = (df['Major'].value_counts(ascending=True)).head(1) print('Major that admitted fewest students') print(df_applicants) Sample code with output shown below :