如何在 R 資料框的倆列中比較兩個完全匹配的值?
有時分析要求使用者檢查 R 資料框兩列中的值是否完全相同,如果我們懷疑兩列中的比較值,則這有助於分析非常大的資料框。這可以透過 ifelse 函式輕鬆完成。
示例
考慮以下資料框−
x1<-sample(c("Spring","Winter","Autumn","Summer"),20,replace=TRUE)
y1<-sample(c("Spring","Winter","Autumn","Summer"),20,replace=TRUE)
df1<-data.frame(x1,y1)
df1輸出
x1 y1 1 Spring Autumn 2 Winter Winter 3 Summer Summer 4 Autumn Autumn 5 Summer Autumn 6 Autumn Autumn 7 Summer Winter 8 Spring Spring 9 Summer Spring 10 Winter Winter 11 Autumn Summer 12 Autumn Summer 13 Spring Winter 14 Spring Winter 15 Spring Spring 16 Summer Autumn 17 Spring Winter 18 Winter Summer 19 Summer Spring 20 Spring Autumn
確定 x1 和 y1 中的每個值是否相同−
示例
ifelse(df1$x1==df1$y1,"Yes","No")
輸出
[1] "No" "Yes" "Yes" "Yes" "No" "Yes" "No" "Yes" "No" "Yes" "No" "No" [13] "No" "No" "Yes" "No" "No" "No" "No" "No"
示例
x2<-sample(c("Male","Female"),20,replace=TRUE)
y2<-sample(c("Male","Female"),20,replace=TRUE)
df2<-data.frame(x2,y2)
df2輸出
x2 y2 1 Male Female 2 Female Male 3 Female Female 4 Male Male 5 Female Female 6 Male Female 7 Female Female 8 Male Male 9 Male Female 10 Female Female 11 Female Female 12 Male Female 13 Male Male 14 Female Male 15 Male Male 16 Female Female 17 Male Male 18 Female Female 19 Male Female 20 Male Female
確定 x2 和 y2 中的每個值是否相同−
示例
> ifelse(df2$x2==df2$y2,"Yes","No")
輸出
[1] "No" "No" "Yes" "Yes" "Yes" "No" "Yes" "Yes" "No" "Yes" "Yes" "No" [13] "Yes" "No" "Yes" "Yes" "Yes" "Yes" "No" "No"
廣告
資料結構
網路
RDBMS
作業系統
Java
iOS
HTML
CSS
Android
Python
C 程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP