# DataFrames: display in a Jupyter notebook

**URL:** <https://discourse.julialang.org/t/dataframes-display-in-a-jupyter-notebook/24411>\
**Category:** General Usage\
**Created:** [May 20, 2019, 5:15pm UTC](https://discourse.julialang.org/t/dataframes-display-in-a-jupyter-notebook/24411 "2019-05-20T17:15:27Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![BLI](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bli/32/37206_2.png) [@BLI](https://discourse.julialang.org/u/BLI)\
**Post date:** [May 20, 2019, 5:15pm UTC](https://discourse.julialang.org/t/dataframes-display-in-a-jupyter-notebook/24411/1 "2019-05-20T17:15:27Z")

</div>

I’d like to display all 9 columns of a DataFrame in Jupyter notebook, but the system decides to omit the 2 rightmost columns because it thinks there is a lack of space.

I know I can show all columns with the `show(dataframe, allcols=true)` construct, but the resulting table is less elegant than the one I get without using `show()`.

 ![image](https://global.discourse-cdn.com/julialang/original/3X/4/d/4da6638d3f02421bb0e99d65fc2ef833a6d4c75a.png)

Is there a way to overrule the system so that command `df[1:3,:]` shows all columns?

---

<div class="post-metadata">

**Author:** ![Mattriks](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/mattriks/32/351_2.png) [@Mattriks](https://discourse.julialang.org/u/Mattriks)\
**Post date:** [May 20, 2019, 5:26pm UTC](https://discourse.julialang.org/t/dataframes-display-in-a-jupyter-notebook/24411/2 "2019-05-20T17:26:47Z")

</div>

Try `ENV["COLUMNS"]=120`  
[https://github.com/JuliaLang/IJulia.jl#default-display-size](https://github.com/JuliaLang/IJulia.jl#default-display-size).

---

<div class="post-metadata">

**Author:** ![BLI](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/bli/32/37206_2.png) [@BLI](https://discourse.julialang.org/u/BLI)\
**Post date:** [May 20, 2019, 6:01pm UTC](https://discourse.julialang.org/t/dataframes-display-in-a-jupyter-notebook/24411/3 "2019-05-20T18:01:07Z")

</div>

Thanks, that did the trick!  
[Based on limited trial and error, I suspect the default is `ENV["COLUMNS"]=80`…, which reminds me of good old FORTRAN coding template sheets… that I used as a student to hand in hand-written FORTRAN code to the punchers… :-o ]

---

<div class="post-metadata">

**Author:** ![pdeffebach](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/pdeffebach/32/10320_2.png) [@pdeffebach](https://discourse.julialang.org/u/pdeffebach)\
**Post date:** [May 20, 2019, 7:48pm UTC](https://discourse.julialang.org/t/dataframes-display-in-a-jupyter-notebook/24411/4 "2019-05-20T19:48:16Z")

</div>

TableView.jl should work in IJulia. It enables (Lazy!) loading of DataFrames for infinite scrolling.

---

<div class="post-metadata">

**Author:** ![affans](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/affans/32/11911_2.png) [@affans](https://discourse.julialang.org/u/affans)\
**Post date:** [May 21, 2019, 12:28am UTC](https://discourse.julialang.org/t/dataframes-display-in-a-jupyter-notebook/24411/5 "2019-05-21T00:28:48Z")

</div>

How do you pass the HTML MIME type to `show` so that the HTML table is displayed in Jupiter? That should be a more elegant solution