pandas2 icon indicating copy to clipboard operation
pandas2 copied to clipboard

Alternate groupby API that is more functionally consistent with databases or systems like dplyr

Open wesm opened this issue 8 years ago • 2 comments

pandas's row indexes introduces a level of semantic incompatibility with other systems that occasionally causes problems for users who are using both pandas and some other system.

Functionally, this mainly means returning the group keys as data columns rather than row index. In the case of .apply, it may make sense to discard the group keys altogether.

We may also discuss a means to make specifying more complex aggregations easier in a separate issue

wesm avatar Sep 07 '16 15:09 wesm

related to this, we might make groupby().filter() a lazy method with returned a filtered groupby (rather than an imemdiate evaluation)

jreback avatar Sep 15 '16 21:09 jreback

definitely, re: #7

wesm avatar Sep 16 '16 02:09 wesm