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

User · Answer

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".

User · Answer

from IPython display import display display df     OR print df to html

User · Answer

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

User · Answer

In order to show the DataFrame in Jupyter Notebook just type       display Name of the DataFrame    for example      display df

User · Answer

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       lt div style  float  left  padding  10px   gt       lt p style  font-family  Courier New   Courier  monospace  gt  0  lt  p gt  1       lt  div gt         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

User · Answer

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

User · Answer

To display dataframes contained in a list   display  dfs

[pandas] Show DataFrame as table in iPython Notebook

Examples related to pandas

Examples related to printing

Examples related to ipython-notebook

Examples related to jupyter-notebook

Examples related to display