Calculate Median by Group in Python (2 Examples) | DataFrame Subgroups | groupby & median Functions

Python code of this video:

import pandas as pd # Load pandas library

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

# x1 x2
# group1
# A 4.0 13.0
# B 3.5 13.5
# C 5.0 14.0

# x1 x2
# group1 group2
# A a 2.0 12.0
# b 8.0 18.0
# B a 3.5 10.5
# b 3.5 16.5
# C a 5.0 13.0
# b 5.0 15.0

Follow me on Social Media: