Replace free text in a dataframe with a empty string

Question

what's the best way to replace any string in a dataframe? The SPECIAL_NEEDS contains loads of free text and i cant delete the column/row as there is data in the other rows and columns. So i figured, why not just change the free text into a empty string '' I'm currently working with this but its throwing errors?

df['SPECIAL_NEEDS'] = df['SPECIAL_NEEDS'].str.replace(str, '', regex=True)

could you provide a sample data? it's not clear what the question is here — user7864386
– user7864386, Commented Feb 27, 2022 at 18:04

EliasK93 · Accepted Answer · 2022-02-27 14:34:13Z

1

What do you mean by free text? Any content should just be overwritten? In this case use:

df['SPECIAL_NEEDS'] = ""

Or just cases where the row value is a string?

answered Feb 27, 2022 at 14:34

EliasK93

3,1861 gold badge7 silver badges17 bronze badges

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

Collectives™ on Stack Overflow

Replace free text in a dataframe with a empty string

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related