pandas .map vs .apply vs .applymap — Pick the Right One

About this lesson

Three pandas methods. Three different jobs. And one of them was removed in pandas 3.0 — which is why your copy-pasted Stack Overflow snippet just threw AttributeError. This tutorial walks through .map, .apply, and .applymap on a small prices DataFrame and shows exactly which method belongs where. Source code: https://github.com/GoCelesteAI/apply-vs-map-vs-applymap .map is Series-only. It takes a dict, a Series, or a function — and that dict overload is its superpower. If you're translating ticker symbols to sector names, country codes to country names, or any value-to-value lookup, .map is the one-liner that does it. .apply works on both Series and DataFrames, but always takes a function. On a Series it's basically a slower .map. On a DataFrame it's something else entirely — axis=0 hands your function each column as a Series, axis=1 hands it each row as a Series. That's how you compute per-column standard deviation in one line, or per-row max in another. .applymap was the old element-wise method — it ran your function on every cell of a DataFrame. As of pandas 2.1 it's deprecated, and in pandas 3.0 it's gone. The replacement is DataFrame.map, which works exactly the same way. What You'll Build: - pandas_methods.py — a single file that demonstrates all four cases (Series.map, Series.apply, DataFrame.apply axis=0 + axis=1, DataFrame.map) on a 3x3 prices DataFrame. Runs in two seconds. - The Series.map dict pattern — pass a dict of ticker→sector mappings and pandas does the lookup for every value at once. No loop. No merge. - The Series.apply function pattern — same shape, but takes a function. Useful when the transformation needs logic the dict can't express. - DataFrame.apply axis=0 — your function receives each column as a Series. Perfect for per-column reductions like std, mean, custom z-scores. - DataFrame.apply axis=1 — your function receives each row as a Series. The row-wise tool you reach for when no column expression works. - DataFrame.map element-wise —

Original Description