Show DataFrame as table in iPython Notebook

Question

I am using iPython notebook. When I do this:

df

I get a beautiful table with cells. However, if i do this:

df1
df2

it doesn't print the first beautiful table. If I try this:

print df1
print df2

It prints out the table in a different format that spills columns over and makes the output very tall.

Is there a way to force it to print out the beautiful tables for both datasets?

display(df) (with from IPython.display import display), or print df.to_html() — joris
– joris, Commented Nov 11, 2014 at 22:48
@joris, your comment seems to answer the question, so could you perhaps post it as an answer, so that the question doesn't remain unanswered? — Cristian Ciupitu
– Cristian Ciupitu, Commented Jan 11, 2015 at 3:37

Harmon · Accepted Answer · 2018-02-08 01:39:51Z

574

You'll need to use the HTML() or display() functions from IPython's display module:

from IPython.display import display, HTML

# Assuming that dataframes df1 and df2 are already defined:
print "Dataframe 1:"
display(df1)
print "Dataframe 2:"
display(HTML(df2.to_html()))

Note that if you just print df1.to_html() you'll get the raw, unrendered HTML.

You can also import from IPython.core.display with the same effect

edited Feb 8, 2018 at 1:39

Harmon

4,5092 gold badges21 silver badges16 bronze badges

answered Apr 16, 2015 at 4:39

emunsing

10k4 gold badges26 silver badges29 bronze badges

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

8 Comments

Cina Over a year ago

Is it possible to ask python to automatically open browser and show HTML(df2.to_html()) ?

nealmcb Over a year ago

@Cina You should be able to write the HTML to a file, and then call your favorite browser on that file, but how to do so depends a lot on the system you're on, the browser, etc.

alyaxey Over a year ago

HTML(df2.to_html()) does nothing. You should do display(HTML(df2.to_html())) to render the dataframe. I tried to edit your answer but somehow it was rejected.

joel Over a year ago

on version 5.6.0 you don't need to import display

Peter.k Over a year ago

How to deal with concatenated strings? For example to get all text from text columns.

|

nbro · Accepted Answer · 2018-12-03 16:37:55Z

70

from IPython.display import display
display(df)  # OR
print df.to_html()

edited Dec 3, 2018 at 16:37

nbro

16.1k34 gold badges122 silver badges219 bronze badges

answered Feb 13, 2015 at 19:28

JacobWuzHere

9137 silver badges12 bronze badges

2 Comments

mayank Over a year ago

As stated by @emunsing, .to_html() doesn't work, it gives unrendered html table.

Arnab Biswas Over a year ago

Don't need to import display any more. Just display(df) works.

Jonny Brooks · Accepted Answer · 2017-04-11 14:30:53Z

52

This answer is based on the 2nd tip from this blog post: 28 Jupyter Notebook tips, tricks and shortcuts

You can add the following code to the top of your notebook

from IPython.core.interactiveshell import InteractiveShell
InteractiveShell.ast_node_interactivity = "all"

This tells Jupyter to print the results for any variable or statement on it’s own line. So you can then execute a cell solely containing

df1
df2

and it will "print out the beautiful tables for both datasets".

edited Apr 11, 2017 at 14:30

answered Feb 22, 2017 at 13:26

Jonny Brooks

3,3083 gold badges22 silver badges22 bronze badges

2 Comments

ions me Over a year ago

is there a way to suppress output though, if you don't want everything showing? Like ideally, putting a semicolon at the end would prevent a print.

Jonny Brooks Over a year ago

@IonSme If you put a semicolon at the end of the last line then I think it suppresses all output, otherwise I don't think it suppresses any output. If you want to suppress output of a variable then you just don't put the variable on its own line. What scenarios would you want to suppress output of some variables but still have them on their own line?

Shital Shah · Accepted Answer · 2019-03-04 06:27:25Z

20

I prefer not messing with HTML and use as much as native infrastructure as possible. You can use Output widget with Hbox or VBox:

import ipywidgets as widgets
from IPython import display
import pandas as pd
import numpy as np

# sample data
df1 = pd.DataFrame(np.random.randn(8, 3))
df2 = pd.DataFrame(np.random.randn(8, 3))

# create output widgets
widget1 = widgets.Output()
widget2 = widgets.Output()

# render in output widgets
with widget1:
    display.display(df1)
with widget2:
    display.display(df2)

# create HBox
hbox = widgets.HBox([widget1, widget2])

# render hbox
hbox

This outputs:

edited Mar 4, 2019 at 6:27

answered Mar 4, 2019 at 6:11

Shital Shah

69.9k21 gold badges258 silver badges202 bronze badges

Comments

Hossein SLT · Accepted Answer · 2020-03-31 01:09:29Z

17

In order to show the DataFrame in Jupyter Notebook just type:

   display(Name_of_the_DataFrame)

for example:

  display(df)

answered Mar 31, 2020 at 1:09

Hossein SLT

1711 silver badge2 bronze badges

Comments

Moondra · Accepted Answer · 2017-04-14 23:04:13Z

It seems you can just display both dfs using a comma in between in display. I noticed this on some notebooks on github. This code is from Jake VanderPlas's notebook.

class display(object):
    """Display HTML representation of multiple objects"""
    template = """<div style="float: left; padding: 10px;">
    <p style='font-family:"Courier New", Courier, monospace'>{0}</p>{1}
    </div>"""
    def __init__(self, *args):
        self.args = args

    def _repr_html_(self):
        return '\n'.join(self.template.format(a, eval(a)._repr_html_())
                     for a in self.args)

    def __repr__(self):
        return '\n\n'.join(a + '\n' + repr(eval(a))
                       for a in self.args)

display('df', "df2")

Mokhamad Arfan Wicaksono · Accepted Answer · 2021-09-06 03:52:02Z

5

You can use markdown to create a table. You'll be asked to install tabulate package first if it is not yet available.

from IPython.display import display, Markdown

display(Markdown(df.to_markdown()))

answered Sep 6, 2021 at 3:52

Mokhamad Arfan Wicaksono

3254 silver badges7 bronze badges

1 Comment

jxmorris12 Over a year ago

This approach almost never works right for me. HTML(df.to_html()) properly escapes characters, markdown doesn't.

Kim · Accepted Answer · 2021-05-20 07:20:24Z

4

To display dataframes contained in a list:

dfs = [df1, df2]
display(*dfs)

edited May 20, 2021 at 7:20

Kim

1,5153 gold badges19 silver badges26 bronze badges

answered Jan 6, 2020 at 11:01

BSalita

9,07111 gold badges59 silver badges75 bronze badges

4 Comments

Kim Over a year ago

This displays the column/header names only, which is not what the OP asked for. Instead, they wanted the whole DataFrame to be printed in a nice format. So display(df) or display(HTML(df2.to_html())) for wider dataframes is the correct and accepted answer.

BSalita Over a year ago

@Kim Please reread my answer. If you still don't believe it, verify it with code. I stand by my answer.

Kim Over a year ago

apologies for the confusion. I did overlook the "contained in a list" part of your answer. So you are right, your example works with dfs being a list of dataframes. I suggest to update your code example accordingly, to make this stand out in the code as well. Especially since this is the extra value you bring to the discussion. I am more than happy to change my vote then.

BSalita Over a year ago

It is common to not fully read answers. I've done that myself. Maybe as many as 40% of comments are misunderstandings.

Muhammad Yasirroni · Accepted Answer · 2022-09-22 03:40:11Z

3

From my other answer,

if you want to using option, you can use context manager combining the display:

from IPython.display import display

with pd.option_context('precision', 3):
    display(df1)
    display(df2)

answered Sep 22, 2022 at 3:40

Muhammad Yasirroni

2,29620 silver badges24 bronze badges

Comments

Ultra · Accepted Answer · 2025-02-13 18:08:37Z

0

using spark 3.5.4 the following displays a table in pretty print. df is a spark data frame.

import pandas as pd

df.toPandas()

answered Feb 13 at 18:08

Ultra

1011 silver badge8 bronze badges

Collectives™ on Stack Overflow

Show DataFrame as table in iPython Notebook

10 Answers 10

8 Comments

2 Comments

2 Comments

Comments

Comments

Comments

1 Comment

4 Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

10 Answers 10

8 Comments

2 Comments

2 Comments

Comments

Comments

Comments

1 Comment

4 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related