Calculate Max & Min by Group in Python (2 Examples) | Maxima & Minima in Subgroup | Multiple Columns

Описание: How to calculate maxima and minima by group in the Python programming language. More details: https://statisticsglobe.com/max-min-g...
Python code of this video:

import pandas as pd # Load pandas library

data = pd.DataFrame({'x1':[6, 5, 2, 8, 1, 6, 5, 8], # Create pandas DataFrame
'x2':range(11, 19),
'group1':['C', 'B', 'B', 'A', 'C', 'A', 'B', 'A'],
'group2':['a', 'a', 'a', 'a', 'b', 'b', 'b', 'b']})
print(data) # Print pandas DataFrame

print(data.groupby('group1').max()) # Get max by group
x1 x2 group2
group1
A 8 18 b
B 5 17 b
C 6 15 b

print(data.groupby('group1').min()) # Get min by group
x1 x2 group2
group1
A 6 14 a
B 2 12 a
C 1 11 a

print(data.groupby(['group1', 'group2']).max()) # Get max by multiple groups
x1 x2
group1 group2
A a 8 14
b 8 18
B a 5 13
b 5 17
C a 6 11
b 1 15

print(data.groupby(['group1', 'group2']).min()) # Get min by multiple groups
x1 x2
group1 group2
A a 8 14
b 6 16
B a 2 12
b 5 17
C a 6 11
b 1 15

Follow me on Social Media:
Facebook – Statistics Globe Page:   / statisticsglobecom  
Facebook – R Programming Group for Discussions & Questions:   / statisticsglobe  
Facebook – Python Programming Group for Discussions & Questions:   / statisticsglobepython  
LinkedIn – Statistics Globe Page:   / statisticsglobe  
LinkedIn – R Programming Group for Discussions & Questions:   / 12555223  
LinkedIn – Python Programming Group for Discussions & Questions:   / 12673534  
Twitter:   / joachimschork  

Music by bensound.com