You need to enable JavaScript to run this app. 纵向数据固定时间间隔分箱及按土地类别绘制X值分箱时间线咨询
优惠活动
大模型
产品
解决方案
定价
更多

纵向数据固定时间间隔分箱及按土地类别绘制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

相关产品推荐
方舟 Agent Plan

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

最近更新时间:2026.10.19 14:15:02