I want to filter a column of a list, when I do it though it says the column object is not found.
> library(dbplyr)
> college_sum = nba_stats_net$aggregate('[{"$group":{"_id":"$College","Sum":{"$sum":1} ,"Overall": {"$avg":"$Overall"}}}]')
> final_thing = college_sum%>% filter(Sum>5)
It gives me this error
Error in filter(., Sum > 5) : object 'Sum' not found
This is the original list.
**
**
Thanks for any help
Be explicit and use
dplyr::filter(Sum > 5)
Update: As below, make sure you are using the full expression
college_sum %>% dplyr::filter(Sum>5)
or in base R:
college_sum[college_sum$Sum > 5, ]
Best,
Marcel
I still get
Error in dplyr::filter(Sum > 5) : object 'Sum' not found
You've loaded dbplyr
rather than dplyr
. They are different libraries.
You probably want (from dplyr):
college_sum %>%
filter(Sum > 5)
# or this
filter(college_sum, Sum > 5)
system
Closed
5
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.