Using Jupyter (Python)

For this question you will need Employment.csv file

Please find the needed files here: https://1drv.ms/f/s!AuDGvZfVai_VgeMvoo2FaZ1T4K6gtA

Question 3.c (3 points): John does not know the total number of participants, but he has the data of male and female participants Generate a new column that shows total number of participants in the field study based on each major The name of the coloum is total In [269] : df['total.] -df[?'] + df[?"] # select the columns Question 3.d (5 points): He wants to have % of female participants for each major Generate another new column that shows % of the female students participant in the feild study based on each major. The name of the coloum is WomenShare In [268] : df['WomenShare'] -df[.?')/df[?'] # select the columns Questions 3.e: (3 points). Find the number of students that do not have college_jobs in each major Show the result as a new column 'non_college_jobs' df["non-college-jobs'] In [ ] : = df ['?'] - df ['?']s select the columns Questions 3.f: (8 points) Find the % of the unemployed students in each major. df["unemployedRate'] In [270] : - 100* (df['?']-df['?'])/(df[.?'])# select the columns