Grouping Rows in pandas (original) (raw)

`import pandas as pd

example dataframe

example = {'Team':['Australia', 'England', 'South Africa', 'Australia', 'England', 'India', 'India', 'South Africa', 'England', 'India'],

       'Player':['Ricky Ponting', 'Joe Root', 'Hashim Amla',
                 'David Warner', 'Jos Buttler', 'Virat Kohli',
                 'Rohit Sharma', 'David Miller', 'Eoin Morgan',
                                             'Dinesh Karthik'],
                                             
      'Runs':[345, 336, 689, 490, 989, 672, 560, 455, 342, 376],
      
      'Salary':[34500, 33600, 68900, 49000, 98899,
                67562, 56760, 45675, 34542, 31176] }

df = pd.DataFrame(example)

total_salary = df['Salary'].groupby(df['Team'])

printing the means value

print(total_salary.mean())

`