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