Accepted Students for Each Major

Write the Python code to calculate the total number of ACCEPTED applications for each

Major and store it in the column Accepted.

Your solution must include only a single row for each major. Each row must contain a Major

variable $($column$)$ and an Accepted variable $($column$).$ You can create extra columns if needed

$--$ only Major and Accepted will be graded.

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's self$-$identified gender, one of: $"$M$"$ or $"$F$"$

Admission $($string$),$ The admission decision for each applicant, one of: "Accepted" or

"Rejected"