r - Edit values from a variable based on multiple values from multiple variable within a dataframe -
i new r please bear me.
i have dataframe of 8891 obs. of 4 variables:
survived: int 0 1 1 0 0 0 0 1 1 ... sex : factor w/ 2 levels "female","male": 2 1 1 1 2 2 2 2 1 1 ... age : num 22 38 15 78 35 na 54 2 27 14 ... fare : num 120 120 120 120 ... sex <- c("female","male", "male", "male") survive <- c(0,1,1,0) age <- c(22,38,15,78) fare <- c(120,120,120,120) dataframe <- data.frame(sex, survive, age, fare) #view(dataframe)
i trying create variable fixedfare
values variable fare
divided 2 based on values variable survived
, variable age
.
basically, if value in survived
1 , value in age
<= 16 , >= 60 divide value x in fare
2. , if comes across na
mark na
. within same data frame.
i not sure how this. i’ve searched related questions in stackoverflow solution couldn’t find 1 similar question.
thanks help.
the ifelse
approach assigns values based on conditions provided:
df$fare <- ifelse(df$survived == 1 & (df$age <= 16 | df$age >= 60), df$fare/2, df$fare)
using example in question wrap function call in transform
:
transform(dataframe, fare = ifelse(survive == 1 & (age <= 16 | age >= 60), fare/2, fare)) # sex survive age fare #1 female 0 22 120 #2 male 1 38 120 #3 male 1 15 60 #4 male 0 78 120
Comments
Post a Comment