search

ddavisqa / google-refine

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

Merge Rows #341

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
I'd like to see the option to merge similar rows, perhaps through a clustering 
type interface

I use refine in electronics and I often have multi byte data output as single 
byte per row in test files

E.g.

Address  Data   Name
0x5000   0x23   Register A
0x5001   0x35   Register A (low)

I'd like to see clustering where I could do an operation like
- Cluster on name (perhaps with specified pattern match)
- Sort by address
- Merge data as join(data1,data2.split("x")[1]) into a line named Register A @ 
address 0x5000

This type of row joining has many applications, e.g. in the example disasters 
spreadsheet it could be used to create a total cost of disasters per country 
between 1950 and 2000

Original issue reported on code.google.com by timothy....@gmail.com on 25 Feb 2011 at 2:35

GoogleCodeExporter commented 9 years ago

Original comment by tfmorris on 6 Jun 2011 at 10:34