Reshaping time series data from wide to tall format (for plotting) [duplicate]

by

you can also use melt() from the ‘reshape’ library (I think it’s easier to use than reshape() itself) – that’ll save you the extra step of having to add the time column back in…

> library(reshape)
> m <- melt(dat,id="t",variable_name="symbol")
> names(m) <- sub("value","price",names(m))
> head(m)
           t symbol       price
1 2009-01-01      X -1.14945096
2 2009-01-02      X -0.07619870
3 2009-01-03      X  0.01547395
4 2009-01-04      X -0.31493143
5 2009-01-05      X  1.26985167
6 2009-01-06      X  1.31492397
> class(m$t)
[1] "Date"
> library(lattice)                                                              
> xyplot( price ~ t | symbol, data=m ,type ="l", layout = c(1,3) )

For this particular task, however, I would consider using the ‘zoo’ library, which would not require you to reshape the data frame:

> library(zoo)                                                                  
> zobj <- zoo(dat[,-1],dat[,1])                                                 
> plot(zobj,col=rainbow(ncol(zobj)))

R developers/contributors (Gabor and Hadley in this case) have blessed us with many great choices. (and can’t forget Deepayan for the lattice package)

More Related Contents:

  1. Conversion of a data into time series object
  2. Plotting two variables as lines using ggplot2 on the same graph
  3. Insert rows for missing dates/times
  4. Basic lag in R vector/dataframe
  5. How to get a vertical geom_vline to an x-axis of class date?
  6. How to convert dataframe into time series?
  7. How to parse milliseconds?
  8. R tick data : merging date and time into a single object
  9. Converting a data frame to xts
  10. Forecasting time series data
  11. How to make gradient color filled timeseries plot in R
  12. Transforming a time-series into a data frame and back
  13. Return data subset time frames within another timeframes?
  14. Analyzing Daily/Weekly data using ts in R
  15. Creating regular 15-minute time-series from irregular time-series
  16. Multiple time series in one plot
  17. Subset xts object by time of day
  18. Filling missing dates in a grouped time series – a tidyverse-way?
  19. starting a daily time series in R
  20. Fill NA in a time series only to a limited number
  21. rolling joins data.table in R
  22. Replace -inf, NaN and NA values with zero in a dataset in R
  23. R: merge two irregular time series
  24. Create sequential counter that restarts on a condition within panel data groups [duplicate]
  25. Time series plot gets offset by 2 hours if scale_x_datetime is used
  26. R: convert date from character to datetime [duplicate]
  27. simple examples of filter function, recursive option specifically
  28. Calculate monthly average of ts object
  29. optimized rolling functions on irregular time series with time-based window
  30. Using geom_rect for time series shading in R

Leave a Comment