[FIXED] Turn off abbreviations in Jupyter Notebook output?

Issue

I am quite new to using Jupyter. I came across a rather annoying little thing in Jupyter: abbreviations. I have a rather large - but not enormous - pandas dataframe. I would like to get some insights ont the missing structure. However, running df_total.isnull().sum() returns a list that is abbreviated with ...(see below).

roe_before_tax_1               1101
roe_before_tax_2               1165
roce_before_tax_0              1009
roce_before_tax_1              1050
roce_before_tax_2              1115
                               ... 
revenue_by_fte_2                689
personell_cost_by_revenue_0    1144
personell_cost_by_revenue_1    1187
personell_cost_by_revenue_2    1271

Is there any way to get rid of that and to see the full output? Thanks! /R

Solution

Use pd.options.display.max_rows = 2000 (or pd.set_option("max_rows",2000) - use whichever you prefer!) Substitute 2000 for some number larger than the number of rows you want to display.

There's another option max_columns if you encounter the same problem with columns instead

Answered By - Louise Davies