How to put back a number-based index

David Shi davidgshi at yahoo.co.uk
Fri May 13 16:00:20 EDT 2016


Dear MIchael,
I am very confused.
Can you send me a link to a working example?
Regards.
David 

    On Friday, 13 May 2016, 20:56, Michael Selik <michael.selik at gmail.com> wrote:
 

 In order to preserve your index after the aggregation, you need to make sure it is considered a data column (via reset_index) and then choose how your aggregation will operate on that column.
On Fri, May 13, 2016 at 3:29 PM David Shi <davidgshi at yahoo.co.uk> wrote:

Hello, Michael,
Why reset_index before grouping?
Regards.
David 

  On Friday, 13 May 2016, 17:57, Michael Selik <michael.selik at gmail.com> wrote:
 

 

On Fri, May 13, 2016 at 12:27 PM David Shi via Python-list <python-list at python.org> wrote:

I lost my indexes after grouping in Pandas.
I managed to rest_index and got back the index column.
But How can I get back a index row?


Was the grouping an aggregation? If so, the original indexes are meaningless. What you could do is reset_index before the grouping and when you aggregate decide how to handle the formerly-known-as-index column (min, max, mean, ?).

 


   


More information about the Python-list mailing list