Dropping rows where number of cases is greater that population size

Question

I have merged health data (cases) with population data. In some instances, the number of cases (n) is greater than the population size (N). I will need to drop these rows.

What is the most efficient way to do this in R? For example: where n > N, replace n with 0?

Please include some sample data, eg using the `dput()` function. — Jon Spring, Jul 26 '23 at 23:54
`df$n[df$n > df$N] <- 0` will replace `n` in a data.frame called `df` whenever that row's `n > N`. — Jon Spring, Jul 27 '23 at 00:09

score 0 · Accepted Answer · answered Jul 27 '23 at 04:51

0

To drop rows

df = df[df$n < df$N,]

for replacement

df[df$n > df$N,"n"] = 0

answered Jul 27 '23 at 04:51

DDV

16

Dropping rows where number of cases is greater that population size

1 Answers1

To drop rows

for replacement