Iloc

From wiki

Revision as of 16:14, 30 December 2019 by Hdridder (talk | contribs) (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...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

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])

Retrieved from "https://wiki.antiperfect.org/index.php?title=Iloc&oldid=687"