DataCleaning.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "DataCleaning.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "IyC4zAVzQ7Ik"
      },
      "source": [
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xma3845gRfW0"
      },
      "source": [
        "df=pd.read_csv('/content/Health Survey 2021 (Responses) - Form Responses 1.csv')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "RxQo4j9PSF8Y"
      },
      "source": [
        "df=df[df['Informed Consent']=='Yes']"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 318
        },
        "id": "IVJHMJxLC4hp",
        "outputId": "9d4c8aab-c0f1-4145-da25-ef0812c69149"
      },
      "source": [
        "df.describe()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>No. of Family Members</th>\n",
              "      <th>Inclinination towards exercise per week</th>\n",
              "      <th>Difficulty level to manage daily/household expenses</th>\n",
              "      <th>Affect of Covid on Daily Schedule</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>160.000000</td>\n",
              "      <td>160.000000</td>\n",
              "      <td>155.000000</td>\n",
              "      <td>160.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>3.956250</td>\n",
              "      <td>2.625000</td>\n",
              "      <td>2.580645</td>\n",
              "      <td>2.325000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>1.770999</td>\n",
              "      <td>1.469822</td>\n",
              "      <td>1.167031</td>\n",
              "      <td>1.403276</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>3.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>1.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>4.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>2.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>4.250000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>9.000000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       No. of Family Members  ...  Affect of Covid on Daily Schedule\n",
              "count             160.000000  ...                         160.000000\n",
              "mean                3.956250  ...                           2.325000\n",
              "std                 1.770999  ...                           1.403276\n",
              "min                 0.000000  ...                           1.000000\n",
              "25%                 3.000000  ...                           1.000000\n",
              "50%                 4.000000  ...                           2.000000\n",
              "75%                 4.250000  ...                           3.000000\n",
              "max                 9.000000  ...                           5.000000\n",
              "\n",
              "[8 rows x 4 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "adcLy_UZuT-W"
      },
      "source": [
        "depression_choices=['Not at all',\n",
        "'Just a little',\n",
        "'Somewhat',\n",
        "'Moderately',\n",
        "'Quite a lot',\n",
        "'Very much']\n",
        "depressiontest_columns=df.columns[17:17+18]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "_VWxEsudymN7",
        "outputId": "643f02fd-1500-4d26-f6cc-3098e51c4e9d"
      },
      "source": [
        "depressiontest_columns"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['Depression Test - Q1', 'Depression Test - Q2', 'Depression Test - Q3',\n",
              "       'Depression Test - Q4', 'Depression Test - Q5', 'Depression Test - Q6',\n",
              "       'Depression Test - Q7', 'Depression Test - Q8', 'Depression Test - Q9',\n",
              "       'Depression Test - Q10', 'Depression Test - Q11',\n",
              "       'Depression Test - Q12', 'Depression Test - Q13',\n",
              "       'Depression Test - Q14', 'Depression Test - Q15',\n",
              "       'Depression Test - Q16', 'Depression Test - Q17',\n",
              "       'Depression Test - Q18'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "UUCZFIetxhXT"
      },
      "source": [
        "for i in depressiontest_columns:\n",
        "  for j in range(len(depression_choices)):\n",
        "    df.loc[df[i]==depression_choices[j],i]=j"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "iQRwD8bnD1MI",
        "outputId": "e327c0a9-6b65-40f8-e695-624df2706163"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "160"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "K2MgvxQxDWty"
      },
      "source": [
        "depression_scores=[]\n",
        "for i in range(len(df)):\n",
        "  score=0\n",
        "  for j in depressiontest_columns:\n",
        "    score+=df[j].iloc[i]\n",
        "  depression_scores.append(score)\n",
        "df=df.assign(DepressionScale=depression_scores)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 283
        },
        "id": "zyYRf-gdF--h",
        "outputId": "d6cb6b46-4db2-417d-ccb6-4385ea112f9b"
      },
      "source": [
        "df['DepressionScale'].hist()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "<matplotlib.axes._subplots.AxesSubplot at 0x7f7cb01a5e50>"
            ]
          },
          "metadata": {},
          "execution_count": 23
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXAAAAD4CAYAAAD1jb0+AAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAANyUlEQVR4nO3dX4xc5XmA8ecNBkHYFkNAK9emXUegRAgrUFaUiKrahVaiMQpcIErkRnZF5JtEJa2j1slNFalVjVpCIxRVsiCtL6wsyKEyAqUVcliluQgpG9o64EYgahIQsRMZnCxCSbd9ezHHsne9MOPZ+bPv7POTkOecmTPn49PZx2eP5+xGZiJJqud9wx6AJKk7BlySijLgklSUAZekogy4JBW1bpA7u/zyy3NiYqKrbd9++20uvvji3g6oMOfjNOdiMedjsVGYj7m5uZ9m5hVL1w804BMTEzz33HNdbTs7O8vU1FRvB1SY83Gac7GY87HYKMxHRLy63HovoUhSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRA70TcyUOv36SHbufGvh+j+7ZOvB9SlInPAOXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklSUAZekogy4JBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJamojgMeEedFxPMR8WSzvDkino2IlyPi0Yi4oH/DlCQtdS5n4PcBR85Yvh94MDOvAt4E7u3lwCRJ762jgEfEJmAr8HCzHMAtwIHmJfuAO/sxQEnS8iIz278o4gDw18CvAJ8DdgDfac6+iYgrgW9k5rXLbLsT2AkwPj5+w8zMTFcDPX7iJMfe6WrTFdmy8ZLB77QD8/PzjI2NDXsYq4JzsZjzsdgozMf09PRcZk4uXb+u3YYRcTtwPDPnImLqXHecmXuBvQCTk5M5NXXObwHAQ/sP8sDhtsPtuaPbpga+z07Mzs7S7VyOGudiMedjsVGej06KeDPw8Yj4GHAh8KvAl4H1EbEuMxeATcDr/RumJGmpttfAM/PzmbkpMyeAe4BvZuY24BngruZl24GDfRulJOksK/kc+J8DfxoRLwMfAB7pzZAkSZ04p4vKmTkLzDaPXwFu7P2QJEmd8E5MSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklSUAZekogy4JBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklSUAZekotoGPCIujIjvRsR/RMQLEfHFZv3miHg2Il6OiEcj4oL+D1eSdEonZ+C/AG7JzI8A1wG3RcRNwP3Ag5l5FfAmcG//hilJWqptwLNlvlk8v/kvgVuAA836fcCdfRmhJGlZkZntXxRxHjAHXAV8Bfgb4DvN2TcRcSXwjcy8dpltdwI7AcbHx2+YmZnpaqDHT5zk2DtdbboiWzZeMviddmB+fp6xsbFhD2NVcC4Wcz4WG4X5mJ6ensvMyaXr13WycWb+L3BdRKwH/gn4cKc7zsy9wF6AycnJnJqa6nTTRR7af5AHDnc03J46um1q4PvsxOzsLN3O5ahxLhZzPhYb5fk4p0+hZOZbwDPAR4H1EXGqqJuA13s8NknSe+jkUyhXNGfeRMRFwO8BR2iF/K7mZduBg/0apCTpbJ1ck9gA7Guug78PeCwzn4yIF4GZiPhL4HngkT6Oc2gmdj81tH0f3bN1aPuWtPq1DXhm/idw/TLrXwFu7MegJEnteSemJBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRbX8rvYZnYvdT7/rcri0L7HiP51fi6J6tfXlfSb3lGbgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklRU24BHxJUR8UxEvBgRL0TEfc36yyLi6Yh4qfnz0v4PV5J0Sidn4AvArsy8BrgJ+HREXAPsBg5l5tXAoWZZkjQgbQOemW9k5veaxz8HjgAbgTuAfc3L9gF39muQkqSzRWZ2/uKICeBbwLXADzNzfbM+gDdPLS/ZZiewE2B8fPyGmZmZrgZ6/MRJjr3T1aYjafwi+jYfWzZe0p837pP5+XnGxsaGPYxVw/lYbBTmY3p6ei4zJ5eu7/h3YkbEGPB14LOZ+bNWs1syMyNi2b8JMnMvsBdgcnIyp6amznHoLQ/tP8gDh/0Vnqfs2rLQt/k4um2qL+/bL7Ozs3R7XI0i52OxUZ6Pjj6FEhHn04r3/sx8vFl9LCI2NM9vAI73Z4iSpOV08imUAB4BjmTml8546glge/N4O3Cw98OTJL2bTr4Hvxn4JHA4Iv69WfcFYA/wWETcC7wK3N2fIUqSltM24Jn5bSDe5elbezscSVKnvBNTkooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JR/nQonWVi91ND2/fRPVuHtm+pGs/AJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQV5Y08WlW6uYlo15YFdqzw5iNvIFJFnoFLUlEGXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySijLgklRU24BHxFcj4nhEfP+MdZdFxNMR8VLz56X9HaYkaalOzsD/EbhtybrdwKHMvBo41CxLkgaobcAz81vAiSWr7wD2NY/3AXf2eFySpDYiM9u/KGICeDIzr22W38rM9c3jAN48tbzMtjuBnQDj4+M3zMzMdDXQ4ydOcuydrjYdSeMX4Xw0ejEXWzZe0pvBrALz8/OMjY0NexirxijMx/T09FxmTi5dv26lb5yZGRHv+rdAZu4F9gJMTk7m1NRUV/t5aP9BHji84uGOjF1bFpyPRi/m4ui2qd4MZhWYnZ2l26+zUTTK89Htp1CORcQGgObP470bkiSpE90G/Alge/N4O3CwN8ORJHWq7fedEfE1YAq4PCJeA/4C2AM8FhH3Aq8Cd/dzkNIom9j9VE/fb9eWBXZ08J5H92zt6X41eG0DnpmfeJenbu3xWCRJ58A7MSWpKAMuSUUZcEkqyoBLUlEGXJKKMuCSVJQBl6SiDLgkFeVPQ5Lo/d2Q0iB4Bi5JRRlwSSrKgEtSUV4Dl9aoYV739ych9oZn4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKsqAS1JRBlySivJGHkkDN8ibiHZtWWDHkH9YWb9uXPIMXJKKMuCSVJQBl6SiDLgkFWXAJakoAy5JRRlwSSrKgEtSUQZckooy4JJUlAGXpKIMuCQVZcAlqSgDLklFGXBJKmpFAY+I2yLiBxHxckTs7tWgJEntdR3wiDgP+Arw+8A1wCci4ppeDUyS9N5WcgZ+I/ByZr6Smb8EZoA7ejMsSVI7kZndbRhxF3BbZn6qWf4k8FuZ+Zklr9sJ7GwWPwT8oMuxXg78tMttR5HzcZpzsZjzsdgozMdvZOYVS1f2/XdiZuZeYO9K3ycinsvMyR4MaSQ4H6c5F4s5H4uN8nys5BLK68CVZyxvatZJkgZgJQH/N+DqiNgcERcA9wBP9GZYkqR2ur6EkpkLEfEZ4F+A84CvZuYLPRvZ2VZ8GWbEOB+nOReLOR+Ljex8dP2PmJKk4fJOTEkqyoBLUlElAr6Wb9mPiCsj4pmIeDEiXoiI+5r1l0XE0xHxUvPnpcMe6yBFxHkR8XxEPNksb46IZ5tj5NHmH9ZHXkSsj4gDEfFfEXEkIj66lo+NiPiT5uvk+xHxtYi4cJSPjVUfcG/ZZwHYlZnXADcBn27+/3cDhzLzauBQs7yW3AccOWP5fuDBzLwKeBO4dyijGrwvA/+cmR8GPkJrTtbksRERG4E/BiYz81paH664hxE+NlZ9wFnjt+xn5huZ+b3m8c9pfYFupDUH+5qX7QPuHM4IBy8iNgFbgYeb5QBuAQ40L1kT8xERlwC/AzwCkJm/zMy3WMPHBq1P1l0UEeuA9wNvMMLHRoWAbwR+dMbya826NSciJoDrgWeB8cx8o3nqx8D4kIY1DH8H/Bnwf83yB4C3MnOhWV4rx8hm4CfAPzSXkx6OiItZo8dGZr4O/C3wQ1rhPgnMMcLHRoWAC4iIMeDrwGcz82dnPpetz4Kuic+DRsTtwPHMnBv2WFaBdcBvAn+fmdcDb7PkcskaOzYupfXdx2bg14CLgduGOqg+qxDwNX/LfkScTyve+zPz8Wb1sYjY0Dy/ATg+rPEN2M3AxyPiKK3LabfQug68vvm2GdbOMfIa8FpmPtssH6AV9LV6bPwu8N+Z+ZPM/B/gcVrHy8geGxUCvqZv2W+u7z4CHMnML53x1BPA9ubxduDgoMc2DJn5+czclJkTtI6Fb2bmNuAZ4K7mZWtiPjLzx8CPIuJDzapbgRdZo8cGrUsnN0XE+5uvm1PzMbLHRok7MSPiY7Sue566Zf+vhjykgYmI3wb+FTjM6Wu+X6B1Hfwx4NeBV4G7M/PEUAY5JBExBXwuM2+PiA/SOiO/DHge+MPM/MUwxzcIEXEdrX/MvQB4BfgjWidma/LYiIgvAn9A69NbzwOfonXNeySPjRIBlySdrcIlFEnSMgy4JBVlwCWpKAMuSUUZcEkqyoBLUlEGXJKK+n8ODoxfmzNAAgAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 318
        },
        "id": "zC2pBYbVFqIU",
        "outputId": "f7e43b14-19a3-4aad-bbc7-814f0c48e956"
      },
      "source": [
        "df.describe()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>No. of Family Members</th>\n",
              "      <th>Inclinination towards exercise per week</th>\n",
              "      <th>Difficulty level to manage daily/household expenses</th>\n",
              "      <th>Affect of Covid on Daily Schedule</th>\n",
              "      <th>DepressionScale</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>count</th>\n",
              "      <td>160.000000</td>\n",
              "      <td>160.000000</td>\n",
              "      <td>155.000000</td>\n",
              "      <td>160.000000</td>\n",
              "      <td>160.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>mean</th>\n",
              "      <td>3.956250</td>\n",
              "      <td>2.625000</td>\n",
              "      <td>2.580645</td>\n",
              "      <td>2.325000</td>\n",
              "      <td>25.737500</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>std</th>\n",
              "      <td>1.770999</td>\n",
              "      <td>1.469822</td>\n",
              "      <td>1.167031</td>\n",
              "      <td>1.403276</td>\n",
              "      <td>21.961226</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>min</th>\n",
              "      <td>0.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>0.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25%</th>\n",
              "      <td>3.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>1.000000</td>\n",
              "      <td>8.000000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>50%</th>\n",
              "      <td>4.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>2.000000</td>\n",
              "      <td>18.500000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>75%</th>\n",
              "      <td>4.250000</td>\n",
              "      <td>4.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>3.000000</td>\n",
              "      <td>37.250000</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>max</th>\n",
              "      <td>9.000000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>5.000000</td>\n",
              "      <td>90.000000</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "       No. of Family Members  ...  DepressionScale\n",
              "count             160.000000  ...       160.000000\n",
              "mean                3.956250  ...        25.737500\n",
              "std                 1.770999  ...        21.961226\n",
              "min                 0.000000  ...         0.000000\n",
              "25%                 3.000000  ...         8.000000\n",
              "50%                 4.000000  ...        18.500000\n",
              "75%                 4.250000  ...        37.250000\n",
              "max                 9.000000  ...        90.000000\n",
              "\n",
              "[8 rows x 5 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 591
        },
        "id": "vhvLkAdaRyIk",
        "outputId": "2345d2b1-46bd-4793-8852-2bd3b726dc10"
      },
      "source": [
        "df.head()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Timestamp</th>\n",
              "      <th>Email Address</th>\n",
              "      <th>Informed Consent</th>\n",
              "      <th>Finding survey</th>\n",
              "      <th>State/UT</th>\n",
              "      <th>Area</th>\n",
              "      <th>Age</th>\n",
              "      <th>Gender</th>\n",
              "      <th>Level of Education</th>\n",
              "      <th>Marital Status</th>\n",
              "      <th>Current Employment Status</th>\n",
              "      <th>Occupation</th>\n",
              "      <th>Household Income</th>\n",
              "      <th>No. of Family Members</th>\n",
              "      <th>Covid Diagnosed(Self)</th>\n",
              "      <th>Covid Diagnosed(Family)</th>\n",
              "      <th>Death in Family/Friends(due to Covid)</th>\n",
              "      <th>Depression Test - Q1</th>\n",
              "      <th>Depression Test - Q2</th>\n",
              "      <th>Depression Test - Q3</th>\n",
              "      <th>Depression Test - Q4</th>\n",
              "      <th>Depression Test - Q5</th>\n",
              "      <th>Depression Test - Q6</th>\n",
              "      <th>Depression Test - Q7</th>\n",
              "      <th>Depression Test - Q8</th>\n",
              "      <th>Depression Test - Q9</th>\n",
              "      <th>Depression Test - Q10</th>\n",
              "      <th>Depression Test - Q11</th>\n",
              "      <th>Depression Test - Q12</th>\n",
              "      <th>Depression Test - Q13</th>\n",
              "      <th>Depression Test - Q14</th>\n",
              "      <th>Depression Test - Q15</th>\n",
              "      <th>Depression Test - Q16</th>\n",
              "      <th>Depression Test - Q17</th>\n",
              "      <th>Depression Test - Q18</th>\n",
              "      <th>Additional Diseases</th>\n",
              "      <th>Work/Study (Online)</th>\n",
              "      <th>No. of hours in work/study per day</th>\n",
              "      <th>No. of hours in household chores per day</th>\n",
              "      <th>Househelp Workers</th>\n",
              "      <th>Inclinination towards exercise per week</th>\n",
              "      <th>No. of hours of sleep per day</th>\n",
              "      <th>Nutrition - Homecooked Meals</th>\n",
              "      <th>Nutrition - Ordered Food</th>\n",
              "      <th>Nutrition - Processed Snacks</th>\n",
              "      <th>Nutrition - Medication</th>\n",
              "      <th>Difficulty level to manage daily/household expenses</th>\n",
              "      <th>Affect of Covid on Daily Schedule</th>\n",
              "      <th>Mental Health Talk - Partner</th>\n",
              "      <th>Mental Health Talk - Family Member</th>\n",
              "      <th>Mental Health Talk - Friend</th>\n",
              "      <th>Mental Health Talk - Neighbour</th>\n",
              "      <th>Mental Health Talk - Co-worker</th>\n",
              "      <th>Mental Health Talk - Therapist</th>\n",
              "      <th>Inclination to Substance Abuse - Alcohol</th>\n",
              "      <th>Inclination to Substance Abuse - Smoking</th>\n",
              "      <th>Inclination to Substance Abuse - Tobacco</th>\n",
              "      <th>Inclination to Substance Abuse - Drugs</th>\n",
              "      <th>DepressionScale</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>6/27/2021 11:18:24</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Maharashtra</td>\n",
              "      <td>NaN</td>\n",
              "      <td>30 - 44 years old</td>\n",
              "      <td>Male</td>\n",
              "      <td>PhD</td>\n",
              "      <td>Married</td>\n",
              "      <td>Full-time employment</td>\n",
              "      <td>NaN</td>\n",
              "      <td>8 lakh INR - 14 lakh INR</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>6 to 8 hours</td>\n",
              "      <td>2 to 4 hours</td>\n",
              "      <td>Yes</td>\n",
              "      <td>3.0</td>\n",
              "      <td>6 - 8 hours</td>\n",
              "      <td>Stronly Agree</td>\n",
              "      <td>Strongly Disagree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Strongly Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>17</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>9/8/2021 0:16:04</td>\n",
              "      <td>shivang19101@iiitnr.edu.in</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Linkedin</td>\n",
              "      <td>Chhattisgarh</td>\n",
              "      <td>Rural</td>\n",
              "      <td>18 - 29 years old</td>\n",
              "      <td>Male</td>\n",
              "      <td>12th Grade or SSC</td>\n",
              "      <td>Single</td>\n",
              "      <td>Student</td>\n",
              "      <td>Engineering</td>\n",
              "      <td>Less than 2 lakh INR</td>\n",
              "      <td>9.0</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>4 to 6 hours</td>\n",
              "      <td>2 to 4 hours</td>\n",
              "      <td>Yes</td>\n",
              "      <td>5.0</td>\n",
              "      <td>6 - 8 hours</td>\n",
              "      <td>Stronly Agree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>3.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Strongly Agree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Strongly Agree</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>9/8/2021 1:11:11</td>\n",
              "      <td>paneri.avinash.sahare@gmail.com</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Linkedin</td>\n",
              "      <td>Maharashtra</td>\n",
              "      <td>Rural</td>\n",
              "      <td>18 - 29 years old</td>\n",
              "      <td>Female</td>\n",
              "      <td>Bachelor’s degree</td>\n",
              "      <td>Single</td>\n",
              "      <td>Full-time employment</td>\n",
              "      <td>Buisness and Financial Operations</td>\n",
              "      <td>14 lakh INR -  20 lakh INR</td>\n",
              "      <td>9.0</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>4</td>\n",
              "      <td>4</td>\n",
              "      <td>2</td>\n",
              "      <td>4</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>2</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>6 to 8 hours</td>\n",
              "      <td>4 to 6 hours</td>\n",
              "      <td>Yes</td>\n",
              "      <td>3.0</td>\n",
              "      <td>6 - 8 hours</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.0</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>29</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>9/8/2021 3:38:55</td>\n",
              "      <td>patelkupatelkuldeep0012@gmail.com</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Linkedin</td>\n",
              "      <td>Madhya Pradesh</td>\n",
              "      <td>Sub-Urban or Town</td>\n",
              "      <td>18 - 29 years old</td>\n",
              "      <td>Male</td>\n",
              "      <td>Bachelor’s degree</td>\n",
              "      <td>Single</td>\n",
              "      <td>Full-time employment</td>\n",
              "      <td>Data Science &amp; Engineering</td>\n",
              "      <td>8 lakh INR - 14 lakh INR</td>\n",
              "      <td>4.0</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>3</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>2</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>2</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>4</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2 to 4 hours</td>\n",
              "      <td>Less than 2 hours</td>\n",
              "      <td>No</td>\n",
              "      <td>1.0</td>\n",
              "      <td>8 - 10 hours</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>2.0</td>\n",
              "      <td>5.0</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Strongly Agree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Rarely</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>23</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>9/8/2021 5:30:15</td>\n",
              "      <td>kjaisinghani@stvincentngp.edu.in</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Linkedin</td>\n",
              "      <td>Maharashtra</td>\n",
              "      <td>Urban</td>\n",
              "      <td>30 - 44 years old</td>\n",
              "      <td>Female</td>\n",
              "      <td>Master’s degree</td>\n",
              "      <td>Married</td>\n",
              "      <td>Full-time employment</td>\n",
              "      <td>Architecture and Engineering</td>\n",
              "      <td>2 lakh INR - 8 lakh INR</td>\n",
              "      <td>5.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>No</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>3</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>1</td>\n",
              "      <td>Hypertension</td>\n",
              "      <td>No</td>\n",
              "      <td>4 to 6 hours</td>\n",
              "      <td>4 to 6 hours</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1.0</td>\n",
              "      <td>6 - 8 hours</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Disagree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>Strongly Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Strongly Agree</td>\n",
              "      <td>Neutral</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Agree</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>Not At All</td>\n",
              "      <td>8</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "            Timestamp  ... DepressionScale\n",
              "0  6/27/2021 11:18:24  ...              17\n",
              "1    9/8/2021 0:16:04  ...               8\n",
              "2    9/8/2021 1:11:11  ...              29\n",
              "3    9/8/2021 3:38:55  ...              23\n",
              "4    9/8/2021 5:30:15  ...               8\n",
              "\n",
              "[5 rows x 59 columns]"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    }
  ]
}