lundi 17 juin 2019

how to use evaluate recursively a vector of conditions on another vector ifelse

Issue in applying if conditions in Rows and columns of 2 different dataframes.

Data

df1<- data.frame(X1=10,
                 X2=12,
                 X3= 8,
                 X4=4,
                 X5=6)

df2<-data.frame(Class = c("class_1", "class_2","class_3", "class_4", "class_5", "class_6",
                "class_7", "class_8", "class_9", "class_10"),
                MARKS = c(8,6,9,10,11,8,5,4,7,5))

Output:

class 1     Y       Y   FALSE   FALSE   FALSE
class 2     Y       Y   Y       FALSE   FALSE
class 3     Y       Y   FALSE   FALSE   FALSE
class 4     FALSE   Y   FALSE   FALSE   FALSE
class 5     FALSE   Y   FALSE   FALSE   FALSE
class 6     Y       Y   FALSE   FALSE   FALSE
class 7     Y       Y   Y       FALSE   Y
class 8     Y       Y   Y       FALSE   Y
class 9     Y       Y   Y       FALSE   FALSE
class 10    Y       Y   Y       FALSE   Y

formula: =IF($A$2>$I2,"Y")
FOR CLASS 1 - I2 WILL BE CONSTANT 

eg: where A2 = 10 of df1 and I2 = 8 of df2. If 10 > 8 then print Y, else condition fails and print FALSE.

FOR CLASS 2 - I3 WILL BE CONSTANT 
FORMULA =IF($A$2>$I3,"Y")

Similary, where B2 = 12 OF DF1 AND I3 = 6 OF df2 so if 12>6 print Y, else condition fails and print FALSE.

Aucun commentaire:

Enregistrer un commentaire