[IPython-dev] Integrating a JS grid control with ipython notebook?

[Joris Van den Bossche]

2013/12/20 Thomas Kluyver <takowl at gmail.com>

>
> On 19 December 2013 15:39, Patrick Surry <patrick.surry at gmail.com> wrote:
>
>> One of the things that would make pandas even more awesome(!) for me in
>> the ipython notebook would be if I could display wide/long tables in a more
>> flexible way than static html with horizontal and vertical scrollbars.
>>  (Then maybe a pivot table/chart widget :-)
>>
>> It seems like there are tons of JS grid controls out there - has anyone
>> experimenting with rendering a pandas dataframe into a bit of interactive
>> JS?   I've had a little experience with the google charts table
>> visualization tho it isn't super flexible.
>>
>> I'd be willing to hack on it if someone could give me some "getting
>> started" pointers.
>>
>
> I don't know of anyone who's looked into that, but I agree it would be
> neat.
>
> There are two possible approaches, I think:
>
> First, you could spice up the HTML repr (e.g. to allow sorting/filtering
> columns, hiding parts of the table, etc.), but still keep all the data in
> the display. This would be relatively easy - you just need to copy a
> DataFrame's to_html() method and add a reference to some JS.
>
> Second, you could use the new widget stuff (
> https://github.com/ipython/ipython/pull/4374 ) to communicate between the
> table view and the DataFrame. This would be considerably trickier, but it
> would allow you to work with very large data frames, because you don't have
> to send all the data to the frontend at once. It could also enable two-way
> communications, so you could edit the DataFrame from the table view.
>

This could maybe of interest:

Javascript grid UI for pandas Dataframes:
https://github.com/pydata/pandas/issues/2974
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ipython-dev/attachments/20131220/a212e25a/attachment.html>