Skip to content
Tutorial Reference

Python Pandas: How to Calculate String Lengths in a Pandas Series

Learn efficient methods to calculate string lengths in a Pandas Series using .str.len(), handle missing values, and apply length-based filtering for data validation and text analysis.

Measuring text length is fundamental to data validation, feature engineering, and text analysis. Whether you're filtering entries by character count, detecting anomalies, or preparing features for machine learning, Pandas provides optimized vectorized methods that process millions of strings in milliseconds.

This guide demonstrates efficient techniques for calculating string lengths while properly handling missing data.

Vectorized Length Calculation with str.len()

The .str.len() method is the most efficient approach for calculating string lengths in a Pandas Series. It executes at the C level, avoiding Python loop overhead:

import pandas as pd

languages = pd.Series(['Python', 'JavaScript', 'C++', 'Java', 'Rust'])

lengths = languages.str.len()

print("Languages:")
print(languages)
print("\nCharacter Counts:")
print(lengths)

Output:

Languages:
0        Python
1    JavaScript
2           C++
3          Java
4          Rust
dtype: object

Character Counts:
0     6
1    10
2     3
3     4
4     4
dtype: int64

Handling Missing Values

A key advantage of .str.len() is its graceful handling of NaN and None values:

import pandas as pd

data = pd.Series(['Hello', None, 'World', pd.NA, 'Python'])

lengths = data.str.len()

print("Data with missing values:")
print(data)
print("\nLengths (NaN preserved):")
print(lengths)

Output:

Data with missing values:
0     Hello
1      None
2     World
3      <NA>
4    Python
dtype: object

Lengths (NaN preserved):
0       5
1    None
2       5
3    <NA>
4       6
dtype: object

Adding Lengths to a DataFrame

Common workflow: calculate lengths and add as a new column:

import pandas as pd

df = pd.DataFrame({
    'product': ['Laptop', 'Smartphone', 'Tablet', 'Smartwatch'],
    'description': [
        'Powerful computing device',
        'Mobile communication tool',
        'Portable touchscreen',
        'Wearable tech'
    ]
})

df['product_length'] = df['product'].str.len()
df['desc_length'] = df['description'].str.len()

print(df)

Output:

      product                description  product_length  desc_length
0      Laptop  Powerful computing device               6           25
1  Smartphone  Mobile communication tool              10           25
2      Tablet       Portable touchscreen               6           20
3  Smartwatch              Wearable tech              10           13

Filtering by String Length

Use length calculations to filter data:

import pandas as pd

usernames = pd.Series(['jo', 'alice', 'bob', 'christopher', 'sam'])

valid_usernames = usernames[usernames.str.len().between(3, 10)]

print("Valid usernames (3-10 characters):")
print(valid_usernames)

Output:

Valid usernames (3-10 characters):
1    alice
2      bob
4      sam
dtype: object

Method Comparison

Method Performance Handles NaN Use Case
.str.len() Fastest Yes Production code, large datasets
.map(len) Fast No Clean data only
.apply(len) Slower No Custom functions 
import pandas as pd

data = pd.Series(['apple', 'banana', 'cherry'])

print(data.str.len().tolist())   # [5, 6, 6]
print(data.map(len).tolist())    # [5, 6, 6]
print(data.apply(len).tolist())  # [5, 6, 6]

Output:

[5, 6, 6]
[5, 6, 6]
[5, 6, 6]

Practical Applications

Text Validation

import pandas as pd

passwords = pd.Series(['abc', 'secure123', 'p@ssw0rd!', '12345'])
lengths = passwords.str.len()

df = pd.DataFrame({
    'password': passwords,
    'length': lengths,
    'valid': lengths >= 8
})

print(df)

Output:

    password  length  valid
0        abc       3  False
1  secure123       9   True
2  p@ssw0rd!       9   True
3      12345       5  False

Summary Statistics

import pandas as pd

reviews = pd.Series([
    'Great product!',
    'Terrible experience, would not recommend to anyone.',
    'OK',
    'Absolutely fantastic, exceeded all expectations!'
])

lengths = reviews.str.len()

print(f"Average length: {lengths.mean():.1f}")
print(f"Shortest review: {lengths.min()} characters")
print(f"Longest review: {lengths.max()} characters")

Output:

Average length: 28.8
Shortest review: 2 characters
Longest review: 51 characters

Binning by Length

import pandas as pd

texts = pd.Series(['Hi', 'Hello there', 'This is a longer message', 'OK'])
lengths = texts.str.len()

categories = pd.cut(lengths, bins=[0, 5, 15, 100], labels=['short', 'medium', 'long'])

result = pd.DataFrame({
    'text': texts,
    'length': lengths,
    'category': categories
})

print(result)

Output:

                       text  length category
0                        Hi       2    short
1               Hello there      11   medium
2  This is a longer message      24     long
3                        OK       2    short

Mastering vectorized string length calculations enables efficient text analysis, robust data validation, and scalable feature engineering in your Pandas workflows.

Navigation