Year,Sex,Min degree,Total,White, Black, Hispanic, Asian, Pacific Islander, American Indian/Alaska Native, Two or more races 1940,A,high school,...

Transcribed Image Text:

Year,Sex,Min degree,Total,White, Black, Hispanic, Asian, Pacific Islander, American Indian/Alaska Native, Two or more races 1940,A,high school, 38.1,41.2,12.3,- 1920,A,high school,---,22.0,6.3,- 1950,A,high school,52.8,56.3,23.6,- 1960,A,high school,60.7,63.7,38.6,- 1970,A,high school,75.4,77.8,58.4,- 1980,A,high school, 85.4,89.2,76.7,58.0,---,- 1990,A,high school, 85.7,90.1,81.7,58.2,- 1995,A,high school,86.8,92.5,86.7,57.1,---,---,81.5,--- 2000,A,high school, 88.1,94.0,86.8,62.8,-- -,79.2,--- 2005,A,high school, 86.2,92.8,87.0,63.3,95.5,99.5,80.2,91.4 MATTHEW A CARLTON Chegg View all so What were the percentages for women vs. men having earned a Bachelor's Degree in 1980? Task: Write a function compare_bachelors_1980 and that takes the data and computes the percentages of men and women who achieved a minimum degree of a Bachelor's degree in 1980. The result should be a 2-by-2 DataFrame with rows corresponding to men and women and columns corresponding to Sex and Total. The order of the rows doesn't matter. For example, your result should look something like this: Sex Total : LL F Enter Ear bac Choo to ea Year,Sex,Min degree,Total,White, Black, Hispanic, Asian, Pacific Islander, American Indian/Alaska Native, Two or more races 1940,A,high school, 38.1,41.2,12.3,- 1920,A,high school,---,22.0,6.3,- 1950,A,high school,52.8,56.3,23.6,- 1960,A,high school,60.7,63.7,38.6,- 1970,A,high school,75.4,77.8,58.4,- 1980,A,high school, 85.4,89.2,76.7,58.0,---,- 1990,A,high school, 85.7,90.1,81.7,58.2,- 1995,A,high school,86.8,92.5,86.7,57.1,---,---,81.5,--- 2000,A,high school, 88.1,94.0,86.8,62.8,-- -,79.2,--- 2005,A,high school, 86.2,92.8,87.0,63.3,95.5,99.5,80.2,91.4 MATTHEW A CARLTON Chegg View all so What were the percentages for women vs. men having earned a Bachelor's Degree in 1980? Task: Write a function compare_bachelors_1980 and that takes the data and computes the percentages of men and women who achieved a minimum degree of a Bachelor's degree in 1980. The result should be a 2-by-2 DataFrame with rows corresponding to men and women and columns corresponding to Sex and Total. The order of the rows doesn't matter. For example, your result should look something like this: Sex Total : LL F Enter Ear bac Choo to ea