Home › Python

AttributeError: 'DataFrame' object has no attribute 'append' (Python) — how to fix

Traceback (most recent call last):
  File "main.py", line 8, in <module>
    df = df.append({"name": "Ann", "age": 31}, ignore_index=True)
  File ".../pandas/core/generic.py", line 6299, in __getattr__
    return object.__getattribute__(self, name)
AttributeError: 'DataFrame' object has no attribute 'append'. Did you mean: '_append'?

Quick fix: Use pd.concat: df = pd.concat([df, pd.DataFrame([row])], ignore_index=True). Better, collect rows in a list and build once: df = pd.DataFrame(rows). For one row with a default index, df.loc[len(df)] = row works too. Don't use the private _append.

What it means

pandas 2.0 (April 2023) removed DataFrame.append and Series.append. Check your version:

python -c "import pandas; print(pandas.__version__)"

append was removed partly because it was slow: each call copies the whole DataFrame, so appending in a loop is quadratic. The replacements below are both correct and faster.

The Did you mean: '_append'? hint points to a private method — it may change or disappear, so don't rely on it.

Fix 1: pd.concat for joining DataFrames

import pandas as pd

# Old
df = df1.append(df2, ignore_index=True)
# New
df = pd.concat([df1, df2], ignore_index=True)

Appending a single row (a dict) means wrapping it in a one-row DataFrame:

row = {"name": "Ann", "age": 31}
df = pd.concat([df, pd.DataFrame([row])], ignore_index=True)

Note the brackets: pd.DataFrame([row]) (list of dicts → one row). pd.DataFrame(row) with scalar values raises If using all scalar values, you must pass an index.

For Series: s = pd.concat([s, pd.Series([value])], ignore_index=True).

Fix 2: build the list first, DataFrame once (best for loops)

rows = []
for item in items:
    rows.append({"name": item.name, "age": item.age})   # list.append is fine
df = pd.DataFrame(rows)

This is much faster than concatenating inside the loop. If you're producing DataFrames in a loop, collect them and concat once:

frames = [pd.read_csv(f) for f in files]
df = pd.concat(frames, ignore_index=True)

Fix 3: df.loc for a single row

With a default RangeIndex, you can assign a new row by label:

df.loc[len(df)] = ["Ann", 31]               # values in column order
df.loc[len(df)] = {"name": "Ann", "age": 31}

This modifies df in place. It only works as "append" when the index is 0..n-1 — otherwise len(df) may overwrite an existing label.

Watch out for dtypes and empty frames

Pinning an old pandas (temporary)

If you can't change the code right now (e.g. a third-party script):

python -m pip install "pandas<2"

pandas 1.5 still has append with a deprecation warning, but it doesn't support the newest Python versions — treat this as a stopgap and port the code.

Last updated 2026-11-19.