Support return the result as a pandas.DataFrame object

[litaotao]

Hi, I'm adding a feature on supporting return the sql result as a pandas.dataframe, I think this will make ipydb more powerful.

For now, ipydb is very useful for do ad-hoc both in console and ipython notebook, but people will take more actions on the result, which will almost use pandas, scipy, numpy, matplotlib in most cases, so I believe return a pandas.dataframe object will be much more useful and flexible.

what's more, it will be more clear if people just want to see the result for the display of dataframe is an excel table like style.

thanks, how do you guys think about this feature, I'm working on it now.

links:

• pandas
• pandas-dataframe-intro-step-1
• pandas in data analyst and data science, example

screenshots:

table style explore data

[jaysw]

Hello litaotao,

Thanks for your interest in ipydb!

Yes, I think this is a great idea.
ipydb was initially designed to only work with the ipython-consoIe (running in a terminal). I have been wanting to add support for viewing queries in the popular web-based ipython-notebook for some time now. Indeed using pandas dataframes for output provides a quick path to running ipydb queries in a notebook. I will take a look at your PR soon. Thanks again!

Jay.

[jaysw]

Fixed in #10