data_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "1158ba95",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "# Import dependencies\n",
    "import matplotlib.pyplot as plt\n",
    "import pandas as pd\n",
    "import sqlite3\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "e7601277",
   "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>Are you self-employed?</th>\n",
       "      <th>How many employees does your company or organization have?</th>\n",
       "      <th>Is your employer primarily a tech company/organization?</th>\n",
       "      <th>Is your primary role within your company related to tech/IT?</th>\n",
       "      <th>Does your employer provide mental health benefits as part of healthcare coverage?</th>\n",
       "      <th>Do you know the options for mental health care available under your employer-provided health coverage?</th>\n",
       "      <th>Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?</th>\n",
       "      <th>Does your employer offer resources to learn more about mental health disorders and options for seeking help?</th>\n",
       "      <th>Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?</th>\n",
       "      <th>...</th>\n",
       "      <th>What is your gender?</th>\n",
       "      <th>What country do you live in?</th>\n",
       "      <th>What US state or territory do you live in?</th>\n",
       "      <th>What is your race?</th>\n",
       "      <th>Other.3</th>\n",
       "      <th>What country do you work in?</th>\n",
       "      <th>What US state or territory do you work in?</th>\n",
       "      <th>Start Date (UTC)</th>\n",
       "      <th>Submit Date (UTC)</th>\n",
       "      <th>Network ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>e49fe87572831232dcfa51b376b22039</td>\n",
       "      <td>0</td>\n",
       "      <td>100-500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5/16/18 12:32</td>\n",
       "      <td>5/16/18 12:42</td>\n",
       "      <td>464b7a12f1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a1eede444ac024928d247a8372d54931</td>\n",
       "      <td>0</td>\n",
       "      <td>100-500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>male</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>NaN</td>\n",
       "      <td>5/16/18 12:31</td>\n",
       "      <td>5/16/18 12:40</td>\n",
       "      <td>464b7a12f1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37d3fd67f62bd1e0a2dea4f9cd440d98</td>\n",
       "      <td>0</td>\n",
       "      <td>25-Jun</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Missouri</td>\n",
       "      <td>5/9/18 5:34</td>\n",
       "      <td>5/9/18 5:46</td>\n",
       "      <td>1eb7e0cb94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>519b759442c1cab0e9b5a8a1acb1b216</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Washington</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Washington</td>\n",
       "      <td>5/4/18 23:19</td>\n",
       "      <td>5/4/18 23:23</td>\n",
       "      <td>63852edbc4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ef0af4927b575b1a3e607c11ca37870e</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>More than one of the above</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>5/3/18 0:40</td>\n",
       "      <td>5/3/18 0:53</td>\n",
       "      <td>43237889f1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 123 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  #  Are you self-employed?  \\\n",
       "0  e49fe87572831232dcfa51b376b22039                       0   \n",
       "1  a1eede444ac024928d247a8372d54931                       0   \n",
       "2  37d3fd67f62bd1e0a2dea4f9cd440d98                       0   \n",
       "3  519b759442c1cab0e9b5a8a1acb1b216                       0   \n",
       "4  ef0af4927b575b1a3e607c11ca37870e                       1   \n",
       "\n",
       "  How many employees does your company or organization have?  \\\n",
       "0                                            100-500           \n",
       "1                                            100-500           \n",
       "2                                             25-Jun           \n",
       "3                                     More than 1000           \n",
       "4                                                NaN           \n",
       "\n",
       "   Is your employer primarily a tech company/organization?  \\\n",
       "0                                                1.0         \n",
       "1                                                1.0         \n",
       "2                                                1.0         \n",
       "3                                                1.0         \n",
       "4                                                NaN         \n",
       "\n",
       "   Is your primary role within your company related to tech/IT?  \\\n",
       "0                                                1.0              \n",
       "1                                                1.0              \n",
       "2                                                1.0              \n",
       "3                                                1.0              \n",
       "4                                                NaN              \n",
       "\n",
       "  Does your employer provide mental health benefits as part of healthcare coverage?  \\\n",
       "0                                                 No                                  \n",
       "1                                                Yes                                  \n",
       "2                                       I don't know                                  \n",
       "3                                                Yes                                  \n",
       "4                                                NaN                                  \n",
       "\n",
       "  Do you know the options for mental health care available under your employer-provided health coverage?  \\\n",
       "0                                                Yes                                                       \n",
       "1                                                Yes                                                       \n",
       "2                                                 No                                                       \n",
       "3                                                Yes                                                       \n",
       "4                                                NaN                                                       \n",
       "\n",
       "  Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?  \\\n",
       "0                                                 No                                                                                       \n",
       "1                                                 No                                                                                       \n",
       "2                                       I don't know                                                                                       \n",
       "3                                       I don't know                                                                                       \n",
       "4                                                NaN                                                                                       \n",
       "\n",
       "  Does your employer offer resources to learn more about mental health disorders and options for seeking help?  \\\n",
       "0                                       I don't know                                                             \n",
       "1                                                 No                                                             \n",
       "2                                                 No                                                             \n",
       "3                                       I don't know                                                             \n",
       "4                                                NaN                                                             \n",
       "\n",
       "  Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?  \\\n",
       "0                                       I don't know                                                                                               \n",
       "1                                       I don't know                                                                                               \n",
       "2                                                Yes                                                                                               \n",
       "3                                                Yes                                                                                               \n",
       "4                                                NaN                                                                                               \n",
       "\n",
       "   ... What is your gender? What country do you live in?  \\\n",
       "0  ...               Female               United Kingdom   \n",
       "1  ...                 male               United Kingdom   \n",
       "2  ...                 male     United States of America   \n",
       "3  ...                 Male     United States of America   \n",
       "4  ...               female     United States of America   \n",
       "\n",
       "  What US state or territory do you live in?          What is your race?  \\\n",
       "0                                        NaN                         NaN   \n",
       "1                                        NaN                         NaN   \n",
       "2                                   Missouri                       White   \n",
       "3                                 Washington                       White   \n",
       "4                                   Illinois  More than one of the above   \n",
       "\n",
       "  Other.3 What country do you work in?  \\\n",
       "0     NaN               United Kingdom   \n",
       "1     NaN               United Kingdom   \n",
       "2     NaN     United States of America   \n",
       "3     NaN     United States of America   \n",
       "4     NaN     United States of America   \n",
       "\n",
       "   What US state or territory do you work in? Start Date (UTC)  \\\n",
       "0                                         NaN    5/16/18 12:32   \n",
       "1                                         NaN    5/16/18 12:31   \n",
       "2                                    Missouri      5/9/18 5:34   \n",
       "3                                  Washington     5/4/18 23:19   \n",
       "4                                    Illinois      5/3/18 0:40   \n",
       "\n",
       "   Submit Date (UTC)  Network ID  \n",
       "0      5/16/18 12:42  464b7a12f1  \n",
       "1      5/16/18 12:40  464b7a12f1  \n",
       "2        5/9/18 5:46  1eb7e0cb94  \n",
       "3       5/4/18 23:23  63852edbc4  \n",
       "4        5/3/18 0:53  43237889f1  \n",
       "\n",
       "[5 rows x 123 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Load 2017 data\n",
    "csv_2017 = pd.read_csv('OSMI Mental Health in Tech Survey 2017.csv')\n",
    "\n",
    "data_2017 = pd.DataFrame(csv_2017)\n",
    "data_2017.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "0fd18a8b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "756"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "number_of_rows_2017 = len(data_2017)\n",
    "number_of_rows_2017"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "d88c282a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "#                                                               756\n",
       "Are you self-employed?                                          756\n",
       "How many employees does your company or organization have?      643\n",
       "Is your employer primarily a tech company/organization?         643\n",
       "Is your primary role within your company related to tech/IT?    643\n",
       "                                                               ... \n",
       "What country do you work in?                                    754\n",
       "What US state or territory do you work in?                      503\n",
       "Start Date (UTC)                                                756\n",
       "Submit Date (UTC)                                               756\n",
       "Network ID                                                      756\n",
       "Length: 123, dtype: int64"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_2017.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "61736406",
   "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>Are you self-employed?</th>\n",
       "      <th>How many employees does your company or organization have?</th>\n",
       "      <th>Is your employer primarily a tech company/organization?</th>\n",
       "      <th>Is your primary role within your company related to tech/IT?</th>\n",
       "      <th>Does your employer provide mental health benefits as part of healthcare coverage?</th>\n",
       "      <th>Do you know the options for mental health care available under your employer-provided health coverage?</th>\n",
       "      <th>Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?</th>\n",
       "      <th>Does your employer offer resources to learn more about mental health disorders and options for seeking help?</th>\n",
       "      <th>Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?</th>\n",
       "      <th>...</th>\n",
       "      <th>What is your gender?</th>\n",
       "      <th>What country do you live in?</th>\n",
       "      <th>What US state or territory do you live in?</th>\n",
       "      <th>What is your race?</th>\n",
       "      <th>Other.3</th>\n",
       "      <th>What country do you work in?</th>\n",
       "      <th>What US state or territory do you work in?</th>\n",
       "      <th>Start Date (UTC)</th>\n",
       "      <th>Submit Date (UTC)</th>\n",
       "      <th>Network ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>e44a0a34f2465940beda2a1537e9b99e</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Canada</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/29/18 23:46</td>\n",
       "      <td>12/30/18 0:00</td>\n",
       "      <td>4bbb884ccc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0d698e3beca20fb75f19b9d528e36d73</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Massachusetts</td>\n",
       "      <td>12/27/18 21:40</td>\n",
       "      <td>12/27/18 21:45</td>\n",
       "      <td>275e7543bd</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>61a40c9071eb36fa9caa254d31500c41</td>\n",
       "      <td>0</td>\n",
       "      <td>25-Jun</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Florida</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Florida</td>\n",
       "      <td>12/21/18 17:37</td>\n",
       "      <td>12/21/18 18:08</td>\n",
       "      <td>43994c3dba</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>f8624340bead7deb08abb766704ddf6b</td>\n",
       "      <td>0</td>\n",
       "      <td>25-Jun</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>male</td>\n",
       "      <td>Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Norway</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/21/18 16:37</td>\n",
       "      <td>12/21/18 16:44</td>\n",
       "      <td>907b3a3faa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31d3ae93b68d79e504a0a643601b6b1e</td>\n",
       "      <td>0</td>\n",
       "      <td>26-100</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>Ostensibly Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>White</td>\n",
       "      <td>NaN</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Tennessee</td>\n",
       "      <td>12/20/18 19:39</td>\n",
       "      <td>12/20/18 20:58</td>\n",
       "      <td>26df20fea3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 123 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  #  Are you self-employed?  \\\n",
       "0  e44a0a34f2465940beda2a1537e9b99e                       0   \n",
       "1  0d698e3beca20fb75f19b9d528e36d73                       0   \n",
       "2  61a40c9071eb36fa9caa254d31500c41                       0   \n",
       "3  f8624340bead7deb08abb766704ddf6b                       0   \n",
       "4  31d3ae93b68d79e504a0a643601b6b1e                       0   \n",
       "\n",
       "  How many employees does your company or organization have?  \\\n",
       "0                                     More than 1000           \n",
       "1                                     More than 1000           \n",
       "2                                             25-Jun           \n",
       "3                                             25-Jun           \n",
       "4                                             26-100           \n",
       "\n",
       "   Is your employer primarily a tech company/organization?  \\\n",
       "0                                                1.0         \n",
       "1                                                1.0         \n",
       "2                                                0.0         \n",
       "3                                                1.0         \n",
       "4                                                1.0         \n",
       "\n",
       "   Is your primary role within your company related to tech/IT?  \\\n",
       "0                                                0.0              \n",
       "1                                                1.0              \n",
       "2                                                1.0              \n",
       "3                                                1.0              \n",
       "4                                                1.0              \n",
       "\n",
       "  Does your employer provide mental health benefits as part of healthcare coverage?  \\\n",
       "0                                                Yes                                  \n",
       "1                                                Yes                                  \n",
       "2                                                Yes                                  \n",
       "3                                                 No                                  \n",
       "4                                                Yes                                  \n",
       "\n",
       "  Do you know the options for mental health care available under your employer-provided health coverage?  \\\n",
       "0                                                Yes                                                       \n",
       "1                                                Yes                                                       \n",
       "2                                                Yes                                                       \n",
       "3                                                 No                                                       \n",
       "4                                                Yes                                                       \n",
       "\n",
       "  Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?  \\\n",
       "0                                                Yes                                                                                       \n",
       "1                                                 No                                                                                       \n",
       "2                                                 No                                                                                       \n",
       "3                                                 No                                                                                       \n",
       "4                                                Yes                                                                                       \n",
       "\n",
       "  Does your employer offer resources to learn more about mental health disorders and options for seeking help?  \\\n",
       "0                                                Yes                                                             \n",
       "1                                       I don't know                                                             \n",
       "2                                                 No                                                             \n",
       "3                                                 No                                                             \n",
       "4                                                Yes                                                             \n",
       "\n",
       "  Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?  \\\n",
       "0                                                Yes                                                                                               \n",
       "1                                       I don't know                                                                                               \n",
       "2                                       I don't know                                                                                               \n",
       "3                                       I don't know                                                                                               \n",
       "4                                                Yes                                                                                               \n",
       "\n",
       "   ... What is your gender? What country do you live in?  \\\n",
       "0  ...               Female                       Canada   \n",
       "1  ...                 male     United States of America   \n",
       "2  ...                 Male     United States of America   \n",
       "3  ...                 male                       Norway   \n",
       "4  ...      Ostensibly Male     United States of America   \n",
       "\n",
       "  What US state or territory do you live in?  What is your race? Other.3  \\\n",
       "0                                        NaN                 NaN     NaN   \n",
       "1                              Massachusetts               White     NaN   \n",
       "2                                    Florida               White     NaN   \n",
       "3                                        NaN                 NaN     NaN   \n",
       "4                                  Tennessee               White     NaN   \n",
       "\n",
       "  What country do you work in?  What US state or territory do you work in?  \\\n",
       "0                       Canada                                         NaN   \n",
       "1     United States of America                               Massachusetts   \n",
       "2     United States of America                                     Florida   \n",
       "3                       Norway                                         NaN   \n",
       "4     United States of America                                   Tennessee   \n",
       "\n",
       "  Start Date (UTC)  Submit Date (UTC)  Network ID  \n",
       "0   12/29/18 23:46      12/30/18 0:00  4bbb884ccc  \n",
       "1   12/27/18 21:40     12/27/18 21:45  275e7543bd  \n",
       "2   12/21/18 17:37     12/21/18 18:08  43994c3dba  \n",
       "3   12/21/18 16:37     12/21/18 16:44  907b3a3faa  \n",
       "4   12/20/18 19:39     12/20/18 20:58  26df20fea3  \n",
       "\n",
       "[5 rows x 123 columns]"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csv_2018 = pd.read_csv('OSMI Mental Health in Tech Survey 2018.csv')\n",
    "data_2018 = pd.DataFrame(csv_2018)\n",
    "data_2018.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "ab316eba",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "417"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "number_of_rows_2018 = len(data_2018)\n",
    "number_of_rows_2018"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "f45d5e62",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "#                                                               417\n",
       "Are you self-employed?                                          417\n",
       "How many employees does your company or organization have?      361\n",
       "Is your employer primarily a tech company/organization?         361\n",
       "Is your primary role within your company related to tech/IT?    361\n",
       "                                                               ... \n",
       "What country do you work in?                                    417\n",
       "What US state or territory do you work in?                      314\n",
       "Start Date (UTC)                                                417\n",
       "Submit Date (UTC)                                               417\n",
       "Network ID                                                      417\n",
       "Length: 123, dtype: int64"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_2018.count()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "4ec362b2",
   "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>Are you self-employed?</th>\n",
       "      <th>How many employees does your company or organization have?</th>\n",
       "      <th>Is your employer primarily a tech company/organization?</th>\n",
       "      <th>Is your primary role within your company related to tech/IT?</th>\n",
       "      <th>Does your employer provide mental health benefits as part of healthcare coverage?</th>\n",
       "      <th>Do you know the options for mental health care available under your employer-provided health coverage?</th>\n",
       "      <th>Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?</th>\n",
       "      <th>Does your employer offer resources to learn more about mental health disorders and options for seeking help?</th>\n",
       "      <th>Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?</th>\n",
       "      <th>If a mental health issue prompted you to request a medical leave from work, how easy or difficult would it be to ask for that leave?</th>\n",
       "      <th>...</th>\n",
       "      <th>Briefly describe what you think the industry as a whole and/or employers could do to improve mental health support for employees.</th>\n",
       "      <th>If there is anything else you would like to tell us that has not been covered by the survey questions, please use this space to do so.</th>\n",
       "      <th>Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used _anonymously_ and only with your permission.)</th>\n",
       "      <th>What is your age?</th>\n",
       "      <th>What is your gender?</th>\n",
       "      <th>What country do you live in?</th>\n",
       "      <th>What US state or territory do you live in?</th>\n",
       "      <th>What is your race?</th>\n",
       "      <th>What country do you work in?</th>\n",
       "      <th>What US state or territory do you work in?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>False</td>\n",
       "      <td>26-100</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Very easy</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>25</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>White</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>False</td>\n",
       "      <td>26-100</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>51</td>\n",
       "      <td>male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>White</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>False</td>\n",
       "      <td>26-100</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Somewhat difficult</td>\n",
       "      <td>...</td>\n",
       "      <td>I think opening up more conversation around th...</td>\n",
       "      <td>Thank you</td>\n",
       "      <td>True</td>\n",
       "      <td>27</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>White</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Illinois</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>False</td>\n",
       "      <td>100-500</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Very easy</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>37</td>\n",
       "      <td>male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>White</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>False</td>\n",
       "      <td>26-100</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>46</td>\n",
       "      <td>m</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "      <td>White</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>Nebraska</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 82 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   Are you self-employed?  \\\n",
       "0                   False   \n",
       "1                   False   \n",
       "2                   False   \n",
       "3                   False   \n",
       "4                   False   \n",
       "\n",
       "  How many employees does your company or organization have?  \\\n",
       "0                                             26-100           \n",
       "1                                             26-100           \n",
       "2                                             26-100           \n",
       "3                                            100-500           \n",
       "4                                             26-100           \n",
       "\n",
       "  Is your employer primarily a tech company/organization?  \\\n",
       "0                                               True        \n",
       "1                                               True        \n",
       "2                                               True        \n",
       "3                                               True        \n",
       "4                                               True        \n",
       "\n",
       "  Is your primary role within your company related to tech/IT?  \\\n",
       "0                                               True             \n",
       "1                                               True             \n",
       "2                                               True             \n",
       "3                                               True             \n",
       "4                                               True             \n",
       "\n",
       "  Does your employer provide mental health benefits as part of healthcare coverage?  \\\n",
       "0                                       I don't know                                  \n",
       "1                                                Yes                                  \n",
       "2                                       I don't know                                  \n",
       "3                                       I don't know                                  \n",
       "4                                       I don't know                                  \n",
       "\n",
       "  Do you know the options for mental health care available under your employer-provided health coverage?  \\\n",
       "0                                                 No                                                       \n",
       "1                                                 No                                                       \n",
       "2                                                 No                                                       \n",
       "3                                                 No                                                       \n",
       "4                                                 No                                                       \n",
       "\n",
       "  Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?  \\\n",
       "0                                                Yes                                                                                       \n",
       "1                                                 No                                                                                       \n",
       "2                                                 No                                                                                       \n",
       "3                                                Yes                                                                                       \n",
       "4                                       I don't know                                                                                       \n",
       "\n",
       "  Does your employer offer resources to learn more about mental health disorders and options for seeking help?  \\\n",
       "0                                                Yes                                                             \n",
       "1                                                Yes                                                             \n",
       "2                                       I don't know                                                             \n",
       "3                                                Yes                                                             \n",
       "4                                       I don't know                                                             \n",
       "\n",
       "  Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?  \\\n",
       "0                                       I don't know                                                                                               \n",
       "1                                                Yes                                                                                               \n",
       "2                                       I don't know                                                                                               \n",
       "3                                                Yes                                                                                               \n",
       "4                                       I don't know                                                                                               \n",
       "\n",
       "  If a mental health issue prompted you to request a medical leave from work, how easy or difficult would it be to ask for that leave?  \\\n",
       "0                                          Very easy                                                                                     \n",
       "1                                       I don't know                                                                                     \n",
       "2                                 Somewhat difficult                                                                                     \n",
       "3                                          Very easy                                                                                     \n",
       "4                                       I don't know                                                                                     \n",
       "\n",
       "   ...  \\\n",
       "0  ...   \n",
       "1  ...   \n",
       "2  ...   \n",
       "3  ...   \n",
       "4  ...   \n",
       "\n",
       "  Briefly describe what you think the industry as a whole and/or employers could do to improve mental health support for employees.  \\\n",
       "0                                                NaN                                                                                  \n",
       "1                                                NaN                                                                                  \n",
       "2  I think opening up more conversation around th...                                                                                  \n",
       "3                                                NaN                                                                                  \n",
       "4                                                NaN                                                                                  \n",
       "\n",
       "  If there is anything else you would like to tell us that has not been covered by the survey questions, please use this space to do so.  \\\n",
       "0                                                NaN                                                                                       \n",
       "1                                                NaN                                                                                       \n",
       "2                                          Thank you                                                                                       \n",
       "3                                                NaN                                                                                       \n",
       "4                                                NaN                                                                                       \n",
       "\n",
       "  Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used _anonymously_ and only with your permission.)  \\\n",
       "0                                              False                                                                                                                                                                                 \n",
       "1                                              False                                                                                                                                                                                 \n",
       "2                                               True                                                                                                                                                                                 \n",
       "3                                              False                                                                                                                                                                                 \n",
       "4                                              False                                                                                                                                                                                 \n",
       "\n",
       "  What is your age? What is your gender? What country do you live in?  \\\n",
       "0                25                 Male     United States of America   \n",
       "1                51                 male     United States of America   \n",
       "2                27                 Male     United States of America   \n",
       "3                37                 male     United States of America   \n",
       "4                46                    m     United States of America   \n",
       "\n",
       "  What US state or territory do you live in? What is your race?  \\\n",
       "0                                   Nebraska              White   \n",
       "1                                   Nebraska              White   \n",
       "2                                   Illinois              White   \n",
       "3                                   Nebraska              White   \n",
       "4                                   Nebraska              White   \n",
       "\n",
       "  What country do you work in?  What US state or territory do you work in?  \n",
       "0     United States of America                                    Nebraska  \n",
       "1     United States of America                                    Nebraska  \n",
       "2     United States of America                                    Illinois  \n",
       "3     United States of America                                    Nebraska  \n",
       "4     United States of America                                    Nebraska  \n",
       "\n",
       "[5 rows x 82 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "csv_2019 = pd.read_csv('OSMI 2019 Mental Health in Tech Survey Results - OSMI Mental Health in Tech Survey 2019.csv')\n",
    "data_2019 = pd.DataFrame(csv_2019)\n",
    "data_2019.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "e9b0977c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "352"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "number_of_rows_2019 = len(data_2019)\n",
    "number_of_rows_2019"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "9da0d75e",
   "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>Are you self-employed?</th>\n",
       "      <th>How many employees does your company or organization have?</th>\n",
       "      <th>Is your employer primarily a tech company/organization?</th>\n",
       "      <th>Is your primary role within your company related to tech/IT?</th>\n",
       "      <th>Does your employer provide mental health benefits as part of healthcare coverage?</th>\n",
       "      <th>Do you know the options for mental health care available under your employer-provided health coverage?</th>\n",
       "      <th>Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?</th>\n",
       "      <th>Does your employer offer resources to learn more about mental health disorders and options for seeking help?</th>\n",
       "      <th>Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?</th>\n",
       "      <th>...</th>\n",
       "      <th>Network ID</th>\n",
       "      <th>Does your employer provide mental health benefits as part of healthcare coverage?</th>\n",
       "      <th>If they knew you suffered from a mental health disorder, how do you think that team members/co-workers would react?</th>\n",
       "      <th>Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used &lt;em&gt;anonymously and only with your permission.)</th>\n",
       "      <th>What disorder(s) have you been diagnosed with?</th>\n",
       "      <th>If possibly, what disorder(s) do you believe you have?</th>\n",
       "      <th>If so, what disorder(s) were you diagnosed with?</th>\n",
       "      <th>If they knew you suffered from a mental health disorder, how do you think that your team members/co-workers would react?</th>\n",
       "      <th>Have you observed or experienced a supportive or well handled response to a mental health issue in your current or previous workplace?</th>\n",
       "      <th>Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used _anonymously_ and only with your permission.)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>e49fe87572831232dcfa51b376b22039</td>\n",
       "      <td>0</td>\n",
       "      <td>100-500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>464b7a12f1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a1eede444ac024928d247a8372d54931</td>\n",
       "      <td>0</td>\n",
       "      <td>100-500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>464b7a12f1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37d3fd67f62bd1e0a2dea4f9cd440d98</td>\n",
       "      <td>0</td>\n",
       "      <td>25-Jun</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>1eb7e0cb94</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>519b759442c1cab0e9b5a8a1acb1b216</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>63852edbc4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ef0af4927b575b1a3e607c11ca37870e</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>43237889f1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</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>347</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mood Disorder (Depression, Bipolar Disorder, etc)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Maybe/Not sure</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>348</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>No</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>10.0</td>\n",
       "      <td>I've always been self-employed</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>350</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Mood Disorder (Depression, Bipolar Disorder, etc)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>351</th>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Anxiety Disorder (Generalized, Social, Phobia,...</td>\n",
       "      <td>3.0</td>\n",
       "      <td>No</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1525 rows × 132 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    #  Are you self-employed?  \\\n",
       "0    e49fe87572831232dcfa51b376b22039                       0   \n",
       "1    a1eede444ac024928d247a8372d54931                       0   \n",
       "2    37d3fd67f62bd1e0a2dea4f9cd440d98                       0   \n",
       "3    519b759442c1cab0e9b5a8a1acb1b216                       0   \n",
       "4    ef0af4927b575b1a3e607c11ca37870e                       1   \n",
       "..                                ...                     ...   \n",
       "347                               NaN                       0   \n",
       "348                               NaN                       1   \n",
       "349                               NaN                       1   \n",
       "350                               NaN                       0   \n",
       "351                               NaN                       0   \n",
       "\n",
       "    How many employees does your company or organization have?  \\\n",
       "0                                              100-500           \n",
       "1                                              100-500           \n",
       "2                                               25-Jun           \n",
       "3                                       More than 1000           \n",
       "4                                                  NaN           \n",
       "..                                                 ...           \n",
       "347                                     More than 1000           \n",
       "348                                                NaN           \n",
       "349                                                NaN           \n",
       "350                                     More than 1000           \n",
       "351                                     More than 1000           \n",
       "\n",
       "    Is your employer primarily a tech company/organization?  \\\n",
       "0                                                  1.0        \n",
       "1                                                  1.0        \n",
       "2                                                  1.0        \n",
       "3                                                  1.0        \n",
       "4                                                  NaN        \n",
       "..                                                 ...        \n",
       "347                                              False        \n",
       "348                                                NaN        \n",
       "349                                                NaN        \n",
       "350                                               True        \n",
       "351                                               True        \n",
       "\n",
       "    Is your primary role within your company related to tech/IT?  \\\n",
       "0                                                  1.0             \n",
       "1                                                  1.0             \n",
       "2                                                  1.0             \n",
       "3                                                  1.0             \n",
       "4                                                  NaN             \n",
       "..                                                 ...             \n",
       "347                                               True             \n",
       "348                                                NaN             \n",
       "349                                                NaN             \n",
       "350                                               True             \n",
       "351                                               True             \n",
       "\n",
       "    Does your employer provide mental health benefits as part of healthcare coverage?  \\\n",
       "0                                                   No                                  \n",
       "1                                                  Yes                                  \n",
       "2                                         I don't know                                  \n",
       "3                                                  Yes                                  \n",
       "4                                                  NaN                                  \n",
       "..                                                 ...                                  \n",
       "347                                                NaN                                  \n",
       "348                                                NaN                                  \n",
       "349                                                NaN                                  \n",
       "350                                                NaN                                  \n",
       "351                                                NaN                                  \n",
       "\n",
       "    Do you know the options for mental health care available under your employer-provided health coverage?  \\\n",
       "0                                                  Yes                                                       \n",
       "1                                                  Yes                                                       \n",
       "2                                                   No                                                       \n",
       "3                                                  Yes                                                       \n",
       "4                                                  NaN                                                       \n",
       "..                                                 ...                                                       \n",
       "347                                                 No                                                       \n",
       "348                                                NaN                                                       \n",
       "349                                                NaN                                                       \n",
       "350                                                 No                                                       \n",
       "351                                                Yes                                                       \n",
       "\n",
       "    Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?  \\\n",
       "0                                                   No                                                                                       \n",
       "1                                                   No                                                                                       \n",
       "2                                         I don't know                                                                                       \n",
       "3                                         I don't know                                                                                       \n",
       "4                                                  NaN                                                                                       \n",
       "..                                                 ...                                                                                       \n",
       "347                                                 No                                                                                       \n",
       "348                                                NaN                                                                                       \n",
       "349                                                NaN                                                                                       \n",
       "350                                                 No                                                                                       \n",
       "351                                                 No                                                                                       \n",
       "\n",
       "    Does your employer offer resources to learn more about mental health disorders and options for seeking help?  \\\n",
       "0                                         I don't know                                                             \n",
       "1                                                   No                                                             \n",
       "2                                                   No                                                             \n",
       "3                                         I don't know                                                             \n",
       "4                                                  NaN                                                             \n",
       "..                                                 ...                                                             \n",
       "347                                       I don't know                                                             \n",
       "348                                                NaN                                                             \n",
       "349                                                NaN                                                             \n",
       "350                                                 No                                                             \n",
       "351                                                Yes                                                             \n",
       "\n",
       "    Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?  \\\n",
       "0                                         I don't know                                                                                               \n",
       "1                                         I don't know                                                                                               \n",
       "2                                                  Yes                                                                                               \n",
       "3                                                  Yes                                                                                               \n",
       "4                                                  NaN                                                                                               \n",
       "..                                                 ...                                                                                               \n",
       "347                                       I don't know                                                                                               \n",
       "348                                                NaN                                                                                               \n",
       "349                                                NaN                                                                                               \n",
       "350                                                Yes                                                                                               \n",
       "351                                                Yes                                                                                               \n",
       "\n",
       "     ...  Network ID  \\\n",
       "0    ...  464b7a12f1   \n",
       "1    ...  464b7a12f1   \n",
       "2    ...  1eb7e0cb94   \n",
       "3    ...  63852edbc4   \n",
       "4    ...  43237889f1   \n",
       "..   ...         ...   \n",
       "347  ...         NaN   \n",
       "348  ...         NaN   \n",
       "349  ...         NaN   \n",
       "350  ...         NaN   \n",
       "351  ...         NaN   \n",
       "\n",
       "    Does your employer provide mental health benefits as part of healthcare coverage?  \\\n",
       "0                                                  NaN                                  \n",
       "1                                                  NaN                                  \n",
       "2                                                  NaN                                  \n",
       "3                                                  NaN                                  \n",
       "4                                                  NaN                                  \n",
       "..                                                 ...                                  \n",
       "347                                       I don't know                                  \n",
       "348                                                NaN                                  \n",
       "349                                                NaN                                  \n",
       "350                                                 No                                  \n",
       "351                                                Yes                                  \n",
       "\n",
       "    If they knew you suffered from a mental health disorder, how do you think that team members/co-workers would react?  \\\n",
       "0                                                  NaN                                                                    \n",
       "1                                                  NaN                                                                    \n",
       "2                                                  NaN                                                                    \n",
       "3                                                  NaN                                                                    \n",
       "4                                                  NaN                                                                    \n",
       "..                                                 ...                                                                    \n",
       "347                                                NaN                                                                    \n",
       "348                                                NaN                                                                    \n",
       "349                                                NaN                                                                    \n",
       "350                                                NaN                                                                    \n",
       "351                                                NaN                                                                    \n",
       "\n",
       "    Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used <em>anonymously and only with your permission.)  \\\n",
       "0                                                  NaN                                                                                                                                                                                   \n",
       "1                                                  NaN                                                                                                                                                                                   \n",
       "2                                                  NaN                                                                                                                                                                                   \n",
       "3                                                  NaN                                                                                                                                                                                   \n",
       "4                                                  NaN                                                                                                                                                                                   \n",
       "..                                                 ...                                                                                                                                                                                   \n",
       "347                                                NaN                                                                                                                                                                                   \n",
       "348                                                NaN                                                                                                                                                                                   \n",
       "349                                                NaN                                                                                                                                                                                   \n",
       "350                                                NaN                                                                                                                                                                                   \n",
       "351                                                NaN                                                                                                                                                                                   \n",
       "\n",
       "    What disorder(s) have you been diagnosed with?  \\\n",
       "0                                              NaN   \n",
       "1                                              NaN   \n",
       "2                                              NaN   \n",
       "3                                              NaN   \n",
       "4                                              NaN   \n",
       "..                                             ...   \n",
       "347                                            NaN   \n",
       "348                                            NaN   \n",
       "349                                            NaN   \n",
       "350                                            NaN   \n",
       "351                                            NaN   \n",
       "\n",
       "    If possibly, what disorder(s) do you believe you have?  \\\n",
       "0                                                  NaN       \n",
       "1                                                  NaN       \n",
       "2                                                  NaN       \n",
       "3                                                  NaN       \n",
       "4                                                  NaN       \n",
       "..                                                 ...       \n",
       "347  Mood Disorder (Depression, Bipolar Disorder, etc)       \n",
       "348                                                NaN       \n",
       "349                                                NaN       \n",
       "350  Mood Disorder (Depression, Bipolar Disorder, etc)       \n",
       "351                                                NaN       \n",
       "\n",
       "      If so, what disorder(s) were you diagnosed with?  \\\n",
       "0                                                  NaN   \n",
       "1                                                  NaN   \n",
       "2                                                  NaN   \n",
       "3                                                  NaN   \n",
       "4                                                  NaN   \n",
       "..                                                 ...   \n",
       "347                                                NaN   \n",
       "348                                                NaN   \n",
       "349                                                NaN   \n",
       "350                                                NaN   \n",
       "351  Anxiety Disorder (Generalized, Social, Phobia,...   \n",
       "\n",
       "    If they knew you suffered from a mental health disorder, how do you think that your team members/co-workers would react?  \\\n",
       "0                                                  NaN                                                                         \n",
       "1                                                  NaN                                                                         \n",
       "2                                                  NaN                                                                         \n",
       "3                                                  NaN                                                                         \n",
       "4                                                  NaN                                                                         \n",
       "..                                                 ...                                                                         \n",
       "347                                                1.0                                                                         \n",
       "348                                                2.0                                                                         \n",
       "349                                               10.0                                                                         \n",
       "350                                                2.0                                                                         \n",
       "351                                                3.0                                                                         \n",
       "\n",
       "    Have you observed or experienced a supportive or well handled response to a mental health issue in your current or previous workplace?  \\\n",
       "0                                                  NaN                                                                                       \n",
       "1                                                  NaN                                                                                       \n",
       "2                                                  NaN                                                                                       \n",
       "3                                                  NaN                                                                                       \n",
       "4                                                  NaN                                                                                       \n",
       "..                                                 ...                                                                                       \n",
       "347                                     Maybe/Not sure                                                                                       \n",
       "348                                                 No                                                                                       \n",
       "349                     I've always been self-employed                                                                                       \n",
       "350                                 Yes, I experienced                                                                                       \n",
       "351                                                 No                                                                                       \n",
       "\n",
       "    Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used _anonymously_ and only with your permission.)  \n",
       "0                                                  NaN                                                                                                                                                                                \n",
       "1                                                  NaN                                                                                                                                                                                \n",
       "2                                                  NaN                                                                                                                                                                                \n",
       "3                                                  NaN                                                                                                                                                                                \n",
       "4                                                  NaN                                                                                                                                                                                \n",
       "..                                                 ...                                                                                                                                                                                \n",
       "347                                              False                                                                                                                                                                                \n",
       "348                                              False                                                                                                                                                                                \n",
       "349                                              False                                                                                                                                                                                \n",
       "350                                              False                                                                                                                                                                                \n",
       "351                                               True                                                                                                                                                                                \n",
       "\n",
       "[1525 rows x 132 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "years_dataset = pd.concat([data_2017,data_2018, data_2019])\n",
    "years_dataset "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "213691ff",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1525"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "number_of_rows_total = len(years_dataset)\n",
    "number_of_rows_total"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "15eda224",
   "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>Are you self-employed?</th>\n",
       "      <th>How many employees does your company or organization have?</th>\n",
       "      <th>Is your employer primarily a tech company/organization?</th>\n",
       "      <th>Is your primary role within your company related to tech/IT?</th>\n",
       "      <th>Does your employer provide mental health benefits as part of healthcare coverage?</th>\n",
       "      <th>Do you know the options for mental health care available under your employer-provided health coverage?</th>\n",
       "      <th>Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?</th>\n",
       "      <th>Does your employer offer resources to learn more about mental health disorders and options for seeking help?</th>\n",
       "      <th>Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?</th>\n",
       "      <th>...</th>\n",
       "      <th>Network ID</th>\n",
       "      <th>Does your employer provide mental health benefits as part of healthcare coverage?</th>\n",
       "      <th>If they knew you suffered from a mental health disorder, how do you think that team members/co-workers would react?</th>\n",
       "      <th>Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used &lt;em&gt;anonymously and only with your permission.)</th>\n",
       "      <th>What disorder(s) have you been diagnosed with?</th>\n",
       "      <th>If possibly, what disorder(s) do you believe you have?</th>\n",
       "      <th>If so, what disorder(s) were you diagnosed with?</th>\n",
       "      <th>If they knew you suffered from a mental health disorder, how do you think that your team members/co-workers would react?</th>\n",
       "      <th>Have you observed or experienced a supportive or well handled response to a mental health issue in your current or previous workplace?</th>\n",
       "      <th>Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used _anonymously_ and only with your permission.)</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>e49fe87572831232dcfa51b376b22039</td>\n",
       "      <td>0</td>\n",
       "      <td>100-500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>464b7a12f1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>a1eede444ac024928d247a8372d54931</td>\n",
       "      <td>0</td>\n",
       "      <td>100-500</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>...</td>\n",
       "      <td>464b7a12f1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>37d3fd67f62bd1e0a2dea4f9cd440d98</td>\n",
       "      <td>0</td>\n",
       "      <td>25-Jun</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>1eb7e0cb94</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>519b759442c1cab0e9b5a8a1acb1b216</td>\n",
       "      <td>0</td>\n",
       "      <td>More than 1000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes</td>\n",
       "      <td>...</td>\n",
       "      <td>63852edbc4</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>ef0af4927b575b1a3e607c11ca37870e</td>\n",
       "      <td>1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>43237889f1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 132 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                  #  Are you self-employed?  \\\n",
       "0  e49fe87572831232dcfa51b376b22039                       0   \n",
       "1  a1eede444ac024928d247a8372d54931                       0   \n",
       "2  37d3fd67f62bd1e0a2dea4f9cd440d98                       0   \n",
       "3  519b759442c1cab0e9b5a8a1acb1b216                       0   \n",
       "4  ef0af4927b575b1a3e607c11ca37870e                       1   \n",
       "\n",
       "  How many employees does your company or organization have?  \\\n",
       "0                                            100-500           \n",
       "1                                            100-500           \n",
       "2                                             25-Jun           \n",
       "3                                     More than 1000           \n",
       "4                                                NaN           \n",
       "\n",
       "  Is your employer primarily a tech company/organization?  \\\n",
       "0                                                1.0        \n",
       "1                                                1.0        \n",
       "2                                                1.0        \n",
       "3                                                1.0        \n",
       "4                                                NaN        \n",
       "\n",
       "  Is your primary role within your company related to tech/IT?  \\\n",
       "0                                                1.0             \n",
       "1                                                1.0             \n",
       "2                                                1.0             \n",
       "3                                                1.0             \n",
       "4                                                NaN             \n",
       "\n",
       "  Does your employer provide mental health benefits as part of healthcare coverage?  \\\n",
       "0                                                 No                                  \n",
       "1                                                Yes                                  \n",
       "2                                       I don't know                                  \n",
       "3                                                Yes                                  \n",
       "4                                                NaN                                  \n",
       "\n",
       "  Do you know the options for mental health care available under your employer-provided health coverage?  \\\n",
       "0                                                Yes                                                       \n",
       "1                                                Yes                                                       \n",
       "2                                                 No                                                       \n",
       "3                                                Yes                                                       \n",
       "4                                                NaN                                                       \n",
       "\n",
       "  Has your employer ever formally discussed mental health (for example, as part of a wellness campaign or other official communication)?  \\\n",
       "0                                                 No                                                                                       \n",
       "1                                                 No                                                                                       \n",
       "2                                       I don't know                                                                                       \n",
       "3                                       I don't know                                                                                       \n",
       "4                                                NaN                                                                                       \n",
       "\n",
       "  Does your employer offer resources to learn more about mental health disorders and options for seeking help?  \\\n",
       "0                                       I don't know                                                             \n",
       "1                                                 No                                                             \n",
       "2                                                 No                                                             \n",
       "3                                       I don't know                                                             \n",
       "4                                                NaN                                                             \n",
       "\n",
       "  Is your anonymity protected if you choose to take advantage of mental health or substance abuse treatment resources provided by your employer?  \\\n",
       "0                                       I don't know                                                                                               \n",
       "1                                       I don't know                                                                                               \n",
       "2                                                Yes                                                                                               \n",
       "3                                                Yes                                                                                               \n",
       "4                                                NaN                                                                                               \n",
       "\n",
       "   ...  Network ID  \\\n",
       "0  ...  464b7a12f1   \n",
       "1  ...  464b7a12f1   \n",
       "2  ...  1eb7e0cb94   \n",
       "3  ...  63852edbc4   \n",
       "4  ...  43237889f1   \n",
       "\n",
       "  Does your employer provide mental health benefits as part of healthcare coverage?  \\\n",
       "0                                                NaN                                  \n",
       "1                                                NaN                                  \n",
       "2                                                NaN                                  \n",
       "3                                                NaN                                  \n",
       "4                                                NaN                                  \n",
       "\n",
       "  If they knew you suffered from a mental health disorder, how do you think that team members/co-workers would react?  \\\n",
       "0                                                NaN                                                                    \n",
       "1                                                NaN                                                                    \n",
       "2                                                NaN                                                                    \n",
       "3                                                NaN                                                                    \n",
       "4                                                NaN                                                                    \n",
       "\n",
       "  Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used <em>anonymously and only with your permission.)  \\\n",
       "0                                                NaN                                                                                                                                                                                   \n",
       "1                                                NaN                                                                                                                                                                                   \n",
       "2                                                NaN                                                                                                                                                                                   \n",
       "3                                                NaN                                                                                                                                                                                   \n",
       "4                                                NaN                                                                                                                                                                                   \n",
       "\n",
       "  What disorder(s) have you been diagnosed with?  \\\n",
       "0                                            NaN   \n",
       "1                                            NaN   \n",
       "2                                            NaN   \n",
       "3                                            NaN   \n",
       "4                                            NaN   \n",
       "\n",
       "  If possibly, what disorder(s) do you believe you have?  \\\n",
       "0                                                NaN       \n",
       "1                                                NaN       \n",
       "2                                                NaN       \n",
       "3                                                NaN       \n",
       "4                                                NaN       \n",
       "\n",
       "  If so, what disorder(s) were you diagnosed with?  \\\n",
       "0                                              NaN   \n",
       "1                                              NaN   \n",
       "2                                              NaN   \n",
       "3                                              NaN   \n",
       "4                                              NaN   \n",
       "\n",
       "  If they knew you suffered from a mental health disorder, how do you think that your team members/co-workers would react?  \\\n",
       "0                                                NaN                                                                         \n",
       "1                                                NaN                                                                         \n",
       "2                                                NaN                                                                         \n",
       "3                                                NaN                                                                         \n",
       "4                                                NaN                                                                         \n",
       "\n",
       "  Have you observed or experienced a supportive or well handled response to a mental health issue in your current or previous workplace?  \\\n",
       "0                                                NaN                                                                                       \n",
       "1                                                NaN                                                                                       \n",
       "2                                                NaN                                                                                       \n",
       "3                                                NaN                                                                                       \n",
       "4                                                NaN                                                                                       \n",
       "\n",
       "  Would you be willing to talk to one of us more extensively about your experiences with mental health issues in the tech industry? (Note that all interview responses would be used _anonymously_ and only with your permission.)  \n",
       "0                                                NaN                                                                                                                                                                                \n",
       "1                                                NaN                                                                                                                                                                                \n",
       "2                                                NaN                                                                                                                                                                                \n",
       "3                                                NaN                                                                                                                                                                                \n",
       "4                                                NaN                                                                                                                                                                                \n",
       "\n",
       "[5 rows x 132 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "years_dataset.head(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "f4e762b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "#print(data_2017[~data_2018.column1.isin(data_2017.column1)])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d71d050e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.10"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}