R help - Sep 2022 - Converting a Date variable from character to Date

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 <atchirume at
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 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.
-- 
Sent from my phone. Please excuse my brevity.

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: addtarris at icloud.com/TChirume at rbz.co.zw
Skype: admirechirume
Call: +263773369884
whatsapp: +818099861504


On Thu, Sep 29, 2022 at 6:10 PM Jeff Newmiller <jdnewmil at
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 <
> atchirume at 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 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.
>
> --
> Sent from my phone. Please excuse my brevity.
>
	[[alternative HTML version deleted]]