3 Easy Ways to Delete Rows From Big Data Files
While columns could be deleted in Gigasheet, rows were hard to get rid of. Until now! Introducing not just one, but three easy ways to delete rows from your data.
Previously, deleting rows required a work around: unwanted rows could be filtered out and then Save As a new sheet would create a file with only the desired data. While this cumbersome process worked, it caused unnecessary steps and created clutter in users' Library. At Gigasheet, our goal is to make exploring and analyzing data easy.
To that end, we are introducing three ways to quickly and easily delete rows from your data. In this blog post, we are going to explore the following ways to delete rows:
Select data and individually Delete Row
Filter data and Delete Matching Rows
Filter data and Delete Excluded Rows
Select Data and Individually Delete Row
The quickest way to delete rows is to simply select bad data and delete the row that you no longer need. This is convenient for one-off data cleanup, which is nice because it seems like there is always a row here or there with bad data. The Delete Row function works one row at a time but can be repeated to delete multiple rows.
In this example file, we see rows 4, 5, and 6 literally have "Bad Data", which does not belong in this list of Olympic Medalists. By using Shift and clicking, I have highlighted the 3 values that do not belong in the data set for illustration purposes.
Select the first "Bad Data" point for deletion. Once selected, there are two ways to perform the delete action. You can either choose Data Cleanup -> Delete Row,
or simply right click and select Delete Row.
Whichever way you select Delete Row, the outcome will be the same. Gigasheet will first ask you if you are sure you want to delete the rows, because the delete operation cannot be undone. In this case, we are sure, so hit Confirm.
The first row containing the "Bad Data" will be removed. Repeat these steps for the other two rows containing "Bad Data" and the file will be ready for analysis. Here is the cleaned-up file. No more "Bad Data"!
Filter Data and Delete Matching Rows
Delete Row is convenient for cleaning up errors that you find as you explore a file. However, what if there are huge sections of data that need to be removed?
In that case, it's best to use the two Delete Rows functions that take advantage of Gigasheet's powerful Filters. Both functions allow us to delete millions of rows at a time, leaving us with a file that contains only the desired data.
Returning to the Olympic Medalists file, let's group the data by "/year" to see what exactly is in the file. Our data set contains records for the 2000 through 2012 Olympic games.