Creating_SQLite_db.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Creating a SQLite Database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Import dependencies \n",
    "import pandas as pd\n",
    "import sqlalchemy\n",
    "from sqlalchemy.ext.automap import automap_base\n",
    "from sqlalchemy.orm import Session\n",
    "from sqlalchemy import create_engine, func, text\n",
    "\n",
    "from sklearn.ensemble import RandomForestClassifier\n",
    "from sklearn.preprocessing import StandardScaler,OneHotEncoder\n",
    "from sklearn.model_selection import train_test_split\n",
    "from sklearn.metrics import confusion_matrix, accuracy_score, classification_report\n",
    "from sqlalchemy import create_engine"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>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 coverage?</th>\n",
       "      <th>Does your employer offer resources to learn more about mental health concerns and options for seeking help?</th>\n",
       "      <th>If a mental health issue prompted you to request a medical leave from work, asking for that leave would be:</th>\n",
       "      <th>Do you think that discussing a mental health disorder with your employer would have negative consequences?</th>\n",
       "      <th>Do you think that discussing a physical health issue with your employer would have negative consequences?</th>\n",
       "      <th>Do you feel that your employer takes mental health as seriously as physical health?</th>\n",
       "      <th>Have you heard of or observed negative consequences for co-workers who have been open about mental health issues in your workplace?</th>\n",
       "      <th>Do you have previous employers?</th>\n",
       "      <th>Have your previous employers provided mental health benefits?</th>\n",
       "      <th>Were you aware of the options for mental health care provided by your previous employers?</th>\n",
       "      <th>Did your previous employers ever formally discuss mental health (as part of a wellness campaign or other official communication)?</th>\n",
       "      <th>Was your anonymity protected if you chose to take advantage of mental health or substance abuse treatment resources with previous employers?</th>\n",
       "      <th>Do you think that discussing a mental health disorder with previous employers would have negative consequences?</th>\n",
       "      <th>Would you have been willing to discuss a mental health issue with your direct supervisor(s)?</th>\n",
       "      <th>Did you feel that your previous employers took mental health as seriously as physical health?</th>\n",
       "      <th>Did you hear of or observe negative consequences for co-workers with mental health issues in your previous workplaces?</th>\n",
       "      <th>Would you bring up a mental health issue with a potential employer in an interview?</th>\n",
       "      <th>Do you feel that being identified as a person with a mental health issue would hurt your career?</th>\n",
       "      <th>Do you think that team members/co-workers would view you more negatively if they knew you suffered from a mental health issue?</th>\n",
       "      <th>How willing would you be to share with friends and family that you have a mental illness?</th>\n",
       "      <th>Have you observed or experienced an unsupportive or badly handled response to a mental health issue in your current or previous workplace?</th>\n",
       "      <th>Do you have a family history of mental illness?</th>\n",
       "      <th>Have you had a mental health disorder in the past?</th>\n",
       "      <th>Do you currently have a mental health disorder?</th>\n",
       "      <th>Have you been diagnosed with a mental health condition by a medical professional?</th>\n",
       "      <th>Have you ever sought treatment for a mental health issue from a mental health professional?</th>\n",
       "      <th>If you have a mental health issue, do you feel that it interferes with your work when being treated effectively?</th>\n",
       "      <th>If you have a mental health issue, do you feel that it interferes with your work when NOT being treated effectively?</th>\n",
       "      <th>What is your gender?</th>\n",
       "      <th>What country do you live in?</th>\n",
       "      <th>What country do you work in?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes, they all did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>Yes, always</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>No</td>\n",
       "      <td>No, I don't think it would</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>N/A (not currently aware)</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yes</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>No, none did</td>\n",
       "      <td>Yes, I was aware of all of them</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Not applicable to me</td>\n",
       "      <td>Often</td>\n",
       "      <td>Male</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Yes, at all of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Not applicable to me (I do not have a mental i...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>0</td>\n",
       "      <td>Not applicable to me</td>\n",
       "      <td>Not applicable to me</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Very easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I observed</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</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",
       "      <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>856</th>\n",
       "      <td>Yes</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>No, I only became aware later</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Yes, always</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat not open</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>0</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Male</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>857</th>\n",
       "      <td>I don't know</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>N/A (not currently aware)</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes, it has</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>858</th>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Very open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>859</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat difficult</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, it has</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I observed</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>I don't know</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat difficult</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>No, none did</td>\n",
       "      <td>N/A (not currently aware)</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>No</td>\n",
       "      <td>No, I don't think it would</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>861 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Does your employer provide mental health benefits as part of healthcare coverage?   \n",
       "0                                                   No                                 \\\n",
       "1                                                  Yes                                  \n",
       "2                                                  Yes                                  \n",
       "3                                         I don't know                                  \n",
       "4                                                  Yes                                  \n",
       "..                                                 ...                                  \n",
       "856                                                Yes                                  \n",
       "857                                       I don't know                                  \n",
       "858                                                Yes                                  \n",
       "859                                                Yes                                  \n",
       "860                                       I don't know                                  \n",
       "\n",
       "    Do you know the options for mental health care available under your employer-provided coverage?   \n",
       "0                                                  Yes                                               \\\n",
       "1                                                  Yes                                                \n",
       "2                                        I am not sure                                                \n",
       "3                                                   No                                                \n",
       "4                                                  Yes                                                \n",
       "..                                                 ...                                                \n",
       "856                                      I am not sure                                                \n",
       "857                                      I am not sure                                                \n",
       "858                                                 No                                                \n",
       "859                                                Yes                                                \n",
       "860                                      I am not sure                                                \n",
       "\n",
       "    Does your employer offer resources to learn more about mental health concerns and options for seeking help?   \n",
       "0                                                  Yes                                                           \\\n",
       "1                                                   No                                                            \n",
       "2                                                  Yes                                                            \n",
       "3                                                   No                                                            \n",
       "4                                                  Yes                                                            \n",
       "..                                                 ...                                                            \n",
       "856                                                Yes                                                            \n",
       "857                                       I don't know                                                            \n",
       "858                                                 No                                                            \n",
       "859                                                Yes                                                            \n",
       "860                                                Yes                                                            \n",
       "\n",
       "    If a mental health issue prompted you to request a medical leave from work, asking for that leave would be:   \n",
       "0                                        Somewhat easy                                                           \\\n",
       "1                           Neither easy nor difficult                                                            \n",
       "2                                        Somewhat easy                                                            \n",
       "3                                        Somewhat easy                                                            \n",
       "4                                            Very easy                                                            \n",
       "..                                                 ...                                                            \n",
       "856                                      Somewhat easy                                                            \n",
       "857                                      Somewhat easy                                                            \n",
       "858                                      Somewhat easy                                                            \n",
       "859                                 Somewhat difficult                                                            \n",
       "860                                 Somewhat difficult                                                            \n",
       "\n",
       "    Do you think that discussing a mental health disorder with your employer would have negative consequences?   \n",
       "0                                                   No                                                          \\\n",
       "1                                                  Yes                                                           \n",
       "2                                                  Yes                                                           \n",
       "3                                                   No                                                           \n",
       "4                                                   No                                                           \n",
       "..                                                 ...                                                           \n",
       "856                                                 No                                                           \n",
       "857                                              Maybe                                                           \n",
       "858                                                 No                                                           \n",
       "859                                              Maybe                                                           \n",
       "860                                              Maybe                                                           \n",
       "\n",
       "    Do you think that discussing a physical health issue with your employer would have negative consequences?   \n",
       "0                                                   No                                                         \\\n",
       "1                                                Maybe                                                          \n",
       "2                                                  Yes                                                          \n",
       "3                                                   No                                                          \n",
       "4                                                   No                                                          \n",
       "..                                                 ...                                                          \n",
       "856                                                 No                                                          \n",
       "857                                                 No                                                          \n",
       "858                                                 No                                                          \n",
       "859                                              Maybe                                                          \n",
       "860                                                 No                                                          \n",
       "\n",
       "    Do you feel that your employer takes mental health as seriously as physical health?   \n",
       "0                                                  Yes                                   \\\n",
       "1                                                   No                                    \n",
       "2                                                   No                                    \n",
       "3                                                  Yes                                    \n",
       "4                                         I don't know                                    \n",
       "..                                                 ...                                    \n",
       "856                                                Yes                                    \n",
       "857                                       I don't know                                    \n",
       "858                                                Yes                                    \n",
       "859                                       I don't know                                    \n",
       "860                                                 No                                    \n",
       "\n",
       "    Have you heard of or observed negative consequences for co-workers who have been open about mental health issues in your workplace?   \n",
       "0                                                   No                                                                                   \\\n",
       "1                                                   No                                                                                    \n",
       "2                                                  Yes                                                                                    \n",
       "3                                                   No                                                                                    \n",
       "4                                                   No                                                                                    \n",
       "..                                                 ...                                                                                    \n",
       "856                                                 No                                                                                    \n",
       "857                                                 No                                                                                    \n",
       "858                                                 No                                                                                    \n",
       "859                                                Yes                                                                                    \n",
       "860                                                 No                                                                                    \n",
       "\n",
       "     Do you have previous employers?   \n",
       "0                                  1  \\\n",
       "1                                  1   \n",
       "2                                  1   \n",
       "3                                  1   \n",
       "4                                  1   \n",
       "..                               ...   \n",
       "856                                1   \n",
       "857                                1   \n",
       "858                                1   \n",
       "859                                1   \n",
       "860                                1   \n",
       "\n",
       "    Have your previous employers provided mental health benefits?   \n",
       "0                                    Yes, they all did             \\\n",
       "1                                         I don't know              \n",
       "2                                         No, none did              \n",
       "3                                             Some did              \n",
       "4                                             Some did              \n",
       "..                                                 ...              \n",
       "856                                           Some did              \n",
       "857                                       I don't know              \n",
       "858                                           Some did              \n",
       "859                                           Some did              \n",
       "860                                       No, none did              \n",
       "\n",
       "    Were you aware of the options for mental health care provided by your previous employers?   \n",
       "0                                  I was aware of some                                         \\\n",
       "1                            N/A (not currently aware)                                          \n",
       "2                      Yes, I was aware of all of them                                          \n",
       "3                                  I was aware of some                                          \n",
       "4                                  I was aware of some                                          \n",
       "..                                                 ...                                          \n",
       "856                      No, I only became aware later                                          \n",
       "857                          N/A (not currently aware)                                          \n",
       "858                                I was aware of some                                          \n",
       "859                                I was aware of some                                          \n",
       "860                          N/A (not currently aware)                                          \n",
       "\n",
       "    Did your previous employers ever formally discuss mental health (as part of a wellness campaign or other official communication)?   \n",
       "0                                             None did                                                                                 \\\n",
       "1                                             Some did                                                                                  \n",
       "2                                             None did                                                                                  \n",
       "3                                             None did                                                                                  \n",
       "4                                             Some did                                                                                  \n",
       "..                                                 ...                                                                                  \n",
       "856                                           Some did                                                                                  \n",
       "857                                       I don't know                                                                                  \n",
       "858                                           None did                                                                                  \n",
       "859                                           None did                                                                                  \n",
       "860                                           None did                                                                                  \n",
       "\n",
       "    Was your anonymity protected if you chose to take advantage of mental health or substance abuse treatment resources with previous employers?   \n",
       "0                                          Yes, always                                                                                            \\\n",
       "1                                         I don't know                                                                                             \n",
       "2                                         I don't know                                                                                             \n",
       "3                                         I don't know                                                                                             \n",
       "4                                            Sometimes                                                                                             \n",
       "..                                                 ...                                                                                             \n",
       "856                                        Yes, always                                                                                             \n",
       "857                                       I don't know                                                                                             \n",
       "858                                       I don't know                                                                                             \n",
       "859                                          Sometimes                                                                                             \n",
       "860                                       I don't know                                                                                             \n",
       "\n",
       "    Do you think that discussing a mental health disorder with previous employers would have negative consequences?   \n",
       "0                                         None of them                                                               \\\n",
       "1                                         Some of them                                                                \n",
       "2                                     Yes, all of them                                                                \n",
       "3                                         None of them                                                                \n",
       "4                                         Some of them                                                                \n",
       "..                                                 ...                                                                \n",
       "856                                       Some of them                                                                \n",
       "857                                       Some of them                                                                \n",
       "858                                       Some of them                                                                \n",
       "859                                   Yes, all of them                                                                \n",
       "860                                   Yes, all of them                                                                \n",
       "\n",
       "    Would you have been willing to discuss a mental health issue with your direct supervisor(s)?   \n",
       "0                        Some of my previous employers                                            \\\n",
       "1                        Some of my previous employers                                             \n",
       "2                 No, at none of my previous employers                                             \n",
       "3                 Yes, at all of my previous employers                                             \n",
       "4                        Some of my previous employers                                             \n",
       "..                                                 ...                                             \n",
       "856               No, at none of my previous employers                                             \n",
       "857                      Some of my previous employers                                             \n",
       "858               No, at none of my previous employers                                             \n",
       "859                      Some of my previous employers                                             \n",
       "860               No, at none of my previous employers                                             \n",
       "\n",
       "    Did you feel that your previous employers took mental health as seriously as physical health?   \n",
       "0                                             Some did                                             \\\n",
       "1                                             Some did                                              \n",
       "2                                             None did                                              \n",
       "3                                             Some did                                              \n",
       "4                                             Some did                                              \n",
       "..                                                 ...                                              \n",
       "856                                           Some did                                              \n",
       "857                                           Some did                                              \n",
       "858                                           None did                                              \n",
       "859                                           None did                                              \n",
       "860                                           None did                                              \n",
       "\n",
       "    Did you hear of or observe negative consequences for co-workers with mental health issues in your previous workplaces?   \n",
       "0                                         None of them                                                                      \\\n",
       "1                                         Some of them                                                                       \n",
       "2                                         Some of them                                                                       \n",
       "3                                         None of them                                                                       \n",
       "4                                         Some of them                                                                       \n",
       "..                                                 ...                                                                       \n",
       "856                                       None of them                                                                       \n",
       "857                                       None of them                                                                       \n",
       "858                                   Yes, all of them                                                                       \n",
       "859                                       Some of them                                                                       \n",
       "860                                       None of them                                                                       \n",
       "\n",
       "    Would you bring up a mental health issue with a potential employer in an interview?   \n",
       "0                                                   No                                   \\\n",
       "1                                                   No                                    \n",
       "2                                                Maybe                                    \n",
       "3                                                  Yes                                    \n",
       "4                                                   No                                    \n",
       "..                                                 ...                                    \n",
       "856                                                 No                                    \n",
       "857                                              Maybe                                    \n",
       "858                                                 No                                    \n",
       "859                                                 No                                    \n",
       "860                                                 No                                    \n",
       "\n",
       "    Do you feel that being identified as a person with a mental health issue would hurt your career?   \n",
       "0                           No, I don't think it would                                                \\\n",
       "1                                Yes, I think it would                                                 \n",
       "2                                Yes, I think it would                                                 \n",
       "3                                Yes, I think it would                                                 \n",
       "4                                                Maybe                                                 \n",
       "..                                                 ...                                                 \n",
       "856                              Yes, I think it would                                                 \n",
       "857                                        Yes, it has                                                 \n",
       "858                                              Maybe                                                 \n",
       "859                                        Yes, it has                                                 \n",
       "860                         No, I don't think it would                                                 \n",
       "\n",
       "    Do you think that team members/co-workers would view you more negatively if they knew you suffered from a mental health issue?   \n",
       "0                         No, I don't think they would                                                                              \\\n",
       "1                                                Maybe                                                                               \n",
       "2                                                Maybe                                                                               \n",
       "3                         No, I don't think they would                                                                               \n",
       "4                                                Maybe                                                                               \n",
       "..                                                 ...                                                                               \n",
       "856                                              Maybe                                                                               \n",
       "857                                              Maybe                                                                               \n",
       "858                       No, I don't think they would                                                                               \n",
       "859                       No, I don't think they would                                                                               \n",
       "860                       No, I don't think they would                                                                               \n",
       "\n",
       "    How willing would you be to share with friends and family that you have a mental illness?   \n",
       "0                                        Somewhat open                                         \\\n",
       "1                                        Somewhat open                                          \n",
       "2                                        Somewhat open                                          \n",
       "3    Not applicable to me (I do not have a mental i...                                          \n",
       "4                                        Somewhat open                                          \n",
       "..                                                 ...                                          \n",
       "856                                  Somewhat not open                                          \n",
       "857                                      Somewhat open                                          \n",
       "858                                          Very open                                          \n",
       "859                                      Somewhat open                                          \n",
       "860                                      Somewhat open                                          \n",
       "\n",
       "    Have you observed or experienced an unsupportive or badly handled response to a mental health issue in your current or previous workplace?   \n",
       "0                                                   No                                                                                          \\\n",
       "1                                   Yes, I experienced                                                                                           \n",
       "2                                   Yes, I experienced                                                                                           \n",
       "3                                                   No                                                                                           \n",
       "4                                      Yes, I observed                                                                                           \n",
       "..                                                 ...                                                                                           \n",
       "856                                                 No                                                                                           \n",
       "857                                 Yes, I experienced                                                                                           \n",
       "858                                 Yes, I experienced                                                                                           \n",
       "859                                    Yes, I observed                                                                                           \n",
       "860                                 Yes, I experienced                                                                                           \n",
       "\n",
       "    Do you have a family history of mental illness?   \n",
       "0                                               Yes  \\\n",
       "1                                               Yes   \n",
       "2                                                No   \n",
       "3                                                No   \n",
       "4                                               Yes   \n",
       "..                                              ...   \n",
       "856                                    I don't know   \n",
       "857                                    I don't know   \n",
       "858                                             Yes   \n",
       "859                                             Yes   \n",
       "860                                             Yes   \n",
       "\n",
       "    Have you had a mental health disorder in the past?   \n",
       "0                                                  Yes  \\\n",
       "1                                                  Yes   \n",
       "2                                                   No   \n",
       "3                                                   No   \n",
       "4                                                  Yes   \n",
       "..                                                 ...   \n",
       "856                                              Maybe   \n",
       "857                                                Yes   \n",
       "858                                                Yes   \n",
       "859                                                Yes   \n",
       "860                                              Maybe   \n",
       "\n",
       "    Do you currently have a mental health disorder?   \n",
       "0                                               Yes  \\\n",
       "1                                               Yes   \n",
       "2                                               Yes   \n",
       "3                                                No   \n",
       "4                                               Yes   \n",
       "..                                              ...   \n",
       "856                                           Maybe   \n",
       "857                                             Yes   \n",
       "858                                             Yes   \n",
       "859                                           Maybe   \n",
       "860                                             Yes   \n",
       "\n",
       "    Have you been diagnosed with a mental health condition by a medical professional?   \n",
       "0                                                  Yes                                 \\\n",
       "1                                                  Yes                                  \n",
       "2                                                   No                                  \n",
       "3                                                   No                                  \n",
       "4                                                  Yes                                  \n",
       "..                                                 ...                                  \n",
       "856                                                 No                                  \n",
       "857                                                Yes                                  \n",
       "858                                                Yes                                  \n",
       "859                                                Yes                                  \n",
       "860                                                Yes                                  \n",
       "\n",
       "     Have you ever sought treatment for a mental health issue from a mental health professional?   \n",
       "0                                                    1                                            \\\n",
       "1                                                    1                                             \n",
       "2                                                    1                                             \n",
       "3                                                    0                                             \n",
       "4                                                    1                                             \n",
       "..                                                 ...                                             \n",
       "856                                                  0                                             \n",
       "857                                                  1                                             \n",
       "858                                                  1                                             \n",
       "859                                                  1                                             \n",
       "860                                                  0                                             \n",
       "\n",
       "    If you have a mental health issue, do you feel that it interferes with your work when being treated effectively?   \n",
       "0                                               Rarely                                                                \\\n",
       "1                                            Sometimes                                                                 \n",
       "2                                 Not applicable to me                                                                 \n",
       "3                                 Not applicable to me                                                                 \n",
       "4                                            Sometimes                                                                 \n",
       "..                                                 ...                                                                 \n",
       "856                                             Rarely                                                                 \n",
       "857                                             Rarely                                                                 \n",
       "858                                             Rarely                                                                 \n",
       "859                                             Rarely                                                                 \n",
       "860                                          Sometimes                                                                 \n",
       "\n",
       "    If you have a mental health issue, do you feel that it interferes with your work when NOT being treated effectively?   \n",
       "0                                            Sometimes                                                                    \\\n",
       "1                                            Sometimes                                                                     \n",
       "2                                                Often                                                                     \n",
       "3                                 Not applicable to me                                                                     \n",
       "4                                                Often                                                                     \n",
       "..                                                 ...                                                                     \n",
       "856                                             Rarely                                                                     \n",
       "857                                              Often                                                                     \n",
       "858                                              Often                                                                     \n",
       "859                                          Sometimes                                                                     \n",
       "860                                              Often                                                                     \n",
       "\n",
       "    What is your gender? What country do you live in?   \n",
       "0                   Male     United States of America  \\\n",
       "1                 Female     United States of America   \n",
       "2                   Male               United Kingdom   \n",
       "3                   Male     United States of America   \n",
       "4                 Female     United States of America   \n",
       "..                   ...                          ...   \n",
       "856                 Male                       Canada   \n",
       "857               Female                       Canada   \n",
       "858               Female     United States of America   \n",
       "859                 Male     United States of America   \n",
       "860               Female     United States of America   \n",
       "\n",
       "    What country do you work in?  \n",
       "0       United States of America  \n",
       "1       United States of America  \n",
       "2                 United Kingdom  \n",
       "3       United States of America  \n",
       "4       United States of America  \n",
       "..                           ...  \n",
       "856                       Canada  \n",
       "857                       Canada  \n",
       "858     United States of America  \n",
       "859     United States of America  \n",
       "860     United States of America  \n",
       "\n",
       "[861 rows x 32 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Load data from Resources as tab seperated file into dataframe\n",
    "pd.set_option('display.max_columns', None)\n",
    "mental_df = pd.read_csv('./Resources/cleaned_data.csv')\n",
    "mental_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Creating tables with categorical variables for database"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Question</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Does your employer provide mental health benef...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Do you know the options for mental health care...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Does your employer offer resources to learn mo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>If a mental health issue prompted you to reque...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Do you think that discussing a mental health d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Do you think that discussing a physical health...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Do you feel that your employer takes mental he...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Have you heard of or observed negative consequ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Do you have previous employers?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Have your previous employers provided mental h...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Were you aware of the options for mental healt...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Did your previous employers ever formally disc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Was your anonymity protected if you chose to t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Do you think that discussing a mental health d...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Would you have been willing to discuss a menta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Did you feel that your previous employers took...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Did you hear of or observe negative consequenc...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Would you bring up a mental health issue with ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Do you feel that being identified as a person ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Do you think that team members/co-workers woul...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>How willing would you be to share with friends...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Have you observed or experienced an unsupporti...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Do you have a family history of mental illness?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Have you had a mental health disorder in the p...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Do you currently have a mental health disorder?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Have you been diagnosed with a mental health c...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Have you ever sought treatment for a mental he...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>If you have a mental health issue, do you feel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>If you have a mental health issue, do you feel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>What is your gender?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>What country do you live in?</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>What country do you work in?</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Question\n",
       "0   Does your employer provide mental health benef...\n",
       "1   Do you know the options for mental health care...\n",
       "2   Does your employer offer resources to learn mo...\n",
       "3   If a mental health issue prompted you to reque...\n",
       "4   Do you think that discussing a mental health d...\n",
       "5   Do you think that discussing a physical health...\n",
       "6   Do you feel that your employer takes mental he...\n",
       "7   Have you heard of or observed negative consequ...\n",
       "8                     Do you have previous employers?\n",
       "9   Have your previous employers provided mental h...\n",
       "10  Were you aware of the options for mental healt...\n",
       "11  Did your previous employers ever formally disc...\n",
       "12  Was your anonymity protected if you chose to t...\n",
       "13  Do you think that discussing a mental health d...\n",
       "14  Would you have been willing to discuss a menta...\n",
       "15  Did you feel that your previous employers took...\n",
       "16  Did you hear of or observe negative consequenc...\n",
       "17  Would you bring up a mental health issue with ...\n",
       "18  Do you feel that being identified as a person ...\n",
       "19  Do you think that team members/co-workers woul...\n",
       "20  How willing would you be to share with friends...\n",
       "21  Have you observed or experienced an unsupporti...\n",
       "22    Do you have a family history of mental illness?\n",
       "23  Have you had a mental health disorder in the p...\n",
       "24    Do you currently have a mental health disorder?\n",
       "25  Have you been diagnosed with a mental health c...\n",
       "26  Have you ever sought treatment for a mental he...\n",
       "27  If you have a mental health issue, do you feel...\n",
       "28  If you have a mental health issue, do you feel...\n",
       "29                               What is your gender?\n",
       "30                       What country do you live in?\n",
       "31                       What country do you work in?"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# build a dataframe of the questions\n",
    "dict = {}\n",
    "count = 0\n",
    "for column in mental_df.columns:\n",
    "    \n",
    "    dict[count] = [column]\n",
    "    count = count + 1\n",
    "    \n",
    "    \n",
    "dict\n",
    "\n",
    "questions_df = pd.DataFrame.from_dict(dict, orient='index', columns=['Question'])\n",
    "questions_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>4</th>\n",
       "      <th>5</th>\n",
       "      <th>6</th>\n",
       "      <th>7</th>\n",
       "      <th>8</th>\n",
       "      <th>9</th>\n",
       "      <th>10</th>\n",
       "      <th>11</th>\n",
       "      <th>12</th>\n",
       "      <th>13</th>\n",
       "      <th>14</th>\n",
       "      <th>15</th>\n",
       "      <th>16</th>\n",
       "      <th>17</th>\n",
       "      <th>18</th>\n",
       "      <th>19</th>\n",
       "      <th>20</th>\n",
       "      <th>21</th>\n",
       "      <th>22</th>\n",
       "      <th>23</th>\n",
       "      <th>24</th>\n",
       "      <th>25</th>\n",
       "      <th>26</th>\n",
       "      <th>27</th>\n",
       "      <th>28</th>\n",
       "      <th>29</th>\n",
       "      <th>30</th>\n",
       "      <th>31</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes, they all did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>Yes, always</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>No</td>\n",
       "      <td>No, I don't think it would</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Neither easy nor difficult</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>N/A (not currently aware)</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yes</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>No, none did</td>\n",
       "      <td>Yes, I was aware of all of them</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Not applicable to me</td>\n",
       "      <td>Often</td>\n",
       "      <td>Male</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>United Kingdom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Yes, at all of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Not applicable to me (I do not have a mental i...</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>0</td>\n",
       "      <td>Not applicable to me</td>\n",
       "      <td>Not applicable to me</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Very easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I observed</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</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",
       "      <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>856</th>\n",
       "      <td>Yes</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>No, I only became aware later</td>\n",
       "      <td>Some did</td>\n",
       "      <td>Yes, always</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, I think it would</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat not open</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>0</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Male</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>857</th>\n",
       "      <td>I don't know</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>N/A (not currently aware)</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>Some did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes, it has</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>858</th>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Somewhat easy</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Very open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>859</th>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat difficult</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Some did</td>\n",
       "      <td>I was aware of some</td>\n",
       "      <td>None did</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>Some of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>Some of them</td>\n",
       "      <td>No</td>\n",
       "      <td>Yes, it has</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I observed</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes</td>\n",
       "      <td>1</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Male</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>860</th>\n",
       "      <td>I don't know</td>\n",
       "      <td>I am not sure</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Somewhat difficult</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>No</td>\n",
       "      <td>1</td>\n",
       "      <td>No, none did</td>\n",
       "      <td>N/A (not currently aware)</td>\n",
       "      <td>None did</td>\n",
       "      <td>I don't know</td>\n",
       "      <td>Yes, all of them</td>\n",
       "      <td>No, at none of my previous employers</td>\n",
       "      <td>None did</td>\n",
       "      <td>None of them</td>\n",
       "      <td>No</td>\n",
       "      <td>No, I don't think it would</td>\n",
       "      <td>No, I don't think they would</td>\n",
       "      <td>Somewhat open</td>\n",
       "      <td>Yes, I experienced</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Maybe</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Yes</td>\n",
       "      <td>0</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Female</td>\n",
       "      <td>United States of America</td>\n",
       "      <td>United States of America</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>861 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               0              1             2                           3    \n",
       "0              No            Yes           Yes               Somewhat easy  \\\n",
       "1             Yes            Yes            No  Neither easy nor difficult   \n",
       "2             Yes  I am not sure           Yes               Somewhat easy   \n",
       "3    I don't know             No            No               Somewhat easy   \n",
       "4             Yes            Yes           Yes                   Very easy   \n",
       "..            ...            ...           ...                         ...   \n",
       "856           Yes  I am not sure           Yes               Somewhat easy   \n",
       "857  I don't know  I am not sure  I don't know               Somewhat easy   \n",
       "858           Yes             No            No               Somewhat easy   \n",
       "859           Yes            Yes           Yes          Somewhat difficult   \n",
       "860  I don't know  I am not sure           Yes          Somewhat difficult   \n",
       "\n",
       "        4      5             6    7   8                  9    \n",
       "0       No     No           Yes   No   1  Yes, they all did  \\\n",
       "1      Yes  Maybe            No   No   1       I don't know   \n",
       "2      Yes    Yes            No  Yes   1       No, none did   \n",
       "3       No     No           Yes   No   1           Some did   \n",
       "4       No     No  I don't know   No   1           Some did   \n",
       "..     ...    ...           ...  ...  ..                ...   \n",
       "856     No     No           Yes   No   1           Some did   \n",
       "857  Maybe     No  I don't know   No   1       I don't know   \n",
       "858     No     No           Yes   No   1           Some did   \n",
       "859  Maybe  Maybe  I don't know  Yes   1           Some did   \n",
       "860  Maybe     No            No   No   1       No, none did   \n",
       "\n",
       "                                  10            11            12   \n",
       "0                I was aware of some      None did   Yes, always  \\\n",
       "1          N/A (not currently aware)      Some did  I don't know   \n",
       "2    Yes, I was aware of all of them      None did  I don't know   \n",
       "3                I was aware of some      None did  I don't know   \n",
       "4                I was aware of some      Some did     Sometimes   \n",
       "..                               ...           ...           ...   \n",
       "856    No, I only became aware later      Some did   Yes, always   \n",
       "857        N/A (not currently aware)  I don't know  I don't know   \n",
       "858              I was aware of some      None did  I don't know   \n",
       "859              I was aware of some      None did     Sometimes   \n",
       "860        N/A (not currently aware)      None did  I don't know   \n",
       "\n",
       "                   13                                    14        15   \n",
       "0        None of them         Some of my previous employers  Some did  \\\n",
       "1        Some of them         Some of my previous employers  Some did   \n",
       "2    Yes, all of them  No, at none of my previous employers  None did   \n",
       "3        None of them  Yes, at all of my previous employers  Some did   \n",
       "4        Some of them         Some of my previous employers  Some did   \n",
       "..                ...                                   ...       ...   \n",
       "856      Some of them  No, at none of my previous employers  Some did   \n",
       "857      Some of them         Some of my previous employers  Some did   \n",
       "858      Some of them  No, at none of my previous employers  None did   \n",
       "859  Yes, all of them         Some of my previous employers  None did   \n",
       "860  Yes, all of them  No, at none of my previous employers  None did   \n",
       "\n",
       "                   16     17                          18   \n",
       "0        None of them     No  No, I don't think it would  \\\n",
       "1        Some of them     No       Yes, I think it would   \n",
       "2        Some of them  Maybe       Yes, I think it would   \n",
       "3        None of them    Yes       Yes, I think it would   \n",
       "4        Some of them     No                       Maybe   \n",
       "..                ...    ...                         ...   \n",
       "856      None of them     No       Yes, I think it would   \n",
       "857      None of them  Maybe                 Yes, it has   \n",
       "858  Yes, all of them     No                       Maybe   \n",
       "859      Some of them     No                 Yes, it has   \n",
       "860      None of them     No  No, I don't think it would   \n",
       "\n",
       "                               19   \n",
       "0    No, I don't think they would  \\\n",
       "1                           Maybe   \n",
       "2                           Maybe   \n",
       "3    No, I don't think they would   \n",
       "4                           Maybe   \n",
       "..                            ...   \n",
       "856                         Maybe   \n",
       "857                         Maybe   \n",
       "858  No, I don't think they would   \n",
       "859  No, I don't think they would   \n",
       "860  No, I don't think they would   \n",
       "\n",
       "                                                    20                  21   \n",
       "0                                        Somewhat open                  No  \\\n",
       "1                                        Somewhat open  Yes, I experienced   \n",
       "2                                        Somewhat open  Yes, I experienced   \n",
       "3    Not applicable to me (I do not have a mental i...                  No   \n",
       "4                                        Somewhat open     Yes, I observed   \n",
       "..                                                 ...                 ...   \n",
       "856                                  Somewhat not open                  No   \n",
       "857                                      Somewhat open  Yes, I experienced   \n",
       "858                                          Very open  Yes, I experienced   \n",
       "859                                      Somewhat open     Yes, I observed   \n",
       "860                                      Somewhat open  Yes, I experienced   \n",
       "\n",
       "               22     23     24   25  26                    27   \n",
       "0             Yes    Yes    Yes  Yes   1                Rarely  \\\n",
       "1             Yes    Yes    Yes  Yes   1             Sometimes   \n",
       "2              No     No    Yes   No   1  Not applicable to me   \n",
       "3              No     No     No   No   0  Not applicable to me   \n",
       "4             Yes    Yes    Yes  Yes   1             Sometimes   \n",
       "..            ...    ...    ...  ...  ..                   ...   \n",
       "856  I don't know  Maybe  Maybe   No   0                Rarely   \n",
       "857  I don't know    Yes    Yes  Yes   1                Rarely   \n",
       "858           Yes    Yes    Yes  Yes   1                Rarely   \n",
       "859           Yes    Yes  Maybe  Yes   1                Rarely   \n",
       "860           Yes  Maybe    Yes  Yes   0             Sometimes   \n",
       "\n",
       "                       28      29                        30   \n",
       "0               Sometimes    Male  United States of America  \\\n",
       "1               Sometimes  Female  United States of America   \n",
       "2                   Often    Male            United Kingdom   \n",
       "3    Not applicable to me    Male  United States of America   \n",
       "4                   Often  Female  United States of America   \n",
       "..                    ...     ...                       ...   \n",
       "856                Rarely    Male                    Canada   \n",
       "857                 Often  Female                    Canada   \n",
       "858                 Often  Female  United States of America   \n",
       "859             Sometimes    Male  United States of America   \n",
       "860                 Often  Female  United States of America   \n",
       "\n",
       "                           31  \n",
       "0    United States of America  \n",
       "1    United States of America  \n",
       "2              United Kingdom  \n",
       "3    United States of America  \n",
       "4    United States of America  \n",
       "..                        ...  \n",
       "856                    Canada  \n",
       "857                    Canada  \n",
       "858  United States of America  \n",
       "859  United States of America  \n",
       "860  United States of America  \n",
       "\n",
       "[861 rows x 32 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# rename the columns in the dataframe to numbers\n",
    "column_rename = {}\n",
    "count = 0\n",
    "for column in mental_df.columns:\n",
    "    \n",
    "    column_rename[column] = count\n",
    "    count = count + 1\n",
    "    \n",
    "    \n",
    "column_rename\n",
    "\n",
    "renamed_df = mental_df.rename(columns=column_rename)\n",
    "renamed_df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Create Database"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "We used pandas and SQLAlchemy to put the csv files that we started with, and merged tables that we created into a SQLite database. Our database is then able to interact with our machnie learning model, which allows us to make predictions and analyze our results."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\Admin\\AppData\\Local\\Temp\\ipykernel_6412\\2964153773.py:9: SADeprecationWarning: The AutomapBase.prepare.reflect parameter is deprecated and will be removed in a future release.  Reflection is enabled when AutomapBase.prepare.autoload_with is passed.\n",
      "  Base.prepare(engine, reflect=True)\n"
     ]
    }
   ],
   "source": [
    "# Create an in-memory SQLite database\n",
    "\n",
    "# Create the engine\n",
    "engine = create_engine(\"sqlite:///mental_health.db\", echo=False)\n",
    "\n",
    "# Reflect existing db into a new model\n",
    "Base = automap_base()\n",
    "# Refelct the tables\n",
    "Base.prepare(engine, reflect=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "32"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Use pandas to_sql to write records stored in a dataframe to a SQL database\n",
    "\n",
    "# Write dataframe of all survey questions to a sqlite table\n",
    "renamed_df.to_sql('pre_encoded_survey', con=engine, if_exists='replace')\n",
    "# Write dataframe of all questions with encoded numbers to a sqlite table\n",
    "questions_df.to_sql('pre_encoded_questions', con=engine, if_exists='replace')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[(0, 'Does your employer provide mental health benefits as part of healthcare coverage?'),\n",
       " (1, 'Do you know the options for mental health care available under your employer-provided coverage?'),\n",
       " (2, 'Does your employer offer resources to learn more about mental health concerns and options for seeking help?'),\n",
       " (3, 'If a mental health issue prompted you to request a medical leave from work, asking for that leave would be:'),\n",
       " (4, 'Do you think that discussing a mental health disorder with your employer would have negative consequences?'),\n",
       " (5, 'Do you think that discussing a physical health issue with your employer would have negative consequences?'),\n",
       " (6, 'Do you feel that your employer takes mental health as seriously as physical health?'),\n",
       " (7, 'Have you heard of or observed negative consequences for co-workers who have been open about mental health issues in your workplace?'),\n",
       " (8, 'Do you have previous employers?'),\n",
       " (9, 'Have your previous employers provided mental health benefits?'),\n",
       " (10, 'Were you aware of the options for mental health care provided by your previous employers?'),\n",
       " (11, 'Did your previous employers ever formally discuss mental health (as part of a wellness campaign or other official communication)?'),\n",
       " (12, 'Was your anonymity protected if you chose to take advantage of mental health or substance abuse treatment resources with previous employers?'),\n",
       " (13, 'Do you think that discussing a mental health disorder with previous employers would have negative consequences?'),\n",
       " (14, 'Would you have been willing to discuss a mental health issue with your direct supervisor(s)?'),\n",
       " (15, 'Did you feel that your previous employers took mental health as seriously as physical health?'),\n",
       " (16, 'Did you hear of or observe negative consequences for co-workers with mental health issues in your previous workplaces?'),\n",
       " (17, 'Would you bring up a mental health issue with a potential employer in an interview?'),\n",
       " (18, 'Do you feel that being identified as a person with a mental health issue would hurt your career?'),\n",
       " (19, 'Do you think that team members/co-workers would view you more negatively if they knew you suffered from a mental health issue?'),\n",
       " (20, 'How willing would you be to share with friends and family that you have a mental illness?'),\n",
       " (21, 'Have you observed or experienced an unsupportive or badly handled response to a mental health issue in your current or previous workplace?'),\n",
       " (22, 'Do you have a family history of mental illness?'),\n",
       " (23, 'Have you had a mental health disorder in the past?'),\n",
       " (24, 'Do you currently have a mental health disorder?'),\n",
       " (25, 'Have you been diagnosed with a mental health condition by a medical professional?'),\n",
       " (26, 'Have you ever sought treatment for a mental health issue from a mental health professional?'),\n",
       " (27, 'If you have a mental health issue, do you feel that it interferes with your work when being treated effectively?'),\n",
       " (28, 'If you have a mental health issue, do you feel that it interferes with your work when NOT being treated effectively?'),\n",
       " (29, 'What is your gender?'),\n",
       " (30, 'What country do you live in?'),\n",
       " (31, 'What country do you work in?')]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check that you can select a table from the database\n",
    "#engine.execute(\"SELECT * FROM pre_encoded_survey\").fetchall()\n",
    "#engine.execute(\"SELECT * FROM pre_encoded_questions\").fetchall()\n",
    "\n",
    "with engine.connect() as conn:\n",
    "    result = conn.execute(text('select * FROM pre_encoded_questions')).fetchall()\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "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.11.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}