Remove substring from entire Pandas DataFrame

Question

I have a Pandas DataFrame with three columns and every string in these columns ends with '\n'

Example:

test\n | abc\n | 123\n

Now, I want to get rid of these '\n' and achieve:

test | abc | 123

I only find solutions where substrings are removed from certain columns, but I want to remove this substring from the entire DataFrame

I would therefore be very happy if someone had a solution to my problem.

Thank you very much in advance for your help!

mozway · Accepted Answer · 2022-03-02 12:18:32Z

3

Use:

df = df.apply(lambda s: s.str.strip())

To limit to a list of columns:

# cols = ['col1', 'col2']
df[cols] = df[cols].apply(lambda s: s.str.strip())

answered Mar 2, 2022 at 12:18

mozway

267k13 gold badges56 silver badges106 bronze badges

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

3 Comments

RKF Over a year ago

Thank you, your approach worked very well! Since I also got some "\n" inside some strings I slightly modified your solution from: df = df.apply(lambda s: s.str.strip()) to: df = df.apply(lambda s: s.str.replace("\n",""))

mozway Over a year ago

@RKF yes sure, I thought this was only for the final '\n' ;)

Luis Felipe Over a year ago

Is it needed to use index = True or something like that? It's not working for me.

Collectives™ on Stack Overflow

Remove substring from entire Pandas DataFrame

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related