displaying embedded newlines in a text column of a Pandas DataFrame

Question

I am trying to display a DataFrame with a mutiline text column (eg code snippet) in a Jupyter notebook:

IPython.display.display(df)

Unfortunatelly this does not respect the newlines in the text and turns each cell into a wall of text.

How can I display a dataframe with linebreaks within text cells preserved?

Possible duplicate of Pretty printing newlines inside a string in a Pandas DataFrame — Georgy
– Georgy, Commented Nov 23, 2018 at 11:47

yongjieyongjie · Accepted Answer · 2019-07-04 05:53:54Z

12

Using pandas `.set_properties()` and CSS `white-space` property

My preferred way is to use pandas's pandas.io.formats.style.Styler.set_properties() method and the CSS "white-space": "pre-wrap" property:

from IPython.display import display

# Assuming the variable df contains the relevant DataFrame
display(df.style.set_properties(**{
    'white-space': 'pre-wrap',
})

To keep the text left-aligned, you might want to add 'text-align': 'left' as below:

from IPython.display import display

# Assuming the variable df contains the relevant DataFrame
display(df.style.set_properties(**{
    'text-align': 'left',
    'white-space': 'pre-wrap',
})

edited Jul 4, 2019 at 5:53

answered Jul 4, 2019 at 5:41

yongjieyongjie

90310 silver badges20 bronze badges

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

1 Comment

Daniel Mahler Over a year ago

That looks great. I need to rry it out

Peter Leimbigler · Accepted Answer · 2018-04-05 03:45:18Z

5

Try @unsorted's answer to this question:

from IPython.display import display, HTML
def pretty_print(df):
    return display( HTML( df.to_html().replace("\\n","<br>") ) )

answered Apr 5, 2018 at 3:45

Peter Leimbigler

11.1k1 gold badge27 silver badges39 bronze badges

1 Comment

Daniel Mahler Over a year ago

Thanks! That does solve the newline problem, but it makes all the text lines right-justified again. I am currently using Styling (pandas.pydata.org/pandas-docs/stable/style.html) to force left justification. Is there a way to make the cells left justified with .to_html()? I see a way to make column headers left-justified, but not body cells.

Collectives™ on Stack Overflow

displaying embedded newlines in a text column of a Pandas DataFrame

2 Answers 2

Using pandas `.set_properties()` and CSS `white-space` property

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Using pandas .set_properties() and CSS white-space property

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related

Using pandas `.set_properties()` and CSS `white-space` property