Display multiple output tables in IPython notebook using Pandas

Question

I now know that I can output multiple charts from IPython pandas by embedding them in one plot space which will appear in a single output cell in the notebook.

Can I do something similar with Pandas HTML Tables?

I am getting data from multiple tabs (about 15-20) on a spreadsheet and running them though a set of regressions and I'd like to display the results together, perhaps 2 up.. But since the function to display the table only displays one, the last one, not sure how to approach. Ideas?

I'd even be happy to display in successive output cells.. not real sure how to do that either But I guess I could do something really dirty calling each (spreadsheet) tab in a separate cell.. Ughh... FWIW I'm on IPython 2.0 dev and Pandas 13

Is IPython.display.display(table) what you're after? i.e. call it once per table, it should show them all in the output. — Thomas K
– Thomas K, Commented Jan 18, 2014 at 19:06

dartdog · Accepted Answer · 2014-01-20 15:32:37Z

3

This does it:

area-tabs=list(map(str, range(1, 28))) # for all 27 tabs
#area_tabs=['1','2'] # for specific tabs
for area_tabs in area_tabs:
    actdf,aname = get_data(area_tabs) #get_data gets the data and does a bunch or regression and table building
    aname,actdf,merged2,mergederrs,montdist,ols_test,mergedfcst=projections(actdf)
    IPython.display.display('Area: %s' % aname, mergederrs.tail(12))
    IPython.display.display('Area: %s' % aname, ols_test)
    IPython.display.display('Area: %s' % aname, merged2)

SO I can print all the results for each tab on the spreadsheet

edited Jan 20, 2014 at 15:32

answered Jan 19, 2014 at 21:58

dartdog

10.9k22 gold badges75 silver badges122 bronze badges

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

1 Comment

Phillip Cloud Over a year ago

FYI You can create those tab numbers like this: list(map(str, range(1, 28))).

Collectives™ on Stack Overflow

Display multiple output tables in IPython notebook using Pandas

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related