Python Pandas: Is Order Preserved When Using groupby() and agg()?

by

See this enhancement issue

The short answer is yes, the groupby will preserve the orderings as passed in. You can prove this by using your example like this:

In [20]: df.sort_index(ascending=False).groupby('A').agg([np.mean, lambda x: x.iloc[1] ])
Out[20]: 
           B             C         
        mean <lambda> mean <lambda>
A                                  
group1  11.0       10  101      100
group2  17.5       10  175      100
group3  11.0       10  101      100

This is NOT true for resample however as it requires a monotonic index (it WILL work with a non-monotonic index, but will sort it first).

Their is a sort= flag to groupby, but this relates to the sorting of the groups themselves and not the observations within a group.

FYI: df.groupby('A').nth(1) is a safe way to get the 2nd value of a group (as your method above will fail if a group has < 2 elements)

More Related Contents:

  1. How do I Pandas group-by to get sum?
  2. How to group dataframe rows into list in pandas groupby
  3. Keep other columns when doing groupby
  4. Multiple aggregations of the same column using pandas GroupBy.agg()
  5. Pandas sum by groupby, but exclude certain columns
  6. Rename result columns from Pandas aggregation (“FutureWarning: using a dict with renaming is deprecated”)
  7. Pass percentiles to pandas agg function
  8. Pandas: using groupby to get mean for each data category
  9. Pandas aggregate count distinct
  10. Difference between map, applymap and apply methods in Pandas
  11. Python Pandas : group by in group by and average?
  12. Python pandas insert list into a cell
  13. Stacked Bar Chart with Centered Labels
  14. How to replace text in a string column of a Pandas dataframe?
  15. Pandas dataframe get first row of each group
  16. pandas .at versus .loc
  17. What does the term “broadcasting” mean in Pandas documentation?
  18. Add column to dataframe with constant value
  19. Pandas: compare list objects in Series
  20. Python / Pandas – GUI for viewing a DataFrame or Matrix [closed]
  21. Filter string data based on its string length
  22. Converting pandas column of comma-separated strings into dummy variables
  23. Creating an empty Pandas DataFrame, and then filling it
  24. Matplotlib showing x-tick labels overlapping
  25. Check if rows in one dataframe exist in another dataframe
  26. How indexing works in Pandas?
  27. Pandas custom function to find whether it is the 1st, 2nd etc Monday, Tuesday, etc – all suggestions welcome
  28. How to use str.contains() with multiple expressions in pandas dataframes
  29. Pandas: Knowing when an operation affects the original dataframe
  30. Pandas Secondary Axis

Leave a Comment