python - Removing characters from a string in pandas

Question

I have a similar question to this one: Pandas DataFrame: remove unwanted parts from strings in a column.

So I used:

temp_dataframe['PPI'] = temp_dataframe['PPI'].map(lambda x: x.lstrip('PPI/'))

Most, of the items start with a 'PPI/' but not all. It seems that when an item without the 'PPI/' suffix encountered this error:

AttributeError: 'float' object has no attribute 'lstrip'

Am I missing something here?

Answer 1

use replace:

temp_dataframe['PPI'].replace('PPI/','',regex=True,inplace=True)

or string.replace:

temp_dataframe['PPI'].str.replace('PPI/','')