4

I'm trying to print a df in ipython notebook but it doesn't print it as a table. 

data = {'year': [2010, 2011, 2012, 2011, 2012, 2010, 2011, 2012],
        'team': ['Bears', 'Bears', 'Bears', 'Packers', 'Packers', 'Lions', 'Lions', 'Lions'],
        'wins': [11, 8, 10, 15, 11, 6, 10, 4],
        'losses': [5, 8, 6, 1, 5, 10, 6, 12]}
football = pd.DataFrame(data, columns=['year', 'team', 'wins', 'losses'])

print football

Output

   year     team  wins  losses
0  2010    Bears    11       5
1  2011    Bears     8       8
2  2012    Bears    10       6
3  2011  Packers    15       1
4  2012  Packers    11       5
5  2010    Lions     6      10
6  2011    Lions    10       6
7  2012    Lions     4      12

I tried "display" as suggested Show DataFrame as table in iPython Notebook:

from IPython.display import display
#.....
print display(football)

Also tried:

pandas.core.format.set_printoptions(notebook_repr_html=True)

but got error:

AttributeError: 'module' object has no attribute 'set_printoptions'

How can I print my df as a table with nice vertical and horizontal lines?

Community
  • 1
  • 1
Boosted_d16
  • 13,340
  • 35
  • 98
  • 158

1 Answers1

10

set_printoptions has been replaced by set_options in the more recent versions of pandas, try to use:

pandas.set_option('display.notebook_repr_html', True)

Also do not use print, simply state football or display(football) in the last line of a notebook cell.

joris
  • 133,120
  • 36
  • 247
  • 202
Marcel Stimberg
  • 415
  • 3
  • 9
  • Thanks, I had to simply state "football" in a new cell, a bit odd? but it works. – Boosted_d16 Jan 06 '15 at 15:37
  • 1
    `notebook_repr_html` defaults to `True` so you shouldn't need to set it. – ari Jan 06 '15 at 17:27
  • 1
    Python will always try to represent the last thing that was output with a default display, that's why `football` by itself or at the end of a cell works. – ari Jan 06 '15 at 17:33