{"id":2068,"date":"2023-07-23T20:22:25","date_gmt":"2023-07-23T20:22:25","guid":{"rendered":"https:\/\/statorials.org\/ja\/dplyr-%e3%81%ae%e3%82%af%e3%82%99%e3%83%ab%e3%83%bc%e3%83%95%e3%82%9a%e5%88%a5%e5%88%86%e9%a1%9e\/"},"modified":"2023-07-23T20:22:25","modified_gmt":"2023-07-23T20:22:25","slug":"dplyr-%e3%81%ae%e3%82%af%e3%82%99%e3%83%ab%e3%83%bc%e3%83%95%e3%82%9a%e5%88%a5%e5%88%86%e9%a1%9e","status":"publish","type":"post","link":"https:\/\/statorials.org\/ja\/dplyr-%e3%81%ae%e3%82%af%e3%82%99%e3%83%ab%e3%83%bc%e3%83%95%e3%82%9a%e5%88%a5%e5%88%86%e9%a1%9e\/","title":{"rendered":"Dplyr \u3092\u4f7f\u7528\u3057\u3066\u5909\u6570\u3092\u30b0\u30eb\u30fc\u30d7\u5225\u306b\u4e26\u3079\u66ff\u3048\u308b\u65b9\u6cd5"},"content":{"rendered":"

<\/p>\n

\n

\u6b21\u306e\u57fa\u672c\u69cb\u6587\u3092\u4f7f\u7528\u3057\u3066\u3001dplyr \u3067\u5909\u6570\u3092\u30b0\u30eb\u30fc\u30d7\u5316\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n

 df %>% arrange<\/span> (group_var, numeric_var) %>%\n    group_by<\/span> (group_var) %>% \n    mutate<\/span> (rank = rank(numeric_var))\n<\/strong><\/pre>\n
\u6b21\u306e\u4f8b\u306f\u3001\u6b21\u306e\u30c7\u30fc\u30bf \u30d5\u30ec\u30fc\u30e0\u3067\u3053\u306e\u69cb\u6587\u3092\u5b9f\u969b\u306b\u4f7f\u7528\u3059\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n
 #create data frame\n<\/span>df <- data. frame<\/span> (team = c('A', 'A', 'A', 'A', 'B', 'B', 'B', 'C', 'C', 'C'),\n                 points = c(12, 28, 19, 22, 32, 45, 22, 28, 13, 19),\n                 rebounds = c(5, 7, 7, 12, 11, 4, 10, 7, 8, 8))\n\n#view data frame<\/span>\ndf\n\n   team points rebounds\n1 to 12 5\n2 to 28 7\n3 to 19 7\n4 A 22 12\n5 B 32 11\n6 B 45 4\n7 B 22 10\n8 C 28 7\n9 C 13 8\n10 C 19 8\n<\/strong><\/pre>\n
\u4f8b 1: \u6607\u9806\u3067\u306e\u30e9\u30f3\u30ad\u30f3\u30b0<\/strong><\/span><\/h3>\n
\u6b21\u306e\u30b3\u30fc\u30c9\u306f\u3001\u30d7\u30ec\u30fc\u30e4\u30fc\u304c\u7372\u5f97\u3057\u305f\u30dd\u30a4\u30f3\u30c8\u3092\u30c1\u30fc\u30e0\u3054\u3068\u306b\u30b0\u30eb\u30fc\u30d7\u5316\u3057\u3066\u6607\u9806\u306b\u4e26\u3079\u66ff\u3048\u308b\u65b9\u6cd5\u3092\u793a\u3057\u3066\u3044\u307e\u3059\u3002<\/span><\/p>\n
 library<\/span> (dplyr)<\/span>\n\n#rank points scored, grouped by team<\/span>\ndf %>% arrange<\/span> (team, points) %>%\n    group_by<\/span> (team) %>% \n    mutate<\/span> (rank = rank(points))\n\n# A tibble: 10 x 4\n# Groups: team [3]\n   team points rebounds rank\n          \n 1 A 12 5 1\n 2 A 19 7 2\n 3 A 22 12 3\n 4 A 28 7 4\n 5 B 22 10 1\n 6 B 32 11 2\n 7 B 45 4 3\n 8 C 13 8 1\n 9 C 19 8 2\n10 C 28 7 3<\/strong><\/pre>\n
\u4f8b 2: \u964d\u9806\u3067\u306e\u30e9\u30f3\u30ad\u30f3\u30b0<\/strong><\/span><\/h3>\n
Rank()<\/strong>\u95a2\u6570\u5185\u3067\u8ca0\u306e\u7b26\u53f7\u3092\u4f7f\u7528\u3057\u3066\u3001\u30b9\u30b3\u30a2\u3055\u308c\u305f\u30dd\u30a4\u30f3\u30c8\u3092\u30b0\u30eb\u30fc\u30d7\u3054\u3068\u306b\u964d\u9806\u306b\u5206\u985e\u3059\u308b\u3053\u3068\u3082\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n
 library<\/span> (dplyr)<\/span>\n\n#rank points scored in reverse, grouped by team<\/span>\ndf %>% arrange<\/span> (team, points) %>%\n    group_by<\/span> (team) %>% \n    mutate<\/span> (rank = rank(-points))\n\n# A tibble: 10 x 4\n# Groups: team [3]\n   team points rebounds rank\n          \n 1 to 12 5 4\n 2 A 19 7 3\n 3 A 22 12 2\n 4 A 28 7 1\n 5 B 22 10 3\n 6 B 32 11 2\n 7 B 45 4 1\n 8 C 13 8 3\n 9 C 19 8 2\n10 C 28 7 1\n<\/strong><\/pre>\n
\u30e9\u30f3\u30ad\u30f3\u30b0\u3067\u306e\u540c\u70b9\u306e\u6271\u3044\u65b9<\/strong><\/span><\/h3>\n
tie.method<\/strong>\u5f15\u6570\u3092\u4f7f\u7528\u3057\u3066\u3001\u6570\u5024\u3092\u4e26\u3079\u66ff\u3048\u308b\u3068\u304d\u306b\u30bf\u30a4\u3092\u51e6\u7406\u3059\u308b\u65b9\u6cd5\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n
 rank(points, ties. method<\/span> = ' average<\/span> ')\n<\/strong><\/pre>\n
\u6b21\u306e\u30aa\u30d7\u30b7\u30e7\u30f3\u306e\u3044\u305a\u308c\u304b\u3092\u4f7f\u7528\u3057\u3066\u3001\u30ea\u30f3\u30af\u306e\u51e6\u7406\u65b9\u6cd5\u3092\u6307\u5b9a\u3067\u304d\u307e\u3059\u3002<\/span><\/p>\n