R:比较不同级别的字符串变量

Question

我能知道如何比较R中不同级别的两个字符串变量吗？

我想检查Q2中的变量Q1是否与匹配，以便以后可以对我的数据进行一些验证

Key  Q1      Q2               
 1   Apple   Pineapple       
 2   Banana  Banana              
 3   Apple   Papaya              
 4   Orange  ""                    
 5   Papaya  ""                 
 6   Apple   Apple          

结果如下所示

Key  Q1      Q2          Result           
 1   Apple   Pineapple   No   
 2   Banana  Banana      Yes           
 3   Apple   Papaya      No             
 4   Orange  ""          No                      
 5   Papaya  ""          No              
 6   Apple   Apple       Yes        

我收到一条错误消息，指出

"level sets of factors are different"


$ Q1    : Factor w/ 4 levels "Apple","Banana",..: 1 2... 
$ Q2    : Factor w/ 5 levels "","Pineapple","Banana"...

有人能帮上忙吗？

非常感谢。

Answer 1

试试这个：

Q1 = c("Apple", "Banana", "Apple", "Orange", "Papaya", "Apple")
Q2 = c("Pineapple", "Banana", "Papaya", "", "", "Apple")

df = as.data.frame(cbind(Q1, Q2))
df$Q1 = as.character(df$Q1)
df$Q2 = as.character(df$Q2)

df$Results = ifelse(df$Q1 == df$Q2, "Yes", "No")
df

> df
      Q1        Q2 Results
1  Apple Pineapple      No
2 Banana    Banana     Yes
3  Apple    Papaya      No
4 Orange                No
5 Papaya                No
6  Apple     Apple     Yes