col_datetime() missing argument

williaml · December 9, 2020, 5:11am

Otherwise, I asked this question a while ago. It might apply to what you are doing:

Columns being read in by read_excel as a date instead of numeric General

I have used read_excel from to read in a file. It picks up one of the columns as a date, instead of numeric. Is there a way of fixing this? I am aware of col_types within read_excel, but there are 39 columns, so am not going to enter them all. read_in <- structure(list(read_in = structure(c(-2201817600, -2206915200, NA, -2204755200, -2200953600, -2200521600, -2205619200, -2204755200), tzone = "UTC", class = c("POSIXct", "POSIXt" ))), row.names = c(NA, -8L), class = c("tbl_df", "tbl", "data.frame" )) actual <- c(85, 25, NA, 50, 95, 100, 40, 50) converted <- read_in %>% mutate(decrease = as.numeric(decrease)) df <- tibble(read_in, actual) %>% mutate(converted = as.numeric(read_in)/…