{"issue":{"pull_request":{"diff_url":null,"html_url":null,"patch_url":null},"state":"closed","milestone":{"state":"open","open_issues":5,"url":"https://api.github.com/repos/wesm/pandas/milestones/7","due_on":"2011-11-18T08:00:00Z","title":"0.5.1 minor release","description":"","number":7,"creator":{"avatar_url":"https://secure.gravatar.com/avatar/2c08a3eed709a9d1a2654cea45aa466f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"2c08a3eed709a9d1a2654cea45aa466f","url":"https://api.github.com/users/wesm","login":"wesm","id":329591},"closed_issues":60,"created_at":"2011-10-26T01:14:28Z"},"user":{"avatar_url":"https://secure.gravatar.com/avatar/0134e494b0e8a3a4aa4e01be5611ee52?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"0134e494b0e8a3a4aa4e01be5611ee52","url":"https://api.github.com/users/ukch","login":"ukch","id":973865},"updated_at":"2011-11-18T06:08:34Z","labels":[{"name":"Bug","color":"e10c02","url":"https://api.github.com/repos/wesm/pandas/labels/Bug"}],"assignee":null,"closed_at":"2011-11-18T06:08:34Z","comments":2,"url":"https://api.github.com/repos/wesm/pandas/issues/375","body":"Seen on HEAD. This problem is new since 0.5.0.\r\n\r\n    In [3]: data\r\n    Out[3]: \r\n       foo   bar   baz   spam   data\r\n    0  foo1  bar1  baz1  spam2  20  \r\n    1  foo1  bar2  baz1  spam3  30  \r\n    2  foo2  bar2  baz1  spam2  40  \r\n    3  foo1  bar1  baz2  spam1  50  \r\n    4  foo3  bar1  baz2  spam1  60  \r\n\r\n    In [4]: pandas.pivot_table(data, values=\"data\", rows=[\"foo\", \"bar\"], cols=[\"baz\", \"spam\"])\r\n    Out[4]: \r\n      baz      baz1   baz2 \r\n      spam     spam1  spam1\r\n    foo  bar               \r\n    foo1 bar1  20     50   \r\n         bar2  30     NaN  \r\n    foo2 bar2  40     NaN  \r\n    foo3 bar1  NaN    60   \r\n\r\nAs you can see, the `(\"baz1\", \"spam2\")`, `(\"baz2\", \"spam2\")`, `(\"baz1\", \"spam3\")` and `(\"baz2\", \"spam3\")` columns have disappeared and their contents have been aggregated into the remaining two columns.","html_url":"https://github.com/wesm/pandas/issues/375","title":"Pivoting on multiple columns causes data loss","number":375,"id":2268125,"created_at":"2011-11-17T12:21:36Z"},"action":"created","comment":{"user":{"avatar_url":"https://secure.gravatar.com/avatar/2c08a3eed709a9d1a2654cea45aa466f?d=https://a248.e.akamai.net/assets.github.com%2Fimages%2Fgravatars%2Fgravatar-140.png","gravatar_id":"2c08a3eed709a9d1a2654cea45aa466f","url":"https://api.github.com/users/wesm","login":"wesm","id":329591},"updated_at":"2011-11-18T06:08:34Z","url":"https://api.github.com/repos/wesm/pandas/issues/comments/2786153","body":"thanks a lot for catching this. fixed in the above commit. i'm going to overhaul some of the multi-key groupby code for 0.6.0 later this year","id":2786153,"created_at":"2011-11-18T06:08:34Z"}}