Answered step by step
Verified Expert Solution
Question
1 Approved Answer
how to calculate average maths score for student of each year level(9,10,11,12) at each school, using pandas. how to make a pandas series for each
how to calculate average maths score for student of each year level(9,10,11,12) at each school, using pandas. how to make a pandas series for each year, and group each series by school, and then combine the series in a dataframe
the results like below
Year 9 | Year 10 | Year 11 | Year 12 | |
---|---|---|---|---|
Bailey High School | 72.493827 | 71.897498 | 72.374900 | 72.675097 |
Cabrera High School | 72.321970 | 72.437768 | 71.008299 | 70.604712 |
Figueroa High School | 68.477804 | 68.331586 | 68.811001 | 69.325282 |
Ford High School | 69.021609 | 69.387006 | 69.248862 | 68.617811 |
Griffin High School | 72.789731 | 71.093596 | 71.692521 | 71.469178 |
Hernandez High School | 68.586831 | 68.867156 | 69.154412 | 68.985075 |
Holden High School | 70.543307 | 75.105263 | 71.640777 | 73.409639 |
Huang High School | 69.081754 | 68.533246 | 69.431345 | 68.639316 |
Johnson High School | 69.469286 | 67.990220 | 68.637730 | 69.287393 |
Pena High School | 71.996364 | 72.396000 | 72.523438 | 71.187845 |
Rodriguez High School | 71.940722 | 71.779808 | 72.364811 | 72.154626 |
Shelton High School | 72.932075 | 72.506696 | 70.097087 | 72.331536 |
Thomas High School | 69.234273 | 70.057007 | 69.657831 | 69.369822 |
Wilson High School | 69.212361 | 69.455446 | 68.378965 | 69.787472 |
Wright High School | 71.741176 | 72.179012 | 73.275862 | 70.848238 |
csv file link https://drive.google.com/drive/folders/1N5tUXjtgSq5G2msJy4tqzZOrNT4VaWcW?usp=sharing
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started