Try this by add a "day" to the date field
library(tidyverse)
library(lubridate)
input <- "*Period CPI*
2022m1 4994
2022m2 5336
2022m3 5671
2022m4 6532
2022m5 7973
2022m6 10365
2022m7 12673
2022m8 14356
2022m9 14708"
m_data <- read.delim(text = input, sep = "")
# convert the date by adding a "day" before the conversion
m_data$date <- ymd(paste0(m_data$X.Period, '-1'))
m_data
## X.Period CPI. date
## 1 2022m1 4994 2022-01-01
## 2 2022m2 5336 2022-02-01
## 3 2022m3 5671 2022-03-01
## 4 2022m4 6532 2022-04-01
## 5 2022m5 7973 2022-05-01
## 6 2022m6 10365 2022-06-01
## 7 2022m7 12673 2022-07-01
## 8 2022m8 14356 2022-08-01
## 9 2022m9 14708 2022-09-01
Thanks
Jim Holtman
*Data Munger Guru*
*What is the problem that you are trying to solve?Tell me what you want to
do, not how you want to do it.*
On Thu, Sep 29, 2022 at 9:36 AM Admire Tarisirayi Chirume <
atchir...@gmail.com> wrote:
> 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.
>
[[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.
