I have assignment to solve using python if any one can help me here.

The explanation of each column in this dataset is presented in the picture below . Read the data from PatientInfo.csv file and apply the following operations:

a) Remove the data rows with empty sex and age fields

b) Add a new column infection reason by using existing infection case column. If infection case is contact with patient, copy this reason to a new column, otherwise, write other.

c)Add a column to the dataset for the age group defined as categories (Children: 0s10s; Youth: 20s years; Adults: 30s-60s years; Seniors: the rest of the age column)

d) Display the following graphs (histogram): Display the number of patients by age groups (with the categories given above) Display the number of patients by gender Display the number of patients by Infection Reason (the new columns that you created).

e) Is there any difference between the males and females according to the average number of people that they contact? Test the hypothesis and comment on the result with one or two sentences. H0= Men and women contact with the same number of people on average H1= Men and women do not contact with the same number of people on averag

C D A B 1 patient_id sex 2 1E+09 male 3 1E+09 male 4 1E+09 male 5 1E+09 male 6 1E+09 female 7 1E+09 female 8 1E+09 male 9 1E+09 male 10 1E+09 male 11 1E+09 female 12 120g female age 50s 30s 50s 20s 20s 50s 20s 20s 30s 60s 50s country Korea Korea Korea Korea Korea Korea Korea Korea Korea Korea China E G H K L M N province city infection_ infected_b contact_n symptom_confirmed released_c deceased_state Seoul Gangseo-g overseas inflow 75 ######## ######## 2/5/2020 released Seoul Jungnang-1 overseas inflow 31 ######## 3/2/2020 released Seoul Jongno-gu contact wi 2E+09 17 ######## ######## released Seoul Mapo-gu Overseas inflow 9 ######## ######## ######## released Seoul Seongbuk-contact wi 1E+09 2 ######## ######## released Seoul Jongno-gu contact wi 1E+09 43 ######## ######## released Seoul Jongno-gu contact wi 1E+09 0 ################ released Seoul etc overseas inflow 0 2/2/2020 ######## released Seoul Songpa-gu overseas inflow 68 2/5/2020 ######## released Seoul Seongbuk-contact wi 1E+09 6 2/5/2020 ######## released Seoul Seodaemu overseas inflow 23 2/6/2020 HHHHHHHH released