I request your help, because I have gotten involved with a problem that I have not been able to solve and I request your support if possible
I have a cvs file with the following records
year ; sex ; age_range ; career ; duration_semester; time_to_entitle_in_semest; total_semester
2015; female; 20 to 24 years; electrical engineering;9;2;11
2015;male;25 to 30 years; medicine;10;2;12
2015;male;31 to 34 years; teacher;9;1;10
2015;female;40 to 45 years;programmer;5;1;6
2015; female; 20 to 24 years; electrical engineering;9;4;13
I have performed several functions that were requested, but I have not been able to perform the follow:
I must calculate by sex, the average time that people between the ages of 20 and 24 take to complete their studies, for that I must take from the csv all the females between the ages of 20 and 24 , and calculate the average delay in graduating (total_semester) of all the students in that age range, considering the duration (duration_semester) and the time it took to do their thesis and receive their degree (time_to_entitle_in_semest).
For example, case 1, it took 2 semesters to finish his thesis and receive his degree, giving a total of 11 semesters, and case 5, it took 4 semesters to finish giving a total of 13 semesters, then, I must average how many Approximate semesters take to graduate.
I have not been able to understand how to do it, and I have read a lot, but I cannot understand how to do it.
I appreciate your help, and I apologize for bothering you with this problem, but I’m new to this topic and I’m learning how to solve this.
Thanks for your comments