Replace a special character with a new line within same row in pandas

Asked Sep 14 '19 at 12:30

Active Sep 15 '19 at 11:34

Viewed 14 times

We have a character | in one of the columns in a pandas dataframe which needs to be replaced with a new line within the same columns.

I tried using replace which doesn't seem to give the expected output.

import pandas as pd
df = pd.DataFrame(['sample || text | needs replacement'] , columns=['text'])
df.text.str.replace('|' , '\n')

# Gives sample \n\n text \n needs replacement

# Expected output 

"""sample 

text 
needs replacement
"""
print(len(df['text'])) #1

edited Sep 15 '19 at 11:34

asked Sep 14 '19 at 12:30

gr.kr

Since pandas `0.25.0` we have a new function for this called `explode`, you can use: `df['text'].str.split('|').explode()` – Erfan Sep 14 '19 at 12:33
Thanks @Erfan , Do we have any other methods to tackle this problem with pandas 0.23.0 – gr.kr Sep 14 '19 at 12:38
There are some custom functions in the linked answer which you can use. But I would recommend to update your pandas and simply use the line of code which I provided – Erfan Sep 14 '19 at 12:40
Thanks @Erfan , explode() is creating multiple rows. Is it possible to have new lines within the same row? – gr.kr Sep 14 '19 at 12:42
Why would you want to do that? – Erfan Sep 14 '19 at 12:47
We have requirement to have so. – gr.kr Sep 14 '19 at 13:02
@Erfan , could you please remove this as duplicate. – gr.kr Sep 14 '19 at 15:20

Replace a special character with a new line within same row in pandas

0 Answers0