vendredi 15 décembre 2017

Rstudio: Generate column based if other columns are equal

What I want to do is generate a new column in a dataframe that meets these conditions:

dataframe1$var1 == dataframe2$var1 &
dataframe1$var2 == dataframe2$var2 &
dataframe1var3 == dataframe3$var3*

Dataframe1 example Dataeframe2 example

Basically I need to generate a dummy variable that has the value 1 if the conditions are met, and the value 0 if they are not.

I've tried the following code that doesn't work:

dataframe1$NewVar <- ifelse(dataframe1$var1 == dataframe2$var1 & 
dataframe1$var2 == dataframe2$var2 & dataframe1$var3 == dataframe2$var3 , 1, 0)

Aucun commentaire:

Enregistrer un commentaire