I need to create a new variable (NewVAR) based on the lowest value of FOUR other variables which is easy to me using R Code. BUT I need to enter name of that Variable with lowest value in the new variable (NewVAR). I can do it manually for few observations but I need to do this for 1000 observations. However, I do not know how to solve this problem using R code. Please see the following example. Any help is highly appreciated.
ID V1 V2 V3 V4 NewVAR
1 20 10 4 5 V3
2 10 1 4 6 V2
3 30 9 6 2 V4
....
Dear Proloy Barua
To create a new variable or to transform an old variable into a new one, usually, is a simple task in R. The common function to use is newvariable
Dear Qamar Ul Islam Thank you for suggestions. My problem is a bit different. I actually want to fill up variable value in the NewVar based on four other variables. I attached an example what I want. The value for each observation will be variable name with minimum score (seems funny). Thanks
Dear Proloy Barua
I would suggest using the case_when() function from the "dplyr" package.
The code should be something like:
df_new %
mutate(NewVar = case_when(
V1