Convert Date in YYYYMM to YYYY-MM-DD

Question

I have a data frame in the format of:

["201301",1111],["201302",1111],["201702",2222],["201603",3333].

When I try to plot it using ggplot, there is a huge gap between years. I think the problem is caused by x value is consider as number.

Is it possible to fix the issue without using other libries?

Thanks!

So what have you tried in order to convert that text to a date? — camille, May 07 '19 at 16:04

score 2 · Answer 1 · answered May 07 '19 at 15:51

2

One option is to paste a day and then use as.Date

as.Date(paste0("201301", "01"), "%Y%m%d")
#[1] "2013-01-01"

answered May 07 '19 at 15:51

akrun

Thanks! I want to apply it to the whole data frame. I tried: df$V1 <- as.Date(paste0(df$V1, "01"), "%Y%m%d") But, it doesn't work. – kevin May 07 '19 at 15:56
@chen What is the error message – akrun May 07 '19 at 15:56

1 Answers1