How can I summarize by group by in (R)?

Question

I would like to summarize Votes by Party.

My table:

Expected:

Party	Votes
RP	110
DM	90

This doesnt work for me:

data <- data %>% group_by(Party) %>% summarise(Votos)

Thanks!

score 0 · Accepted Answer · answered Nov 14 '21 at 16:42

0

Use the sum() function within summarise

library(dplyr)
df %>% 
  group_by(Party) %>% 
  summarise(Votes = sum(Votes, na.rm = TRUE))

 Party Votes
  <chr> <int>
1 DM       90
2 RP      110

If you want to have sorted:

df %>% 
  group_by(Party) %>% 
  summarise(Votes = sum(Votes, na.rm = TRUE)) %>% 
  arrange(desc(Votes))

  Party Votes
  <chr> <int>
1 RP      110
2 DM       90

answered Nov 14 '21 at 16:42

TarJae

That gives me this data frame: 1 obs. of 1 variable: $ Votos: num 7176015 – Clara Nov 14 '21 at 16:48
What is your dataframe named ? `df` or `data`? this must work. Please load `library(dplyr)` – TarJae Nov 14 '21 at 16:50
yes, I dont know why doesnt work my group by. – Clara Nov 14 '21 at 16:52
If you have a longer pipe, maybe you have to `ungroup()` before. – TarJae Nov 14 '21 at 16:53
1

Thanks! I wrote this: dplyr::summarise. And it works! – Clara Nov 14 '21 at 16:55

1 Answers1