Replicating Common Excel Tasks in OpenRefine

[Wayne Smerdon]

Hi,

 I'm new to OpenRefine and see that it is very flexible. I'd like to reduce my reliance on using Excel to manipulate data and wanted to see if anyone knew of a comparison between the two. For example, I commonly add new columns to count the number of occurrences of a value in an adjacent cell across an entire column. I would add a COUNTIFS formula to result in a number counting how many times the value to the left or right appeared in that column. I have not yet listed out all the tasks I commonly do and think that would be a starting point, but wanted to ask to see if a translation was already available.

WS

[Ettore Rizza]

Hi Wayne,

The Open Refine's equivalent of COUNTIFS() is facetCount(). You can use it adding a new column based on your main column and using this syntax:

facetCount(value, "value", "your column name")

I've never seen a systematic translation of the most common Excel formulas in GREL, but this should be possible. The equivalent of VLOOKUP, for example, is cell.cross ().

[Thad Guidry]

Wayne,

Why not start a Google Spreadsheet or Google Document that has that systematic translation of common Excel formulas in GREL ?

Option 1: The community would thank you considerably and help you through it.  Just provide the link.

Option 2: Or better yet, If you want I can give you Wiki edit access and you can create a dedicated Wiki page on our Github and help the world by giving back to OpenRefine while maintaining that Excel<->OpenRefine translation Wiki page.

Let us know !

-Thad

+ThadGuidry  

--
You received this message because you are subscribed to the Google Groups "OpenRefine" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openrefine+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Thad Guidry]

Of course, You can start with Option 1...and we can always drop it into Wiki pages with Option 2 later on.

:)