Re: [R] Creating dataframe of all possible variable combinations

2010-03-25 Thread Erik Iverson 

Hello,

Hosack, Michael wrote:

Hello,

I need to create a dataframe containing all possible combinations of
three variables: SITE (101,102,103,104), WDAY (MON,TUE,WED,THR,FRI),
and TOD (MORN, AFTN). There should be a total of 40 unique
combinations in my dataframe. I used expand.grid() successfully(?) to
create my dataframe, but then when I went to order it by SITE, the
resultant dataframe only contained four rows, one for each site.
There must be something about this function that I don't understand.
Any advice would be appreciated.


I don't know what you see, since you don't provide reproducible code.  I 
cannot reproduce what you saw.


tmp <- expand.grid(site = c(101,102,103,104),
   wday = c("MON","TUE","WED","THR","FRI"),
   tod  = c ("MORN", "AFTN"))

tmp[order(tmp$site),]

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Creating dataframe of all possible variable combinations

2010-03-25 Thread Stephan Kolassa 

Hi Mike,

the following works for me:

SITE <- ordered(c(101,102,103,104))
WDAY <- 
ordered(c("MON","TUE","WED","THR","FRI"),levels=c("MON","TUE","WED","THR","FRI"))

TOD <- ordered(c("MORN","AFTN"),levels=c("MORN","AFTN"))

foo <- expand.grid(SITE=SITE,WDAY=WDAY,TOD=TOD)
foo[order(foo$SITE),]

If this doesn't solve your problem, perhaps you could give us a minimal 
code snippet that demonstrates what exactly you are doing without 
getting what you are looking for?


Bye,
Stephan


Hosack, Michael schrieb:

Hello,

I need to create a dataframe containing all possible combinations of
three variables: SITE (101,102,103,104), WDAY (MON,TUE,WED,THR,FRI),
and TOD (MORN, AFTN). There should be a total of 40 unique
combinations in my dataframe. I used expand.grid() successfully(?) to
create my dataframe, but then when I went to order it by SITE, the
resultant dataframe only contained four rows, one for each site.
There must be something about this function that I don't understand.
Any advice would be appreciated.

Thank you,

Mike

__ R-help@r-project.org
mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do
read the posting guide http://www.R-project.org/posting-guide.html 
and provide commented, minimal, self-contained, reproducible code.




__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Creating dataframe of all possible variable combinations

2010-03-25 Thread Rolf Turner 

On 26/03/2010, at 9:22 AM, Hosack, Michael wrote:

> Hello,
> 
> I need to create a dataframe containing all possible combinations of 
> three variables: SITE (101,102,103,104), WDAY (MON,TUE,WED,THR,FRI),
> and TOD (MORN, AFTN). There should be a total of 40 unique combinations
> in my dataframe. I used expand.grid() successfully(?) to create my 
> dataframe, but then when I went to order it by SITE, the resultant 
> dataframe only contained four rows, one for each site. There must 
> be something about this function that I don't understand. Any advice
> would be appreciated.

Works for me. I used:

xxx <- expand.grid(SITE=SITE,WDAY=WDAY,TOD=TOD)
yyy <- xxx[order(xxx$SITE),]

I expect you used:

yyy <- xxx[order(SITE),]

In the foregoing, SITE is the length-4 vector in your global environment, not
the length-40 column of xxx.  So ``naturally'' you get a result with 4 rows.

cheers,

Rolf Turner

##
Attention:\ This e-mail message is privileged and confid...{{dropped:9}}

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Re: [R] Creating dataframe of all possible variable combinations

2010-03-25 Thread Jorge Ivan Velez 
Hi Mike,

Try this:

SITE <- c(101,102,103,104)
WDAY <- c('MON','TUE','WED','THR','FRI')
TOD <- c('MORN', 'AFTN')
out <- expand.grid(SITE, WDAY, TOD)
out

HTH,
Jorge


On Thu, Mar 25, 2010 at 4:21 PM, Hosack, Michael <> wrote:

> Hello,
>
> I need to create a dataframe containing all possible combinations of three
> variables: SITE (101,102,103,104), WDAY (MON,TUE,WED,THR,FRI), and TOD
> (MORN, AFTN). There should be a total of 40 unique combinations in my
> dataframe. I used expand.grid() successfully(?) to create my dataframe, but
> then when I went to order it by SITE, the resultant dataframe only contained
> four rows, one for each site. There must be something about this function
> that I don't understand. Any advice would be appreciated.
>
> Thank you,
>
> Mike
>
> __
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>

[[alternative HTML version deleted]]

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] Creating dataframe of all possible variable combinations

2010-03-25 Thread Hosack, Michael 
Hello,

I need to create a dataframe containing all possible combinations of 
three variables: SITE (101,102,103,104), WDAY (MON,TUE,WED,THR,FRI),
and TOD (MORN, AFTN). There should be a total of 40 unique combinations
in my dataframe. I used expand.grid() successfully(?) to create my 
dataframe, but then when I went to order it by SITE, the resultant 
dataframe only contained four rows, one for each site. There must 
be something about this function that I don't understand. Any advice
would be appreciated. 

Thank you,

Mike

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

[R] Creating dataframe of all possible variable combinations

2010-03-25 Thread Hosack, Michael 
Hello,

I need to create a dataframe containing all possible combinations of three 
variables: SITE (101,102,103,104), WDAY (MON,TUE,WED,THR,FRI), and TOD (MORN, 
AFTN). There should be a total of 40 unique combinations in my dataframe. I 
used expand.grid() successfully(?) to create my dataframe, but then when I went 
to order it by SITE, the resultant dataframe only contained four rows, one for 
each site. There must be something about this function that I don't understand. 
Any advice would be appreciated. 

Thank you,

Mike

__
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.