I am attempting a simple subset but am having a little trouble with simultaneously applying both of my conditions. I am looking to select, for each unique ID, the most recent record where the value column increased. For example, here is a simplified version of my data.
ID| Date | Value
A 1/1/17 100
A 1/2/17 185
A 1/3/17 40
A 1/4/17 100
A 1/5/17 30
B 1/3/17 40
B 1/4/17 30
B 1/5/17 65
B 1/6/17 80
B 1/7/17 0
B 1/8/17 0
While my desired output would be the row where the last increase of Value took place for each ID
ID| Date | Value
A 1/4/17 100
A 1/6/17 80
Does anybody have some insight on how I can achieve my desired output? Thanks.