HR_Data.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "4e38a48a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "2185ba24",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv('D:\\\\vishal data\\\\csv file\\\\HR Data.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "345282af",
   "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>Attrition</th>\n",
       "      <th>Business Travel</th>\n",
       "      <th>CF_age band</th>\n",
       "      <th>CF_attrition label</th>\n",
       "      <th>Department</th>\n",
       "      <th>Education Field</th>\n",
       "      <th>emp no</th>\n",
       "      <th>Employee Number</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Job Role</th>\n",
       "      <th>...</th>\n",
       "      <th>Performance Rating</th>\n",
       "      <th>Relationship Satisfaction</th>\n",
       "      <th>Standard Hours</th>\n",
       "      <th>Stock Option Level</th>\n",
       "      <th>Total Working Years</th>\n",
       "      <th>Work Life Balance</th>\n",
       "      <th>Years At Company</th>\n",
       "      <th>Years In Current Role</th>\n",
       "      <th>Years Since Last Promotion</th>\n",
       "      <th>Years With Curr Manager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Travel_Rarely</td>\n",
       "      <td>35 - 44</td>\n",
       "      <td>Ex-Employees</td>\n",
       "      <td>Sales</td>\n",
       "      <td>Life Sciences</td>\n",
       "      <td>STAFF-1</td>\n",
       "      <td>1</td>\n",
       "      <td>Female</td>\n",
       "      <td>Sales Executive</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>No</td>\n",
       "      <td>Travel_Frequently</td>\n",
       "      <td>45 - 54</td>\n",
       "      <td>Current Employees</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>Life Sciences</td>\n",
       "      <td>STAFF-2</td>\n",
       "      <td>2</td>\n",
       "      <td>Male</td>\n",
       "      <td>Research Scientist</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>3</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Travel_Rarely</td>\n",
       "      <td>35 - 44</td>\n",
       "      <td>Ex-Employees</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>Other</td>\n",
       "      <td>STAFF-4</td>\n",
       "      <td>4</td>\n",
       "      <td>Male</td>\n",
       "      <td>Laboratory Technician</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>No</td>\n",
       "      <td>Travel_Frequently</td>\n",
       "      <td>25 - 34</td>\n",
       "      <td>Current Employees</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>Life Sciences</td>\n",
       "      <td>STAFF-5</td>\n",
       "      <td>5</td>\n",
       "      <td>Female</td>\n",
       "      <td>Research Scientist</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>No</td>\n",
       "      <td>Travel_Rarely</td>\n",
       "      <td>25 - 34</td>\n",
       "      <td>Current Employees</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>Medical</td>\n",
       "      <td>STAFF-7</td>\n",
       "      <td>7</td>\n",
       "      <td>Male</td>\n",
       "      <td>Laboratory Technician</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1465</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Non-Travel</td>\n",
       "      <td>25 - 34</td>\n",
       "      <td>Ex-Employees</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>Technical Degree</td>\n",
       "      <td>STAFF-1905</td>\n",
       "      <td>1905</td>\n",
       "      <td>Male</td>\n",
       "      <td>Research Scientist</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1466</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Travel_Frequently</td>\n",
       "      <td>25 - 34</td>\n",
       "      <td>Ex-Employees</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>Life Sciences</td>\n",
       "      <td>STAFF-1868</td>\n",
       "      <td>1868</td>\n",
       "      <td>Male</td>\n",
       "      <td>Research Scientist</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1467</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Travel_Frequently</td>\n",
       "      <td>35 - 44</td>\n",
       "      <td>Ex-Employees</td>\n",
       "      <td>Sales</td>\n",
       "      <td>Other</td>\n",
       "      <td>STAFF-1667</td>\n",
       "      <td>1667</td>\n",
       "      <td>Male</td>\n",
       "      <td>Sales Executive</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>4</td>\n",
       "      <td>11</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1468</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Travel_Rarely</td>\n",
       "      <td>Under 25</td>\n",
       "      <td>Ex-Employees</td>\n",
       "      <td>R&amp;D</td>\n",
       "      <td>Life Sciences</td>\n",
       "      <td>STAFF-1878</td>\n",
       "      <td>1878</td>\n",
       "      <td>Male</td>\n",
       "      <td>Research Scientist</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>80</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1469</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Travel_Rarely</td>\n",
       "      <td>Under 25</td>\n",
       "      <td>Ex-Employees</td>\n",
       "      <td>Sales</td>\n",
       "      <td>Life Sciences</td>\n",
       "      <td>STAFF-1702</td>\n",
       "      <td>1702</td>\n",
       "      <td>Male</td>\n",
       "      <td>Sales Representative</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>80</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1470 rows × 39 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Attrition    Business Travel CF_age band CF_attrition label Department  \\\n",
       "0          Yes      Travel_Rarely     35 - 44       Ex-Employees      Sales   \n",
       "1           No  Travel_Frequently     45 - 54  Current Employees        R&D   \n",
       "2          Yes      Travel_Rarely     35 - 44       Ex-Employees        R&D   \n",
       "3           No  Travel_Frequently     25 - 34  Current Employees        R&D   \n",
       "4           No      Travel_Rarely     25 - 34  Current Employees        R&D   \n",
       "...        ...                ...         ...                ...        ...   \n",
       "1465       Yes         Non-Travel     25 - 34       Ex-Employees        R&D   \n",
       "1466       Yes  Travel_Frequently     25 - 34       Ex-Employees        R&D   \n",
       "1467       Yes  Travel_Frequently     35 - 44       Ex-Employees      Sales   \n",
       "1468       Yes      Travel_Rarely    Under 25       Ex-Employees        R&D   \n",
       "1469       Yes      Travel_Rarely    Under 25       Ex-Employees      Sales   \n",
       "\n",
       "       Education Field      emp no  Employee Number  Gender  \\\n",
       "0        Life Sciences     STAFF-1                1  Female   \n",
       "1        Life Sciences     STAFF-2                2    Male   \n",
       "2                Other     STAFF-4                4    Male   \n",
       "3        Life Sciences     STAFF-5                5  Female   \n",
       "4              Medical     STAFF-7                7    Male   \n",
       "...                ...         ...              ...     ...   \n",
       "1465  Technical Degree  STAFF-1905             1905    Male   \n",
       "1466     Life Sciences  STAFF-1868             1868    Male   \n",
       "1467             Other  STAFF-1667             1667    Male   \n",
       "1468     Life Sciences  STAFF-1878             1878    Male   \n",
       "1469     Life Sciences  STAFF-1702             1702    Male   \n",
       "\n",
       "                   Job Role  ... Performance Rating Relationship Satisfaction  \\\n",
       "0           Sales Executive  ...                  3                         1   \n",
       "1        Research Scientist  ...                  4                         4   \n",
       "2     Laboratory Technician  ...                  3                         2   \n",
       "3        Research Scientist  ...                  3                         3   \n",
       "4     Laboratory Technician  ...                  3                         4   \n",
       "...                     ...  ...                ...                       ...   \n",
       "1465     Research Scientist  ...                  4                         2   \n",
       "1466     Research Scientist  ...                  4                         2   \n",
       "1467        Sales Executive  ...                  4                         1   \n",
       "1468     Research Scientist  ...                  4                         1   \n",
       "1469   Sales Representative  ...                  4                         2   \n",
       "\n",
       "     Standard Hours  Stock Option Level  Total Working Years  \\\n",
       "0                80                   0                    8   \n",
       "1                80                   1                   10   \n",
       "2                80                   0                    7   \n",
       "3                80                   0                    8   \n",
       "4                80                   1                    6   \n",
       "...             ...                 ...                  ...   \n",
       "1465             80                   1                    5   \n",
       "1466             80                   0                    1   \n",
       "1467             80                   0                   13   \n",
       "1468             80                   0                    1   \n",
       "1469             80                   1                    3   \n",
       "\n",
       "      Work Life Balance  Years At Company  Years In Current Role  \\\n",
       "0                     1                 6                      4   \n",
       "1                     3                10                      7   \n",
       "2                     3                 0                      0   \n",
       "3                     3                 8                      7   \n",
       "4                     3                 2                      2   \n",
       "...                 ...               ...                    ...   \n",
       "1465                  3                 5                      2   \n",
       "1466                  2                 1                      0   \n",
       "1467                  4                11                      9   \n",
       "1468                  3                 1                      0   \n",
       "1469                  3                 3                      2   \n",
       "\n",
       "     Years Since Last Promotion  Years With Curr Manager  \n",
       "0                             0                        5  \n",
       "1                             1                        7  \n",
       "2                             0                        0  \n",
       "3                             3                        0  \n",
       "4                             2                        2  \n",
       "...                         ...                      ...  \n",
       "1465                          3                        0  \n",
       "1466                          1                        0  \n",
       "1467                          6                        7  \n",
       "1468                          0                        0  \n",
       "1469                          0                        2  \n",
       "\n",
       "[1470 rows x 39 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "52508034",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "fc354988",
   "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></th>\n",
       "      <th>Attrition</th>\n",
       "      <th>Business Travel</th>\n",
       "      <th>CF_age band</th>\n",
       "      <th>CF_attrition label</th>\n",
       "      <th>emp no</th>\n",
       "      <th>Employee Number</th>\n",
       "      <th>Gender</th>\n",
       "      <th>Job Role</th>\n",
       "      <th>Marital Status</th>\n",
       "      <th>Over Time</th>\n",
       "      <th>...</th>\n",
       "      <th>Performance Rating</th>\n",
       "      <th>Relationship Satisfaction</th>\n",
       "      <th>Standard Hours</th>\n",
       "      <th>Stock Option Level</th>\n",
       "      <th>Total Working Years</th>\n",
       "      <th>Work Life Balance</th>\n",
       "      <th>Years At Company</th>\n",
       "      <th>Years In Current Role</th>\n",
       "      <th>Years Since Last Promotion</th>\n",
       "      <th>Years With Curr Manager</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Department</th>\n",
       "      <th>Education Field</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <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 rowspan=\"5\" valign=\"top\">HR</th>\n",
       "      <th>Human Resources</th>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>...</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Life Sciences</th>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>...</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical</th>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>...</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical Degree</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"4\" valign=\"top\">R&amp;D</th>\n",
       "      <th>Life Sciences</th>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>...</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "      <td>440</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical</th>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>...</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "      <td>363</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other</th>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>...</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical Degree</th>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>...</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "      <td>94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"5\" valign=\"top\">Sales</th>\n",
       "      <th>Life Sciences</th>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>...</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "      <td>150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marketing</th>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>...</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "      <td>159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Medical</th>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>...</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "      <td>88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Other</th>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>...</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Technical Degree</th>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>...</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "      <td>34</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>14 rows × 37 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             Attrition  Business Travel  CF_age band  \\\n",
       "Department Education Field                                             \n",
       "HR         Human Resources          27               27           27   \n",
       "           Life Sciences            16               16           16   \n",
       "           Medical                  13               13           13   \n",
       "           Other                     3                3            3   \n",
       "           Technical Degree          4                4            4   \n",
       "R&D        Life Sciences           440              440          440   \n",
       "           Medical                 363              363          363   \n",
       "           Other                    64               64           64   \n",
       "           Technical Degree         94               94           94   \n",
       "Sales      Life Sciences           150              150          150   \n",
       "           Marketing               159              159          159   \n",
       "           Medical                  88               88           88   \n",
       "           Other                    15               15           15   \n",
       "           Technical Degree         34               34           34   \n",
       "\n",
       "                             CF_attrition label  emp no  Employee Number  \\\n",
       "Department Education Field                                                 \n",
       "HR         Human Resources                   27      27               27   \n",
       "           Life Sciences                     16      16               16   \n",
       "           Medical                           13      13               13   \n",
       "           Other                              3       3                3   \n",
       "           Technical Degree                   4       4                4   \n",
       "R&D        Life Sciences                    440     440              440   \n",
       "           Medical                          363     363              363   \n",
       "           Other                             64      64               64   \n",
       "           Technical Degree                  94      94               94   \n",
       "Sales      Life Sciences                    150     150              150   \n",
       "           Marketing                        159     159              159   \n",
       "           Medical                           88      88               88   \n",
       "           Other                             15      15               15   \n",
       "           Technical Degree                  34      34               34   \n",
       "\n",
       "                             Gender  Job Role  Marital Status  Over Time  ...  \\\n",
       "Department Education Field                                                ...   \n",
       "HR         Human Resources       27        27              27         27  ...   \n",
       "           Life Sciences         16        16              16         16  ...   \n",
       "           Medical               13        13              13         13  ...   \n",
       "           Other                  3         3               3          3  ...   \n",
       "           Technical Degree       4         4               4          4  ...   \n",
       "R&D        Life Sciences        440       440             440        440  ...   \n",
       "           Medical              363       363             363        363  ...   \n",
       "           Other                 64        64              64         64  ...   \n",
       "           Technical Degree      94        94              94         94  ...   \n",
       "Sales      Life Sciences        150       150             150        150  ...   \n",
       "           Marketing            159       159             159        159  ...   \n",
       "           Medical               88        88              88         88  ...   \n",
       "           Other                 15        15              15         15  ...   \n",
       "           Technical Degree      34        34              34         34  ...   \n",
       "\n",
       "                             Performance Rating  Relationship Satisfaction  \\\n",
       "Department Education Field                                                   \n",
       "HR         Human Resources                   27                         27   \n",
       "           Life Sciences                     16                         16   \n",
       "           Medical                           13                         13   \n",
       "           Other                              3                          3   \n",
       "           Technical Degree                   4                          4   \n",
       "R&D        Life Sciences                    440                        440   \n",
       "           Medical                          363                        363   \n",
       "           Other                             64                         64   \n",
       "           Technical Degree                  94                         94   \n",
       "Sales      Life Sciences                    150                        150   \n",
       "           Marketing                        159                        159   \n",
       "           Medical                           88                         88   \n",
       "           Other                             15                         15   \n",
       "           Technical Degree                  34                         34   \n",
       "\n",
       "                             Standard Hours  Stock Option Level  \\\n",
       "Department Education Field                                        \n",
       "HR         Human Resources               27                  27   \n",
       "           Life Sciences                 16                  16   \n",
       "           Medical                       13                  13   \n",
       "           Other                          3                   3   \n",
       "           Technical Degree               4                   4   \n",
       "R&D        Life Sciences                440                 440   \n",
       "           Medical                      363                 363   \n",
       "           Other                         64                  64   \n",
       "           Technical Degree              94                  94   \n",
       "Sales      Life Sciences                150                 150   \n",
       "           Marketing                    159                 159   \n",
       "           Medical                       88                  88   \n",
       "           Other                         15                  15   \n",
       "           Technical Degree              34                  34   \n",
       "\n",
       "                             Total Working Years  Work Life Balance  \\\n",
       "Department Education Field                                            \n",
       "HR         Human Resources                    27                 27   \n",
       "           Life Sciences                      16                 16   \n",
       "           Medical                            13                 13   \n",
       "           Other                               3                  3   \n",
       "           Technical Degree                    4                  4   \n",
       "R&D        Life Sciences                     440                440   \n",
       "           Medical                           363                363   \n",
       "           Other                              64                 64   \n",
       "           Technical Degree                   94                 94   \n",
       "Sales      Life Sciences                     150                150   \n",
       "           Marketing                         159                159   \n",
       "           Medical                            88                 88   \n",
       "           Other                              15                 15   \n",
       "           Technical Degree                   34                 34   \n",
       "\n",
       "                             Years At Company  Years In Current Role  \\\n",
       "Department Education Field                                             \n",
       "HR         Human Resources                 27                     27   \n",
       "           Life Sciences                   16                     16   \n",
       "           Medical                         13                     13   \n",
       "           Other                            3                      3   \n",
       "           Technical Degree                 4                      4   \n",
       "R&D        Life Sciences                  440                    440   \n",
       "           Medical                        363                    363   \n",
       "           Other                           64                     64   \n",
       "           Technical Degree                94                     94   \n",
       "Sales      Life Sciences                  150                    150   \n",
       "           Marketing                      159                    159   \n",
       "           Medical                         88                     88   \n",
       "           Other                           15                     15   \n",
       "           Technical Degree                34                     34   \n",
       "\n",
       "                             Years Since Last Promotion  \\\n",
       "Department Education Field                                \n",
       "HR         Human Resources                           27   \n",
       "           Life Sciences                             16   \n",
       "           Medical                                   13   \n",
       "           Other                                      3   \n",
       "           Technical Degree                           4   \n",
       "R&D        Life Sciences                            440   \n",
       "           Medical                                  363   \n",
       "           Other                                     64   \n",
       "           Technical Degree                          94   \n",
       "Sales      Life Sciences                            150   \n",
       "           Marketing                                159   \n",
       "           Medical                                   88   \n",
       "           Other                                     15   \n",
       "           Technical Degree                          34   \n",
       "\n",
       "                             Years With Curr Manager  \n",
       "Department Education Field                            \n",
       "HR         Human Resources                        27  \n",
       "           Life Sciences                          16  \n",
       "           Medical                                13  \n",
       "           Other                                   3  \n",
       "           Technical Degree                        4  \n",
       "R&D        Life Sciences                         440  \n",
       "           Medical                               363  \n",
       "           Other                                  64  \n",
       "           Technical Degree                       94  \n",
       "Sales      Life Sciences                         150  \n",
       "           Marketing                             159  \n",
       "           Medical                                88  \n",
       "           Other                                  15  \n",
       "           Technical Degree                       34  \n",
       "\n",
       "[14 rows x 37 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(['Department', 'Education Field']).count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "0199be24",
   "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>Employee Number</th>\n",
       "      <th>Training Times Last Year</th>\n",
       "      <th>Age</th>\n",
       "      <th>CF_current Employee</th>\n",
       "      <th>Daily Rate</th>\n",
       "      <th>Distance From Home</th>\n",
       "      <th>Employee Count</th>\n",
       "      <th>Environment Satisfaction</th>\n",
       "      <th>Hourly Rate</th>\n",
       "      <th>Job Involvement</th>\n",
       "      <th>...</th>\n",
       "      <th>Performance Rating</th>\n",
       "      <th>Relationship Satisfaction</th>\n",
       "      <th>Standard Hours</th>\n",
       "      <th>Stock Option Level</th>\n",
       "      <th>Total Working Years</th>\n",
       "      <th>Work Life Balance</th>\n",
       "      <th>Years At Company</th>\n",
       "      <th>Years In Current Role</th>\n",
       "      <th>Years Since Last Promotion</th>\n",
       "      <th>Years With Curr Manager</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CF_age band</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <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>25 - 34</th>\n",
       "      <td>1026.853791</td>\n",
       "      <td>2.814079</td>\n",
       "      <td>30.142599</td>\n",
       "      <td>0.797834</td>\n",
       "      <td>797.536101</td>\n",
       "      <td>9.057762</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.722022</td>\n",
       "      <td>65.324910</td>\n",
       "      <td>2.693141</td>\n",
       "      <td>...</td>\n",
       "      <td>3.155235</td>\n",
       "      <td>2.702166</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.806859</td>\n",
       "      <td>7.368231</td>\n",
       "      <td>2.736462</td>\n",
       "      <td>5.772563</td>\n",
       "      <td>3.909747</td>\n",
       "      <td>1.691336</td>\n",
       "      <td>3.810469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35 - 44</th>\n",
       "      <td>1050.095050</td>\n",
       "      <td>2.813861</td>\n",
       "      <td>38.784158</td>\n",
       "      <td>0.899010</td>\n",
       "      <td>799.897030</td>\n",
       "      <td>9.372277</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.700990</td>\n",
       "      <td>66.106931</td>\n",
       "      <td>2.750495</td>\n",
       "      <td>...</td>\n",
       "      <td>3.148515</td>\n",
       "      <td>2.677228</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.817822</td>\n",
       "      <td>12.071287</td>\n",
       "      <td>2.792079</td>\n",
       "      <td>7.800000</td>\n",
       "      <td>4.623762</td>\n",
       "      <td>2.506931</td>\n",
       "      <td>4.615842</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45 - 54</th>\n",
       "      <td>1001.840816</td>\n",
       "      <td>2.755102</td>\n",
       "      <td>48.828571</td>\n",
       "      <td>0.897959</td>\n",
       "      <td>843.195918</td>\n",
       "      <td>9.065306</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.746939</td>\n",
       "      <td>66.493878</td>\n",
       "      <td>2.738776</td>\n",
       "      <td>...</td>\n",
       "      <td>3.146939</td>\n",
       "      <td>2.746939</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.816327</td>\n",
       "      <td>18.918367</td>\n",
       "      <td>2.734694</td>\n",
       "      <td>9.387755</td>\n",
       "      <td>5.085714</td>\n",
       "      <td>2.938776</td>\n",
       "      <td>4.910204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Over 55</th>\n",
       "      <td>963.101449</td>\n",
       "      <td>2.623188</td>\n",
       "      <td>56.869565</td>\n",
       "      <td>0.840580</td>\n",
       "      <td>756.188406</td>\n",
       "      <td>9.115942</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.782609</td>\n",
       "      <td>67.420290</td>\n",
       "      <td>2.753623</td>\n",
       "      <td>...</td>\n",
       "      <td>3.188406</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.797101</td>\n",
       "      <td>22.028986</td>\n",
       "      <td>2.681159</td>\n",
       "      <td>9.565217</td>\n",
       "      <td>5.028986</td>\n",
       "      <td>3.275362</td>\n",
       "      <td>4.347826</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Under 25</th>\n",
       "      <td>984.247423</td>\n",
       "      <td>2.876289</td>\n",
       "      <td>21.711340</td>\n",
       "      <td>0.608247</td>\n",
       "      <td>774.340206</td>\n",
       "      <td>9.402062</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.721649</td>\n",
       "      <td>65.391753</td>\n",
       "      <td>2.793814</td>\n",
       "      <td>...</td>\n",
       "      <td>3.164948</td>\n",
       "      <td>2.659794</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.536082</td>\n",
       "      <td>2.556701</td>\n",
       "      <td>2.865979</td>\n",
       "      <td>2.113402</td>\n",
       "      <td>1.268041</td>\n",
       "      <td>0.690722</td>\n",
       "      <td>1.195876</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Employee Number  Training Times Last Year        Age  \\\n",
       "CF_age band                                                         \n",
       "25 - 34          1026.853791                  2.814079  30.142599   \n",
       "35 - 44          1050.095050                  2.813861  38.784158   \n",
       "45 - 54          1001.840816                  2.755102  48.828571   \n",
       "Over 55           963.101449                  2.623188  56.869565   \n",
       "Under 25          984.247423                  2.876289  21.711340   \n",
       "\n",
       "             CF_current Employee  Daily Rate  Distance From Home  \\\n",
       "CF_age band                                                        \n",
       "25 - 34                 0.797834  797.536101            9.057762   \n",
       "35 - 44                 0.899010  799.897030            9.372277   \n",
       "45 - 54                 0.897959  843.195918            9.065306   \n",
       "Over 55                 0.840580  756.188406            9.115942   \n",
       "Under 25                0.608247  774.340206            9.402062   \n",
       "\n",
       "             Employee Count  Environment Satisfaction  Hourly Rate  \\\n",
       "CF_age band                                                          \n",
       "25 - 34                 1.0                  2.722022    65.324910   \n",
       "35 - 44                 1.0                  2.700990    66.106931   \n",
       "45 - 54                 1.0                  2.746939    66.493878   \n",
       "Over 55                 1.0                  2.782609    67.420290   \n",
       "Under 25                1.0                  2.721649    65.391753   \n",
       "\n",
       "             Job Involvement  ...  Performance Rating  \\\n",
       "CF_age band                   ...                       \n",
       "25 - 34             2.693141  ...            3.155235   \n",
       "35 - 44             2.750495  ...            3.148515   \n",
       "45 - 54             2.738776  ...            3.146939   \n",
       "Over 55             2.753623  ...            3.188406   \n",
       "Under 25            2.793814  ...            3.164948   \n",
       "\n",
       "             Relationship Satisfaction  Standard Hours  Stock Option Level  \\\n",
       "CF_age band                                                                  \n",
       "25 - 34                       2.702166            80.0            0.806859   \n",
       "35 - 44                       2.677228            80.0            0.817822   \n",
       "45 - 54                       2.746939            80.0            0.816327   \n",
       "Over 55                       3.000000            80.0            0.797101   \n",
       "Under 25                      2.659794            80.0            0.536082   \n",
       "\n",
       "             Total Working Years  Work Life Balance  Years At Company  \\\n",
       "CF_age band                                                             \n",
       "25 - 34                 7.368231           2.736462          5.772563   \n",
       "35 - 44                12.071287           2.792079          7.800000   \n",
       "45 - 54                18.918367           2.734694          9.387755   \n",
       "Over 55                22.028986           2.681159          9.565217   \n",
       "Under 25                2.556701           2.865979          2.113402   \n",
       "\n",
       "             Years In Current Role  Years Since Last Promotion  \\\n",
       "CF_age band                                                      \n",
       "25 - 34                   3.909747                    1.691336   \n",
       "35 - 44                   4.623762                    2.506931   \n",
       "45 - 54                   5.085714                    2.938776   \n",
       "Over 55                   5.028986                    3.275362   \n",
       "Under 25                  1.268041                    0.690722   \n",
       "\n",
       "             Years With Curr Manager  \n",
       "CF_age band                           \n",
       "25 - 34                     3.810469  \n",
       "35 - 44                     4.615842  \n",
       "45 - 54                     4.910204  \n",
       "Over 55                     4.347826  \n",
       "Under 25                    1.195876  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(['CF_age band']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "657b30a2",
   "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></th>\n",
       "      <th>Employee Number</th>\n",
       "      <th>Training Times Last Year</th>\n",
       "      <th>Age</th>\n",
       "      <th>CF_current Employee</th>\n",
       "      <th>Daily Rate</th>\n",
       "      <th>Distance From Home</th>\n",
       "      <th>Employee Count</th>\n",
       "      <th>Environment Satisfaction</th>\n",
       "      <th>Hourly Rate</th>\n",
       "      <th>Job Involvement</th>\n",
       "      <th>...</th>\n",
       "      <th>Performance Rating</th>\n",
       "      <th>Relationship Satisfaction</th>\n",
       "      <th>Standard Hours</th>\n",
       "      <th>Stock Option Level</th>\n",
       "      <th>Total Working Years</th>\n",
       "      <th>Work Life Balance</th>\n",
       "      <th>Years At Company</th>\n",
       "      <th>Years In Current Role</th>\n",
       "      <th>Years Since Last Promotion</th>\n",
       "      <th>Years With Curr Manager</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Gender</th>\n",
       "      <th>Job Role</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <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 rowspan=\"9\" valign=\"top\">Female</th>\n",
       "      <th>Healthcare Representative</th>\n",
       "      <td>1008.333333</td>\n",
       "      <td>2.823529</td>\n",
       "      <td>38.901961</td>\n",
       "      <td>0.901961</td>\n",
       "      <td>787.156863</td>\n",
       "      <td>9.529412</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.843137</td>\n",
       "      <td>63.313725</td>\n",
       "      <td>2.725490</td>\n",
       "      <td>...</td>\n",
       "      <td>3.117647</td>\n",
       "      <td>2.588235</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.784314</td>\n",
       "      <td>13.921569</td>\n",
       "      <td>2.705882</td>\n",
       "      <td>9.215686</td>\n",
       "      <td>5.529412</td>\n",
       "      <td>3.254902</td>\n",
       "      <td>5.137255</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Human Resources</th>\n",
       "      <td>1307.125000</td>\n",
       "      <td>2.062500</td>\n",
       "      <td>34.437500</td>\n",
       "      <td>0.625000</td>\n",
       "      <td>869.812500</td>\n",
       "      <td>10.750000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.750000</td>\n",
       "      <td>56.000000</td>\n",
       "      <td>2.750000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.125000</td>\n",
       "      <td>2.812500</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.875000</td>\n",
       "      <td>7.937500</td>\n",
       "      <td>2.937500</td>\n",
       "      <td>4.562500</td>\n",
       "      <td>2.500000</td>\n",
       "      <td>1.375000</td>\n",
       "      <td>3.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Laboratory Technician</th>\n",
       "      <td>976.611765</td>\n",
       "      <td>3.105882</td>\n",
       "      <td>35.270588</td>\n",
       "      <td>0.811765</td>\n",
       "      <td>814.047059</td>\n",
       "      <td>7.764706</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.741176</td>\n",
       "      <td>62.976471</td>\n",
       "      <td>2.682353</td>\n",
       "      <td>...</td>\n",
       "      <td>3.164706</td>\n",
       "      <td>2.482353</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.741176</td>\n",
       "      <td>8.058824</td>\n",
       "      <td>2.776471</td>\n",
       "      <td>5.317647</td>\n",
       "      <td>3.247059</td>\n",
       "      <td>1.788235</td>\n",
       "      <td>3.305882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Manager</th>\n",
       "      <td>873.127660</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>47.680851</td>\n",
       "      <td>0.957447</td>\n",
       "      <td>900.191489</td>\n",
       "      <td>9.085106</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.829787</td>\n",
       "      <td>65.234043</td>\n",
       "      <td>2.744681</td>\n",
       "      <td>...</td>\n",
       "      <td>3.212766</td>\n",
       "      <td>2.957447</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.808511</td>\n",
       "      <td>24.361702</td>\n",
       "      <td>2.702128</td>\n",
       "      <td>11.574468</td>\n",
       "      <td>6.510638</td>\n",
       "      <td>3.723404</td>\n",
       "      <td>5.595745</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Manufacturing Director</th>\n",
       "      <td>1068.819444</td>\n",
       "      <td>2.888889</td>\n",
       "      <td>38.638889</td>\n",
       "      <td>0.944444</td>\n",
       "      <td>744.861111</td>\n",
       "      <td>8.750000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.819444</td>\n",
       "      <td>64.555556</td>\n",
       "      <td>2.680556</td>\n",
       "      <td>...</td>\n",
       "      <td>3.180556</td>\n",
       "      <td>2.777778</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.819444</td>\n",
       "      <td>13.680556</td>\n",
       "      <td>2.750000</td>\n",
       "      <td>8.236111</td>\n",
       "      <td>5.111111</td>\n",
       "      <td>2.361111</td>\n",
       "      <td>5.097222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Research Director</th>\n",
       "      <td>1015.424242</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>41.909091</td>\n",
       "      <td>0.969697</td>\n",
       "      <td>731.121212</td>\n",
       "      <td>9.727273</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.242424</td>\n",
       "      <td>65.333333</td>\n",
       "      <td>2.848485</td>\n",
       "      <td>...</td>\n",
       "      <td>3.121212</td>\n",
       "      <td>2.545455</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.878788</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>2.757576</td>\n",
       "      <td>11.636364</td>\n",
       "      <td>7.060606</td>\n",
       "      <td>3.333333</td>\n",
       "      <td>6.515152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Research Scientist</th>\n",
       "      <td>962.157895</td>\n",
       "      <td>2.771930</td>\n",
       "      <td>33.991228</td>\n",
       "      <td>0.850877</td>\n",
       "      <td>797.122807</td>\n",
       "      <td>10.043860</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.701754</td>\n",
       "      <td>69.754386</td>\n",
       "      <td>2.728070</td>\n",
       "      <td>...</td>\n",
       "      <td>3.166667</td>\n",
       "      <td>2.771930</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.692982</td>\n",
       "      <td>8.271930</td>\n",
       "      <td>2.666667</td>\n",
       "      <td>5.289474</td>\n",
       "      <td>3.298246</td>\n",
       "      <td>1.464912</td>\n",
       "      <td>3.245614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales Executive</th>\n",
       "      <td>1036.219697</td>\n",
       "      <td>2.810606</td>\n",
       "      <td>37.833333</td>\n",
       "      <td>0.848485</td>\n",
       "      <td>830.628788</td>\n",
       "      <td>9.825758</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.659091</td>\n",
       "      <td>67.318182</td>\n",
       "      <td>2.742424</td>\n",
       "      <td>...</td>\n",
       "      <td>3.159091</td>\n",
       "      <td>2.659091</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.840909</td>\n",
       "      <td>11.386364</td>\n",
       "      <td>2.840909</td>\n",
       "      <td>7.696970</td>\n",
       "      <td>4.840909</td>\n",
       "      <td>2.628788</td>\n",
       "      <td>4.727273</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales Representative</th>\n",
       "      <td>1040.157895</td>\n",
       "      <td>3.078947</td>\n",
       "      <td>30.052632</td>\n",
       "      <td>0.578947</td>\n",
       "      <td>827.052632</td>\n",
       "      <td>7.315789</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.868421</td>\n",
       "      <td>67.500000</td>\n",
       "      <td>2.526316</td>\n",
       "      <td>...</td>\n",
       "      <td>3.131579</td>\n",
       "      <td>2.605263</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.684211</td>\n",
       "      <td>4.473684</td>\n",
       "      <td>2.868421</td>\n",
       "      <td>3.078947</td>\n",
       "      <td>1.973684</td>\n",
       "      <td>1.052632</td>\n",
       "      <td>1.815789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"9\" valign=\"top\">Male</th>\n",
       "      <th>Healthcare Representative</th>\n",
       "      <td>1117.150000</td>\n",
       "      <td>2.700000</td>\n",
       "      <td>40.387500</td>\n",
       "      <td>0.950000</td>\n",
       "      <td>897.025000</td>\n",
       "      <td>9.950000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.725000</td>\n",
       "      <td>69.087500</td>\n",
       "      <td>2.737500</td>\n",
       "      <td>...</td>\n",
       "      <td>3.175000</td>\n",
       "      <td>2.762500</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.862500</td>\n",
       "      <td>14.162500</td>\n",
       "      <td>2.700000</td>\n",
       "      <td>7.837500</td>\n",
       "      <td>4.437500</td>\n",
       "      <td>2.787500</td>\n",
       "      <td>4.212500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Human Resources</th>\n",
       "      <td>1204.861111</td>\n",
       "      <td>2.777778</td>\n",
       "      <td>35.972222</td>\n",
       "      <td>0.833333</td>\n",
       "      <td>708.194444</td>\n",
       "      <td>7.027778</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.527778</td>\n",
       "      <td>67.805556</td>\n",
       "      <td>2.694444</td>\n",
       "      <td>...</td>\n",
       "      <td>3.138889</td>\n",
       "      <td>3.027778</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.694444</td>\n",
       "      <td>8.277778</td>\n",
       "      <td>2.916667</td>\n",
       "      <td>5.666667</td>\n",
       "      <td>3.416667</td>\n",
       "      <td>1.222222</td>\n",
       "      <td>3.138889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Laboratory Technician</th>\n",
       "      <td>1010.235632</td>\n",
       "      <td>2.873563</td>\n",
       "      <td>33.522989</td>\n",
       "      <td>0.735632</td>\n",
       "      <td>788.103448</td>\n",
       "      <td>10.212644</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.706897</td>\n",
       "      <td>68.494253</td>\n",
       "      <td>2.701149</td>\n",
       "      <td>...</td>\n",
       "      <td>3.160920</td>\n",
       "      <td>2.787356</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.856322</td>\n",
       "      <td>7.459770</td>\n",
       "      <td>2.689655</td>\n",
       "      <td>4.873563</td>\n",
       "      <td>3.178161</td>\n",
       "      <td>1.241379</td>\n",
       "      <td>3.293103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Manager</th>\n",
       "      <td>1011.236364</td>\n",
       "      <td>2.654545</td>\n",
       "      <td>45.981818</td>\n",
       "      <td>0.945455</td>\n",
       "      <td>682.763636</td>\n",
       "      <td>7.127273</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.709091</td>\n",
       "      <td>68.200000</td>\n",
       "      <td>2.800000</td>\n",
       "      <td>...</td>\n",
       "      <td>3.181818</td>\n",
       "      <td>2.690909</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.690909</td>\n",
       "      <td>24.709091</td>\n",
       "      <td>2.836364</td>\n",
       "      <td>16.872727</td>\n",
       "      <td>6.400000</td>\n",
       "      <td>5.781818</td>\n",
       "      <td>6.854545</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Manufacturing Director</th>\n",
       "      <td>929.657534</td>\n",
       "      <td>2.602740</td>\n",
       "      <td>37.958904</td>\n",
       "      <td>0.917808</td>\n",
       "      <td>846.479452</td>\n",
       "      <td>10.205479</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.013699</td>\n",
       "      <td>65.452055</td>\n",
       "      <td>2.684932</td>\n",
       "      <td>...</td>\n",
       "      <td>3.191781</td>\n",
       "      <td>2.671233</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.808219</td>\n",
       "      <td>11.904110</td>\n",
       "      <td>2.780822</td>\n",
       "      <td>6.972603</td>\n",
       "      <td>4.835616</td>\n",
       "      <td>1.876712</td>\n",
       "      <td>4.794521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Research Director</th>\n",
       "      <td>971.787234</td>\n",
       "      <td>2.851064</td>\n",
       "      <td>45.468085</td>\n",
       "      <td>0.978723</td>\n",
       "      <td>852.531915</td>\n",
       "      <td>7.531915</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.680851</td>\n",
       "      <td>62.659574</td>\n",
       "      <td>2.723404</td>\n",
       "      <td>...</td>\n",
       "      <td>3.085106</td>\n",
       "      <td>2.787234</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.829787</td>\n",
       "      <td>23.085106</td>\n",
       "      <td>2.936170</td>\n",
       "      <td>10.446809</td>\n",
       "      <td>5.744681</td>\n",
       "      <td>3.085106</td>\n",
       "      <td>5.765957</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Research Scientist</th>\n",
       "      <td>1029.955056</td>\n",
       "      <td>2.595506</td>\n",
       "      <td>34.393258</td>\n",
       "      <td>0.831461</td>\n",
       "      <td>802.432584</td>\n",
       "      <td>8.353933</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.741573</td>\n",
       "      <td>64.758427</td>\n",
       "      <td>2.842697</td>\n",
       "      <td>...</td>\n",
       "      <td>3.168539</td>\n",
       "      <td>2.662921</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.825843</td>\n",
       "      <td>7.359551</td>\n",
       "      <td>2.685393</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>3.258427</td>\n",
       "      <td>1.533708</td>\n",
       "      <td>3.185393</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales Executive</th>\n",
       "      <td>1061.211340</td>\n",
       "      <td>2.845361</td>\n",
       "      <td>36.247423</td>\n",
       "      <td>0.809278</td>\n",
       "      <td>782.685567</td>\n",
       "      <td>9.546392</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.680412</td>\n",
       "      <td>64.159794</td>\n",
       "      <td>2.695876</td>\n",
       "      <td>...</td>\n",
       "      <td>3.103093</td>\n",
       "      <td>2.731959</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.804124</td>\n",
       "      <td>10.907216</td>\n",
       "      <td>2.778351</td>\n",
       "      <td>7.360825</td>\n",
       "      <td>4.865979</td>\n",
       "      <td>2.386598</td>\n",
       "      <td>4.644330</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales Representative</th>\n",
       "      <td>1040.333333</td>\n",
       "      <td>2.955556</td>\n",
       "      <td>30.622222</td>\n",
       "      <td>0.622222</td>\n",
       "      <td>798.088889</td>\n",
       "      <td>9.800000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.622222</td>\n",
       "      <td>61.666667</td>\n",
       "      <td>2.755556</td>\n",
       "      <td>...</td>\n",
       "      <td>3.155556</td>\n",
       "      <td>2.600000</td>\n",
       "      <td>80.0</td>\n",
       "      <td>0.577778</td>\n",
       "      <td>4.844444</td>\n",
       "      <td>2.911111</td>\n",
       "      <td>2.777778</td>\n",
       "      <td>2.044444</td>\n",
       "      <td>1.066667</td>\n",
       "      <td>1.533333</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  Employee Number  Training Times Last Year  \\\n",
       "Gender Job Role                                                               \n",
       "Female Healthcare Representative      1008.333333                  2.823529   \n",
       "       Human Resources                1307.125000                  2.062500   \n",
       "       Laboratory Technician           976.611765                  3.105882   \n",
       "       Manager                         873.127660                  3.000000   \n",
       "       Manufacturing Director         1068.819444                  2.888889   \n",
       "       Research Director              1015.424242                  2.666667   \n",
       "       Research Scientist              962.157895                  2.771930   \n",
       "       Sales Executive                1036.219697                  2.810606   \n",
       "       Sales Representative           1040.157895                  3.078947   \n",
       "Male   Healthcare Representative      1117.150000                  2.700000   \n",
       "       Human Resources                1204.861111                  2.777778   \n",
       "       Laboratory Technician          1010.235632                  2.873563   \n",
       "       Manager                        1011.236364                  2.654545   \n",
       "       Manufacturing Director          929.657534                  2.602740   \n",
       "       Research Director               971.787234                  2.851064   \n",
       "       Research Scientist             1029.955056                  2.595506   \n",
       "       Sales Executive                1061.211340                  2.845361   \n",
       "       Sales Representative           1040.333333                  2.955556   \n",
       "\n",
       "                                        Age  CF_current Employee  Daily Rate  \\\n",
       "Gender Job Role                                                                \n",
       "Female Healthcare Representative  38.901961             0.901961  787.156863   \n",
       "       Human Resources            34.437500             0.625000  869.812500   \n",
       "       Laboratory Technician      35.270588             0.811765  814.047059   \n",
       "       Manager                    47.680851             0.957447  900.191489   \n",
       "       Manufacturing Director     38.638889             0.944444  744.861111   \n",
       "       Research Director          41.909091             0.969697  731.121212   \n",
       "       Research Scientist         33.991228             0.850877  797.122807   \n",
       "       Sales Executive            37.833333             0.848485  830.628788   \n",
       "       Sales Representative       30.052632             0.578947  827.052632   \n",
       "Male   Healthcare Representative  40.387500             0.950000  897.025000   \n",
       "       Human Resources            35.972222             0.833333  708.194444   \n",
       "       Laboratory Technician      33.522989             0.735632  788.103448   \n",
       "       Manager                    45.981818             0.945455  682.763636   \n",
       "       Manufacturing Director     37.958904             0.917808  846.479452   \n",
       "       Research Director          45.468085             0.978723  852.531915   \n",
       "       Research Scientist         34.393258             0.831461  802.432584   \n",
       "       Sales Executive            36.247423             0.809278  782.685567   \n",
       "       Sales Representative       30.622222             0.622222  798.088889   \n",
       "\n",
       "                                  Distance From Home  Employee Count  \\\n",
       "Gender Job Role                                                        \n",
       "Female Healthcare Representative            9.529412             1.0   \n",
       "       Human Resources                     10.750000             1.0   \n",
       "       Laboratory Technician                7.764706             1.0   \n",
       "       Manager                              9.085106             1.0   \n",
       "       Manufacturing Director               8.750000             1.0   \n",
       "       Research Director                    9.727273             1.0   \n",
       "       Research Scientist                  10.043860             1.0   \n",
       "       Sales Executive                      9.825758             1.0   \n",
       "       Sales Representative                 7.315789             1.0   \n",
       "Male   Healthcare Representative            9.950000             1.0   \n",
       "       Human Resources                      7.027778             1.0   \n",
       "       Laboratory Technician               10.212644             1.0   \n",
       "       Manager                              7.127273             1.0   \n",
       "       Manufacturing Director              10.205479             1.0   \n",
       "       Research Director                    7.531915             1.0   \n",
       "       Research Scientist                   8.353933             1.0   \n",
       "       Sales Executive                      9.546392             1.0   \n",
       "       Sales Representative                 9.800000             1.0   \n",
       "\n",
       "                                  Environment Satisfaction  Hourly Rate  \\\n",
       "Gender Job Role                                                           \n",
       "Female Healthcare Representative                  2.843137    63.313725   \n",
       "       Human Resources                            2.750000    56.000000   \n",
       "       Laboratory Technician                      2.741176    62.976471   \n",
       "       Manager                                    2.829787    65.234043   \n",
       "       Manufacturing Director                     2.819444    64.555556   \n",
       "       Research Director                          2.242424    65.333333   \n",
       "       Research Scientist                         2.701754    69.754386   \n",
       "       Sales Executive                            2.659091    67.318182   \n",
       "       Sales Representative                       2.868421    67.500000   \n",
       "Male   Healthcare Representative                  2.725000    69.087500   \n",
       "       Human Resources                            2.527778    67.805556   \n",
       "       Laboratory Technician                      2.706897    68.494253   \n",
       "       Manager                                    2.709091    68.200000   \n",
       "       Manufacturing Director                     3.013699    65.452055   \n",
       "       Research Director                          2.680851    62.659574   \n",
       "       Research Scientist                         2.741573    64.758427   \n",
       "       Sales Executive                            2.680412    64.159794   \n",
       "       Sales Representative                       2.622222    61.666667   \n",
       "\n",
       "                                  Job Involvement  ...  Performance Rating  \\\n",
       "Gender Job Role                                    ...                       \n",
       "Female Healthcare Representative         2.725490  ...            3.117647   \n",
       "       Human Resources                   2.750000  ...            3.125000   \n",
       "       Laboratory Technician             2.682353  ...            3.164706   \n",
       "       Manager                           2.744681  ...            3.212766   \n",
       "       Manufacturing Director            2.680556  ...            3.180556   \n",
       "       Research Director                 2.848485  ...            3.121212   \n",
       "       Research Scientist                2.728070  ...            3.166667   \n",
       "       Sales Executive                   2.742424  ...            3.159091   \n",
       "       Sales Representative              2.526316  ...            3.131579   \n",
       "Male   Healthcare Representative         2.737500  ...            3.175000   \n",
       "       Human Resources                   2.694444  ...            3.138889   \n",
       "       Laboratory Technician             2.701149  ...            3.160920   \n",
       "       Manager                           2.800000  ...            3.181818   \n",
       "       Manufacturing Director            2.684932  ...            3.191781   \n",
       "       Research Director                 2.723404  ...            3.085106   \n",
       "       Research Scientist                2.842697  ...            3.168539   \n",
       "       Sales Executive                   2.695876  ...            3.103093   \n",
       "       Sales Representative              2.755556  ...            3.155556   \n",
       "\n",
       "                                  Relationship Satisfaction  Standard Hours  \\\n",
       "Gender Job Role                                                               \n",
       "Female Healthcare Representative                   2.588235            80.0   \n",
       "       Human Resources                             2.812500            80.0   \n",
       "       Laboratory Technician                       2.482353            80.0   \n",
       "       Manager                                     2.957447            80.0   \n",
       "       Manufacturing Director                      2.777778            80.0   \n",
       "       Research Director                           2.545455            80.0   \n",
       "       Research Scientist                          2.771930            80.0   \n",
       "       Sales Executive                             2.659091            80.0   \n",
       "       Sales Representative                        2.605263            80.0   \n",
       "Male   Healthcare Representative                   2.762500            80.0   \n",
       "       Human Resources                             3.027778            80.0   \n",
       "       Laboratory Technician                       2.787356            80.0   \n",
       "       Manager                                     2.690909            80.0   \n",
       "       Manufacturing Director                      2.671233            80.0   \n",
       "       Research Director                           2.787234            80.0   \n",
       "       Research Scientist                          2.662921            80.0   \n",
       "       Sales Executive                             2.731959            80.0   \n",
       "       Sales Representative                        2.600000            80.0   \n",
       "\n",
       "                                  Stock Option Level  Total Working Years  \\\n",
       "Gender Job Role                                                             \n",
       "Female Healthcare Representative            0.784314            13.921569   \n",
       "       Human Resources                      0.875000             7.937500   \n",
       "       Laboratory Technician                0.741176             8.058824   \n",
       "       Manager                              0.808511            24.361702   \n",
       "       Manufacturing Director               0.819444            13.680556   \n",
       "       Research Director                    0.878788            19.000000   \n",
       "       Research Scientist                   0.692982             8.271930   \n",
       "       Sales Executive                      0.840909            11.386364   \n",
       "       Sales Representative                 0.684211             4.473684   \n",
       "Male   Healthcare Representative            0.862500            14.162500   \n",
       "       Human Resources                      0.694444             8.277778   \n",
       "       Laboratory Technician                0.856322             7.459770   \n",
       "       Manager                              0.690909            24.709091   \n",
       "       Manufacturing Director               0.808219            11.904110   \n",
       "       Research Director                    0.829787            23.085106   \n",
       "       Research Scientist                   0.825843             7.359551   \n",
       "       Sales Executive                      0.804124            10.907216   \n",
       "       Sales Representative                 0.577778             4.844444   \n",
       "\n",
       "                                  Work Life Balance  Years At Company  \\\n",
       "Gender Job Role                                                         \n",
       "Female Healthcare Representative           2.705882          9.215686   \n",
       "       Human Resources                     2.937500          4.562500   \n",
       "       Laboratory Technician               2.776471          5.317647   \n",
       "       Manager                             2.702128         11.574468   \n",
       "       Manufacturing Director              2.750000          8.236111   \n",
       "       Research Director                   2.757576         11.636364   \n",
       "       Research Scientist                  2.666667          5.289474   \n",
       "       Sales Executive                     2.840909          7.696970   \n",
       "       Sales Representative                2.868421          3.078947   \n",
       "Male   Healthcare Representative           2.700000          7.837500   \n",
       "       Human Resources                     2.916667          5.666667   \n",
       "       Laboratory Technician               2.689655          4.873563   \n",
       "       Manager                             2.836364         16.872727   \n",
       "       Manufacturing Director              2.780822          6.972603   \n",
       "       Research Director                   2.936170         10.446809   \n",
       "       Research Scientist                  2.685393          5.000000   \n",
       "       Sales Executive                     2.778351          7.360825   \n",
       "       Sales Representative                2.911111          2.777778   \n",
       "\n",
       "                                  Years In Current Role  \\\n",
       "Gender Job Role                                           \n",
       "Female Healthcare Representative               5.529412   \n",
       "       Human Resources                         2.500000   \n",
       "       Laboratory Technician                   3.247059   \n",
       "       Manager                                 6.510638   \n",
       "       Manufacturing Director                  5.111111   \n",
       "       Research Director                       7.060606   \n",
       "       Research Scientist                      3.298246   \n",
       "       Sales Executive                         4.840909   \n",
       "       Sales Representative                    1.973684   \n",
       "Male   Healthcare Representative               4.437500   \n",
       "       Human Resources                         3.416667   \n",
       "       Laboratory Technician                   3.178161   \n",
       "       Manager                                 6.400000   \n",
       "       Manufacturing Director                  4.835616   \n",
       "       Research Director                       5.744681   \n",
       "       Research Scientist                      3.258427   \n",
       "       Sales Executive                         4.865979   \n",
       "       Sales Representative                    2.044444   \n",
       "\n",
       "                                  Years Since Last Promotion  \\\n",
       "Gender Job Role                                                \n",
       "Female Healthcare Representative                    3.254902   \n",
       "       Human Resources                              1.375000   \n",
       "       Laboratory Technician                        1.788235   \n",
       "       Manager                                      3.723404   \n",
       "       Manufacturing Director                       2.361111   \n",
       "       Research Director                            3.333333   \n",
       "       Research Scientist                           1.464912   \n",
       "       Sales Executive                              2.628788   \n",
       "       Sales Representative                         1.052632   \n",
       "Male   Healthcare Representative                    2.787500   \n",
       "       Human Resources                              1.222222   \n",
       "       Laboratory Technician                        1.241379   \n",
       "       Manager                                      5.781818   \n",
       "       Manufacturing Director                       1.876712   \n",
       "       Research Director                            3.085106   \n",
       "       Research Scientist                           1.533708   \n",
       "       Sales Executive                              2.386598   \n",
       "       Sales Representative                         1.066667   \n",
       "\n",
       "                                  Years With Curr Manager  \n",
       "Gender Job Role                                            \n",
       "Female Healthcare Representative                 5.137255  \n",
       "       Human Resources                           3.250000  \n",
       "       Laboratory Technician                     3.305882  \n",
       "       Manager                                   5.595745  \n",
       "       Manufacturing Director                    5.097222  \n",
       "       Research Director                         6.515152  \n",
       "       Research Scientist                        3.245614  \n",
       "       Sales Executive                           4.727273  \n",
       "       Sales Representative                      1.815789  \n",
       "Male   Healthcare Representative                 4.212500  \n",
       "       Human Resources                           3.138889  \n",
       "       Laboratory Technician                     3.293103  \n",
       "       Manager                                   6.854545  \n",
       "       Manufacturing Director                    4.794521  \n",
       "       Research Director                         5.765957  \n",
       "       Research Scientist                        3.185393  \n",
       "       Sales Executive                           4.644330  \n",
       "       Sales Representative                      1.533333  \n",
       "\n",
       "[18 rows x 26 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby(['Gender', 'Job Role']).mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "02e39c51",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.13"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}