Pivot table of Pandas

[Sayth Renshaw]

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