Re: [R] converting to time series object : ts - package:stats

From: Sachin J <sachinj.2006_at_yahoo.com>
Date: Tue 27 Jun 2006 - 00:11:47 EST

 

  It seems I have problem in reading the data as dataframe. It is reading it as factors. Here is the df    

  df <- read.csv("C:/Data.csv",header=TRUE,sep=",",na.strings="NA", dec=",", strip.white=TRUE)    

  > dput(df)    

  > df <- structure(list(V1 = structure(c(2, 15, 15, 14, 14, 14, 12, 13,

+ 16, 2, 14, 5, 6, 8, 10, 17, 11, 9, 18, 11, 1, 4, 7, 3), .Label = c("10.83", 
+ "11.08", "11.83", "12.83", "13.08", "13.83", "15.83", "16.83", 
+ "17.83", "19.83", "20.83", "23.08", "32.08", "6.08", "7.08", 
+ "8.08", "8.83", "9.83"), class = "factor"), V2 = structure(c(8, 
+ 15, 2, 10, 9, 18, 1, 4, 10, 2, 8, 6, 17, 5, 16, 13, 5, 14, 3, 
+ 11, 3, 12, 7, 7), .Label = c("10.73", "11.73", "11.75", "12.73", 
+ "15.75", "19.73", "19.75", "21.73", "25.73", "26.73", "26.75", 
+ "27.75", "32.75", "33.75", "37.73", "42.75", "61.75", "9.73"), class = "factor"), 
+     V3 = structure(c(3, 8, 7, 9, 11, 9, 3, 8, 10, 9, 11, 10, 
+     2, 1, 12, 12, 6, 5, 4, 6, 2, 5, 5, 1), .Label = c("10.33", 
+     "12.33", "13.08", "13.33", "14.33", "15.33", "21.08", "6.08", 
+     "7.08", "8.08", "9.08", "9.33"), class = "factor")), .Names = c("V1", 
+ "V2", "V3"), class = "data.frame", row.names = c("1", "2", "3", 
+ "4", "5", "6", "7", "8", "9", "10", "11", "12", "13", "14", "15", 
+ "16", "17", "18", "19", "20", "21", "22", "23", "24"))
   

  TIA       Sachin

Gabor Grothendieck <ggrothendieck@gmail.com> wrote:   Sorry I meant issue dput(df) and
post

df <- ...the output your got from dput(df)... ...rest of your code...

Now its reproducible.

On 6/26/06, Gabor Grothendieck wrote:
> 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 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 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@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@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@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 Received on Tue Jun 27 00:23:30 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 27 Jun 2006 - 02:12:46 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.