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 -- https://mail.python.org/mailman/listinfo/python-list
