R:summarise +group_by function produces no result

Asked Sep 27 '17 at 22:54

Active Sep 27 '17 at 23:37

Viewed 41 times

I am trying to collapse the column b so that entries in column a will have only one row and column B will be multiple values separated by ; my code is:(my file is known as disease)

a       b
2012    cancer
2013    HIV
2014    cancer
2014    HIV

library(dplyr)
summary <- disease %>% 
   group_by(a) %>%
   summarise(b = paste0(b, collapse = ';')) %>% 
   ungroup()

This does not give me any error but does not yield the desired results too. Summary file is generated but has only one column named b and that is empty.

edited Sep 27 '17 at 23:37

shiny

2,920
8
28
69

asked Sep 27 '17 at 22:54

Bioinformatician

Presumably dplyr is loaded? – Hong Ooi Sep 27 '17 at 22:56
Works for me (two columns in output) – pogibas Sep 27 '17 at 23:04
@Bioinformatician so post actual data... – pogibas Sep 27 '17 at 23:18
Please provide an example that reproduces the issue. (You could try running on a subset of your file to see if you can reproduce the issue without the full file.) – Tim Goodman Sep 27 '17 at 23:19
1

probably `plyr` is loaded, `detach("packages:plyr")`, or `dplyr::summarise` – Moody_Mudskipper Sep 27 '17 at 23:23
1

@Moody_Mudskipper Thank you so so much..dplyr::summarise worked!!! – Bioinformatician Sep 27 '17 at 23:30

R:summarise +group_by function produces no result

0 Answers0