Skip to content

Instantly share code, notes, and snippets.

@rossant
Created March 10, 2014 12:08
Show Gist options
  • Star 16 You must be signed in to star a gist
  • Fork 2 You must be signed in to fork a gist
  • Save rossant/9463955 to your computer and use it in GitHub Desktop.
Save rossant/9463955 to your computer and use it in GitHub Desktop.
Excel-like data grid editor for Pandas in the IPython notebook with Handsontable
Display the source blob
Display the rendered blob
Raw
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@rdhyee
Copy link

rdhyee commented Mar 31, 2014

I did a slight rewrite of your notebook to avoid having to change my IPython profile: https://gist.github.com/rdhyee/9897356

@Who8MyLunch
Copy link

I believe the Handsontable package supports inserting rows and columns. Is it at all feasible to expose this functionality in Python?

@mgaitan
Copy link

mgaitan commented May 6, 2014

Cyrille are you planning to continue this? I would like to help. let me know

@mkeller-upb
Copy link

An interactive tabular widget would be awsome helpful. Some frequently used task/operations are done way faster by clicking instead of writing df[df.x >= 3][['x','y']].sort... : (Un)Folding/Hiding columns, sorting, slice rows.
Editing features could range from single cell editing to selected cells are simultaniously edited (same value), or a kind of autofill of cells.
More viewing features would be even more useful, like filtering rows via checkbox for each unique column value, custom lambda expression (*).
Very very large tables should also be handled, e.g. by support scrolling; such tables need to be processed (filtered) to be easier to handle.

Does anyone know related efforts?

Would like to contribute, know how python works, no clue about java script and packages/framework for interactive widgets.

@markolopa
Copy link

Hello, has someone managed to make this run on ipython 4? I am running into issues on javascript both with the original notebook and with the one from rdhyee.

@rossant
Copy link
Author

rossant commented Dec 15, 2015

see the more recent "qgrid" project: https://github.com/quantopian/qgrid

@shobhitverma
Copy link

shobhitverma commented Dec 15, 2015

qgrid doesnt let you change data.
(It does, I only realised after double clicking)

@kierancondon
Copy link

This is a great idea and should definitely exist.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment