Sum (or not) a value based on condition of another column in R

Question

Let's imagine the following data. Columns A, B, and C. Column A contains years (eg.2022, 2025, 2030, etc). Column B contains a month (eg. 2, 7,8, etc). I need to create a column C that does the following "if else".

If B >=6, then C = A+1.
If B is smaller than 6, then C = A.

Can anyone help me please? Have a good day

Something like this will do the trick df$C = ifelse(df$B >= 6, df$A + 1, df$A) — tivd
– tivd, Commented Feb 5, 2022 at 19:54

Sweepy Dodo · Accepted Answer · 2022-02-05 19:54:07Z

4

df$c <- ifelse(df$b >= 6, df$a+1, df$a)

answered Feb 5, 2022 at 19:54

Sweepy Dodo

1,89114 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

TarJae · Accepted Answer · 2022-02-05 19:56:20Z

3

Here is a dplyr solution using an ifelse statement:

library(dplyr)

df %>% 
  mutate(C = ifelse(B >= 6, A+1, A))

      A     B     C
  <dbl> <dbl> <dbl>
1  2022     2  2022
2  2025     7  2026
3  2030     8  2031

df <- structure(list(A = c(2022, 2025, 2030), B = c(2, 7, 8)), class = c("tbl_df", 
"tbl", "data.frame"), row.names = c(NA, -3L))

answered Feb 5, 2022 at 19:56

TarJae

80.2k6 gold badges30 silver badges94 bronze badges

Collectives™ on Stack Overflow

Sum (or not) a value based on condition of another column in R

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related