DEV Community

Nilotpal Choudhury
Nilotpal Choudhury

Posted on

Strip / trim all strings of a dataframe

Strip / trim all strings of a dataframe

80

Cleaning the values of a multitype data frame in python/pandas, I want to trim the strings. I am currently doing it in two instructions :

import pandas as pd

df = pd.DataFrame([['  a  ', 10], ['  c  ', 5]])

df.replace('^\s+', '', regex=True, inplace=True) #front
df.replace('\s+$', '', regex=True, inplace=True) #end

df.values

Top comments (0)