如何在 R 中的同一数据集下使用 rename() 和 rename_with()

发布于03月07日

A data.frame: 6 × 3
Id  ActivityDay Calories
<dbl>   <chr>   <int>
1   1503960366  4/12/2016   1985
2   1503960366  4/13/2016   1797
3   1503960366  4/14/2016   1776
4   1503960366  4/15/2016   1745
5   1503960366  4/16/2016   1863
6   1503960366  4/17/2016   1728

上面是数据集的head()预览，我试图将列名ActivityDay转换为ActivityDate，同时将所有列名转换为小写，以下是我的代码:

# calories
calories %>%
    rename_with(calories, tolower) %>%
    rename(activitydate=activityday)
Error: Can't rename columns that don't exist.
✖ Column `ActivityDay` doesn't exist.

请帮我指出我在代码上哪里做错了，谢谢！

推荐答案

您不需要调用calories(您的数据帧名称)两次:

calories %>% 
  rename_with(tolower) %>% 
  rename(activitydate = activityday)

数据

calories <- structure(list(Id = c(1503960366L, 1503960366L, 1503960366L, 
1503960366L, 1503960366L, 1503960366L), ActivityDay = c("4/12/2016", 
"4/13/2016", "4/14/2016", "4/15/2016", "4/16/2016", "4/17/2016"
), Calories = c(1985L, 1797L, 1776L, 1745L, 1863L, 1728L)), class = "数据.frame", row.names = c("1", 
"2", "3", "4", "5", "6"))