Prevent line break in pandas column

Asked Mar 13 '20 at 18:15

Active Mar 13 '20 at 18:27

Viewed 1,240 times

I have a pandas dataframe imported by pd.read_excel().

When a show it some chacarcters in a cell are printed with breaks like that:

I have used set_option but still show columns with breaks:

pd.set_option('display.max_columns', None)
pd.set_option('display.expand_frame_repr', False)
pd.set_option('max_colwidth', -1)

Is there another way to show the entire text in a cell without breaks?

edited Mar 13 '20 at 18:27

realr

asked Mar 13 '20 at 18:15

Bruce Lourenço

Please avoid images in the question. – Sajan Mar 13 '20 at 18:21
Do you want the newlines removed from the dataframe itself or just when printing. Replacing as in this question should work https://stackoverflow.com/questions/44227748/removing-newlines-from-messy-strings-in-pandas-dataframe-cells. Its likely this is a dup. – tdelaney Mar 13 '20 at 18:26
@Sajan the image itself show the behavior I have working on. – Bruce Lourenço Mar 13 '20 at 18:50
@tdelaney I want to show the entire text in cell without break line like this: AMÉRICO BRASILIENSE – Bruce Lourenço Mar 13 '20 at 18:56
Right. I asked whether you want to modify the dataframe itself. – tdelaney Mar 13 '20 at 19:10
1

`df.replace("\\n", " ", regex=True, inplace=True)` – tdelaney Mar 13 '20 at 19:15
@tdelaney Oh now I understand you. Yes, no problem to change the dataframe. I will test and answer here. Thanks – Bruce Lourenço Mar 13 '20 at 19:44
The solution you proposed on your quesion solved my problem, so thanks I guess :^D – Marcelo Lacerda Nov 24 '22 at 14:31

0 Answers0