2 ms·
How to write functions in JS / VB script and call them from a cell expression. How to name variables something other than AB3. How to use physical units and d
by westurner 6y ago
How to write functions in JS / VB script and call them from a cell expression.
How to name variables something other than AB3.
How to use physical units and datatypes. (How to specify XSD datatype URIs that map to native primitives in an additional frozen header row. e.g. py-moneyed and Pint & NumPy ufuncs)
How transitive sort works (is there a tsort to determine what to calculate first (and whether there are cycles) on every modification event?)
Which Jupyter platforms do and don't support interactive charts with e.g. ipywidgets?
pandas.df.plot(kind=) (matplotlib), seaborne (what are the calculated parameters of this chart?), holoviews, plotly, altair
Reproducibility w/ repo2docker / BinderHub:
pip freeze > constraints.txt
cp constraints.txt requirements.txt
conda env export --from-history
- etothepii 6y agoInteresting, your suggestion is that the first thing to do is to learn how to make functions and variable names within excel?
- westurner 6y agoYeah if you port it to functions and verify that you haven't broken anything, you could then easily port to Python functions that you could call from Excel with an add-on that everyone that opens the sheet needs to have installed; but everyone that opens a sheet that calls Python must have that same extension (and all python package dependencies) installed, too
- westurner 6y agoAlso, When is it better to have code in a notebook instead of in a module? How to export notebook cells to a module with nbdev How to write tests to assert the quality of the code and the model: @pytest.mark.parametrize, pytest-notebook, jupyter-pytest-2, pytest-jupyter When is it appropriate to parametrized a notebook with e.g. papermill? How to handle concurrency: dask.distributed + dask-labextension, ipyparallel