Difference between revisions of "Iloc"

From wiki
Jump to: navigation, search
(Created page with "Find the latest value per ID for a dataframe like this: {| class="wikitable" style="width:60%" |- !Index !ID !date !value |- |0 |1 |2019-06-14 23:00:03 |7550.00 |- |0 |2 |201...")
 
Line 1: Line 1:
Find the latest value per ID for a dataframe like this:
+
Function for a  [[Pandas#DataFrame]] locating an index(row)
 +
 
 +
;Find the latest value per ID for a dataframe like this
  
 
{| class="wikitable" style="width:60%"
 
{| class="wikitable" style="width:60%"

Revision as of 14:18, 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
0 2 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

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