Problem with tidyverse parsing functions

Dear Braintrust,
I'm trying to tidy a large dataset from a text file (.txt).
importing the dataset with read_delim I'm trying to convert different columns in the right format such as datetime and factor
my date are in the format "2008-12-01 13:44:00" (ex with date_maj column name)
when automatically guessing the format when importing these have been recognized as character vectors.
when trying the code :
dataset %>% parse_datetime(date_maj)
I receive the error message
Error: is.character(x) is not TRUE
however when typing is.character(date_maj) it's TRUE
I try to retype as.character(date_maj) and other manipulation and did not get any other things than the message error. I had the same type of error in the column I want to convert as factors.
is there any clue/documentation on that type of error and how to solve the problem?
I try to google this error message but did not had a clear answer
thanks for your time!

Using the pipe here, it is as if you're asking for

parse_datetime(dataset, date_maj)

If you read the doc, parse_datetime does not work that way with a data.frame as first argument.

You did not provide a reproductible example so I can't check, but this should work like that

parse_datetime(dataset$date_maj)

or

library(dplyr)
dataset %>% mutate(date_maj2 = parse_datetime(date_maj))

parse_datetime function works on vector only.

Hope it helps

2 Likes

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.