extracting a subTable
I have a BIG table with data organized by ID, see example on Table#1 bellow. I would like to extract a smaller table with the same number of columns. The rows should include only the last ROW of each ID. Table# 2 is an example extracted form table #1. I tried using the SUBSET function and plan to loop, but I was wondering if someone out there has a more efficient way to accomplish this. You recommendations are highly appreciated.
My recommendation would be not to send R-help questions to R-sig-FINANCE. :) This list derives its value from the high signal to noise ratio it maintains. Please feel free to send all the 'finance' related questions you deem fit, but send the general R questions to the appropriate list(s). Jeff