Currently pd.read_excel
only allows reading in DataFrame
s. To read a Panel back in (after pnl.to_excel(fl)
) one has to loop over the sheets.
Comment From: jreback
I suppose this is possible (e.g. reading multiple sheets) and then concatting to a Panel, but this only really makes sense if you want aligned data. How many people keep a 2-d repr of their 3-d data in excel?
Comment From: jreback
closing as Panel deprecated