notebooks/pandas/pandas-stack-overflow.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 🐼 Pandas Example - Stack Overflow Survey"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<module 'pandas' from 'c:\\\\users\\\\anish\\\\appdata\\\\local\\\\programs\\\\python\\\\python37\\\\lib\\\\site-packages\\\\pandas\\\\__init__.py'>"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core</td>\n",
       "      <td>ASP.NET;ASP.NET Core</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>36</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I code primarily as a hobby</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albania</td>\n",
       "      <td>Albanian lek</td>\n",
       "      <td>ALL</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>I used to be a developer by profession, but no...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>31.0</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Ruby on Rails</td>\n",
       "      <td>Ruby on Rails</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>14</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>React.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>India</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A lot more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>36.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;React.js;Vue.js</td>\n",
       "      <td>Flask</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>39.0</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>30.0</td>\n",
       "      <td>20</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular.js</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>22.0</td>\n",
       "      <td>14</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>25000.0</td>\n",
       "      <td>32315.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Mathematics or statistics</td>\n",
       "      <td>Flask;jQuery</td>\n",
       "      <td>Flask;jQuery</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>36.0</td>\n",
       "      <td>8</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>23.0</td>\n",
       "      <td>13</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>31000.0</td>\n",
       "      <td>40070.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Django;React.js</td>\n",
       "      <td>Angular;Angular.js;Django;React.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>49.0</td>\n",
       "      <td>42</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>1100.0</td>\n",
       "      <td>14268.0</td>\n",
       "      <td>Spain</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Mathematics or statistics</td>\n",
       "      <td>ASP.NET;jQuery</td>\n",
       "      <td>ASP.NET;jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>I am not primarily a developer, but I write co...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>53.0</td>\n",
       "      <td>14</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>38916.0</td>\n",
       "      <td>Netherlands</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A lot less welcome now than last year</td>\n",
       "      <td>36.0</td>\n",
       "      <td>35</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>27.0</td>\n",
       "      <td>13</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>66000.0</td>\n",
       "      <td>66000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Vue.js</td>\n",
       "      <td>Angular;Vue.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>I am a student who is learning to code</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>France</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>45.0</td>\n",
       "      <td>8</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>108576.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jQuery;React.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>37</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>14</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;Gatsby;React.js;Vue.js</td>\n",
       "      <td>ASP.NET;Gatsby;jQuery;React.js;Vue.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>32.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>1260000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>45.0</td>\n",
       "      <td>19</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>24.0</td>\n",
       "      <td>15</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>83400.0</td>\n",
       "      <td>83400.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Express;React.js</td>\n",
       "      <td>Angular;Angular.js;ASP.NET Core</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>35.0</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>40.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Spain</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>Spring</td>\n",
       "      <td>Angular.js;Spring</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>22</td>\n",
       "      <td>17</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "1                              I am a developer by profession      Yes   NaN   \n",
       "2                              I am a developer by profession       No   NaN   \n",
       "3                                 I code primarily as a hobby      Yes   NaN   \n",
       "4                              I am a developer by profession      Yes  25.0   \n",
       "5           I used to be a developer by profession, but no...      Yes  31.0   \n",
       "6                              I am a developer by profession       No   NaN   \n",
       "7                              I am a developer by profession      Yes   NaN   \n",
       "8                              I am a developer by profession      Yes  36.0   \n",
       "9                              I am a developer by profession       No  30.0   \n",
       "10                             I am a developer by profession      Yes  22.0   \n",
       "11                             I am a developer by profession      Yes  23.0   \n",
       "12                             I am a developer by profession       No  49.0   \n",
       "13          I am not primarily a developer, but I write co...      Yes  53.0   \n",
       "14                             I am a developer by profession      Yes  27.0   \n",
       "15                     I am a student who is learning to code      Yes   NaN   \n",
       "16                             I am a developer by profession      Yes  45.0   \n",
       "17                             I am a developer by profession      Yes  25.0   \n",
       "18                             I am a developer by profession      Yes  32.0   \n",
       "19                             I am a developer by profession       No  24.0   \n",
       "20                             I am a developer by profession      Yes  40.0   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  ConvertedComp             Country  \\\n",
       "Respondent                                                                     \n",
       "1                  13  Monthly        NaN            NaN             Germany   \n",
       "2                  19      NaN        NaN            NaN      United Kingdom   \n",
       "3                  15      NaN        NaN            NaN  Russian Federation   \n",
       "4                  18      NaN        NaN            NaN             Albania   \n",
       "5                  16      NaN        NaN            NaN       United States   \n",
       "6                  14      NaN        NaN            NaN             Germany   \n",
       "7                  18  Monthly        NaN            NaN               India   \n",
       "8                  12   Yearly   116000.0       116000.0       United States   \n",
       "9                  20      NaN        NaN            NaN             Tunisia   \n",
       "10                 14   Yearly    25000.0        32315.0      United Kingdom   \n",
       "11                 13   Yearly    31000.0        40070.0      United Kingdom   \n",
       "12                 42  Monthly     1100.0        14268.0               Spain   \n",
       "13                 14  Monthly     3000.0        38916.0         Netherlands   \n",
       "14                 13   Yearly    66000.0        66000.0       United States   \n",
       "15                 13      NaN        NaN            NaN              France   \n",
       "16                  8  Monthly     7000.0       108576.0      United Kingdom   \n",
       "17                 14   Yearly    79000.0        79000.0       United States   \n",
       "18                 12  Monthly   105000.0      1260000.0       United States   \n",
       "19                 15   Yearly    83400.0        83400.0       United States   \n",
       "20                 18      NaN        NaN            NaN               Spain   \n",
       "\n",
       "                    CurrencyDesc CurrencySymbol  ...  \\\n",
       "Respondent                                       ...   \n",
       "1                  European Euro            EUR  ...   \n",
       "2                 Pound sterling            GBP  ...   \n",
       "3                            NaN            NaN  ...   \n",
       "4                   Albanian lek            ALL  ...   \n",
       "5                            NaN            NaN  ...   \n",
       "6                  European Euro            EUR  ...   \n",
       "7           United States dollar            USD  ...   \n",
       "8           United States dollar            USD  ...   \n",
       "9           United States dollar            USD  ...   \n",
       "10                Pound sterling            GBP  ...   \n",
       "11                Pound sterling            GBP  ...   \n",
       "12                 European Euro            EUR  ...   \n",
       "13                 European Euro            EUR  ...   \n",
       "14          United States dollar            USD  ...   \n",
       "15                           NaN            NaN  ...   \n",
       "16                Pound sterling            GBP  ...   \n",
       "17          United States dollar            USD  ...   \n",
       "18          United States dollar            USD  ...   \n",
       "19          United States dollar            USD  ...   \n",
       "20                 European Euro            EUR  ...   \n",
       "\n",
       "                            SurveyEase           SurveyLength Trans  \\\n",
       "Respondent                                                            \n",
       "1           Neither easy nor difficult  Appropriate in length    No   \n",
       "2                                  NaN                    NaN   NaN   \n",
       "3           Neither easy nor difficult  Appropriate in length   NaN   \n",
       "4                                  NaN                    NaN    No   \n",
       "5                                 Easy              Too short    No   \n",
       "6           Neither easy nor difficult  Appropriate in length   NaN   \n",
       "7                                  NaN                    NaN   NaN   \n",
       "8                                 Easy  Appropriate in length    No   \n",
       "9           Neither easy nor difficult  Appropriate in length    No   \n",
       "10                                Easy  Appropriate in length    No   \n",
       "11                                Easy  Appropriate in length    No   \n",
       "12                                Easy  Appropriate in length    No   \n",
       "13          Neither easy nor difficult               Too long    No   \n",
       "14          Neither easy nor difficult  Appropriate in length    No   \n",
       "15                                Easy  Appropriate in length    No   \n",
       "16                                Easy  Appropriate in length    No   \n",
       "17                                Easy  Appropriate in length    No   \n",
       "18          Neither easy nor difficult  Appropriate in length    No   \n",
       "19                                Easy  Appropriate in length    No   \n",
       "20                                Easy              Too short    No   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "1           Computer science, computer engineering, or sof...   \n",
       "2           Computer science, computer engineering, or sof...   \n",
       "3                                                         NaN   \n",
       "4           Computer science, computer engineering, or sof...   \n",
       "5           Computer science, computer engineering, or sof...   \n",
       "6                                                         NaN   \n",
       "7           Computer science, computer engineering, or sof...   \n",
       "8           Computer science, computer engineering, or sof...   \n",
       "9           Computer science, computer engineering, or sof...   \n",
       "10                                  Mathematics or statistics   \n",
       "11          Computer science, computer engineering, or sof...   \n",
       "12                                  Mathematics or statistics   \n",
       "13                                                        NaN   \n",
       "14          Computer science, computer engineering, or sof...   \n",
       "15          Computer science, computer engineering, or sof...   \n",
       "16          Computer science, computer engineering, or sof...   \n",
       "17          Computer science, computer engineering, or sof...   \n",
       "18          Computer science, computer engineering, or sof...   \n",
       "19          Computer science, computer engineering, or sof...   \n",
       "20          Another engineering discipline (such as civil,...   \n",
       "\n",
       "                         WebframeDesireNextYear  \\\n",
       "Respondent                                        \n",
       "1                                  ASP.NET Core   \n",
       "2                                           NaN   \n",
       "3                                           NaN   \n",
       "4                                           NaN   \n",
       "5                          Django;Ruby on Rails   \n",
       "6                                      React.js   \n",
       "7                                           NaN   \n",
       "8                        Django;React.js;Vue.js   \n",
       "9                                    Angular.js   \n",
       "10                                 Flask;jQuery   \n",
       "11                      Angular;Django;React.js   \n",
       "12                               ASP.NET;jQuery   \n",
       "13                                          NaN   \n",
       "14                               Angular;Vue.js   \n",
       "15                                          NaN   \n",
       "16                                          NaN   \n",
       "17          ASP.NET Core;Gatsby;React.js;Vue.js   \n",
       "18                                          NaN   \n",
       "19                      Django;Express;React.js   \n",
       "20                                       Spring   \n",
       "\n",
       "                               WebframeWorkedWith  \\\n",
       "Respondent                                          \n",
       "1                            ASP.NET;ASP.NET Core   \n",
       "2                                             NaN   \n",
       "3                                             NaN   \n",
       "4                                             NaN   \n",
       "5                                   Ruby on Rails   \n",
       "6                                             NaN   \n",
       "7                                             NaN   \n",
       "8                                           Flask   \n",
       "9                                          jQuery   \n",
       "10                                   Flask;jQuery   \n",
       "11             Angular;Angular.js;Django;React.js   \n",
       "12                                 ASP.NET;jQuery   \n",
       "13                                            NaN   \n",
       "14                                 Angular;Vue.js   \n",
       "15                                            NaN   \n",
       "16                                jQuery;React.js   \n",
       "17          ASP.NET;Gatsby;jQuery;React.js;Vue.js   \n",
       "18                                            NaN   \n",
       "19                Angular;Angular.js;ASP.NET Core   \n",
       "20                              Angular.js;Spring   \n",
       "\n",
       "                                       WelcomeChange WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                   \n",
       "1            Just as welcome now as I felt last year        50.0        36   \n",
       "2           Somewhat more welcome now than last year         NaN         7   \n",
       "3           Somewhat more welcome now than last year         NaN         4   \n",
       "4           Somewhat less welcome now than last year        40.0         7   \n",
       "5            Just as welcome now as I felt last year         NaN        15   \n",
       "6                                                NaN         NaN         6   \n",
       "7              A lot more welcome now than last year         NaN         6   \n",
       "8            Just as welcome now as I felt last year        39.0        17   \n",
       "9            Just as welcome now as I felt last year        50.0         6   \n",
       "10          Somewhat more welcome now than last year        36.0         8   \n",
       "11           Just as welcome now as I felt last year        40.0        10   \n",
       "12           Just as welcome now as I felt last year        40.0         7   \n",
       "13             A lot less welcome now than last year        36.0        35   \n",
       "14           Just as welcome now as I felt last year        40.0         5   \n",
       "15           Just as welcome now as I felt last year         NaN         4   \n",
       "16           Just as welcome now as I felt last year        50.0        37   \n",
       "17           Just as welcome now as I felt last year        40.0         7   \n",
       "18           Just as welcome now as I felt last year        45.0        19   \n",
       "19           Just as welcome now as I felt last year        35.0         9   \n",
       "20           Just as welcome now as I felt last year        50.0        22   \n",
       "\n",
       "           YearsCodePro  \n",
       "Respondent               \n",
       "1                    27  \n",
       "2                     4  \n",
       "3                   NaN  \n",
       "4                     4  \n",
       "5                     8  \n",
       "6                     4  \n",
       "7                     4  \n",
       "8                    13  \n",
       "9                     4  \n",
       "10                    4  \n",
       "11                    2  \n",
       "12                    7  \n",
       "13                   20  \n",
       "14                    1  \n",
       "15                  NaN  \n",
       "16                   23  \n",
       "17                    3  \n",
       "18                   12  \n",
       "19                    3  \n",
       "20                   17  \n",
       "\n",
       "[20 rows x 60 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# loading in the stack overflow survey data\n",
    "survey = pd.read_csv('developer_survey_2020/survey_results_public.csv', index_col='Respondent')\n",
    "survey.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MainBranch                                         I am a developer by profession\n",
       "Hobbyist                                                                      Yes\n",
       "Age                                                                           NaN\n",
       "Age1stCode                                                                     13\n",
       "CompFreq                                                                  Monthly\n",
       "CompTotal                                                                     NaN\n",
       "ConvertedComp                                                                 NaN\n",
       "Country                                                                   Germany\n",
       "CurrencyDesc                                                        European Euro\n",
       "CurrencySymbol                                                                EUR\n",
       "DatabaseDesireNextYear                                       Microsoft SQL Server\n",
       "DatabaseWorkedWith                      Elasticsearch;Microsoft SQL Server;Oracle\n",
       "DevType                         Developer, desktop or enterprise applications;...\n",
       "EdLevel                           Master’s degree (M.A., M.S., M.Eng., MBA, etc.)\n",
       "Employment                      Independent contractor, freelancer, or self-em...\n",
       "Ethnicity                                            White or of European descent\n",
       "Gender                                                                        Man\n",
       "JobFactors                      Languages, frameworks, and other technologies ...\n",
       "JobSat                                                         Slightly satisfied\n",
       "JobSeek                              I am not interested in new job opportunities\n",
       "LanguageDesireNextYear                                     C#;HTML/CSS;JavaScript\n",
       "LanguageWorkedWith                                         C#;HTML/CSS;JavaScript\n",
       "MiscTechDesireNextYear                                          .NET Core;Xamarin\n",
       "MiscTechWorkedWith                                                 .NET;.NET Core\n",
       "NEWCollabToolsDesireNextYear               Microsoft Teams;Microsoft Azure;Trello\n",
       "NEWCollabToolsWorkedWith             Confluence;Jira;Slack;Microsoft Azure;Trello\n",
       "NEWDevOps                                                                      No\n",
       "NEWDevOpsImpt                                                  Somewhat important\n",
       "NEWEdImpt                                                        Fairly important\n",
       "NEWJobHunt                                                                    NaN\n",
       "NEWJobHuntResearch                                                            NaN\n",
       "NEWLearn                                                              Once a year\n",
       "NEWOffTopic                                                              Not sure\n",
       "NEWOnboardGood                                                                NaN\n",
       "NEWOtherComms                                                                  No\n",
       "NEWOvertime                                      Often: 1-2 days per week or more\n",
       "NEWPurchaseResearch             Start a free trial;Ask developers I know/work ...\n",
       "NEWPurpleLink                                                              Amused\n",
       "NEWSOSites                       Stack Overflow (public Q&A for anyone who codes)\n",
       "NEWStuck                        Visit Stack Overflow;Go for a walk or other ph...\n",
       "OpSys                                                                     Windows\n",
       "OrgSize                                                          2 to 9 employees\n",
       "PlatformDesireNextYear             Android;iOS;Kubernetes;Microsoft Azure;Windows\n",
       "PlatformWorkedWith                                                        Windows\n",
       "PurchaseWhat                                                                  NaN\n",
       "Sexuality                                                 Straight / Heterosexual\n",
       "SOAccount                                                                      No\n",
       "SOComm                                                             No, not at all\n",
       "SOPartFreq                                                                    NaN\n",
       "SOVisitFreq                                                Multiple times per day\n",
       "SurveyEase                                             Neither easy nor difficult\n",
       "SurveyLength                                                Appropriate in length\n",
       "Trans                                                                          No\n",
       "UndergradMajor                  Computer science, computer engineering, or sof...\n",
       "WebframeDesireNextYear                                               ASP.NET Core\n",
       "WebframeWorkedWith                                           ASP.NET;ASP.NET Core\n",
       "WelcomeChange                             Just as welcome now as I felt last year\n",
       "WorkWeekHrs                                                                    50\n",
       "YearsCode                                                                      36\n",
       "YearsCodePro                                                                   27\n",
       "Name: 1, dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# loading a particular row using the index\n",
    "survey.loc[1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>QuestionText</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Column</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Age</th>\n",
       "      <td>What is your age (in years)? If you prefer not...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Age1stCode</th>\n",
       "      <td>At what age did you write your first line of c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CompFreq</th>\n",
       "      <td>Is that compensation weekly, monthly, or yearly?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CompTotal</th>\n",
       "      <td>What is your current total compensation (salar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ConvertedComp</th>\n",
       "      <td>Salary converted to annual USD salaries using ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <td>Which web frameworks have you done extensive d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WelcomeChange</th>\n",
       "      <td>Compared to last year, how welcome do you feel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <td>On average, how many hours per week do you wor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YearsCode</th>\n",
       "      <td>Including any education, how many years have y...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>YearsCodePro</th>\n",
       "      <td>NOT including education, how many years have y...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>61 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                         QuestionText\n",
       "Column                                                               \n",
       "Age                 What is your age (in years)? If you prefer not...\n",
       "Age1stCode          At what age did you write your first line of c...\n",
       "CompFreq             Is that compensation weekly, monthly, or yearly?\n",
       "CompTotal           What is your current total compensation (salar...\n",
       "ConvertedComp       Salary converted to annual USD salaries using ...\n",
       "...                                                               ...\n",
       "WebframeWorkedWith  Which web frameworks have you done extensive d...\n",
       "WelcomeChange       Compared to last year, how welcome do you feel...\n",
       "WorkWeekHrs         On average, how many hours per week do you wor...\n",
       "YearsCode           Including any education, how many years have y...\n",
       "YearsCodePro        NOT including education, how many years have y...\n",
       "\n",
       "[61 rows x 1 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# loading survey results \n",
    "schema = pd.read_csv('developer_survey_2020/survey_results_schema.csv', index_col='Column')\n",
    "schema.sort_index(inplace=True)\n",
    "schema"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "QuestionText    What is your age (in years)? If you prefer not...\n",
       "Name: Age, dtype: object"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We can now search for columns directly\n",
    "schema.loc['Age']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "QuestionText    Do you code as a hobby?\n",
       "Name: Hobbyist, dtype: object"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schema.loc['Hobbyist']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Which other frameworks, libraries, and tools have you done extensive development work in over the past year, and which do you want to work in over the next year? (If you both worked with the framework and want to continue to do so, please check both boxes in that row.)'"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schema.loc['MiscTechDesireNextYear', 'QuestionText']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "QuestionText    Salary converted to annual USD salaries using ...\n",
       "Name: ConvertedComp, dtype: object"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "schema.loc['ConvertedComp']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Filtering Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1        False\n",
       "2        False\n",
       "3        False\n",
       "4        False\n",
       "5        False\n",
       "         ...  \n",
       "64858    False\n",
       "64867    False\n",
       "64898    False\n",
       "64925    False\n",
       "65112    False\n",
       "Name: ConvertedComp, Length: 64461, dtype: bool"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "salary_mask = (survey['ConvertedComp'] > 70000)\n",
    "salary_mask"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>36.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>116000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;React.js;Vue.js</td>\n",
       "      <td>Flask</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>39.0</td>\n",
       "      <td>17</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>45.0</td>\n",
       "      <td>8</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>7000.0</td>\n",
       "      <td>108576.0</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jQuery;React.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>37</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>25.0</td>\n",
       "      <td>14</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>79000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;Gatsby;React.js;Vue.js</td>\n",
       "      <td>ASP.NET;Gatsby;jQuery;React.js;Vue.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>32.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>1260000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>45.0</td>\n",
       "      <td>19</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>24.0</td>\n",
       "      <td>15</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>83400.0</td>\n",
       "      <td>83400.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Express;React.js</td>\n",
       "      <td>Angular;Angular.js;ASP.NET Core</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>35.0</td>\n",
       "      <td>9</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65586</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>8</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>225000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mathematics or statistics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>50.0</td>\n",
       "      <td>25</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65589</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>150000.0</td>\n",
       "      <td>150000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>10</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65602</th>\n",
       "      <td>I am not primarily a developer, but I write co...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>140000.0</td>\n",
       "      <td>140000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65604</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>3000.0</td>\n",
       "      <td>150000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>45.0</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65617</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>129718.0</td>\n",
       "      <td>Germany</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>35.0</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13178 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "8                              I am a developer by profession      Yes  36.0   \n",
       "16                             I am a developer by profession      Yes  45.0   \n",
       "17                             I am a developer by profession      Yes  25.0   \n",
       "18                             I am a developer by profession      Yes  32.0   \n",
       "19                             I am a developer by profession       No  24.0   \n",
       "...                                                       ...      ...   ...   \n",
       "65586                          I am a developer by profession      Yes   NaN   \n",
       "65589                          I am a developer by profession      Yes   NaN   \n",
       "65602       I am not primarily a developer, but I write co...      Yes   NaN   \n",
       "65604                          I am a developer by profession       No   NaN   \n",
       "65617                          I am a developer by profession      Yes   NaN   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  ConvertedComp         Country  \\\n",
       "Respondent                                                                 \n",
       "8                  12   Yearly   116000.0       116000.0   United States   \n",
       "16                  8  Monthly     7000.0       108576.0  United Kingdom   \n",
       "17                 14   Yearly    79000.0        79000.0   United States   \n",
       "18                 12  Monthly   105000.0      1260000.0   United States   \n",
       "19                 15   Yearly    83400.0        83400.0   United States   \n",
       "...               ...      ...        ...            ...             ...   \n",
       "65586               8   Yearly   225000.0       225000.0   United States   \n",
       "65589              16   Yearly   150000.0       150000.0   United States   \n",
       "65602              13   Yearly   140000.0       140000.0   United States   \n",
       "65604              13   Weekly     3000.0       150000.0   United States   \n",
       "65617              15   Yearly   120000.0       129718.0         Germany   \n",
       "\n",
       "                    CurrencyDesc CurrencySymbol  ...  \\\n",
       "Respondent                                       ...   \n",
       "8           United States dollar            USD  ...   \n",
       "16                Pound sterling            GBP  ...   \n",
       "17          United States dollar            USD  ...   \n",
       "18          United States dollar            USD  ...   \n",
       "19          United States dollar            USD  ...   \n",
       "...                          ...            ...  ...   \n",
       "65586       United States dollar            USD  ...   \n",
       "65589       United States dollar            USD  ...   \n",
       "65602       United States dollar            USD  ...   \n",
       "65604       United States dollar            USD  ...   \n",
       "65617              European Euro            EUR  ...   \n",
       "\n",
       "                            SurveyEase           SurveyLength Trans  \\\n",
       "Respondent                                                            \n",
       "8                                 Easy  Appropriate in length    No   \n",
       "16                                Easy  Appropriate in length    No   \n",
       "17                                Easy  Appropriate in length    No   \n",
       "18          Neither easy nor difficult  Appropriate in length    No   \n",
       "19                                Easy  Appropriate in length    No   \n",
       "...                                ...                    ...   ...   \n",
       "65586                              NaN                    NaN   NaN   \n",
       "65589                              NaN                    NaN   NaN   \n",
       "65602                              NaN                    NaN   NaN   \n",
       "65604                              NaN                    NaN   NaN   \n",
       "65617                              NaN                    NaN   NaN   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "8           Computer science, computer engineering, or sof...   \n",
       "16          Computer science, computer engineering, or sof...   \n",
       "17          Computer science, computer engineering, or sof...   \n",
       "18          Computer science, computer engineering, or sof...   \n",
       "19          Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "65586                               Mathematics or statistics   \n",
       "65589       Computer science, computer engineering, or sof...   \n",
       "65602       Another engineering discipline (such as civil,...   \n",
       "65604       Computer science, computer engineering, or sof...   \n",
       "65617       Another engineering discipline (such as civil,...   \n",
       "\n",
       "                         WebframeDesireNextYear  \\\n",
       "Respondent                                        \n",
       "8                        Django;React.js;Vue.js   \n",
       "16                                          NaN   \n",
       "17          ASP.NET Core;Gatsby;React.js;Vue.js   \n",
       "18                                          NaN   \n",
       "19                      Django;Express;React.js   \n",
       "...                                         ...   \n",
       "65586                                       NaN   \n",
       "65589                                       NaN   \n",
       "65602                                       NaN   \n",
       "65604                                       NaN   \n",
       "65617                                       NaN   \n",
       "\n",
       "                               WebframeWorkedWith  \\\n",
       "Respondent                                          \n",
       "8                                           Flask   \n",
       "16                                jQuery;React.js   \n",
       "17          ASP.NET;Gatsby;jQuery;React.js;Vue.js   \n",
       "18                                            NaN   \n",
       "19                Angular;Angular.js;ASP.NET Core   \n",
       "...                                           ...   \n",
       "65586                                         NaN   \n",
       "65589                                         NaN   \n",
       "65602                                         NaN   \n",
       "65604                                         NaN   \n",
       "65617                                         NaN   \n",
       "\n",
       "                                      WelcomeChange WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                  \n",
       "8           Just as welcome now as I felt last year        39.0        17   \n",
       "16          Just as welcome now as I felt last year        50.0        37   \n",
       "17          Just as welcome now as I felt last year        40.0         7   \n",
       "18          Just as welcome now as I felt last year        45.0        19   \n",
       "19          Just as welcome now as I felt last year        35.0         9   \n",
       "...                                             ...         ...       ...   \n",
       "65586                                           NaN        50.0        25   \n",
       "65589                                           NaN        45.0        10   \n",
       "65602                                           NaN         NaN        15   \n",
       "65604                                           NaN        45.0         7   \n",
       "65617       Just as welcome now as I felt last year        35.0         9   \n",
       "\n",
       "           YearsCodePro  \n",
       "Respondent               \n",
       "8                    13  \n",
       "16                   23  \n",
       "17                    3  \n",
       "18                   12  \n",
       "19                    3  \n",
       "...                 ...  \n",
       "65586                15  \n",
       "65589                 6  \n",
       "65602                12  \n",
       "65604                 4  \n",
       "65617                 9  \n",
       "\n",
       "[13178 rows x 60 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey.loc[salary_mask]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>ConvertedComp</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>United States</td>\n",
       "      <td>Python;SQL</td>\n",
       "      <td>116000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...</td>\n",
       "      <td>108576.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>United States</td>\n",
       "      <td>C#;HTML/CSS;JavaScript;Python;SQL;VBA</td>\n",
       "      <td>79000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>United States</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;Perl</td>\n",
       "      <td>1260000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>United States</td>\n",
       "      <td>Bash/Shell/PowerShell;C#;HTML/CSS;JavaScript;S...</td>\n",
       "      <td>83400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65586</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>225000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65589</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65602</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>140000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65604</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65617</th>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129718.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>13178 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Country                                 LanguageWorkedWith  \\\n",
       "Respondent                                                                      \n",
       "8            United States                                         Python;SQL   \n",
       "16          United Kingdom  Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...   \n",
       "17           United States              C#;HTML/CSS;JavaScript;Python;SQL;VBA   \n",
       "18           United States                Bash/Shell/PowerShell;HTML/CSS;Perl   \n",
       "19           United States  Bash/Shell/PowerShell;C#;HTML/CSS;JavaScript;S...   \n",
       "...                    ...                                                ...   \n",
       "65586        United States                                                NaN   \n",
       "65589        United States                                                NaN   \n",
       "65602        United States                                                NaN   \n",
       "65604        United States                                                NaN   \n",
       "65617              Germany                                                NaN   \n",
       "\n",
       "            ConvertedComp  \n",
       "Respondent                 \n",
       "8                116000.0  \n",
       "16               108576.0  \n",
       "17                79000.0  \n",
       "18              1260000.0  \n",
       "19                83400.0  \n",
       "...                   ...  \n",
       "65586            225000.0  \n",
       "65589            150000.0  \n",
       "65602            140000.0  \n",
       "65604            150000.0  \n",
       "65617            129718.0  \n",
       "\n",
       "[13178 rows x 3 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# grabbing only a few columns for this data\n",
    "survey.loc[salary_mask, ['Country', 'LanguageWorkedWith', 'ConvertedComp']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "('United States', 'India', 'United Kingdom', 'Germany', 'Canada')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# filtering by countries\n",
    "countries = ('United States', 'India', 'United Kingdom', 'Germany', 'Canada')\n",
    "countries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1         True\n",
       "2         True\n",
       "3        False\n",
       "4        False\n",
       "5         True\n",
       "         ...  \n",
       "64858     True\n",
       "64867    False\n",
       "64898    False\n",
       "64925    False\n",
       "65112    False\n",
       "Name: Country, Length: 64461, dtype: bool"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_filter = survey['Country'].isin(countries)\n",
    "country_filter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>ConvertedComp</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>United States</td>\n",
       "      <td>Python;SQL</td>\n",
       "      <td>116000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...</td>\n",
       "      <td>108576.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>United States</td>\n",
       "      <td>C#;HTML/CSS;JavaScript;Python;SQL;VBA</td>\n",
       "      <td>79000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>United States</td>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;Perl</td>\n",
       "      <td>1260000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>United States</td>\n",
       "      <td>Bash/Shell/PowerShell;C#;HTML/CSS;JavaScript;S...</td>\n",
       "      <td>83400.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65586</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>225000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65589</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65602</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>140000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65604</th>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>150000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65617</th>\n",
       "      <td>Germany</td>\n",
       "      <td>NaN</td>\n",
       "      <td>129718.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9755 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                   Country                                 LanguageWorkedWith  \\\n",
       "Respondent                                                                      \n",
       "8            United States                                         Python;SQL   \n",
       "16          United Kingdom  Bash/Shell/PowerShell;HTML/CSS;Java;JavaScript...   \n",
       "17           United States              C#;HTML/CSS;JavaScript;Python;SQL;VBA   \n",
       "18           United States                Bash/Shell/PowerShell;HTML/CSS;Perl   \n",
       "19           United States  Bash/Shell/PowerShell;C#;HTML/CSS;JavaScript;S...   \n",
       "...                    ...                                                ...   \n",
       "65586        United States                                                NaN   \n",
       "65589        United States                                                NaN   \n",
       "65602        United States                                                NaN   \n",
       "65604        United States                                                NaN   \n",
       "65617              Germany                                                NaN   \n",
       "\n",
       "            ConvertedComp  \n",
       "Respondent                 \n",
       "8                116000.0  \n",
       "16               108576.0  \n",
       "17                79000.0  \n",
       "18              1260000.0  \n",
       "19                83400.0  \n",
       "...                   ...  \n",
       "65586            225000.0  \n",
       "65589            150000.0  \n",
       "65602            140000.0  \n",
       "65604            150000.0  \n",
       "65617            129718.0  \n",
       "\n",
       "[9755 rows x 3 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# respondents who belong to these countries and also have high salaries\n",
    "survey.loc[country_filter & salary_mask, ['Country', 'LanguageWorkedWith', 'ConvertedComp']]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## People That answered they knew Python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1                                   C#;HTML/CSS;JavaScript\n",
       "2                                         JavaScript;Swift\n",
       "3                                 Objective-C;Python;Swift\n",
       "4                                                      NaN\n",
       "5                                        HTML/CSS;Ruby;SQL\n",
       "                               ...                        \n",
       "64858                                                  NaN\n",
       "64867    Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...\n",
       "64898                                                  NaN\n",
       "64925                                             HTML/CSS\n",
       "65112                      C#;HTML/CSS;Java;JavaScript;SQL\n",
       "Name: LanguageWorkedWith, Length: 64461, dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['LanguageWorkedWith']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1        False\n",
       "2        False\n",
       "3         True\n",
       "4        False\n",
       "5        False\n",
       "         ...  \n",
       "64858    False\n",
       "64867     True\n",
       "64898    False\n",
       "64925    False\n",
       "65112    False\n",
       "Name: LanguageWorkedWith, Length: 64461, dtype: bool"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_filter = survey['LanguageWorkedWith'].str.contains('Python', na=False)\n",
    "python_filter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Objective-C;Python;Swift</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Python;SQL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>HTML/CSS;Java;JavaScript;Python;SQL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>C;JavaScript;Python</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Bash/Shell/PowerShell;C;HTML/CSS;Java;Python;SQL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61561</th>\n",
       "      <td>Bash/Shell/PowerShell;HTML/CSS;JavaScript;Perl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62391</th>\n",
       "      <td>C++;HTML/CSS;JavaScript;Python;Ruby;TypeScript</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63077</th>\n",
       "      <td>C++;HTML/CSS;Java;JavaScript;Python;SQL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63640</th>\n",
       "      <td>Bash/Shell/PowerShell;C;C#;C++;HTML/CSS;Java;J...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64867</th>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>25287 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           LanguageWorkedWith\n",
       "Respondent                                                   \n",
       "3                                    Objective-C;Python;Swift\n",
       "8                                                  Python;SQL\n",
       "10                        HTML/CSS;Java;JavaScript;Python;SQL\n",
       "13                                        C;JavaScript;Python\n",
       "15           Bash/Shell/PowerShell;C;HTML/CSS;Java;Python;SQL\n",
       "...                                                       ...\n",
       "61561       Bash/Shell/PowerShell;HTML/CSS;JavaScript;Perl...\n",
       "62391          C++;HTML/CSS;JavaScript;Python;Ruby;TypeScript\n",
       "63077                 C++;HTML/CSS;Java;JavaScript;Python;SQL\n",
       "63640       Bash/Shell/PowerShell;C;C#;C++;HTML/CSS;Java;J...\n",
       "64867       Assembly;Bash/Shell/PowerShell;C;C#;C++;Dart;G...\n",
       "\n",
       "[25287 rows x 1 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey.loc[python_filter, ['LanguageWorkedWith']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['MainBranch', 'Hobbyist', 'Age', 'Age1stCode', 'CompFreq', 'CompTotal',\n",
       "       'SalaryUSD', 'Country', 'CurrencyDesc', 'CurrencySymbol',\n",
       "       'DatabaseDesireNextYear', 'DatabaseWorkedWith', 'DevType', 'EdLevel',\n",
       "       'Employment', 'Ethnicity', 'Gender', 'JobFactors', 'JobSat', 'JobSeek',\n",
       "       'LanguageDesireNextYear', 'LanguageWorkedWith',\n",
       "       'MiscTechDesireNextYear', 'MiscTechWorkedWith',\n",
       "       'NEWCollabToolsDesireNextYear', 'NEWCollabToolsWorkedWith', 'NEWDevOps',\n",
       "       'NEWDevOpsImpt', 'NEWEdImpt', 'NEWJobHunt', 'NEWJobHuntResearch',\n",
       "       'NEWLearn', 'NEWOffTopic', 'NEWOnboardGood', 'NEWOtherComms',\n",
       "       'NEWOvertime', 'NEWPurchaseResearch', 'NEWPurpleLink', 'NEWSOSites',\n",
       "       'NEWStuck', 'OpSys', 'OrgSize', 'PlatformDesireNextYear',\n",
       "       'PlatformWorkedWith', 'PurchaseWhat', 'Sexuality', 'SOAccount',\n",
       "       'SOComm', 'SOPartFreq', 'SOVisitFreq', 'SurveyEase', 'SurveyLength',\n",
       "       'Trans', 'UndergradMajor', 'WebframeDesireNextYear',\n",
       "       'WebframeWorkedWith', 'WelcomeChange', 'WorkWeekHrs', 'YearsCode',\n",
       "       'YearsCodePro'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Renaming the ConvertedComp Column\n",
    "survey.rename(columns={'ConvertedComp': 'SalaryUSD'}, inplace=True)\n",
    "survey.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1       NaN\n",
       "2       NaN\n",
       "3       NaN\n",
       "4       NaN\n",
       "5       NaN\n",
       "         ..\n",
       "64858   NaN\n",
       "64867   NaN\n",
       "64898   NaN\n",
       "64925   NaN\n",
       "65112   NaN\n",
       "Name: SalaryUSD, Length: 64461, dtype: float64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['SalaryUSD']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1        Yes\n",
       "2         No\n",
       "3        Yes\n",
       "4        Yes\n",
       "5        Yes\n",
       "        ... \n",
       "64858    Yes\n",
       "64867    Yes\n",
       "64898    Yes\n",
       "64925    Yes\n",
       "65112    Yes\n",
       "Name: Hobbyist, Length: 64461, dtype: object"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Hobbyist']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "1         True\n",
       "2        False\n",
       "3         True\n",
       "4         True\n",
       "5         True\n",
       "         ...  \n",
       "64858     True\n",
       "64867     True\n",
       "64898     True\n",
       "64925     True\n",
       "65112     True\n",
       "Name: Hobbyist, Length: 64461, dtype: object"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# mapping values to boolean\n",
    "survey['Hobbyist'].map({\n",
    "    'Yes': True,\n",
    "    'No': False\n",
    "})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Germany</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core</td>\n",
       "      <td>ASP.NET;ASP.NET Core</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>50.0</td>\n",
       "      <td>36</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I code primarily as a hobby</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Russian Federation</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>25.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Albania</td>\n",
       "      <td>Albanian lek</td>\n",
       "      <td>ALL</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>I used to be a developer by profession, but no...</td>\n",
       "      <td>True</td>\n",
       "      <td>31.0</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Ruby on Rails</td>\n",
       "      <td>Ruby on Rails</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64858</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>Less than 1 year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64867</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Morocco</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64898</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Viet Nam</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64925</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Poland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angular;Angular.js;React.js</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>65112</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Spain</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;jQuery</td>\n",
       "      <td>Angular;Angular.js;ASP.NET Core;jQuery</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64461 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "1                              I am a developer by profession     True   NaN   \n",
       "2                              I am a developer by profession    False   NaN   \n",
       "3                                 I code primarily as a hobby     True   NaN   \n",
       "4                              I am a developer by profession     True  25.0   \n",
       "5           I used to be a developer by profession, but no...     True  31.0   \n",
       "...                                                       ...      ...   ...   \n",
       "64858                                                     NaN     True   NaN   \n",
       "64867                                                     NaN     True   NaN   \n",
       "64898                                                     NaN     True   NaN   \n",
       "64925                                                     NaN     True   NaN   \n",
       "65112                                                     NaN     True   NaN   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  SalaryUSD             Country  \\\n",
       "Respondent                                                                 \n",
       "1                  13  Monthly        NaN        NaN             Germany   \n",
       "2                  19      NaN        NaN        NaN      United Kingdom   \n",
       "3                  15      NaN        NaN        NaN  Russian Federation   \n",
       "4                  18      NaN        NaN        NaN             Albania   \n",
       "5                  16      NaN        NaN        NaN       United States   \n",
       "...               ...      ...        ...        ...                 ...   \n",
       "64858              16      NaN        NaN        NaN       United States   \n",
       "64867             NaN      NaN        NaN        NaN             Morocco   \n",
       "64898             NaN      NaN        NaN        NaN            Viet Nam   \n",
       "64925             NaN      NaN        NaN        NaN              Poland   \n",
       "65112             NaN      NaN        NaN        NaN               Spain   \n",
       "\n",
       "              CurrencyDesc CurrencySymbol  ...                  SurveyEase  \\\n",
       "Respondent                                 ...                               \n",
       "1            European Euro            EUR  ...  Neither easy nor difficult   \n",
       "2           Pound sterling            GBP  ...                         NaN   \n",
       "3                      NaN            NaN  ...  Neither easy nor difficult   \n",
       "4             Albanian lek            ALL  ...                         NaN   \n",
       "5                      NaN            NaN  ...                        Easy   \n",
       "...                    ...            ...  ...                         ...   \n",
       "64858                  NaN            NaN  ...                         NaN   \n",
       "64867                  NaN            NaN  ...                         NaN   \n",
       "64898                  NaN            NaN  ...                         NaN   \n",
       "64925                  NaN            NaN  ...                         NaN   \n",
       "65112                  NaN            NaN  ...                         NaN   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "1           Appropriate in length    No   \n",
       "2                             NaN   NaN   \n",
       "3           Appropriate in length   NaN   \n",
       "4                             NaN    No   \n",
       "5                       Too short    No   \n",
       "...                           ...   ...   \n",
       "64858                         NaN   NaN   \n",
       "64867                         NaN   NaN   \n",
       "64898                         NaN   NaN   \n",
       "64925                         NaN   NaN   \n",
       "65112                         NaN   NaN   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "1           Computer science, computer engineering, or sof...   \n",
       "2           Computer science, computer engineering, or sof...   \n",
       "3                                                         NaN   \n",
       "4           Computer science, computer engineering, or sof...   \n",
       "5           Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "64858       Computer science, computer engineering, or sof...   \n",
       "64867                                                     NaN   \n",
       "64898                                                     NaN   \n",
       "64925                                                     NaN   \n",
       "65112       Computer science, computer engineering, or sof...   \n",
       "\n",
       "                 WebframeDesireNextYear  \\\n",
       "Respondent                                \n",
       "1                          ASP.NET Core   \n",
       "2                                   NaN   \n",
       "3                                   NaN   \n",
       "4                                   NaN   \n",
       "5                  Django;Ruby on Rails   \n",
       "...                                 ...   \n",
       "64858                               NaN   \n",
       "64867                               NaN   \n",
       "64898                               NaN   \n",
       "64925       Angular;Angular.js;React.js   \n",
       "65112               ASP.NET Core;jQuery   \n",
       "\n",
       "                                WebframeWorkedWith  \\\n",
       "Respondent                                           \n",
       "1                             ASP.NET;ASP.NET Core   \n",
       "2                                              NaN   \n",
       "3                                              NaN   \n",
       "4                                              NaN   \n",
       "5                                    Ruby on Rails   \n",
       "...                                            ...   \n",
       "64858                                          NaN   \n",
       "64867                                          NaN   \n",
       "64898                                          NaN   \n",
       "64925                                          NaN   \n",
       "65112       Angular;Angular.js;ASP.NET Core;jQuery   \n",
       "\n",
       "                                       WelcomeChange WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                   \n",
       "1            Just as welcome now as I felt last year        50.0        36   \n",
       "2           Somewhat more welcome now than last year         NaN         7   \n",
       "3           Somewhat more welcome now than last year         NaN         4   \n",
       "4           Somewhat less welcome now than last year        40.0         7   \n",
       "5            Just as welcome now as I felt last year         NaN        15   \n",
       "...                                              ...         ...       ...   \n",
       "64858                                            NaN         NaN        10   \n",
       "64867                                            NaN         NaN       NaN   \n",
       "64898                                            NaN         NaN       NaN   \n",
       "64925                                            NaN         NaN       NaN   \n",
       "65112                                            NaN         NaN       NaN   \n",
       "\n",
       "                YearsCodePro  \n",
       "Respondent                    \n",
       "1                         27  \n",
       "2                          4  \n",
       "3                        NaN  \n",
       "4                          4  \n",
       "5                          8  \n",
       "...                      ...  \n",
       "64858       Less than 1 year  \n",
       "64867                    NaN  \n",
       "64898                    NaN  \n",
       "64925                    NaN  \n",
       "65112                    NaN  \n",
       "\n",
       "[64461 rows x 60 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Hobbyist'] = survey['Hobbyist'].map({\n",
    "    'Yes': True,\n",
    "    'No': False\n",
    "})\n",
    "survey"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Sorting Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8631</th>\n",
       "      <td>I am a student who is learning to code</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>19</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Spring</td>\n",
       "      <td>Angular.js</td>\n",
       "      <td>Somewhat more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25001</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Younger than 5 years</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>United Arab Emirates dirham</td>\n",
       "      <td>AED</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angular</td>\n",
       "      <td>A lot less welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Less than 1 year</td>\n",
       "      <td>Less than 1 year</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58171</th>\n",
       "      <td>I am a student who is learning to code</td>\n",
       "      <td>True</td>\n",
       "      <td>23.0</td>\n",
       "      <td>18</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>ASP.NET;Spring</td>\n",
       "      <td>Laravel;Spring</td>\n",
       "      <td>A lot more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42668</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Afghan afghani</td>\n",
       "      <td>AFN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51509</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>28.0</td>\n",
       "      <td>19</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>130000.0</td>\n",
       "      <td>20220.0</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Afghan afghani</td>\n",
       "      <td>AFN</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Express</td>\n",
       "      <td>Angular</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60055</th>\n",
       "      <td>NaN</td>\n",
       "      <td>False</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",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61121</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True</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",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61570</th>\n",
       "      <td>NaN</td>\n",
       "      <td>False</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",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61918</th>\n",
       "      <td>NaN</td>\n",
       "      <td>True</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",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62605</th>\n",
       "      <td>NaN</td>\n",
       "      <td>False</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",
       "      <td>NaN</td>\n",
       "      <td>...</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",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64461 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                          \n",
       "8631        I am a student who is learning to code    False   NaN   \n",
       "25001               I am a developer by profession    False   NaN   \n",
       "58171       I am a student who is learning to code     True  23.0   \n",
       "42668               I am a developer by profession     True   NaN   \n",
       "51509               I am a developer by profession    False  28.0   \n",
       "...                                            ...      ...   ...   \n",
       "60055                                          NaN    False   NaN   \n",
       "61121                                          NaN     True   NaN   \n",
       "61570                                          NaN    False   NaN   \n",
       "61918                                          NaN     True   NaN   \n",
       "62605                                          NaN    False   NaN   \n",
       "\n",
       "                      Age1stCode CompFreq  CompTotal  SalaryUSD      Country  \\\n",
       "Respondent                                                                     \n",
       "8631                          19      NaN        NaN        NaN  Afghanistan   \n",
       "25001       Younger than 5 years   Weekly        NaN        NaN  Afghanistan   \n",
       "58171                         18      NaN        NaN        NaN  Afghanistan   \n",
       "42668                        NaN      NaN        NaN        NaN  Afghanistan   \n",
       "51509                         19  Monthly   130000.0    20220.0  Afghanistan   \n",
       "...                          ...      ...        ...        ...          ...   \n",
       "60055                        NaN      NaN        NaN        NaN          NaN   \n",
       "61121                        NaN      NaN        NaN        NaN          NaN   \n",
       "61570                        NaN      NaN        NaN        NaN          NaN   \n",
       "61918                        NaN      NaN        NaN        NaN          NaN   \n",
       "62605                        NaN      NaN        NaN        NaN          NaN   \n",
       "\n",
       "                           CurrencyDesc CurrencySymbol  ...  \\\n",
       "Respondent                                              ...   \n",
       "8631                                NaN            NaN  ...   \n",
       "25001       United Arab Emirates dirham            AED  ...   \n",
       "58171                               NaN            NaN  ...   \n",
       "42668                    Afghan afghani            AFN  ...   \n",
       "51509                    Afghan afghani            AFN  ...   \n",
       "...                                 ...            ...  ...   \n",
       "60055                               NaN            NaN  ...   \n",
       "61121                               NaN            NaN  ...   \n",
       "61570                               NaN            NaN  ...   \n",
       "61918                               NaN            NaN  ...   \n",
       "62605                               NaN            NaN  ...   \n",
       "\n",
       "                            SurveyEase           SurveyLength Trans  \\\n",
       "Respondent                                                            \n",
       "8631        Neither easy nor difficult               Too long    No   \n",
       "25001                             Easy              Too short   Yes   \n",
       "58171                             Easy  Appropriate in length   NaN   \n",
       "42668                              NaN                    NaN   NaN   \n",
       "51509                             Easy  Appropriate in length    No   \n",
       "...                                ...                    ...   ...   \n",
       "60055                              NaN                    NaN   NaN   \n",
       "61121                              NaN                    NaN   NaN   \n",
       "61570                              NaN                    NaN   NaN   \n",
       "61918                              NaN                    NaN   NaN   \n",
       "62605                              NaN                    NaN   NaN   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "8631        Computer science, computer engineering, or sof...   \n",
       "25001                                                     NaN   \n",
       "58171                                                     NaN   \n",
       "42668                                                     NaN   \n",
       "51509       Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "60055                                                     NaN   \n",
       "61121                                                     NaN   \n",
       "61570                                                     NaN   \n",
       "61918                                                     NaN   \n",
       "62605                                                     NaN   \n",
       "\n",
       "           WebframeDesireNextYear WebframeWorkedWith  \\\n",
       "Respondent                                             \n",
       "8631                       Spring         Angular.js   \n",
       "25001                         NaN            Angular   \n",
       "58171              ASP.NET;Spring     Laravel;Spring   \n",
       "42668                         NaN                NaN   \n",
       "51509             Angular;Express            Angular   \n",
       "...                           ...                ...   \n",
       "60055                         NaN                NaN   \n",
       "61121                         NaN                NaN   \n",
       "61570                         NaN                NaN   \n",
       "61918                         NaN                NaN   \n",
       "62605                         NaN                NaN   \n",
       "\n",
       "                                       WelcomeChange WorkWeekHrs  \\\n",
       "Respondent                                                         \n",
       "8631        Somewhat more welcome now than last year         NaN   \n",
       "25001          A lot less welcome now than last year         NaN   \n",
       "58171          A lot more welcome now than last year         NaN   \n",
       "42668                                            NaN         NaN   \n",
       "51509        Just as welcome now as I felt last year        40.0   \n",
       "...                                              ...         ...   \n",
       "60055                                            NaN         NaN   \n",
       "61121                                            NaN         NaN   \n",
       "61570                                            NaN         NaN   \n",
       "61918                                            NaN         NaN   \n",
       "62605                                            NaN         NaN   \n",
       "\n",
       "                   YearsCode      YearsCodePro  \n",
       "Respondent                                      \n",
       "8631                       3               NaN  \n",
       "25001       Less than 1 year  Less than 1 year  \n",
       "58171                      5               NaN  \n",
       "42668                    NaN               NaN  \n",
       "51509                      8                 5  \n",
       "...                      ...               ...  \n",
       "60055                    NaN               NaN  \n",
       "61121                    NaN               NaN  \n",
       "61570                    NaN               NaN  \n",
       "61918                    NaN               NaN  \n",
       "62605                    NaN               NaN  \n",
       "\n",
       "[64461 rows x 60 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# sorting by Counry name\n",
    "survey.sort_values(by='Country', inplace=True)\n",
    "survey"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "8631     Afghanistan\n",
       "25001    Afghanistan\n",
       "58171    Afghanistan\n",
       "42668    Afghanistan\n",
       "51509    Afghanistan\n",
       "37951    Afghanistan\n",
       "28374    Afghanistan\n",
       "7616     Afghanistan\n",
       "43966    Afghanistan\n",
       "62698    Afghanistan\n",
       "51532    Afghanistan\n",
       "36574    Afghanistan\n",
       "43946    Afghanistan\n",
       "65381    Afghanistan\n",
       "38672    Afghanistan\n",
       "35753    Afghanistan\n",
       "43808    Afghanistan\n",
       "37159    Afghanistan\n",
       "44555    Afghanistan\n",
       "35687    Afghanistan\n",
       "37605    Afghanistan\n",
       "44556    Afghanistan\n",
       "23798    Afghanistan\n",
       "42188    Afghanistan\n",
       "65456    Afghanistan\n",
       "44697    Afghanistan\n",
       "60507    Afghanistan\n",
       "898      Afghanistan\n",
       "51900    Afghanistan\n",
       "35179    Afghanistan\n",
       "2932     Afghanistan\n",
       "55019    Afghanistan\n",
       "15422    Afghanistan\n",
       "46844    Afghanistan\n",
       "45481    Afghanistan\n",
       "51862    Afghanistan\n",
       "63848    Afghanistan\n",
       "35656    Afghanistan\n",
       "33878    Afghanistan\n",
       "26575    Afghanistan\n",
       "37601    Afghanistan\n",
       "9839     Afghanistan\n",
       "57269    Afghanistan\n",
       "29893    Afghanistan\n",
       "45409    Afghanistan\n",
       "51683    Afghanistan\n",
       "30608    Afghanistan\n",
       "26775    Afghanistan\n",
       "39217    Afghanistan\n",
       "30568    Afghanistan\n",
       "Name: Country, dtype: object"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Country'].head(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "44891    NaN\n",
       "46810    NaN\n",
       "51650    NaN\n",
       "51958    NaN\n",
       "53347    NaN\n",
       "54379    NaN\n",
       "54654    NaN\n",
       "55156    NaN\n",
       "55162    NaN\n",
       "55314    NaN\n",
       "55417    NaN\n",
       "56415    NaN\n",
       "57583    NaN\n",
       "58915    NaN\n",
       "59962    NaN\n",
       "60055    NaN\n",
       "61121    NaN\n",
       "61570    NaN\n",
       "61918    NaN\n",
       "62605    NaN\n",
       "Name: Country, dtype: object"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Country'].tail(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>SalaryUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8631</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25001</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58171</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42668</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51509</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>20220.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60055</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61121</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61570</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61918</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62605</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64461 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Country  SalaryUSD\n",
       "Respondent                        \n",
       "8631        Afghanistan        NaN\n",
       "25001       Afghanistan        NaN\n",
       "58171       Afghanistan        NaN\n",
       "42668       Afghanistan        NaN\n",
       "51509       Afghanistan    20220.0\n",
       "...                 ...        ...\n",
       "60055               NaN        NaN\n",
       "61121               NaN        NaN\n",
       "61570               NaN        NaN\n",
       "61918               NaN        NaN\n",
       "62605               NaN        NaN\n",
       "\n",
       "[64461 rows x 2 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey[['Country', 'SalaryUSD']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "survey.sort_values(by=['Country', 'SalaryUSD'], ascending=[True, False], inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>SalaryUSD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>65381</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65456</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62788</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38672</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>231192.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28374</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>130000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60055</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61121</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61570</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61918</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62605</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>64461 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Country  SalaryUSD\n",
       "Respondent                        \n",
       "65381       Afghanistan  1000000.0\n",
       "65456       Afghanistan  1000000.0\n",
       "62788       Afghanistan  1000000.0\n",
       "38672       Afghanistan   231192.0\n",
       "28374       Afghanistan   130000.0\n",
       "...                 ...        ...\n",
       "60055               NaN        NaN\n",
       "61121               NaN        NaN\n",
       "61570               NaN        NaN\n",
       "61918               NaN        NaN\n",
       "62605               NaN        NaN\n",
       "\n",
       "[64461 rows x 2 columns]"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey[['Country', 'SalaryUSD']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "54263    2000000.0\n",
       "5725     2000000.0\n",
       "43430    2000000.0\n",
       "59279    2000000.0\n",
       "46711    2000000.0\n",
       "1793     2000000.0\n",
       "3072     2000000.0\n",
       "3045     2000000.0\n",
       "1413     2000000.0\n",
       "3261     2000000.0\n",
       "Name: SalaryUSD, dtype: float64"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 10 largest salaries\n",
    "survey['SalaryUSD'].nlargest(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>54263</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>29.0</td>\n",
       "      <td>10</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>7.000000e+04</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>Canada</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>React.js;Vue.js</td>\n",
       "      <td>Express;Flask;jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>36.0</td>\n",
       "      <td>14</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5725</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>26.0</td>\n",
       "      <td>14</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>1.800000e+05</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>Canada</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too short</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Gatsby</td>\n",
       "      <td>Spring</td>\n",
       "      <td>Not applicable - I did not use Stack Overflow ...</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43430</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>33.0</td>\n",
       "      <td>17</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>1.710000e+05</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>Italy</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>13</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59279</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>3.000000e+05</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>Nepal</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;Drupal;Flask;Gatsby;Laravel</td>\n",
       "      <td>Angular;Angular.js;ASP.NET;ASP.NET Core;Expres...</td>\n",
       "      <td>A lot more welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>20</td>\n",
       "      <td>14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46711</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Younger than 5 years</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>1.000000e+56</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>Nomadic</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angular;Angular.js;ASP.NET;ASP.NET Core;Django...</td>\n",
       "      <td>Angular;Angular.js;ASP.NET;ASP.NET Core;Django...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>168.0</td>\n",
       "      <td>More than 50 years</td>\n",
       "      <td>More than 50 years</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>27.0</td>\n",
       "      <td>16</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>1.200000e+05</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3072</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>32.0</td>\n",
       "      <td>22</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>1.020000e+05</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;Flask</td>\n",
       "      <td>ASP.NET Core</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3045</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>35.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>1.000000e+05</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Angular.js;ASP.NET;ASP.NET Core;Django...</td>\n",
       "      <td>Angular;Angular.js;ASP.NET;ASP.NET Core;Django...</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>42.0</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>25.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>4.100000e+04</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>jQuery;Laravel</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>37.0</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3261</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>34.0</td>\n",
       "      <td>23</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>1.150000e+05</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;jQuery;Spring</td>\n",
       "      <td>Spring</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                  \n",
       "54263       I am a developer by profession     True  29.0   \n",
       "5725        I am a developer by profession    False  26.0   \n",
       "43430       I am a developer by profession     True  33.0   \n",
       "59279       I am a developer by profession     True   NaN   \n",
       "46711       I am a developer by profession     True   NaN   \n",
       "1793        I am a developer by profession     True  27.0   \n",
       "3072        I am a developer by profession     True  32.0   \n",
       "3045        I am a developer by profession     True  35.0   \n",
       "1413        I am a developer by profession     True  25.0   \n",
       "3261        I am a developer by profession     True  34.0   \n",
       "\n",
       "                      Age1stCode CompFreq     CompTotal  SalaryUSD  \\\n",
       "Respondent                                                           \n",
       "54263                         10   Weekly  7.000000e+04  2000000.0   \n",
       "5725                          14  Monthly  1.800000e+05  2000000.0   \n",
       "43430                         17  Monthly  1.710000e+05  2000000.0   \n",
       "59279                         12  Monthly  3.000000e+05  2000000.0   \n",
       "46711       Younger than 5 years   Yearly  1.000000e+56  2000000.0   \n",
       "1793                          16   Weekly  1.200000e+05  2000000.0   \n",
       "3072                          22   Weekly  1.020000e+05  2000000.0   \n",
       "3045                          12   Weekly  1.000000e+05  2000000.0   \n",
       "1413                          12   Weekly  4.100000e+04  2000000.0   \n",
       "3261                          23   Weekly  1.150000e+05  2000000.0   \n",
       "\n",
       "                  Country          CurrencyDesc CurrencySymbol  ...  \\\n",
       "Respondent                                                      ...   \n",
       "54263              Canada  United States dollar            USD  ...   \n",
       "5725               Canada  United States dollar            USD  ...   \n",
       "43430               Italy  United States dollar            USD  ...   \n",
       "59279               Nepal  United States dollar            USD  ...   \n",
       "46711             Nomadic  United States dollar            USD  ...   \n",
       "1793        United States  United States dollar            USD  ...   \n",
       "3072        United States  United States dollar            USD  ...   \n",
       "3045        United States  United States dollar            USD  ...   \n",
       "1413        United States  United States dollar            USD  ...   \n",
       "3261        United States  United States dollar            USD  ...   \n",
       "\n",
       "                            SurveyEase           SurveyLength Trans  \\\n",
       "Respondent                                                            \n",
       "54263       Neither easy nor difficult               Too long    No   \n",
       "5725                              Easy              Too short    No   \n",
       "43430                             Easy  Appropriate in length    No   \n",
       "59279       Neither easy nor difficult               Too long   NaN   \n",
       "46711                              NaN                    NaN   NaN   \n",
       "1793                              Easy  Appropriate in length    No   \n",
       "3072                              Easy  Appropriate in length    No   \n",
       "3045        Neither easy nor difficult               Too long    No   \n",
       "1413        Neither easy nor difficult  Appropriate in length    No   \n",
       "3261                              Easy  Appropriate in length    No   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "54263       Computer science, computer engineering, or sof...   \n",
       "5725        Computer science, computer engineering, or sof...   \n",
       "43430       Computer science, computer engineering, or sof...   \n",
       "59279       Computer science, computer engineering, or sof...   \n",
       "46711                                                     NaN   \n",
       "1793        Computer science, computer engineering, or sof...   \n",
       "3072        Computer science, computer engineering, or sof...   \n",
       "3045        Computer science, computer engineering, or sof...   \n",
       "1413        Computer science, computer engineering, or sof...   \n",
       "3261        Computer science, computer engineering, or sof...   \n",
       "\n",
       "                                       WebframeDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "54263                                         React.js;Vue.js   \n",
       "5725                                                   Gatsby   \n",
       "43430                                                     NaN   \n",
       "59279                      Django;Drupal;Flask;Gatsby;Laravel   \n",
       "46711       Angular;Angular.js;ASP.NET;ASP.NET Core;Django...   \n",
       "1793                                                      NaN   \n",
       "3072                                       ASP.NET Core;Flask   \n",
       "3045        Angular;Angular.js;ASP.NET;ASP.NET Core;Django...   \n",
       "1413                                           jQuery;Laravel   \n",
       "3261                                     Django;jQuery;Spring   \n",
       "\n",
       "                                           WebframeWorkedWith  \\\n",
       "Respondent                                                      \n",
       "54263                                    Express;Flask;jQuery   \n",
       "5725                                                   Spring   \n",
       "43430                                                     NaN   \n",
       "59279       Angular;Angular.js;ASP.NET;ASP.NET Core;Expres...   \n",
       "46711       Angular;Angular.js;ASP.NET;ASP.NET Core;Django...   \n",
       "1793                                                      NaN   \n",
       "3072                                             ASP.NET Core   \n",
       "3045        Angular;Angular.js;ASP.NET;ASP.NET Core;Django...   \n",
       "1413                                                   jQuery   \n",
       "3261                                                   Spring   \n",
       "\n",
       "                                                WelcomeChange WorkWeekHrs  \\\n",
       "Respondent                                                                  \n",
       "54263                 Just as welcome now as I felt last year        36.0   \n",
       "5725        Not applicable - I did not use Stack Overflow ...        40.0   \n",
       "43430                 Just as welcome now as I felt last year        40.0   \n",
       "59279                   A lot more welcome now than last year        40.0   \n",
       "46711                                                     NaN       168.0   \n",
       "1793                  Just as welcome now as I felt last year        40.0   \n",
       "3072                 Somewhat less welcome now than last year        40.0   \n",
       "3045                  Just as welcome now as I felt last year        42.0   \n",
       "1413                  Just as welcome now as I felt last year        37.0   \n",
       "3261                  Just as welcome now as I felt last year        60.0   \n",
       "\n",
       "                     YearsCode        YearsCodePro  \n",
       "Respondent                                          \n",
       "54263                       14                   5  \n",
       "5725                        10                   4  \n",
       "43430                       13                   2  \n",
       "59279                       20                  14  \n",
       "46711       More than 50 years  More than 50 years  \n",
       "1793                        12                 NaN  \n",
       "3072                        10                   7  \n",
       "3045                        23                   5  \n",
       "1413                        13                   3  \n",
       "3261                        11                   9  \n",
       "\n",
       "[10 rows x 60 columns]"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey.nlargest(10, 'SalaryUSD')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>35295</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>13</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Afghan afghani</td>\n",
       "      <td>AFN</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>A lot less welcome now than last year</td>\n",
       "      <td>100.0</td>\n",
       "      <td>35</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47357</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Albania</td>\n",
       "      <td>Bhutanese ngultrum</td>\n",
       "      <td>BTN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Drupal</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>168.0</td>\n",
       "      <td>2</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27135</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Australian dollar</td>\n",
       "      <td>AUD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>A humanities discipline (such as literature, h...</td>\n",
       "      <td>Angular.js;Django;jQuery;React.js;Vue.js</td>\n",
       "      <td>Django;jQuery;React.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>80.0</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6054</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>38.0</td>\n",
       "      <td>15</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Australian dollar</td>\n",
       "      <td>AUD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Laravel</td>\n",
       "      <td>A lot less welcome now than last year</td>\n",
       "      <td>30.0</td>\n",
       "      <td>22</td>\n",
       "      <td>20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60292</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Austria</td>\n",
       "      <td>European Euro</td>\n",
       "      <td>EUR</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38813</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>Azerbaijan manat</td>\n",
       "      <td>AZN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A lot more welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8470</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>30.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Bangladesh</td>\n",
       "      <td>Bangladeshi taka</td>\n",
       "      <td>BDT</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Express;Gatsby;Laravel;React.js;Vue.js</td>\n",
       "      <td>Django;Express;Gatsby;Laravel;React.js;Vue.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41006</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>22.0</td>\n",
       "      <td>17</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>Pound sterling</td>\n",
       "      <td>GBP</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>A business discipline (such as accounting, fin...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Angular;ASP.NET Core;React.js;Spring</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>30.0</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15493</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>44.0</td>\n",
       "      <td>17</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Brazilian real</td>\n",
       "      <td>BRL</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>A business discipline (such as accounting, fin...</td>\n",
       "      <td>React.js</td>\n",
       "      <td>React.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>60.0</td>\n",
       "      <td>10</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57369</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>44.0</td>\n",
       "      <td>18</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>Brazilian real</td>\n",
       "      <td>BRL</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>A business discipline (such as accounting, fin...</td>\n",
       "      <td>React.js</td>\n",
       "      <td>React.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>60.0</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                MainBranch Hobbyist   Age Age1stCode CompFreq  \\\n",
       "Respondent                                                                      \n",
       "35295       I am a developer by profession     True   NaN         13  Monthly   \n",
       "47357       I am a developer by profession     True   NaN          5   Weekly   \n",
       "27135       I am a developer by profession    False   NaN         16   Yearly   \n",
       "6054        I am a developer by profession     True  38.0         15   Yearly   \n",
       "60292       I am a developer by profession     True   NaN         12   Yearly   \n",
       "38813       I am a developer by profession    False   NaN         18  Monthly   \n",
       "8470        I am a developer by profession     True   NaN          5  Monthly   \n",
       "41006       I am a developer by profession     True  22.0         17   Yearly   \n",
       "15493       I am a developer by profession    False  44.0         17  Monthly   \n",
       "57369       I am a developer by profession    False  44.0         18  Monthly   \n",
       "\n",
       "            CompTotal  SalaryUSD      Country        CurrencyDesc  \\\n",
       "Respondent                                                          \n",
       "35295             2.0        0.0  Afghanistan      Afghan afghani   \n",
       "47357             1.0        0.0      Albania  Bhutanese ngultrum   \n",
       "27135             0.0        0.0    Australia   Australian dollar   \n",
       "6054              0.0        0.0    Australia   Australian dollar   \n",
       "60292             0.0        0.0      Austria       European Euro   \n",
       "38813             0.0        0.0   Azerbaijan    Azerbaijan manat   \n",
       "8470             30.0        0.0   Bangladesh    Bangladeshi taka   \n",
       "41006             0.0        0.0      Belgium      Pound sterling   \n",
       "15493             0.0        0.0       Brazil      Brazilian real   \n",
       "57369             0.0        0.0       Brazil      Brazilian real   \n",
       "\n",
       "           CurrencySymbol  ...                  SurveyEase  \\\n",
       "Respondent                 ...                               \n",
       "35295                 AFN  ...  Neither easy nor difficult   \n",
       "47357                 BTN  ...                         NaN   \n",
       "27135                 AUD  ...  Neither easy nor difficult   \n",
       "6054                  AUD  ...                        Easy   \n",
       "60292                 EUR  ...                         NaN   \n",
       "38813                 AZN  ...                         NaN   \n",
       "8470                  BDT  ...  Neither easy nor difficult   \n",
       "41006                 GBP  ...                        Easy   \n",
       "15493                 BRL  ...                        Easy   \n",
       "57369                 BRL  ...                        Easy   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "35295       Appropriate in length   NaN   \n",
       "47357                         NaN   NaN   \n",
       "27135       Appropriate in length    No   \n",
       "6054                     Too long    No   \n",
       "60292                         NaN   NaN   \n",
       "38813                         NaN   NaN   \n",
       "8470        Appropriate in length    No   \n",
       "41006       Appropriate in length    No   \n",
       "15493       Appropriate in length    No   \n",
       "57369                    Too long    No   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "35295       Another engineering discipline (such as civil,...   \n",
       "47357                                                     NaN   \n",
       "27135       A humanities discipline (such as literature, h...   \n",
       "6054                                                      NaN   \n",
       "60292       Computer science, computer engineering, or sof...   \n",
       "38813       Computer science, computer engineering, or sof...   \n",
       "8470        Computer science, computer engineering, or sof...   \n",
       "41006       A business discipline (such as accounting, fin...   \n",
       "15493       A business discipline (such as accounting, fin...   \n",
       "57369       A business discipline (such as accounting, fin...   \n",
       "\n",
       "                              WebframeDesireNextYear  \\\n",
       "Respondent                                             \n",
       "35295                                            NaN   \n",
       "47357                                         Drupal   \n",
       "27135       Angular.js;Django;jQuery;React.js;Vue.js   \n",
       "6054                                             NaN   \n",
       "60292                                            NaN   \n",
       "38813                                            NaN   \n",
       "8470          Express;Gatsby;Laravel;React.js;Vue.js   \n",
       "41006                                            NaN   \n",
       "15493                                       React.js   \n",
       "57369                                       React.js   \n",
       "\n",
       "                                       WebframeWorkedWith  \\\n",
       "Respondent                                                  \n",
       "35295                                              jQuery   \n",
       "47357                                                 NaN   \n",
       "27135                              Django;jQuery;React.js   \n",
       "6054                                              Laravel   \n",
       "60292                                                 NaN   \n",
       "38813                                                 NaN   \n",
       "8470        Django;Express;Gatsby;Laravel;React.js;Vue.js   \n",
       "41006                Angular;ASP.NET Core;React.js;Spring   \n",
       "15493                                            React.js   \n",
       "57369                                            React.js   \n",
       "\n",
       "                                       WelcomeChange WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                   \n",
       "35295          A lot less welcome now than last year       100.0        35   \n",
       "47357       Somewhat less welcome now than last year       168.0         2   \n",
       "27135        Just as welcome now as I felt last year        80.0        15   \n",
       "6054           A lot less welcome now than last year        30.0        22   \n",
       "60292                                            NaN         NaN        18   \n",
       "38813          A lot more welcome now than last year         NaN         4   \n",
       "8470                                             NaN         NaN         4   \n",
       "41006        Just as welcome now as I felt last year        30.0         4   \n",
       "15493        Just as welcome now as I felt last year        60.0        10   \n",
       "57369        Just as welcome now as I felt last year        60.0        10   \n",
       "\n",
       "           YearsCodePro  \n",
       "Respondent               \n",
       "35295                27  \n",
       "47357                11  \n",
       "27135                15  \n",
       "6054                 20  \n",
       "60292                10  \n",
       "38813                 3  \n",
       "8470                  2  \n",
       "41006                 3  \n",
       "15493                 4  \n",
       "57369                 5  \n",
       "\n",
       "[10 rows x 60 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey.nsmallest(10, 'SalaryUSD')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Grouping and Data Aggregation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "65381    1000000.0\n",
       "65456    1000000.0\n",
       "62788    1000000.0\n",
       "38672     231192.0\n",
       "28374     130000.0\n",
       "63848      23328.0\n",
       "9839       23328.0\n",
       "51862      20950.0\n",
       "51509      20220.0\n",
       "44484      18660.0\n",
       "15422      18000.0\n",
       "2932       16335.0\n",
       "26540      13992.0\n",
       "57269      10884.0\n",
       "26775       8016.0\n",
       "30568       5448.0\n",
       "30522       4668.0\n",
       "28811       4509.0\n",
       "34969       4356.0\n",
       "26857       2328.0\n",
       "33878       1860.0\n",
       "35753        780.0\n",
       "18049        109.0\n",
       "35295          0.0\n",
       "8631           NaN\n",
       "25001          NaN\n",
       "58171          NaN\n",
       "42668          NaN\n",
       "37951          NaN\n",
       "7616           NaN\n",
       "Name: SalaryUSD, dtype: float64"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['SalaryUSD'].head(30)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "54049.0"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# computing the median salary\n",
    "survey['SalaryUSD'].median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Hobbyist           1.0\n",
       "Age               29.0\n",
       "CompTotal      63000.0\n",
       "SalaryUSD      54049.0\n",
       "WorkWeekHrs       40.0\n",
       "dtype: float64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# median of all columns\n",
    "survey.median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>25.0</td>\n",
       "      <td>15</td>\n",
       "      <td>Yearly</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>React.js</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       MainBranch Hobbyist   Age Age1stCode CompFreq  \\\n",
       "0  I am a developer by profession     True  25.0         15   Yearly   \n",
       "\n",
       "   CompTotal  SalaryUSD        Country          CurrencyDesc CurrencySymbol  \\\n",
       "0   100000.0   120000.0  United States  United States dollar            USD   \n",
       "\n",
       "   ... SurveyEase           SurveyLength Trans  \\\n",
       "0  ...       Easy  Appropriate in length    No   \n",
       "\n",
       "                                      UndergradMajor WebframeDesireNextYear  \\\n",
       "0  Computer science, computer engineering, or sof...               React.js   \n",
       "\n",
       "  WebframeWorkedWith                            WelcomeChange WorkWeekHrs  \\\n",
       "0             jQuery  Just as welcome now as I felt last year        40.0   \n",
       "\n",
       "  YearsCode YearsCodePro  \n",
       "0        10            3  \n",
       "\n",
       "[1 rows x 60 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey.mode()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Age</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>45446.000000</td>\n",
       "      <td>3.482600e+04</td>\n",
       "      <td>3.475600e+04</td>\n",
       "      <td>41151.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>30.834111</td>\n",
       "      <td>3.190464e+242</td>\n",
       "      <td>1.037561e+05</td>\n",
       "      <td>40.782174</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>9.585392</td>\n",
       "      <td>inf</td>\n",
       "      <td>2.268853e+05</td>\n",
       "      <td>17.816383</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>24.000000</td>\n",
       "      <td>2.000000e+04</td>\n",
       "      <td>2.464800e+04</td>\n",
       "      <td>40.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>29.000000</td>\n",
       "      <td>6.300000e+04</td>\n",
       "      <td>5.404900e+04</td>\n",
       "      <td>40.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>35.000000</td>\n",
       "      <td>1.250000e+05</td>\n",
       "      <td>9.500000e+04</td>\n",
       "      <td>44.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>279.000000</td>\n",
       "      <td>1.111111e+247</td>\n",
       "      <td>2.000000e+06</td>\n",
       "      <td>475.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Age      CompTotal     SalaryUSD   WorkWeekHrs\n",
       "count  45446.000000   3.482600e+04  3.475600e+04  41151.000000\n",
       "mean      30.834111  3.190464e+242  1.037561e+05     40.782174\n",
       "std        9.585392            inf  2.268853e+05     17.816383\n",
       "min        1.000000   0.000000e+00  0.000000e+00      1.000000\n",
       "25%       24.000000   2.000000e+04  2.464800e+04     40.000000\n",
       "50%       29.000000   6.300000e+04  5.404900e+04     40.000000\n",
       "75%       35.000000   1.250000e+05  9.500000e+04     44.000000\n",
       "max      279.000000  1.111111e+247  2.000000e+06    475.000000"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Broad overview of data\n",
    "survey.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "34756"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# number of rows with no NaN data\n",
    "survey['SalaryUSD'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MainBranch                      64162\n",
       "Hobbyist                        64416\n",
       "Age                             45446\n",
       "Age1stCode                      57900\n",
       "CompFreq                        40069\n",
       "CompTotal                       34826\n",
       "SalaryUSD                       34756\n",
       "Country                         64072\n",
       "CurrencyDesc                    45472\n",
       "CurrencySymbol                  45472\n",
       "DatabaseDesireNextYear          44070\n",
       "DatabaseWorkedWith              49537\n",
       "DevType                         49370\n",
       "EdLevel                         57431\n",
       "Employment                      63854\n",
       "Ethnicity                       45948\n",
       "Gender                          50557\n",
       "JobFactors                      49349\n",
       "JobSat                          45194\n",
       "JobSeek                         51727\n",
       "LanguageDesireNextYear          54113\n",
       "LanguageWorkedWith              57378\n",
       "MiscTechDesireNextYear          42379\n",
       "MiscTechWorkedWith              40314\n",
       "NEWCollabToolsDesireNextYear    47287\n",
       "NEWCollabToolsWorkedWith        52883\n",
       "NEWDevOps                       42686\n",
       "NEWDevOpsImpt                   41732\n",
       "NEWEdImpt                       48465\n",
       "NEWJobHunt                      42286\n",
       "NEWJobHuntResearch              41022\n",
       "NEWLearn                        56156\n",
       "NEWOffTopic                     50804\n",
       "NEWOnboardGood                  42623\n",
       "NEWOtherComms                   57205\n",
       "NEWOvertime                     43231\n",
       "NEWPurchaseResearch             37321\n",
       "NEWPurpleLink                   54803\n",
       "NEWSOSites                      58275\n",
       "NEWStuck                        54983\n",
       "OpSys                           56228\n",
       "OrgSize                         44334\n",
       "PlatformDesireNextYear          50605\n",
       "PlatformWorkedWith              53843\n",
       "PurchaseWhat                    39364\n",
       "Sexuality                       43992\n",
       "SOAccount                       56805\n",
       "SOComm                          56476\n",
       "SOPartFreq                      46792\n",
       "SOVisitFreq                     56970\n",
       "SurveyEase                      51802\n",
       "SurveyLength                    51701\n",
       "Trans                           49345\n",
       "UndergradMajor                  50995\n",
       "WebframeDesireNextYear          40024\n",
       "WebframeWorkedWith              42279\n",
       "WelcomeChange                   52683\n",
       "WorkWeekHrs                     41151\n",
       "YearsCode                       57684\n",
       "YearsCodePro                    46349\n",
       "dtype: int64"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(64461, 60)"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "65381    False\n",
       "65456     True\n",
       "62788     True\n",
       "38672    False\n",
       "28374     True\n",
       "         ...  \n",
       "60055    False\n",
       "61121     True\n",
       "61570    False\n",
       "61918     True\n",
       "62605    False\n",
       "Name: Hobbyist, Length: 64461, dtype: object"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Hobbyist']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "True     50388\n",
       "False    14028\n",
       "Name: Hobbyist, dtype: int64"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Hobbyist'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Man                                                            46013\n",
       "Woman                                                           3844\n",
       "Non-binary, genderqueer, or gender non-conforming                385\n",
       "Man;Non-binary, genderqueer, or gender non-conforming            121\n",
       "Woman;Non-binary, genderqueer, or gender non-conforming           92\n",
       "Woman;Man                                                         76\n",
       "Woman;Man;Non-binary, genderqueer, or gender non-conforming       26\n",
       "Name: Gender, dtype: int64"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Gender'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Computer science, computer engineering, or software engineering                   31582\n",
       "Another engineering discipline (such as civil, electrical, mechanical, etc.)       4754\n",
       "Information systems, information technology, or system administration              4071\n",
       "A natural science (such as biology, chemistry, physics, etc.)                      2205\n",
       "Mathematics or statistics                                                          1849\n",
       "Web development or web design                                                      1789\n",
       "A business discipline (such as accounting, finance, marketing, etc.)               1375\n",
       "A humanities discipline (such as literature, history, philosophy, etc.)            1007\n",
       "A social science (such as anthropology, psychology, political science, etc.)        933\n",
       "Fine arts or performing arts (such as graphic design, music, studio art, etc.)      725\n",
       "I never declared a major                                                            453\n",
       "A health science (such as nursing, pharmacy, radiology, etc.)                       252\n",
       "Name: UndergradMajor, dtype: int64"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['UndergradMajor'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Computer science, computer engineering, or software engineering                   0.619316\n",
       "Another engineering discipline (such as civil, electrical, mechanical, etc.)      0.093225\n",
       "Information systems, information technology, or system administration             0.079831\n",
       "A natural science (such as biology, chemistry, physics, etc.)                     0.043240\n",
       "Mathematics or statistics                                                         0.036258\n",
       "Web development or web design                                                     0.035082\n",
       "A business discipline (such as accounting, finance, marketing, etc.)              0.026963\n",
       "A humanities discipline (such as literature, history, philosophy, etc.)           0.019747\n",
       "A social science (such as anthropology, psychology, political science, etc.)      0.018296\n",
       "Fine arts or performing arts (such as graphic design, music, studio art, etc.)    0.014217\n",
       "I never declared a major                                                          0.008883\n",
       "A health science (such as nursing, pharmacy, radiology, etc.)                     0.004942\n",
       "Name: UndergradMajor, dtype: float64"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['UndergradMajor'].value_counts(normalize=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "United States     12469\n",
       "India              8403\n",
       "United Kingdom     3896\n",
       "Germany            3890\n",
       "Canada             2191\n",
       "                  ...  \n",
       "Gabon                 1\n",
       "Mali                  1\n",
       "Fiji                  1\n",
       "Chad                  1\n",
       "Saint Lucia           1\n",
       "Name: Country, Length: 183, dtype: int64"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "survey['Country'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<pandas.core.groupby.generic.DataFrameGroupBy object at 0x000001D5E70C9408>"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group = survey.groupby(['Country'])\n",
    "country_group"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1793</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>27.0</td>\n",
       "      <td>16</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3072</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>32.0</td>\n",
       "      <td>22</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>102000.0</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;Flask</td>\n",
       "      <td>ASP.NET Core</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3045</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>35.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>100000.0</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Angular.js;ASP.NET;ASP.NET Core;Django...</td>\n",
       "      <td>Angular;Angular.js;ASP.NET;ASP.NET Core;Django...</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>42.0</td>\n",
       "      <td>23</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1413</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>25.0</td>\n",
       "      <td>12</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>41000.0</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>jQuery;Laravel</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>37.0</td>\n",
       "      <td>13</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3261</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>34.0</td>\n",
       "      <td>23</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>115000.0</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;jQuery;Spring</td>\n",
       "      <td>Spring</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>60.0</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53404</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Django;React.js</td>\n",
       "      <td>Django;jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>28</td>\n",
       "      <td>19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52375</th>\n",
       "      <td>I am not primarily a developer, but I write co...</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>A natural science (such as biology, chemistry,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>35.0</td>\n",
       "      <td>15</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53407</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>31.0</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Flask</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52364</th>\n",
       "      <td>I am a student who is learning to code</td>\n",
       "      <td>True</td>\n",
       "      <td>23.0</td>\n",
       "      <td>12</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;ASP.NET Core;Express;jQuery;React.js</td>\n",
       "      <td>Angular;ASP.NET Core;Express</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52389</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>11</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>USD</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Too long</td>\n",
       "      <td>No</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>23</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>12469 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "1793                           I am a developer by profession     True  27.0   \n",
       "3072                           I am a developer by profession     True  32.0   \n",
       "3045                           I am a developer by profession     True  35.0   \n",
       "1413                           I am a developer by profession     True  25.0   \n",
       "3261                           I am a developer by profession     True  34.0   \n",
       "...                                                       ...      ...   ...   \n",
       "53404                          I am a developer by profession     True   NaN   \n",
       "52375       I am not primarily a developer, but I write co...     True   NaN   \n",
       "53407                          I am a developer by profession     True  31.0   \n",
       "52364                  I am a student who is learning to code     True  23.0   \n",
       "52389                          I am a developer by profession     True   NaN   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  SalaryUSD        Country  \\\n",
       "Respondent                                                            \n",
       "1793               16   Weekly   120000.0  2000000.0  United States   \n",
       "3072               22   Weekly   102000.0  2000000.0  United States   \n",
       "3045               12   Weekly   100000.0  2000000.0  United States   \n",
       "1413               12   Weekly    41000.0  2000000.0  United States   \n",
       "3261               23   Weekly   115000.0  2000000.0  United States   \n",
       "...               ...      ...        ...        ...            ...   \n",
       "53404               5      NaN        NaN        NaN  United States   \n",
       "52375              10      NaN        NaN        NaN  United States   \n",
       "53407              12      NaN        NaN        NaN  United States   \n",
       "52364              12      NaN        NaN        NaN  United States   \n",
       "52389              11   Weekly        NaN        NaN  United States   \n",
       "\n",
       "                    CurrencyDesc CurrencySymbol  ...  \\\n",
       "Respondent                                       ...   \n",
       "1793        United States dollar            USD  ...   \n",
       "3072        United States dollar            USD  ...   \n",
       "3045        United States dollar            USD  ...   \n",
       "1413        United States dollar            USD  ...   \n",
       "3261        United States dollar            USD  ...   \n",
       "...                          ...            ...  ...   \n",
       "53404       United States dollar            USD  ...   \n",
       "52375       United States dollar            USD  ...   \n",
       "53407                        NaN            NaN  ...   \n",
       "52364                        NaN            NaN  ...   \n",
       "52389       United States dollar            USD  ...   \n",
       "\n",
       "                            SurveyEase           SurveyLength Trans  \\\n",
       "Respondent                                                            \n",
       "1793                              Easy  Appropriate in length    No   \n",
       "3072                              Easy  Appropriate in length    No   \n",
       "3045        Neither easy nor difficult               Too long    No   \n",
       "1413        Neither easy nor difficult  Appropriate in length    No   \n",
       "3261                              Easy  Appropriate in length    No   \n",
       "...                                ...                    ...   ...   \n",
       "53404                             Easy  Appropriate in length   NaN   \n",
       "52375                             Easy  Appropriate in length    No   \n",
       "53407       Neither easy nor difficult  Appropriate in length    No   \n",
       "52364                             Easy  Appropriate in length    No   \n",
       "52389       Neither easy nor difficult               Too long    No   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "1793        Computer science, computer engineering, or sof...   \n",
       "3072        Computer science, computer engineering, or sof...   \n",
       "3045        Computer science, computer engineering, or sof...   \n",
       "1413        Computer science, computer engineering, or sof...   \n",
       "3261        Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "53404       Computer science, computer engineering, or sof...   \n",
       "52375       A natural science (such as biology, chemistry,...   \n",
       "53407       Computer science, computer engineering, or sof...   \n",
       "52364       Computer science, computer engineering, or sof...   \n",
       "52389       Another engineering discipline (such as civil,...   \n",
       "\n",
       "                                       WebframeDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "1793                                                      NaN   \n",
       "3072                                       ASP.NET Core;Flask   \n",
       "3045        Angular;Angular.js;ASP.NET;ASP.NET Core;Django...   \n",
       "1413                                           jQuery;Laravel   \n",
       "3261                                     Django;jQuery;Spring   \n",
       "...                                                       ...   \n",
       "53404                                         Django;React.js   \n",
       "52375                                                     NaN   \n",
       "53407                                                   Flask   \n",
       "52364            Angular;ASP.NET Core;Express;jQuery;React.js   \n",
       "52389                                                     NaN   \n",
       "\n",
       "                                           WebframeWorkedWith  \\\n",
       "Respondent                                                      \n",
       "1793                                                      NaN   \n",
       "3072                                             ASP.NET Core   \n",
       "3045        Angular;Angular.js;ASP.NET;ASP.NET Core;Django...   \n",
       "1413                                                   jQuery   \n",
       "3261                                                   Spring   \n",
       "...                                                       ...   \n",
       "53404                                           Django;jQuery   \n",
       "52375                                                     NaN   \n",
       "53407                                                     NaN   \n",
       "52364                            Angular;ASP.NET Core;Express   \n",
       "52389                                                     NaN   \n",
       "\n",
       "                                       WelcomeChange WorkWeekHrs YearsCode  \\\n",
       "Respondent                                                                   \n",
       "1793         Just as welcome now as I felt last year        40.0        12   \n",
       "3072        Somewhat less welcome now than last year        40.0        10   \n",
       "3045         Just as welcome now as I felt last year        42.0        23   \n",
       "1413         Just as welcome now as I felt last year        37.0        13   \n",
       "3261         Just as welcome now as I felt last year        60.0        11   \n",
       "...                                              ...         ...       ...   \n",
       "53404        Just as welcome now as I felt last year        40.0        28   \n",
       "52375        Just as welcome now as I felt last year        35.0        15   \n",
       "53407        Just as welcome now as I felt last year         NaN        15   \n",
       "52364        Just as welcome now as I felt last year         NaN         3   \n",
       "52389        Just as welcome now as I felt last year        40.0        23   \n",
       "\n",
       "           YearsCodePro  \n",
       "Respondent               \n",
       "1793                NaN  \n",
       "3072                  7  \n",
       "3045                  5  \n",
       "1413                  3  \n",
       "3261                  9  \n",
       "...                 ...  \n",
       "53404                19  \n",
       "52375                 5  \n",
       "53407               NaN  \n",
       "52364               NaN  \n",
       "52389                10  \n",
       "\n",
       "[12469 rows x 60 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('United States')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 54,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>Age</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>SalaryUSD</th>\n",
       "      <th>Country</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>...</th>\n",
       "      <th>SurveyEase</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>Trans</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>WebframeDesireNextYear</th>\n",
       "      <th>WebframeWorkedWith</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Respondent</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",
       "      <th></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",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11681</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>33.0</td>\n",
       "      <td>15</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>96000.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>42.5</td>\n",
       "      <td>18</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11116</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>34.0</td>\n",
       "      <td>11</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Spring;Vue.js</td>\n",
       "      <td>Angular;Gatsby;Spring;Vue.js</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>55.0</td>\n",
       "      <td>23</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>954</th>\n",
       "      <td>I am not primarily a developer, but I write co...</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Another engineering discipline (such as civil,...</td>\n",
       "      <td>Vue.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>20</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19446</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>32.0</td>\n",
       "      <td>18</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>1250000.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>Difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Mathematics or statistics</td>\n",
       "      <td>NaN</td>\n",
       "      <td>React.js</td>\n",
       "      <td>Not applicable - I did not use Stack Overflow ...</td>\n",
       "      <td>42.0</td>\n",
       "      <td>12</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29255</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>30.0</td>\n",
       "      <td>15</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>105000.0</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Angular;Spring</td>\n",
       "      <td>Angular;Spring</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>40.0</td>\n",
       "      <td>15</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50644</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Web development or web design</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>36121</th>\n",
       "      <td>I am not primarily a developer, but I write co...</td>\n",
       "      <td>True</td>\n",
       "      <td>36.0</td>\n",
       "      <td>18</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>A humanities discipline (such as literature, h...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>30.0</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43957</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Web development or web design</td>\n",
       "      <td>ASP.NET;ASP.NET Core</td>\n",
       "      <td>ASP.NET</td>\n",
       "      <td>NaN</td>\n",
       "      <td>36.0</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33967</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>False</td>\n",
       "      <td>34.0</td>\n",
       "      <td>16</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>Swiss franc</td>\n",
       "      <td>CHF</td>\n",
       "      <td>...</td>\n",
       "      <td>Easy</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>No</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>ASP.NET Core;Vue.js</td>\n",
       "      <td>Angular;ASP.NET;ASP.NET Core;jQuery</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44648</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Switzerland</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</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>Somewhat less welcome now than last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>629 rows × 60 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   MainBranch Hobbyist   Age  \\\n",
       "Respondent                                                                     \n",
       "11681                          I am a developer by profession     True  33.0   \n",
       "11116                          I am a developer by profession     True  34.0   \n",
       "954         I am not primarily a developer, but I write co...     True   NaN   \n",
       "19446                          I am a developer by profession     True  32.0   \n",
       "29255                          I am a developer by profession     True  30.0   \n",
       "...                                                       ...      ...   ...   \n",
       "50644                          I am a developer by profession     True   NaN   \n",
       "36121       I am not primarily a developer, but I write co...     True  36.0   \n",
       "43957                          I am a developer by profession     True   NaN   \n",
       "33967                          I am a developer by profession    False  34.0   \n",
       "44648                          I am a developer by profession     True   NaN   \n",
       "\n",
       "           Age1stCode CompFreq  CompTotal  SalaryUSD      Country  \\\n",
       "Respondent                                                          \n",
       "11681              15  Monthly    96000.0  1000000.0  Switzerland   \n",
       "11116              11  Monthly   120000.0  1000000.0  Switzerland   \n",
       "954                10  Monthly   120000.0  1000000.0  Switzerland   \n",
       "19446              18  Monthly  1250000.0  1000000.0  Switzerland   \n",
       "29255              15  Monthly   105000.0  1000000.0  Switzerland   \n",
       "...               ...      ...        ...        ...          ...   \n",
       "50644             NaN      NaN        NaN        NaN  Switzerland   \n",
       "36121              18  Monthly        NaN        NaN  Switzerland   \n",
       "43957              16      NaN        NaN        NaN  Switzerland   \n",
       "33967              16      NaN        NaN        NaN  Switzerland   \n",
       "44648             NaN      NaN        NaN        NaN  Switzerland   \n",
       "\n",
       "           CurrencyDesc CurrencySymbol  ...                  SurveyEase  \\\n",
       "Respondent                              ...                               \n",
       "11681       Swiss franc            CHF  ...                        Easy   \n",
       "11116       Swiss franc            CHF  ...                        Easy   \n",
       "954         Swiss franc            CHF  ...  Neither easy nor difficult   \n",
       "19446       Swiss franc            CHF  ...                   Difficult   \n",
       "29255       Swiss franc            CHF  ...  Neither easy nor difficult   \n",
       "...                 ...            ...  ...                         ...   \n",
       "50644               NaN            NaN  ...                         NaN   \n",
       "36121       Swiss franc            CHF  ...                        Easy   \n",
       "43957       Swiss franc            CHF  ...                         NaN   \n",
       "33967       Swiss franc            CHF  ...                        Easy   \n",
       "44648               NaN            NaN  ...                         NaN   \n",
       "\n",
       "                     SurveyLength Trans  \\\n",
       "Respondent                                \n",
       "11681       Appropriate in length    No   \n",
       "11116       Appropriate in length    No   \n",
       "954         Appropriate in length    No   \n",
       "19446       Appropriate in length    No   \n",
       "29255       Appropriate in length    No   \n",
       "...                           ...   ...   \n",
       "50644                         NaN   NaN   \n",
       "36121       Appropriate in length    No   \n",
       "43957                         NaN   NaN   \n",
       "33967       Appropriate in length    No   \n",
       "44648                         NaN   NaN   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "11681       Computer science, computer engineering, or sof...   \n",
       "11116       Computer science, computer engineering, or sof...   \n",
       "954         Another engineering discipline (such as civil,...   \n",
       "19446                               Mathematics or statistics   \n",
       "29255       Computer science, computer engineering, or sof...   \n",
       "...                                                       ...   \n",
       "50644                           Web development or web design   \n",
       "36121       A humanities discipline (such as literature, h...   \n",
       "43957                           Web development or web design   \n",
       "33967       Computer science, computer engineering, or sof...   \n",
       "44648                                                     NaN   \n",
       "\n",
       "           WebframeDesireNextYear                   WebframeWorkedWith  \\\n",
       "Respondent                                                               \n",
       "11681                         NaN                                  NaN   \n",
       "11116       Angular;Spring;Vue.js         Angular;Gatsby;Spring;Vue.js   \n",
       "954                        Vue.js                                  NaN   \n",
       "19446                         NaN                             React.js   \n",
       "29255              Angular;Spring                       Angular;Spring   \n",
       "...                           ...                                  ...   \n",
       "50644                         NaN                                  NaN   \n",
       "36121                         NaN                                  NaN   \n",
       "43957        ASP.NET;ASP.NET Core                              ASP.NET   \n",
       "33967         ASP.NET Core;Vue.js  Angular;ASP.NET;ASP.NET Core;jQuery   \n",
       "44648                         NaN                                  NaN   \n",
       "\n",
       "                                                WelcomeChange WorkWeekHrs  \\\n",
       "Respondent                                                                  \n",
       "11681                 Just as welcome now as I felt last year        42.5   \n",
       "11116                 Just as welcome now as I felt last year        55.0   \n",
       "954                   Just as welcome now as I felt last year         NaN   \n",
       "19446       Not applicable - I did not use Stack Overflow ...        42.0   \n",
       "29255                 Just as welcome now as I felt last year        40.0   \n",
       "...                                                       ...         ...   \n",
       "50644                                                     NaN         NaN   \n",
       "36121                Somewhat less welcome now than last year        30.0   \n",
       "43957                                                     NaN        36.0   \n",
       "33967                 Just as welcome now as I felt last year         NaN   \n",
       "44648                Somewhat less welcome now than last year         NaN   \n",
       "\n",
       "           YearsCode YearsCodePro  \n",
       "Respondent                         \n",
       "11681             18           12  \n",
       "11116             23           11  \n",
       "954               20           10  \n",
       "19446             12            7  \n",
       "29255             15          NaN  \n",
       "...              ...          ...  \n",
       "50644            NaN          NaN  \n",
       "36121             18           10  \n",
       "43957              9            5  \n",
       "33967             18           13  \n",
       "44648            NaN          NaN  \n",
       "\n",
       "[629 rows x 60 columns]"
      ]
     },
     "execution_count": 54,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('Switzerland')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Gender\n",
       "Man                                                            499\n",
       "Woman                                                           24\n",
       "Non-binary, genderqueer, or gender non-conforming                4\n",
       "Woman;Man;Non-binary, genderqueer, or gender non-conforming      1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('Switzerland').value_counts('Gender')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 56,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Gender\n",
       "Man                                                            5002\n",
       "Woman                                                           370\n",
       "Woman;Man                                                        21\n",
       "Non-binary, genderqueer, or gender non-conforming                12\n",
       "Man;Non-binary, genderqueer, or gender non-conforming             5\n",
       "Woman;Man;Non-binary, genderqueer, or gender non-conforming       4\n",
       "Woman;Non-binary, genderqueer, or gender non-conforming           1\n",
       "dtype: int64"
      ]
     },
     "execution_count": 56,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('India').value_counts('Gender')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "WebframeWorkedWith\n",
       "React.js                                            457\n",
       "jQuery                                              388\n",
       "Flask                                               250\n",
       "Spring                                              192\n",
       "Express;React.js                                    189\n",
       "                                                   ... \n",
       "Angular;Angular.js;Django;React.js;Vue.js             1\n",
       "Angular;Angular.js;Django;React.js;Spring;Vue.js      1\n",
       "Angular;Angular.js;Django;React.js;Spring             1\n",
       "Angular;Angular.js;Django;React.js                    1\n",
       "Angular;Angular.js;Django                             1\n",
       "Length: 1409, dtype: int64"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('United States').value_counts('WebframeWorkedWith')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 58,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "WebframeWorkedWith\n",
       "jQuery                                                       295\n",
       "Spring                                                       205\n",
       "React.js                                                     178\n",
       "Django                                                       175\n",
       "ASP.NET                                                      131\n",
       "                                                            ... \n",
       "Angular;Angular.js;Django;Spring                               1\n",
       "Angular;Angular.js;Django;Laravel;Vue.js                       1\n",
       "Angular;Angular.js;Django;Gatsby;jQuery;React.js               1\n",
       "Angular;Angular.js;Django;Gatsby;Spring                        1\n",
       "Angular;Angular.js;ASP.NET;Express;jQuery;React.js;Spring      1\n",
       "Length: 985, dtype: int64"
      ]
     },
     "execution_count": 58,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('India').value_counts('WebframeWorkedWith')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "WebframeWorkedWith\n",
       "jQuery                                                  143\n",
       "Spring                                                  123\n",
       "React.js                                                109\n",
       "Flask                                                    73\n",
       "Angular                                                  64\n",
       "                                                       ... \n",
       "Angular;Drupal;jQuery;Laravel;React.js;Spring;Vue.js      1\n",
       "Angular;Drupal;jQuery;Laravel;Symfony;Vue.js              1\n",
       "Angular;Drupal;jQuery;React.js                            1\n",
       "Angular;Express;Flask;React.js                            1\n",
       "Angular;Django;Express;Gatsby;jQuery;React.js             1\n",
       "Length: 634, dtype: int64"
      ]
     },
     "execution_count": 59,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('Germany').value_counts('WebframeWorkedWith')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 60,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "WebframeWorkedWith\n",
       "React.js                                           59\n",
       "jQuery                                             58\n",
       "Flask                                              35\n",
       "Spring                                             35\n",
       "Angular                                            30\n",
       "                                                   ..\n",
       "Angular;Express;jQuery;Laravel;React.js;Symfony     1\n",
       "Angular;Express;jQuery;React.js                     1\n",
       "Angular;Express;jQuery;React.js;Spring              1\n",
       "Angular;Express;jQuery;Spring;Vue.js                1\n",
       "Angular;Drupal;jQuery;React.js;Symfony;Vue.js       1\n",
       "Length: 486, dtype: int64"
      ]
     },
     "execution_count": 60,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('France').value_counts('WebframeWorkedWith')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country      WebframeWorkedWith    \n",
       "Afghanistan  Angular                   5\n",
       "             jQuery                    5\n",
       "             ASP.NET;jQuery;Laravel    3\n",
       "             Laravel                   2\n",
       "             jQuery;Laravel            2\n",
       "                                      ..\n",
       "Zimbabwe     Ruby on Rails             1\n",
       "             Spring                    1\n",
       "             Vue.js                    1\n",
       "             jQuery;Laravel;Symfony    1\n",
       "             jQuery;Laravel;Vue.js     1\n",
       "Name: WebframeWorkedWith, Length: 15777, dtype: int64"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# group functions\n",
    "country_group['WebframeWorkedWith'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 62,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "WebframeWorkedWith\n",
       "jQuery                                         5.853175\n",
       "Spring                                         4.067460\n",
       "React.js                                       3.531746\n",
       "Django                                         3.472222\n",
       "ASP.NET                                        2.599206\n",
       "                                                 ...   \n",
       "jQuery;React.js;Ruby on Rails;Spring           0.019841\n",
       "jQuery;React.js;Ruby on Rails;Spring;Vue.js    0.019841\n",
       "jQuery;React.js;Ruby on Rails;Vue.js           0.019841\n",
       "jQuery;Ruby on Rails;Spring                    0.019841\n",
       "jQuery;Spring;Symfony                          0.019841\n",
       "Name: WebframeWorkedWith, Length: 985, dtype: float64"
      ]
     },
     "execution_count": 62,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group['WebframeWorkedWith'].value_counts(normalize=True)['India'] * 100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Afghanistan                             15163.5\n",
       "Albania                                 15900.0\n",
       "Algeria                                  9432.0\n",
       "Andorra                                 88640.0\n",
       "Angola                                   5292.0\n",
       "                                         ...   \n",
       "Venezuela, Bolivarian Republic of...     3600.0\n",
       "Viet Nam                                10344.0\n",
       "Yemen                                   36000.0\n",
       "Zambia                                   5452.0\n",
       "Zimbabwe                                 7200.0\n",
       "Name: SalaryUSD, Length: 183, dtype: float64"
      ]
     },
     "execution_count": 63,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Having a look at salary\n",
    "country_group['SalaryUSD'].median()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "62697.0"
      ]
     },
     "execution_count": 64,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group['SalaryUSD'].median()['Germany']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 65,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "10056.0"
      ]
     },
     "execution_count": 65,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Having a look at salary\n",
    "country_group['SalaryUSD'].median()['India']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "115000.0"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Having a look at salary\n",
    "country_group['SalaryUSD'].median()['United States']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "98599.0"
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Having a look at salary\n",
    "country_group['SalaryUSD'].median()['Switzerland']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Applying Multiple Aggregate Functions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>median</th>\n",
       "      <th>mean</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Country</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Afghanistan</th>\n",
       "      <td>15163.5</td>\n",
       "      <td>148290.125000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Albania</th>\n",
       "      <td>15900.0</td>\n",
       "      <td>25611.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Algeria</th>\n",
       "      <td>9432.0</td>\n",
       "      <td>10362.812500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Andorra</th>\n",
       "      <td>88640.0</td>\n",
       "      <td>88640.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Angola</th>\n",
       "      <td>5292.0</td>\n",
       "      <td>5292.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Venezuela, Bolivarian Republic of...</th>\n",
       "      <td>3600.0</td>\n",
       "      <td>6280.611111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Viet Nam</th>\n",
       "      <td>10344.0</td>\n",
       "      <td>28342.605769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Yemen</th>\n",
       "      <td>36000.0</td>\n",
       "      <td>36000.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zambia</th>\n",
       "      <td>5452.0</td>\n",
       "      <td>17506.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Zimbabwe</th>\n",
       "      <td>7200.0</td>\n",
       "      <td>26338.181818</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       median           mean\n",
       "Country                                                     \n",
       "Afghanistan                           15163.5  148290.125000\n",
       "Albania                               15900.0   25611.000000\n",
       "Algeria                                9432.0   10362.812500\n",
       "Andorra                               88640.0   88640.000000\n",
       "Angola                                 5292.0    5292.000000\n",
       "...                                       ...            ...\n",
       "Venezuela, Bolivarian Republic of...   3600.0    6280.611111\n",
       "Viet Nam                              10344.0   28342.605769\n",
       "Yemen                                 36000.0   36000.000000\n",
       "Zambia                                 5452.0   17506.400000\n",
       "Zimbabwe                               7200.0   26338.181818\n",
       "\n",
       "[183 rows x 2 columns]"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group['SalaryUSD'].agg(['median', 'mean'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "median     68068.000000\n",
       "mean      115101.775465\n",
       "Name: Canada, dtype: float64"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group['SalaryUSD'].agg(['median', 'mean']).loc['Canada']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## How many people in a country know Python?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "65381    False\n",
       "65456    False\n",
       "62788    False\n",
       "38672    False\n",
       "28374    False\n",
       "         ...  \n",
       "60055    False\n",
       "61121    False\n",
       "61570    False\n",
       "61918    False\n",
       "62605    False\n",
       "Name: LanguageWorkedWith, Length: 64461, dtype: bool"
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_filter = survey['LanguageWorkedWith'].str.contains('Python', na=False)\n",
    "python_filter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 72,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25287"
      ]
     },
     "execution_count": 72,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# number of people who claim to know python\n",
    "python_filter.sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "c:\\users\\anish\\appdata\\local\\programs\\python\\python37\\lib\\site-packages\\ipykernel_launcher.py:1: UserWarning: Boolean Series key will be reindexed to match DataFrame index.\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "2670"
      ]
     },
     "execution_count": 118,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group.get_group('India')[python_filter]['LanguageWorkedWith'].count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'SeriesGroupBy' object has no attribute 'str'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-123-d53e638812ba>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mcountry_group\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'LanguageWorkedWith'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mstr\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mcontains\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'Python'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mc:\\users\\anish\\appdata\\local\\programs\\python\\python37\\lib\\site-packages\\pandas\\core\\groupby\\groupby.py\u001b[0m in \u001b[0;36m__getattr__\u001b[1;34m(self, attr)\u001b[0m\n\u001b[0;32m    702\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    703\u001b[0m         raise AttributeError(\n\u001b[1;32m--> 704\u001b[1;33m             \u001b[1;34mf\"'{type(self).__name__}' object has no attribute '{attr}'\"\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    705\u001b[0m         )\n\u001b[0;32m    706\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mAttributeError\u001b[0m: 'SeriesGroupBy' object has no attribute 'str'"
     ]
    }
   ],
   "source": [
    "# the follwoing will give an error\n",
    "# country_group['LanguageWorkedWith'].str.contains('Python')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Afghanistan                              11\n",
       "Albania                                  13\n",
       "Algeria                                  40\n",
       "Andorra                                   3\n",
       "Angola                                    1\n",
       "                                       ... \n",
       "Venezuela, Bolivarian Republic of...     29\n",
       "Viet Nam                                102\n",
       "Yemen                                     1\n",
       "Zambia                                    4\n",
       "Zimbabwe                                 13\n",
       "Name: LanguageWorkedWith, Length: 183, dtype: int64"
      ]
     },
     "execution_count": 73,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_group['LanguageWorkedWith'].apply(lambda x: x.str.contains('Python').sum())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "25287"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# total number of python user\n",
    "total_python_users = country_group['LanguageWorkedWith'].apply(lambda x: x.str.contains('Python').sum()).sum()\n",
    "total_python_users"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Afghanistan                             0.043501\n",
       "Albania                                 0.051410\n",
       "Algeria                                 0.158184\n",
       "Andorra                                 0.011864\n",
       "Angola                                  0.003955\n",
       "                                          ...   \n",
       "Venezuela, Bolivarian Republic of...    0.114683\n",
       "Viet Nam                                0.403369\n",
       "Yemen                                   0.003955\n",
       "Zambia                                  0.015818\n",
       "Zimbabwe                                0.051410\n",
       "Name: LanguageWorkedWith, Length: 183, dtype: float64"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "100 * country_group['LanguageWorkedWith'].apply(lambda x: x.str.contains('Python').sum()) / total_python_users"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "United States     12469\n",
       "India              8403\n",
       "United Kingdom     3896\n",
       "Germany            3890\n",
       "Canada             2191\n",
       "                  ...  \n",
       "Gabon                 1\n",
       "Mali                  1\n",
       "Fiji                  1\n",
       "Chad                  1\n",
       "Saint Lucia           1\n",
       "Name: Country, Length: 183, dtype: int64"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Percentage of people in each country who know python\n",
    "country_population = survey['Country'].value_counts()\n",
    "country_population"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Country\n",
       "Afghanistan                              11\n",
       "Albania                                  13\n",
       "Algeria                                  40\n",
       "Andorra                                   3\n",
       "Angola                                    1\n",
       "                                       ... \n",
       "Venezuela, Bolivarian Republic of...     29\n",
       "Viet Nam                                102\n",
       "Yemen                                     1\n",
       "Zambia                                    4\n",
       "Zimbabwe                                 13\n",
       "Name: LanguageWorkedWith, Length: 183, dtype: int64"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_users = country_group['LanguageWorkedWith'].apply(lambda x: x.str.contains('Python').sum())\n",
    "python_users"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Afghanistan                             13.095238\n",
       "Albania                                 24.074074\n",
       "Algeria                                 42.553191\n",
       "Andorra                                 23.076923\n",
       "Angola                                  11.111111\n",
       "                                          ...    \n",
       "Venezuela, Bolivarian Republic of...    41.428571\n",
       "Viet Nam                                28.021978\n",
       "Yemen                                   14.285714\n",
       "Zambia                                  19.047619\n",
       "Zimbabwe                                41.935484\n",
       "Length: 183, dtype: float64"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_users_per_country = 100 * python_users / country_population\n",
    "python_users_per_country"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "31.774366297750802"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_users_per_country['India']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "47.830619937444865"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_users_per_country['United States']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "44.01028277634961"
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_users_per_country['Germany']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "44.19713831478538"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_users_per_country['Switzerland']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Gabon                                 100.000000\n",
       "Micronesia, Federated States of...    100.000000\n",
       "Saint Lucia                           100.000000\n",
       "Montenegro                             69.230769\n",
       "Brunei Darussalam                      66.666667\n",
       "Guyana                                 60.000000\n",
       "Swaziland                              57.142857\n",
       "Iceland                                52.830189\n",
       "Finland                                52.435530\n",
       "Uganda                                 51.851852\n",
       "dtype: float64"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python_users_per_country.nlargest(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "country_population['Gabon']"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Creating a New Table Using Concatenation"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Country</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>12469</td>\n",
       "      <td>5964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>India</th>\n",
       "      <td>8403</td>\n",
       "      <td>2670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>3896</td>\n",
       "      <td>1621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>3890</td>\n",
       "      <td>1712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>2191</td>\n",
       "      <td>1011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gabon</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mali</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fiji</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chad</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saint Lucia</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                Country  LanguageWorkedWith\n",
       "United States     12469                5964\n",
       "India              8403                2670\n",
       "United Kingdom     3896                1621\n",
       "Germany            3890                1712\n",
       "Canada             2191                1011\n",
       "...                 ...                 ...\n",
       "Gabon                 1                   1\n",
       "Mali                  1                   0\n",
       "Fiji                  1                   0\n",
       "Chad                  1                   0\n",
       "Saint Lucia           1                   1\n",
       "\n",
       "[183 rows x 2 columns]"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python = pd.concat([country_population, python_users], axis='columns', sort=False)\n",
    "python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>population</th>\n",
       "      <th>python_users</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>12469</td>\n",
       "      <td>5964</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>India</th>\n",
       "      <td>8403</td>\n",
       "      <td>2670</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>3896</td>\n",
       "      <td>1621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>3890</td>\n",
       "      <td>1712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>2191</td>\n",
       "      <td>1011</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gabon</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mali</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fiji</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chad</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saint Lucia</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                population  python_users\n",
       "United States        12469          5964\n",
       "India                 8403          2670\n",
       "United Kingdom        3896          1621\n",
       "Germany               3890          1712\n",
       "Canada                2191          1011\n",
       "...                    ...           ...\n",
       "Gabon                    1             1\n",
       "Mali                     1             0\n",
       "Fiji                     1             0\n",
       "Chad                     1             0\n",
       "Saint Lucia              1             1\n",
       "\n",
       "[183 rows x 2 columns]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python.columns = ['population', 'python_users']\n",
    "python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>population</th>\n",
       "      <th>python_users</th>\n",
       "      <th>percentage_python</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>United States</th>\n",
       "      <td>12469</td>\n",
       "      <td>5964</td>\n",
       "      <td>47.830620</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>India</th>\n",
       "      <td>8403</td>\n",
       "      <td>2670</td>\n",
       "      <td>31.774366</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>United Kingdom</th>\n",
       "      <td>3896</td>\n",
       "      <td>1621</td>\n",
       "      <td>41.606776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Germany</th>\n",
       "      <td>3890</td>\n",
       "      <td>1712</td>\n",
       "      <td>44.010283</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Canada</th>\n",
       "      <td>2191</td>\n",
       "      <td>1011</td>\n",
       "      <td>46.143314</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gabon</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Mali</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Fiji</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chad</th>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Saint Lucia</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                population  python_users  percentage_python\n",
       "United States        12469          5964          47.830620\n",
       "India                 8403          2670          31.774366\n",
       "United Kingdom        3896          1621          41.606776\n",
       "Germany               3890          1712          44.010283\n",
       "Canada                2191          1011          46.143314\n",
       "...                    ...           ...                ...\n",
       "Gabon                    1             1         100.000000\n",
       "Mali                     1             0           0.000000\n",
       "Fiji                     1             0           0.000000\n",
       "Chad                     1             0           0.000000\n",
       "Saint Lucia              1             1         100.000000\n",
       "\n",
       "[183 rows x 3 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python['percentage_python'] = 100 * python['python_users'] / python['population']\n",
    "python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>population</th>\n",
       "      <th>python_users</th>\n",
       "      <th>percentage_python</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Saint Lucia</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gabon</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Micronesia, Federated States of...</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>100.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Montenegro</th>\n",
       "      <td>13</td>\n",
       "      <td>9</td>\n",
       "      <td>69.230769</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Brunei Darussalam</th>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>66.666667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gambia</th>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>San Marino</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Antigua and Barbuda</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Cape Verde</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Djibouti</th>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>183 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    population  python_users  \\\n",
       "Saint Lucia                                  1             1   \n",
       "Gabon                                        1             1   \n",
       "Micronesia, Federated States of...           1             1   \n",
       "Montenegro                                  13             9   \n",
       "Brunei Darussalam                            3             2   \n",
       "...                                        ...           ...   \n",
       "Gambia                                       4             0   \n",
       "San Marino                                   2             0   \n",
       "Antigua and Barbuda                          2             0   \n",
       "Cape Verde                                   2             0   \n",
       "Djibouti                                     2             0   \n",
       "\n",
       "                                    percentage_python  \n",
       "Saint Lucia                                100.000000  \n",
       "Gabon                                      100.000000  \n",
       "Micronesia, Federated States of...         100.000000  \n",
       "Montenegro                                  69.230769  \n",
       "Brunei Darussalam                           66.666667  \n",
       "...                                               ...  \n",
       "Gambia                                       0.000000  \n",
       "San Marino                                   0.000000  \n",
       "Antigua and Barbuda                          0.000000  \n",
       "Cape Verde                                   0.000000  \n",
       "Djibouti                                     0.000000  \n",
       "\n",
       "[183 rows x 3 columns]"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# sorting on basis of python knowledge\n",
    "python.sort_values(by='percentage_python', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "population           297.000000\n",
       "python_users         132.000000\n",
       "percentage_python     44.444444\n",
       "Name: Japan, dtype: float64"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "python.loc['Japan']"
   ]
  }
 ],
 "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.7.9"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}