Skip to content

Instantly share code, notes, and snippets.

@genya0407
Created November 27, 2017 13:24
Show Gist options
  • Save genya0407/3384040f6a4d9add0affc2a15aa665a3 to your computer and use it in GitHub Desktop.
Save genya0407/3384040f6a4d9add0affc2a15aa665a3 to your computer and use it in GitHub Desktop.
Display the source blob
Display the rendered blob
Raw
{
"cells": [
{
"cell_type": "code",
"execution_count": 11,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"%matplotlib inline\n",
"import seaborn as sns\n",
"import pandas as pd\n",
"sns.set()"
]
},
{
"cell_type": "code",
"execution_count": 21,
"metadata": {},
"outputs": [],
"source": [
"df = pd.DataFrame(\n",
" [\n",
" {'lv': 1, 'kin1': 100, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 1, 'kin1': 100, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 2, 'kin1': 200, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 2, 'kin1': 34, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 3, 'kin1': 200, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 3, 'kin1': 200, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 4, 'kin1': 45, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 4, 'kin1': 67, 'kin2': 10, 'kin3': 100},\n",
" {'lv': 1, 'kin1': 5000, 'kin2': 10, 'kin3': 100 },\n",
" ]\n",
")"
]
},
{
"cell_type": "code",
"execution_count": 24,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>kin1</th>\n",
" <th>kin2</th>\n",
" <th>kin3</th>\n",
" <th>lv</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>100</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>100</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>34</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>45</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>67</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>5000</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" kin1 kin2 kin3 lv\n",
"0 100 10 100 1\n",
"1 100 10 100 1\n",
"2 200 10 100 2\n",
"3 34 10 100 2\n",
"4 200 10 100 3\n",
"5 200 10 100 3\n",
"6 45 10 100 4\n",
"7 67 10 100 4\n",
"8 5000 10 100 1"
]
},
"execution_count": 24,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "code",
"execution_count": 26,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"df_sorted = df.sort_values(by='lv')"
]
},
{
"cell_type": "code",
"execution_count": 27,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>kin1</th>\n",
" <th>kin2</th>\n",
" <th>kin3</th>\n",
" <th>lv</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>100</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>100</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>5000</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>1</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>34</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>2</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>3</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>45</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>4</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>67</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" <td>4</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" kin1 kin2 kin3 lv\n",
"0 100 10 100 1\n",
"1 100 10 100 1\n",
"8 5000 10 100 1\n",
"2 200 10 100 2\n",
"3 34 10 100 2\n",
"4 200 10 100 3\n",
"5 200 10 100 3\n",
"6 45 10 100 4\n",
"7 67 10 100 4"
]
},
"execution_count": 27,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_sorted"
]
},
{
"cell_type": "code",
"execution_count": 28,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x116360b70>"
]
},
"execution_count": 28,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAcUAAAFMCAYAAAC6fqeUAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGXRJREFUeJzt3X9wVPXZ9/HP2U1CJJutBZWKBQ0WKLSgdyZ3htEQxCHF\n0gIlUgHbUFTUhkGIBgfDj8RUINDR4AwUf9B7bEEzaAoydMZOp8VqjOmQ3kzjj1TpWCOi8WaQPH2a\nBEJCznn+4CR9cpMsISdnk/3m/ZrZGdl893DtTsYP1/dc56zlOI4jAACgwEAXAADAYEEoAgDgIhQB\nAHARigAAuAhFAABchCIAAK64gS4AAIBIFixYoFAoJEn6+te/rkWLFmnz5s0KBoPKyMjQypUrZdu2\nHn/8cR07dkwJCQnatGmTrr/+etXU1Fy0NhJCEQAwaJ07d06O42jv3r2dz82fP187duzQmDFj9MAD\nD+hvf/ubPvvsM7W2turll19WTU2Ntm7dqmeeeUZFRUUXrZ08eXKPfx+hCAAYtD788EOdPXtW9957\nr86fP6+HHnpIra2tGjt2rCQpIyNDVVVVOnXqlKZPny5Juvnmm/X++++rqamp27UDFootp//Hz8ND\nUiA+fqBLMJ7d1jbQJQwJ/C77LyE80rdjT71+Rp9f++7xN3v8WWJiou677z798Ic/1CeffKL7779f\n4XC48+dJSUk6ceKEmpqaOrdYJSkYDF70XMfaSOgUAQCeWZbly3FTUlJ0/fXXy7IspaSkKDk5Wf/8\n5z87f97c3KxwOKyWlhY1Nzd3Pm/btkKhUJfnOtZGwvQpAGDQ+s1vfqOtW7dKkk6ePKmzZ89q+PDh\n+vTTT+U4jiorK5WWlqbU1FRVVFRIkmpqajRhwgSFQiHFx8dftDYSOkUAgGeW5U+PtXDhQhUUFGjJ\nkiWyLEtbtmxRIBDQmjVr1N7eroyMDN10002aMmWK3n77bS1evFiO42jLli2SpOLi4ovWRnwffn5L\nBucU/cd5GP9xTjE6+F32n5/nFG9Oub3Pr62pe70fK/GGThEA4FlA/pxTjDZCEQDgmV+DNtFGKAIA\nPAv4dE4x2ghFAIBnpnSKZkQ7AAD9gFAEAMDF9ikAwDOL6VMAAC5g0AYAAJcpgza9DkXbthUImPEv\nAQBA/woMhVA8ceKESkpK9P777ysuLk62bWvChAkqKChQSkpKtGoEACAqIobi+vXrlZ+f3+UGqjU1\nNSooKNC+fft8Lw4AgGiKGIqtra0X3VH85ptv9rUgAEDssQy5wi9iKE6cOFEFBQWaPn26kpOT1dzc\nrDfffFMTJ06MVn0AgBgwJAZtHn/8cf3xj3/U0aNH1dTUpFAopJkzZyorKyta9QEAYsCQGLSxLEtZ\nWVmEIAAgIlMu3jdjExgAgH5AKAIA4OKONgAAz7jNGwAAriExfQoAQG8MielTAAB6g+lTAAAMQ6cI\nAPDMlEEbM94FAAD9gE4RAOAZ06cAALiYPgUAwMX0KQAAhqFTBAB4xjlFAABcppxTZPsUAAAXnSIA\nwDNTBm0IRQCAZ9zRBgAAw9ApAgA8Y/oUAACXKdOnhCIAwDNTBm04pwgAgItOEQDgmSnbp3SKAAC4\n6BQBAJ4xfQoAgMuU7VNCEQDgmSnTp4QiAMAzUzpFBm0AAHBF7BRzcnLU1tbW5TnHcWRZlvbt2+dr\nYQAARFvEUFyzZo02bNigX/ziFwoGg9GqCQAQY4bE9OlNN92k+fPn69ixY8rKyopWTQCAGGPKOcVL\nDtosX748GnUAAGIY06cAALhM6RSZPgUAwEUoAgAGvdOnT2vGjBn6xz/+oePHj2vJkiW6++67VVRU\nJNu2JUk7d+7UwoULtXjxYr377ruS1OPanhCKAADPLMvq8+NS2traVFhYqMTERElSSUmJ8vLyVFZW\nJsdxdPjwYdXW1qq6ulrl5eUqLS1VcXFxj2sjIRQBAJ4FLKvPj0vZtm2bFi9erGuuuUaSVFtbq/T0\ndElSZmamqqqqdPToUWVkZMiyLI0ePVrt7e1qaGjodm3E9+HxcwAAwLdO8cCBAxoxYoSmT5/e+VzH\nTWQkKSkpSY2NjWpqalIoFOpc0/F8d2sjYfoUAOCZX5dk7N+/X5Zl6c9//rM++OADrV27Vg0NDZ0/\nb25uVjgcVigUUnNzc5fnk5OTFQgELlobCZ0iAGDQeumll/Tiiy9q7969mjRpkrZt26bMzEwdOXJE\nklRRUaG0tDSlpqaqsrJStm2rvr5etm1rxIgRmjx58kVrI6FTBAB4FojiZYpr167Vxo0bVVpaqnHj\nxmn27NkKBoNKS0vTokWLZNu2CgsLe1wbieU4juNX4S2n/8evQ8MViI8f6BKMZ/+vm+LDH/wu+y8h\nPNK3Y6+ckdfn1+588+l+rMQbOkUAgGdD4obgAAD0him3efM1FO3zrX4eHmLLCcDgYEqnyPQpAAAu\ntk8BAJ4F+OooAAAuYPsUAADD0CkCADxj+hQAAJchmcj2KQAAHegUAQCesX0KAIDLr6+OijZCEQDg\nGZdkAABgGDpFAIBnnFMEAMBlSCZe/vZpayvffAEAMFOPofj6669r5syZysrK0muvvdb5/PLly6NS\nGAAgdgQsq8+PwaTH7dNnn31WBw8elG3bWr16tc6dO6cFCxbIcZxo1gcAiAHGX5IRHx+vr3zlK5Kk\nXbt26Sc/+YmuvfZaY8ZuAQD9Z7B1fH3V4/bpddddp5KSEp05c0ahUEg7d+7Uz372M3388cfRrA8A\ngKjpMRS3bNmiiRMndnaG1157rfbs2aPvfve7USsOABAbLKvvj8Gkx+3TuLg4ZWdnd3nuqquu0vr1\n630vCgCAgcB1igAAz0yZNyEUAQCemTJoQygCADwzJBMJRQCAd6Z0inxLBgAALkIRAAAX26cAAM+M\nv80bAAC9xSUZAAC4AmZkIqEIAPDOlE6RQRsAAFyEIgAALl+3T+MSh/t5eADAIGHK9innFAEAnjFo\nAwCAi04RAACXIZnIoA0AAB3oFAEAnvEtGQAAGIZOEQDgGTcEBwDAZcjuKaEIAPCOc4oAABiGThEA\n4BkX7wMA4DIkE9k+BQCgw2V1ii0tLQoEAkpISPCrHgBADDJl+zRip/jRRx9pxYoVKigoUFVVlebM\nmaM5c+boT3/6U7TqAwDEgIDV98dgErFTLCoq0urVq/X5559r1apV+v3vf69hw4Zp+fLlmjlzZrRq\nBAAgKiKGom3bSk9PlyQdOXJEI0eOvPCiOOZzAAD/5tf2aXt7uzZs2KC6ujpZlqXi4mINGzZMjz32\nmCzL0vjx41VUVKRAIKCdO3fqjTfeUFxcnNatW6epU6fq+PHj3a7tScTt05SUFK1fv162bWvr1q2S\npOeff15XXXVV/75rAEBMs6y+PyLpOF23b98+5eXlafv27SopKVFeXp7KysrkOI4OHz6s2tpaVVdX\nq7y8XKWlpSouLpakbtdGErHl27Rpk15//fUuqTpq1Cjl5OT05jMCAAwRft3RZtasWbrtttskSfX1\n9QqHw6qqqurcxczMzNTbb7+tlJQUZWRkyLIsjR49Wu3t7WpoaFBtbe1Fa7Oysnp+H5GKCQQCmjVr\nVpfn5s+fryuuuMLLewQAoNfi4uK0du1aPfHEE5o7d64cx+ncrk1KSlJjY6OampoUCoU6X9PxfHdr\nI/5d/r0NAMBQ4fclGdu2bdOaNWt011136dy5c53PNzc3KxwOKxQKqbm5ucvzycnJXXY6O9ZGwsX7\nAIBB6+DBg3ruueckSVdccYUsy9K3v/1tHTlyRJJUUVGhtLQ0paamqrKyUrZtq76+XrZta8SIEZo8\nefJFayOxHMdx/Hozrf/3S78OjQ6GXDA7mNltbQNdwpAQiI8f6BKMlxAe6duxX7zvqT6/9sf/ld/j\nz86cOaOCggJ9+eWXOn/+vO6//37deOON2rhxo9ra2jRu3Dht2rRJwWBQO3bsUEVFhWzbVkFBgdLS\n0lRXV9ft2p4QirGOUPQdoRgdhKL//AzFl5aX9vm1P/rlI/1YiTecUwQAeGbKv88JRQCAZ3zJMAAA\nhiEUAQBwsX0KAPDMkN1TQhEA4J0p36dIKAIAPDMkEwlFAIB3dIq9cL7ljJ+Hh6S4K5IGugQAMAbT\npwAAuNg+BQB4ZsjuKaEIAPDOlDvaEIoAAM8MyURCEQDgnSnTpwzaAADgolMEAHhmSKNIpwgAQAc6\nRQCAZ6acUyQUAQCeGZKJhCIAwDtTOkXOKQIA4KJTBAB4Zkij2PtO8fTp037WAQCIYZZl9fkxmPQY\ninV1dV0eubm5nf8NAICJetw+veeee5SYmKhrrrlGjuOorq5OhYWFsixLe/bsiWaNAIBBbpA1fH3W\nYyju379fRUVFWrJkiW699Vbl5ORo79690awNABAjjP+WjJEjR+rpp5/Wtm3b9N5770WzJgBAjDEk\nEyMP2sTFxWn9+vWdW6gAAJisV5dkZGdnKzs72+9aAAAxarBNkfYV1ykCADwzJBO5ow0AAB3oFAEA\nnlkBM1pFQhEA4BnbpwAAGIZOEQDgGdOnAAC4DMlEQhEA4J0pnSLnFAEAcNEpAgA8M6RRpFMEAKAD\nnSIAwDtDWkVCEQDgmSmDNoQiAMAzQzKRUAQAeGfKvU8ZtAEAwEUoAgDgYvsUAOAZ5xQBAHAxfQoA\ngMuQTCQUAQDemdIpMmgDAICLUAQAwMX2KQDAM792T9va2rRu3Tp9/vnnam1tVW5urr7xjW/oscce\nk2VZGj9+vIqKihQIBLRz50698cYbiouL07p16zR16lQdP36827U9oVMEAHhmWVafH5EcOnRIV155\npcrKyvTLX/5STzzxhEpKSpSXl6eysjI5jqPDhw+rtrZW1dXVKi8vV2lpqYqLiyWp27WREIoAAO8C\nHh4R3HHHHVq9erUkyXEcBYNB1dbWKj09XZKUmZmpqqoqHT16VBkZGbIsS6NHj1Z7e7saGhq6XXup\nt9Ertm3r5MmTsm27ty8BAAwRfnWKSUlJCoVCampq0qpVq5SXlyfHcTpfl5SUpMbGRjU1NSkUCnV5\nXWNjY7drI4kYiuvWrZMkvfPOO5o9e7ZWrlyp73//+6qpqbn0JwQAQD/44osvtHTpUs2fP19z587t\nck6wublZ4XBYoVBIzc3NXZ5PTk7udm0kEUPxs88+kyRt375du3fvVnl5uV544QU9+eSTfXpjAABc\nji+//FL33nuvHn30US1cuFCSNHnyZB05ckSSVFFRobS0NKWmpqqyslK2bau+vl62bWvEiBHdro2k\nV9OnwWBQN9xwgyRp1KhRbKECALrwa/r02Wef1b/+9S/t2rVLu3btkiStX79emzZtUmlpqcaNG6fZ\ns2crGAwqLS1NixYtkm3bKiwslCStXbtWGzdu7LI24vtwHMfp6YfZ2dmSpDNnzui+++7TvHnztHXr\nVjU2NvaqWzxz8tNev3H0TdwVSQNdgvHstraBLmFICMTHD3QJxksIj/Tt2H99em+fX/sfeTn9WIk3\nETvFAwcOqLW1VR9++KESExNlWZYmTJjQ2cICACANoXufJiQkaOrUqZ1/XrJkia8FAQBikCGpyHWK\nAAC4uM0bAMAzK0CnCACAUegUAQCeGXJKkVAEAHhnypcME4oAAM8MyUTOKQIA0IFOEQDgnSGtIqEI\nAPCMSzIAADAMnSIAwDNDdk8JRQBAPzAkFdk+BQDA5WunGByW6OfhAQCDhCGNItunAADvTJk+JRQB\nAJ6Zcps3zikCAOCiUwQAeGdGo0inCABABzpFAIBnppxTJBQBAJ4RigAAdDDkZByhCADwzJRO0ZBs\nBwDAO0IRAAAX26cAAM9M2T4lFAEA3pmRiZcXig0NDfrqV79qzL8IAAD9Y0jcEHz//v364osvNHPm\nTOXn52vYsGFqaWlRUVGRbrnllmjVCAAY7AxpliKGYllZmfbu3avc3Fw988wzSklJ0cmTJ7VixQpC\nEQBgnIjTp/Hx8Ro+fLiSkpI0ZswYSdKoUaPYPgUAGClip3j77bcrNzdXEyZM0IMPPqjp06frrbfe\n0rRp06JVHwAgBpjSK0UMxQceeEDV1dWqrKzU6NGjdfr0aeXk5Oi2226LUnkAgFhgyg7iJadP09PT\nlZ6eHo1aAACxaihMnwIA0BumdIrc5g0AABedIgDAOzMaRTpFAAA60CkCADwz5ZwioQgA8GxI3PsU\nAIBeoVMEAOACU7ZPGbQBAMBFpwgA8M6MRpFOEQCADnSKAADPmD7tDcfx9fAAgEHCkEEbOkUAgGdM\nnwIAYBhCEQDgXcDq+6MX3nnnHeXk5EiSjh8/riVLlujuu+9WUVGRbNuWJO3cuVMLFy7U4sWL9e67\n70Zc2+Pb8PARAAAg6cL2aV8fl7J7925t2LBB586dkySVlJQoLy9PZWVlchxHhw8fVm1traqrq1Ve\nXq7S0lIVFxf3uDYSQhEAMKiNHTtWO3bs6PxzbW2t0tPTJUmZmZmqqqrS0aNHlZGRIcuyNHr0aLW3\nt6uhoaHbtZEQigAA7ywPj0uYPXu24uL+PRfqOE5nh5mUlKTGxkY1NTUpFAp1rul4vru1kTB9CgDw\nLJrTp4HAv/u55uZmhcNhhUIhNTc3d3k+OTm527URj93/5QIA4J/JkyfryJEjkqSKigqlpaUpNTVV\nlZWVsm1b9fX1sm1bI0aM6HZtJHSKAADvonhHm7Vr12rjxo0qLS3VuHHjNHv2bAWDQaWlpWnRokWy\nbVuFhYU9ro3Echz/bjtz7v+c9OvQcFlB/l3jN7utbaBLGBIC8fEDXYLxEsIjfTv2ybfe6PNrR02/\nrd/q8Ir/owIAvOOONgAAmIVOEQDg2ZC492lTU1O06gAAYMBFDMVbb71V5eXl0aoFABCrfL73abRE\nDMVvfvOb+uCDD7R06VJVV1dHqyYAQIzx896n0RTxnOKwYcNUWFio9957T88//7yeeOIJTZs2TWPG\njNHSpUujVSMAYLAbZOHWVxFDseMSxilTpmjHjh1qbGzUX/7yF9XV1UWlOABAbLAG2TZoX0UMxezs\n7C5/Tk5O1u233+5rQQAADJSI5xQXLFgQrToAABhwXKcIAPBuKJxTBACgNwbbFGlfEYoAAO8IRQAA\nLjBl+pQbggMA4CIUAQBwsX0KAPCOc4oAALgIRQAALuCSDAAAOjB9CgCAWegUAQCeWZYZPZavofif\nN9/l5+Eh6b/fOzDQJQCAMegUAQDeMWgDAMAFTJ8CANCB6VMAAMxCpwgA8IztUwAAOhgSimyfAgDg\nolMEAHjHxfsAAFxgMX0KAIBZ6BQBAN4ZMmhDKAIAPOOSDAAAOhgyaHNZ76K1tVUtLS1+1QIAwICK\nGIp1dXVatWqV8vPzVVNTo7lz5+p73/ueXnvttWjVBwCIAVbA6vNjMIm4fbpx40atWLFCjY2NevDB\nB3Xo0CElJyfrnnvu0Zw5c6JVIwAAURGxUzx//rxuueUWfec739GVV16pUaNGafjw4YqL41QkAOD/\nY1l9fwwiEdPtuuuu08MPP6z29nYlJSVp+/btCoVCuvrqq6NVHwAgBgyJ6dNt27bpzTff1A033KCk\npCT96le/UmJiorZs2RKt+gAAscCQ6VPLcRzHr4NPvX6GX4eG67/fOzDQJRjPbmsb6BKGhEB8/ECX\nYLyE8Ejfjn3m5Kd9fu3wUWP7sRJvzIh2AAD6AaEIAICLMVIAgGdDYtAGAIBeMWTQhlAEAHhGpwgA\nQAdDOkUz3gUAAP2AUAQAwMX2KQDAs8H2bRd9RSgCALxj0AYAgAssQwZtCEUAgHeGdIq+3hAcAIBY\nYka/CwBAPyAUAQBwEYoAALgIRQAAXIQiAAAuQhEAABehCACAa0iF4oEDB/Tkk092/rmiokIvv/zy\nJV/3hz/8Qfn5+X6WZozL/YwbGxv105/+VD/+8Y+1aNEi/fWvf41GmTHvcj/nM2fOKDc3Vz/60Y+0\nbNkynTx5MhplGul/f/Ywy5C+o01mZuYl12zatEmVlZWaNGlSFCoyz6U+4xdeeEHTpk3TsmXL9PHH\nHys/P1+vvvpqlKozx6U+51deeUXf+ta3tHLlSh04cEC7d+/Whg0bolQdEDuGZCg2NDRoxYoVuvPO\nO3X8+HEtXrxY+fn5+trXvqYTJ05oypQpKi4uliSlpqZq1qxZveoo8W+9/YyXLVumhIQESVJ7e7uG\nDRs2wJXHlsv5nNvb2yVJ9fX1CofDA1x5bHvllVeUmJiolStXqrW1VfPmzdOhQ4c6f5cRu4bU9qkk\nnT59Wrm5uSooKFAwGOx8/pNPPtHmzZtVXl6uiooKnTp1SpI0Z84cWYbc0y9aLuczDofDSkxM1KlT\np/Too4/qkUceGcDKY8vl/i4Hg0EtXbpUL774orKysgaqbCPccccd+t3vfifHcXT48GHNnDmTQDTE\nkAvFt956S62trbJtu8vzY8eOVSgUUjAY1NVXX61z584NUIWx73I/42PHjmnZsmV6+OGHlZ6ePhAl\nx6S+/C7v2bNHL730kh566KFol2uUcDisSZMm6ejRo3r11Ve1cOHCgS4J/WTIheIPfvAD/fznP9eG\nDRt09uzZzufpBvvP5XzGH330kVavXq2nnnpKM2bMiGaZMe9yPufnnntOBw8elCQlJSV16SzRN3fd\ndZd+/etfq6WlRTfeeONAl4N+MuRCUZLGjx+vefPmqaSkZKBLMVZvP+OnnnpKra2t2rx5s3JycpSb\nmxulCs3Q28/5zjvv1G9/+1vl5OTokUce0ZYtW6JUobnS09P197//XdnZ2QNdCvoRXx0FAIBrSHaK\nAAB0h1AEAMBFKAIA4CIUAQBwEYoAALgIRQAAXIQiAACu/weqte5emoXDswAAAABJRU5ErkJggg==\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x1163061d0>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"sns.heatmap(df)"
]
},
{
"cell_type": "code",
"execution_count": 29,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.axes._subplots.AxesSubplot at 0x11634f668>"
]
},
"execution_count": 29,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAcUAAAFMCAYAAAC6fqeUAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGYxJREFUeJzt3X9wVPW9//HX2U1CJJstAyoVCwIWEFrQm+abYTREsVAs\nLVJiKmAbSi3WhkGIBgfCr5gSCHRqcAZaq/ROW8AMmooMndHptPgjpuklvbmNP1KhY42IxJsvknYm\nWcgPcvb+wUm8XJIl5ORssp88HzNnxpx89vDency8fH8+n3PWCofDYQEAAPkGugAAAAYLQhEAAAeh\nCACAg1AEAMBBKAIA4CAUAQBwxA10AQAARLJo0SIFAgFJ0he+8AUtXrxY27Ztk9/vV3p6ulatWiXb\ntvXEE0/oxIkTSkhIUFFRkW666SbV1NRcNjYSQhEAMGi1trYqHA5r//79XecWLlyo3bt3a+zYsfrh\nD3+ov/3tb/r444/V1tam559/XjU1NdqxY4eefvppFRQUXDZ22rRpPf57hCIAYNA6fvy4zp8/rwcf\nfFAXLlzQI488ora2No0bN06SlJ6ersrKSp05c0azZs2SJN12221699131dzc3O3YAQvFlrP/7eXl\nIckXHz/QJRjPbm8f6BKGBP6WvZcQHOXZtWfcdGefX/v2yTd6/F1iYqJ+8IMf6Nvf/rY+/PBDPfTQ\nQwoGg12/T0pK0qlTp9Tc3Nw1xSpJfr//snOdYyOhUwQAuGZZlifXnTBhgm666SZZlqUJEyYoOTlZ\n//rXv7p+HwqFFAwG1dLSolAo1HXetm0FAoFLznWOjYTdpwCAQeu3v/2tduzYIUlqaGjQ+fPnNXz4\ncH300UcKh8OqqKhQamqqUlJSVF5eLkmqqanR5MmTFQgEFB8ff9nYSOgUAQCuWZY3PVZWVpby8/O1\ndOlSWZal7du3y+fzae3atero6FB6erpuvfVWTZ8+XX/605+0ZMkShcNhbd++XZJUWFh42diI78PL\nb8lgTdF7rMN4jzXF6OBv2XterineNuHuPr+2pu7VfqzEHTpFAIBrPnmzphhthCIAwDWvNtpEG6EI\nAHDN59GaYrQRigAA10zpFM2IdgAA+gGhCACAg+lTAIBrFrtPAQC4iI02AAA4TNlo0+tQtG1bPp8Z\n/ycAAOhfvqEQiqdOnVJxcbHeffddxcXFybZtTZ48Wfn5+ZowYUK0agQAICoihuLGjRuVl5d3yQNU\na2pqlJ+fr4MHD3peHAAA0RQxFNva2i57ovhtt93maUEAgNhjGXKHX8RQnDJlivLz8zVr1iwlJycr\nFArpjTfe0JQpU6JVHwAgBgyJjTZPPPGE/vjHP6q6ulrNzc0KBAKaPXu25s6dG636AAAxYEhstLEs\nS3PnziUEAQARmXLzvhmTwAAA9ANCEQAAB0+0AQC4xmPeAABwDIndpwAA9MaQ2H0KAEBvsPsUAADD\n0CkCAFwzZaONGe8CAIB+QKcIAHCN3acAADjYfQoAgIPdpwAAGIZOEQDgGmuKAAA4TFlTZPoUAAAH\nnSIAwDVTNtoQigAA13iiDQAAhqFTBAC4xu5TAAAcpuw+JRQBAK6ZstGGNUUAABx0igAA10yZPqVT\nBADAQacIAHCN3acAADhMmT4lFAEArpmy+5RQBAC4ZkqnyEYbAAAcETvF7Oxstbe3X3IuHA7Lsiwd\nPHjQ08IAAIi2iKG4du1abdq0ST/72c/k9/ujVRMAIMYMid2nt956qxYuXKgTJ05o7ty50aoJABBj\nTFlTvOJGmxUrVkSjDgBADGP3KQAADlM6RXafAgDgIBQBAIPe2bNndeedd+of//iHTp48qaVLl+qB\nBx5QQUGBbNuWJO3Zs0dZWVlasmSJ3n77bUnqcWxPCEUAgGuWZfX5uJL29nZt2bJFiYmJkqTi4mLl\n5uaqtLRU4XBYR48eVW1traqqqlRWVqaSkhIVFhb2ODYSQhEA4JrPsvp8XMnOnTu1ZMkSXX/99ZKk\n2tpapaWlSZIyMjJUWVmp6upqpaeny7IsjRkzRh0dHWpsbOx2bMT34fJzAADAs07x0KFDGjlypGbN\nmtV1rvMhMpKUlJSkpqYmNTc3KxAIdI3pPN/d2EjYfQoAcM2rWzJefPFFWZalP//5z3rvvfe0bt06\nNTY2dv0+FAopGAwqEAgoFApdcj45OVk+n++ysZHQKQIABq3nnntOBw4c0P79+zV16lTt3LlTGRkZ\nOnbsmCSpvLxcqampSklJUUVFhWzbVn19vWzb1siRIzVt2rTLxkZCpwgAcM0XxdsU161bp82bN6uk\npEQTJ07UvHnz5Pf7lZqaqsWLF8u2bW3ZsqXHsZFY4XA47FXhLWf/26tLw+GLjx/oEoxn/5+H4sMb\n/C17LyE4yrNrr7ozt8+v3fPGU/1YiTt0igAA14bEA8EBAOgNUx7z5mkopqUs9vLykPSf7xwa6BIA\nwJhOkd2nAAA4mD4FALjm46ujAAC4iOlTAAAMQ6cIAHCN3acAADgMyUSmTwEA6ESnCABwjelTAAAc\nXn11VLQRigAA17glAwAAw9ApAgBcY00RAACHIZl4ddOnbW1tamlp8aoWAAAGVMRQrKur0+rVq5WX\nl6eamhotWLBA3/jGN/Tyyy9Hqz4AQAzwWVafj8Ek4vTp5s2btXLlSjU1Nenhhx/WkSNHlJycrO9/\n//uaP39+tGoEAAxyptySEbFTvHDhgm6//XZ97Wtf04gRIzR69GgNHz5ccXEsRQIAPjMkOsUbb7xR\njz76qDo6OpSUlKRdu3YpEAjouuuui1Z9AABETcRQ3Llzp9544w2NHz9eSUlJ+vWvf63ExERt3749\nWvUBAGLAIGv4+ixiKMbFxemrX/1q18/r16/3vCAAAAYKi4MAANdMecwboQgAcG2wbZjpK0IRAOCa\nIZlIKAIA3DOlU+RbMgAAcBCKAAA4mD4FALhmymPeCEUAgGvckgEAgMNnRiYSigAA90zpFNloAwCA\ng1AEAMDh6fTpf1Tt9/LyAIBBwpTpU9YUAQCusdEGAAAHnSIAAA5DMpGNNgAAdKJTBAC4xrdkAABg\nGDpFAIBrPBAcAACHIbOnhCIAwD3WFAEAMAydIgDANW7eBwDAYUgmMn0KAECnq+4U29ralJCQ4EUt\nAIAYZcr0aY+d4quvvqrZs2dr7ty5evnll7vOr1ixIiqFAQBih8/q+zGY9Ngp/uIXv9Dhw4dl27bW\nrFmj1tZWLVq0SOFwOJr1AQAQNT2GYnx8vD73uc9Jkn7+85/re9/7nm644QZjWmQAQP/xKhs6Ojq0\nadMm1dXVybIsFRYWatiwYVq/fr0sy9KkSZNUUFAgn8+nPXv26PXXX1dcXJw2bNigGTNm6OTJk92O\n7UmPv7nxxhtVXFysc+fOKRAIaM+ePfrxj3+sDz74wJM3DgCIXZbV9yOS1157TZJ08OBB5ebmateu\nXSouLlZubq5KS0sVDod19OhR1dbWqqqqSmVlZSopKVFhYaEkdTs2kh5Dcfv27ZoyZUpX+t9www3a\nt2+fvv71r1/N5wQAGAJ8ltXnI5I5c+Zo69atkqT6+noFg0HV1tYqLS1NkpSRkaHKykpVV1crPT1d\nlmVpzJgx6ujoUGNjY7djI76Pnn4RFxenzMxMXXPNNV3nrr32Wm3cuLF3nxAAAP0gLi5O69at09at\nW7VgwQKFw+Guhi0pKUlNTU1qbm5WIBDoek3n+e7GRvy3vHsbAIChwuv9Jjt37tTatWt1//33q7W1\ntet8KBRSMBhUIBBQKBS65HxycvIl64edYyPh5n0AwKB1+PBhPfPMM5Kka665RpZl6ctf/rKOHTsm\nSSovL1dqaqpSUlJUUVEh27ZVX18v27Y1cuRITZs27bKxkVhhD++xONfwkVeXhiPumqSBLsF4dnv7\nQJcwJPji4we6BOMlBEd5du0DP3iyz6/97r/n9fi7c+fOKT8/X59++qkuXLighx56SDfffLM2b96s\n9vZ2TZw4UUVFRfL7/dq9e7fKy8tl27by8/OVmpqqurq6bsf2hFCMcYSi9wjF6CAUvedlKD63oqTP\nr/3OLx/rx0rcYU0RAOCaKbewE4oAANf4kmEAAAxDKAIA4GD6FADgmiGzp4QiAMA9U74sglAEALhm\nSCYSigAA9+gUe3PxxOFeXh4AgH7F7lMAABxMnwIAXDNk9pRQBAC4Z8oTbQhFAIBrhmQioQgAcM+U\n3adstAEAwEGnCABwzZBGkU4RAIBOdIoAANdMWVMkFAEArhmSiYQiAMA9UzpF1hQBAHDQKQIAXDOk\nUby6UGxpaZHP51NCQoJX9QAAYtCQmD59//33tXLlSuXn56uyslLz58/X/Pnz9dprr0WrPgAAoiZi\np1hQUKA1a9bo9OnTWr16tX7/+99r2LBhWrFihWbPnh2tGgEAg5whjWLkULRtW2lpaZKkY8eOadSo\nURdfFMdSJADgM6Z8S0bE6dMJEyZo48aNsm1bO3bskCQ9++yzuvbaa6NSHAAgNlhW34/BJGLLV1RU\npFdffVU+32fZOXr0aGVnZ3teGAAA0RYxFH0+n+bMmXPJuYULF3paEAAg9piy+5TFQQCAa4ZkIk+0\nAQCgE50iAMA1y2dGq0goAgBcY/oUAADD0CkCAFxj9ykAAA5DMpFQBAC4Z0qnyJoiAAAOOkUAgGuG\nNIp0igAAdKJTBAC4Z0ir6GkoXmg55+XlISnumqSBLgEAjNloQ6cIAHDNkEwkFAEA7pny7FM22gAA\n4CAUAQBwMH0KAHCNNUUAABzsPgUAwGFIJhKKAAD3TOkU2WgDAICDUAQAwMH0KQDANa9mT9vb27Vh\nwwadPn1abW1tysnJ0Re/+EWtX79elmVp0qRJKigokM/n0549e/T6668rLi5OGzZs0IwZM3Ty5Mlu\nx/aEThEA4JplWX0+Ijly5IhGjBih0tJS/fKXv9TWrVtVXFys3NxclZaWKhwO6+jRo6qtrVVVVZXK\nyspUUlKiwsJCSep2bCSEIgDAPZ+LI4J77rlHa9askSSFw2H5/X7V1tYqLS1NkpSRkaHKykpVV1cr\nPT1dlmVpzJgx6ujoUGNjY7djr/Q2AABwxatOMSkpSYFAQM3NzVq9erVyc3MVDoe7XpeUlKSmpiY1\nNzcrEAhc8rqmpqZux0bS61A8e/Zsb4cCANBvPvnkEy1btkwLFy7UggULLlkTDIVCCgaDCgQCCoVC\nl5xPTk7udmwkPYZiXV3dJUdOTk7XfwMAEA2ffvqpHnzwQT3++OPKysqSJE2bNk3Hjh2TJJWXlys1\nNVUpKSmqqKiQbduqr6+XbdsaOXJkt2MjscLhcLi7X9x1111KTEzU9ddfr3A4rOPHj+uWW26RZVna\nt29fr97MuYaPev3G0Td8ybD37Pb2gS5hSPDFxw90CcZLCI7y7Nr/tat3udCdlEeX9fi7oqIivfLK\nK5o4cWLXuY0bN6qoqEjt7e2aOHGiioqK5Pf7tXv3bpWXl8u2beXn5ys1NVV1dXXavHnzZWN70mMo\nnj17VgUFBVq6dKnuuOMOZWdna//+/Vf1RglF7xGK3iMUo4NQ9J6XofjXp64uH/63f8vN7sdK3Onx\nPsVRo0bpqaee0s6dO/XOO+9EsyYAQIwx5ClvkTfaxMXFaePGjV1TqAAAdMuy+n4MIr16ok1mZqYy\nMzO9rgUAgAHFY94AAK5ZvsHV8fUVN+8DAOCgUwQAuDbIlgb7jFAEALhmypcME4oAANcMyUTWFAEA\n6ESnCABwz5BWkVAEALjGLRkAABiGThEA4Johs6eEIgCgHxiSikyfAgDgoFMEALhmSKNIKAIA3DNl\n9ymhCABwzZTHvLGmCACAg04RAOCeGY0inSIAAJ3oFAEArpmypkgoAgBcIxQBAOhkyGIcoQgAcM2U\nTtGQbAcAwD1CEQAAB9OnAADXTJk+JRQBAO6ZkYm9nz61bVsNDQ2ybdvLegAAMcjyWX0+BpOIobhh\nwwZJ0ltvvaV58+Zp1apV+uY3v6mampqoFAcAiBGW1fdjEIk4ffrxxx9Lknbt2qW9e/dq/Pjxamho\nUF5eng4cOBCVAgEAiJZeTZ/6/X6NHz9ekjR69GimUAEARooYis3NzcrMzNTp06dVVlam1tZWFRYW\nasyYMdGqDwAQAwyZPY08fXro0CG1tbXp+PHjSkxMlGVZmjx5srKysqJVHwAgBgyZWzISEhI0Y8aM\nrp+XLl3qaUEAgBg0yHaR9hX3KQIAXDOlU+QxbwAAOOgUAQDumdEo0ikCANCJThEA4Jopa4qEIgDA\ntcH2DNO+IhQBAO7RKQIAcJEp06dstAEAwEGnCABwz4xGkU4RAIBOdIoAANfYfdoL/mGJXl4eADBY\nGLLRhk4RAOAau08BADAMoQgAcM9n9f3ohbfeekvZ2dmSpJMnT2rp0qV64IEHVFBQINu2JUl79uxR\nVlaWlixZorfffjvi2B7fhouPAAAASRenT/t6XMnevXu1adMmtba2SpKKi4uVm5ur0tJShcNhHT16\nVLW1taqqqlJZWZlKSkpUWFjY49hICEUAwKA2btw47d69u+vn2tpapaWlSZIyMjJUWVmp6upqpaen\ny7IsjRkzRh0dHWpsbOx2bCSEIgDAPcvFcQXz5s1TXNxn+0LD4XBXh5mUlKSmpiY1NzcrEAh0jek8\n393YSNh9CgBwLZq7T32+z/q5UCikYDCoQCCgUCh0yfnk5ORux0a8dv+XCwCAd6ZNm6Zjx45JksrL\ny5WamqqUlBRVVFTItm3V19fLtm2NHDmy27GR0CkCANyL4hNt1q1bp82bN6ukpEQTJ07UvHnz5Pf7\nlZqaqsWLF8u2bW3ZsqXHsZFY4XA47FXhrf/6/15dGg7L5x/oEoxnt7cPdAlDgi8+fqBLMF5CcJRn\n12548/U+v3b0rLv6rQ636BQBAO7xRBsAAMxCpwgAcG1IPvu0sbFRHi5BAgAwoCJ2ii+++KI++eQT\nzZ49W3l5eRo2bJhaWlpUUFCg22+/PVo1AgAGu6HwfYqlpaXav3+/cnJy9PTTT2vChAlqaGjQypUr\nCUUAQBdTpk8jhmJ8fLyGDx+upKQkjR07VpI0evRoY948AKCfGJILEUPx7rvvVk5OjiZPnqyHH35Y\ns2bN0ptvvqmZM2dGqz4AQAywDJk+veLN+1VVVaqoqNA///lPjRgxQl/5yld011139eri3LzvPW7e\n9x4370cHN+97z8ub9z/9S+Rvn4jk2v83eJbjrnhLRlpaWtfXbgAAYDLuUwQAuDcU1hQBAOgNUzZg\nEooAAPcIRQAALjJl9ykPBAcAwEEoAgDgYPoUAOAea4oAADgIRQAALuKWDAAAOrH7FAAAs9ApAgBc\nsywzeixvQzHyF3AAADCo0CkCANxjow0AABex+xQAgE7sPgUAwCx0igAA15g+BQCgkyGhyPQpAAAO\nOkUAgHvcvA8AwEUWu08BADALnSIAwD1DNtoQigAA17glAwCAToZstIn4Lpqbm6NVBwAAAy5iKN5x\nxx0qKyuLVi0AgBhl+aw+H4NJxFC85ZZb9N5772nZsmWqqqqKVk0AAAyIiGuKw4YN05YtW/TOO+/o\n2Wef1datWzVz5kyNHTtWy5Yti1aNAIDBbihstAmHw5Kk6dOna/fu3WpqatJf/vIX1dXVRaU4AEBs\nGBK7TzMzMy/5OTk5WXfffbenBQEAYpAhu08jhuKiRYuiVQcAIJYNsg0zfWVGtAMA0A8IRQAAHDzR\nBgDg2pDYaAMAQK8MhY02AAD0Bp0iAACdDOkUzXgXAAD0A0IRAAAH06cAANcG27dd9BWhCABwj402\nAABcZBmy0YZQBAC4Z0inaIU7vx8KAIAhzox+FwCAfkAoAgDgIBQBAHAQigAAOAhFAAAchCIAAA5C\nEQAAx5AKxUOHDumnP/1p18/l5eV6/vnnr/i6P/zhD8rLy/OyNGNc7Wfc1NSkH/3oR/rud7+rxYsX\n669//Ws0yox5V/s5nzt3Tjk5OfrOd76j5cuXq6GhIRplGun/fvYwy5B+ok1GRsYVxxQVFamiokJT\np06NQkXmudJn/Ktf/UozZ87U8uXL9cEHHygvL08vvfRSlKozx5U+5xdeeEFf+tKXtGrVKh06dEh7\n9+7Vpk2bolQdEDuGZCg2NjZq5cqVuu+++3Ty5EktWbJEeXl5+vznP69Tp05p+vTpKiwslCSlpKRo\nzpw5veoo8ZnefsbLly9XQkKCJKmjo0PDhg0b4Mpjy9V8zh0dHZKk+vp6BYPBAa48tr3wwgtKTEzU\nqlWr1NbWpnvvvVdHjhzp+ltG7BpS06eSdPbsWeXk5Cg/P19+v7/r/Icffqht27aprKxM5eXlOnPm\njCRp/vz5sgx5pl+0XM1nHAwGlZiYqDNnzujxxx/XY489NoCVx5ar/Vv2+/1atmyZDhw4oLlz5w5U\n2Ua455579MorrygcDuvo0aOaPXs2gWiIIReKb775ptra2mTb9iXnx40bp0AgIL/fr+uuu06tra0D\nVGHsu9rP+MSJE1q+fLkeffRRpaWlDUTJMakvf8v79u3Tc889p0ceeSTa5RolGAxq6tSpqq6u1ksv\nvaSsrKyBLgn9ZMiF4re+9S395Cc/0aZNm3T+/Pmu83SD/edqPuP3339fa9as0ZNPPqk777wzmmXG\nvKv5nJ955hkdPnxYkpSUlHRJZ4m+uf/++/Wb3/xGLS0tuvnmmwe6HPSTIReKkjRp0iTde++9Ki4u\nHuhSjNXbz/jJJ59UW1ubtm3bpuzsbOXk5ESpQjP09nO+77779Lvf/U7Z2dl67LHHtH379ihVaK60\ntDT9/e9/V2Zm5kCXgn7EV0cBAOAYkp0iAADdIRQBAHAQigAAOAhFAAAchCIAAA5CEQAAB6EIAIDj\nfwBbWAYCJ0waWAAAAABJRU5ErkJggg==\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x1164372e8>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"sns.heatmap(df_sorted)"
]
},
{
"cell_type": "code",
"execution_count": 30,
"metadata": {
"collapsed": true
},
"outputs": [],
"source": [
"df_dropped = df_sorted.drop('lv', axis=1)"
]
},
{
"cell_type": "code",
"execution_count": 31,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<div>\n",
"<style>\n",
" .dataframe thead tr:only-child th {\n",
" text-align: right;\n",
" }\n",
"\n",
" .dataframe thead th {\n",
" text-align: left;\n",
" }\n",
"\n",
" .dataframe tbody tr th {\n",
" vertical-align: top;\n",
" }\n",
"</style>\n",
"<table border=\"1\" class=\"dataframe\">\n",
" <thead>\n",
" <tr style=\"text-align: right;\">\n",
" <th></th>\n",
" <th>kin1</th>\n",
" <th>kin2</th>\n",
" <th>kin3</th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>0</th>\n",
" <td>100</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>1</th>\n",
" <td>100</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>8</th>\n",
" <td>5000</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>2</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>3</th>\n",
" <td>34</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>4</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>5</th>\n",
" <td>200</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>6</th>\n",
" <td>45</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" <tr>\n",
" <th>7</th>\n",
" <td>67</td>\n",
" <td>10</td>\n",
" <td>100</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"</div>"
],
"text/plain": [
" kin1 kin2 kin3\n",
"0 100 10 100\n",
"1 100 10 100\n",
"8 5000 10 100\n",
"2 200 10 100\n",
"3 34 10 100\n",
"4 200 10 100\n",
"5 200 10 100\n",
"6 45 10 100\n",
"7 67 10 100"
]
},
"execution_count": 31,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df_dropped"
]
},
{
"cell_type": "code",
"execution_count": 36,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"<matplotlib.collections.LineCollection at 0x1167fab00>"
]
},
"execution_count": 36,
"metadata": {},
"output_type": "execute_result"
},
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAcUAAAFMCAYAAAC6fqeUAAAABHNCSVQICAgIfAhkiAAAAAlwSFlz\nAAALEgAACxIB0t1+/AAAGKhJREFUeJzt3X9s1fW9x/HX95wCxR7qQpFfOkxx6GRDvE1vs1xrGTcQ\nJonrUDZArTKtyyBCO8FUaKGrVEqX2ZlQGP6KCSjBMRjZEhOzAK6rXcodkamd4kWwIN3lIo13bYG2\n9vu9f/BtTUd7aPvp95z20+cjOX/w7ed8eR9O4MX78/l8v1/H8zxPAABAoXgXAADAUEEoAgDgIxQB\nAPARigAA+AhFAAB8hCIAAL6EeBcAAEA0ixYtUiQSkSTddNNNWrJkiZ599lmFw2FlZmbqiSeekOu6\n+vnPf67jx49r9OjRKi0t1c0336xjx45dNTYaQhEAMGS1trbK8zzt2rWr61h2dra2bt2qr3/96/rJ\nT36iv//97/rss8/U1tamN954Q8eOHdOWLVv061//WsXFxVeNnTlzZq+/H6EIABiyPvroI126dEmP\nPvqovvzyS61atUptbW2aNm2aJCkzM1M1NTU6f/687r77bknSnXfeqQ8++EDNzc09jo1bKF6+8D9B\nnh5xFBo1Kt4lICBue3u8S0BAElMmB3buO26eM+D3vlf/p15/lpiYqMcee0w//OEP9emnn+rxxx9X\ncnJy18+TkpJ05swZNTc3d02xSlI4HL7qWOfYaOgUAQDGHMcJ5Lypqam6+eab5TiOUlNTNW7cOH3x\nxRddP29paVFycrIuX76slpaWruOu6yoSiXQ71jk2GnafAgCGrN/+9rfasmWLJOncuXO6dOmSrrvu\nOp0+fVqe56m6ulrp6elKS0tTVVWVJOnYsWO69dZbFYlENGrUqKvGRkOnCAAw5jjB9FiLFy/WunXr\ntGzZMjmOo82bNysUCmnt2rXq6OhQZmamZs+erVmzZumdd97R0qVL5XmeNm/eLEkqKSm5amzUzxHk\nUzJYU7QXa4r2Yk3RXkGuKd6Z+p8Dfu+xU4cGsRIzdIoAAGMhBbOmGGuEIgDAWFAbbWKNUAQAGAsF\ntKYYa4QiAMCYLZ2iHdEOAMAgIBQBAPAxfQoAMOaw+xQAgCvYaAMAgM+WjTaEIgDAWMiSULSj3wUA\nYBAQigAA+KJOn+bk5Kj9X24O7HmeHMfRnj17Ai0MADB8OJb0WFFDce3atSoqKtK2bdsUDodjVRMA\nYJgZERttZs+erezsbB0/flzz58+PVU0AgGHGlo0219x9mpubG4s6AADDmC0X79sxCQwAwCAgFAEA\n8HHxPgDAGLd5AwDANyJ2nwIA0BcjZvcpAADXwu5TAAAsQ6cIADBmy0YbOz4FAACDgE4RAGCM3acA\nAPjYfQoAgI/dpwAAWIZOEQBgjDVFAAB8tqwpMn0KAICPThEAYMyWjTaEIgDAGHe0AQDAMnSKAABj\n7D4FAMBny+5TQhEAYMyWjTasKQIA4KNTBAAYs2X6lE4RAAAfnSIAwBi7TwEA8NkyfUooAgCM2bL7\nlFAEABizpVNkow0AAL6onWJOTo7a29u7HfM8T47jaM+ePYEWBgBArEUNxbVr16qoqEjbtm1TOByO\nVU0AgGFmROw+nT17trKzs3X8+HHNnz8/VjUBAIYZW9YUr7nRJjc3NxZ1AACGMXafAgDgs6VTZPcp\nAAA+QhEAMORduHBBc+bM0SeffKL6+notW7ZMDzzwgIqLi+W6riSpsrJSixcv1tKlS/Xee+9JUq9j\ne0MoAgCMOY4z4Ne1tLe3a+PGjUpMTJQklZWVKT8/X7t375bneTp48KDq6up05MgR7d27VxUVFSop\nKel1bDSEIgDAWMhxBvy6lvLyci1dulQTJ06UJNXV1SkjI0OSlJWVpZqaGh09elSZmZlyHEdTp05V\nR0eHGhsbexwb9XMY/jkAABBYp7h//36NHz9ed999d9exzpvISFJSUpKamprU3NysSCTSNabzeE9j\no2H3KQDAWFCXZOzbt0+O4+gvf/mLPvzwQxUUFKixsbHr5y0tLUpOTlYkElFLS0u34+PGjVMoFLpq\nbDR0igCAIev111/Xa6+9pl27dun2229XeXm5srKyVFtbK0mqqqpSenq60tLSVF1dLdd11dDQINd1\nNX78eM2cOfOqsdHQKQIAjIVieJliQUGBNmzYoIqKCk2fPl0LFixQOBxWenq6lixZItd1tXHjxl7H\nRuN4nucFVfjlC/8T1KkRZ6FRo+JdAgLi/stDAGCPxJTJgZ37iTn5A35v5Z+eH8RKzNApAgCMjYgb\nggMA0Be23OYt0FDMSFsS5OkRR399f3+8SwAwhNjSKbL7FAAAH9OnAABjIR4dBQDAFUyfAgBgGTpF\nAIAxdp8CAOCzJBOZPgUAoBOdIgDAGNOnAAD4gnp0VKwRigAAY1ySAQCAZegUAQDGWFMEAMBnSSYy\nfQoAQCc6RQCAMaZPAQDwjYhLMnJyctTe3t7tmOd5chxHe/bsCbQwAMDwMSI6xbVr16qoqEjbtm1T\nOByOVU0AAMRF1FCcPXu2srOzdfz4cc2fPz9WNQEAhhlLGsVrrynm5ubGog4AAOKOjTYAAGO23OaN\nUAQAGBsRG20AAOgLSzKRUAQAmLOlU+Q2bwAA+AhFAAB8TJ8CAIyNiNu8AQDQF1ySAQCAL2RHJhKK\nAABzdIp98NHZ2iBPjzi6dda/xbsEBMTzvHiXgIDUnz4T7xKGPHafAgDgC7RT/OLsx0GeHnGUMDYp\n3iUgIO6/PEMV6AumTwEA8LHRBgAAH50iAAA+SzKRjTYAAHSiUwQAGOMpGQAAWIZOEQBgjBuCAwDg\ns2T2lFAEAJhjTREAAMvQKQIAjHHxPgAAPksykelTAAA69btTbGtr0+jRo4OoBQAwTNkyfdprp3jo\n0CHNnTtX8+fP15tvvtl1PDc3NyaFAQCGj5Az8NdQ0munuGPHDh04cECu6yovL0+tra1atGgRT+UG\nAFir11AcNWqUrr/+eknS9u3b9cgjj2jKlCnWtMgAgMETVDZ0dHSoqKhIp06dkuM4Kikp0ZgxY/T0\n00/LcRzNmDFDxcXFCoVCqqys1Ntvv62EhAStX79ed9xxh+rr63sc25tef3LjjTeqrKxMFy9eVCQS\nUWVlpZ555hmdPHkykA8OABi+HGfgr2gOHz4sSdqzZ4/y8/P1q1/9SmVlZcrPz9fu3bvleZ4OHjyo\nuro6HTlyRHv37lVFRYVKSkokqcex0fQaips3b9Ztt93Wlf5TpkzRzp07dc899/TnzwkAMAKEHGfA\nr2jmzZunTZs2SZIaGhqUnJysuro6ZWRkSJKysrJUU1Ojo0ePKjMzU47jaOrUqero6FBjY2OPY6N+\njt5+kJCQoPvuu09jx47tOjZhwgQVFhb27U8IAIBBkJCQoIKCAm3atEn33nuvPM/ratiSkpLU1NSk\n5uZmRSKRrvd0Hu9pbNTfK7iPAQAYKYLeb1JeXq61a9fqRz/6kVpbW7uOt7S0KDk5WZFIRC0tLd2O\njxs3rtv6YefYaLh4HwAwZB04cEAvvPCCJGns2LFyHEff/va3VVtbK0mqqqpSenq60tLSVF1dLdd1\n1dDQINd1NX78eM2cOfOqsdE4XoDXWFw8dzqoUyPOEsYmxbsEBMRtb493CQhIYsrkwM792mPPDfi9\nD72yptefXbx4UevWrdPnn3+uL7/8Uo8//rhuueUWbdiwQe3t7Zo+fbpKS0sVDoe1detWVVVVyXVd\nrVu3Tunp6Tp16lSPY3tDKGJACEV7EYr2CjIUX8+tGPB7H3z5yUGsxAxrigAAY7Zcwk4oAgCM8ZBh\nAAAsQygCAOBj+hQAYMyS2VNCEQBgzpaHRRCKAABjlmQioQgAMEen2JeTJ14X5OkBABhU7D4FAMDH\n9CkAwJgls6eEIgDAnC13tCEUAQDGLMlEQhEAYM6W3adstAEAwEenCAAwZkmjSKcIAEAnOkUAgDFb\n1hQJRQCAMUsykVAEAJizpVNkTREAAB+dIgDAmCWNYv9Dsa2tTaNHjw6iFgDAMGX99OmhQ4c0d+5c\nzZ8/X2+++WbX8dzc3JgUBgBArPXaKe7YsUMHDhyQ67rKy8tTa2urFi1aJM/zYlkfAGAYsKRR7D0U\nR40apeuvv16StH37dj3yyCOaMmWKNS0yAGDw2PKUjF6nT2+88UaVlZXp4sWLikQiqqys1DPPPKOT\nJ0/Gsj4AwDDgOAN/DSW9huLmzZt12223dXWGU6ZM0c6dO3XPPffErDgAAGKp1+nThIQE3Xfffd2O\nTZgwQYWFhYEXBQAYXmxZWuM6RQCAMUsykTvaAADQiU4RAGDMCdnRKhKKAABjTJ8CAGAZOkUAgDF2\nnwIA4LMkEwlFAIA5WzpF1hQBAPDRKQIAjFnSKNIpAgDQKdBO8dZZaUGeHvFkyf8KcTWemWqv+tNn\ngju5Ja1ioKHIXy572bKoDmBw2PJvQqCh+OFf3wny9IijhLFJ8S4BAXHb2+NdAoYhSzKRjTYAAHO2\n3PuUjTYAAPgIRQAAfEyfAgCMsaYIAICP3acAAPgsyURCEQBgzpZOkY02AAD4CEUAAHxMnwIAjAU1\ne9re3q7169fr7Nmzamtr04oVK/SNb3xDTz/9tBzH0YwZM1RcXKxQKKTKykq9/fbbSkhI0Pr163XH\nHXeovr6+x7G9oVMEABhzHGfAr2h+//vf62tf+5p2796tl19+WZs2bVJZWZny8/O1e/dueZ6ngwcP\nqq6uTkeOHNHevXtVUVGhkpISSepxbDSEIgDAXMjgFcX3vvc95eXlSbrykIlwOKy6ujplZGRIkrKy\nslRTU6OjR48qMzNTjuNo6tSp6ujoUGNjY49jr/UxAAAwElSnmJSUpEgkoubmZq1evVr5+fnyPK/r\nfUlJSWpqalJzc7MikUi39zU1NfU4Npp+heLly5fV1tbWn7cAAGDkH//4hx5++GFlZ2fr3nvv7bYm\n2NLSouTkZEUiEbW0tHQ7Pm7cuB7HRhM1FE+cOKGVK1dq3bp1qqmp0cKFC7Vw4UIdPnx4oJ8NAIA+\n+/zzz/Xoo4/qqaee0uLFiyVJM2fOVG1trSSpqqpK6enpSktLU3V1tVzXVUNDg1zX1fjx43scG03U\n3afFxcXKy8vT2bNntXr1ar311lsaM2aMcnNzNXfu3MH4vAAACwS1+3THjh365z//qe3bt2v79u2S\npMLCQpWWlqqiokLTp0/XggULFA6HlZ6eriVLlsh1XW3cuFGSVFBQoA0bNnQbG03UUHRdt2uBsra2\nVikpKVfelMCVHACArwR1R5uioiIVFRVddfy111676tiqVau0atWqbsdSU1N7HNubqNOnqampKiws\nlOu62rJliyTpxRdf1IQJE/r8GwAA7Oc4A38NJVFbvtLSUh06dKjbQuWkSZOUk5MTeGEAgGFkqKXb\nAEUNxVAopHnz5nU7lp2dHWhBAADEC4uDAABjTsiOTpGL9wEA8NEpAgCMWbKkSCgCAMzZ8pBhQhEA\nYMySTGRNEQCATnSKAABzlrSKhCIAwBiXZAAAYBk6RQCAMUtmTwlFAMAgsCQVmT4FAMBHpwgAMGZJ\no0goAgDM2bL7lFAEABiz5TZvrCkCAOCjUwQAmLOjUaRTBACgE50iAMCYLWuKhCIAwBihCABAJ0sW\n4whFAIAxWzpFS7IdAABzhCIAAD6mTwEAxmyZPiUUAQDm7MjE/oXi5cuXFQqFNHr06KDqAQAMQ7bc\nEDzqmuKJEye0cuVKrVu3TjU1NVq4cKEWLlyow4cPx6o+AMBw4DgDfw0hUTvF4uJi5eXl6ezZs1q9\nerXeeustjRkzRrm5uZo7d26sagQAICaihqLrusrIyJAk1dbWKiUl5cqbEliKBADYJ+r0aWpqqgoL\nC+W6rrZs2SJJevHFFzVhwoSYFAcAGB4smT2N3imWlpbq0KFDCoW+ys5JkyYpJycn8MIAAMPHiLgk\nIxQKad68ed2OZWdnB1oQAGAYsmT3KYuDAABjtnSK3OYNAAAfnSIAwJwdjSKdIgAAnegUAQDGbFlT\nJBQBAMZsufcpoQgAMEenCADAFbZMn7LRBgAAH50iAMCcHY1isKF4e/pdQZ4ecWTLojqu5nlevEtA\nQOpPn4l3CUMenSIAwJgt/1EONBT/+4N3gzw94smSRXVczW1vj3cJGI4s+TeBThEAYIzdpwAAWIZO\nEQBgzpI1RTpFAIAxx3EG/OqLv/3tb8rJyZEk1dfXa9myZXrggQdUXFws13UlSZWVlVq8eLGWLl2q\n9957L+rY3hCKAIAh7aWXXlJRUZFaW1slSWVlZcrPz9fu3bvleZ4OHjyouro6HTlyRHv37lVFRYVK\nSkp6HRsNoQgAMOcYvK5h2rRp2rp1a9ev6+rqlJGRIUnKyspSTU2Njh49qszMTDmOo6lTp6qjo0ON\njY09jo2GUAQAGAty+nTBggVKSPhqC4zneV3vS0pKUlNTk5qbmxWJRLrGdB7vaWw0hCIAYFgJhb6K\nrpaWFiUnJysSiailpaXb8XHjxvU4Nuq5B79cAMCIE3IG/uqnmTNnqra2VpJUVVWl9PR0paWlqbq6\nWq7rqqGhQa7ravz48T2OjYZLMgAAxmJ58X5BQYE2bNigiooKTZ8+XQsWLFA4HFZ6erqWLFki13W1\ncePGXsdG43gB3v237f8+D+rUiDdL7l6Bq3GbN3slpkwO7Nznqv804PdOypwziJWYYfoUAAAf06cA\nAGMj7t6nFy5cCLIOAADirtdO8dSpU91+XVBQoPLycklSampqsFUBAIYXS+592mso/vjHP1ZiYqIm\nTpwoz/N06tQpbdy4UY7jaOfOnbGsEQAwxNkyfdprKO7bt0/FxcVatmyZ7rrrLuXk5GjXrl2xrA0A\nMFzYHoopKSl6/vnnVV5ervfffz+WNQEAhhnHkunTqBttEhISVFhY2DWFCgCAzbh4HwNjyVQJrsbF\n+/YK8uL9z/8r+tMnopnw7/8xiJWY4TpFAIA5S/6jTCgCAIxZv/sUAIA+IxQBALhiROw+BQBgJCEU\nAQDwMX0KADDHmiIAAD5CEQCAK7gkAwCATuw+BQDALnSKAABjjmNHjxVoKHqeG+TpEUeOE453CQAw\n6OgUAQDm2GgDAMAV7D4FAKATu08BALALnSIAwBjTpwAAdLIkFJk+BQDAR6cIADDHxfsAAFzhsPsU\nAAC70CkCAMxZstGGUAQAGOOSDAAAOlmy0abPn+LChQtB1gEAQNz12imeOnWq268LCgpUXl4uSUpN\nTQ22KgDAsGLL7lPH8zyvpx9897vfVWJioiZOnCjP8/TRRx/pm9/8phzH0c6dO/t08tYv/ndQi8XQ\n4YR4nqKt3Pb2eJeAgCSmTA7s3C2ffTLg9ybddMsgVmKm105x3759Ki4u1rJly3TXXXcpJydHu3bt\nimVtAIDhwvaNNikpKXr++edVXl6u999/P5Y1AQCGGVt2n0bdaJOQkKDCwsKuKVQAAHrkhAb+GkJ6\nXVMcDKwp2os1RXuxpmivINcUL547PeD3Xjdp2iBWYmZoRTQAAHFEKAIA4OOONgAAY7ZstCEUAQDm\nhtiGmYEiFAEAxugUAQDoZEmnaMenAABgEBCKAAD4mD4FABiz5SkZhCIAwBwbbQAAuMKxZKMNoQgA\nMGdJpxjoDcEBABhO7Oh3AQAYBIQiAAA+QhEAAB+hCACAj1AEAMBHKAIA4CMUAQDwEYp9tH//fv3y\nl7/s+nVVVZXeeOONa77vj3/8o9asWRNkaTDU3++2qalJP/3pT/XQQw9pyZIlevfdd2NRJgagv9/t\nxYsXtWLFCj344INavny5zp07F4syMYRwR5sBysrKuuaY0tJSVVdX6/bbb49BRRgs1/puX331VX3n\nO9/R8uXLdfLkSa1Zs0a/+93vYlQdTFzru/3Nb36jb33rW3riiSe0f/9+vfTSSyoqKopRdRgKCMV+\namxs1MqVK3X//fervr5eS5cu1Zo1azR58mSdOXNGs2bNUklJiSQpLS1N8+bN61NHifjr63e7fPly\njR49WpLU0dGhMWPGxLlyXEt/vtuOjg5JUkNDg5KTk+NcOWKNUOyHCxcuaMWKFVq/fr0++eSTruOf\nfvqpXnnlFY0dO1bz5s3T+fPndcMNN2jhwoWqra2NY8Xoq/5+t5J0/vx5PfXUU1q/fn28ykYf9Pe7\nDYfDevjhh/Xxxx/r1VdfjWPliAfWFPvhz3/+s9ra2uS6brfj06ZNUyQSUTgc1g033KDW1tY4VYiB\n6u93e/z4cS1fvlw/+9nPlJGREY+S0UcD+Xu7c+dOvf7661q1alWsy0WcEYr98IMf/EC/+MUvVFRU\npEuXLnUddyy5O/xI1p/v9sSJE8rLy9Nzzz2nOXPmxLJMDEB/vtsXXnhBBw4ckCQlJSUpHA7HrE4M\nDYRiP82YMUPf//73VVZWFu9SMMj6+t0+99xzamtr07PPPqucnBytWLEiRhVioPr63d5///36wx/+\noJycHD355JPavHlzjCrEUMGjowAA8NEpAgDgIxQBAPARigAA+AhFAAB8hCIAAD5CEQAAH6EIAIDv\n/wFbKrnC8SCUNAAAAABJRU5ErkJggg==\n",
"text/plain": [
"<matplotlib.figure.Figure at 0x1167facf8>"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"ax = sns.heatmap(df_dropped, yticklabels=list(df_sorted['lv']))\n",
"ax.hlines([2, 4, 6], *ax.get_xlim())"
]
}
],
"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.6.1"
}
},
"nbformat": 4,
"nbformat_minor": 2
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment