Summary Statistics of pandas DataFrame in Python (4 Examples) | Calculate Descriptive Stats by Group

Python code of this video:

import pandas as pd # Load pandas

data = pd.DataFrame({'x1':[2, 7, 5, 7, 1, 5, 9], # Create pandas DataFrame
'x2':range(1, 8),
'group':['A', 'B', 'A', 'A', 'C', 'B', 'A']})
print(data) # Print pandas DataFrame

print(data['x1'].mean()) # Get mean of one column
# 5.142857142857143

# x1 5.142857
# x2 4.000000
# dtype: float64

# x1 x2
# count 7.000000 7.000000
# mean 5.142857 4.000000
# std 2.853569 2.160247
# min 1.000000 1.000000
# 25% 3.500000 2.500000
# 50% 5.000000 4.000000
# 75% 7.000000 5.500000
# max 9.000000 7.000000

# x1 x2
# group
# A 5.75 3.75
# B 6.00 4.00
# C 1.00 5.00

Follow me on Social Media: