graduate analysis.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = pd.read_csv(r\"C:\\Users\\mahdi\\Desktop\\Challenge\\OriginDataSet.csv\")"
   ]
  },
  {
   "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>Timestamp</th>\n",
       "      <th>1. How comfortable are you with your surroundings in school ?</th>\n",
       "      <th>2. How would you rate the quality of your relationships with your classmates?</th>\n",
       "      <th>3. Do you have any close friends at school?</th>\n",
       "      <th>4. If 'YES', how did they affect in your academics?</th>\n",
       "      <th>5. What is the part of your student life that you are unsatisfied with the most?</th>\n",
       "      <th>6. Do you sometimes feel isolated in your college  environment?</th>\n",
       "      <th>7. How often do external problems affect your academics ?</th>\n",
       "      <th>8. Does your personal relationship (Love Life) affect your academic level  ?</th>\n",
       "      <th>9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?</th>\n",
       "      <th>...</th>\n",
       "      <th>Are you?</th>\n",
       "      <th>Age</th>\n",
       "      <th>Status</th>\n",
       "      <th>Level of education</th>\n",
       "      <th>Field of study</th>\n",
       "      <th>Location</th>\n",
       "      <th>Governorates</th>\n",
       "      <th>Your university</th>\n",
       "      <th>How well do you describe yourself academically ?</th>\n",
       "      <th>Share your opinon about the surveys</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10/20/2023 19:39:56</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Social life, Exams</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Taken</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Public</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10/20/2023 19:46:11</td>\n",
       "      <td>5</td>\n",
       "      <td>7</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social life, Teacher, Subjects</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Public</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>10/20/2023 19:46:23</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Social life, Exams</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Business</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Private</td>\n",
       "      <td>7</td>\n",
       "      <td>Loved all the questions nice keep up the good ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10/20/2023 19:46:58</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Schedule</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Taken</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Marketing</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private</td>\n",
       "      <td>7</td>\n",
       "      <td>I like it</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10/20/2023 19:47:55</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Schedule</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Always</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Taken</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Business, management</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Monastir</td>\n",
       "      <td>Private</td>\n",
       "      <td>6</td>\n",
       "      <td>Long</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             Timestamp  \\\n",
       "0  10/20/2023 19:39:56   \n",
       "1  10/20/2023 19:46:11   \n",
       "2  10/20/2023 19:46:23   \n",
       "3  10/20/2023 19:46:58   \n",
       "4  10/20/2023 19:47:55   \n",
       "\n",
       "   1. How comfortable are you with your surroundings in school ?  \\\n",
       "0                                                  8               \n",
       "1                                                  5               \n",
       "2                                                  5               \n",
       "3                                                  1               \n",
       "4                                                  9               \n",
       "\n",
       "   2. How would you rate the quality of your relationships with your classmates?  \\\n",
       "0                                                  8                               \n",
       "1                                                  7                               \n",
       "2                                                  5                               \n",
       "3                                                  3                               \n",
       "4                                                  9                               \n",
       "\n",
       "  3. Do you have any close friends at school?  \\\n",
       "0                                         Yes   \n",
       "1                                          No   \n",
       "2                                         Yes   \n",
       "3                                         Yes   \n",
       "4                                          No   \n",
       "\n",
       "  4. If 'YES', how did they affect in your academics?  \\\n",
       "0                                      Positive/Good    \n",
       "1                                                NaN    \n",
       "2                                             Normal    \n",
       "3                                             Normal    \n",
       "4                                                NaN    \n",
       "\n",
       "  5. What is the part of your student life that you are unsatisfied with the most?  \\\n",
       "0                                 Social life, Exams                                 \n",
       "1                     Social life, Teacher, Subjects                                 \n",
       "2                                 Social life, Exams                                 \n",
       "3                                           Schedule                                 \n",
       "4                                           Schedule                                 \n",
       "\n",
       "  6. Do you sometimes feel isolated in your college  environment?  \\\n",
       "0                                          Sometimes                \n",
       "1                                          Sometimes                \n",
       "2                                          Sometimes                \n",
       "3                                          Sometimes                \n",
       "4                                          Sometimes                \n",
       "\n",
       "  7. How often do external problems affect your academics ?  \\\n",
       "0                                             Rarely          \n",
       "1                                             Rarely          \n",
       "2                                             Rarely          \n",
       "3                                              Often          \n",
       "4                                             Always          \n",
       "\n",
       "  8. Does your personal relationship (Love Life) affect your academic level  ?  \\\n",
       "0                                              Agree                             \n",
       "1                                           Disagree                             \n",
       "2                                           Disagree                             \n",
       "3                                           Disagree                             \n",
       "4                                              Agree                             \n",
       "\n",
       "  9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?  \\\n",
       "0                                            Neutral                                                \n",
       "1                                            Neutral                                                \n",
       "2                                        Comfortable                                                \n",
       "3                                            Neutral                                                \n",
       "4                                        Comfortable                                                \n",
       "\n",
       "   ... Are you?   Age  Status         Level of education  \\\n",
       "0  ...   Female  18-21   Taken  Undergraduate (Bachelor)   \n",
       "1  ...   Female  18-21  Single  Undergraduate (Bachelor)   \n",
       "2  ...   Female  18-21  Single  Undergraduate (Bachelor)   \n",
       "3  ...   Female  18-21   Taken  Undergraduate (Bachelor)   \n",
       "4  ...   Female  18-21   Taken  Undergraduate (Bachelor)   \n",
       "\n",
       "                                      Field of study  Location Governorates  \\\n",
       "0  Formal Sciences ( logic, mathematics, statisti...   Tunisia       Sousse   \n",
       "1  Formal Sciences ( logic, mathematics, statisti...   Tunisia       Sousse   \n",
       "2                                          Business    Tunisia       Sousse   \n",
       "3                                         Marketing    Tunisia          NaN   \n",
       "4                              Business, management    Tunisia     Monastir   \n",
       "\n",
       "  Your university  How well do you describe yourself academically ?  \\\n",
       "0           Public                                                7   \n",
       "1           Public                                                8   \n",
       "2          Private                                                7   \n",
       "3          Private                                                7   \n",
       "4          Private                                                6   \n",
       "\n",
       "                Share your opinon about the surveys   \n",
       "0                                                NaN  \n",
       "1                                                NaN  \n",
       "2  Loved all the questions nice keep up the good ...  \n",
       "3                                          I like it  \n",
       "4                                               Long  \n",
       "\n",
       "[5 rows x 44 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.head()"
   ]
  },
  {
   "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>Timestamp</th>\n",
       "      <th>1. How comfortable are you with your surroundings in school ?</th>\n",
       "      <th>2. How would you rate the quality of your relationships with your classmates?</th>\n",
       "      <th>3. Do you have any close friends at school?</th>\n",
       "      <th>4. If 'YES', how did they affect in your academics?</th>\n",
       "      <th>5. What is the part of your student life that you are unsatisfied with the most?</th>\n",
       "      <th>6. Do you sometimes feel isolated in your college  environment?</th>\n",
       "      <th>7. How often do external problems affect your academics ?</th>\n",
       "      <th>8. Does your personal relationship (Love Life) affect your academic level  ?</th>\n",
       "      <th>9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?</th>\n",
       "      <th>...</th>\n",
       "      <th>Are you?</th>\n",
       "      <th>Age</th>\n",
       "      <th>Status</th>\n",
       "      <th>Level of education</th>\n",
       "      <th>Field of study</th>\n",
       "      <th>Location</th>\n",
       "      <th>Governorates</th>\n",
       "      <th>Your university</th>\n",
       "      <th>How well do you describe yourself academically ?</th>\n",
       "      <th>Share your opinon about the surveys</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>294</th>\n",
       "      <td>10/22/2023 7:01:15</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Teacher, Exams, Administration</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Never</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Natural Sciences (Medical,Biology, Chemistry, ...</td>\n",
       "      <td>Romania</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>160</th>\n",
       "      <td>10/21/2023 1:10:52</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Subjects, Schedule, Exams</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Pre-Engineering</td>\n",
       "      <td>cycle  prépartoire technolgie</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Kairouan</td>\n",
       "      <td>Public</td>\n",
       "      <td>6</td>\n",
       "      <td>i like it</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>10/20/2023 23:04:34</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Subjects, Exams</td>\n",
       "      <td>Always</td>\n",
       "      <td>Always</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Pre-Engineering</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Public</td>\n",
       "      <td>1</td>\n",
       "      <td>Boring</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>10/20/2023 22:25:48</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>Yes</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Exams</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>PhD</td>\n",
       "      <td>Natural Sciences (Medical,Biology, Chemistry, ...</td>\n",
       "      <td>United States</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Private</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>10/20/2023 22:07:54</td>\n",
       "      <td>8</td>\n",
       "      <td>10</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Teacher</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Public</td>\n",
       "      <td>6</td>\n",
       "      <td>interesting and i enjoyed doing it</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>10/21/2023 8:39:59</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Social life, Teacher, Administration</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>22-24</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Nabeul</td>\n",
       "      <td>Public</td>\n",
       "      <td>6</td>\n",
       "      <td>Idk if the governorate is for university or wh...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>10/21/2023 5:22:01</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Schedule</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>22-24</td>\n",
       "      <td>Single</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Private</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>10/20/2023 23:12:06</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Social life</td>\n",
       "      <td>Often</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Uncomfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>+ 28</td>\n",
       "      <td>Married</td>\n",
       "      <td>PhD</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>Nigeria</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Public</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>436</th>\n",
       "      <td>10/30/2023 19:01:48</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social life</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>22-24</td>\n",
       "      <td>Taken</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Social Sciences ( Business, law, languages, ph...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Public</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>11/1/2023 18:01:06</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Social life, Schedule, Administration</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Pre-Engineering</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Nabeul</td>\n",
       "      <td>Public</td>\n",
       "      <td>7</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Timestamp  \\\n",
       "294   10/22/2023 7:01:15   \n",
       "160   10/21/2023 1:10:52   \n",
       "124  10/20/2023 23:04:34   \n",
       "106  10/20/2023 22:25:48   \n",
       "88   10/20/2023 22:07:54   \n",
       "185   10/21/2023 8:39:59   \n",
       "169   10/21/2023 5:22:01   \n",
       "129  10/20/2023 23:12:06   \n",
       "436  10/30/2023 19:01:48   \n",
       "453   11/1/2023 18:01:06   \n",
       "\n",
       "     1. How comfortable are you with your surroundings in school ?  \\\n",
       "294                                                  8               \n",
       "160                                                  7               \n",
       "124                                                  4               \n",
       "106                                                  5               \n",
       "88                                                   8               \n",
       "185                                                  6               \n",
       "169                                                 10               \n",
       "129                                                 10               \n",
       "436                                                  3               \n",
       "453                                                  6               \n",
       "\n",
       "     2. How would you rate the quality of your relationships with your classmates?  \\\n",
       "294                                                  8                               \n",
       "160                                                  5                               \n",
       "124                                                  8                               \n",
       "106                                                  8                               \n",
       "88                                                  10                               \n",
       "185                                                  3                               \n",
       "169                                                  7                               \n",
       "129                                                 10                               \n",
       "436                                                  2                               \n",
       "453                                                  5                               \n",
       "\n",
       "    3. Do you have any close friends at school?  \\\n",
       "294                                         Yes   \n",
       "160                                         Yes   \n",
       "124                                          No   \n",
       "106                                         Yes   \n",
       "88                                          Yes   \n",
       "185                                         Yes   \n",
       "169                                         Yes   \n",
       "129                                         Yes   \n",
       "436                                          No   \n",
       "453                                         Yes   \n",
       "\n",
       "    4. If 'YES', how did they affect in your academics?  \\\n",
       "294                                             Normal    \n",
       "160                                      Positive/Good    \n",
       "124                                                NaN    \n",
       "106                                                NaN    \n",
       "88                                              Normal    \n",
       "185                                             Normal    \n",
       "169                                      Positive/Good    \n",
       "129                                             Normal    \n",
       "436                                                NaN    \n",
       "453                                             Normal    \n",
       "\n",
       "    5. What is the part of your student life that you are unsatisfied with the most?  \\\n",
       "294                     Teacher, Exams, Administration                                 \n",
       "160                          Subjects, Schedule, Exams                                 \n",
       "124                                    Subjects, Exams                                 \n",
       "106                                              Exams                                 \n",
       "88                                             Teacher                                 \n",
       "185               Social life, Teacher, Administration                                 \n",
       "169                                           Schedule                                 \n",
       "129                                        Social life                                 \n",
       "436                                        Social life                                 \n",
       "453              Social life, Schedule, Administration                                 \n",
       "\n",
       "    6. Do you sometimes feel isolated in your college  environment?  \\\n",
       "294                                             Rarely                \n",
       "160                                          Sometimes                \n",
       "124                                             Always                \n",
       "106                                          Sometimes                \n",
       "88                                           Sometimes                \n",
       "185                                          Sometimes                \n",
       "169                                             Rarely                \n",
       "129                                              Often                \n",
       "436                                          Sometimes                \n",
       "453                                          Sometimes                \n",
       "\n",
       "    7. How often do external problems affect your academics ?  \\\n",
       "294                                              Never          \n",
       "160                                          Sometimes          \n",
       "124                                             Always          \n",
       "106                                             Rarely          \n",
       "88                                           Sometimes          \n",
       "185                                          Sometimes          \n",
       "169                                          Sometimes          \n",
       "129                                          Sometimes          \n",
       "436                                              Often          \n",
       "453                                             Rarely          \n",
       "\n",
       "    8. Does your personal relationship (Love Life) affect your academic level  ?  \\\n",
       "294                                              Agree                             \n",
       "160                                              Agree                             \n",
       "124                                              Agree                             \n",
       "106                                           Disagree                             \n",
       "88                                            Disagree                             \n",
       "185                                           Disagree                             \n",
       "169                                              Agree                             \n",
       "129                                              Agree                             \n",
       "436                                              Agree                             \n",
       "453                                           Disagree                             \n",
       "\n",
       "    9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?  \\\n",
       "294                                            Neutral                                                \n",
       "160                                        Comfortable                                                \n",
       "124                                            Neutral                                                \n",
       "106                                            Neutral                                                \n",
       "88                                         Comfortable                                                \n",
       "185                                            Neutral                                                \n",
       "169                                            Neutral                                                \n",
       "129                                      Uncomfortable                                                \n",
       "436                                        Comfortable                                                \n",
       "453                                            Neutral                                                \n",
       "\n",
       "     ... Are you?   Age   Status         Level of education  \\\n",
       "294  ...   Female  18-21   Single  Undergraduate (Bachelor)   \n",
       "160  ...   Female  18-21   Single           Pre-Engineering   \n",
       "124  ...   Female  18-21   Single           Pre-Engineering   \n",
       "106  ...   Female  18-21   Single                       PhD   \n",
       "88   ...   Female  18-21   Single  Undergraduate (Bachelor)   \n",
       "185  ...     Male  22-24   Single  Undergraduate (Bachelor)   \n",
       "169  ...     Male  22-24   Single               Engineering   \n",
       "129  ...     Male   + 28  Married                       PhD   \n",
       "436  ...     Male  22-24    Taken  Undergraduate (Bachelor)   \n",
       "453  ...     Male  18-21   Single           Pre-Engineering   \n",
       "\n",
       "                                        Field of study       Location  \\\n",
       "294  Natural Sciences (Medical,Biology, Chemistry, ...        Romania   \n",
       "160                      cycle  prépartoire technolgie        Tunisia   \n",
       "124  Formal Sciences ( logic, mathematics, statisti...        Tunisia   \n",
       "106  Natural Sciences (Medical,Biology, Chemistry, ...  United States   \n",
       "88   Formal Sciences ( logic, mathematics, statisti...        Tunisia   \n",
       "185  Formal Sciences ( logic, mathematics, statisti...        Tunisia   \n",
       "169  Formal Sciences ( logic, mathematics, statisti...        Tunisia   \n",
       "129                                       Engineering         Nigeria   \n",
       "436  Social Sciences ( Business, law, languages, ph...        Tunisia   \n",
       "453  Formal Sciences ( logic, mathematics, statisti...        Tunisia   \n",
       "\n",
       "    Governorates Your university   \\\n",
       "294          NaN          Private   \n",
       "160     Kairouan           Public   \n",
       "124          NaN           Public   \n",
       "106          NaN          Private   \n",
       "88        Sousse           Public   \n",
       "185       Nabeul           Public   \n",
       "169       Sousse          Private   \n",
       "129          NaN           Public   \n",
       "436       Sousse           Public   \n",
       "453       Nabeul           Public   \n",
       "\n",
       "    How well do you describe yourself academically ?  \\\n",
       "294                                                8   \n",
       "160                                                6   \n",
       "124                                                1   \n",
       "106                                                6   \n",
       "88                                                 6   \n",
       "185                                                6   \n",
       "169                                                8   \n",
       "129                                                7   \n",
       "436                                                7   \n",
       "453                                                7   \n",
       "\n",
       "                  Share your opinon about the surveys   \n",
       "294                                                NaN  \n",
       "160                                          i like it  \n",
       "124                                             Boring  \n",
       "106                                                NaN  \n",
       "88                  interesting and i enjoyed doing it  \n",
       "185  Idk if the governorate is for university or wh...  \n",
       "169                                                NaN  \n",
       "129                                                NaN  \n",
       "436                                                NaN  \n",
       "453                                                NaN  \n",
       "\n",
       "[10 rows x 44 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "20152"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.size\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(458, 44)"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Timestamp',\n",
       "       '1. How comfortable are you with your surroundings in school ?',\n",
       "       '2. How would you rate the quality of your relationships with your classmates?',\n",
       "       '3. Do you have any close friends at school?',\n",
       "       '4. If 'YES', how did they affect in your academics?',\n",
       "       '5. What is the part of your student life that you are unsatisfied with the most?',\n",
       "       '6. Do you sometimes feel isolated in your college  environment?',\n",
       "       '7. How often do external problems affect your academics ?',\n",
       "       '8. Does your personal relationship (Love Life) affect your academic level  ?',\n",
       "       '9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?',\n",
       "       '10. Are you engaged in any external activities  (Associations, Clubs, organizations...) outside of academics? ',\n",
       "       '11. If 'YES',How often are you engaged in these social activities ? ',\n",
       "       '1. Does your academic study affect your mental well-being?',\n",
       "       '2. If 'YES' rate it: ',\n",
       "       '3. Do you feel motivated to wake up and go to college?',\n",
       "       '4. How stresseful  school is for you?',\n",
       "       '5. How would you rate the university environment ?',\n",
       "       '6. Do you experience any sleep disorders during exams and assesment due to the university environment ?',\n",
       "       '7. Is it tough for you to fulfill your ambitions ?',\n",
       "       '8. If you could choose any of these words to describe your mental health, which would suit you? ',\n",
       "       '9. Do academic results affect your mental health ?',\n",
       "       '1. Are you engaged in any physical activities ? (gym, sport activity ...)',\n",
       "       '2. If \"NO\", tell us why ',\n",
       "       '3. Do you often have time to have lunch during the break',\n",
       "       '4. Does it cause you any eat disorders',\n",
       "       '5. How many hours of sleep do you get on an average night at university ?',\n",
       "       '6. How would you describe your daily routine?',\n",
       "       '7. How do you rate your overall health ?',\n",
       "       '1. How do you rate your emotional resilience ?',\n",
       "       '2. Have you ever felt like you lack a sense of purpose in your studies ?',\n",
       "       '3. How confident do you feel in your ability to overcome challenges in your academic life?',\n",
       "       '4. Have you ever received training or support in developing emotional resilience skills?',\n",
       "       '5. If 'YES', did it help ?',\n",
       "       '6. How often do you engage in activities that help you relax and unwind?',\n",
       "       'Are you?', 'Age ', 'Status ', 'Level of education', 'Field of study',\n",
       "       'Location', 'Governorates', 'Your university ',\n",
       "       'How well do you describe yourself academically ?',\n",
       "       'Share your opinon about the surveys '],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>Timestamp</th>\n",
       "      <th>1. How comfortable are you with your surroundings in school ?</th>\n",
       "      <th>2. How would you rate the quality of your relationships with your classmates?</th>\n",
       "      <th>3. Do you have any close friends at school?</th>\n",
       "      <th>4. If 'YES', how did they affect in your academics?</th>\n",
       "      <th>5. What is the part of your student life that you are unsatisfied with the most?</th>\n",
       "      <th>6. Do you sometimes feel isolated in your college  environment?</th>\n",
       "      <th>7. How often do external problems affect your academics ?</th>\n",
       "      <th>8. Does your personal relationship (Love Life) affect your academic level  ?</th>\n",
       "      <th>9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?</th>\n",
       "      <th>...</th>\n",
       "      <th>Are you?</th>\n",
       "      <th>Age</th>\n",
       "      <th>Status</th>\n",
       "      <th>Level of education</th>\n",
       "      <th>Field of study</th>\n",
       "      <th>Location</th>\n",
       "      <th>Governorates</th>\n",
       "      <th>Your university</th>\n",
       "      <th>How well do you describe yourself academically ?</th>\n",
       "      <th>Share your opinon about the surveys</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>10/21/2023 20:12:15</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Subjects, Schedule, Exams</td>\n",
       "      <td>Always</td>\n",
       "      <td>Always</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>24-28</td>\n",
       "      <td>Single</td>\n",
       "      <td>Master's</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Ben Arous</td>\n",
       "      <td>Public</td>\n",
       "      <td>3</td>\n",
       "      <td>Fun</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>10/20/2023 22:03:36</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Teacher, Subjects, Administration</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Always</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Medical science</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Monastir</td>\n",
       "      <td>Public</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>337</th>\n",
       "      <td>10/24/2023 12:57:57</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Normal</td>\n",
       "      <td>Social life, Teacher,</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Monastir</td>\n",
       "      <td>Public</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>10/20/2023 22:15:03</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Social life, Schedule, Administration</td>\n",
       "      <td>Always</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Taken</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Monastir</td>\n",
       "      <td>Public</td>\n",
       "      <td>6</td>\n",
       "      <td>It was a good experience 😁</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>193</th>\n",
       "      <td>10/21/2023 10:02:26</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Teacher, Schedule, Administration</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Social Sciences ( Business, law, languages, ph...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Public</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>10/20/2023 22:33:57</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Teacher, Schedule, Administration</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Often</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>22-24</td>\n",
       "      <td>Taken</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>Natural Sciences (Medical,Biology, Chemistry, ...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Tunis</td>\n",
       "      <td>Public</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>10/21/2023 11:17:09</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Social life</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Social Sciences ( Business, law, languages, ph...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Public</td>\n",
       "      <td>5</td>\n",
       "      <td>It is very interesting it is like i am talking...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>411</th>\n",
       "      <td>10/29/2023 15:50:03</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Social life, Teacher</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Social Sciences ( Business, law, languages, ph...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Ariana</td>\n",
       "      <td>Public</td>\n",
       "      <td>6</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>155</th>\n",
       "      <td>10/21/2023 0:39:41</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Teacher, Exams</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Female</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Taken</td>\n",
       "      <td>Pre-Engineering</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Public</td>\n",
       "      <td>10</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>286</th>\n",
       "      <td>10/21/2023 22:41:34</td>\n",
       "      <td>9</td>\n",
       "      <td>10</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Positive/Good</td>\n",
       "      <td>Exams</td>\n",
       "      <td>Never</td>\n",
       "      <td>Never</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>...</td>\n",
       "      <td>Male</td>\n",
       "      <td>18-21</td>\n",
       "      <td>Single</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>Formal Sciences ( logic, mathematics, statisti...</td>\n",
       "      <td>Tunisia</td>\n",
       "      <td>Sousse</td>\n",
       "      <td>Private</td>\n",
       "      <td>8</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 44 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Timestamp  \\\n",
       "256  10/21/2023 20:12:15   \n",
       "83   10/20/2023 22:03:36   \n",
       "337  10/24/2023 12:57:57   \n",
       "96   10/20/2023 22:15:03   \n",
       "193  10/21/2023 10:02:26   \n",
       "110  10/20/2023 22:33:57   \n",
       "211  10/21/2023 11:17:09   \n",
       "411  10/29/2023 15:50:03   \n",
       "155   10/21/2023 0:39:41   \n",
       "286  10/21/2023 22:41:34   \n",
       "\n",
       "     1. How comfortable are you with your surroundings in school ?  \\\n",
       "256                                                  1               \n",
       "83                                                   5               \n",
       "337                                                  6               \n",
       "96                                                   6               \n",
       "193                                                  3               \n",
       "110                                                  4               \n",
       "211                                                  7               \n",
       "411                                                  7               \n",
       "155                                                  6               \n",
       "286                                                  9               \n",
       "\n",
       "     2. How would you rate the quality of your relationships with your classmates?  \\\n",
       "256                                                  1                               \n",
       "83                                                   5                               \n",
       "337                                                  2                               \n",
       "96                                                   7                               \n",
       "193                                                  2                               \n",
       "110                                                  5                               \n",
       "211                                                  5                               \n",
       "411                                                  5                               \n",
       "155                                                  6                               \n",
       "286                                                 10                               \n",
       "\n",
       "    3. Do you have any close friends at school?  \\\n",
       "256                                          No   \n",
       "83                                          Yes   \n",
       "337                                         Yes   \n",
       "96                                           No   \n",
       "193                                         Yes   \n",
       "110                                         Yes   \n",
       "211                                         Yes   \n",
       "411                                         Yes   \n",
       "155                                         Yes   \n",
       "286                                         Yes   \n",
       "\n",
       "    4. If 'YES', how did they affect in your academics?  \\\n",
       "256                                                NaN    \n",
       "83                                       Positive/Good    \n",
       "337                                             Normal    \n",
       "96                                                 NaN    \n",
       "193                                      Positive/Good    \n",
       "110                                      Positive/Good    \n",
       "211                                      Positive/Good    \n",
       "411                                      Positive/Good    \n",
       "155                                      Positive/Good    \n",
       "286                                      Positive/Good    \n",
       "\n",
       "    5. What is the part of your student life that you are unsatisfied with the most?  \\\n",
       "256                          Subjects, Schedule, Exams                                 \n",
       "83                   Teacher, Subjects, Administration                                 \n",
       "337                             Social life, Teacher,                                  \n",
       "96               Social life, Schedule, Administration                                 \n",
       "193                  Teacher, Schedule, Administration                                 \n",
       "110                  Teacher, Schedule, Administration                                 \n",
       "211                                        Social life                                 \n",
       "411                               Social life, Teacher                                 \n",
       "155                                     Teacher, Exams                                 \n",
       "286                                              Exams                                 \n",
       "\n",
       "    6. Do you sometimes feel isolated in your college  environment?  \\\n",
       "256                                             Always                \n",
       "83                                              Rarely                \n",
       "337                                          Sometimes                \n",
       "96                                              Always                \n",
       "193                                             Rarely                \n",
       "110                                             Rarely                \n",
       "211                                          Sometimes                \n",
       "411                                          Sometimes                \n",
       "155                                          Sometimes                \n",
       "286                                              Never                \n",
       "\n",
       "    7. How often do external problems affect your academics ?  \\\n",
       "256                                             Always          \n",
       "83                                              Always          \n",
       "337                                          Sometimes          \n",
       "96                                              Rarely          \n",
       "193                                             Rarely          \n",
       "110                                              Often          \n",
       "211                                              Often          \n",
       "411                                             Rarely          \n",
       "155                                              Often          \n",
       "286                                              Never          \n",
       "\n",
       "    8. Does your personal relationship (Love Life) affect your academic level  ?  \\\n",
       "256                                              Agree                             \n",
       "83                                            Disagree                             \n",
       "337                                              Agree                             \n",
       "96                                            Disagree                             \n",
       "193                                           Disagree                             \n",
       "110                                           Disagree                             \n",
       "211                                              Agree                             \n",
       "411                                           Disagree                             \n",
       "155                                           Disagree                             \n",
       "286                                              Agree                             \n",
       "\n",
       "    9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?  \\\n",
       "256                                        Comfortable                                                \n",
       "83                                             Neutral                                                \n",
       "337                                            Neutral                                                \n",
       "96                                             Neutral                                                \n",
       "193                                        Comfortable                                                \n",
       "110                                        Comfortable                                                \n",
       "211                                            Neutral                                                \n",
       "411                                        Comfortable                                                \n",
       "155                                        Comfortable                                                \n",
       "286                                        Comfortable                                                \n",
       "\n",
       "     ... Are you?   Age  Status         Level of education  \\\n",
       "256  ...   Female  24-28  Single                  Master's   \n",
       "83   ...   Female  18-21  Single  Undergraduate (Bachelor)   \n",
       "337  ...     Male  18-21  Single  Undergraduate (Bachelor)   \n",
       "96   ...     Male  18-21   Taken  Undergraduate (Bachelor)   \n",
       "193  ...   Female  18-21  Single  Undergraduate (Bachelor)   \n",
       "110  ...   Female  22-24   Taken               Engineering   \n",
       "211  ...   Female  18-21  Single  Undergraduate (Bachelor)   \n",
       "411  ...   Female  18-21  Single  Undergraduate (Bachelor)   \n",
       "155  ...   Female  18-21   Taken           Pre-Engineering   \n",
       "286  ...     Male  18-21  Single  Undergraduate (Bachelor)   \n",
       "\n",
       "                                        Field of study  Location Governorates  \\\n",
       "256  Formal Sciences ( logic, mathematics, statisti...   Tunisia    Ben Arous   \n",
       "83                                     Medical science   Tunisia     Monastir   \n",
       "337  Formal Sciences ( logic, mathematics, statisti...   Tunisia     Monastir   \n",
       "96                                        Engineering    Tunisia     Monastir   \n",
       "193  Social Sciences ( Business, law, languages, ph...   Tunisia       Sousse   \n",
       "110  Natural Sciences (Medical,Biology, Chemistry, ...   Tunisia        Tunis   \n",
       "211  Social Sciences ( Business, law, languages, ph...   Tunisia       Sousse   \n",
       "411  Social Sciences ( Business, law, languages, ph...   Tunisia       Ariana   \n",
       "155  Formal Sciences ( logic, mathematics, statisti...   Tunisia       Sousse   \n",
       "286  Formal Sciences ( logic, mathematics, statisti...   Tunisia       Sousse   \n",
       "\n",
       "    Your university  How well do you describe yourself academically ?  \\\n",
       "256           Public                                                3   \n",
       "83            Public                                                6   \n",
       "337           Public                                                8   \n",
       "96            Public                                                6   \n",
       "193           Public                                                8   \n",
       "110           Public                                                8   \n",
       "211           Public                                                5   \n",
       "411           Public                                                6   \n",
       "155           Public                                               10   \n",
       "286          Private                                                8   \n",
       "\n",
       "                  Share your opinon about the surveys   \n",
       "256                                                Fun  \n",
       "83                                                 NaN  \n",
       "337                                                NaN  \n",
       "96                          It was a good experience 😁  \n",
       "193                                                NaN  \n",
       "110                                                NaN  \n",
       "211  It is very interesting it is like i am talking...  \n",
       "411                                                NaN  \n",
       "155                                                NaN  \n",
       "286                                                NaN  \n",
       "\n",
       "[10 rows x 44 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "ucolumns = [\"Timestamp\", \"Age \", \"Status \", \"Field of study\", \"Location\", \"Governorates\", \"Your university \", \"Share your opinon about the surveys \", \"4. If 'YES', how did they affect in your academics?\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.drop(columns=ucolumns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Timestamp',\n",
       " 'Age ',\n",
       " 'Status ',\n",
       " 'Field of study',\n",
       " 'Location',\n",
       " 'Governorates',\n",
       " 'Your university ',\n",
       " 'Share your opinon about the surveys ',\n",
       " \"4. If 'YES', how did they affect in your academics?\"]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ucolumns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['1. How comfortable are you with your surroundings in school ?',\n",
       "       '2. How would you rate the quality of your relationships with your classmates?',\n",
       "       '3. Do you have any close friends at school?',\n",
       "       '5. What is the part of your student life that you are unsatisfied with the most?',\n",
       "       '6. Do you sometimes feel isolated in your college  environment?',\n",
       "       '7. How often do external problems affect your academics ?',\n",
       "       '8. Does your personal relationship (Love Life) affect your academic level  ?',\n",
       "       '9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?',\n",
       "       '10. Are you engaged in any external activities  (Associations, Clubs, organizations...) outside of academics? ',\n",
       "       '11. If 'YES',How often are you engaged in these social activities ? ',\n",
       "       '1. Does your academic study affect your mental well-being?',\n",
       "       '2. If 'YES' rate it: ',\n",
       "       '3. Do you feel motivated to wake up and go to college?',\n",
       "       '4. How stresseful  school is for you?',\n",
       "       '5. How would you rate the university environment ?',\n",
       "       '6. Do you experience any sleep disorders during exams and assesment due to the university environment ?',\n",
       "       '7. Is it tough for you to fulfill your ambitions ?',\n",
       "       '8. If you could choose any of these words to describe your mental health, which would suit you? ',\n",
       "       '9. Do academic results affect your mental health ?',\n",
       "       '1. Are you engaged in any physical activities ? (gym, sport activity ...)',\n",
       "       '2. If \"NO\", tell us why ',\n",
       "       '3. Do you often have time to have lunch during the break',\n",
       "       '4. Does it cause you any eat disorders',\n",
       "       '5. How many hours of sleep do you get on an average night at university ?',\n",
       "       '6. How would you describe your daily routine?',\n",
       "       '7. How do you rate your overall health ?',\n",
       "       '1. How do you rate your emotional resilience ?',\n",
       "       '2. Have you ever felt like you lack a sense of purpose in your studies ?',\n",
       "       '3. How confident do you feel in your ability to overcome challenges in your academic life?',\n",
       "       '4. Have you ever received training or support in developing emotional resilience skills?',\n",
       "       '5. If 'YES', did it help ?',\n",
       "       '6. How often do you engage in activities that help you relax and unwind?',\n",
       "       'Are you?', 'Level of education',\n",
       "       'How well do you describe yourself academically ?'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(458, 35)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>1. How comfortable are you with your surroundings in school ?</th>\n",
       "      <th>2. How would you rate the quality of your relationships with your classmates?</th>\n",
       "      <th>3. Do you have any close friends at school?</th>\n",
       "      <th>5. What is the part of your student life that you are unsatisfied with the most?</th>\n",
       "      <th>6. Do you sometimes feel isolated in your college  environment?</th>\n",
       "      <th>7. How often do external problems affect your academics ?</th>\n",
       "      <th>8. Does your personal relationship (Love Life) affect your academic level  ?</th>\n",
       "      <th>9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?</th>\n",
       "      <th>10. Are you engaged in any external activities  (Associations, Clubs, organizations...) outside of academics?</th>\n",
       "      <th>11. If 'YES',How often are you engaged in these social activities ?</th>\n",
       "      <th>...</th>\n",
       "      <th>7. How do you rate your overall health ?</th>\n",
       "      <th>1. How do you rate your emotional resilience ?</th>\n",
       "      <th>2. Have you ever felt like you lack a sense of purpose in your studies ?</th>\n",
       "      <th>3. How confident do you feel in your ability to overcome challenges in your academic life?</th>\n",
       "      <th>4. Have you ever received training or support in developing emotional resilience skills?</th>\n",
       "      <th>5. If 'YES', did it help ?</th>\n",
       "      <th>6. How often do you engage in activities that help you relax and unwind?</th>\n",
       "      <th>Are you?</th>\n",
       "      <th>Level of education</th>\n",
       "      <th>How well do you describe yourself academically ?</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>274</th>\n",
       "      <td>6</td>\n",
       "      <td>8</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Subjects, Exams, Administration</td>\n",
       "      <td>Often</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>8</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Unconfident</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Soo helpful</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Female</td>\n",
       "      <td>Master's</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Social life</td>\n",
       "      <td>Often</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>No</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Confident</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Never</td>\n",
       "      <td>Female</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Social life</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Often</td>\n",
       "      <td>Agree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>No</td>\n",
       "      <td>Never</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Confident</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Quiet helpful</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>Female</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>No</td>\n",
       "      <td>Schedule</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>Yes, occasionally</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>...</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>No</td>\n",
       "      <td>Confident</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Quiet helpful</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Female</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Schedule, Exams</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>Yes, occasionally</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Daily</td>\n",
       "      <td>Female</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "      <td>No</td>\n",
       "      <td>Social life</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Always</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>No</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>...</td>\n",
       "      <td>9</td>\n",
       "      <td>6</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Quiet helpful</td>\n",
       "      <td>Monthly</td>\n",
       "      <td>Female</td>\n",
       "      <td>Engineering</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Subjects, Schedule, Administration</td>\n",
       "      <td>Never</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>No</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>...</td>\n",
       "      <td>7</td>\n",
       "      <td>8</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Confident</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Soo helpful</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Male</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Exams</td>\n",
       "      <td>Never</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Comfortable</td>\n",
       "      <td>Yes, Too Much</td>\n",
       "      <td>Daily</td>\n",
       "      <td>...</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>No</td>\n",
       "      <td>Confident</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Quiet helpful</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Male</td>\n",
       "      <td>Pre-Engineering</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Subjects, Exams</td>\n",
       "      <td>Often</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>4</td>\n",
       "      <td>9</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>No</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Male</td>\n",
       "      <td>Undergraduate (Bachelor)</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>276</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Social life, Subjects</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Sometimes</td>\n",
       "      <td>Disagree</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Yes, occasionally</td>\n",
       "      <td>Weekly</td>\n",
       "      <td>...</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>No</td>\n",
       "      <td>Neutral</td>\n",
       "      <td>Yes</td>\n",
       "      <td>Quiet helpful</td>\n",
       "      <td>Rarely</td>\n",
       "      <td>Female</td>\n",
       "      <td>Master's</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>10 rows × 35 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     1. How comfortable are you with your surroundings in school ?  \\\n",
       "274                                                  6               \n",
       "79                                                   1               \n",
       "68                                                   6               \n",
       "40                                                   7               \n",
       "258                                                  8               \n",
       "47                                                   4               \n",
       "38                                                  10               \n",
       "30                                                   8               \n",
       "85                                                   5               \n",
       "276                                                  5               \n",
       "\n",
       "     2. How would you rate the quality of your relationships with your classmates?  \\\n",
       "274                                                  8                               \n",
       "79                                                   1                               \n",
       "68                                                   7                               \n",
       "40                                                   8                               \n",
       "258                                                  7                               \n",
       "47                                                   7                               \n",
       "38                                                  10                               \n",
       "30                                                   8                               \n",
       "85                                                   5                               \n",
       "276                                                  5                               \n",
       "\n",
       "    3. Do you have any close friends at school?  \\\n",
       "274                                         Yes   \n",
       "79                                          Yes   \n",
       "68                                          Yes   \n",
       "40                                           No   \n",
       "258                                         Yes   \n",
       "47                                           No   \n",
       "38                                          Yes   \n",
       "30                                          Yes   \n",
       "85                                          Yes   \n",
       "276                                         Yes   \n",
       "\n",
       "    5. What is the part of your student life that you are unsatisfied with the most?  \\\n",
       "274                    Subjects, Exams, Administration                                 \n",
       "79                                         Social life                                 \n",
       "68                                         Social life                                 \n",
       "40                                            Schedule                                 \n",
       "258                                    Schedule, Exams                                 \n",
       "47                                         Social life                                 \n",
       "38                  Subjects, Schedule, Administration                                 \n",
       "30                                               Exams                                 \n",
       "85                                     Subjects, Exams                                 \n",
       "276                              Social life, Subjects                                 \n",
       "\n",
       "    6. Do you sometimes feel isolated in your college  environment?  \\\n",
       "274                                              Often                \n",
       "79                                               Often                \n",
       "68                                           Sometimes                \n",
       "40                                           Sometimes                \n",
       "258                                             Rarely                \n",
       "47                                           Sometimes                \n",
       "38                                               Never                \n",
       "30                                               Never                \n",
       "85                                               Often                \n",
       "276                                          Sometimes                \n",
       "\n",
       "    7. How often do external problems affect your academics ?  \\\n",
       "274                                          Sometimes          \n",
       "79                                           Sometimes          \n",
       "68                                               Often          \n",
       "40                                           Sometimes          \n",
       "258                                             Rarely          \n",
       "47                                              Always          \n",
       "38                                           Sometimes          \n",
       "30                                              Rarely          \n",
       "85                                           Sometimes          \n",
       "276                                          Sometimes          \n",
       "\n",
       "    8. Does your personal relationship (Love Life) affect your academic level  ?  \\\n",
       "274                                           Disagree                             \n",
       "79                                            Disagree                             \n",
       "68                                               Agree                             \n",
       "40                                            Disagree                             \n",
       "258                                           Disagree                             \n",
       "47                                            Disagree                             \n",
       "38                                            Disagree                             \n",
       "30                                            Disagree                             \n",
       "85                                            Disagree                             \n",
       "276                                           Disagree                             \n",
       "\n",
       "    9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?  \\\n",
       "274                                        Comfortable                                                \n",
       "79                                             Neutral                                                \n",
       "68                                         Comfortable                                                \n",
       "40                                         Comfortable                                                \n",
       "258                                        Comfortable                                                \n",
       "47                                             Neutral                                                \n",
       "38                                             Neutral                                                \n",
       "30                                         Comfortable                                                \n",
       "85                                             Neutral                                                \n",
       "276                                            Neutral                                                \n",
       "\n",
       "    10. Are you engaged in any external activities  (Associations, Clubs, organizations...) outside of academics?   \\\n",
       "274                                                 No                                                               \n",
       "79                                                  No                                                               \n",
       "68                                                  No                                                               \n",
       "40                                   Yes, occasionally                                                               \n",
       "258                                  Yes, occasionally                                                               \n",
       "47                                                  No                                                               \n",
       "38                                                  No                                                               \n",
       "30                                       Yes, Too Much                                                               \n",
       "85                                                  No                                                               \n",
       "276                                  Yes, occasionally                                                               \n",
       "\n",
       "    11. If 'YES',How often are you engaged in these social activities ?   ...  \\\n",
       "274                                                NaN                    ...   \n",
       "79                                              Rarely                    ...   \n",
       "68                                               Never                    ...   \n",
       "40                                             Monthly                    ...   \n",
       "258                                             Weekly                    ...   \n",
       "47                                              Rarely                    ...   \n",
       "38                                              Rarely                    ...   \n",
       "30                                               Daily                    ...   \n",
       "85                                                 NaN                    ...   \n",
       "276                                             Weekly                    ...   \n",
       "\n",
       "    7. How do you rate your overall health ?  \\\n",
       "274                                        5   \n",
       "79                                         5   \n",
       "68                                         9   \n",
       "40                                         6   \n",
       "258                                        7   \n",
       "47                                         9   \n",
       "38                                         7   \n",
       "30                                         8   \n",
       "85                                         4   \n",
       "276                                        5   \n",
       "\n",
       "     1. How do you rate your emotional resilience ?  \\\n",
       "274                                               8   \n",
       "79                                                2   \n",
       "68                                                5   \n",
       "40                                                6   \n",
       "258                                               9   \n",
       "47                                                6   \n",
       "38                                                8   \n",
       "30                                                7   \n",
       "85                                                9   \n",
       "276                                               5   \n",
       "\n",
       "    2. Have you ever felt like you lack a sense of purpose in your studies ?  \\\n",
       "274                                                Yes                         \n",
       "79                                                 Yes                         \n",
       "68                                                 Yes                         \n",
       "40                                                  No                         \n",
       "258                                                Yes                         \n",
       "47                                                 Yes                         \n",
       "38                                                 Yes                         \n",
       "30                                                  No                         \n",
       "85                                                 Yes                         \n",
       "276                                                 No                         \n",
       "\n",
       "     3. How confident do you feel in your ability to overcome challenges in your academic life?  \\\n",
       "274                                        Unconfident                                            \n",
       "79                                           Confident                                            \n",
       "68                                           Confident                                            \n",
       "40                                           Confident                                            \n",
       "258                                            Neutral                                            \n",
       "47                                             Neutral                                            \n",
       "38                                           Confident                                            \n",
       "30                                           Confident                                            \n",
       "85                                             Neutral                                            \n",
       "276                                            Neutral                                            \n",
       "\n",
       "    4. Have you ever received training or support in developing emotional resilience skills?  \\\n",
       "274                                                Yes                                         \n",
       "79                                                  No                                         \n",
       "68                                                 Yes                                         \n",
       "40                                                 Yes                                         \n",
       "258                                                 No                                         \n",
       "47                                                 Yes                                         \n",
       "38                                                 Yes                                         \n",
       "30                                                 Yes                                         \n",
       "85                                                  No                                         \n",
       "276                                                Yes                                         \n",
       "\n",
       "    5. If 'YES', did it help ?  \\\n",
       "274                Soo helpful   \n",
       "79                         NaN   \n",
       "68               Quiet helpful   \n",
       "40               Quiet helpful   \n",
       "258                        NaN   \n",
       "47               Quiet helpful   \n",
       "38                 Soo helpful   \n",
       "30               Quiet helpful   \n",
       "85                         NaN   \n",
       "276              Quiet helpful   \n",
       "\n",
       "    6. How often do you engage in activities that help you relax and unwind?  \\\n",
       "274                                             Rarely                         \n",
       "79                                               Never                         \n",
       "68                                             Monthly                         \n",
       "40                                              Rarely                         \n",
       "258                                              Daily                         \n",
       "47                                             Monthly                         \n",
       "38                                              Rarely                         \n",
       "30                                              Rarely                         \n",
       "85                                              Rarely                         \n",
       "276                                             Rarely                         \n",
       "\n",
       "    Are you?        Level of education  \\\n",
       "274   Female                  Master's   \n",
       "79    Female  Undergraduate (Bachelor)   \n",
       "68    Female  Undergraduate (Bachelor)   \n",
       "40    Female  Undergraduate (Bachelor)   \n",
       "258   Female  Undergraduate (Bachelor)   \n",
       "47    Female               Engineering   \n",
       "38      Male  Undergraduate (Bachelor)   \n",
       "30      Male           Pre-Engineering   \n",
       "85      Male  Undergraduate (Bachelor)   \n",
       "276   Female                  Master's   \n",
       "\n",
       "    How well do you describe yourself academically ?  \n",
       "274                                                5  \n",
       "79                                                 8  \n",
       "68                                                 8  \n",
       "40                                                 6  \n",
       "258                                                7  \n",
       "47                                                 6  \n",
       "38                                                 7  \n",
       "30                                                 7  \n",
       "85                                                 5  \n",
       "276                                                8  \n",
       "\n",
       "[10 rows x 35 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "ucolumns =[\"Are you?\", \"5. If 'YES', did it help ?\", \"11. If 'YES',How often are you engaged in these social activities ? \"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "data = data.drop(columns=ucolumns)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "32"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data.columns.size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Undergraduate (Bachelor)    259\n",
       "Pre-Engineering             113\n",
       "Engineering                  46\n",
       "Master's                     30\n",
       "PhD                          10\n",
       "Name: Level of education, dtype: int64"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data[\"Level of education\"].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "data2 = data\n",
    "data2.to_excel('datanocolumns.xlsx', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "pre_engineering_df = data2.loc[data2['Level of education'] == 'Pre-Engineering']\n",
    "\n",
    "# Create a DataFrame for Engineering\n",
    "engineering_df = data2.loc[data2['Level of education'] == 'Engineering']\n",
    "\n",
    "# Create a DataFrame for Undergraduate\n",
    "undergraduate_df = data2.loc[data2['Level of education'] == 'Undergraduate (Bachelor)']\n",
    "\n",
    "# Create a DataFrame for Master's and PhD\n",
    "masters_phd_df = data2.loc[data2['Level of education'].isin(['Master\\'s', 'PhD'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method IndexOpsMixin.value_counts of 7      Pre-Engineering\n",
       "13     Pre-Engineering\n",
       "14     Pre-Engineering\n",
       "18     Pre-Engineering\n",
       "24     Pre-Engineering\n",
       "            ...       \n",
       "448    Pre-Engineering\n",
       "451    Pre-Engineering\n",
       "453    Pre-Engineering\n",
       "454    Pre-Engineering\n",
       "456    Pre-Engineering\n",
       "Name: Level of education, Length: 113, dtype: object>"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pre_engineering_df[\"Level of education\"].value_counts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(113, 32)"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pre_engineering_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(40, 32)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "masters_phd_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [],
   "source": [
    "pre_engineering_df.to_excel('pre_engineering_data.xlsx', index=False)\n",
    "engineering_df.to_excel('engineering_data.xlsx', index=False)\n",
    "\n",
    "# Create a DataFrame for Undergraduate\n",
    "\n",
    "undergraduate_df.to_excel('undergraduate_data.xlsx', index=False)\n",
    "\n",
    "# Create a DataFrame for Master's and PhD\n",
    "\n",
    "masters_phd_df.to_excel('masters_phd_data.xlsx', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "data2 = data\n",
    "column_names = data2.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['1. How comfortable are you with your surroundings in school ?',\n",
       "       '2. How would you rate the quality of your relationships with your classmates?',\n",
       "       '3. Do you have any close friends at school?',\n",
       "       '5. What is the part of your student life that you are unsatisfied with the most?',\n",
       "       '6. Do you sometimes feel isolated in your college  environment?',\n",
       "       '7. How often do external problems affect your academics ?',\n",
       "       '8. Does your personal relationship (Love Life) affect your academic level  ?',\n",
       "       '9. Do you feel comfortable seeking help or advice from friends when facing academic challenges?',\n",
       "       '10. Are you engaged in any external activities  (Associations, Clubs, organizations...) outside of academics? ',\n",
       "       '1. Does your academic study affect your mental well-being?',\n",
       "       '2. If 'YES' rate it: ',\n",
       "       '3. Do you feel motivated to wake up and go to college?',\n",
       "       '4. How stresseful  school is for you?',\n",
       "       '5. How would you rate the university environment ?',\n",
       "       '6. Do you experience any sleep disorders during exams and assesment due to the university environment ?',\n",
       "       '7. Is it tough for you to fulfill your ambitions ?',\n",
       "       '8. If you could choose any of these words to describe your mental health, which would suit you? ',\n",
       "       '9. Do academic results affect your mental health ?',\n",
       "       '1. Are you engaged in any physical activities ? (gym, sport activity ...)',\n",
       "       '2. If \"NO\", tell us why ',\n",
       "       '3. Do you often have time to have lunch during the break',\n",
       "       '4. Does it cause you any eat disorders',\n",
       "       '5. How many hours of sleep do you get on an average night at university ?',\n",
       "       '6. How would you describe your daily routine?',\n",
       "       '7. How do you rate your overall health ?',\n",
       "       '1. How do you rate your emotional resilience ?',\n",
       "       '2. Have you ever felt like you lack a sense of purpose in your studies ?',\n",
       "       '3. How confident do you feel in your ability to overcome challenges in your academic life?',\n",
       "       '4. Have you ever received training or support in developing emotional resilience skills?',\n",
       "       '6. How often do you engage in activities that help you relax and unwind?',\n",
       "       'Level of education',\n",
       "       'How well do you describe yourself academically ?'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "column_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  }
 ],
 "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.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}