Hi,
I would like to create a new column with values setting according to three other columns from my database.
My data looks like that (sorry I do not understand how do to to display it correctly so I just give you the code):
df <- structure(list(Examinator1_General = c("Yes", "No", "No", "No", "No", "No", "No", "Yes"),Examinator1_Focal = c("No", "Yes", "No", "No", "No", "No", "Yes", "No"),Examinator1_Local = c ("No", "No", "No", "Yes", "No", "No", "No", "No"),Examinator2_General = c("No","No","No","No","No","No","No","No"),Examinator2_Focal = c("Yes","No","No","No","No","No","Yes","No"),Examinator2_Local = c("No","No","No","Yes","No","No","No","Yes")),.Names=c("Examinator1_General","Examinator1_Focal", "Examinator1_Local","Examinator2_General","Examinator2_Focal", "Examinator2_Local"), row.names = c(NA,8L),class = "data.frame")
df
Examinator1_General Examinator1_Focal Examinator1_Local Examinator2_General Examinator2_Focal Examinator2_Local
1 Yes No No No Yes No
2 No Yes No No No No
3 No No No No No No
4 No No Yes No No Yes
5 No No No No No No
6 No No No No No No
7 No Yes No No Yes No
8 Yes No No No No Yes
And I would like to add two columns one summarizing the findings from Examinator1 and one from Examinator2 so a final database looking like that
df2 <- structure(list (Examinator1_General = c("Yes", "No", "No", "No", "No", "No", "No", "Yes"),Examinator1_Focal = c("No", "Yes", "No", "No", "No", "No", "Yes", "No"),Examinator1_Local = c ("No", "No", "No", "Yes", "No", "No", "No", "No"),Examinator2_General = c("No","No","No","No","No","No","No","No"),Examinator2_Focal = c("Yes","No","No","No","No","No","Yes","No"),Examinator2_Local = c("No","No","No","Yes","No","No","No","Yes"),Examinator1 = c("General","Focal","None","Local","None","None","Focal","General"),Examinator2 = c("Focal","None","None","Local","None","None","Focal","Local")),.Names=c("Examinator1_General","Examinator1_Focal", "Examinator1_Local","Examinator2_General","Examinator2_Focal","Examinator2_Local","Examinator1","Examinator2"), row.names = c(NA,8L),class = "data.frame")
df2
Examinator1_General Examinator1_Focal Examinator1_Local Examinator2_General Examinator2_Focal Examinator2_Local Examinator1 Examinator2
1 Yes No No No Yes No General Focal
2 No Yes No No No No Focal None
3 No No No No No No None None
4 No No Yes No No Yes Local Local
5 No No No No No No None None
6 No No No No No No None None
7 No Yes No No Yes No Focal Focal
8 Yes No No No No Yes General Local
I am quiet new with R and cannot think of a way to do it.
Thank you very much for your help ! Let me know if the explanation is unclear or if you want me to provide the database example in another format.