Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

sqldf with label attached to a variable does not work #56

Open
spal2024 opened this issue Aug 29, 2024 · 1 comment
Open

sqldf with label attached to a variable does not work #56

spal2024 opened this issue Aug 29, 2024 · 1 comment

Comments

@spal2024
Copy link

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?

@ggrothendieck
Copy link
Owner

ggrothendieck commented Aug 29, 2024

There isn't enough detail in the question to address this but maybe the method= argument of sqldf can be used.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants