dplyr`pivot_longer()`对象未找到，但是就在那里吗? [英] dplyr `pivot_longer()` object not found but it's right there?

问题描述

library(tidyverse)
df <- tibble(Date = as.Date(c("2020-01-01", "2020-01-02")),
             Shop = c("Store A", "Store B"),
             Employees = c(5, 10),
             Sales = c(1000, 3000))

#> # A tibble: 2 x 4
#>   Date       Shop    Employees Sales
#>   <date>     <chr>       <dbl> <dbl>
#> 1 2020-01-01 Store A         5  1000
#> 2 2020-01-02 Store B        10  3000

我正在按照 dplyr参考指南从dplyr传播/收集切换到ivot_ *.一个>.我想通过以下方式收集员工"和销售"列:

I'm switching from dplyr spread/gather to pivot_* following the dplyr reference guide. I want to gather the "Employees" and "Sales" columns in the following manner:

df %>% pivot_longer(-Date, -Shop, names_to = "Names", values_to = "Values")
#> Error in build_longer_spec(data, !!cols, names_to = names_to, 
#> values_to = values_to, : object 'Shop' not found

但是我遇到了这个错误.好像我在做正确的一切.除了我显然不是.你知道出了什么问题吗?

But I'm getting this error. It seems as though I'm doing everything right. Except that I'm apparently not. Do you know what went wrong?

推荐答案

cols 参数是要透视的所有列.您可以将其视为 reshape2 :: melt

The cols argument is all of the columns you want to pivot. You can think of it as the complement of the id.vars argument from reshape2::melt

df %>% pivot_longer(-c(Date, Shop), names_to = "Names", values_to = "Values")

与:

reshape2::melt(df, id.vars=c("Date", "Shop"), variable.name="Names", value.name="Value")

这篇关于dplyr`pivot_longer()`对象未找到，但是就在那里吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！