3 ms·
You can build something like this with Jupyter today. > Traitlets is a framework that lets Python classes have attributes with type checking, dynamically calcu
by westurner 8y ago
You can build something like this with Jupyter today.
> Traitlets is a framework that lets Python classes have attributes with type checking, dynamically calculated default values, and ‘on change’ callbacks.
https://traitlets.readthedocs.io/en/stable/ https://traitlets.readthedocs.io/en/stable/
> Traitlet events.
Widget properties are IPython traitlets and traitlets are eventful. To handle changes, the observe method of the widget can be used to register a callback
https://ipywidgets.readthedocs.io/en/stable/examples/Widget%20Events.html#Traitlet-events https://ipywidgets.readthedocs.io/en/stable/examples/Widget%...
You can definitely build interactive notebooks with Jupyter Notebook and JupyterLab (and ipywidgets or Altair or HoloViews and Bokeh or Plotly for interactive data visualization).
> Qgrid is a Jupyter notebook widget which uses SlickGrid to render pandas DataFrames within a Jupyter notebook. This allows you to explore your DataFrames with intuitive scrolling, sorting, and filtering controls, as well as edit your DataFrames by double clicking cells.
https://github.com/quantopian/qgrid https://github.com/quantopian/qgrid
Qgrid's API includes event handler registration:
https://qgrid.readthedocs.io/en/latest/ https://qgrid.readthedocs.io/en/latest/
> neuron is a robust application that seamlessly combines the power of Visual Studio Code with the interactivity of Jupyter Notebook.
https://marketplace.visualstudio.com/items?itemName=neuron.neuron-IPE https://marketplace.visualstudio.com/items?itemName=neuron.n...
"Excel team considering Python as scripting language: asking for feedback" (2017)
https://news.ycombinator.com/item?id=15927132 https://news.ycombinator.com/item?id=15927132
OpenOffice Calc ships with Python 2.7 support:
https://wiki.openoffice.org/wiki/Python https://wiki.openoffice.org/wiki/Python
Procedural scripts written in a general purpose language with named variables (with no UI input except for chart design and persisted parameter changes) are reproducible.
What's a good way to review all of the formulas and VBA and/or Python and data ETL in a spreadsheet?
Is there a way to record a reproducible data transformation script from a sequence of GUI interactions in e.g. OpenRefine or similar?
- westurner 8y agoOpenRefine/OpenRefine/wiki/Jupyter "Within the Python context, a Python OpenRefine client allows a user to script interactions within a Jupyter notebook against an OpenRefine application instance, essentially as a headless service (although workflows are possible where both notebook-scripted and live interactions take place. https://github.com/OpenRefine/OpenRefine/wiki/Jupyter https://github.com/OpenRefine/OpenRefine/wiki/Jupyter Are there data wrangling workflows that are supported by OpenRefine but not Pandas, Dask, or Vaex?
- rmbeard 8y agoThis interesting need to have a closer look, possibly refine can be more efficient? But haven't used it enough to know, just payed around with it a bit. Didn't realise you could combine it with jupyter.