r - 按年份低于阈值的值的百分比-6ren

r - 按年份低于阈值的值的百分比

转载作者：行者123 更新时间：2023-12-04 11:06:51

可能很容易但很难获得。

如何按年份获取以下数据中低于 112 的值的百分比？输出是 2 个值，一个代表一年。

这是我试图推导出百分比的代码，但它为每一行生成一个值，而不是对一年中的所有日期进行汇总:

library(dplyr)

dat= a %>% 
        filter(value < 112) %>%
        group_by(year) %>%
        mutate(per=paste0(round(100*value/value,2),'%'))


a= structure(list(value = c(196, 186, 188, 186, 188, 191, 229, 277, 
    274, 258, 242, 261, 248, 226, 208, 196, 200, 255, 617, 515, 411, 
    328, 280, 267, 261, 251, 245, 236, 228, 220, 242, 345, 462, 515, 
    532, 549, 428, 348, 314, 300, 300, 320, 320, 303, 371, 566, 648, 
    609, 583, 555, 530, 476, 436, 402, 462, 589, 790, 736, 629, 623, 
    745, 1040, 1450, 1460, 1280, 1050, 878, 725, 648, 711, 779, 691, 
    623, 569, 487, 439, 445, 476, 535, 663, 711, 677, 629, 912, 1170, 
    994, 838, 810, 844, 790, 711, 629, 623, 564, 541, 555, 575, 697, 
    671, 756, 1030, 971, 799, 731, 697, 648, 617, 549, 513, 476, 
    433, 481, 784, 1320, 1150, 932, 736, 682, 657, 691, 617, 564, 
    535, 501, 515, 530, 481, 476, 530, 456, 391, 348, 334, 303, 297, 
    289, 286, 283, 289, 283, 279, 273, 267, 254, 245, 238, 238, 238, 
    232, 230, 230, 227, 227, 227, 227, 227, 227, 227, 220, 215, 210, 
    205, 205, 205, 205, 205, 200, 196, 191, 186, 181, 177, 172, 164, 
    160, 156, 156, 156, 154, 152, 152, 148, 144, 138, 133, 125, 114, 
    114, 111, 99.6999969482422, 89.5, 89.5, 88.5999984741211, 88.5999984741211, 
    56.5999984741211, 56.5999984741211, 56.5999984741211, 56.5999984741211, 
    56.5999984741211, 56.5999984741211, 56.5999984741211, 56.5999984741211, 
    56.5999984741211, 56.5999984741211, 56.5999984741211, 56.5999984741211, 
    56.5999984741211, 56.5999984741211, 56.5999984741211, 56.5999984741211, 
    56.5999984741211, 56.5999984741211, 56.5999984741211, 56.5999984741211, 
    48.7000007629395, 48.7000007629395, 48.7000007629395, 48.7000007629395, 
    48.7000007629395, 48.7000007629395, 48.7000007629395, 48.7000007629395, 
    48.7000007629395, 48.4000015258789, 48.0999984741211, 48.0999984741211, 
    48.0999984741211, 47, 47, 46.7000007629395, 46.4000015258789, 
    45.9000015258789, 45.2999992370605, 44.7000007629395, 44.2000007629395, 
    42.5, 41.9000015258789, 42.5, 46.7000007629395, 48.0999984741211, 
    48.0999984741211, 49.5999984741211, 47.2999992370605, 45.2999992370605, 
    39.0999984741211, 32.7999992370605, 32.7999992370605, 34, 34, 
    34.7999992370605, 36, 36, 36, 36, 36, 36, 36, 36, 35.4000015258789, 
    34.7999992370605, 34.7999992370605, 34.7999992370605, 34, 34, 
    34.7999992370605, 35.4000015258789, 36, 36, 36, 36.7999992370605, 
    34.7999992370605, 35.0999984741211, 36.7999992370605, 38.7999992370605, 
    38.7999992370605, 39.5999984741211, 39.5999984741211, 40.7999992370605, 
    40.7999992370605, 40.2000007629395, 39.5999984741211, 38.7999992370605, 
    38.5, 37.7000007629395, 37.7000007629395, 37.7000007629395, 37.7000007629395, 
    37.7000007629395, 37.7000007629395, 37.7000007629395, 37.7000007629395, 
    36.7999992370605, 36.7999992370605, 36.7999992370605, 36.7999992370605, 
    36.7999992370605, 36.7999992370605, 36.7999992370605, 36.7999992370605, 
    36.7999992370605, 36.7999992370605, 36.7999992370605, 36, 36, 
    34.7999992370605, 34, 34, 33.4000015258789, 32.7999992370605, 
    32, 32.5999984741211, 32.5999984741211, 32, 34, 34, 34, 33.4000015258789, 
    32.7999992370605, 32.5999984741211, 33.4000015258789, 33.4000015258789, 
    32.7999992370605, 32.7999992370605, 32, 31.1000003814697, 31.1000003814697, 
    31.1000003814697, 31.1000003814697, 30.6000003814697, 30, 32, 
    45.2999992370605, 56.5999984741211, 66, 68, 74.1999969482422, 
    79.9000015258789, 87.1999969482422, 99.0999984741211, 105, 102, 
    102, 108, 113, 120, 126, 135, 135, 135, 135, 135, 135, 135, 159, 
    179, 218, 187, 159, 139, 135, 135, 124, 128, 124, 124, 135, 135, 
    218, 278, 265, 278, 292, 385, 365, 385, 459, 436, 360, 306, 265, 
    265, 337, 345, 436, 385, 337, 385, 425, 365, 320, 311, 292, 311, 
    337, 436, 413, 354, 306, 278, 213, 246, 228, 208, 199, 189, 179, 
    175, 259, 306, 278, 278, 365, 484, 997, 968, 915, 835, 767, 753, 
    753, 767, 782, 782, 767, 767, 767, 699, 646, 538, 484, 425, 425, 
    459, 646, 1320, 2030, 2100, 1600, 1320, 1130, 1170, 1090, 1140, 
    968, 929, 835, 793, 835, 929, 875, 889, 1040, 1180, 1060, 954, 
    835, 699, 646, 606, 631, 646, 620, 631, 739, 767, 728, 592, 552, 
    566, 631, 552, 498, 436, 394, 413, 436, 1990, 1360, 1060, 900, 
    835, 807, 782, 807, 782, 915, 889, 875, 782, 674, 473, 552, 513, 
    513, 484, 513, 436, 413, 447, 425, 385, 566, 566, 271, 328, 306, 
    306, 283, 252, 228, 223, 218, 228, 234, 252, 218, 218, 208, 208, 
    228, 213, 208, 208, 203, 203, 213, 213, 189, 208, 240, 223, 223, 
    218, 218, 213, 208, 208, 208, 208, 213, 208, 203, 189, 189, 184, 
    179, 175, 171, 159, 163, 159, 146, 150, 154, 159, 159, 154, 146, 
    146, 119, 90.9000015258789, 63.0999984741211, 64.8000030517578, 
    64.8000030517578, 60.9000015258789, 62.9000015258789, 62.9000015258789, 
    62.9000015258789, 58.9000015258789, 58.9000015258789, 65.6999969482422, 
    63.7000007629395, 61.7000007629395, 60, 56.0999984741211, 56.0999984741211, 
    56.0999984741211, 49.2999992370605, 44.5, 42.5, 39.5999984741211, 
    39.5999984741211, 42.5, 41.5999984741211, 36.7999992370605, 36, 
    40.7999992370605, 45.5999984741211, 50.4000015258789, 55.2000007629395, 
    55.2000007629395, 56.0999984741211, 55.2000007629395, 50.4000015258789, 
    49.2999992370605, 48.4000015258789, 47.2999992370605, 50.4000015258789, 
    49.2999992370605, 52.0999984741211, 48.4000015258789, 48.4000015258789, 
    48.4000015258789, 48.4000015258789, 48.4000015258789, 49.2999992370605, 
    47.2999992370605, 48.4000015258789, 48.4000015258789, 48.4000015258789, 
    49.2999992370605), year = c(1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 
    1911, 1911, 1911, 1911, 1911, 1911, 1911, 1911, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 
    1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912, 1912
    )), class = "data.frame", row.names = c(NA, -611L))

最佳答案

一个有用的常见技巧是对值的逻辑向量使用mean 来获得比例:

a %>% 
    group_by(year) %>% 
    summarise(per = scales::percent(mean(value < 112)))
## A tibble: 2 x 2
#   year per  
#  <dbl> <chr>
#1  1911 23.3%
#2  1912 40.7%

关于r - 按年份低于阈值的值的百分比，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/58828020/

文章推荐： Azure 服务总线 : Message size, 技术限制和定价

文章推荐： reactjs - React-i18next 悬念

文章推荐： python - await 是否总是让其他任务有机会执行？

language-agnostic - 百分比、百分比、分数、比例因子的术语？
我的函数概念上都返回相同的东西，但结果可以采用不同的形式: function GetThingy() 有四个不同的函数，每个可以返回不同的东西: 0.071(代表增长 7.1% 的 float 值)
Java 百分比
这个问题在这里已经有了答案: Int division: Why is the result of 1/3 == 0? (19 个回答) 关闭 4 年前。有什么方法可以计算(例如)120 的 50
范围格式中每个单元格的 VBA 百分比
我四处寻找这个，它看起来很简单，但我无法让它工作。我有一张表格，其中一列需要格式化为百分比。下面是我的代码，但它没有格式化单元格，它只是将它们保留为小数。我想这是因为 cell ，即使声明为范围，
WPF - margin 百分比
我刚刚开始使用 WPF。从那以后，我开始关注造型系统。我来自 CSS 背景，我想以百分比设置边距。当前值以像素为单位
真实列的 SQL 百分比
我有一个表，其中每一行都有一个描述字段和一个 bool 值。我正在尝试编写一个查询，我可以在其中按每个相应的描述进行分组，并查看 bool 值为真的次数百分比。示例表: PID Gen
caching - OrientDB中的磁盘缓存如何按读缓存和写缓存分开(百分比)
我从文档中发现，考虑到 orientdb 100% 使用磁盘缓存，它使用的最大大小为 70% 用于读取缓存，30% 用于写入缓存 ( http://orientdb.com/docs/last/plo
Docker CPU 百分比
有什么方法可以获取 docker 容器内部而不是外部的 cpu 百分比吗？! docker stats DOCKER_ID 显示的百分比正是我需要的，但我需要它作为变量。我需要获取容器本身内部的 cp
r - 计算数据集每列的比例(百分比)
我正在尝试计算数据集每列中类别的比例(百分比)。示例数据: df <- data.frame( "Size" = c("Y","N","N","Y","Y"), "Type" =
SQL:你用什么在数据库中存储比率(百分比)？
我应该使用小数还是 float 在数据库中存储比率？特别是在 SQL2005 中。最佳答案这取决于您对准确性的需求。如果您可以容忍来自存储 float 的 IEEE 方法的典型错误，则使用 flo
Lua:随机:百分比
我正在创建一个游戏，目前必须处理一些math.random问题。我的Lua能力不是那么强，你觉得怎么样您能制定一个使用 math.random 和给定百分比的算法吗？我的意思是这样的函数: fu
动态计算的 SQL 百分比
如何在SQL中动态计算百分比？假设您有一个名为 Classes 的下表: ClassSession StudentName -------------------------------
javascript - 掩码输入数字 - 百分比
如何通过 jQuery 创建具有百分比的数字掩码输入？我是否让输入仅接受三个数字，并在用户完成输入时在数字后添加百分号(keyup)？我不使用插件。示例:1% 或 30% 或 99% 或 100%
Python-删除字典对的比例/百分比
我正在尝试构建一个工具，可以突出显示具有最高介数中心性的社交网络节点。我将所有网络节点的测量值计算到字典中，按顺序对字典进行排序，然后仅保留前 3 对。我希望这个工具是可扩展的，所以我想保留前 10
mysql - 同列计算/百分比
MYSQL 中的人员如何将一个日期条目和分数的用户百分比与另一个日期条目和分数进行比较，从而有效地返回从一个日期到另一个日期的用户百分比增加情况？几天来我一直在试图解决这个问题，但我已经没有想法了，
mysql - SQL - 百分比
我需要进行查询，结果是百分比。我现在的查询如下所示: select COUNT(CREATE_WEEKDAY), CREATE_WEEKDAY, COUNT(CREATE
javascript - AJAX图片上传时生成加载条/百分比
我有一个图像上传功能，其工作原理如下: $('.update-insertimage-form').submit(function() { $(".submit-newupdate-btn").add
Html - 容器中的图像高度(百分比)
我的问题很简单，但我仍然找不到这个问题的答案... 假设我们有两个包含图像的容器。我们有类似的东西 #containera { width: 50%; height: 50%; backgr
其他元素的 CSS 百分比
是否可以将 CSS 尺寸指定为除其父元素之外的另一个元素的百分比？例如，我想将 div 的 border-radius 指定为 div 宽度的 10%。但是，border-radius: 10% 在
html - 输入和提交按钮的大小(百分比)
我正在尝试设置按钮的大小并以百分比进行编辑但是这个的线性大小是不同的。为什么？最佳答案您好，问题出在属性 box-sizing 上.默认为 input type
html - 如何将数据可见范围更改为 % 百分比
我将它用于我的页眉，该页眉在一页上下滚动页面中发生变化。我注意到它没有响应，所以我想问你是否知道一种使它响应的方法。就像将 0-690 更改为百分比，以便它可以在移动设备和电视屏幕上使用。 HTML

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

r - 按年份低于阈值的值的百分比