mito
mito copied to clipboard
mito-ds
Delete Row
Is your feature request related to a problem? Please describe. Several users want to be able to delete rows without using a filter. Oftentimes, they want to do this because import did not work as they expected. See the below for more details on the relationship with import.
Describe the solution you'd like
I want to be able to click on rows in the index column to select the entire row, and then press either the backspace key or a delete button in the toolbar to delete all of the selected rows.
Describe alternatives you've considered There are two alternatives to this 1) using a filter to remove specific rows from the data set 2) using the skip rows configuration while importing a .xlsx file.
Additional context Deleting rows is often something we have seen users want to do directly after importing a file. Specifically, because the import didn't handle their file as they expected. Because users are trying to fix these issues in the sheet, we should give them the tools to do it. Yay for discoverability
Take the following import for example.
In this example, Mito/pandas was tripped up by the format of the original dataset, and the user ended up wanting to delete the row in Mito once they saw it. They didn't realize that they could go back and skip the rows in the import step.
Some other features that address related issues:
- Select a row and promote that row to be the column headers
- Add a row
- Transpose a data frame
Main question here: should the button be renamed from DEL COL? It kinda doesn't make sense for this to delete a row, but maybe this isn't a big problem.
Yeah, I think we definitely should not use the DEL COL button. Either rename it to just DELETE or add a second delete button for DEL ROW.
I think moving to just DELETE is probably best.
+1 a lot of header information and/or rows that are "one-offs" need to be deleted
I was thinking about trying to ditch excel for a bit and just use mito, but without this feature, doesn't seem that doable?
In the meantime a pointer on how to use the delete row via a filter could be helpful.
@jcrben this issue should've been closed. We released delete row a few months ago. You can see the documentation for it here. Along with deleting rows, you can promote a row to header -- we've seen those go hand in hand quite often.