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@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.


______________________________________________
R-help@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.

Reply via email to