Pandas · Pipe

str accessor

Pandas' .str accessor supplies vectorized string operations for Series and Index objects, including DataFrame columns and labels. Use it for tasks such as trimming, changing case, matching patterns, splitting, extracting, and concatenating text.

How it works

The .str accessor exposes vectorized string operations for a pandas Series and can also be used with DataFrame column labels because df.columns is an Index. Accessor methods transform or inspect string elements while preserving pandas alignment and missing-value handling.

Syntax

obj.str.<method>(...)

Returns

A pandas Series, Index, or DataFrame depending on the selected object and operation; shape and values are determined by the specific .str method.

Key points

Prefer pandas' dedicated string dtype when creating or normalizing text columns.
The accessor is available for cleaning or transforming column labels as well as Series values.
Use cat to combine string values according to its documented options.
Use contains to produce elementwise boolean matches for a pattern or regular expression.
Use rsplit when the meaningful delimiter is nearest the right-hand end of each value.

Common mistakes

Use it with string-like data; operations on unsupported element types are not generally supported.
Position-based string indexing beyond an element's length produces a missing value rather than an exception.
A Series containing list elements cannot use the string methods designed for string elements.

Example: Clean a text column

import pandas as pd

df = pd.DataFrame({"name": [" Alice ", "Bob"]})
df["name"] = df["name"].str.strip().str.lower()
print(df)

Cleans a string column by chaining the accessor's elementwise methods.

When to use it

Text cleaning

Normalize imported text fields by trimming whitespace and standardizing case.

Filtering and validation

Detect rows whose string values match or contain a pattern.

Parsing text

Split compound fields or extract structured parts into separate columns.

Column-name normalization

Clean DataFrame column labels before selecting or exporting data.

Interview questions

QWhat is the purpose of pandas' .str accessor?

The .str accessor provides vectorized string operations on pandas Series and related Index objects. It lets code apply methods such as strip, lower, contains, and rsplit element by element without an explicit Python loop.

Follow-up: What happens when the data is not string-like? The accessor is intended primarily for strings, and unsupported non-string uses may fail or remain unsupported.

QHow would you use .str with a DataFrame?

A DataFrame column is normally selected as a Series, so df["column"].str.method(...) applies a string operation to each value. The accessor can also operate on df.columns, because the columns object is an Index.

Follow-up: How can multiple transformations be composed? Chain accessor calls, such as .str.strip().str.lower(), when each stage returns compatible string-like data.

QWhat kinds of operations does the accessor provide?

The accessor supports operations including concatenation, splitting, extraction, containment checks, and case or whitespace transformations. Methods that split or extract can change the result shape, for example by producing multiple columns or a DataFrame.

Follow-up: What should be checked when using regex-oriented methods? Verify whether the method interprets its pattern as a regular expression and choose arguments accordingly.

Series.str
Index.str
Series.str.extractall
Series.str.cat
Series.str.contains
Series.str.rsplit

Source: Working with text data. Checked 2026-10-15.