Pandas: Calculate Standard Error of Mean with sem()

Compute the standard error of the mean for values across Series or DataFrames using the Pandas sem() method. Evaluate sampling precision, configure delta degrees of freedom (ddof), and handle missing observations effectively.

Show Table of Contents ↓

Introduction to sem() 🔝

The sem() method calculates the standard error of the mean ($ ext{SEM} = rac{ ext{std}}{\sqrt{N}}$) for requested numerical columns. By default, Pandas uses sample standard deviation with $ ext{ddof}=1$ and excludes missing values (skipna=True).

Create numerical sample DataFrame 🔝

We start with a multi-column numerical DataFrame representing repeated experiment readings.

import pandas as pd

df = pd.DataFrame({
    "TRIAL_A": [10, 12, 14, 16, 18],
    "TRIAL_B": [20, 25, 30, 35, 40]
})
print(df)
assert df.shape == (5, 2)

Expected output

   TRIAL_A  TRIAL_B
0       10       20
1       12       25
2       14       30
3       16       35
4       18       40

Basic SEM calculation 🔝

Call sem() on the DataFrame to calculate the standard error of the mean across columns.

sem_res = df.sem()
print(sem_res)
assert round(sem_res["TRIAL_A"], 4) == 1.4142

Expected output

TRIAL_A    1.414214
TRIAL_B    3.535534
dtype: float64

Standard error on a single Series 🔝

Apply sem() directly to a single column or standalone Pandas Series.

s_sem = df["TRIAL_A"].sem()
print(f"Standard Error: {s_sem:.4f}")
assert round(s_sem, 4) == 1.4142

Expected output

Standard Error: 1.4142

Exercise: compute sample measurement SEM 🔝

Given a Series vals = pd.Series([2, 4, 4, 4, 5, 5, 7, 9], name="MEASURE"), compute its standard error of the mean using sem() and verify that it rounds to 0.7777.

Exercise solution 🔝

Solution creating the Series and calculating sem().

vals = pd.Series([2, 4, 4, 4, 5, 5, 7, 9], name="MEASURE")
answer = vals.sem()
print(f"Answer: {answer:.4f}")
assert round(answer, 4) == 0.7777

Expected output

Answer: 0.7777

Practice in Google Colab 🔝

Interactive Colab Notebook

Practice sem() examples interactively directly in your browser:

View on GitHub

Reference: Pandas sem() documentation.

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here