3 ms·

This would require a reactive recomputing of cells to be anything like a spreadsheet. > Essentially, replace the excel formula `=B3-B4` with a Python function `

by afiori 8y ago

This would require a reactive recomputing of cells to be anything like a spreadsheet. > Essentially, replace the excel formula `=B3-B4` with a Python function `subtract(b3, b4)` as of now jupyter/ipython would not recompute `subtract(b3, b4)` if you change b3 or b4, this has positive and negative (reliance on hidden state and order of execution) effects. I too would really like something like this, but I think it is pretty far away from where jupiter is now.

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 ago
  OpenRefine/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 ago
    This 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.

by afiori 8y ago

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 ago
OpenRefine/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 ago
  This 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.