hce1994 / google-refine

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

The ability to insert and or append rows #556

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago
I have been using google refine a lot.  PS think it's awesome.

When cleaning up data regularly I also need to add in new rows of information 
into the data set.  Currently I have to export the data and then do the inserts 
in textmate or excel.

So just want the ability to insert rows and to manually edit the values in the 
cells.

Original issue reported on code.google.com by steve.mo...@gmail.com on 22 Mar 2012 at 3:52

GoogleCodeExporter commented 8 years ago
Refine isn't really meant for arbitrary editing of spreadsheets, but one hack 
that you can use to do this within Refine is:

1. Add a cell value of ",,,,,,,,,,,,,,,,,,,,,,,,,,," (or something similar)
2. Use the Edit Cells -> Split multivalued cells to create a bunch of empty rows

Can you explain a little bit more about why you need blank rows which aren't 
based on the data that you are working with?

Original comment by tfmorris on 18 Sep 2012 at 8:06

GoogleCodeExporter commented 8 years ago
This is because when your cleansing data you come across obvious entries that 
are missing from data sets and want to add them then and there.  A more common 
case in one project that you see a single row of data that should be split into 
two or more rows of data.

Example: When working on a new potential taxonomy you find entries of a number 
of column the the key is a value like 
  New York/New Jersey Value2 Value3 Value4  
and I want to quickly fix this by inserting a new row with and fix the old row. 
  New York Value2 Value3 Value4
  New Jersey Value2 Value3 Value4
There are a number of other cases like this when working the datasets your 
cleansing.   If you would like me to clarify further or answer other questions 
please let me know I would love to help.

Original comment by steve.mo...@gmail.com on 18 Sep 2012 at 8:19

GoogleCodeExporter commented 8 years ago
Does this explanation make sense?

Original comment by steve.mo...@gmail.com on 18 Sep 2012 at 8:20