Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: David Shi <davidgshi@yahoo.co.uk>
Newsgroups: comp.lang.python
Subject: Re: How to put back a number-based index
Date: Fri, 13 May 2016 20:33:54 +0000 (UTC)
Lines: 74
Message-ID: <mailman.648.1463171993.32212.python-list@python.org>
References: <1878444350.3064027.1463156091513.JavaMail.yahoo.ref@mail.yahoo.com> <1878444350.3064027.1463156091513.JavaMail.yahoo@mail.yahoo.com> <1974768074.3081564.1463156374539.JavaMail.yahoo@mail.yahoo.com> <CAGgTfkNC=aCkp+6TY3LxYe-EK5Ug64L-Qua_qVS70qPpfbbtvA@mail.gmail.com> <877815788.3201804.1463167634101.JavaMail.yahoo@mail.yahoo.com> <CAGgTfkPAVVT7bLLmoKe2ZZZeR7g4yQaLNiJ0dOxG4-WzmVHqxw@mail.gmail.com> <CAGgTfkNww+h6uzZ7QuvbohuP_nE1rgC=0TAR=3PGnSpfXJ1qcA@mail.gmail.com> <434110787.3205994.1463170295636.JavaMail.yahoo@mail.yahoo.com> <2098601859.3273341.1463170752937.JavaMail.yahoo@mail.yahoo.com> <1215747866.3212467.1463171634713.JavaMail.yahoo@mail.yahoo.com>
Reply-To: David Shi <davidgshi@yahoo.co.uk>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de fRyi2+QXfESW2VjOlUvHvAAWFB/0YpIBKXRISsCrIeXg==
Return-Path: <davidgshi@yahoo.co.uk>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.000
X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; '16,': 0.03; 'from:addr:yahoo.co.uk': 0.05; '21,': 0.07; 'aggregate': 0.07; 'column': 0.07; 'friday,': 0.07; 'subject:number': 0.07; 'subject:How': 0.09; '22,': 0.09; '34,': 0.09; '40,': 0.09; '[0,': 0.09; 'indexes': 0.09; 'rows': 0.09; 'typed': 0.09; 'email addr:python.org&gt;': 0.10; 'index': 0.13; 'skip:f 30': 0.15; '(via': 0.16; '11.0,': 0.16; '2016': 0.16; '23,': 0.16; '24,': 0.16; '32,': 0.16; '33,': 0.16; '36,': 0.16; '37,': 0.16; '39,': 0.16; '42,': 0.16; '46,': 0.16; '6.0,': 0.16; 'aggregation,': 0.16; 'between.': 0.16; 'break-all;': 0.16; 'break-word;': 0.16; 'from:addr:davidgshi': 0.16; 'from:name:david shi': 0.16; 'mean,': 0.16; 'michael,': 0.16; 'monospace;': 0.16; 'received:io': 0.16; 'received:psf.io': 0.16; 'reply-to:addr:davidgshi': 0.16; 'reply- to:name:david shi': 0.16; 'subject:based': 0.16; 'word-break:': 0.16; 'word-wrap:': 0.16; 'wrote:': 0.16; 'email addr:gmail.com&gt;': 0.18; 'to:name:python-list@python.org': 0.20; 'to:2**1': 0.21; '31,': 0.22; 'decide': 0.23; 'header:In-Reply- To:1': 0.24; 'example': 0.26; 'command': 0.26; 'fri,': 0.27; '14,': 0.27; 'skip:i 40': 0.27; '13,': 0.29; '14px;': 0.29; 'grouping': 0.29; 'preserve': 0.29; 'reset': 0.29; '15,': 0.30; 'operations': 0.31; 'operate': 0.32; 'changed': 0.33; 'michael': 0.33; 'values.': 0.33; 'handle': 0.34; 'skip:d 20': 0.34; 'list': 0.34; 'so,': 0.35; 'header:Received:8': 0.35; 'could': 0.35; 'done': 0.35; 'but': 0.36; 'to:addr:python-list': 0.36; 'subject:: ': 0.37; '12,': 0.37; 'mailing': 0.38; 'why': 0.39; 'data': 0.39; 'sure': 0.39; 'does': 0.39; 'subject:-': 0.39; 'to:addr:python.org': 0.40; 'hello,': 0.40; 'your': 0.60; "you'll": 0.61; 'back': 0.62; 'providing': 0.62; '30,': 0.63; 'information': 0.63; '20,': 0.66; 'margin-top:': 0.66; 'python- list': 0.66; 'received:98.137': 0.67; 'regards.': 0.67; 'header :Reply-To:1': 0.67; 'dear': 0.67; 'choose': 0.68; 'received:98.136': 0.70; '26,': 0.72; 'received:gq1.yahoo.com': 0.72; 'received:mail.gq1.yahoo.com': 0.72; 'interest.': 0.79; '10.0,': 0.84; '4.0,': 0.84; 'column.': 0.84; 'max,': 0.84; 'message-id:@mail.yahoo.com': 0.84; 'pasting': 0.84; 'received:bullet.mail.gq1.yahoo.com': 0.84; 'different.': 0.91
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.uk; s=s2048; t=1463171799; bh=6x8cN30LKFyHfs8pKyBXk3Umt4uof5sb5GZts0AgRw0=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=RTc6BL+d12XnTc4a4rNH/46cpB8pFZegTH+GdJtPegcFDyoeeGqb1NxD5gftPxlpKoOmVazxENcx1pgNVCFQqyT7gP2cCLUUyEgYdNaD/IZA/r2phnwzjF4kMau9rc7SVl8ea8naQTX2HxPCMvy/jKYe/DHJ8GNSFtnu610BwywAzNKVrWd69zbF4J7PYHD7qMHrupduifCl1bix6NzII8grX4tYI1O7XcoqvMlomnmbm3zF283VNB7P40uHGAQFx0yl/UOrzuG3hD5hDq7KcSEaKTiqaI2zM2iYDXP/8t1EmPpuSGs1JPW80KKUp6FSDn2UZ4lWuXicUfLQ/+v+AA==
X-Yahoo-Newman-Property: ymail-4
X-Yahoo-Newman-Id: 472559.54445.bm@omp1004.mail.ir2.yahoo.com
X-YMail-OSG: TCq_bDcVM1kfcnz6ac2vjIjx0w.Z66vInDpkxO69hCq3grEqOoHzcDDRBlGzX0z U8DaOr.B2kFQ75Y18GzyP4N2aXnHh8gS2RqfuvXSWM4cFK5bAch8N1OmAwROJardb9OSTDiVIKAr ZvArY2QQR8NYT5jp59sqsboFbuHMBIltpJVDTcLEuBCJE0peoxaLLx06z_qF45qXUVCzSzYq.Mxx cAtt97.qdg_u.QnOunoouX.esVQWJolZivp9wzt0V272fI8NtWxy4WDPALuNnd2.r3pH4xxEcMAl p0I2oK6Flj4bHruPCX2DRtahaOJoW1ijdx1rPkdwESunypGNjLVrXzReQUp0YLqVk6cU1eOcywGE Jy1rtAC5Gggy6LcoW4gUYDW1sOZW8F2c.6j5fo5ys9bnRb0Bw1n4PGC53Y3S.aCbriWudd9HDFIx xB0OGPqwTz2v9cIrEg0PT02jDgnDgATF5_f.m6C5T7PZZTyXm0LL_cHMs8qzfTzHKAwi8Jt2Rmu0 zU4jsz9w1w_G79CVwNxY-
In-Reply-To: <2098601859.3273341.1463170752937.JavaMail.yahoo@mail.yahoo.com>
X-Content-Filtered-By: Mailman/MimeDel 2.1.22
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.22
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <1215747866.3212467.1463171634713.JavaMail.yahoo@mail.yahoo.com>
X-Mailman-Original-References: <1878444350.3064027.1463156091513.JavaMail.yahoo.ref@mail.yahoo.com> <1878444350.3064027.1463156091513.JavaMail.yahoo@mail.yahoo.com> <1974768074.3081564.1463156374539.JavaMail.yahoo@mail.yahoo.com> <CAGgTfkNC=aCkp+6TY3LxYe-EK5Ug64L-Qua_qVS70qPpfbbtvA@mail.gmail.com> <877815788.3201804.1463167634101.JavaMail.yahoo@mail.yahoo.com> <CAGgTfkPAVVT7bLLmoKe2ZZZeR7g4yQaLNiJ0dOxG4-WzmVHqxw@mail.gmail.com> <CAGgTfkNww+h6uzZ7QuvbohuP_nE1rgC=0TAR=3PGnSpfXJ1qcA@mail.gmail.com> <434110787.3205994.1463170295636.JavaMail.yahoo@mail.yahoo.com> <2098601859.3273341.1463170752937.JavaMail.yahoo@mail.yahoo.com>
Xref: csiph.com comp.lang.python:108620

Hello, Michael,
I changed groupby with one column.
The index is different.
Index([   u'AL',    u'AR',    u'AZ',    u'CA',    u'CO',    u'CT',    u'DC',
          u'DE',    u'FL',    u'GA',    u'IA',    u'ID',    u'IL',    u'IN',
          u'KS',    u'KY',    u'LA',    u'MA',    u'MD',    u'ME',    u'MI',
          u'MN',    u'MO',    u'MS',    u'MT',    u'NC',    u'ND',    u'NE',
          u'NH',    u'NJ',    u'NM',    u'NV',    u'NY',    u'OH',    u'OK',
          u'OR',    u'PA',    u'RI',    u'SC',    u'SD', u'State',    u'TN',
          u'TX',    u'UT',    u'VA',    u'VT',    u'WA',    u'WI',    u'WV',
          u'WY'],
      dtype='object', name=0)
How to use this index?
Regards.
David 

    On Friday, 13 May 2016, 21:19, David Shi <davidgshi@yahoo.co.uk> wrote:
 

 Hello, Michael,
I typed in df.index
I got the followingMultiIndex(levels=[[1.0, 4.0, 5.0, 6.0, 8.0, 9.0, 10.0, 11.0, 12.0, 13.0, 16.0, 17.0, 18.0, 19.0, 20.0, 21.0, 22.0, 23.0, 24.0, 25.0, 26.0, 27.0, 28.0, 29.0, 30.0, 31.0, 32.0, 33.0, 34.0, 35.0, 36.0, 37.0, 38.0, 39.0, 40.0, 41.0, 42.0, 44.0, 45.0, 46.0, 47.0, 48.0, 49.0, 50.0, 51.0, 53.0, 54.0, 55.0, 56.0], [u'AL', u'AR', u'AZ', u'CA', u'CO', u'CT', u'DC', u'DE', u'FL', u'GA', u'IA', u'ID', u'IL', u'IN', u'KS', u'KY', u'LA', u'MA', u'MD', u'ME', u'MI', u'MN', u'MO', u'MS', u'MT', u'NC', u'ND', u'NE', u'NH', u'NJ', u'NM', u'NV', u'NY', u'OH', u'OK', u'OR', u'PA', u'RI', u'SC', u'SD', u'State', u'TN', u'TX', u'UT', u'VA', u'VT', u'WA', u'WI', u'WV', u'WY']],
           labels=[[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48], [0, 2, 1, 3, 4, 5, 7, 6, 8, 9, 11, 12, 13, 10, 14, 15, 16, 19, 18, 17, 20, 21, 23, 22, 24, 27, 31, 28, 29, 30, 32, 25, 26, 33, 34, 35, 36, 37, 38, 39, 41, 42, 43, 45, 44, 46, 48, 47, 49]],
           names=[u'StateFIPS', 0])Regards.
David 

    On Friday, 13 May 2016, 21:11, David Shi <davidgshi@yahoo.co.uk> wrote:
 

 Dear Michael,
I have done a number of operation in between.
Providing that information does not help you
How to reset index after grouping and various operations is of interest.
How to type in a command to find out its current dataframe?
Regards.
David 

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

 Just in case I misunderstood, why don't you make a little example of before and after the grouping? This mailing list does not accept attachments, so you'll have to make do with pasting a few rows of comma-separated or tab-separated values.
On Fri, May 13, 2016 at 3:56 PM Michael Selik <michael.selik@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@yahoo.co.uk> wrote:

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

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

 

On Fri, May 13, 2016 at 12:27 PM David Shi via Python-list <python-list@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, ?).