From 5f6ec0476f262f14c4b134d44f294aeb8d603743 Mon Sep 17 00:00:00 2001
From: Anshul Gupta <ansg191@anshulg.com>
Date: Thu, 15 Feb 2024 16:42:24 -0800
Subject: Adds all questions to dataframe

---
 CS105MiniProject.ipynb | 25 ++++++++++++++-----------
 1 file changed, 14 insertions(+), 11 deletions(-)

(limited to 'CS105MiniProject.ipynb')

diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb
index 4935969..d19a096 100644
--- a/CS105MiniProject.ipynb
+++ b/CS105MiniProject.ipynb
@@ -2,7 +2,7 @@
  "cells": [
   {
    "cell_type": "code",
-   "execution_count": 2,
+   "execution_count": 1,
    "id": "daa13044",
    "metadata": {
     "id": "daa13044",
@@ -12,17 +12,17 @@
      "height": 614
     },
     "ExecuteTime": {
-     "end_time": "2024-02-16T00:28:29.748265Z",
-     "start_time": "2024-02-16T00:28:29.708379Z"
+     "end_time": "2024-02-16T00:42:12.437369Z",
+     "start_time": "2024-02-16T00:42:11.755307Z"
     }
    },
    "outputs": [
     {
      "data": {
-      "text/plain": "              Timestamp What gender do you identify as?  \\\n0     2/9/2024 20:12:14                            Male   \n1     2/9/2024 20:16:34                          Female   \n2     2/9/2024 20:18:55                          Female   \n3     2/9/2024 20:24:00                            Male   \n4     2/9/2024 20:26:16                            Male   \n..                  ...                             ...   \n255  2/14/2024 19:46:28                            Male   \n256   2/15/2024 0:28:38                            Male   \n257   2/15/2024 8:33:45                            Male   \n258  2/15/2024 16:10:40                          Female   \n259  2/15/2024 16:14:11                          Female   \n\n    Who do you live with?  How many people live in your household?  \n0                  Neither                                       6  \n1                     Both                                       4  \n2                  Friends                                       4  \n3                  Neither                                       1  \n4                  Neither                                       1  \n..                     ...                                     ...  \n255                Friends                                       5  \n256                 Family             North District 4 bed 2 bath  \n257                 Family                                       9  \n258                 Family                                       4  \n259                Friends      3 (room), 8 (hall), ~70 (building)  \n\n[260 rows x 4 columns]",
-      "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>What gender do you identify as?</th>\n      <th>Who do you live with?</th>\n      <th>How many people live in your household?</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>2/9/2024 20:12:14</td>\n      <td>Male</td>\n      <td>Neither</td>\n      <td>6</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2/9/2024 20:16:34</td>\n      <td>Female</td>\n      <td>Both</td>\n      <td>4</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>2/9/2024 20:18:55</td>\n      <td>Female</td>\n      <td>Friends</td>\n      <td>4</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>2/9/2024 20:24:00</td>\n      <td>Male</td>\n      <td>Neither</td>\n      <td>1</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>2/9/2024 20:26:16</td>\n      <td>Male</td>\n      <td>Neither</td>\n      <td>1</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>255</th>\n      <td>2/14/2024 19:46:28</td>\n      <td>Male</td>\n      <td>Friends</td>\n      <td>5</td>\n    </tr>\n    <tr>\n      <th>256</th>\n      <td>2/15/2024 0:28:38</td>\n      <td>Male</td>\n      <td>Family</td>\n      <td>North District 4 bed 2 bath</td>\n    </tr>\n    <tr>\n      <th>257</th>\n      <td>2/15/2024 8:33:45</td>\n      <td>Male</td>\n      <td>Family</td>\n      <td>9</td>\n    </tr>\n    <tr>\n      <th>258</th>\n      <td>2/15/2024 16:10:40</td>\n      <td>Female</td>\n      <td>Family</td>\n      <td>4</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td>2/15/2024 16:14:11</td>\n      <td>Female</td>\n      <td>Friends</td>\n      <td>3 (room), 8 (hall), ~70 (building)</td>\n    </tr>\n  </tbody>\n</table>\n<p>260 rows × 4 columns</p>\n</div>"
+      "text/plain": "              Timestamp What gender do you identify as?  \\\n0     2/9/2024 20:12:14                            Male   \n1     2/9/2024 20:16:34                          Female   \n2     2/9/2024 20:18:55                          Female   \n3     2/9/2024 20:24:00                            Male   \n4     2/9/2024 20:26:16                            Male   \n..                  ...                             ...   \n255  2/14/2024 19:46:28                            Male   \n256   2/15/2024 0:28:38                            Male   \n257   2/15/2024 8:33:45                            Male   \n258  2/15/2024 16:10:40                          Female   \n259  2/15/2024 16:14:11                          Female   \n\n    Who do you live with?   \\\n0                  Neither   \n1                     Both   \n2                  Friends   \n3                  Neither   \n4                  Neither   \n..                     ...   \n255                Friends   \n256                 Family   \n257                 Family   \n258                 Family   \n259                Friends   \n\n    Do you currently live in a house, apartnment, or dorm?   \\\n0                                                House        \n1                                            Apartment        \n2                                                House        \n3                                            Apartment        \n4                                            Apartment        \n..                                                 ...        \n255                                              House        \n256                                          Apartment        \n257                                              House        \n258                                          Apartment        \n259                                               Dorm        \n\n    How many people live in your household? Do you currently work?  \\\n0                                         6                    Yes   \n1                                         4                     No   \n2                                         4                     No   \n3                                         1                     No   \n4                                         1                    Yes   \n..                                      ...                    ...   \n255                                       5                    Yes   \n256             North District 4 bed 2 bath                     No   \n257                                       9                     No   \n258                                       4                    Yes   \n259      3 (room), 8 (hall), ~70 (building)                     No   \n\n    How many hours do you work per week on average?  \\\n0                                            5 - 10   \n1                                               NaN   \n2                                               NaN   \n3                                               NaN   \n4                                           10 - 20   \n..                                              ...   \n255                                         10 - 20   \n256                                             NaN   \n257                                           1 - 5   \n258                                          5 - 10   \n259                                             NaN   \n\n    Do you work on or off campus?  \\\n0                      Off-campus   \n1                             NaN   \n2                             NaN   \n3                             NaN   \n4                      Off-campus   \n..                            ...   \n255                     On-campus   \n256                           NaN   \n257                    Off-campus   \n258                     On-campus   \n259                           NaN   \n\n    Do you work in a department related to your major?  \\\n0                                                   No   \n1                                                  NaN   \n2                                                  NaN   \n3                                                   No   \n4                                                  Yes   \n..                                                 ...   \n255                                                 No   \n256                                                NaN   \n257                                                 No   \n258                                                 No   \n259                                                NaN   \n\n    Do you have roommates that are part of your major?  \n0                                                   No  \n1                                                  Yes  \n2                                                   No  \n3                                                   No  \n4                                                   No  \n..                                                 ...  \n255                                                 No  \n256                                                 No  \n257                                                 No  \n258                                                 No  \n259                                                Yes  \n\n[260 rows x 10 columns]",
+      "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>What gender do you identify as?</th>\n      <th>Who do you live with?</th>\n      <th>Do you currently live in a house, apartnment, or dorm?</th>\n      <th>How many people live in your household?</th>\n      <th>Do you currently work?</th>\n      <th>How many hours do you work per week on average?</th>\n      <th>Do you work on or off campus?</th>\n      <th>Do you work in a department related to your major?</th>\n      <th>Do you have roommates that are part of your major?</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>2/9/2024 20:12:14</td>\n      <td>Male</td>\n      <td>Neither</td>\n      <td>House</td>\n      <td>6</td>\n      <td>Yes</td>\n      <td>5 - 10</td>\n      <td>Off-campus</td>\n      <td>No</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>2/9/2024 20:16:34</td>\n      <td>Female</td>\n      <td>Both</td>\n      <td>Apartment</td>\n      <td>4</td>\n      <td>No</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Yes</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>2/9/2024 20:18:55</td>\n      <td>Female</td>\n      <td>Friends</td>\n      <td>House</td>\n      <td>4</td>\n      <td>No</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>2/9/2024 20:24:00</td>\n      <td>Male</td>\n      <td>Neither</td>\n      <td>Apartment</td>\n      <td>1</td>\n      <td>No</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>No</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>2/9/2024 20:26:16</td>\n      <td>Male</td>\n      <td>Neither</td>\n      <td>Apartment</td>\n      <td>1</td>\n      <td>Yes</td>\n      <td>10 - 20</td>\n      <td>Off-campus</td>\n      <td>Yes</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>255</th>\n      <td>2/14/2024 19:46:28</td>\n      <td>Male</td>\n      <td>Friends</td>\n      <td>House</td>\n      <td>5</td>\n      <td>Yes</td>\n      <td>10 - 20</td>\n      <td>On-campus</td>\n      <td>No</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>256</th>\n      <td>2/15/2024 0:28:38</td>\n      <td>Male</td>\n      <td>Family</td>\n      <td>Apartment</td>\n      <td>North District 4 bed 2 bath</td>\n      <td>No</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>257</th>\n      <td>2/15/2024 8:33:45</td>\n      <td>Male</td>\n      <td>Family</td>\n      <td>House</td>\n      <td>9</td>\n      <td>No</td>\n      <td>1 - 5</td>\n      <td>Off-campus</td>\n      <td>No</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>258</th>\n      <td>2/15/2024 16:10:40</td>\n      <td>Female</td>\n      <td>Family</td>\n      <td>Apartment</td>\n      <td>4</td>\n      <td>Yes</td>\n      <td>5 - 10</td>\n      <td>On-campus</td>\n      <td>No</td>\n      <td>No</td>\n    </tr>\n    <tr>\n      <th>259</th>\n      <td>2/15/2024 16:14:11</td>\n      <td>Female</td>\n      <td>Friends</td>\n      <td>Dorm</td>\n      <td>3 (room), 8 (hall), ~70 (building)</td>\n      <td>No</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>Yes</td>\n    </tr>\n  </tbody>\n</table>\n<p>260 rows × 10 columns</p>\n</div>"
      },
-     "execution_count": 2,
+     "execution_count": 1,
      "metadata": {},
      "output_type": "execute_result"
     }
@@ -33,17 +33,20 @@
     "import numpy as np\n",
     "\n",
     "df = pd.read_csv(\"data.csv\")\n",
-    "#df\n",
-    "df2 = df.iloc[:, [0, 5, 7, 9]]\n",
-    "df2"
+    "df = df.iloc[:, [0, 5, 7, 8, 9, 58, 59, 60, 61, 26]]\n",
+    "df"
    ]
   },
   {
    "cell_type": "code",
-   "execution_count": null,
+   "execution_count": 1,
    "id": "29889175",
    "metadata": {
-    "id": "29889175"
+    "id": "29889175",
+    "ExecuteTime": {
+     "end_time": "2024-02-16T00:42:12.440256Z",
+     "start_time": "2024-02-16T00:42:12.438587Z"
+    }
    },
    "outputs": [],
    "source": []
-- 
cgit v1.2.3