Convert a numeric number to date

Question

DATA as.POSIXct(DADOS1[c(3:n), c(1)], tz = "GMT", origin = "1970-01-01")

I have a dataset with many columns and I want to convert the first column which is a numeric number to a date. With the command that I am using it is giving an error: "Error in as.POSIXct.default(DADOS1[c(3:n), c(1)], tz = "GMT", origin = "1970-01-01") : do not know how to convert 'DADOS1[c(3:n), c(1)]' to class “POSIXct”"

Please post `dput(head(DADOS1[,1:2]))` through edit. Also, why do you want to convert the column beginning with row 3? It's most likely not possible to store the result in the same data frame column. — Andre Wildberg, Mar 15 '23 at 15:10
I uploaded an image with many values. I do not want to convert the 1 and 2 line because are not numbers. — Roberto Nogueira, Mar 15 '23 at 15:22
Your data is not numeric, it has on the first two rows "header" like info, making the whole column of type character. — Merijn van Tilborg, Mar 15 '23 at 15:41

score 0 · Answer 1 · answered Mar 15 '23 at 15:12

0

You can do something like this:

df <- data.frame(
  date = 20230301:20230401
)
df$date <- as.POSIXct(df$date, tz = "GMT", origin = "1970-01-01")

I am not sure what DADOS1 is. Could you please include an example data?

answered Mar 15 '23 at 15:12

Shubham

220
2
10

I uploaded an image, if you can check I would appreciate it. – Roberto Nogueira Mar 15 '23 at 15:24

Convert a numeric number to date

1 Answers1