R help - Oct 2009 - Plot overview xy plots from data frame?

Hi,

I've got a data frame (556 rows and 36 columns) from which I need to create
several xy plots and print to pdf, in order to detect outliers and trends in the
data. 16 of the columns contains numerical values, and I would like to create
graphs for all combinations. It can be done manually, but creating 256 plots by
hand takes time... I guess I have to iterate through the data frame, but I'm
not used to do that with R. Below I've written my thoughts, trying to
combine my knowledge in Java and R, just to give you the idea:

pdf("FieldTrial0809Overview.pdf")

int colWidth = fieldTrial[0].length;


for(i=0, i<colWidth, i++)
{
    for(j=0, j<colWidth, j++)
    {
        String colI=get.fieldTrial$i;
        String colJ=get.fieldTrial$j;

        plot(fieldTrial$i~fieldTrial$j, main=colI + " vs " + colJ,
xlab=colI, ylab=colJ)
    }
}

dev.off()

Anyone who know how to solve this?
Do I have to copy the 16 numerical columns to a new dataset, because they are
not grouped and there are 20 additional non-numerical columns in the data frame.
By the way, can the iterations be made using R, or do you have to combine with
for instance Perl?

All the best,

Joel
 		 	   		  
_________________________________________________________________
Hitta hetaste singlarna på MSN Dejting!
http://dejting.se.msn.com/channel/index.aspx?trackingid=1002952
	[[alternative HTML version deleted]]

On 10/15/2009 07:40 AM, Joel F?rstenberg-H?gg wrote:
> Hi,
>
> I've got a data frame (556 rows and 36 columns) from which I need to
create several xy plots and print to pdf, in order to detect outliers and trends
in the data. 16 of the columns contains numerical values, and I would like to
create graphs for all combinations. It can be done manually, but creating 256
plots by hand takes time... I guess I have to iterate through the data frame,
but I'm not used to do that with R. Below I've written my thoughts,
trying to combine my knowledge in Java and R, just to give you the idea:
>
> pdf("FieldTrial0809Overview.pdf")
>
> int colWidth = fieldTrial[0].length;
>
>
> for(i=0, i<colWidth, i++)
> {
>      for(j=0, j<colWidth, j++)
>      {
>          String colI=get.fieldTrial$i;
>          String colJ=get.fieldTrial$j;
>
>          plot(fieldTrial$i~fieldTrial$j, main=colI + " vs " +
colJ, xlab=colI, ylab=colJ)
>      }
> }
>
> dev.off()
>
> Anyone who know how to solve this?
> Do I have to copy the 16 numerical columns to a new dataset, because they
are not grouped and there are 20 additional non-numerical columns in the data
frame.
> By the way, can the iterations be made using R, or do you have to combine
with for instance Perl?
>
>    
Hi Joel,
If by "all combinations" you mean all pairwise combinations, then if 
your numeric columns are numbers 5 to 20, you could do this:

allpairs<-combn(5:20,2)
for(i in 1:dim(allpairs)[2]) {
  pdf(
   paste("FieldTrial0809Overview",
   allpairs[1,i],allpairs[2,i],sep="_"))
  plot(fieldTrial[,allpairs[1,i]],fieldTrial[,allpairs[2,i]],...)
  dev.off()
}

Jim