Iloc: Difference between revisions

Revision as of 14:18, 30 December 2019

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

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

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

Revision as of 14:18, 30 December 2019 view source Hdridder (talk \| contribs) Bureaucrats, Administrators 1,716 edits No edit summary ← Older edit		Revision as of 14:18, 30 December 2019 view source Hdridder (talk \| contribs) Bureaucrats, Administrators 1,716 edits mNo edit summary Newer edit →
Line 32:		Line 32:
	\|}		\|}

	<code>~~df2~~.groupby('ID').apply(lambda d: d.iloc[-1])</code>		<code>df.groupby('ID').apply(lambda d: d.iloc[-1])</code>