我正在尝试检索数据框中存在的特定列中重复次数最多的值,这是下面的示例数据和代码。
data("Forbes2000", package = "HSAUR")
head(Forbes2000)
rank name country category sales profits assets marketvalue
1 1 Citigroup United States Banking 94.71 17.85 1264.03 255.30
2 2 General Electric United States Conglomerates 134.19 15.59 626.93 328.54
3 3 American Intl Group United States Insurance 76.66 6.46 647.66 194.87
4 4 ExxonMobil United States Oil & gas operations 222.88 20.96 166.99 277.02
5 5 BP United Kingdom Oil & gas operations 232.57 10.27 177.57 173.54
6 6 Bank of America United States Banking 49.01 10.81 736.45 117.55
根据我的样本数据,我需要返回最重复的类别是保险。
subset(subset(Forbes2000,country=="Bermuda")
最佳答案
tail(names(sort(table(Forbes2000$category))), 1)