Best House on Average

Data questions · Intermediate · about 8 min

house_points.csv has each student's name, house and the points they earned this term. The houses have different numbers of students, so compare the average points per student. Set answer to the name of the house with the highest average, exactly as in the file.

Example

The first lines of house_points.csv:

student,house,points
Aiden,Red,12
Bianca,Blue,18

house_points.csv · 20 rows

student	house	points
Aiden	Red	12
Bianca	Blue	18
Chirag	Green	15
Dalia	Yellow	11
Emeka	Red	14
Fiona	Blue	17
Gabe	Green	10
Hema	Yellow	16

First 8 of 20 rows.

import pandas as pd

df = pd.read_csv("house_points.csv")

answer = None

The solution opens after your first Check.