07-Sorting Data.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# 07 - Sorting Data\n",
    "\n",
    "https://youtu.be/T11QYVfZoD0?si=_nMLS7XWhASycD4M\n",
    "\n",
    "Notes by [Innovinitylabs](https://github.com/innovinitylabs)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 73,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "#Setup for learning data\n",
    "\n",
    "people = {\n",
    "    \"first\": [\"Corey\", 'Jane', 'John', 'Ratan', 'Arjun', 'Pushpa', 'Rajinikanth'], \n",
    "    \"last\": [\"Schafer\", 'Doe', 'Doe', 'Tata', 'Reddy', 'No Inti Peru', 'Rajinikanth'], \n",
    "    \"email\": [\"CoreyMSchafer@gmail.com\", 'JaneDoe@email.com', 'JohnDoe@email.com', 'Ratan@tata.com', 'Aready@email.com', 'thaggedhele@puspha.com', 'gmail@rajinikanth.com' ]\n",
    "}\n",
    "dft = pd.DataFrame(people)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Setup for Real world data.\n",
    "###### uncomment when in need to avoid conflicting code autocomplete suggestions"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 74,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('data/survey_results_public.csv', index_col='Respondent' )\n",
    "schema_df = pd.read_csv('data/survey_results_schema.csv', index_col='Column')\n",
    "pd.set_option('display.max_columns', 85)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 75,
   "metadata": {},
   "outputs": [],
   "source": [
    "# pd.set_option('display.max_rows', 85)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "---\n",
    "---"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 76,
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Corey</td>\n",
       "      <td>Schafer</td>\n",
       "      <td>CoreyMSchafer@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JaneDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>John</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JohnDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ratan</td>\n",
       "      <td>Tata</td>\n",
       "      <td>Ratan@tata.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Arjun</td>\n",
       "      <td>Reddy</td>\n",
       "      <td>Aready@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pushpa</td>\n",
       "      <td>No Inti Peru</td>\n",
       "      <td>thaggedhele@puspha.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>gmail@rajinikanth.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first          last                    email\n",
       "0        Corey       Schafer  CoreyMSchafer@gmail.com\n",
       "1         Jane           Doe        JaneDoe@email.com\n",
       "2         John           Doe        JohnDoe@email.com\n",
       "3        Ratan          Tata           Ratan@tata.com\n",
       "4        Arjun         Reddy         Aready@email.com\n",
       "5       Pushpa  No Inti Peru   thaggedhele@puspha.com\n",
       "6  Rajinikanth   Rajinikanth    gmail@rajinikanth.com"
      ]
     },
     "execution_count": 76,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dft"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "in order to sor this by last name\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JaneDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>John</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JohnDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pushpa</td>\n",
       "      <td>No Inti Peru</td>\n",
       "      <td>thaggedhele@puspha.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>gmail@rajinikanth.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Arjun</td>\n",
       "      <td>Reddy</td>\n",
       "      <td>Aready@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Corey</td>\n",
       "      <td>Schafer</td>\n",
       "      <td>CoreyMSchafer@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ratan</td>\n",
       "      <td>Tata</td>\n",
       "      <td>Ratan@tata.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first          last                    email\n",
       "1         Jane           Doe        JaneDoe@email.com\n",
       "2         John           Doe        JohnDoe@email.com\n",
       "5       Pushpa  No Inti Peru   thaggedhele@puspha.com\n",
       "6  Rajinikanth   Rajinikanth    gmail@rajinikanth.com\n",
       "4        Arjun         Reddy         Aready@email.com\n",
       "0        Corey       Schafer  CoreyMSchafer@gmail.com\n",
       "3        Ratan          Tata           Ratan@tata.com"
      ]
     },
     "execution_count": 77,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dft.sort_values(by='last')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 78,
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ratan</td>\n",
       "      <td>Tata</td>\n",
       "      <td>Ratan@tata.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Corey</td>\n",
       "      <td>Schafer</td>\n",
       "      <td>CoreyMSchafer@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Arjun</td>\n",
       "      <td>Reddy</td>\n",
       "      <td>Aready@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>gmail@rajinikanth.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pushpa</td>\n",
       "      <td>No Inti Peru</td>\n",
       "      <td>thaggedhele@puspha.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JaneDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>John</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JohnDoe@email.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first          last                    email\n",
       "3        Ratan          Tata           Ratan@tata.com\n",
       "0        Corey       Schafer  CoreyMSchafer@gmail.com\n",
       "4        Arjun         Reddy         Aready@email.com\n",
       "6  Rajinikanth   Rajinikanth    gmail@rajinikanth.com\n",
       "5       Pushpa  No Inti Peru   thaggedhele@puspha.com\n",
       "1         Jane           Doe        JaneDoe@email.com\n",
       "2         John           Doe        JohnDoe@email.com"
      ]
     },
     "execution_count": 78,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dft.sort_values(by='last', ascending=False) #for descending"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "to sort a list of columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 79,
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ratan</td>\n",
       "      <td>Tata</td>\n",
       "      <td>Ratan@tata.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Corey</td>\n",
       "      <td>Schafer</td>\n",
       "      <td>CoreyMSchafer@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Arjun</td>\n",
       "      <td>Reddy</td>\n",
       "      <td>Aready@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>gmail@rajinikanth.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pushpa</td>\n",
       "      <td>No Inti Peru</td>\n",
       "      <td>thaggedhele@puspha.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>John</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JohnDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JaneDoe@email.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first          last                    email\n",
       "3        Ratan          Tata           Ratan@tata.com\n",
       "0        Corey       Schafer  CoreyMSchafer@gmail.com\n",
       "4        Arjun         Reddy         Aready@email.com\n",
       "6  Rajinikanth   Rajinikanth    gmail@rajinikanth.com\n",
       "5       Pushpa  No Inti Peru   thaggedhele@puspha.com\n",
       "2         John           Doe        JohnDoe@email.com\n",
       "1         Jane           Doe        JaneDoe@email.com"
      ]
     },
     "execution_count": 79,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dft.sort_values(by=['last', 'first'], ascending=False) "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "each column in different order. we can give an list of `True` or `False` values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ratan</td>\n",
       "      <td>Tata</td>\n",
       "      <td>Ratan@tata.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Corey</td>\n",
       "      <td>Schafer</td>\n",
       "      <td>CoreyMSchafer@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Arjun</td>\n",
       "      <td>Reddy</td>\n",
       "      <td>Aready@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>gmail@rajinikanth.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pushpa</td>\n",
       "      <td>No Inti Peru</td>\n",
       "      <td>thaggedhele@puspha.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JaneDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>John</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JohnDoe@email.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first          last                    email\n",
       "3        Ratan          Tata           Ratan@tata.com\n",
       "0        Corey       Schafer  CoreyMSchafer@gmail.com\n",
       "4        Arjun         Reddy         Aready@email.com\n",
       "6  Rajinikanth   Rajinikanth    gmail@rajinikanth.com\n",
       "5       Pushpa  No Inti Peru   thaggedhele@puspha.com\n",
       "1         Jane           Doe        JaneDoe@email.com\n",
       "2         John           Doe        JohnDoe@email.com"
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dft.sort_values(by=['last', 'first'], ascending=[False, True], inplace=True) \n",
    "dft"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "to bring it back to how it was sorted by index like before  \n",
    "we use `sort_index()` methos"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 81,
   "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>first</th>\n",
       "      <th>last</th>\n",
       "      <th>email</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Corey</td>\n",
       "      <td>Schafer</td>\n",
       "      <td>CoreyMSchafer@gmail.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jane</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JaneDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>John</td>\n",
       "      <td>Doe</td>\n",
       "      <td>JohnDoe@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ratan</td>\n",
       "      <td>Tata</td>\n",
       "      <td>Ratan@tata.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Arjun</td>\n",
       "      <td>Reddy</td>\n",
       "      <td>Aready@email.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Pushpa</td>\n",
       "      <td>No Inti Peru</td>\n",
       "      <td>thaggedhele@puspha.com</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>Rajinikanth</td>\n",
       "      <td>gmail@rajinikanth.com</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         first          last                    email\n",
       "0        Corey       Schafer  CoreyMSchafer@gmail.com\n",
       "1         Jane           Doe        JaneDoe@email.com\n",
       "2         John           Doe        JohnDoe@email.com\n",
       "3        Ratan          Tata           Ratan@tata.com\n",
       "4        Arjun         Reddy         Aready@email.com\n",
       "5       Pushpa  No Inti Peru   thaggedhele@puspha.com\n",
       "6  Rajinikanth   Rajinikanth    gmail@rajinikanth.com"
      ]
     },
     "execution_count": 81,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dft.sort_index()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "to sort a single column. we can sort a single series as well  \n",
    "series also has sort method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 82,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1             Doe\n",
       "2             Doe\n",
       "5    No Inti Peru\n",
       "6     Rajinikanth\n",
       "4           Reddy\n",
       "0         Schafer\n",
       "3            Tata\n",
       "Name: last, dtype: object"
      ]
     },
     "execution_count": 82,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dft['last'].sort_values()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "---\n",
    "# SO Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 83,
   "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>OpenSourcer</th>\n",
       "      <th>OpenSource</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Country</th>\n",
       "      <th>Student</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>EduOther</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>DevType</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "      <th>CareerSat</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>MgrIdiot</th>\n",
       "      <th>MgrMoney</th>\n",
       "      <th>MgrWant</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LastHireDate</th>\n",
       "      <th>LastInt</th>\n",
       "      <th>FizzBuzz</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>ResumeUpdate</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>WorkPlan</th>\n",
       "      <th>WorkChallenge</th>\n",
       "      <th>WorkRemote</th>\n",
       "      <th>WorkLoc</th>\n",
       "      <th>ImpSyn</th>\n",
       "      <th>CodeRev</th>\n",
       "      <th>CodeRevHrs</th>\n",
       "      <th>UnitTests</th>\n",
       "      <th>PurchaseHow</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>WebFrameWorkedWith</th>\n",
       "      <th>WebFrameDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>DevEnviron</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>Containers</th>\n",
       "      <th>BlockchainOrg</th>\n",
       "      <th>BlockchainIs</th>\n",
       "      <th>BetterLife</th>\n",
       "      <th>ITperson</th>\n",
       "      <th>OffOn</th>\n",
       "      <th>SocialMedia</th>\n",
       "      <th>Extraversion</th>\n",
       "      <th>ScreenName</th>\n",
       "      <th>SOVisit1st</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SOVisitTo</th>\n",
       "      <th>SOFindAnswer</th>\n",
       "      <th>SOTimeSaved</th>\n",
       "      <th>SOHowMuchTime</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOJobs</th>\n",
       "      <th>EntTeams</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>SONewContent</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Trans</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>SurveyEase</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",
       "      <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",
       "      <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",
       "      <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 student who is learning to code</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Never</td>\n",
       "      <td>The quality of OSS and closed source software ...</td>\n",
       "      <td>Not employed, and not looking for work</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>No</td>\n",
       "      <td>Primary/elementary school</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Taught yourself a new language, framework, or ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>4</td>\n",
       "      <td>10</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",
       "      <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",
       "      <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>HTML/CSS;Java;JavaScript;Python</td>\n",
       "      <td>C;C++;C#;Go;HTML/CSS;Java;JavaScript;Python;SQL</td>\n",
       "      <td>SQLite</td>\n",
       "      <td>MySQL</td>\n",
       "      <td>MacOS;Windows</td>\n",
       "      <td>Android;Arduino;Windows</td>\n",
       "      <td>Django;Flask</td>\n",
       "      <td>Flask;jQuery</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>IntelliJ;Notepad++;PyCharm</td>\n",
       "      <td>Windows</td>\n",
       "      <td>I do not use containers</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Fortunately, someone else has that title</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>Online</td>\n",
       "      <td>Username</td>\n",
       "      <td>2017</td>\n",
       "      <td>A few times per month or weekly</td>\n",
       "      <td>Find answers to specific questions;Learn how t...</td>\n",
       "      <td>3-5 times per week</td>\n",
       "      <td>Stack Overflow was much faster</td>\n",
       "      <td>31-60 minutes</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No, I didn't know that Stack Overflow had a jo...</td>\n",
       "      <td>No, and I don't know what those are</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>Tech articles written by other developers;Indu...</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Man</td>\n",
       "      <td>No</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                        MainBranch Hobbyist OpenSourcer  \\\n",
       "Respondent                                                                \n",
       "1           I am a student who is learning to code      Yes       Never   \n",
       "\n",
       "                                                   OpenSource  \\\n",
       "Respondent                                                      \n",
       "1           The quality of OSS and closed source software ...   \n",
       "\n",
       "                                        Employment         Country Student  \\\n",
       "Respondent                                                                   \n",
       "1           Not employed, and not looking for work  United Kingdom      No   \n",
       "\n",
       "                              EdLevel UndergradMajor  \\\n",
       "Respondent                                             \n",
       "1           Primary/elementary school            NaN   \n",
       "\n",
       "                                                     EduOther OrgSize DevType  \\\n",
       "Respondent                                                                      \n",
       "1           Taught yourself a new language, framework, or ...     NaN     NaN   \n",
       "\n",
       "           YearsCode Age1stCode YearsCodePro CareerSat JobSat MgrIdiot  \\\n",
       "Respondent                                                               \n",
       "1                  4         10          NaN       NaN    NaN      NaN   \n",
       "\n",
       "           MgrMoney MgrWant JobSeek LastHireDate LastInt FizzBuzz JobFactors  \\\n",
       "Respondent                                                                     \n",
       "1               NaN     NaN     NaN          NaN     NaN      NaN        NaN   \n",
       "\n",
       "           ResumeUpdate CurrencySymbol CurrencyDesc  CompTotal CompFreq  \\\n",
       "Respondent                                                                \n",
       "1                   NaN            NaN          NaN        NaN      NaN   \n",
       "\n",
       "            ConvertedComp  WorkWeekHrs WorkPlan WorkChallenge WorkRemote  \\\n",
       "Respondent                                                                 \n",
       "1                     NaN          NaN      NaN           NaN        NaN   \n",
       "\n",
       "           WorkLoc ImpSyn CodeRev  CodeRevHrs UnitTests PurchaseHow  \\\n",
       "Respondent                                                            \n",
       "1              NaN    NaN     NaN         NaN       NaN         NaN   \n",
       "\n",
       "           PurchaseWhat               LanguageWorkedWith  \\\n",
       "Respondent                                                 \n",
       "1                   NaN  HTML/CSS;Java;JavaScript;Python   \n",
       "\n",
       "                                     LanguageDesireNextYear  \\\n",
       "Respondent                                                    \n",
       "1           C;C++;C#;Go;HTML/CSS;Java;JavaScript;Python;SQL   \n",
       "\n",
       "           DatabaseWorkedWith DatabaseDesireNextYear PlatformWorkedWith  \\\n",
       "Respondent                                                                \n",
       "1                      SQLite                  MySQL      MacOS;Windows   \n",
       "\n",
       "             PlatformDesireNextYear WebFrameWorkedWith WebFrameDesireNextYear  \\\n",
       "Respondent                                                                      \n",
       "1           Android;Arduino;Windows       Django;Flask           Flask;jQuery   \n",
       "\n",
       "           MiscTechWorkedWith MiscTechDesireNextYear  \\\n",
       "Respondent                                             \n",
       "1                     Node.js                Node.js   \n",
       "\n",
       "                            DevEnviron    OpSys               Containers  \\\n",
       "Respondent                                                                 \n",
       "1           IntelliJ;Notepad++;PyCharm  Windows  I do not use containers   \n",
       "\n",
       "           BlockchainOrg BlockchainIs BetterLife  \\\n",
       "Respondent                                         \n",
       "1                    NaN          NaN        Yes   \n",
       "\n",
       "                                            ITperson OffOn SocialMedia  \\\n",
       "Respondent                                                               \n",
       "1           Fortunately, someone else has that title   Yes     Twitter   \n",
       "\n",
       "           Extraversion ScreenName SOVisit1st  \\\n",
       "Respondent                                      \n",
       "1                Online   Username       2017   \n",
       "\n",
       "                                SOVisitFreq  \\\n",
       "Respondent                                    \n",
       "1           A few times per month or weekly   \n",
       "\n",
       "                                                    SOVisitTo  \\\n",
       "Respondent                                                      \n",
       "1           Find answers to specific questions;Learn how t...   \n",
       "\n",
       "                  SOFindAnswer                     SOTimeSaved  SOHowMuchTime  \\\n",
       "Respondent                                                                      \n",
       "1           3-5 times per week  Stack Overflow was much faster  31-60 minutes   \n",
       "\n",
       "           SOAccount SOPartFreq  \\\n",
       "Respondent                        \n",
       "1                 No        NaN   \n",
       "\n",
       "                                                       SOJobs  \\\n",
       "Respondent                                                      \n",
       "1           No, I didn't know that Stack Overflow had a jo...   \n",
       "\n",
       "                                       EntTeams   SOComm  \\\n",
       "Respondent                                                 \n",
       "1           No, and I don't know what those are  Neutral   \n",
       "\n",
       "                                      WelcomeChange  \\\n",
       "Respondent                                            \n",
       "1           Just as welcome now as I felt last year   \n",
       "\n",
       "                                                 SONewContent   Age Gender  \\\n",
       "Respondent                                                                   \n",
       "1           Tech articles written by other developers;Indu...  14.0    Man   \n",
       "\n",
       "           Trans                Sexuality Ethnicity Dependents  \\\n",
       "Respondent                                                       \n",
       "1             No  Straight / Heterosexual       NaN         No   \n",
       "\n",
       "                     SurveyLength                  SurveyEase  \n",
       "Respondent                                                     \n",
       "1           Appropriate in length  Neither easy nor difficult  "
      ]
     },
     "execution_count": 83,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "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>OpenSourcer</th>\n",
       "      <th>OpenSource</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Country</th>\n",
       "      <th>Student</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>EduOther</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>DevType</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "      <th>CareerSat</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>MgrIdiot</th>\n",
       "      <th>MgrMoney</th>\n",
       "      <th>MgrWant</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LastHireDate</th>\n",
       "      <th>LastInt</th>\n",
       "      <th>FizzBuzz</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>ResumeUpdate</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>WorkPlan</th>\n",
       "      <th>WorkChallenge</th>\n",
       "      <th>WorkRemote</th>\n",
       "      <th>WorkLoc</th>\n",
       "      <th>ImpSyn</th>\n",
       "      <th>CodeRev</th>\n",
       "      <th>CodeRevHrs</th>\n",
       "      <th>UnitTests</th>\n",
       "      <th>PurchaseHow</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>WebFrameWorkedWith</th>\n",
       "      <th>WebFrameDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>DevEnviron</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>Containers</th>\n",
       "      <th>BlockchainOrg</th>\n",
       "      <th>BlockchainIs</th>\n",
       "      <th>BetterLife</th>\n",
       "      <th>ITperson</th>\n",
       "      <th>OffOn</th>\n",
       "      <th>SocialMedia</th>\n",
       "      <th>Extraversion</th>\n",
       "      <th>ScreenName</th>\n",
       "      <th>SOVisit1st</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SOVisitTo</th>\n",
       "      <th>SOFindAnswer</th>\n",
       "      <th>SOTimeSaved</th>\n",
       "      <th>SOHowMuchTime</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOJobs</th>\n",
       "      <th>EntTeams</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>SONewContent</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Trans</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>SurveyEase</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",
       "      <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",
       "      <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",
       "      <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>39258</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Less than once per year</td>\n",
       "      <td>OSS is, on average, of LOWER quality than prop...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>No</td>\n",
       "      <td>Bachelor’s degree (BA, BS, B.Eng., etc.)</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Taken an online course in programming or softw...</td>\n",
       "      <td>100 to 499 employees</td>\n",
       "      <td>Database administrator;Designer;Developer, bac...</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Very confident</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>1-2 years ago</td>\n",
       "      <td>Write code by hand (e.g., on a whiteboard);Int...</td>\n",
       "      <td>No</td>\n",
       "      <td>Languages, frameworks, and other technologies ...</td>\n",
       "      <td>Something else changed (education, award, medi...</td>\n",
       "      <td>AFN</td>\n",
       "      <td>Afghan afghani</td>\n",
       "      <td>120000.0</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>19152.0</td>\n",
       "      <td>49.0</td>\n",
       "      <td>There is a schedule and/or spec (made by me or...</td>\n",
       "      <td>Not enough people for the workload;Time spent ...</td>\n",
       "      <td>Less than once per month / Never</td>\n",
       "      <td>Office</td>\n",
       "      <td>Far above average</td>\n",
       "      <td>Yes, because I see value in code review</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Yes, it's not part of our process but the deve...</td>\n",
       "      <td>Developers typically have the most influence o...</td>\n",
       "      <td>I have some influence</td>\n",
       "      <td>HTML/CSS;JavaScript;PHP;SQL;TypeScript</td>\n",
       "      <td>C#;Dart;JavaScript;SQL;TypeScript</td>\n",
       "      <td>MariaDB;MongoDB;MySQL;PostgreSQL</td>\n",
       "      <td>Couchbase;Firebase;MariaDB;MongoDB;Redis</td>\n",
       "      <td>Android;AWS;Linux;Windows;WordPress</td>\n",
       "      <td>Android;AWS;Docker;Heroku;iOS;Linux;Raspberry ...</td>\n",
       "      <td>Angular/Angular.js;Drupal;Express;Laravel</td>\n",
       "      <td>Angular/Angular.js;Drupal;Express</td>\n",
       "      <td>Cordova;Node.js</td>\n",
       "      <td>Hadoop;Node.js</td>\n",
       "      <td>Notepad++;PHPStorm;Vim;Visual Studio Code</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>Production</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Facebook</td>\n",
       "      <td>Online</td>\n",
       "      <td>Login</td>\n",
       "      <td>2016</td>\n",
       "      <td>A few times per week</td>\n",
       "      <td>Find answers to specific questions;Learn how t...</td>\n",
       "      <td>1-2 times per week</td>\n",
       "      <td>Stack Overflow was much faster</td>\n",
       "      <td>0-10 minutes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes, somewhat</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tech articles written by other developers;Indu...</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Man</td>\n",
       "      <td>No</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>East Asian;South Asian</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Too long</td>\n",
       "      <td>Easy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63129</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Never</td>\n",
       "      <td>OSS is, on average, of HIGHER quality than pro...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>Yes, full-time</td>\n",
       "      <td>I never completed any formal education</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Taken an online course in programming or softw...</td>\n",
       "      <td>Just me - I am a freelancer, sole proprietor, ...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Less than 1 year</td>\n",
       "      <td>Younger than 5 years</td>\n",
       "      <td>1</td>\n",
       "      <td>Very dissatisfied</td>\n",
       "      <td>Very dissatisfied</td>\n",
       "      <td>Very confident</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I am actively looking for a job</td>\n",
       "      <td>I've never had a job</td>\n",
       "      <td>Write any code</td>\n",
       "      <td>Yes</td>\n",
       "      <td>How widely used or impactful my work output wo...</td>\n",
       "      <td>I had a negative experience or interaction at ...</td>\n",
       "      <td>AED</td>\n",
       "      <td>United Arab Emirates dirham</td>\n",
       "      <td>648838511.0</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>1000000.0</td>\n",
       "      <td>168.0</td>\n",
       "      <td>There is a schedule and/or spec (made by me or...</td>\n",
       "      <td>Being tasked with non-development work</td>\n",
       "      <td>It's complicated</td>\n",
       "      <td>Other place, such as a coworking space or cafe</td>\n",
       "      <td>Far below average</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;Other(s):</td>\n",
       "      <td>Bash/Shell/PowerShell;TypeScript</td>\n",
       "      <td>MySQL</td>\n",
       "      <td>MySQL</td>\n",
       "      <td>Android;iOS;Windows;WordPress;Other(s):</td>\n",
       "      <td>Android;iOS;Windows;WordPress;Other(s):</td>\n",
       "      <td>Angular/Angular.js;Express;jQuery;Laravel;Othe...</td>\n",
       "      <td>Angular/Angular.js;Express;jQuery;Laravel;Othe...</td>\n",
       "      <td>Ansible;Apache Spark;Torch/PyTorch</td>\n",
       "      <td>Apache Spark;Torch/PyTorch</td>\n",
       "      <td>Android Studio;Atom;Coda;Eclipse;Emacs;IPython...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>Outside of work, for personal projects</td>\n",
       "      <td>Accepting Bitcoin or other coins and tokens as...</td>\n",
       "      <td>Useful across many domains and could change ma...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I don't use social media</td>\n",
       "      <td>Online</td>\n",
       "      <td>UserID</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I have never visited Stack Overflow (before to...</td>\n",
       "      <td>Find answers to specific questions</td>\n",
       "      <td>Less than once per week</td>\n",
       "      <td>Stack Overflow was much faster</td>\n",
       "      <td>0-10 minutes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No, I didn't know that Stack Overflow had a jo...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No, not at all</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Tech articles written by other developers</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Too short</td>\n",
       "      <td>Easy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85715</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>No</td>\n",
       "      <td>Less than once per year</td>\n",
       "      <td>The quality of OSS and closed source software ...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>No</td>\n",
       "      <td>Bachelor’s degree (BA, BS, B.Eng., etc.)</td>\n",
       "      <td>Information systems, information technology, o...</td>\n",
       "      <td>Received on-the-job training in software devel...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Developer, back-end</td>\n",
       "      <td>8</td>\n",
       "      <td>20</td>\n",
       "      <td>4</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Slightly satisfied</td>\n",
       "      <td>Somewhat confident</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>1-2 years ago</td>\n",
       "      <td>Write code by hand (e.g., on a whiteboard);Int...</td>\n",
       "      <td>No</td>\n",
       "      <td>Financial performance or funding status of the...</td>\n",
       "      <td>I was preparing for a job search</td>\n",
       "      <td>AFN</td>\n",
       "      <td>Afghan afghani</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>NaN</td>\n",
       "      <td>48.0</td>\n",
       "      <td>There is a schedule and/or spec (made by me or...</td>\n",
       "      <td>Distracting work environment;Non-work commitme...</td>\n",
       "      <td>Less than once per month / Never</td>\n",
       "      <td>Office</td>\n",
       "      <td>A little above average</td>\n",
       "      <td>Yes, because I see value in code review</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Yes, it's not part of our process but the deve...</td>\n",
       "      <td>Developers and management have nearly equal in...</td>\n",
       "      <td>I have some influence</td>\n",
       "      <td>HTML/CSS;JavaScript;PHP;TypeScript</td>\n",
       "      <td>HTML/CSS;JavaScript;PHP;SQL;TypeScript</td>\n",
       "      <td>MariaDB;MongoDB;MySQL</td>\n",
       "      <td>MariaDB;MongoDB;Microsoft SQL Server;MySQL;Ora...</td>\n",
       "      <td>Linux;Windows;WordPress</td>\n",
       "      <td>Android;AWS;Linux;Windows</td>\n",
       "      <td>jQuery;Laravel</td>\n",
       "      <td>Express;Laravel</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>.NET Core;Node.js;React Native</td>\n",
       "      <td>Notepad++;PHPStorm;Sublime Text;Visual Studio ...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>I do not use containers</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Facebook</td>\n",
       "      <td>Online</td>\n",
       "      <td>Username</td>\n",
       "      <td>I don't remember</td>\n",
       "      <td>Multiple times per day</td>\n",
       "      <td>Find answers to specific questions</td>\n",
       "      <td>3-5 times per week</td>\n",
       "      <td>Stack Overflow was much faster</td>\n",
       "      <td>11-30 minutes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I have never participated in Q&amp;A on Stack Over...</td>\n",
       "      <td>No, I knew that Stack Overflow had a job board...</td>\n",
       "      <td>No, and I don't know what those are</td>\n",
       "      <td>Not sure</td>\n",
       "      <td>Somewhat less welcome now than last year</td>\n",
       "      <td>Tech articles written by other developers;Indu...</td>\n",
       "      <td>28.0</td>\n",
       "      <td>Man</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Too long</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                MainBranch Hobbyist              OpenSourcer  \\\n",
       "Respondent                                                                     \n",
       "39258       I am a developer by profession      Yes  Less than once per year   \n",
       "63129       I am a developer by profession      Yes                    Never   \n",
       "85715       I am a developer by profession       No  Less than once per year   \n",
       "\n",
       "                                                   OpenSource  \\\n",
       "Respondent                                                      \n",
       "39258       OSS is, on average, of LOWER quality than prop...   \n",
       "63129       OSS is, on average, of HIGHER quality than pro...   \n",
       "85715       The quality of OSS and closed source software ...   \n",
       "\n",
       "                    Employment      Country         Student  \\\n",
       "Respondent                                                    \n",
       "39258       Employed full-time  Afghanistan              No   \n",
       "63129       Employed full-time  Afghanistan  Yes, full-time   \n",
       "85715       Employed full-time  Afghanistan              No   \n",
       "\n",
       "                                             EdLevel  \\\n",
       "Respondent                                             \n",
       "39258       Bachelor’s degree (BA, BS, B.Eng., etc.)   \n",
       "63129         I never completed any formal education   \n",
       "85715       Bachelor’s degree (BA, BS, B.Eng., etc.)   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "39258       Computer science, computer engineering, or sof...   \n",
       "63129                                                     NaN   \n",
       "85715       Information systems, information technology, o...   \n",
       "\n",
       "                                                     EduOther  \\\n",
       "Respondent                                                      \n",
       "39258       Taken an online course in programming or softw...   \n",
       "63129       Taken an online course in programming or softw...   \n",
       "85715       Received on-the-job training in software devel...   \n",
       "\n",
       "                                                      OrgSize  \\\n",
       "Respondent                                                      \n",
       "39258                                    100 to 499 employees   \n",
       "63129       Just me - I am a freelancer, sole proprietor, ...   \n",
       "85715                                                     NaN   \n",
       "\n",
       "                                                      DevType  \\\n",
       "Respondent                                                      \n",
       "39258       Database administrator;Designer;Developer, bac...   \n",
       "63129                                                     NaN   \n",
       "85715                                     Developer, back-end   \n",
       "\n",
       "                   YearsCode            Age1stCode YearsCodePro  \\\n",
       "Respondent                                                        \n",
       "39258                      2                    22            1   \n",
       "63129       Less than 1 year  Younger than 5 years            1   \n",
       "85715                      8                    20            4   \n",
       "\n",
       "                    CareerSat              JobSat            MgrIdiot  \\\n",
       "Respondent                                                              \n",
       "39258          Very satisfied      Very satisfied      Very confident   \n",
       "63129       Very dissatisfied   Very dissatisfied      Very confident   \n",
       "85715          Very satisfied  Slightly satisfied  Somewhat confident   \n",
       "\n",
       "           MgrMoney MgrWant  \\\n",
       "Respondent                    \n",
       "39258            No     Yes   \n",
       "63129           Yes     Yes   \n",
       "85715           Yes     Yes   \n",
       "\n",
       "                                                      JobSeek  \\\n",
       "Respondent                                                      \n",
       "39258       I’m not actively looking, but I am open to new...   \n",
       "63129                         I am actively looking for a job   \n",
       "85715       I’m not actively looking, but I am open to new...   \n",
       "\n",
       "                    LastHireDate  \\\n",
       "Respondent                         \n",
       "39258              1-2 years ago   \n",
       "63129       I've never had a job   \n",
       "85715              1-2 years ago   \n",
       "\n",
       "                                                      LastInt FizzBuzz  \\\n",
       "Respondent                                                               \n",
       "39258       Write code by hand (e.g., on a whiteboard);Int...       No   \n",
       "63129                                          Write any code      Yes   \n",
       "85715       Write code by hand (e.g., on a whiteboard);Int...       No   \n",
       "\n",
       "                                                   JobFactors  \\\n",
       "Respondent                                                      \n",
       "39258       Languages, frameworks, and other technologies ...   \n",
       "63129       How widely used or impactful my work output wo...   \n",
       "85715       Financial performance or funding status of the...   \n",
       "\n",
       "                                                 ResumeUpdate CurrencySymbol  \\\n",
       "Respondent                                                                     \n",
       "39258       Something else changed (education, award, medi...            AFN   \n",
       "63129       I had a negative experience or interaction at ...            AED   \n",
       "85715                        I was preparing for a job search            AFN   \n",
       "\n",
       "                           CurrencyDesc    CompTotal CompFreq  ConvertedComp  \\\n",
       "Respondent                                                                     \n",
       "39258                    Afghan afghani     120000.0  Monthly        19152.0   \n",
       "63129       United Arab Emirates dirham  648838511.0  Monthly      1000000.0   \n",
       "85715                    Afghan afghani          NaN  Monthly            NaN   \n",
       "\n",
       "            WorkWeekHrs                                           WorkPlan  \\\n",
       "Respondent                                                                   \n",
       "39258              49.0  There is a schedule and/or spec (made by me or...   \n",
       "63129             168.0  There is a schedule and/or spec (made by me or...   \n",
       "85715              48.0  There is a schedule and/or spec (made by me or...   \n",
       "\n",
       "                                                WorkChallenge  \\\n",
       "Respondent                                                      \n",
       "39258       Not enough people for the workload;Time spent ...   \n",
       "63129                  Being tasked with non-development work   \n",
       "85715       Distracting work environment;Non-work commitme...   \n",
       "\n",
       "                                  WorkRemote  \\\n",
       "Respondent                                     \n",
       "39258       Less than once per month / Never   \n",
       "63129                       It's complicated   \n",
       "85715       Less than once per month / Never   \n",
       "\n",
       "                                                   WorkLoc  \\\n",
       "Respondent                                                   \n",
       "39258                                               Office   \n",
       "63129       Other place, such as a coworking space or cafe   \n",
       "85715                                               Office   \n",
       "\n",
       "                            ImpSyn                                  CodeRev  \\\n",
       "Respondent                                                                    \n",
       "39258            Far above average  Yes, because I see value in code review   \n",
       "63129            Far below average                                       No   \n",
       "85715       A little above average  Yes, because I see value in code review   \n",
       "\n",
       "            CodeRevHrs                                          UnitTests  \\\n",
       "Respondent                                                                  \n",
       "39258             10.0  Yes, it's not part of our process but the deve...   \n",
       "63129              NaN                                                NaN   \n",
       "85715              5.0  Yes, it's not part of our process but the deve...   \n",
       "\n",
       "                                                  PurchaseHow  \\\n",
       "Respondent                                                      \n",
       "39258       Developers typically have the most influence o...   \n",
       "63129                                                     NaN   \n",
       "85715       Developers and management have nearly equal in...   \n",
       "\n",
       "                     PurchaseWhat                        LanguageWorkedWith  \\\n",
       "Respondent                                                                    \n",
       "39258       I have some influence    HTML/CSS;JavaScript;PHP;SQL;TypeScript   \n",
       "63129                         NaN  Assembly;Bash/Shell/PowerShell;Other(s):   \n",
       "85715       I have some influence        HTML/CSS;JavaScript;PHP;TypeScript   \n",
       "\n",
       "                            LanguageDesireNextYear  \\\n",
       "Respondent                                           \n",
       "39258            C#;Dart;JavaScript;SQL;TypeScript   \n",
       "63129             Bash/Shell/PowerShell;TypeScript   \n",
       "85715       HTML/CSS;JavaScript;PHP;SQL;TypeScript   \n",
       "\n",
       "                          DatabaseWorkedWith  \\\n",
       "Respondent                                     \n",
       "39258       MariaDB;MongoDB;MySQL;PostgreSQL   \n",
       "63129                                  MySQL   \n",
       "85715                  MariaDB;MongoDB;MySQL   \n",
       "\n",
       "                                       DatabaseDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "39258                Couchbase;Firebase;MariaDB;MongoDB;Redis   \n",
       "63129                                                   MySQL   \n",
       "85715       MariaDB;MongoDB;Microsoft SQL Server;MySQL;Ora...   \n",
       "\n",
       "                                 PlatformWorkedWith  \\\n",
       "Respondent                                            \n",
       "39258           Android;AWS;Linux;Windows;WordPress   \n",
       "63129       Android;iOS;Windows;WordPress;Other(s):   \n",
       "85715                       Linux;Windows;WordPress   \n",
       "\n",
       "                                       PlatformDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "39258       Android;AWS;Docker;Heroku;iOS;Linux;Raspberry ...   \n",
       "63129                 Android;iOS;Windows;WordPress;Other(s):   \n",
       "85715                               Android;AWS;Linux;Windows   \n",
       "\n",
       "                                           WebFrameWorkedWith  \\\n",
       "Respondent                                                      \n",
       "39258               Angular/Angular.js;Drupal;Express;Laravel   \n",
       "63129       Angular/Angular.js;Express;jQuery;Laravel;Othe...   \n",
       "85715                                          jQuery;Laravel   \n",
       "\n",
       "                                       WebFrameDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "39258                       Angular/Angular.js;Drupal;Express   \n",
       "63129       Angular/Angular.js;Express;jQuery;Laravel;Othe...   \n",
       "85715                                         Express;Laravel   \n",
       "\n",
       "                            MiscTechWorkedWith  \\\n",
       "Respondent                                       \n",
       "39258                          Cordova;Node.js   \n",
       "63129       Ansible;Apache Spark;Torch/PyTorch   \n",
       "85715                                  Node.js   \n",
       "\n",
       "                    MiscTechDesireNextYear  \\\n",
       "Respondent                                   \n",
       "39258                       Hadoop;Node.js   \n",
       "63129           Apache Spark;Torch/PyTorch   \n",
       "85715       .NET Core;Node.js;React Native   \n",
       "\n",
       "                                                   DevEnviron        OpSys  \\\n",
       "Respondent                                                                   \n",
       "39258               Notepad++;PHPStorm;Vim;Visual Studio Code  Linux-based   \n",
       "63129       Android Studio;Atom;Coda;Eclipse;Emacs;IPython...      Windows   \n",
       "85715       Notepad++;PHPStorm;Sublime Text;Visual Studio ...      Windows   \n",
       "\n",
       "                                        Containers  \\\n",
       "Respondent                                           \n",
       "39258                                   Production   \n",
       "63129       Outside of work, for personal projects   \n",
       "85715                      I do not use containers   \n",
       "\n",
       "                                                BlockchainOrg  \\\n",
       "Respondent                                                      \n",
       "39258                                                     NaN   \n",
       "63129       Accepting Bitcoin or other coins and tokens as...   \n",
       "85715                                                     NaN   \n",
       "\n",
       "                                                 BlockchainIs BetterLife  \\\n",
       "Respondent                                                                 \n",
       "39258                                                     NaN        Yes   \n",
       "63129       Useful across many domains and could change ma...        Yes   \n",
       "85715                                                     NaN         No   \n",
       "\n",
       "           ITperson OffOn               SocialMedia Extraversion ScreenName  \\\n",
       "Respondent                                                                    \n",
       "39258           Yes    No                  Facebook       Online      Login   \n",
       "63129           Yes   Yes  I don't use social media       Online     UserID   \n",
       "85715           Yes   Yes                  Facebook       Online   Username   \n",
       "\n",
       "                  SOVisit1st  \\\n",
       "Respondent                     \n",
       "39258                   2016   \n",
       "63129                    NaN   \n",
       "85715       I don't remember   \n",
       "\n",
       "                                                  SOVisitFreq  \\\n",
       "Respondent                                                      \n",
       "39258                                    A few times per week   \n",
       "63129       I have never visited Stack Overflow (before to...   \n",
       "85715                                  Multiple times per day   \n",
       "\n",
       "                                                    SOVisitTo  \\\n",
       "Respondent                                                      \n",
       "39258       Find answers to specific questions;Learn how t...   \n",
       "63129                      Find answers to specific questions   \n",
       "85715                      Find answers to specific questions   \n",
       "\n",
       "                       SOFindAnswer                     SOTimeSaved  \\\n",
       "Respondent                                                            \n",
       "39258            1-2 times per week  Stack Overflow was much faster   \n",
       "63129       Less than once per week  Stack Overflow was much faster   \n",
       "85715            3-5 times per week  Stack Overflow was much faster   \n",
       "\n",
       "            SOHowMuchTime SOAccount  \\\n",
       "Respondent                            \n",
       "39258        0-10 minutes       Yes   \n",
       "63129        0-10 minutes       NaN   \n",
       "85715       11-30 minutes       Yes   \n",
       "\n",
       "                                                   SOPartFreq  \\\n",
       "Respondent                                                      \n",
       "39258                     Less than once per month or monthly   \n",
       "63129                                                     NaN   \n",
       "85715       I have never participated in Q&A on Stack Over...   \n",
       "\n",
       "                                                       SOJobs  \\\n",
       "Respondent                                                      \n",
       "39258                                                     Yes   \n",
       "63129       No, I didn't know that Stack Overflow had a jo...   \n",
       "85715       No, I knew that Stack Overflow had a job board...   \n",
       "\n",
       "                                       EntTeams          SOComm  \\\n",
       "Respondent                                                        \n",
       "39258                                       NaN   Yes, somewhat   \n",
       "63129                                       NaN  No, not at all   \n",
       "85715       No, and I don't know what those are        Not sure   \n",
       "\n",
       "                                       WelcomeChange  \\\n",
       "Respondent                                             \n",
       "39258                                            NaN   \n",
       "63129                                            NaN   \n",
       "85715       Somewhat less welcome now than last year   \n",
       "\n",
       "                                                 SONewContent   Age Gender  \\\n",
       "Respondent                                                                   \n",
       "39258       Tech articles written by other developers;Indu...  26.0    Man   \n",
       "63129               Tech articles written by other developers   NaN    NaN   \n",
       "85715       Tech articles written by other developers;Indu...  28.0    Man   \n",
       "\n",
       "           Trans                Sexuality               Ethnicity Dependents  \\\n",
       "Respondent                                                                     \n",
       "39258         No  Straight / Heterosexual  East Asian;South Asian        Yes   \n",
       "63129        NaN                      NaN                     NaN        Yes   \n",
       "85715         No                      NaN                     NaN        Yes   \n",
       "\n",
       "           SurveyLength                  SurveyEase  \n",
       "Respondent                                           \n",
       "39258          Too long                        Easy  \n",
       "63129         Too short                        Easy  \n",
       "85715          Too long  Neither easy nor difficult  "
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by=['Country']).head(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 85,
   "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>ConvertedComp</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>63129</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>1000000.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50499</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>153216.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39258</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>19152.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58450</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>17556.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7085</th>\n",
       "      <td>Afghanistan</td>\n",
       "      <td>14364.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                Country  ConvertedComp\n",
       "Respondent                            \n",
       "63129       Afghanistan      1000000.0\n",
       "50499       Afghanistan       153216.0\n",
       "39258       Afghanistan        19152.0\n",
       "58450       Afghanistan        17556.0\n",
       "7085        Afghanistan        14364.0"
      ]
     },
     "execution_count": 85,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by= ['Country', 'ConvertedComp'], ascending=[True, False], inplace=True)\n",
    "df[['Country', 'ConvertedComp']].head(5)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "we can  get the 3 largest in an column with `.nlargest(10)` method\n",
    "and smalles with `nsmallest(10)` method"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "25983    2000000.0\n",
       "87896    2000000.0\n",
       "22013    2000000.0\n",
       "Name: ConvertedComp, dtype: float64"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['ConvertedComp'].nlargest(3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Respondent\n",
       "722      0.0\n",
       "28638    0.0\n",
       "13825    0.0\n",
       "Name: ConvertedComp, dtype: float64"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['ConvertedComp'].nsmallest(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "we can get the realted details like this"
   ]
  },
  {
   "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>MainBranch</th>\n",
       "      <th>Hobbyist</th>\n",
       "      <th>OpenSourcer</th>\n",
       "      <th>OpenSource</th>\n",
       "      <th>Employment</th>\n",
       "      <th>Country</th>\n",
       "      <th>Student</th>\n",
       "      <th>EdLevel</th>\n",
       "      <th>UndergradMajor</th>\n",
       "      <th>EduOther</th>\n",
       "      <th>OrgSize</th>\n",
       "      <th>DevType</th>\n",
       "      <th>YearsCode</th>\n",
       "      <th>Age1stCode</th>\n",
       "      <th>YearsCodePro</th>\n",
       "      <th>CareerSat</th>\n",
       "      <th>JobSat</th>\n",
       "      <th>MgrIdiot</th>\n",
       "      <th>MgrMoney</th>\n",
       "      <th>MgrWant</th>\n",
       "      <th>JobSeek</th>\n",
       "      <th>LastHireDate</th>\n",
       "      <th>LastInt</th>\n",
       "      <th>FizzBuzz</th>\n",
       "      <th>JobFactors</th>\n",
       "      <th>ResumeUpdate</th>\n",
       "      <th>CurrencySymbol</th>\n",
       "      <th>CurrencyDesc</th>\n",
       "      <th>CompTotal</th>\n",
       "      <th>CompFreq</th>\n",
       "      <th>ConvertedComp</th>\n",
       "      <th>WorkWeekHrs</th>\n",
       "      <th>WorkPlan</th>\n",
       "      <th>WorkChallenge</th>\n",
       "      <th>WorkRemote</th>\n",
       "      <th>WorkLoc</th>\n",
       "      <th>ImpSyn</th>\n",
       "      <th>CodeRev</th>\n",
       "      <th>CodeRevHrs</th>\n",
       "      <th>UnitTests</th>\n",
       "      <th>PurchaseHow</th>\n",
       "      <th>PurchaseWhat</th>\n",
       "      <th>LanguageWorkedWith</th>\n",
       "      <th>LanguageDesireNextYear</th>\n",
       "      <th>DatabaseWorkedWith</th>\n",
       "      <th>DatabaseDesireNextYear</th>\n",
       "      <th>PlatformWorkedWith</th>\n",
       "      <th>PlatformDesireNextYear</th>\n",
       "      <th>WebFrameWorkedWith</th>\n",
       "      <th>WebFrameDesireNextYear</th>\n",
       "      <th>MiscTechWorkedWith</th>\n",
       "      <th>MiscTechDesireNextYear</th>\n",
       "      <th>DevEnviron</th>\n",
       "      <th>OpSys</th>\n",
       "      <th>Containers</th>\n",
       "      <th>BlockchainOrg</th>\n",
       "      <th>BlockchainIs</th>\n",
       "      <th>BetterLife</th>\n",
       "      <th>ITperson</th>\n",
       "      <th>OffOn</th>\n",
       "      <th>SocialMedia</th>\n",
       "      <th>Extraversion</th>\n",
       "      <th>ScreenName</th>\n",
       "      <th>SOVisit1st</th>\n",
       "      <th>SOVisitFreq</th>\n",
       "      <th>SOVisitTo</th>\n",
       "      <th>SOFindAnswer</th>\n",
       "      <th>SOTimeSaved</th>\n",
       "      <th>SOHowMuchTime</th>\n",
       "      <th>SOAccount</th>\n",
       "      <th>SOPartFreq</th>\n",
       "      <th>SOJobs</th>\n",
       "      <th>EntTeams</th>\n",
       "      <th>SOComm</th>\n",
       "      <th>WelcomeChange</th>\n",
       "      <th>SONewContent</th>\n",
       "      <th>Age</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Trans</th>\n",
       "      <th>Sexuality</th>\n",
       "      <th>Ethnicity</th>\n",
       "      <th>Dependents</th>\n",
       "      <th>SurveyLength</th>\n",
       "      <th>SurveyEase</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",
       "      <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",
       "      <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",
       "      <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>25983</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Less than once per year</td>\n",
       "      <td>OSS is, on average, of HIGHER quality than pro...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>Canada</td>\n",
       "      <td>No</td>\n",
       "      <td>Bachelor’s degree (BA, BS, B.Eng., etc.)</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Received on-the-job training in software devel...</td>\n",
       "      <td>10,000 or more employees</td>\n",
       "      <td>Developer, full-stack</td>\n",
       "      <td>8</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Somewhat confident</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I’m not actively looking, but I am open to new...</td>\n",
       "      <td>3-4 years ago</td>\n",
       "      <td>Solve a brain-teaser style puzzle;Interview wi...</td>\n",
       "      <td>No</td>\n",
       "      <td>Remote work options;Opportunities for professi...</td>\n",
       "      <td>My job status changed (promotion, new job, etc.)</td>\n",
       "      <td>USD</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>65500.0</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>45.0</td>\n",
       "      <td>There is a schedule and/or spec (made by me or...</td>\n",
       "      <td>Being tasked with non-development work;Meeting...</td>\n",
       "      <td>A few days each month</td>\n",
       "      <td>Office</td>\n",
       "      <td>Average</td>\n",
       "      <td>Yes, because I see value in code review</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Yes, it's part of our process</td>\n",
       "      <td>Developers and management have nearly equal in...</td>\n",
       "      <td>I have little or no influence</td>\n",
       "      <td>Bash/Shell/PowerShell;C++;C#;HTML/CSS;JavaScri...</td>\n",
       "      <td>Bash/Shell/PowerShell;C#;F#;Python;SQL;TypeScript</td>\n",
       "      <td>Microsoft SQL Server;MySQL</td>\n",
       "      <td>Microsoft SQL Server;MySQL</td>\n",
       "      <td>AWS;Docker;Heroku;Linux;MacOS;Raspberry Pi;Win...</td>\n",
       "      <td>AWS;Docker;Linux;MacOS;Windows</td>\n",
       "      <td>Angular/Angular.js</td>\n",
       "      <td>Angular/Angular.js;Flask;React.js</td>\n",
       "      <td>.NET;.NET Core;Node.js</td>\n",
       "      <td>.NET Core;Node.js</td>\n",
       "      <td>Notepad++;Sublime Text;Vim;Visual Studio;Visua...</td>\n",
       "      <td>Windows</td>\n",
       "      <td>Development;Production</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Useful for decentralized currency (i.e., Bitcoin)</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Reddit</td>\n",
       "      <td>In real life (in person)</td>\n",
       "      <td>Username</td>\n",
       "      <td>2013</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Find answers to specific questions;Learn how t...</td>\n",
       "      <td>1-2 times per week</td>\n",
       "      <td>Stack Overflow was much faster</td>\n",
       "      <td>11-30 minutes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>No, I knew that Stack Overflow had a job board...</td>\n",
       "      <td>No, and I don't know what those are</td>\n",
       "      <td>No, not really</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>NaN</td>\n",
       "      <td>24.0</td>\n",
       "      <td>Man</td>\n",
       "      <td>No</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>No</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>Easy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87896</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Less than once per year</td>\n",
       "      <td>The quality of OSS and closed source software ...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>Germany</td>\n",
       "      <td>No</td>\n",
       "      <td>Bachelor’s degree (BA, BS, B.Eng., etc.)</td>\n",
       "      <td>Computer science, computer engineering, or sof...</td>\n",
       "      <td>Taken an online course in programming or softw...</td>\n",
       "      <td>2-9 employees</td>\n",
       "      <td>Developer, full-stack</td>\n",
       "      <td>9</td>\n",
       "      <td>17</td>\n",
       "      <td>8</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Somewhat confident</td>\n",
       "      <td>No</td>\n",
       "      <td>I am already a manager</td>\n",
       "      <td>I am not interested in new job opportunities</td>\n",
       "      <td>More than 4 years ago</td>\n",
       "      <td>Write any code;Interview with people in senior...</td>\n",
       "      <td>No</td>\n",
       "      <td>Office environment or company culture;Diversit...</td>\n",
       "      <td>Something else changed (education, award, medi...</td>\n",
       "      <td>USD</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>55000.0</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>There is a schedule and/or spec (made by me or...</td>\n",
       "      <td>Being tasked with non-development work;Meeting...</td>\n",
       "      <td>All or almost all the time (I'm full-time remote)</td>\n",
       "      <td>Home</td>\n",
       "      <td>A little above average</td>\n",
       "      <td>Yes, because I see value in code review</td>\n",
       "      <td>3.0</td>\n",
       "      <td>No, but I think we should</td>\n",
       "      <td>Developers and management have nearly equal in...</td>\n",
       "      <td>I have a great deal of influence</td>\n",
       "      <td>HTML/CSS;JavaScript;PHP;SQL</td>\n",
       "      <td>HTML/CSS;JavaScript;PHP;Ruby;SQL;TypeScript</td>\n",
       "      <td>MariaDB;MySQL;PostgreSQL</td>\n",
       "      <td>MariaDB;MySQL;PostgreSQL</td>\n",
       "      <td>WordPress</td>\n",
       "      <td>NaN</td>\n",
       "      <td>jQuery;Laravel;Vue.js</td>\n",
       "      <td>Express;Laravel;Ruby on Rails;Vue.js</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Node.js</td>\n",
       "      <td>Sublime Text;Vim;Visual Studio Code</td>\n",
       "      <td>Linux-based</td>\n",
       "      <td>I do not use containers</td>\n",
       "      <td>Not at all</td>\n",
       "      <td>Useful for immutable record keeping outside of...</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Twitter</td>\n",
       "      <td>Online</td>\n",
       "      <td>Handle</td>\n",
       "      <td>2011</td>\n",
       "      <td>Daily or almost daily</td>\n",
       "      <td>Find answers to specific questions</td>\n",
       "      <td>3-5 times per week</td>\n",
       "      <td>Stack Overflow was much faster</td>\n",
       "      <td>0-10 minutes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Less than once per month or monthly</td>\n",
       "      <td>No, I knew that Stack Overflow had a job board...</td>\n",
       "      <td>No, I've heard of them, but I am not part of a...</td>\n",
       "      <td>No, not really</td>\n",
       "      <td>Just as welcome now as I felt last year</td>\n",
       "      <td>Tech articles written by other developers;Tech...</td>\n",
       "      <td>32.0</td>\n",
       "      <td>Man</td>\n",
       "      <td>No</td>\n",
       "      <td>Gay or Lesbian</td>\n",
       "      <td>White or of European descent</td>\n",
       "      <td>No</td>\n",
       "      <td>Appropriate in length</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22013</th>\n",
       "      <td>I am a developer by profession</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Never</td>\n",
       "      <td>The quality of OSS and closed source software ...</td>\n",
       "      <td>Employed full-time</td>\n",
       "      <td>India</td>\n",
       "      <td>No</td>\n",
       "      <td>Professional degree (JD, MD, etc.)</td>\n",
       "      <td>A natural science (ex. biology, chemistry, phy...</td>\n",
       "      <td>Taken an online course in programming or softw...</td>\n",
       "      <td>2-9 employees</td>\n",
       "      <td>Academic researcher;Data scientist or machine ...</td>\n",
       "      <td>3</td>\n",
       "      <td>26</td>\n",
       "      <td>3</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>Very satisfied</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I am not interested in new job opportunities</td>\n",
       "      <td>3-4 years ago</td>\n",
       "      <td>Write code by hand (e.g., on a whiteboard);Com...</td>\n",
       "      <td>No</td>\n",
       "      <td>Financial performance or funding status of the...</td>\n",
       "      <td>Something else changed (education, award, medi...</td>\n",
       "      <td>USD</td>\n",
       "      <td>United States dollar</td>\n",
       "      <td>1500000.0</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>2000000.0</td>\n",
       "      <td>50.0</td>\n",
       "      <td>There's no schedule or spec; I work on what se...</td>\n",
       "      <td>Inadequate access to necessary tools;Meetings;...</td>\n",
       "      <td>All or almost all the time (I'm full-time remote)</td>\n",
       "      <td>Home</td>\n",
       "      <td>A little below average</td>\n",
       "      <td>Yes, because I see value in code review</td>\n",
       "      <td>10.0</td>\n",
       "      <td>Yes, it's part of our process</td>\n",
       "      <td>Developers typically have the most influence o...</td>\n",
       "      <td>I have a great deal of influence</td>\n",
       "      <td>Assembly;Bash/Shell/PowerShell;C;C++;Java;Java...</td>\n",
       "      <td>Python;Swift</td>\n",
       "      <td>Cassandra;Microsoft SQL Server;Oracle</td>\n",
       "      <td>Cassandra</td>\n",
       "      <td>Android;Arduino;Google Cloud Platform;IBM Clou...</td>\n",
       "      <td>IBM Cloud or Watson;Windows</td>\n",
       "      <td>jQuery</td>\n",
       "      <td>NaN</td>\n",
       "      <td>TensorFlow</td>\n",
       "      <td>TensorFlow</td>\n",
       "      <td>Visual Studio;Visual Studio Code</td>\n",
       "      <td>Windows</td>\n",
       "      <td>Development</td>\n",
       "      <td>Implementing our own cryptocurrency</td>\n",
       "      <td>Useful across many domains and could change ma...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>YouTube</td>\n",
       "      <td>Online</td>\n",
       "      <td>Screen Name</td>\n",
       "      <td>NaN</td>\n",
       "      <td>A few times per week</td>\n",
       "      <td>Find answers to specific questions</td>\n",
       "      <td>1-2 times per week</td>\n",
       "      <td>Stack Overflow was much faster</td>\n",
       "      <td>60+ minutes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I have never participated in Q&amp;A on Stack Over...</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, definitely</td>\n",
       "      <td>A lot more welcome now than last year</td>\n",
       "      <td>Tech articles written by other developers;Indu...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Man</td>\n",
       "      <td>No</td>\n",
       "      <td>Straight / Heterosexual</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Too long</td>\n",
       "      <td>Easy</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                MainBranch Hobbyist              OpenSourcer  \\\n",
       "Respondent                                                                     \n",
       "25983       I am a developer by profession      Yes  Less than once per year   \n",
       "87896       I am a developer by profession      Yes  Less than once per year   \n",
       "22013       I am a developer by profession      Yes                    Never   \n",
       "\n",
       "                                                   OpenSource  \\\n",
       "Respondent                                                      \n",
       "25983       OSS is, on average, of HIGHER quality than pro...   \n",
       "87896       The quality of OSS and closed source software ...   \n",
       "22013       The quality of OSS and closed source software ...   \n",
       "\n",
       "                    Employment  Country Student  \\\n",
       "Respondent                                        \n",
       "25983       Employed full-time   Canada      No   \n",
       "87896       Employed full-time  Germany      No   \n",
       "22013       Employed full-time    India      No   \n",
       "\n",
       "                                             EdLevel  \\\n",
       "Respondent                                             \n",
       "25983       Bachelor’s degree (BA, BS, B.Eng., etc.)   \n",
       "87896       Bachelor’s degree (BA, BS, B.Eng., etc.)   \n",
       "22013             Professional degree (JD, MD, etc.)   \n",
       "\n",
       "                                               UndergradMajor  \\\n",
       "Respondent                                                      \n",
       "25983       Computer science, computer engineering, or sof...   \n",
       "87896       Computer science, computer engineering, or sof...   \n",
       "22013       A natural science (ex. biology, chemistry, phy...   \n",
       "\n",
       "                                                     EduOther  \\\n",
       "Respondent                                                      \n",
       "25983       Received on-the-job training in software devel...   \n",
       "87896       Taken an online course in programming or softw...   \n",
       "22013       Taken an online course in programming or softw...   \n",
       "\n",
       "                             OrgSize  \\\n",
       "Respondent                             \n",
       "25983       10,000 or more employees   \n",
       "87896                  2-9 employees   \n",
       "22013                  2-9 employees   \n",
       "\n",
       "                                                      DevType YearsCode  \\\n",
       "Respondent                                                                \n",
       "25983                                   Developer, full-stack         8   \n",
       "87896                                   Developer, full-stack         9   \n",
       "22013       Academic researcher;Data scientist or machine ...         3   \n",
       "\n",
       "           Age1stCode YearsCodePro       CareerSat          JobSat  \\\n",
       "Respondent                                                           \n",
       "25983              16            2  Very satisfied  Very satisfied   \n",
       "87896              17            8  Very satisfied  Very satisfied   \n",
       "22013              26            3  Very satisfied  Very satisfied   \n",
       "\n",
       "                      MgrIdiot MgrMoney                 MgrWant  \\\n",
       "Respondent                                                        \n",
       "25983       Somewhat confident       No                      No   \n",
       "87896       Somewhat confident       No  I am already a manager   \n",
       "22013                      NaN      NaN                     NaN   \n",
       "\n",
       "                                                      JobSeek  \\\n",
       "Respondent                                                      \n",
       "25983       I’m not actively looking, but I am open to new...   \n",
       "87896            I am not interested in new job opportunities   \n",
       "22013            I am not interested in new job opportunities   \n",
       "\n",
       "                     LastHireDate  \\\n",
       "Respondent                          \n",
       "25983               3-4 years ago   \n",
       "87896       More than 4 years ago   \n",
       "22013               3-4 years ago   \n",
       "\n",
       "                                                      LastInt FizzBuzz  \\\n",
       "Respondent                                                               \n",
       "25983       Solve a brain-teaser style puzzle;Interview wi...       No   \n",
       "87896       Write any code;Interview with people in senior...       No   \n",
       "22013       Write code by hand (e.g., on a whiteboard);Com...       No   \n",
       "\n",
       "                                                   JobFactors  \\\n",
       "Respondent                                                      \n",
       "25983       Remote work options;Opportunities for professi...   \n",
       "87896       Office environment or company culture;Diversit...   \n",
       "22013       Financial performance or funding status of the...   \n",
       "\n",
       "                                                 ResumeUpdate CurrencySymbol  \\\n",
       "Respondent                                                                     \n",
       "25983        My job status changed (promotion, new job, etc.)            USD   \n",
       "87896       Something else changed (education, award, medi...            USD   \n",
       "22013       Something else changed (education, award, medi...            USD   \n",
       "\n",
       "                    CurrencyDesc  CompTotal CompFreq  ConvertedComp  \\\n",
       "Respondent                                                            \n",
       "25983       United States dollar    65500.0   Weekly      2000000.0   \n",
       "87896       United States dollar    55000.0   Weekly      2000000.0   \n",
       "22013       United States dollar  1500000.0   Weekly      2000000.0   \n",
       "\n",
       "            WorkWeekHrs                                           WorkPlan  \\\n",
       "Respondent                                                                   \n",
       "25983              45.0  There is a schedule and/or spec (made by me or...   \n",
       "87896              40.0  There is a schedule and/or spec (made by me or...   \n",
       "22013              50.0  There's no schedule or spec; I work on what se...   \n",
       "\n",
       "                                                WorkChallenge  \\\n",
       "Respondent                                                      \n",
       "25983       Being tasked with non-development work;Meeting...   \n",
       "87896       Being tasked with non-development work;Meeting...   \n",
       "22013       Inadequate access to necessary tools;Meetings;...   \n",
       "\n",
       "                                                   WorkRemote WorkLoc  \\\n",
       "Respondent                                                              \n",
       "25983                                   A few days each month  Office   \n",
       "87896       All or almost all the time (I'm full-time remote)    Home   \n",
       "22013       All or almost all the time (I'm full-time remote)    Home   \n",
       "\n",
       "                            ImpSyn                                  CodeRev  \\\n",
       "Respondent                                                                    \n",
       "25983                      Average  Yes, because I see value in code review   \n",
       "87896       A little above average  Yes, because I see value in code review   \n",
       "22013       A little below average  Yes, because I see value in code review   \n",
       "\n",
       "            CodeRevHrs                      UnitTests  \\\n",
       "Respondent                                              \n",
       "25983              2.0  Yes, it's part of our process   \n",
       "87896              3.0      No, but I think we should   \n",
       "22013             10.0  Yes, it's part of our process   \n",
       "\n",
       "                                                  PurchaseHow  \\\n",
       "Respondent                                                      \n",
       "25983       Developers and management have nearly equal in...   \n",
       "87896       Developers and management have nearly equal in...   \n",
       "22013       Developers typically have the most influence o...   \n",
       "\n",
       "                                PurchaseWhat  \\\n",
       "Respondent                                     \n",
       "25983          I have little or no influence   \n",
       "87896       I have a great deal of influence   \n",
       "22013       I have a great deal of influence   \n",
       "\n",
       "                                           LanguageWorkedWith  \\\n",
       "Respondent                                                      \n",
       "25983       Bash/Shell/PowerShell;C++;C#;HTML/CSS;JavaScri...   \n",
       "87896                             HTML/CSS;JavaScript;PHP;SQL   \n",
       "22013       Assembly;Bash/Shell/PowerShell;C;C++;Java;Java...   \n",
       "\n",
       "                                       LanguageDesireNextYear  \\\n",
       "Respondent                                                      \n",
       "25983       Bash/Shell/PowerShell;C#;F#;Python;SQL;TypeScript   \n",
       "87896             HTML/CSS;JavaScript;PHP;Ruby;SQL;TypeScript   \n",
       "22013                                            Python;Swift   \n",
       "\n",
       "                               DatabaseWorkedWith      DatabaseDesireNextYear  \\\n",
       "Respondent                                                                      \n",
       "25983                  Microsoft SQL Server;MySQL  Microsoft SQL Server;MySQL   \n",
       "87896                    MariaDB;MySQL;PostgreSQL    MariaDB;MySQL;PostgreSQL   \n",
       "22013       Cassandra;Microsoft SQL Server;Oracle                   Cassandra   \n",
       "\n",
       "                                           PlatformWorkedWith  \\\n",
       "Respondent                                                      \n",
       "25983       AWS;Docker;Heroku;Linux;MacOS;Raspberry Pi;Win...   \n",
       "87896                                               WordPress   \n",
       "22013       Android;Arduino;Google Cloud Platform;IBM Clou...   \n",
       "\n",
       "                    PlatformDesireNextYear     WebFrameWorkedWith  \\\n",
       "Respondent                                                          \n",
       "25983       AWS;Docker;Linux;MacOS;Windows     Angular/Angular.js   \n",
       "87896                                  NaN  jQuery;Laravel;Vue.js   \n",
       "22013          IBM Cloud or Watson;Windows                 jQuery   \n",
       "\n",
       "                          WebFrameDesireNextYear      MiscTechWorkedWith  \\\n",
       "Respondent                                                                 \n",
       "25983          Angular/Angular.js;Flask;React.js  .NET;.NET Core;Node.js   \n",
       "87896       Express;Laravel;Ruby on Rails;Vue.js                     NaN   \n",
       "22013                                        NaN              TensorFlow   \n",
       "\n",
       "           MiscTechDesireNextYear  \\\n",
       "Respondent                          \n",
       "25983           .NET Core;Node.js   \n",
       "87896                     Node.js   \n",
       "22013                  TensorFlow   \n",
       "\n",
       "                                                   DevEnviron        OpSys  \\\n",
       "Respondent                                                                   \n",
       "25983       Notepad++;Sublime Text;Vim;Visual Studio;Visua...      Windows   \n",
       "87896                     Sublime Text;Vim;Visual Studio Code  Linux-based   \n",
       "22013                        Visual Studio;Visual Studio Code      Windows   \n",
       "\n",
       "                         Containers                        BlockchainOrg  \\\n",
       "Respondent                                                                 \n",
       "25983        Development;Production                                  NaN   \n",
       "87896       I do not use containers                           Not at all   \n",
       "22013                   Development  Implementing our own cryptocurrency   \n",
       "\n",
       "                                                 BlockchainIs BetterLife  \\\n",
       "Respondent                                                                 \n",
       "25983       Useful for decentralized currency (i.e., Bitcoin)         No   \n",
       "87896       Useful for immutable record keeping outside of...         No   \n",
       "22013       Useful across many domains and could change ma...        Yes   \n",
       "\n",
       "           ITperson OffOn SocialMedia              Extraversion   ScreenName  \\\n",
       "Respondent                                                                     \n",
       "25983           Yes   Yes      Reddit  In real life (in person)     Username   \n",
       "87896           Yes   Yes     Twitter                    Online       Handle   \n",
       "22013           Yes    No     YouTube                    Online  Screen Name   \n",
       "\n",
       "           SOVisit1st            SOVisitFreq  \\\n",
       "Respondent                                     \n",
       "25983            2013  Daily or almost daily   \n",
       "87896            2011  Daily or almost daily   \n",
       "22013             NaN   A few times per week   \n",
       "\n",
       "                                                    SOVisitTo  \\\n",
       "Respondent                                                      \n",
       "25983       Find answers to specific questions;Learn how t...   \n",
       "87896                      Find answers to specific questions   \n",
       "22013                      Find answers to specific questions   \n",
       "\n",
       "                  SOFindAnswer                     SOTimeSaved  SOHowMuchTime  \\\n",
       "Respondent                                                                      \n",
       "25983       1-2 times per week  Stack Overflow was much faster  11-30 minutes   \n",
       "87896       3-5 times per week  Stack Overflow was much faster   0-10 minutes   \n",
       "22013       1-2 times per week  Stack Overflow was much faster    60+ minutes   \n",
       "\n",
       "           SOAccount                                         SOPartFreq  \\\n",
       "Respondent                                                                \n",
       "25983            Yes                Less than once per month or monthly   \n",
       "87896            Yes                Less than once per month or monthly   \n",
       "22013            Yes  I have never participated in Q&A on Stack Over...   \n",
       "\n",
       "                                                       SOJobs  \\\n",
       "Respondent                                                      \n",
       "25983       No, I knew that Stack Overflow had a job board...   \n",
       "87896       No, I knew that Stack Overflow had a job board...   \n",
       "22013                                                     Yes   \n",
       "\n",
       "                                                     EntTeams  \\\n",
       "Respondent                                                      \n",
       "25983                     No, and I don't know what those are   \n",
       "87896       No, I've heard of them, but I am not part of a...   \n",
       "22013                                                     Yes   \n",
       "\n",
       "                     SOComm                            WelcomeChange  \\\n",
       "Respondent                                                             \n",
       "25983        No, not really  Just as welcome now as I felt last year   \n",
       "87896        No, not really  Just as welcome now as I felt last year   \n",
       "22013       Yes, definitely    A lot more welcome now than last year   \n",
       "\n",
       "                                                 SONewContent   Age Gender  \\\n",
       "Respondent                                                                   \n",
       "25983                                                     NaN  24.0    Man   \n",
       "87896       Tech articles written by other developers;Tech...  32.0    Man   \n",
       "22013       Tech articles written by other developers;Indu...   NaN    Man   \n",
       "\n",
       "           Trans                Sexuality                     Ethnicity  \\\n",
       "Respondent                                                                \n",
       "25983         No  Straight / Heterosexual  White or of European descent   \n",
       "87896         No           Gay or Lesbian  White or of European descent   \n",
       "22013         No  Straight / Heterosexual                           NaN   \n",
       "\n",
       "           Dependents           SurveyLength                  SurveyEase  \n",
       "Respondent                                                                \n",
       "25983              No  Appropriate in length                        Easy  \n",
       "87896              No  Appropriate in length  Neither easy nor difficult  \n",
       "22013             Yes               Too long                        Easy  "
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.nlargest(3, 'ConvertedComp')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "---\n",
    "---\n",
    "---"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}