Make blank cells as NAs in R script visual

[wes-shen-poal]

HI there,

Can someone kindly advise me on how I can make the blank cells in my dataset (i.e. the columns I have chosen) for a R Script Visual to be NAs within the R Script Editor?

The way I overcome it at the moment is to go to edit script in the external R IDE, I add na.strings argument in the read.csv command as per below:

`dataset` = read.csv('C:/Users/sh6668/AppData/Local/Radio/REditorWrapper_56fdaa70-81ea-4683-9bde-09ddd2f782ff/input_df_dbea42c1-2bea-4737-a2da-83deca7143a7.csv', check.names = FALSE, encoding = "UTF-8", blank.lines.skip = FALSE, na.strings = c(""," ","NA"));

And then copy this command back onto my R Script Editor for my R Script Visual.

But the approach just feels a bit long-winded. Is there a quicker way for me to do this?

Thanks in advance.

Wes

[dkay84_PowerBI]

Try adding a calc column within PBI that checks for blank and returns "NA" otherwise returns the value, then use this new column in your visual

[wes-shen-poal]

thanks @dkay84_PowerBI

Do you know if there's a way I can do this within the R Script Editor (without having to create a new calc column)?