How would you extract the highest score and corresponding subject for each student from a table containing student names, their five subjects, and scores for two consecutive years? Additionally, how would you calculate the growth for each student in every subject from last year to this year, considering that if a student does not have a score from last year, their growth would be considered 100%?

Question

Accepted Answer

Extract highest scores and calculate growth for students across subjects over two years.

Use a data structure (like a DataFrame) to store student names, subjects, and scores.
Group data by student and subject to find the maximum score for each subject.
Example: If Student A has scores [80, 90, 85, 70, 95] in subjects [Math, Science, English, History, Art], the highest score is 95 in Art.
For growth calculation, compare scores from last year to this year.
If last year's score is missing, assign a growth of 100%. Example: If Student A scored 0 in Math last year and 80 this year, growth = 100%.
Store results in a new structure that includes student names, highest scores, corresponding subjects, and growth percentages.

Asked in Comviva Technology

Top Data Scientist Interview Questions Asked at Comviva Technology

Interview Questions Asked to Data Scientist at Other Companies

Top Skill-Based Questions for Comviva Technology Data Scientist