Skip to content

Instantly share code, notes, and snippets.

@TomAugspurger

TomAugspurger/Untitled.ipynb

Created July 7, 2016 12:29
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save TomAugspurger/643402b241e6d945118942cb8ccff3ac to your computer and use it in GitHub Desktop.
Save TomAugspurger/643402b241e6d945118942cb8ccff3ac to your computer and use it in GitHub Desktop.
Download ZIP
Display the source blob
Display the rendered blob
Raw
Untitled.ipynb
{
"cells": [
{
"cell_type": "code",
"execution_count": 4,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"idx = pd.MultiIndex.from_product([['a', 'b'],\n",
" [0, 1]])\n",
"\n",
"df = pd.DataFrame(np.random.randn(4, 4),\n",
" index=idx, columns=idx)"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th colspan=\"2\" halign=\"left\">a</th>\n",
" <th colspan=\"2\" halign=\"left\">b</th>\n",
" </tr>\n",
" <tr>\n",
" <th></th>\n",
" <th></th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" <th>0</th>\n",
" <th>1</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">a</th>\n",
" <th>0</th>\n",
" <td>-0.276961</td>\n",
" <td>-0.589660</td>\n",
" <td>0.140308</td>\n",
" <td>0.196686</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>-0.018808</td>\n",
" <td>-1.543069</td>\n",
" <td>-0.571576</td>\n",
" <td>0.083249</td>\n",
" </tr>\n",
" <tr>\n",
" <th rowspan=\"2\" valign=\"top\">b</th>\n",
" <th>0</th>\n",
" <td>1.235971</td>\n",
" <td>-0.988657</td>\n",
" <td>-0.052996</td>\n",
" <td>-0.145566</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>-1.108096</td>\n",
" <td>-0.643574</td>\n",
" <td>-0.162226</td>\n",
" <td>-1.214142</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" a b \n",
" 0 1 0 1\n",
"a 0 -0.276961 -0.589660 0.140308 0.196686\n",
" 1 -0.018808 -1.543069 -0.571576 0.083249\n",
"b 0 1.235971 -0.988657 -0.052996 -0.145566\n",
" 1 -1.108096 -0.643574 -0.162226 -1.214142"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {
"collapsed": false
},
"outputs": [
{
"data": {
"text/html": [
"\n",
" <style type=\"text/css\" >\n",
" \n",
" \n",
" </style>\n",
"\n",
" <table id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fb\" None>\n",
" \n",
"\n",
" <thead>\n",
" \n",
" <tr>\n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" \n",
" <th class=\"col_heading level0 col0\" colspan=2>a\n",
" \n",
" \n",
" \n",
" \n",
" \n",
" <th class=\"col_heading level0 col2\" colspan=2>b\n",
" \n",
" \n",
" \n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" \n",
" <th class=\"col_heading level1 col0\" colspan=1>0\n",
" \n",
" \n",
" \n",
" <th class=\"col_heading level1 col1\" colspan=1>1\n",
" \n",
" \n",
" \n",
" <th class=\"col_heading level1 col2\" colspan=1>0\n",
" \n",
" \n",
" \n",
" <th class=\"col_heading level1 col3\" colspan=1>1\n",
" \n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" \n",
" <th class=\"col_heading level3 col0\" >None\n",
" \n",
" \n",
" \n",
" <th class=\"col_heading level3 col1\" >None\n",
" \n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" \n",
" <th class=\"blank\" >\n",
" \n",
" \n",
" </tr>\n",
" \n",
" </thead>\n",
" <tbody>\n",
" \n",
" <tr>\n",
" \n",
" \n",
" <th id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fb\" class=\"row_heading level0 row0\" rowspan=2>\n",
" a\n",
" \n",
" \n",
" \n",
" <th id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fb\" class=\"row_heading level1 row0\" rowspan=1>\n",
" 0\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow0_col0\" class=\"data row0 col0\" >\n",
" -0.276961\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow0_col1\" class=\"data row0 col1\" >\n",
" -0.58966\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow0_col2\" class=\"data row0 col2\" >\n",
" 0.140308\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow0_col3\" class=\"data row0 col3\" >\n",
" 0.196686\n",
" \n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" \n",
" \n",
" \n",
" <th id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fb\" class=\"row_heading level1 row1\" rowspan=1>\n",
" 1\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow1_col0\" class=\"data row1 col0\" >\n",
" -0.0188078\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow1_col1\" class=\"data row1 col1\" >\n",
" -1.54307\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow1_col2\" class=\"data row1 col2\" >\n",
" -0.571576\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow1_col3\" class=\"data row1 col3\" >\n",
" 0.0832491\n",
" \n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" \n",
" <th id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fb\" class=\"row_heading level0 row2\" rowspan=2>\n",
" b\n",
" \n",
" \n",
" \n",
" <th id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fb\" class=\"row_heading level1 row2\" rowspan=1>\n",
" 0\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow2_col0\" class=\"data row2 col0\" >\n",
" 1.23597\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow2_col1\" class=\"data row2 col1\" >\n",
" -0.988657\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow2_col2\" class=\"data row2 col2\" >\n",
" -0.0529963\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow2_col3\" class=\"data row2 col3\" >\n",
" -0.145566\n",
" \n",
" \n",
" </tr>\n",
" \n",
" <tr>\n",
" \n",
" \n",
" \n",
" \n",
" <th id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fb\" class=\"row_heading level1 row3\" rowspan=1>\n",
" 1\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow3_col0\" class=\"data row3 col0\" >\n",
" -1.1081\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow3_col1\" class=\"data row3 col1\" >\n",
" -0.643574\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow3_col2\" class=\"data row3 col2\" >\n",
" -0.162226\n",
" \n",
" \n",
" \n",
" <td id=\"T_55a6d652_443e_11e6_aa53_a45e60bd97fbrow3_col3\" class=\"data row3 col3\" >\n",
" -1.21414\n",
" \n",
" \n",
" </tr>\n",
" \n",
" </tbody>\n",
" </table>\n",
" "
],
"text/plain": [
"<pandas.formats.style.Styler at 0x115103da0>"
]
},
"execution_count": 6,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.style"
]
},
{
"cell_type": "code",
"execution_count": null,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "Python 3",
"language": "python",
"name": "python3"
},
"language_info": {
"codemirror_mode": {
"name": "ipython",
"version": 3
},
"file_extension": ".py",
"mimetype": "text/x-python",
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
"version": "3.5.2"
}
},
"nbformat": 4,
"nbformat_minor": 0
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment