sqldf
sqldf copied to clipboard
sqldf with label attached to a variable does not work
I am a fan of sqldf when it comes to data wrangling as I came from SAS background. However I have noticed when a variable has a label attached to it, we could not use sqldf. We get the error message as 'Error in match.fun(asfn) : 'c("as.labelled", "as.Date")' is not a function, character or symbol' I think it's a known issue. The way I am dealing with this situation is creating a brand new variable without a label using mutate function and feed those columns into sqldf. Is there any alternative way you guys suggest?