Hi,

I have data frame like this:

Product     Price    Year_Month  PE
A                 100        201012         -2
A                 98           201101        -3
A                 97           201102        -2.5
B                 110         201101        -1
B                 100         201102        -2
B                  90          201103        -4


How can I achieve the following result using R:
Product     Price    Year_Month  PE
A                 97           201102        -2.5
B                  90          201103        -4

in other words, list the all products' information of the latest month?

Thanks for your help.

Kind regards,
Lingyi




 		 	   		  
	[[alternative HTML version deleted]]

