如何根据R中另一列的日期(月/日/年)计算一列的年/月平均值、最大值、最小值等

# 创建一个包含日期和数值的数据框
data <- data.frame(
  date = c("01/01/2022", "02/01/2022", "03/01/2022", "04/01/2022", "05/01/2022"),
  value = c(10, 20, 30, 40, 50)
)

# 将日期列转换为日期格式
data$date <- as.Date(data$date, format = "%m/%d/%Y")

# 计算年平均值
year_avg <- aggregate(value ~ format(date, "%Y"), data, mean)
print(year_avg)

# 计算月平均值
month_avg <- aggregate(value ~ format(date, "%Y-%m"), data, mean)
print(month_avg)

# 计算年最大值
year_max <- aggregate(value ~ format(date, "%Y"), data, max)
print(year_max)

# 计算月最大值
month_max <- aggregate(value ~ format(date, "%Y-%m"), data, max)
print(month_max)

# 计算年最小值
year_min <- aggregate(value ~ format(date, "%Y"), data, min)
print(year_min)

# 计算月最小值
month_min <- aggregate(value ~ format(date, "%Y-%m"), data, min)
print(month_min)