You need to enable JavaScript to run this app. 仅使用R基础命令分国家计算7日每10万人口病例指标indicator7
优惠活动
大模型
产品
解决方案
定价
更多

仅使用R基础命令分国家计算7日每10万人口病例指标indicator7

R语言7日统计指标创建需求
  • 数据集样式参考

核心任务

在R环境中新增列存储指定的7日统计指标。

指标计算规则

需创建数值型变量indicator7,计算逻辑为:统计对应国家近7天(包含当日)的累计病例数,换算为每10万居民对应的病例数。

现有数据集信息

当前使用的dataframe共包含3类字段,总观测数55000余条:

  • df.date:POSIXct格式的日期列
  • df.cases:当日病例数列
  • df.countriesAndTerritories:所属国家列

实现约束

  • 刚从MS Excel迁移到R开发,不熟悉复杂自动化逻辑实现
  • 仅可使用base R原生命令,禁止依赖任何第三方扩展包

示例数据结构(dput输出)

dput(head(ind7,50))
structure(list(df.date = structure(c(-61665929608, -61697465608, 
-61729001608, -61760537608, -61792160008, -61823696008, -61855232008, 
-61886768008, -61918390408, -61949926408, -61981462408, -62012998408, 
-62044620808, -62076156808, -62107692808, -61163686408, -61195222408, 
-61226758408, -61258294408, -61289916808, -61321452808, -61352988808, 
-61384524808, -61416147208, -61447683208, -61479219208, -61510755208, 
-61542377608, -61573913608, -61605449608, -61636985608, -61668608008, 
-61700144008, -61731680008, -61763216008, -61794838408, -61826374408, 
-61857910408, -61889446408, -61921068808, -61952604808, -61984140808, 
-62015676808, -62047299208, -62078835208, -62110371208, -61197814408, 
-61229350408, -61260886408, -61292508808), class = c("POSIXct", 
"POSIXt"), tzone = ""), df.cases = c(205L, 66L, 360L, 146L, 0L, 
224L, 80L, 126L, 58L, 40L, 121L, 86L, 95L, 132L, 76L, 157L, 123L, 
0L, 113L, 199L, 65L, 81L, 61L, 116L, 135L, 88L, 87L, 59L, 68L, 
47L, 0L, 32L, 66L, 129L, 96L, 0L, 10L, 77L, 68L, 62L, 145L, 44L, 
7L, 5L, 17L, 14L, 15L, 12L, 0L, 35L), df.countriesAndTerritories = structure(c(1L, 
1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 
1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 
1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 
1L), .Label = c("Afghanistan", "Albania", "Algeria", "Andorra", 
"Angola", "Anguilla", "Antigua_and_Barbuda", "Argentina", "Armenia", 
"Aruba", "Australia", "Austria", "Azerbaijan", "Bahamas", "Bahrain", 
"Bangladesh", "Barbados", "Belarus", "Belgium", "Belize", "Benin", 
"Bermuda", "Bhutan", "Bolivia", "Bonaire, Saint Eustatius and Saba", 
"Bosnia_and_Herzegovina", "Botswana", "Brazil", "British_Virgin_Islands", 
"Brunei_Darussalam", "Bulgaria", "Burkina_Faso", "Burundi", "Cambodia", 
"Cameroon", "Canada", "Cape_Verde", "Cases_on_an_international_conveyance_Japan", 
"Cayman_Islands", "Central_African_Republic", "Chad", "Chile", 
"China", "Colombia", "Comoros", "Congo", "Costa_Rica", "Cote_dIvoire", 
"Croatia", "Cuba", "Curaçao", "Cyprus", "Czechia", "Democratic_Republic_of_the_Congo", 
"Denmark", "Djibouti", "Dominica", "Dominican_Republic", "Ecuador", 
"Egypt", "El_Salvador", "Equatorial_Guinea", "Eritrea", "Estonia", 
"Eswatini", "Ethiopia", "Falkland_Islands_(Malvinas)", "Faroe_Islands", 
"Fiji", "Finland", "France", "French_Polynesia", "Gabon", "Gambia", 
"Georgia", "Germany", "Ghana", "Gibraltar", "Greece", "Greenland", 
"Grenada", "Guam", "Guatemala", "Guernsey", "Guinea", "Guinea_Bissau", 
"Guyana", "Haiti", "Holy_See", "Honduras", "Hungary", "Iceland", 
"India", "Indonesia", "Iran", "Iraq", "Ireland", "Isle_of_Man", 
"Israel", "Italy", "Jamaica", "Japan", "Jersey", "Jordan", "Kazakhstan", 
"Kenya", "Kosovo", "Kuwait", "Kyrgyzstan", "Laos", "Latvia", 
"Lebanon", "Lesotho", "Liberia", "Libya", "Liechtenstein", "Lithuania", 
"Luxembourg", "Madagascar", "Malawi", "Malaysia", "Maldives", 
"Mali", "Malta", "Marshall_Islands", "Mauritania", "Mauritius", 
"Mexico", "Moldova", "Monaco", "Mongolia", "Montenegro", "Montserrat", 
"Morocco", "Mozambique", "Myanmar", "Namibia", "Nepal", "Netherlands", 
"New_Caledonia", "New_Zealand", "Nicaragua", "Niger", "Nigeria", 
"North_Macedonia", "Northern_Mariana_Islands", "Norway", "Oman", 
"Pakistan", "Palestine", "Panama", "Papua_New_Guinea", "Paraguay", 
"Peru", "Philippines", "Poland", "Portugal", "Puerto_Rico", "Qatar", 
"Romania", "Russia", "Rwanda", "Saint_Kitts_and_Nevis", "Saint_Lucia", 
"Saint_Vincent_and_the_Grenadines", "San_Marino", "Sao_Tome_and_Principe", 
"Saudi_Arabia", "Senegal", "Serbia", "Seychelles", "Sierra_Leone", 
"Singapore", "Sint_Maarten", "Slovakia", "Slovenia", "Solomon_Islands", 
"Somalia", "South_Africa", "South_Korea", "South_Sudan", "Spain", 
"Sri_Lanka", "Sudan", "Suriname", "Sweden", "Switzerland", "Syria", 
"Taiwan", "Tajikistan", "Thailand", "Timor_Leste", "Togo", "Trinidad_and_Tobago", 
"Tunisia", "Turkey", "Turks_and_Caicos_islands", "Uganda", "Ukraine", 
"United_Arab_Emirates", "United_Kingdom", "United_Republic_of_Tanzania", 
"United_States_of_America", "United_States_Virgin_Islands", "Uruguay", 
"Uzbekistan", "Vanuatu", "Venezuela", "Vietnam", "Wallis_and_Futuna", 
"Western_Sahara", "Yemen", "Zambia", "Zimbabwe"), class = "factor")), row.names = c(NA, 
50L), class = "data.frame")

内容的提问来源于stack exchange,提问作者Trisha Morgan

相关产品推荐
方舟 Agent Plan

超全模态模型 × Harness 升级,最新支持 Deepseek-V4.1-Flash、GLM-5.3 系列、Doubao-Seedream-5.0-pro、Kimi-K3 (部分), 限时 9.9 元起

最近更新时间:2026.11.11 12:54:03