add / remove rows without having to reset the whole datagrid

[jgunstone]

Is your feature request related to a problem? Please describe.
When using Datagrid as a UI object, I'm often required to allow users to add or remove rows. Currently the only way that I know to do this is to reset the .data object recreating all of the data in the grid. For large grids this is slow, and it resets the view which is confusing to the user.

Describe the solution you'd like
Similar to the set_cell_value method, we'd like delete_row and add_row methods that make edits to the self._data object and the grid frontend in-place and then self._notify_cell_change or similar to register the change. The hope would be that by not having to reset the whole grid there is a speed improvement and that it can happen "in-place" without resetting the view of the grid.

Describe alternatives you've considered

• overwriting the whole grid as described above.
• had considered leaving some empty rows at the bottom of the table which would allow more to use the set_cell_value to move data around in the grid instead, but this feels very hacky

[jgunstone]

maybe linked:
#6

[jgunstone]

#438 looks good and is defo very useful... but I'm not sure that it resolves this issue... (re-reading my description could have been clearer)

the issue we are having is if we want to change the shape of the dataframe (i.e. adding or removing a row), that requires resetting the whole grid... it would be great if rows could be added or removed "in-place"

[martinRenou]

Sorry, I indeed closed this issue too quickly!

I had a branch on my local clone for the add_row feature. I just pushed it on my fork: https://github.com/martinRenou/ipydatagrid/tree/add_row I don't think this is completely ready yet. It needs more proper testing etc. Also I've not looked into remove rows yet.

I probably got confused in the different issues when I closed this one 😁

[jobinnthomas]

I am running into the same problem. Every time i update the .data with a new dataframe, the column width setting of the original datagrid gets lost and probably other things as well(my code is not that complex, just sets up a basic ipydatagrid. Is there a way to fix this by adding the function add_row or any other way to fix this?