Hi everybody,
I would like to transfer date from the format in the data below into the format yyyy-mm-dd
df<-data.frame(
rf = c(7, 7.2, 7.6, 7.35, 7.7, 7.9, 7.6, 7.6, 7.35, 8.45),
date = as.factor(c("31-07-07","31-08-07",
"30-09-07","31-10-07","30-11-07","31-12-07",
"31-01-08","29-02-08","31-03-08","30-04-08"))
)
I tried some code but fail. The code I tried
The result turns to NA value
df<-read.csv("rf1.csv")
df$date<-as.character(df$date)
df$date<-as.Date(df$date,format='%d-%b-%y')
The result turns to 0031 value at year
df<-read.csv("rf1.csv")
df$date<-as.Date(df$date)
df$date<-as.Date(df$date,format='%d-%b-%y')
class(df$date)
The result turns to 2031-07-12, wrong year
library(lubridate)
df<-read.csv("rf1.csv")
ymd(df$date)
I would appreciate any help.
Thank you