Plotting average of multiple variables in time-series using ggplot

Question

I have a file which contains time-series data for multiple variables from a to k.

I would like to create a graph that plots the average of the variables a to k over time and above and below that average line adds a smoothed area representing maximum and minimum variation on each day.

So something like confidence intervals but in a smoothed version.

Here's the dataset: https://dl.dropbox.com/u/22681355/co.csv

and here's the code I have so far:

library(ggplot2)
library(reshape2)
meltdf <- melt(df,id="Year")
ggplot(meltdf,aes(x=Year,y=value,colour=variable,group=variable)) + geom_line()

Could you please provide an example of the old dataset?

jackb
– jackb

2014-02-22 09:54:45 +00:00
Commented Feb 22, 2014 at 9:54 — jackb
– jackb, Commented Feb 22, 2014 at 9:54

Roland · Accepted Answer · 2012-11-12 10:35:59Z

11

This depicts bootstrapped 95 % confidence intervals:

ggplot(meltdf,aes(x=Year,y=value,colour=variable,group=variable)) +
  stat_summary(fun.data = "mean_cl_boot", geom = "smooth")

ggplot smoothed bootstrap confidence

This depicts the mean of all values of all variables +-1SD:

ggplot(meltdf,aes(x=Year,y=value)) +
  stat_summary(fun.data ="mean_sdl", mult=1, geom = "smooth")

enter image description here

You might want to calculate the year means before calculating the means and SD over the variables, but I leave that to you.

However, I believe a boostrap confidence interval would be more sensible, since the distribution is clearly not symmetric. It would also be narrower. ;)

And of course you could log-transform your values.

edited Nov 12, 2012 at 10:35

answered Nov 12, 2012 at 10:09

Roland

134k12 gold badges203 silver badges305 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

user1723765 Over a year ago

Roland thanks, maybe I've not been clear, but what I would like to do is plot the average of all these variables and instead of confidence intervals have shaded areas for each day which represents the variation in a to k above and below the average for each day.

Roland Over a year ago

I do not know what you mean by "variation above and below the average".

user1723765 Over a year ago

1. you take the average of a-k and plot that for each day. 2.for each day you will have some of the a-k variables above and below that average. I would like to have a shaded area showing how much variation there is around the mean.

Roland Over a year ago

@user1723765 I added an example of what I think you want.

user1723765 Over a year ago

Yes this is what I would like to have. One extra thing that would be useful is to somehow add different shading in different areas depending on where the majority of values lie. Is that possible to do? thanks for your help

|

Collectives™ on Stack Overflow

Plotting average of multiple variables in time-series using ggplot

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related