R如何从size数据生成size类

Question

我正在尝试为我收集的珊瑚大小数据生成一个大小类的向量。我想要做的是创建一个新列，表示每个单独度量的size类。

我希望大小类以每10个度量单位为基础。例如，如果珊瑚的大小是1-10，我希望它是1级大小，如果11-20我希望它是2级大小，如果21-30我希望是3级大小，依此类推。

任何帮助完成这项看似简单的任务的人都将不胜感激。谢谢!

数据库

structure(list(Coral = c(1, 2, 3, 4, 5, 6), Size = c(6, 10, 12, 
40, 14, 22)), class = c("spec_tbl_df", "tbl_df", "tbl", "data.frame"
), row.names = c(NA, -6L), spec = structure(list(cols = list(
    Coral = structure(list(), class = c("collector_double", "collector"
    )), Size = structure(list(), class = c("collector_double", 
    "collector"))), default = structure(list(), class = c("collector_guess", 
"collector")), skip = 1), class = "col_spec"))

期望输出

structure(list(Coral = c(1, 2, 3, 4, 5, 6), Size = c(6, 10, 12, 
40, 14, 22), `Size Class` = c(1, 1, 2, 4, 2, 3)), class = c("spec_tbl_df", 
"tbl_df", "tbl", "data.frame"), row.names = c(NA, -6L), spec = structure(list(
    cols = list(Coral = structure(list(), class = c("collector_double", 
    "collector")), Size = structure(list(), class = c("collector_double", 
    "collector")), `Size Class` = structure(list(), class = c("collector_double", 
    "collector"))), default = structure(list(), class = c("collector_guess", 
    "collector")), skip = 1), class = "col_spec"))

Answer 1

您可以使用ceiling：

df$Size_class <- ceiling(df$Size/10)

#  Coral  Size Size_class
#  <dbl> <dbl>      <int>
#1     1     6          1
#2     2    10          1
#3     3    12          2
#4     4    40          4
#5     5    14          2
#6     6    22          3

或findInterval

df$Size_class <- findInterval(df$Size, seq(0, max(df$Size), 10), left.open = TRUE)