group two variables and sum one of them based on the previous grouped variable

Question

I'm trying to group two variables and sum one of them based on the previous grouped variable.

structure(list(`Tipo de Geração` = c("EOL", "EOL", "EOL", "EOL", 
"EOL", "EOL", "EOL", "EOL", "EOL", "UFV", "UFV", "UFV", "UFV", 
"UFV", "UFV", "UFV", "UFV", "UFV", "UTE", "UTE", "UTE", "UTE", 
"UTE", "UTE", "UTE", "UTE", "UTE", "UTE", "UTE", "UTE", "UTE", 
"UTE", "UTE"), UF = c("PI", "PI", "PI", "RN", "RN", "RN", "RN", 
"RN", "RS", "PB", "PB", "PB", "PB", "PB", "PB", "PB", "PB", "PB", 
"SP", "AM", "AM", "AM", "AM", "AM", "AM", "AM", "AM", "AM", "AM", 
"AM", "AM", "AM", "AM"), Usina = c("Ventos de Santa Angela 14", 
"Ventos de Santa Angela 14", "Ventos de Santa Angela 14", "Vila Maranhão III", 
"Vila Maranhão III", "Vila Maranhão III", "Vila Maranhão III", 
"Vila Maranhão III", "Xangri-lá", "Coremas III", "Coremas III", 
"Coremas III", "Coremas III", "Coremas III", "Coremas III", "Coremas III", 
"Coremas III", "Coremas III", "Branco Peres", "Alvarães - CGA", 
"Alvarães - CGA", "Alvarães - CGA", "Alvarães - CGA", "Alvarães - CGA", 
"Alvarães - CGA", "Alvarães - CGA", "Alvarães - CGA", "Alvarães - CGA", 
"Alvarães - CGA", "Alvarães - CGA", "Tamaniquá - CGA", "Tamaniquá - CGA", 
"Tamaniquá - CGA"), UG = c(12, 13, 14, 5, 6, 7, 8, 9, 10, 1, 
2, 3, 4, 5, 6, 7, 8, 9, 1, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 
1, 2, 3), `Potência UG (kW)` = c(3000, 3000, 3000, 3550, 3550, 
3550, 3550, 3550, 3800, 3000, 3000, 3000, 3000, 3000, 3000, 3000, 
3000, 3000, 15000, 352, 352, 352, 352, 352, 352, 352, 352, 352, 
352, 352, 297, 297, 297)), row.names = c(NA, -33L), class = c("tbl_df", 
"tbl", "data.frame"))

The variable "UG" stands for the number of eletric turbines which have the following potency represeted by the Potência UG (kW) variable. The variable Usina (Hydroelectric power plant) can have multiple UGs values and also have multiple potencys values. Therefore, I need to group the number of UGs and perform a sum operation of all the following Potência UG (kW) values for each Hydroelectric power plant (represented by the Usina variable). How can i do this? Thanks!

Very strongly related: https://stackoverflow.com/questions/1660124/how-to-sum-a-variable-by-group?rq=1 — Axeman, Nov 01 '20 at 00:49

score 0 · Answer 1 · answered Nov 01 '20 at 00:49

0

If I understand your question correctly I think this should work. I saved your data frame as s

library(dplyr)

s_grouped <- s %>%
  group_by(Usina, UG) %>%
  summarize(sum = sum(`Potência UG (kW)`))

answered Nov 01 '20 at 00:49

hachiko

671
7
20

score 0 · Answer 2 · answered Nov 01 '20 at 00:50

If I follow correctly, perhaps this is what you're looking for, using dplyr (and after assigning sample data into x):

x %>% 
  group_by(Usina) %>% 
  summarise(sum_potencia = sum(`Potência UG (kW)`))

Result:

# A tibble: 7 x 2
  Usina                     sum_potencia
  <chr>                            <dbl>
1 Alvarães - CGA                    3872
2 Branco Peres                     15000
3 Coremas III                      27000
4 Tamaniquá - CGA                    891
5 Ventos de Santa Angela 14         9000
6 Vila Maranhão III                17750
7 Xangri-lá                         3800

group two variables and sum one of them based on the previous grouped variable

2 Answers2