Get the string length of the column – python pandas

len() function in pandas python is used to get the length of string. In this tutorial we will learn How to find the string length of the column in a dataframe in python pandas

 

Syntax for string len() function in python:

len(str)

 

Example of get the length of the string of column in a dataframe in python:

Create dataframe:

##create dataframe

import pandas as pd
d = {'Quarters' : ['q1','quar2','quarter3','quarter-4'],
     'Revenue':[23400344.567,54363744.678,56789117.456,4132454.987]}
df=pd.DataFrame(d)
print df	

dataframe will be

string length of the column in a dataframe in python 1

 

# get the length of the string of column in a dataframe

df['Quarters_length'] = df['Quarters'].apply(len)
print df

We will be using apply function to find the length of the string in the columns of the dataframe so the resultant  dataframe will be

string length of the column in a dataframe in python 2

 

Example 2 – Get the length of the integer of column in a dataframe in python:

# get the length of the integer of column in a dataframe

df[' Revenue_length'] = df['Revenue'].map(str).apply(len)
print df
  • First typecast the integer column to string and then apply length function so the resultant dataframe will be

string length of the column in a dataframe in python 3

 

previous string length of the column in a dataframe in python pandas                                                                                                                next string length of the column in a dataframe in python pandas