Answered step by step
Verified Expert Solution
Link Copied!

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 9Year 10Year 11Year 12
Bailey High School72.49382771.89749872.37490072.675097
Cabrera High School72.32197072.43776871.00829970.604712
Figueroa High School68.47780468.33158668.81100169.325282
Ford High School69.02160969.38700669.24886268.617811
Griffin High School72.78973171.09359671.69252171.469178
Hernandez High School68.58683168.86715669.15441268.985075
Holden High School70.54330775.10526371.64077773.409639
Huang High School69.08175468.53324669.43134568.639316
Johnson High School69.46928667.99022068.63773069.287393
Pena High School71.99636472.39600072.52343871.187845
Rodriguez High School71.94072271.77980872.36481172.154626
Shelton High School72.93207572.50669670.09708772.331536
Thomas High School69.23427370.05700769.65783169.369822
Wilson High School69.21236169.45544668.37896569.787472
Wright High School71.74117672.17901273.27586270.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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Introduction to Management Science

Authors: Bernard W. Taylor

11th Edition

132751917, 978-0132751919

More Books

Students also viewed these Programming questions