Printing 2 Python Pandas DataFrame in HTML Tables in iPython Notebook

Question

Question: How can you print 2 DataFrame tables together from 1 iPython Notebook row, such that both tables are displayed in the pretty table format?

The following prints just the second one, and print df.head() does not produce a pretty table.

df = pd.DataFrame(np.random.randn(6,4), index=pd.date_range('20150101', periods=6), columns=list('ABCD'))
df2 = pd.DataFrame(np.random.randn(6,4), index=pd.date_range('20150101', periods=6), columns=list('WXYZ'))


df.head()
df2.head()

enter image description here

The following does not produce the pretty table needed:

print df.head()
print df2.head()

Are you wanting the bottom answer here: stackoverflow.com/questions/28966780/… if so I'll close as duplicate — EdChum
– EdChum, Commented May 1, 2015 at 15:27
or from IPython.display import display, and then use display(df.head()) — joris
– joris, Commented May 1, 2015 at 15:34

joris · Accepted Answer · 2015-05-01 15:41:32Z

5

In the IPython notebook, only the result of the last line of a cell is shown, unless it is explicitly printed or displayed.

Some options:

Put the second df.head() in the next cell
Use print df to explicitly print the dataframe -> but, this gives the text representation instead of html representation
Use display(df) to explicitly display the dataframe, this will give the same html representation as how a dataframe is shown by default. You need the following import for this:
```
from IPython.display import display
```

answered May 1, 2015 at 15:41

joris

140k37 gold badges257 silver badges207 bronze badges

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

Collectives™ on Stack Overflow

Printing 2 Python Pandas DataFrame in HTML Tables in iPython Notebook

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related