Getting error. After running this code:
data = dslabs::gapminder
data %>% show_query()
Error in UseMethod("show_query") :
no applicable method for 'show_query' applied to an object of class "data.frame"
how to fix it? Pls help if you know
#R dplyr package. Need help with an error
smoky lagoon
ionic drum
Dayumm it's an r question leshgoooo
ionic drum
Getting error. After running this code:
data = dslabs::gapminder
data %>% show...
Why are you using show_query? You're not accessing a database
smoky lagoon
Hi wang
ionic drum
Hi Gx
ionic drum
It might be useful to show the task when asking for help 🙂
smoky lagoon
okay
the first task is:
import data "dslabs::stars". Import it so that the "data %>% show_query()" code doesn't throw an error.
then has other one
i think i need to do with dplyr package. but even if i used it. it gives error(
when i checked the type of data it is data frame
smoky lagoon
It might be useful to show the task when asking for help 🙂
i think that maybe to use tibble or something like this but then also gived an error. Pls help me to find the answer
ionic drum
Sorry was doing my night routine
smoky lagoon
no problem
ionic drum
Where is show_query from? Dbplyr or dplyr?
smoky lagoon
i think in dplyr
ionic drum
Can you try utils::getAnywhere(show_query)
Maybe it needs to be in quotes?
I can't remember
smoky lagoon
okay
A single object matching ‘show_query’ was found
It was found in the following places
package:dplyr
namespace:dplyr
with value
ionic drum
Okay so it is from dplyr
Interesting, I've never used that function except for in a database
smoky lagoon
actually i dont understand why it gives an error. But i think it's related to dplyr
smoky lagoon
okay
ionic drum
What's kinda answer is that lol
smoky lagoon
data = dslabs::stars %>% as_tibble()
data %>% class()
[1] "tbl_df" "tbl" "data.frame"
data %>% show_query()
no applicable method for 'show_query' applied to an object of class "c('tbl_df', 'tbl', 'data.frame')"
smoky lagoon
What's kinda answer is that lol
i was trying ))
ionic drum
Oh what why'd a vector get returned
smoky lagoon
there is no problem in data. but then again show query gives an error
sorry i also did this
data %>% class()
ionic drum
What about making it into a tbl?
smoky lagoon
you mean like this?
data = tbl(dslabs::stars)
ionic drum
Oh okay I was right
smoky lagoon
no applicable method for 'tbl' applied to an object of class "data.frame"
ionic drum
You have to convert it to a databse
smoky lagoon
how i can do it
ionic drum
Have you been taught any ways?
I don't want to get you in trouble for using things you're not allowed to
ionic drum
That sounds like it could work
smoky lagoon
but it gives error again((
Error in tbl_memdb(.) : could not find function "tbl_memdb"
smoky lagoon
oh okay
ionic drum
Error in tbl_memdb(.) : could not find function "tbl_memdb"
Surely these errors you should be able to solve yourself c'mon
smoky lagoon
okay. i will try to do it
ionic drum
Hello? It shouldn't take this long lol
smoky lagoon
i tried then gived another error
))
oh I fixed it. i think
data %>% show_query()
<SQL>
SELECT *
FROM .
i am new in R. I think it works now
ionic drum
Noice good work
ionic drum
i am new in R. I think it works now
Welcome to R lol
smoky lagoon
Thank you. I will try to do another part of question. I hope there will be no errors)
ionic drum
No worries
Feel free to come back and ask if you have more questions
I will however, be sleeping soon so I won't reply until I wake up and I don't think anyone else in this server helps with r so ...
ionic drum
No problem