watermouth/R_dplyr_memo.md

Created August 7, 2019 04:45

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/watermouth/a572b41bcc1746441fad365edaef6822.js"></script>
Save watermouth/a572b41bcc1746441fad365edaef6822 to your computer and use it in GitHub Desktop.

Download ZIP

dplyr: summarise_at not working on data.table

Raw

R_dplyr_memo.md

error message

data.table(iris) %>% group_by(Species) %>% summarise_at(vars(starts_with("Sepal")), funs(sum))
Error in !funs : invalid argument type

workaround

convert the data type data.table to data.frame.

> data.frame(iris) %>% group_by(Species) %>% summarise_at(vars(starts_with("Sepal")), funs(sum))
# A tibble: 3 x 3
  Species    Sepal.Length Sepal.Width
  <fct>             <dbl>       <dbl>
1 setosa             250.        171.
2 versicolor         297.        138.
3 virginica          329.        149.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment