Python Pandas: Find the length of the string in dataframe

7.3K    Asked by IraJoshi in Python , Asked on Apr 14, 2021

 How to find find the length of dataframe  string stored in each cell. What code should I use to do this?

Answered by Ira Joshi

To find the length of strings in a data frame you have the len method on the dataframes str property. But to do this you need to call this method on the column that contains the string data.

You can find the length of dataframe using the below code:

import pandas as pd
data = pd.DataFrame({
    'age' : [15, 17, 20, 14, 25],
    'name': ["Sample", "New User", "My Name", "Jane Doe", "John Doe"]
})
data['name'].str.len()
You'll get the following output:
0 6
1 8
2 7
3 8
4 8
Name: name, dtype: int64

Your Answer

Interviews

Parent Categories