Admire Tarisirayi Chirume
2022-Sep-29 15:52 UTC
[R] Covwerting a Date variable from character to Date
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.
Jeff Newmiller
2022-Sep-29 16:10 UTC
[R] Covwerting 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.