Kindly request assistance to *convert a Date variable from a character to
be recognized as a date*.
NB: kindly take note that the data is in a csv file called *inflation*. I
have included part of the file content herewith with the header for
assistance.
My data looks like this:
*Period CPI*
2022m1 4994
2022m2 5336
2022m3 5671
2022m4 6532
2022m5 7973
2022m6 10365
2022m7 12673
2022m8 14356
2022m9 14708
I used the following command lines.
class(inflation.2$cpi)
inflation.2$cpi <- as.numeric(as.character(inflation.2$cpi))
*format(as.Date(inflation.2$period), "%Y-%m")*
Having run the command lines above, the variable *period* in the attached
CSV file remains being read as a character variable. Kindly assist.
Thank you.
Alternative email: addtar...@icloud.com/tchir...@rbz.co.zw
Skype: admirechirume
Call: +263773369884
whatsapp: +818099861504
On Thu, Sep 29, 2022 at 6:10 PM Jeff Newmiller <jdnew...@dcn.davis.ca.us>
wrote:
> Your attachment was stripped by the mailing list. The criteria for allowed
> attachments are a bit tricky to translate into actions to apply to your
> email software, so usually including part of your file in the body of the
> email is the most successful approach for communicating your problem. Be
> sure to use a text editor or the
>
> readLines("filename.csv") |> head() |> dput()
>
> functions in R to extract lines of your file for inclusion in the email.
>
> On September 29, 2022 8:52:30 AM PDT, Admire Tarisirayi Chirume <
> atchir...@gmail.com> wrote:
> >I kindly request for assistance to convert a Date variable from a
> character
> >to be recognised as a date. I used the following command lines.
> >
> >inflation<-read.csv("Inflation_forecasts_1.csv")
> >attach(inflation)
> >inflation[,1:2 ] #subsetting the dataframe
> >#Renaming variables
> >inflation<- rename(inflation.df,
> > cpi = CPI,
> > year=period)
> >
> >#subsetting data April 2020 to current
> >inflation.2<-data.frame(inflation[-c(1:135),])
> >class(inflation.2$cpi)
> >inflation.2$cpi <- as.numeric(as.character(inflation.2$cpi))
> >* format(as.Date(inflation.2$period), "%Y-%m")*
> >
> >Having ran the command lines above, the variable period in the attached
> csv
> >file remains being read as a character variable. Kindly assist.
> >
> >Thank you.
> >______________________________________________
> >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.
>
> --
> Sent from my phone. Please excuse my brevity.
>
[[alternative HTML version deleted]]
______________________________________________
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.
