How to aggregate variable by time period for time series plot in R using ggplot2

Question

I would like to create a time series plot using ggplot2 in which the variable plotted over time. However, for each time period, I would like to plot the cumulative count for that period. For example:

set.seed(123)
frame <- data.frame(id = sort(rep(c(0:5), 5)),year = rep(c(2000:2005), 5), y = sample(0:1,30, replace = TRUE))
table(frame$year, frame$y)
ggplot(frame, aes(x = year, y = y)) + geom_point(shape = 1) # Not right

I would ultimately like it to generate a plot like this:

count<- table(frame$year, frame$y)[,2]
plot(2000:2005, count, type = "l")

I'm new to ggplot and any pointers would be greatly appreciated. Thanks.

what is your expected output

Bg1850
– Bg1850

2015-11-15 23:02:58 +00:00
Commented Nov 15, 2015 at 23:02 — Bg1850
– Bg1850, Commented Nov 15, 2015 at 23:02

DatamineR · Accepted Answer · 2015-11-15 23:26:01Z

1

Try:

library(ggplot2)
library(dplyr)
frame %>% group_by(year) %>% summarise(sum = sum(y)) %>% 
ggplot(aes(x = year, y = sum)) + geom_line()

answered Nov 15, 2015 at 23:26

DatamineR

9,6803 gold badges28 silver badges50 bronze badges

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

Comments

polka · Accepted Answer · 2015-11-15 23:23:43Z

1

You are essentially missing a single line from your program. You want a dataframe that returns the sum of the y variable for the year.

set.seed(123)
frame <- data.frame(id = sort(rep(c(0:5), 5)),year = rep(c(2000:2005), 5), y = sample(0:1,30, replace = TRUE))
table(frame$year, frame$y)
newFrame <-aggregate(frame$y, list(frame$year),sum)
ggplot(frame, aes(x = newFrame$Group.1, y = newFrame$x)) + geom_point(shape = 1) # Better

answered Nov 15, 2015 at 23:23

polka

1,5493 gold badges27 silver badges40 bronze badges

Collectives™ on Stack Overflow

How to aggregate variable by time period for time series plot in R using ggplot2

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related