Min value in a record

[Flavio Pompermaier]

Hi to all,

When working in record mode, is there a way to add a columm containig the minimum value of a given column?

Best,

Flavio

[Ettore Rizza]

Hi Flavio, 

in record mode, the following formula produces an array containing all the elements of the record for the column in question.

row.record.cells['your column name'].value

OpenRefine does not have an array function min(), but we can use a sort() and select the first element:

row.record.cells['your column name'].value.sort()[0]

Perhaps a cleaner solution is to use Python/Jython instead:

array = row.record.cells['your column name'].value
return min(array)

In any case, the result will look like this:

You can then use an "Edit cells/Blank Down" to store the minimum value only once per record.

Hope this helps,

Ettore

[Thad Guidry]

OpenRefine does not have an array function min(), but we can use a sort() and select the first element:

row.record.cells['your column name'].value.sort()[0]

Ettore,

Would it be helpful to have that min() function ?

Thad

https://www.linkedin.com/in/thadguidry/

[Ettore RIZZA]

Hi Thad,

Obviously, it is always interesting to have a maximum of methods for all the data types, but is it worthwhile to waste time on that when we could just switch to Python or use a little trick? Not sure. 

Ettore

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

[Thad Guidry]

I was asking "would it be helpful"... in the sense that its an often performed or needed function for folks.  But perhaps we don't know.  I checked our issues and didn't see an ask that was like that previously.

I do know (and we have issues) on making working with Arrays and Records to be easier.  This could be some sub-functionality whenever we work on that.

Thad

https://www.linkedin.com/in/thadguidry/