Pandas

KeyError: Column Not Found — How to Fix It

Answer

This error means you're trying to access a column name that doesn't exist in your dataframe. Fix it by checking your column names with df.columns — the issue is usually a typo, extra whitespace in the column name, or the column was renamed or dropped earlier in your code.

Why This Happens

Pandas raises KeyError when you reference a column that isn't in the dataframe's index. The most common causes: misspelled column name, case sensitivity (Name vs name), hidden whitespace ('price ' vs 'price'), or the column was dropped/renamed upstream and you're working with stale variable names.

Solution

The rule: when you hit a KeyError, run df.columns.tolist() immediately to see what's actually there.

pythonimport pandas as pd

df = pd.DataFrame({'product_name': ['A', 'B'], 'price': [10, 20]})

# ❌ Problematic: column name doesn't exist
df['product']
# KeyError: 'product'

# ✅ Fixed: check columns first, use correct name
print(df.columns.tolist())  # ['product_name', 'price']
df['product_name']

# ✅ Strip whitespace from column names if that's the issue
df.columns = df.columns.str.strip()

Better Workflow

Zerve shows dataframe schema and column names inline as you work, so mismatches between your code and actual column names are visible before you run into errors.