Difference between revisions of "Iloc"

From wiki
Jump to: navigation, search
m
m
 
Line 15: Line 15:
 
|7550.00
 
|7550.00
 
|-
 
|-
|0
+
|1
|2
+
|1
 
|2019-06-15 00:00:03
 
|2019-06-15 00:00:03
 
|7690.00
 
|7690.00

Latest revision as of 14:19, 30 December 2019

Function for a Pandas#DataFrame locating an index(row)

Find the latest value per ID for a dataframe like this
Index ID date value
0 1 2019-06-14 23:00:03 7550.00
1 1 2019-06-15 00:00:03 7690.00
23560 17 2019-12-15 18:10:43 25.50
23561 17 2019-12-16 18:10:45 25.52

df.groupby('ID').apply(lambda d: d.iloc[-1])