summarise with dplyr group by function ignores factor

Asked Nov 14 '18 at 13:56

Active Nov 14 '18 at 14:07

Viewed 31 times

The summarise function in dplyr by means the group by function returns a single value, even though the group by is filled with a factor. What is wrong here?

cols <- c("GGEES203","cl_kmeans")
y <- y[which(y$cl_kmeans>0),cols]
y$cl_kmeans <- as.factor(y$cl_kmeans)
str(y)
    'data.frame':   3863 obs. of  2 variables:
     $ GGEES203 : num  4 11 3 0 9 0 10 11 8 10 ...
     $ cl_kmeans: Factor w/ 9 levels "1","2","3","4",..: 6 4 3 3 6 6 4 9 9 5 ...
gd <- y %>% 
group_by(cl_kmeans) %>% 
summarise(eenzaamheid_avg = mean(GGEES203, na.rm = TRUE))


      eenzaamheid_avg
    1            7.29
    >

edited Nov 14 '18 at 14:07

asked Nov 14 '18 at 13:56

Mark Henry

2,649
7
40
48

can u try with as.character instead of factor – sai saran Nov 14 '18 at 13:59
output is still the same – Mark Henry Nov 14 '18 at 14:01
Can you try using `group_by(cl_kmeans)`? No need to use `$` with `dplyr`. – AntoniosK Nov 14 '18 at 14:05
still the same result – Mark Henry Nov 14 '18 at 14:07
1

Can you post the `y` dataset using `dput`? I need to make sure I can replicate that issue. – AntoniosK Nov 14 '18 at 14:09
1

Hmmm. I think I got it. Which packages are you using? Very likely you're using `plyr` which will break your grouping. Try to do the same using ONLY `dplyr`. If you really need to use both do first `library(plyr)` and then `library(dplyr)`. – AntoniosK Nov 14 '18 at 14:12
yes may be...dont run the dplyr before run of plyr – sai saran Nov 14 '18 at 14:15
you are right AntoniosK, thank you very much – Mark Henry Nov 14 '18 at 14:45

summarise with dplyr group by function ignores factor

0 Answers0