Remove \n from list of values within a pandas columns

[klllmmm]

I want to replace all \n within pandas dataframe with space.

1 2 3 4

import pandas as pd table = pd.DataFrame(data = {'ClientID':[100,102,103],                              'Category':['A','Category\nZ',['Non\nCategory A','']],                              'Income':[800,900,[1000,2000]],},)

I tried with the following code. However, I couldn't replace \n within the list values in the columns.

1	table = table.replace(r'\n',  ' ', regex=True)

Output:
Out[400]: 
              Category  ClientID        Income
0                    A       100           800
1           Category Z       102           900
2  [Non\nCategory A, ]       103  [1000, 2000]

Appreciate if someone can help on this.

[Clunk_Head]

1	(r'\\n',  ' ', regex=True)

You need to escape the backslash.
Check out regex101.com to test out your regex.

[klllmmm]

(r'\\n',  ' ', regex=True)

Thanks for the reply.

It didn't work as I intended.

1	table = table.replace(r'\\n',  ' ', regex=True)

Output:
table
Out[403]: 
              Category  ClientID        Income
0                    A       100           800
1          Category\nZ       102           900
2  [Non\nCategory A, ]       103  [1000, 2000]