Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
DataFrame .xlsx max()
#1
Friends!
I have a data frame from .xslx that return 4 columns, order id, order date, order requester, order urgency,
I want to return the max() order date by order id, BUT to retrieve back the entire columns in it also e.g.:
order id | max(order date) | order requester | order urgency
tried this but I retrieve only 2 columns :

df = df.groupby(['order id'],as_index=False)[['order date']].max()

appreciate your support :-)
Reply


Messages In This Thread
DataFrame .xlsx max() - by bnadir55 - Jan-22-2022, 10:55 AM
RE: DataFrame .xlsx max() - by snippsat - Jan-22-2022, 11:47 AM
RE: DataFrame .xlsx max() - by bnadir55 - Jan-22-2022, 11:53 AM
RE: DataFrame .xlsx max() - by snippsat - Jan-22-2022, 05:46 PM
RE: DataFrame .xlsx max() - by bnadir55 - Jan-22-2022, 06:28 PM
RE: DataFrame .xlsx max() - by snippsat - Jan-22-2022, 10:52 PM
RE: DataFrame .xlsx max() - by bnadir55 - Jan-23-2022, 10:05 AM

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020