How to apply operations (like filter, add column, etc) to a R.data_frame? (R type provider)

Question

On R, you can easily:

filter:

frame <- frame[frame$some_column>0, ]

add a column:

frame$new_column <- frame$some_column * 100

Select unique elements:

unique(frame$some_column)

How can you achieve this with R Provider?

Answer 1

When you realize how heavily the R Provider relies on R.Net, it is easy to look on the internet and realize that you can do stuff like this:

let dataFrame = //some R.data_frame
let e = REngine.GetInstance()
e.SetSymbol("dataFrame", dataFrame)
e.Evaluate("unique(dataFrame$some_column)").GetValue<double[]>()
e.Evaluate("dataFrame$new_column <- dataFrame$some_column * 1000")