get max index in a agg function and select value of another column

PHOTO

Wed Feb 09 2022 01:16:05 GMT+0000 (Coordinated Universal Time)

Saved by @Milados

df.groupby(['User', 'year', 'week']).apply(lambda x: x.loc[x['P/L'].idxmax(), 'symbol'])

http://localhost:8888/notebooks/Untitled.ipynb

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

Pandas

@Milados

Size of pandas columns Replace a string in a list with one string Pandas percentage of total with groupby suppress scientific notation in Pandas get max index in a agg function and select value of another column put values of a agg function in list Save df to parquet Write df in excel file append df in a new sheet in excel file drop first level of a multindex column df python - How to iterate over rows in a DataFrame in Pandas - Stack Overflow Sample with equal number of samples pandas

Browse more snippets >>