'DataFrame' object has no attribute 'str' - .str.replace error

Question

I am trying to replace "," by "" for 80 columns in a panda dataframe. I have create a list of the headers to iterate:

headers = ['h1', 'h2', 'h3'... 'h80']

and then I am using the list to replace multiple columns string value as bellow:

dataFrame[headers] = dataFrame[headers].str.replace(',', '')

Which gave me this error: AttributeError: 'DataFrame' object has no attribute 'str'

When I try the same on only one header it works well, and I need to use the str.replace because the only replace method does sadly not replace the ",".

wjandrea · Accepted Answer · 2024-10-20 16:30:02Z

9

Using `df.apply`

pd.Series.str.replace is a series method not for dataframes. You can use apply on each column (series) instead.

dataFrame[headers] = dataFrame[headers].apply(lambda x: x.str.replace(',', ''))

Another option is to use apply on each row (series) with axis=1.

Using `df.applymap`

Or, you can use applymap and treat each cell as a string and use replace directly on them.

dataFrame[headers] = dataFrame[headers].applymap(lambda x: x.replace(',', ''))

Using `df.replace`

You can also use df.replace which is a method available to replace values in df directly across all columns selected. But, for this purpose you will have to set regex=True.

dataFrame[headers] = dataFrame[headers].replace(',', '', regex=True)

edited Oct 20, 2024 at 16:30

wjandrea

33.8k10 gold badges69 silver badges105 bronze badges

answered Mar 2, 2021 at 16:28

Akshay Sehgal

19.4k3 gold badges26 silver badges57 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

'DataFrame' object has no attribute 'str' - .str.replace error

1 Answer 1

Using `df.apply`

Using `df.applymap`

Using `df.replace`

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Using df.apply

Using df.applymap

Using df.replace

Comments

Your Answer

Sign up or log in

Post as a guest

Related

Using `df.apply`

Using `df.applymap`

Using `df.replace`