Multiply two columns and save to another column

[PoslavskySV]

Hi guys,

thank you for great library. May be I just can't find this in docs (sorry if that is the case), but how I can e.g. multiply two columns or take a square root?
I have two columns with double values count1 and count2 and I want to do

df.map { count1 * count2 into "mul" }
// and
df.map { sqrt(count1 * count2) into "geomMean" }

The only thing I can do is to multiply on a fixed number

df.map { count1 * 2 into "smth" }

Thanks

[nikitinas]

Hi,

Currently only a limited set of column-wise operations are supported, but you can use from infix function to create columns from any row-wise expression:

df.map {
  "mul" from { count1 * count2 }
  "geomMean" from { sqrt(count1*count2) }
}

[PoslavskySV]

Super, thank you! This is exactly what I was looking for.