stackoverflow.ipynb

{
 "worksheets": [
  {
   "cells": [
    {
     "metadata": {},
     "cell_type": "code",
     "input": "import pandas as pd\ndf = pd.DataFrame({'product':['a','b','c','d','e','f','g','h'],\n                   'platform':[1,2,1,2,1,2,1,2],\n                   'id':[0,1,2,3,4,5,6,7]})\ndf",
     "prompt_number": 21,
     "outputs": [
      {
       "text": "   id  platform product\n0   0         1       a\n1   1         2       b\n2   2         1       c\n3   3         2       d\n4   4         1       e\n5   5         2       f\n6   6         1       g\n7   7         2       h",
       "html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>id</th>\n      <th>platform</th>\n      <th>product</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td> 0</td>\n      <td> 1</td>\n      <td> a</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td> 1</td>\n      <td> 2</td>\n      <td> b</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td> 2</td>\n      <td> 1</td>\n      <td> c</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td> 3</td>\n      <td> 2</td>\n      <td> d</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td> 4</td>\n      <td> 1</td>\n      <td> e</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td> 5</td>\n      <td> 2</td>\n      <td> f</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td> 6</td>\n      <td> 1</td>\n      <td> g</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td> 7</td>\n      <td> 2</td>\n      <td> h</td>\n    </tr>\n  </tbody>\n</table>\n</div>",
       "output_type": "pyout",
       "metadata": {},
       "prompt_number": 21
      }
     ],
     "language": "python",
     "trusted": true,
     "collapsed": false
    },
    {
     "metadata": {},
     "cell_type": "code",
     "input": "df.pivot_table(columns='product', values='platform', index='id')",
     "prompt_number": 22,
     "outputs": [
      {
       "text": "product   a   b   c   d   e   f   g   h\nid                                     \n0         1 NaN NaN NaN NaN NaN NaN NaN\n1       NaN   2 NaN NaN NaN NaN NaN NaN\n2       NaN NaN   1 NaN NaN NaN NaN NaN\n3       NaN NaN NaN   2 NaN NaN NaN NaN\n4       NaN NaN NaN NaN   1 NaN NaN NaN\n5       NaN NaN NaN NaN NaN   2 NaN NaN\n6       NaN NaN NaN NaN NaN NaN   1 NaN\n7       NaN NaN NaN NaN NaN NaN NaN   2",
       "html": "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th>product</th>\n      <th>a</th>\n      <th>b</th>\n      <th>c</th>\n      <th>d</th>\n      <th>e</th>\n      <th>f</th>\n      <th>g</th>\n      <th>h</th>\n    </tr>\n    <tr>\n      <th>id</th>\n      <th></th>\n      <th></th>\n      <th></th>\n      <th></th>\n      <th></th>\n      <th></th>\n      <th></th>\n      <th></th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>  1</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>NaN</td>\n      <td>  2</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>  1</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>  2</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>  1</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>  2</td>\n      <td>NaN</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>  1</td>\n      <td>NaN</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>  2</td>\n    </tr>\n  </tbody>\n</table>\n</div>",
       "output_type": "pyout",
       "metadata": {},
       "prompt_number": 22
      }
     ],
     "language": "python",
     "trusted": true,
     "collapsed": false
    },
    {
     "metadata": {},
     "cell_type": "code",
     "input": "",
     "prompt_number": 21,
     "outputs": [],
     "language": "python",
     "trusted": true,
     "collapsed": false
    },
    {
     "metadata": {},
     "cell_type": "code",
     "input": "",
     "outputs": [],
     "language": "python",
     "trusted": true,
     "collapsed": false
    }
   ],
   "metadata": {}
  }
 ],
 "metadata": {
  "name": "",
  "signature": "sha256:621abbeb1cd360cda07e42d15993350a0aca83997ba5ace8360ae40da2649c72"
 },
 "nbformat": 3
}