toropyga

s02_t02_l04_tsk02

Jul 1st, 2021 (edited)
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.51 KB | None | 0 0
  1. import pandas as pd
  2.  
  3. hogwarts_points = pd.read_csv('/datasets/hogwarts_points.csv')
  4. hogwarts_points['faculty_name'] = hogwarts_points['faculty_name'].fillna(value='Гриффиндор')
  5. print('Сумма баллов учеников:', hogwarts_points.groupby('faculty_name')['points'].sum().sum())
  6. print('Сумма баллов факультетов:', hogwarts_points.groupby('faculty_name')['points'].sum())
  7. print(f"Кубок получает {hogwarts_points.groupby('faculty_name')['points'].sum().idxmax()}")
Add Comment
Please, Sign In to add comment