[R] indexing via a character matrix?
Roger Levy
rlevy at inf.ed.ac.uk
Mon Feb 13 23:51:26 CET 2006
Prof Brian Ripley wrote:
> On Mon, 13 Feb 2006, Roger Levy wrote:
>
>> Hi,
>>
>> Is it possible to index via a character matrix? For example, I would
>> like to do the following:
>>
>> cont.table <- table(df1$A,df1$B) # df1 a data frame with factors A and B
>> cont.table[cbind(df2$A,df2$B)] # df2 a smaller data frame with some
>> # pairings of values for A and B
>>
>> but the second step does not work -- I guess that matrices to be used
>> for indexing this way must be numeric. Is there a way to index multiple
>
> Numeric or logical.
>
>> character tuples out of a contingency table without resorting to writing
>> loops?
>
> What are you trying to do here? One possibility is that you meant
>
> comt.table[df2$A, df2$B]
>
> and another is
>
> ind1 <- match(df2$A, df1$A)
> ind2 <- match(df2$B, df1$B)
> cont.table[cbind(ind1, ind2)]
>
> and I am not certain which.
>
Hmm, I think neither one is what I wanted. After thinking more about
it, I think what I would need is
ind1 <- match(df2$A,levels(df1$A))
ind2 <- match(df2$B,levels(df2$B))
cont.table[cbind(ind1,ind2)]
Does this make sense? Is there a more natural way to express this?
Many thanks,
Roger
More information about the R-help
mailing list