Trouble applying pivot_longer to data set (R)

Question

relig_income_tidy <-   relig_income %>% 
pivot_longer(-religion, names_to = "income", values_to = "count")
glimpse(relig_income_tidy)

This is the 'tutorial' dataset that is given in the help section. It works, but when I try to apply the same code to my own dataset:

blackamoor2k19_tidy <- blackamoor2k19 %>% 
pivot_longer(-LIST, -Waypoint -Site, -Recorder, -Date, -Time, -Route, -VisitNumber, names_to = "Species", values_to = "count")

It does not work, resulting in the following error:

Error in build_longer_spec(data, !!cols, names_to = names_to, values_to = values_to,  : 
  object 'Waypoint' not found

The dataset has the columns I've mentioned in my line of code, as well as additional columns of various bird species which I want to convert to rows. I've tried a few things but I can't seem to figure it out.

Thanks!

You should add a comma between `-Waypoint` and `-Site` – Marco Sandri Jul 20 '20 at 17:28 — Marco Sandri, Jul 20 '20 at 17:28

dave-edison · Accepted Answer · 2020-07-20T18:40:06.957

0

You need to wrap your column selections with c, this should work:

blackamoor2k19_tidy <- blackamoor2k19 %>% 
    pivot_longer(c(-LIST, -Waypoint, -Site, -Recorder, -Date, -Time, -Route, -VisitNumber), 
    names_to = "Species", values_to = "count")

edited Jul 20 '20 at 18:40

answered Jul 20 '20 at 17:17

dave-edison

3,666
7
19

Thanks, worked! I think you made a typo by not including a comma after -Waypoint though :) – Kodewings Jul 20 '20 at 17:33

Trouble applying pivot_longer to data set (R)

1 Answers1