Menu
I have searched for but have not found a solution to this:
Is there a way to create data within Jupyter Notebook, particularly tabular data in the form of a pandas DataFrame, via a spreadsheet-like interface as opposed to pd.DataFrame({a:[],b:[]})?
I don't mean read csv or XLwings as solutions, but rather a 'spreadsheet' in the notebook itself so that all information can be edited and stored in one place, and using it feels familiar to a more broad category of people.
Open to creative ideas.
Thanks,
380
Jupyter Notebooks have a range of widgets to make these kinds of changes more user-friendly, aesthetically pleasing, and intuitive. In addition to all these benefits, you will also learn UI concepts and test code that handles user input.
Saving a Jupter notebook Saving your edits is simple. There is a disk icon in the upper left of the Jupyter tool bar. Click the save icon and your notebook edits are saved.
To enter the EDIT mode, press ENTER on your keyboard or click in a cell. Edit mode can be identified by green border around the cell with green left margin. When you are in the edit mode, you can type in the cells.
Enable autocomplete feature To enable code autocomplete in Jupyter Notebook or JupyterLab, you just need to hit the Tab key while writing code. Jupyter will suggest a few completion options. Navigate to the one you want with the arrow keys, and hit Enter to choose the suggestion.
I have not used it myself, but it seems that https://github.com/quantopian/qgrid might fit the bill -- they say that the grid is editable as of v0.3.0.
53
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
