Thank you for the code. It helped. I greatly appreciate. Alternative email: addtar...@icloud.com/tchir...@rbz.co.zw Skype: admirechirume Call: +263773369884 whatsapp: +818099861504
On Thu, Sep 29, 2022 at 7:20 PM jim holtman <jholt...@gmail.com> wrote: > 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.