thinker007 / google-refine

Automatically exported from code.google.com/p/google-refine
0 stars 0 forks source link

Delete a whole row of data #54

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
I'm working with scraping large amounts of web data, and then cleaning it
up in gridworks. As such, I often get bad lines into the system, where I
want to delete a whole row. It would be useful if there was UI for doing
that in Gridworks.

Original issue reported on code.google.com by EmilStenstrom on 21 May 2010 at 6:32

GoogleCodeExporter commented 9 years ago
I believe you can already:

#Flag (or star) the offending row
#In the dropdown above the flag you can get a facet, by going to Facet > Facet 
by 
flag.
#From the facet that opens select the 'true' option.
#In the dropdown menu above the flag you can go to Edit Rows > Remove all 
matching 
rows.

This should delete all the flagged rows.  Is this what you were looking for?

Original comment by iainsproat on 21 May 2010 at 12:22

GoogleCodeExporter commented 9 years ago
Right now the row removal operation isn't so optimized. I'd recommend flagging 
or 
starring all the rows you want to remove before applying the operation just 
once.

In Gridworks, it's best to make changes en masse. Otherwise, you'd be going 
against the 
grain of the tool.

Original comment by dfhu...@gmail.com on 21 May 2010 at 5:02

GoogleCodeExporter commented 9 years ago
@iansproat: Thanks for your reply. I think the reason I didn't find it was 
because I
didn't think it made sense to get to row editing operations from a column 
dropdown.
That's of course false, but explains my chain of thought.

@dfhyynh: That makes sense. I'm slowly getting a grasp of everything I can do 
with
gridworks. Thanks!

Original comment by EmilStenstrom on 21 May 2010 at 5:43

GoogleCodeExporter commented 9 years ago
Great, thank you!

Original comment by behrang....@gmail.com on 4 Jul 2014 at 2:20