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.