資料結構
網路
關係型資料庫管理系統 (RDBMS)
作業系統
Java
MS Excel
iOS
HTML
CSS
Android
Python
C語言程式設計
C++
C#
MongoDB
MySQL
Javascript
PHP
物理學
化學
生物學
數學
英語
經濟學
心理學
社會學
服裝學
法學如何在R資料框中查詢分類列中各個類別的計數？
如果我們在R資料框中擁有兩列分類列，那麼我們可以找到每個類別相對於另一列中每個類別的頻率/計數。這將有助於我們比較所有類別的頻率。為了找到類別的計數，我們可以使用table函式，如下例所示。
示例1
考慮以下資料框：
x1<−sample(c("Child","Teen","Adult","Old"),20,replace=TRUE)
x2<−sample(c("Unemployed","Employed"),20,replace=TRUE)
df1<−data.frame(x1,x2)
df1輸出
x1 x2 1 Old Unemployed 2 Child Unemployed 3 Adult Employed 4 Adult Unemployed 5 Adult Employed 6 Teen Employed 7 Old Employed 8 Child Unemployed 9 Child Employed 10 Adult Unemployed 11 Child Unemployed 12 Old Employed 13 Child Unemployed 14 Child Employed 15 Teen Employed 16 Adult Employed 17 Adult Unemployed 18 Old Employed 19 Adult Unemployed 20 Child Employed
查詢df1兩列中類別的計數：
示例
table(df1$x1,df1$x2)
輸出
Employed Unemployed Adult 3 4 Child 3 4 Old 3 1 Teen 2 0
示例2
y1<−sample(c("Married","Unmarried"),20,replace=TRUE)
y2<−sample(c("Satisfied","Not-Satisfied"),20,replace=TRUE)
df2<−data.frame(y1,y2)
df2輸出
y1 y2 1 Married Not-Satisfied 2 Unmarried Not-Satisfied 3 Married Not-Satisfied 4 Unmarried Not-Satisfied 5 Married Satisfied 6 Married Not-Satisfied 7 Unmarried Satisfied 8 Married Satisfied 9 Unmarried Not-Satisfied 10 Unmarried Not-Satisfied 11 Unmarried Not-Satisfied 12 Unmarried Not-Satisfied 13 Married Satisfied 14 Married Satisfied 15 Married Satisfied 16 Married Not-Satisfied 17 Married Satisfied 18 Unmarried Satisfied 19 Married Satisfied 20 Married Satisfied
查詢df2兩列中類別的計數：
示例
table(df2$y1,df2$y2)
輸出
Not−Satisfied Satisfied Married 4 8 Unmarried 6 2
更新於：2021年2月9日
5K+ 次瀏覽
廣告