topic Error connecting Through R in Developer

Error connecting Through R

arashaga — Fri, 17 Aug 2018 18:28:19 GMT

I am getting the following error when I paste the following code in the R script connector box. It is simple script that runs on RStudio.

df1 <- data_frame(school = c("A", "B", "C", "D", "E", "F", "G", "H"),
perc_25 = c(950, 1140, 1140, 820, 920, 950, 850, 850),
perc_75 = c(1190, 1410, 1380, 1030, 1130, 1150, 1060, 1050),
diff = as.numeric(perc_75 - perc_25))

Details: "ADO.NET: R script error.
Error: could not find function "data_frame"
Execution halted

Does nayone have any ideas why this not running. I have done some visual in powerBI using R previously but I am not sure what has changed. Thanks
"

Re: Error connecting Through R

v-jiascu-msft — Mon, 20 Aug 2018 14:10:59 GMT

Hi @arashaga,

Which library does data_frame belong? It could be data dot frame which is data.frame(). As far as I know, I can't call other columns when initiating the data frame. Please try it like below or include the proper library.

# include the proper library which has the data_frame.
library(lib)
your other codes go here.

school <- c("A", "B", "C", "D", "E", "F", "G", "H")
perc_25 <- c(950, 1140, 1140, 820, 920, 950, 850, 850)
perc_75 <- c(1190, 1410, 1380, 1030, 1130, 1150, 1060, 1050)
diff <- perc_75 - perc_25
df1 <- data.frame(school = school, perc_25 = perc_25, perc_75 = perc_75, diff = diff)

Best Regards,

Dale

Re: Error connecting Through R

v-jiascu-msft — Thu, 23 Aug 2018 09:49:03 GMT

Hi @arashaga,

Could you please mark the proper answers as solutions?

Best Regards,

Dale

Re: Error connecting Through R

arashaga — Thu, 23 Aug 2018 12:07:02 GMT

Yes. Thank you for the solution!