Change language

Grouping strings in pandas

|

Let’s see how to group rows in Pandas Dataframe with some examples.

Example 1:

To group rows in Pandas, we’ll start by creating pandas dataframe first.

# pandas import

import pandas as pd

 
# sample dataframe

example = { ’Team’ : [ ’ Arsenal’ , ’ Manchester United’ , ’Arsenal’ ,

’Arse nal’ , ’Chelsea’ , ’Manchester United’ ,

  ’Manchester United’ , ’ Chelsea’ , ’Chelsea’ , ’ Chelsea’ ],

 

’Player’ : [ ’ Ozil’ , ’ Pogba’ , ’Lucas’ , ’Aubameyang’ ,

’Hazard’ , ’Mata’ , ’Lukaku’ , ’ Morata’

’Giroud’ , ’Kante’ ],

  

’Goals’ : [ 5 , 3 , 6 , 4 , 9 , 2 , 0 , 5 , 2 , 3 ]}

 

df = pd.DataFrame (example)

 

print (df)

Now , create grouping object means an object that represents that particular group.

total_goals = df [ ’Goals’ ]. groupby (df [ ’Team’ ])

  
# print tool value

print (total_goals.mean ()) 

Output:

Example 2 :

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’ ])

 
# print tool value

print (total_salary.mean ()) 

Output:

Grouping strings in pandas Python functions: Questions

Grouping strings in pandas String Variables: Questions

Shop

Best laptop for Fortnite

$

Best laptop for Excel

$

Best laptop for Solidworks

$

Best laptop for Roblox

$

Best computer for crypto mining

$

Best laptop for Sims 4

$

Best laptop for Zoom

$499

Best laptop for Minecraft

$590

Latest questions

NUMPYNUMPY

psycopg2: insert multiple rows with one query

12 answers

NUMPYNUMPY

How to convert Nonetype to int or string?

12 answers

NUMPYNUMPY

How to specify multiple return types using type-hints

12 answers

NUMPYNUMPY

Javascript Error: IPython is not defined in JupyterLab

12 answers

News

Wiki

Python OpenCV | cv2.putText () method

numpy.arctan2 () in Python

Python | os.path.realpath () method

Python OpenCV | cv2.circle () method

Python OpenCV cv2.cvtColor () method

Python - Move item to the end of the list

time.perf_counter () function in Python

Check if one list is a subset of another in Python

Python os.path.join () method