纵向数据固定时间间隔分箱及按土地类别绘制X值分箱时间线咨询
数据预处理与分箱实现
首先修正示例代码中的语法错误,生成符合要求的纵向数据集,再按需求完成分箱操作:
# 加载依赖包 library(dplyr) library(ggplot2) # 修正后的数据生成代码 set.seed(123) ID <- 1:5 Time <- rep(c(1,2,3,4,5), each = 20) # 修正Land列长度匹配问题 Land <- rep(c("small farmers", "medium-farmers", "large farmers"), length.out = length(Time)) data <- data.frame( IDn = rep(ID, length.out = length(Time)), Time = Time, Land = Land, y = rnorm(length(Time), 0, 1), x = runif(length(Time), 0, 1) ) # 按时间步+土地类别分组,对x值划分3个分箱,对应小型/中型/大型三个层级 data_binned <- data %>% group_by(Time, Land) %>% mutate(x_bin = factor(ntile(x, 3), levels = 1:3, labels = c("小型", "中型", "大型"))) %>% ungroup()
趋势可视化实现
1. 分箱趋势折线+散点图
可同时展示原始散点分布和不同分箱的均值随时间的变化趋势:
ggplot(data_binned, aes(x = Time, color = x_bin)) + # 原始散点,调整透明度避免重叠 geom_jitter(aes(y = x), alpha = 0.4, size = 1.5) + # 各分箱的x均值趋势线 stat_summary(aes(y = x, group = x_bin), fun = mean, geom = "line", linewidth = 1) + stat_summary(aes(y = x, group = x_bin), fun = mean, geom = "point", size = 3) + # 按土地类别分面 facet_wrap(~Land) + labs(x = "时间步长", y = "X值", color = "X值分箱层级") + theme_bw()
2. 分面点图实现
如果需要按时间+土地类别分面展示分箱分布,可使用如下代码:
ggplot(data_binned, aes(x = x_bin, y = x, color = x_bin)) + geom_jitter(alpha = 0.4, width = 0.2) + stat_summary(fun = median, geom = "point", size = 3, color = "black") + facet_grid(Land~Time) + labs(x = "X值分箱层级", y = "X值") + theme_bw() + theme(axis.text.x = element_text(angle = 45, hjust = 1))
内容的提问来源于stack exchange,提问作者Sadaf
相关产品推荐
相关产品推荐

