How to creata a "plot matrix"

Question

Hey dear R community !

I have a dataframe with stock values like this:

                   1          2          3       ...   N
                 EADS      Daimler    BOEING
01.01.2012        5,2        6,7         52
02.01.2012        5,4        6,5         51,8
    .              .          .           .
    .              .          .           .
    .              .          .           .
31.12.2012        7,4        4,8         71

I would like to creata s.th. like a "plot matrix" where in each entry a plot is comparing two lines. Each of this NxN plot has the date on x-axe and the stock value on the y-axe. The idea is to be able to compare each stockvalue with the others one by one. So you can get an idea of the correlation.

I can achieve what I want (more or less) with this command:

# hdMn is a matrix containing the normalized entries of the dataframe

windows(title="Comparison CHART (normalized data)")
par(mfrow=c(dim(hdMn)[2],dim(hd)[2])

for (i in 1:dim(hdMn)[2])
{
for (j in 1:dim(hdMn)[2])
{
    plot(x=1:dim(hdMn)[1],y=hdMn[1:dim(hdMn)[1],i],col="red",main=paste("comparison"
  + , names(historicalData)[i],"and", names(historicalData)[j]),xlab="working 
  + days",ylab="stock value [Euro]",type="l")
    lines(x=1:dim(hdMn)[1],y=hdMn[1:dim(hdMn)[1],j],col=(if(i==j)"red" 
  + else"green"),type="l")
}
}

here you can see the result.

https://docs.google.com/file/d/0B88TpEM5dcSdaTRTVXk4aVdCQmM/edit?usp=sharing

In this result I dont like that every single plot has an own title. This costs much space and isn't really nice. Instead I would like to have it like my hand drawing.

https://docs.google.com/file/d/0B88TpEM5dcSdNGJnaWd4WmlhdGM/edit?usp=sharing

Any ideas ?

score 0 · Accepted Answer · answered May 24 '13 at 10:12

0

Using the package 'ggplot2' with a facet_grid() should be what you are looking for. The ggplot2 facet_grid documentation gives all the details and the [R Cookbook provides some nice] recipes(http://www.cookbook-r.com/Graphs/Facets_%28ggplot2%29/).

To use your dataframe, you'll have to melt it with the 'reshape2' package first.

answered May 24 '13 at 10:12

dlaehnemann

671
5
17

If you provide a [great reproducible R example](http://stackoverflow.com/a/5963610/2352071) with a minimal reusable dataframe, I could also provide you with some sample code. But then I guess you already managed? Ah, and if you like an answer, you can vote it up - if it also really answers your question, you can mark it as a solution. – dlaehnemann Jun 02 '13 at 13:22

How to creata a "plot matrix"

1 Answers1