Is there an R function for summing variables tied to an identifying variable?

Asked Jul 21 '21 at 16:09

Active Jul 21 '21 at 16:09

Viewed 23 times

I have the data format:

          id   OB03A OB03B
          1     1     1
          1     0    NA
          1     1    NA
          1     0    NA
          2     0    NA
          2     1    NA

I am trying to add up all of the values of OB03A for each id, so for id 1 the sum should be 2, and for 2 it should be 1, etc. Is there a function that can do this? I have tried messing around with lapply and counting functions, but that feels too complicated. Is there a better solution?

The final dataframe should be one to one id to OB03A sum:

         id   OB03A OB03B
          1     2     1
          2     1    NA
          3     1    NA

asked Jul 21 '21 at 16:09

User350178

1

You could use the dplyr functions group_by() and summarize() – Bill O'Brien Jul 21 '21 at 16:13
1

Read the manual page for `aggregate`. What do you want to do about OB03B? Sum? First value? Last value? Drop? – dcarlson Jul 21 '21 at 16:14
1

[Some alternatives here](https://stackoverflow.com/a/16657546/1315767) – Jilber Urbina Jul 21 '21 at 16:15
@dcarlson I will most likely drop it, I am still not sure if it is good enough data to use seriously. I will probably remove the whole vector though. Sorry for leaving it in. – User350178 Jul 21 '21 at 16:16
The apply function conditionally is perfect for this, thank you! – User350178 Jul 21 '21 at 16:18
1

`aggregate(. ~ id, d, function(x) sum(x, na.rm = TRUE), na.action = NULL)` – d.b Jul 21 '21 at 16:30

Is there an R function for summing variables tied to an identifying variable?

0 Answers0