我希望解决一些关于列名的问题,这些问题在执行代码时会导致错误。下面我将展示一个简单的例子。请注意,我有一个名为
TimeofCalculate
的列,而下面的代码是 Timeofcalculate
,因为代码中的 calculate
是小写的,所以会出现错误。然而,我希望任何一种写法都可以在代码中运行。此外,我有一个名为 Timeofcalculâte
的数据库列,其中包含了一个 â
字符,这是我所在地区常见的字符。因此,我希望解决上述问题。library(dplyr)
Test <- structure(list(date1 = as.Date(c("2021-11-01","2021-11-01","2021-11-01","2021-11-01")),
date2 = as.Date(c("2021-10-22","2021-10-22","2021-10-28","2021-10-30")),
Week = c("Friday", "Friday", "Thursday", "thursday"),
Category = c("FDE", "FDE", "FDE", "FDE"),
TimeofCalculate = c(4, 6, 6, 3)), class = "data.frame",row.names = c(NA, -4L))
Test %>%
group_by(Week = tools::toTitleCase(Week)) %>%
summarise(Time=mean(Timeofcalculate), .groups = 'drop')
summarise(Time=mean(Timeofcalculate), .groups = 'drop')
,这里的Time
是标题,但在你的代码中却没有了。我发现你不能使用summarise(Time=across(matches(nms), mean), .groups = 'drop')
,那么我该如何调整呢?你知道吗?再次感谢! - Antonio.names
参数:summarise(across(matches(nms), mean, .names = 'Time'), .groups = 'drop')
。这是你要找的吗? - jpdugo17