group by pandas dataframe and select latest in each group

by

You can also use tail with groupby to get the last n values of the group:

df.sort_values('date').groupby('id').tail(1)

    id  product date
2   220 6647    2014-10-16
8   901 4555    2014-11-01
5   826 3380    2015-05-19

More Related Contents:

  1. How can I pivot a dataframe?
  2. Get statistics for each group (such as count, mean, etc) using pandas GroupBy?
  3. How do I create a new column from the output of pandas groupby().sum()?
  4. GroupBy pandas DataFrame and select most common value
  5. Pandas GroupBy.apply method duplicates first group
  6. pandas GroupBy columns with NaN (missing) values
  7. Count unique values per groups with Pandas [duplicate]
  8. How to access pandas groupby dataframe by key
  9. Pandas GroupBy and select rows with the minimum value in a specific column
  10. why does pandas rolling use single dimension ndarray
  11. Group dataframe and get sum AND count?
  12. Sample each group after pandas groupby
  13. Pandas groupby with categories with redundant nan
  14. Is there an “ungroup by” operation opposite to .groupby in pandas?
  15. get first and last values in a groupby
  16. Pandas groupby and aggregation output should include all the original columns (including the ones not aggregated on)
  17. Get the row corresponding to the max in pandas GroupBy [duplicate]
  18. How to get number of groups in a groupby object in pandas?
  19. Apply multiple functions to multiple groupby columns
  20. Python Pandas : group by in group by and average?
  21. Pandas dataframe get first row of each group
  22. How to use groupby to concatenate strings in python pandas?
  23. Naming returned columns in Pandas aggregate function? [duplicate]
  24. Python Pandas Conditional Sum with Groupby
  25. How can I use cumsum within a group in Pandas?
  26. Identifying statistical outliers with pandas: groupby and reduce rows into different dataframe
  27. pandas group by and find first non null value for all columns
  28. Split pandas dataframe based on values in a column using groupby
  29. pandas divide row value by aggregated sum with a condition set by other cell
  30. Get frequency of item occurrences in a column as percentage [duplicate]

Leave a Comment