Printing 2 Python Pandas DataFrame in HTML Tables in iPython Notebook

5
votes

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()
1
pythonpandasipythonipython-notebook
Are you wanting the bottom answer here: stackoverflow.com/questions/28966780/… if so I'll close as duplicate - EdChum
df.head(), df2.head() - Benjamin Rowell
or you can use print - joris
@joris print df.head() doesnt produce a pretty table - Nyxynyx
or from IPython.display import display, and then use display(df.head()) - joris

1 Answers

4
votes

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