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?

Answer 1

Here, you 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()))