Forum Discussion
Make blank cells as NAs in R script visual
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
2 Replies
- dkay84_PowerBIMicrosoft EmployeeTry 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-poalHelper III
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)?