Creating new variable based on condition

Question

I have a want to create a new variable that is basically taking the value of an existing variable, but it is conditional. You have var1 and var2 that are both numeric. The new variable should take either var1 or var2, whichever is lower.

Example code (trying this just replicated var1):

upc_data_actual2$price9 <- if(upc_data_actual2$MSRP_PRC<upc_data_actual2$price){
  upc_data_actual2$price9=upc_data_actual2$MSRP_PRC
} else {
  upc_data_actual2$price=upc_data_actual2$price
}

Doing this just yields 0: upc_data_actual2$price8 <- min(upc_data_actual2$MSRP_PRC, upc_data_actual2$price) — knewton16
– knewton16, Commented Aug 29, 2019 at 1:28

Doug Richardson · Accepted Answer · 2019-08-29 03:09:03Z

0

 var1=5
 var2=4
 t=0
 if (var1<var2) {
   t=var1
 } else {
   t=var2
 }
 print(t)
 Takes the smaller variable and puts it into another

edited Aug 29, 2019 at 3:09

Doug Richardson

10.9k6 gold badges56 silver badges81 bronze badges

answered Aug 28, 2019 at 23:36

Arundeep Chohan

9,9995 gold badges17 silver badges36 bronze badges

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

1 Comment

knewton16 Over a year ago

Thanks for the response. I tried this and it just replicated var1. See below for example code: upc_data_actual2$price9 <- if(upc_data_actual2$MSRP_PRC<upc_data_actual2$price){ upc_data_actual2$price9=upc_data_actual2$MSRP_PRC } else { upc_data_actual2$price=upc_data_actual2$price }

Collectives™ on Stack Overflow

Creating new variable based on condition

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related