Python Pandas prevent line break in cell

Question

Using the following functions, I already managed to prevent truncation in the output in my notebook:

pd.set_option('display.max_colwidth', 200)
pd.set_option('display.max_columns', 0)

However, it still breaks long lines within some cells (not truncates!). How can I prevent it from doing that?

(I don't care how wide the total table will be, because I can simply scroll in the output of the notebook cell ...)

If you pass `-1` then there is no limit are you saying that you still have some columns with more than 200 characters? — EdChum, Aug 03 '16 at 14:16
Sorry, no all text is displayed but broken into multiple lines within one cell =( — Zelphir Kaltstahl, Aug 03 '16 at 14:22
@EdChum doesn't change anything, still line breaks in the cells — Zelphir Kaltstahl, Aug 03 '16 at 14:49

score 33 · Answer 1 · answered Aug 16 '17 at 08:55

33

for me worked pandas.set_option('display.expand_frame_repr', False) as suggested by @EdChum.

import pandas
matrix = [[None]*5]*4
matrix[1][1] = "Lorem ipsum dolor sit amet, consetetur sadipscing elitr, sed diam nonumy eirmod tempor invidunt ut"
matrix[1][4] = matrix[1][1]
print pandas.DataFrame(matrix) # will print the matrix,
# column 4 is completely underneath the other 3 columns with all rows


pandas.set_option('display.expand_frame_repr', False)
print pandas.DataFrame(matrix) # prints only one table (no break of columns)

answered Aug 16 '17 at 08:55

Zian

559
4
16

1

Note that it works in `with pd.option_context(...)` as well. – Pierre D May 30 '20 at 03:04
Doesn't work in Jupyter 1.0.0, pandas 1.4.3, python 3.8. – Leo Aug 26 '22 at 08:33

score 5 · Answer 2 · answered Jul 21 '18 at 05:56

This worked for me, I'm using python 2.7, and tested it with 3.6 on the Pycharm IDE.

try:
    df = pd.read_excel(file,sheet_name="sheet", inplace=True, usecols="A,C:E")

    with pd.option_context('display.max_rows', 300, 'display.max_columns', 7, 'display.expand_frame_repr', False):
        print(df)

except:
    print ('failed')

However, for the Jupyter Notebooks, I believe this is the syntax:

pd.options.display.max_rows

pd.set_option('display.max_colwidth', -1)

pd.DataFrame({'string_x': string_x}, index = [0])

score 1 · Answer 3 · answered Feb 19 '22 at 08:59

None of the solutions here worked in jupyter for me, what worked was appealing to CSS:

from IPython.display import HTML
HTML(f"<style>td{white-space: nowrap !important;}</style>")

I've not tested but this may work too:

df.style.set_table_styles([{'selector': 'td', 'props': 'white-space: nowrap !important;'}])

Python Pandas prevent line break in cell

3 Answers3

Linked