import pandas as pd
hogwarts_points = pd.read_csv('/datasets/hogwarts_points_eng.csv')
hogwarts_points['house'] = hogwarts_points['house'].fillna(value='Gryffindor')
print ('Total points for Hogwarts:', hogwarts_points['points'].sum(), 'total sum of points') # total of values in the 'points' column
print ('Total points by house:', hogwarts_points.groupby('house')['points'].sum().sum(), 'total points with grouping by house') # group by the 'house' column
# then use the sum() method to add the points, which are the values in the 'points' column for this grouping
# and apply the sum() method to the results
print('The Cup goes to', hogwarts_points.groupby('house')['points'].sum().idxmax(), 'house name')