i cant arrange the coloum season_month

[dezz12ew]

library(tidyverse)
rodents_full<-read_tsv("https://bit.ly/rodents_full")
rodents_full%>%
  select(record_id,month,day,year,season_month,species_id,plot_id,species_id,sex,hindfoot_length,weight,genus,hindfoot_length,weight,genus,species,taxa,plot_type)%>%
    mutate(season_month = case_when(
    month == "1" | month == "2" | month =="12" ~ "winter",
    month == "3"| month == "4" | month=="5" ~ "spring",
    month =="6" | month == "7" | month =="8" ~ "summer",
    month =="11"|month =="10"| month =="9"~"autumn"))%>%
  arrange(record_id,month,day,year,season_month,plot_id,species_id,sex,hindfoot_length,weight,genus,hindfoot_length,weight,genus,species,taxa,plot_type)

i have been told that i need to use arrange as a call back but when i do it comes back as an error with it saying season_month column doesnt exist

[technocrat]

Always start by seeing what is in the source data.

rodents_full <- readr::read_tsv("https://bit.ly/rodents_full")
#> Rows: 34786 Columns: 13
#> ── Column specification ────────────────────────────────────────────────────────
#> Delimiter: "\t"
#> chr (6): species_id, sex, genus, species, taxa, plot_type
#> dbl (7): record_id, month, day, year, plot_id, hindfoot_length, weight
#> 
#> ℹ Use `spec()` to retrieve the full column specification for this data.
#> ℹ Specify the column types or set `show_col_types = FALSE` to quiet this message.
colnames(rodents_full)
#>  [1] "record_id"       "month"           "day"             "year"           
#>  [5] "plot_id"         "species_id"      "sex"             "hindfoot_length"
#>  [9] "weight"          "genus"           "species"         "taxa"           
#> [13] "plot_type"

[stonepeople]

If you move the select() call to the end it works. You ask it to select season_month before it has done the necessary mutate()