V1 V2 V3
1 a w 200
2 a w 100
3 b w 500
4 b w 200
5 b z 300
6 b z 400
x$rank <- ave(x$V3, x$V1, x$V2, FUN=rank)
x
V1 V2 V3 rank
1 a w 200 2
2 a w 100 1
3 b w 500 2
4 b w 200 1
5 b z 300 1
6 b z 400 2
On Fri, Sep 26, 2008 at 4:54 PM, Matthew Pettis
<matthew.pettis at gmail.com> wrote:
Hi,
I'd like to rank obs in a data frame as subset by 2 or more columns...
The example input would look like the following:
====+====+====+====+
x y v
-- -- --
a w 200
a w 100
b w 500
b w 200
b z 300
b z 400
====+====+====+====+
And the data frame I want to create is below:
====+====+====+====+
x y v rank
-- -- -- ----
a w 200 1
a w 100 2
b w 500 1
b w 200 2
b z 300 2
b z 400 1
====+====+====+====+
Can someone help me with this?
Thanks,
Matt
--
It is from the wellspring of our despair and the places that we are
broken that we come to repair the world.
-- Murray Waas