Hello R experts,
The following problem outstrips my current programming knowledge.
I have a dataframe with two fields that looks like the following:
ID Contract
01 1
01 1
02 2
02 3
02 1
03 2
03 2
03 2
03 1
03 1
03 1
etc...
I would like to end up with a dataframe with one row per ID where the value in the
contract field would be the highest value recorded for a single ID. As you can see
above, the number of IDs varies irregularly. Given the above, the new file would look
like the following:
ID Contract
01 1
02 3
03 2
Thanks in advance for your suggestions.
Gregory L. Blevins The Market Solustions Group, Partner
[[alternative HTML version deleted]]
______________________________________________
[EMAIL PROTECTED] mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
