How to get a vertical scrollbar in HTML output from Jupyter notebooks

Question

When running the following code in Jupyter Notebooks using an excel with 500 rows:

import pandas as pd
pd.set_option('display.min_rows', 50)
pd.set_option('display.max_rows', 50)
df = pd.read_excel('test.xlsx', sheet_name=0)
display(df)

I can click on the left side of the output to get a vertical scrollbar on the output window. When I export this notebook either via nbconvert or the build in "download as; HTML" I just get the 50 rows of data and no vertical scrollbar. Is there any way to keep the dataframe small (In the end I would like to show all 500 rows in an output window with a scrollbar)

HTML table in Jupyter
HTML table in export

So you get some HTML? Did you check if your missing rows are actually in there? — Jongware, Jan 29 '20 at 22:17
I might not have explained it correctly, I've added pictures of what it looks like in the notebook and the export. — StevenV, Jan 30 '20 at 07:30

score 2 · Answer 1 · answered Jan 30 '20 at 10:41

2

I managed to insert CSS with help from this blog post: http://damianavila.github.io/blog/posts/mimic-the-ipython-notebook-cell-execution.html

in this way I could insert:

overflow-y: scroll;
    max-height: 500px;

in all the output cells

answered Jan 30 '20 at 10:41

StevenV

21
1
3

4

where did you add the CSS? – ShahNewazKhan Feb 20 '20 at 00:32

How to get a vertical scrollbar in HTML output from Jupyter notebooks

1 Answers1

Linked