Combine character entries and sum associated numbers

Does your data have NAs in it? if so, use na.rm = TRUE.

df_grouped <- df_combi %>% 
    group_by(states) %>% 
    summarise(total_value = sum(col_lost, na.rm = TRUE))

If this doesn't solve your problem, please provide a proper REPRoducible EXample (reprex) illustrating your issue.

1 Like