Say I have a datafame df
resident faculty submittedBy match caseID phase
george sally george 1 george_1 pre
george sally sally 0 george_1 pre
george sally george 1 george_1 intra
jane carl jane 1 jane_1 pre
jane carl carl 1 jane_1 pre
jane carl carl 0 jane_1 intra
and I want to add a column df$response to this dataframe according to the following parameters (I'm thinking I need a set of nested ifelses, but I'm struggling to execute it correctly):
For a given row X, if df$match = 1, print "1" in df$response if any row in df$match where df$match = 0 has the same contents in df$caseID, df$faculty, and df$phase as row X. Otherwise print "0".
So the output should be this:
response
1
0
0
1
0
0
Aucun commentaire:
Enregistrer un commentaire