Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Add ability to maintain order of groupby results when passing multiple functions #610

Closed
wesm opened this issue Jan 11, 2012 · 0 comments
Closed
Assignees
Milestone

Comments

@wesm
Copy link
Member

wesm commented Jan 11, 2012

from @stig

I'd love an option to maintain the column order that I've specified. At the moment I do this:

    print df.groupby('Status')['Duration'].agg({ 'Min': np.min,
                                                 'Max':np.max,
                                                 'Mean': np.mean,
                                                 'Median': np.median,
                                                 'Stddev':np.std,
                                                 })

but the column order come out like this:

         Max    Mean     Median  Min    Stddev
Error    0.141  0.09967  0.093   0.072  0.02796
Success  12.07  5.879    11.05   0.27   5.41

Which is not ideal. I'd love to pass an OrderedDict and have the order be respected.

    d = OrderedDict([('Min', np.min),
                     ('Max', np.max),
                     ('Mean', np.mean),
                     ('Median', np.median),
                     ('Stddev', np.std),
                     ])

... or, the method could just accept a list of tuples and respect that order.

@ghost ghost assigned wesm May 14, 2012
@wesm wesm closed this as completed May 14, 2012
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant