Message-ID: <604ef448-2755-595a-8b1d-437aade904a6@sapo.pt>
Date: 2021-03-24T19:21:44Z
From: Rui Barradas
Subject: Converting POSIXct format date to Character format
In-Reply-To: <1902293860.753927.1616613067660@mail2.virginmedia.com>
Hello,
R is case sensitive, the column name is YEAR_END_Date, neither of
Year_END_Date
YEAR_END_DATE
matches that name. Try
select(PLC, format(YEAR_END_Date,format = "%B %d, %Y"), EPS)
Hope this helps,
Rui Barradas
?s 19:11 de 24/03/21, e-mail ma015k3113 via R-help escreveu:
> I have a data frame "PLC" which has two variables Year_END_Date EPS
>
> YEAR_END_Date EPS
> 2010-09-10 .10
> 2009-08-10 .20
>
> When I tried to convert Year_END_Date to character format using
>
> select(PLC, format(Year_END_Date,format = "%B %d, %Y"), EPS) I get an error
>
> Error: Can't subset columns that don't exist.
> x Column `Year_END_Date` doesn't exist.
>
> I tried using
>
> PLC_1 <- select(PLC, as.character(YEAR_END_DATE), EPS)
>
> I get the following error
>
> Error: Can't subset columns that don't exist.
> x Columns `2010-09-30`, `2009-09-30`, `2008-09-30`, `2007-09-30`, `2006-09-30`, etc. don't exist.
> Run `rlang::last_error()` to see where the error occurred.
>
> Can anyone please guide me what is happening and how can I resolve it?
>
> ______________________________________________
> R-help at r-project.org mailing list -- To UNSUBSCRIBE and more, see
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>