[R] tidyverse: read_csv() misses column

[Rich Shepard]

On Mon, 1 Nov 2021, CALUM POLWART wrote:

> Mutate. Probably. 

Calum,

I thought that I had it working, but I'm still missing a piece.

For example,
> cor_disc %>% 
+ select(year, mon, day, hr, min) %>%
+ mutate(
+ sampdt = make_datetime(year, mon, day, hr, min)
+ )
# A tibble: 415,263 × 6
     year   mon   day    hr   min sampdt
    <int> <int> <int> <dbl> <dbl> <dttm>
  1  2009    10    23     0     0 2009-10-23 00:00:00
  2  2009    10    23     0    15 2009-10-23 00:15:00
  3  2009    10    23     0    30 2009-10-23 00:30:00
  4  2009    10    23     0    45 2009-10-23 00:45:00
  5  2009    10    23     1     0 2009-10-23 01:00:00
  6  2009    10    23     1    15 2009-10-23 01:15:00
  7  2009    10    23     1    30 2009-10-23 01:30:00
  8  2009    10    23     1    45 2009-10-23 01:45:00
  9  2009    10    23     2     0 2009-10-23 02:00:00
10  2009    10    23     2    15 2009-10-23 02:15:00
# … with 415,253 more rows

produces the sampdt column, but it, and the timezone, are not present in the
cor_disc tibble:

> cor_disc A tibble: 415,263 × 8
    site_nbr  year   mon   day    hr   min tz      cfs
    <chr>    <int> <int> <int> <dbl> <dbl> <chr> <int>
  1 14171600  2009    10    23     0     0 PDT    8750
  2 14171600  2009    10    23     0    15 PDT    8750
  3 14171600  2009    10    23     0    30 PDT    8750
  4 14171600  2009    10    23     0    45 PDT    8750
  5 14171600  2009    10    23     1     0 PDT    8750
  6 14171600  2009    10    23     1    15 PDT    8750
  7 14171600  2009    10    23     1    30 PDT    8750
  8 14171600  2009    10    23     1    45 PDT    8730
  9 14171600  2009    10    23     2     0 PDT    8730
10 14171600  2009    10    23     2    15 PDT    8730
# … with 415,253 more rows

Is the error in the select() or mutate() function specifications?

Thanks,

Rich