[R] converting to time series object : ts - package:stats
Gabor Grothendieck
ggrothendieck at gmail.com
Mon Jun 26 16:01:08 CEST 2006
We don't have data.csv so its still not ***reproducible*** by anyone
else. To be reproducible it means that anyone can copy the code
in your post, paste it into R and get the same answer.
Suggest you post the output of
dput(df)
and then post
dput <- ...the output you got from dput(df)...
Now its reproducible.
On 6/26/06, Sachin J <sachinj.2006 at yahoo.com> wrote:
> Hi Achim,
>
> I did the following:
>
> >df <- read.csv("C:/data.csv", header=TRUE,sep=",",na.strings="NA", dec=",", strip.white=TRUE)
>
> Note: data.csv has 10 (V1...V10) columns.
>
> >df[1]
> V1
> 1 11.08
> 2 7.08
> 3 7.08
> 4 6.08
> 5 6.08
> 6 6.08
> 7 23.08
> 8 32.08
> 9 8.08
> 10 11.08
> 11 6.08
> 12 13.08
> 13 13.83
> 14 16.83
> 15 19.83
> 16 8.83
> 17 20.83
> 18 17.83
> 19 9.83
> 20 20.83
> 21 10.83
> 22 12.83
> 23 15.83
> 24 11.83
>
> >tsdata <- ts((df[1]),frequency = 12, start = c(2005, 1))
>
> The resulting time series is different from the df. I don't know why? I think I am doing something silly.
>
> TIA
>
> Sachin
>
>
> Achim Zeileis <Achim.Zeileis at wu-wien.ac.at> wrote:
> On Mon, 26 Jun 2006, Sachin J wrote:
>
> > Hi,
> >
> > I am trying to convert a dataset (dataframe) into time series object
> > using ts function in stats package. My dataset is as follows:
> >
> > >df
> > [1] 11.08 7.08 7.08 6.08 6.08 6.08 23.08 32.08 8.08 11.08 6.08 13.08 13.83 16.83 19.83 8.83 20.83 17.83
> > [19] 9.83 20.83 10.83 12.83 15.83 11.83
>
> Please provide a reproducible example. You just showed us the print output
> for an object, claiming that it is an object of class "data.frame" which
> is rather unlikely given the print output.
>
> > I converted this into time series object as follows
> >
> > >tsdata <- ts((df),frequency = 12, start = c(1999, 1))
>
> which produces the right result for me if `df' is a vector or a
> data.frame:
>
> df <- c(11.08, 7.08, 7.08, 6.08, 6.08, 6.08, 23.08, 32.08, 8.08, 11.08,
> 6.08, 13.08, 13.83, 16.83, 19.83, 8.83, 20.83, 17.83, 9.83, 20.83,
> 10.83, 12.83, 15.83, 11.83)
> ts(df, frequency = 12, start = c(1999, 1))
> ts(as.data.frame(df), frequency = 12, start = c(1999, 1))
>
> > The resulting time series is as follows:
> >
> > Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
> > 1999 2 15 15 14 14 14 12 13 16 2 14 5
> > 2000 6 8 10 17 11 9 18 11 1 4 7 3
> >
> > I am unable to understand why the values of df and tsdata does not match.
>
> So are we because you didn't really tell us enough about df...
>
> Best,
> Z
>
> > I looked at ts function and I couldn't find any data transformation. Am
> > I missing something here? Any pointers would be of great help.
> >
> > Thanks in advance.
> >
> > Sachin
> >
> >
> > ---------------------------------
> >
> > [[alternative HTML version deleted]]
> >
> > ______________________________________________
> > R-help at stat.math.ethz.ch mailing list
> > https://stat.ethz.ch/mailman/listinfo/r-help
> > PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> >
>
>
> __________________________________________________
>
>
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>
More information about the R-help
mailing list