Transposing to records with different lengths
I have a problem similar to Transpose rows into columns with OpenRefine (variable number of rows) and I found the solution provided there to be very useful (I hadn't really used the records mode before). However, in my case I have a column of attribute names that I'd like to transpose into new column names. So for instance if I start with
ID, Attribute, Value
1, height, 150mm
1, width, 20mm
2, height, 200mm
2, color, blue
3, mass, 5g
After blanking down (on ID) and going to records mode I get a nice view of the records, but I don't know how I'd go about transposing this to
ID, height, width, color, mass
1, 150mm, 20mm, ,
2, 200mm, , blue,
3, , , , 5g
which would be useful for me for for further refining (e.g. making a facet on 'width', say).
The function you are looking for is Columnize by key/value column...
It will create one new column for each value in your key column in your case the Attribute column and move the Value in its respective column.
I recorded a short (50sec) walkthrough video based on the example you provided: https://youtu.be/IUGubwfiJ6o
I am using this GREL expression row.record.cells[columnName].value[0] to move all the value on the same records (more details on how to use ColumnName here)
- In OpenRefine, how to import multiple selected columns at once from another project using GREL or Python
- Openrefine cannot fetch html code inside accordion
- OPenRefine GREL removing words if present in another column
- Where does openrefine store projects?
- Simple OpenRefine IF to create a new column
- OpenRefine: How to delete content of cells if it matches specific string pattern?
- OpenRefine: How to create a unique row for each input in a column ( dilneated by comma)
- Openrefine - Extract the instance of
- openrefine - Sorting column contents within a record?
- How to delete least filled duplicate rows?
- Extract XML attribute value based on element value
- Extracting skos:closeMatch from RDF/XML using GREL in OpenRefine
- Split multi-valued cells paired with other multi-valued cells in other rows
- Open Refine: Exporting nested XML with templating
- OpenRefine: after reconciliation, I want to retrieve the title of Wikidata items in other languages
- regex: get everything that doesn't fit in hooks
- Cannot add python Requests module to OpenRefine
- Transposing to records with different lengths
- Fetching a redirect's target URL in OpenRefine
- Is there a function in GREL to remove many columns at once based on their headers in OpenRefine?
- fetching wikidata labels in other languages from reconciled column
- OpenRefine + RDF: handling repeated occurrences
- Use POST method with URL and Google Refine/ OpenRefine
- Open Refine / Google Refine - Remove blank cells in a column
- openrefine/googlerefine - reconcile two datasets
- Underscore and dash in column names after JSON import
- OpenRefine: Inverting a regular expression
- OpenRefine sample extension not building
- Does OpenRefine support Python3?
- OpenRefine: swapping order strings within a column of values