Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #107833 > unrolled thread

Pivot table of Pandas

Started byDavid Shi <davidgshi@yahoo.co.uk>
First post2016-04-28 23:38 +0000
Last post2016-04-28 18:59 -0700
Articles 2 — 2 participants

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.


Contents

  Pivot table of Pandas David Shi <davidgshi@yahoo.co.uk> - 2016-04-28 23:38 +0000
    Re: Pivot table of Pandas Sayth Renshaw <flebber.crue@gmail.com> - 2016-04-28 18:59 -0700

#107833 — Pivot table of Pandas

FromDavid Shi <davidgshi@yahoo.co.uk>
Date2016-04-28 23:38 +0000
SubjectPivot table of Pandas
Message-ID<mailman.215.1461887070.32212.python-list@python.org>



 Hello, Matt,
Please see the web link.Pandas Pivot Table Explained

|   |
|   |   |   |   |   |
| Pandas Pivot Table ExplainedExplanation of pandas pivot_table function. |
|  |
| View on pbpython.com | Preview by Yahoo |
|  |
|   |


Debra and Fred have their own groups.
How to split the pivot table into separate tables?
What types of objects are these pivot tables?
How to access the "manager" column?
the pivot table is interesting to users, but it is very different from databases which we normally know.
Looking forward to hearing from you.
Regards.
David

  

[toc] | [next] | [standalone]


#107838

FromSayth Renshaw <flebber.crue@gmail.com>
Date2016-04-28 18:59 -0700
Message-ID<fe866679-52fc-4c5a-a810-b79b43e1ad59@googlegroups.com>
In reply to#107833
On Friday, 29 April 2016 09:56:13 UTC+10, David Shi  wrote:
> Hello, Matt,
> Please see the web link.Pandas Pivot Table Explained
> 
> |   |
> |   |   |   |   |   |
> | Pandas Pivot Table ExplainedExplanation of pandas pivot_table function. |
> |  |
> | View on pbpython.com | Preview by Yahoo |
> |  |
> |   |
> 
> 
> Debra and Fred have their own groups.
> How to split the pivot table into separate tables?
> What types of objects are these pivot tables?
> How to access the "manager" column?
> the pivot table is interesting to users, but it is very different from databases which we normally know.
> Looking forward to hearing from you.
> Regards.
> David

Unsure of your exact requirements but this doc on reshaping seems to cover the requirements posted. You would not get 2 tables that would be counter-intuitive to a pivottable.

You would just define a group in rows and the columns as the data or vice versa.

So 
Debra             data of some sort
  team_member1     44
  team_member2     56
Fred
  team_memeber1    62
  team_memeber2    33

http://pandas.pydata.org/pandas-docs/stable/reshaping.html

Sayth

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.python


csiph-web