R语言:如何将列表某列数值转换为对应文字(以BMI分类为例)
BMI数值转分类文本实现方案
你拟定的分段判断规则如下:
underweight = BMI < 18.5 normal = between(BMI, 18.5, 24.9) overweight = between(BMI, 25, 29.9) obese = between(BMI, 30, 34.9) extreme = BMI > 35
注意:当前拟定的分段规则存在数值边界缝隙,比如BMI=24.95这类数值,既不满足normal区间的上限24.9,也不满足overweight区间的下限25,会被判定为缺失值,可根据实际业务需求确认是否调整为连续无断点的区间。
方案1:使用dplyr的case_when()函数(推荐,可读性强)
不需要多层嵌套,逻辑和你写的判断式完全一致,匹配效率高。如果需要输出中文分类标签,直接将代码里的英文文本替换为对应中文即可,例如BMI < 18.5 ~ "体重过轻"
# 加载依赖包 library(dplyr) # 假设数据框为df,BMI列为待转换的数值列 df <- df %>% mutate( BMI分类 = case_when( BMI < 18.5 ~ "underweight", between(BMI, 18.5, 24.9) ~ "normal", between(BMI, 25, 29.9) ~ "overweight", between(BMI, 30, 34.9) ~ "obese", BMI > 35 ~ "extreme", .default = NA_character_ ) )
方案2:使用base R原生cut()函数(无需加载额外包)
适合批量分箱场景,可自动匹配连续区间:
# 匹配你给出的非连续分段规则的写法 df$BMI分类 <- cut( x = df$BMI, breaks = c(-Inf, 18.5, 24.9, 29.9, 34.9, Inf), labels = c("underweight", "normal", "overweight", "obese", "extreme"), right = TRUE, include.lowest = TRUE )
若要补全区间缝隙,可将
breaks调整为连续值c(-Inf, 18.5, 25, 30, 35, Inf),设置right = FALSE,实现无遗漏的连续分箱。
方案3:多层ifelse()嵌套(无额外依赖)
可以实现功能,但分段数量多的时候嵌套层级深、可读性差,示例:
df$BMI分类 <- ifelse(df$BMI < 18.5, "underweight", ifelse(dplyr::between(df$BMI, 18.5, 24.9), "normal", ifelse(dplyr::between(df$BMI, 25, 29.9), "overweight", ifelse(dplyr::between(df$BMI, 30, 34.9), "obese", ifelse(df$BMI > 35, "extreme", NA_character_)))))
内容的提问来源于stack exchange,提问作者Lin
相关产品推荐
相关产品推荐

