[R] aggregation question

Jim Lemon jim at bitwrit.com.au
Fri Jul 8 09:20:28 CEST 2011


Dr Eberhard Lisse <el at lisse.na> wrote:
 > Hi,
 >
 > I am reading payment data like so
 >
 > 2010-01-01,100.00
 > 2010-01-04,100.00
 > ...
 > 2011-01-01,200.00
 > 2011-01-07,100.00
 >
 > and plot it aggregated per month like so
 >
 > library(zoo)
 > df <- read.csv("daily.csv", colClasses=c(d="Date",s="numeric"))
 > z <- zoo(df$s, df$d)
 > z.mo <- aggregate(z, as.yearmon, sum)
 > barplot(z.mo, col="darkblue")
 >
 > How do I get the monthly aggregated payments in different colors
 > next to each other (ie for each year in a different color with the x
 > axis showing the months)?

Hi Dr Eberhard Lisse,
You might also be interested in barp:

paybymonth<-matrix(sample(100:200,120,TRUE),nrow=10)
rownames(paybymonth)<-2000:2009
colnames(paybymonth<-month.abb
library(plotrix)
barp(paybymonth,names.arg=colnames(paybymonth),col=rainbow(10),
  ylim=c(0,250),main="Payments by month from 2000-2009")
par(xpd=TRUE)
legend(13,180,2000:2009,fill=rainbow(10))
par(xpd=FALSE)

Jim



More information about the R-help mailing list