1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
|
{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "daa13044",
"metadata": {
"colab": {
"base_uri": "https://localhost:8080/",
"height": 614
},
"id": "daa13044",
"outputId": "4d440aaa-1ee7-4771-c526-f55e9458ca8a",
"ExecuteTime": {
"end_time": "2024-02-16T01:29:14.937392Z",
"start_time": "2024-02-16T01:29:14.276865Z"
}
},
"outputs": [
{
"data": {
"text/plain": " Timestamp What is your current class standing? \\\n0 2/9/2024 20:12:14 Senior \n1 2/9/2024 20:16:34 Junior \n2 2/9/2024 20:18:55 Junior \n3 2/9/2024 20:24:00 Senior \n4 2/9/2024 20:26:16 Graduate \n.. ... ... \n255 2/14/2024 19:46:28 Junior \n256 2/15/2024 0:28:38 NaN \n257 2/15/2024 8:33:45 Senior \n258 2/15/2024 16:10:40 Sophomore \n259 2/15/2024 16:14:11 Sophomore \n\n What gender do you identify as? Who do you live with? \\\n0 Male Neither \n1 Female Both \n2 Female Friends \n3 Male Neither \n4 Male Neither \n.. ... ... \n255 Male Friends \n256 Male Family \n257 Male Family \n258 Female Family \n259 Female 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 11 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 is your current class standing?</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>Senior</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>Junior</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>Junior</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>Senior</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>Graduate</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 <td>...</td>\n </tr>\n <tr>\n <th>255</th>\n <td>2/14/2024 19:46:28</td>\n <td>Junior</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>NaN</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>Senior</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>Sophomore</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>Sophomore</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 × 11 columns</p>\n</div>"
},
"execution_count": 1,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"%matplotlib inline\n",
"import pandas as pd\n",
"import numpy as np\n",
"\n",
"df = pd.read_csv(\"data.csv\")\n",
"df = df.iloc[:, [0, 2, 5, 7, 8, 9, 58, 59, 60, 61, 26]]\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "29889175",
"metadata": {
"id": "29889175",
"ExecuteTime": {
"end_time": "2024-02-16T01:29:14.950257Z",
"start_time": "2024-02-16T01:29:14.938720Z"
}
},
"outputs": [
{
"data": {
"text/plain": " Timestamp What is your current class standing? \\\n0 2/9/2024 20:12:14 Senior \n1 2/9/2024 20:16:34 Junior \n2 2/9/2024 20:18:55 Junior \n3 2/9/2024 20:24:00 Senior \n4 2/9/2024 20:26:16 Graduate \n.. ... ... \n255 2/14/2024 19:46:28 Junior \n256 2/15/2024 0:28:38 NaN \n257 2/15/2024 8:33:45 Senior \n258 2/15/2024 16:10:40 Sophomore \n259 2/15/2024 16:14:11 Sophomore \n\n What gender do you identify as? Who do you live with? \\\n0 Male Neither \n1 Female Both \n2 Female Friends \n3 Male Neither \n4 Male Neither \n.. ... ... \n255 Male Friends \n256 Male Family \n257 Male Family \n258 Female Family \n259 Female 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 4 No \n257 9 No \n258 4 Yes \n259 3 No \n\n How many hours do you work per week on average? \\\n0 5 - 10 \n1 0 \n2 0 \n3 0 \n4 10 - 20 \n.. ... \n255 10 - 20 \n256 0 \n257 0 \n258 5 - 10 \n259 0 \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 NaN \n4 Yes \n.. ... \n255 No \n256 NaN \n257 NaN \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 11 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 is your current class standing?</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>Senior</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>Junior</td>\n <td>Female</td>\n <td>Both</td>\n <td>Apartment</td>\n <td>4</td>\n <td>No</td>\n <td>0</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>Junior</td>\n <td>Female</td>\n <td>Friends</td>\n <td>House</td>\n <td>4</td>\n <td>No</td>\n <td>0</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>Senior</td>\n <td>Male</td>\n <td>Neither</td>\n <td>Apartment</td>\n <td>1</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>No</td>\n </tr>\n <tr>\n <th>4</th>\n <td>2/9/2024 20:26:16</td>\n <td>Graduate</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 <td>...</td>\n </tr>\n <tr>\n <th>255</th>\n <td>2/14/2024 19:46:28</td>\n <td>Junior</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>NaN</td>\n <td>Male</td>\n <td>Family</td>\n <td>Apartment</td>\n <td>4</td>\n <td>No</td>\n <td>0</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>Senior</td>\n <td>Male</td>\n <td>Family</td>\n <td>House</td>\n <td>9</td>\n <td>No</td>\n <td>0</td>\n <td>Off-campus</td>\n <td>NaN</td>\n <td>No</td>\n </tr>\n <tr>\n <th>258</th>\n <td>2/15/2024 16:10:40</td>\n <td>Sophomore</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>Sophomore</td>\n <td>Female</td>\n <td>Friends</td>\n <td>Dorm</td>\n <td>3</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>Yes</td>\n </tr>\n </tbody>\n</table>\n<p>260 rows × 11 columns</p>\n</div>"
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df['How many people live in your household?'] = (df['How many people live in your household?']\n",
" .fillna(0)\n",
" .replace('4 in total', '4')\n",
" .replace('4 (Including me)', '4')\n",
" .replace('at school 4 including me ', '4')\n",
" .replace('3 excluding me', '3')\n",
" .replace('5 including me', '5')\n",
" .replace('North District 4 bed 2 bath', '4')\n",
" .replace('3 (room), 8 (hall), ~70 (building)', '3')\n",
" .astype(int))\n",
"df.loc[df['Do you currently work?'] == 'No', 'How many hours do you work per week on average?'] = 0\n",
"df['Who do you live with? '] = df['Who do you live with? '].replace('Family, Friends', 'Both').replace('Family, Friends, Both', 'Both')\n",
"df.loc[df['Do you currently work?'] == 'No', 'Do you work in a department related to your major?'] = np.nan\n",
"df"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "de4448fd64205d85",
"metadata": {
"collapsed": false,
"ExecuteTime": {
"end_time": "2024-02-16T01:29:14.960720Z",
"start_time": "2024-02-16T01:29:14.951Z"
}
},
"outputs": [
{
"data": {
"text/plain": " Timestamp What is your current class standing? \\\n0 2/9/2024 20:12:14 Senior \n4 2/9/2024 20:26:16 Graduate \n8 2/9/2024 22:02:49 Junior \n9 2/9/2024 22:08:43 Senior \n13 2/9/2024 22:15:13 Junior \n.. ... ... \n246 2/13/2024 19:37:02 Graduate \n247 2/13/2024 21:39:14 Senior \n252 2/14/2024 9:48:12 Junior \n255 2/14/2024 19:46:28 Junior \n258 2/15/2024 16:10:40 Sophomore \n\n What gender do you identify as? Who do you live with? \\\n0 Male Neither \n4 Male Neither \n8 Male Friends \n9 Male Family \n13 Male Family \n.. ... ... \n246 Male Family \n247 Male Friends \n252 Male Family \n255 Male Friends \n258 Female Family \n\n Do you currently live in a house, apartnment, or dorm? \\\n0 House \n4 Apartment \n8 House \n9 House \n13 Apartment \n.. ... \n246 House \n247 Apartment \n252 House \n255 House \n258 Apartment \n\n How many people live in your household? Do you currently work? \\\n0 6 Yes \n4 1 Yes \n8 6 Yes \n9 5 Yes \n13 4 Yes \n.. ... ... \n246 2 Yes \n247 3 Yes \n252 5 Yes \n255 5 Yes \n258 4 Yes \n\n How many hours do you work per week on average? \\\n0 5 - 10 \n4 10 - 20 \n8 10 - 20 \n9 1 - 5 \n13 10 - 20 \n.. ... \n246 10 - 20 \n247 20 - 40 \n252 20 - 40 \n255 10 - 20 \n258 5 - 10 \n\n Do you work on or off campus? \\\n0 Off-campus \n4 Off-campus \n8 On-campus \n9 On-campus \n13 Off-campus \n.. ... \n246 On-campus \n247 Off-campus \n252 Off-campus \n255 On-campus \n258 On-campus \n\n Do you work in a department related to your major? \\\n0 No \n4 Yes \n8 No \n9 No \n13 No \n.. ... \n246 Yes \n247 No \n252 No \n255 No \n258 No \n\n Do you have roommates that are part of your major? \n0 No \n4 No \n8 No \n9 No \n13 No \n.. ... \n246 No \n247 Yes \n252 No \n255 No \n258 No \n\n[77 rows x 11 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 is your current class standing?</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>Senior</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>4</th>\n <td>2/9/2024 20:26:16</td>\n <td>Graduate</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>8</th>\n <td>2/9/2024 22:02:49</td>\n <td>Junior</td>\n <td>Male</td>\n <td>Friends</td>\n <td>House</td>\n <td>6</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>9</th>\n <td>2/9/2024 22:08:43</td>\n <td>Senior</td>\n <td>Male</td>\n <td>Family</td>\n <td>House</td>\n <td>5</td>\n <td>Yes</td>\n <td>1 - 5</td>\n <td>On-campus</td>\n <td>No</td>\n <td>No</td>\n </tr>\n <tr>\n <th>13</th>\n <td>2/9/2024 22:15:13</td>\n <td>Junior</td>\n <td>Male</td>\n <td>Family</td>\n <td>Apartment</td>\n <td>4</td>\n <td>Yes</td>\n <td>10 - 20</td>\n <td>Off-campus</td>\n <td>No</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 <td>...</td>\n </tr>\n <tr>\n <th>246</th>\n <td>2/13/2024 19:37:02</td>\n <td>Graduate</td>\n <td>Male</td>\n <td>Family</td>\n <td>House</td>\n <td>2</td>\n <td>Yes</td>\n <td>10 - 20</td>\n <td>On-campus</td>\n <td>Yes</td>\n <td>No</td>\n </tr>\n <tr>\n <th>247</th>\n <td>2/13/2024 21:39:14</td>\n <td>Senior</td>\n <td>Male</td>\n <td>Friends</td>\n <td>Apartment</td>\n <td>3</td>\n <td>Yes</td>\n <td>20 - 40</td>\n <td>Off-campus</td>\n <td>No</td>\n <td>Yes</td>\n </tr>\n <tr>\n <th>252</th>\n <td>2/14/2024 9:48:12</td>\n <td>Junior</td>\n <td>Male</td>\n <td>Family</td>\n <td>House</td>\n <td>5</td>\n <td>Yes</td>\n <td>20 - 40</td>\n <td>Off-campus</td>\n <td>No</td>\n <td>No</td>\n </tr>\n <tr>\n <th>255</th>\n <td>2/14/2024 19:46:28</td>\n <td>Junior</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>258</th>\n <td>2/15/2024 16:10:40</td>\n <td>Sophomore</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 </tbody>\n</table>\n<p>77 rows × 11 columns</p>\n</div>"
},
"execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"# Working DataFrame\n",
"w_df = df[df['Do you currently work?'] == 'Yes']\n",
"# Not working DataFrame\n",
"nw_df = df[df['Do you currently work?'] == 'No']\n",
"w_df"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "a9df972e44277de7",
"metadata": {
"collapsed": false,
"ExecuteTime": {
"end_time": "2024-02-16T01:29:14.970741Z",
"start_time": "2024-02-16T01:29:14.962311Z"
}
},
"outputs": [
{
"data": {
"text/plain": " Timestamp What is your current class standing? \\\n1 2/9/2024 20:16:34 Junior \n2 2/9/2024 20:18:55 Junior \n3 2/9/2024 20:24:00 Senior \n5 2/9/2024 20:45:09 Junior \n6 2/9/2024 21:55:59 Sophomore \n.. ... ... \n253 2/14/2024 13:45:45 Senior \n254 2/14/2024 16:26:06 Junior \n256 2/15/2024 0:28:38 NaN \n257 2/15/2024 8:33:45 Senior \n259 2/15/2024 16:14:11 Sophomore \n\n What gender do you identify as? Who do you live with? \\\n1 Female Both \n2 Female Friends \n3 Male Neither \n5 Prefer not to say Both \n6 Female Friends \n.. ... ... \n253 Female Family \n254 Male Family \n256 Male Family \n257 Male Family \n259 Female Friends \n\n Do you currently live in a house, apartnment, or dorm? \\\n1 Apartment \n2 House \n3 Apartment \n5 Apartment \n6 Apartment \n.. ... \n253 House \n254 House \n256 Apartment \n257 House \n259 Dorm \n\n How many people live in your household? Do you currently work? \\\n1 4 No \n2 4 No \n3 1 No \n5 4 No \n6 4 No \n.. ... ... \n253 6 No \n254 5 No \n256 4 No \n257 9 No \n259 3 No \n\n How many hours do you work per week on average? \\\n1 0 \n2 0 \n3 0 \n5 0 \n6 0 \n.. ... \n253 0 \n254 0 \n256 0 \n257 0 \n259 0 \n\n Do you work on or off campus? \\\n1 NaN \n2 NaN \n3 NaN \n5 NaN \n6 NaN \n.. ... \n253 NaN \n254 NaN \n256 NaN \n257 Off-campus \n259 NaN \n\n Do you work in a department related to your major? \\\n1 NaN \n2 NaN \n3 NaN \n5 NaN \n6 NaN \n.. ... \n253 NaN \n254 NaN \n256 NaN \n257 NaN \n259 NaN \n\n Do you have roommates that are part of your major? \n1 Yes \n2 No \n3 No \n5 No \n6 No \n.. ... \n253 No \n254 Yes \n256 No \n257 No \n259 Yes \n\n[176 rows x 11 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 is your current class standing?</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>1</th>\n <td>2/9/2024 20:16:34</td>\n <td>Junior</td>\n <td>Female</td>\n <td>Both</td>\n <td>Apartment</td>\n <td>4</td>\n <td>No</td>\n <td>0</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>Junior</td>\n <td>Female</td>\n <td>Friends</td>\n <td>House</td>\n <td>4</td>\n <td>No</td>\n <td>0</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>Senior</td>\n <td>Male</td>\n <td>Neither</td>\n <td>Apartment</td>\n <td>1</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>No</td>\n </tr>\n <tr>\n <th>5</th>\n <td>2/9/2024 20:45:09</td>\n <td>Junior</td>\n <td>Prefer not to say</td>\n <td>Both</td>\n <td>Apartment</td>\n <td>4</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>No</td>\n </tr>\n <tr>\n <th>6</th>\n <td>2/9/2024 21:55:59</td>\n <td>Sophomore</td>\n <td>Female</td>\n <td>Friends</td>\n <td>Apartment</td>\n <td>4</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</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 <td>...</td>\n </tr>\n <tr>\n <th>253</th>\n <td>2/14/2024 13:45:45</td>\n <td>Senior</td>\n <td>Female</td>\n <td>Family</td>\n <td>House</td>\n <td>6</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>No</td>\n </tr>\n <tr>\n <th>254</th>\n <td>2/14/2024 16:26:06</td>\n <td>Junior</td>\n <td>Male</td>\n <td>Family</td>\n <td>House</td>\n <td>5</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>Yes</td>\n </tr>\n <tr>\n <th>256</th>\n <td>2/15/2024 0:28:38</td>\n <td>NaN</td>\n <td>Male</td>\n <td>Family</td>\n <td>Apartment</td>\n <td>4</td>\n <td>No</td>\n <td>0</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>Senior</td>\n <td>Male</td>\n <td>Family</td>\n <td>House</td>\n <td>9</td>\n <td>No</td>\n <td>0</td>\n <td>Off-campus</td>\n <td>NaN</td>\n <td>No</td>\n </tr>\n <tr>\n <th>259</th>\n <td>2/15/2024 16:14:11</td>\n <td>Sophomore</td>\n <td>Female</td>\n <td>Friends</td>\n <td>Dorm</td>\n <td>3</td>\n <td>No</td>\n <td>0</td>\n <td>NaN</td>\n <td>NaN</td>\n <td>Yes</td>\n </tr>\n </tbody>\n</table>\n<p>176 rows × 11 columns</p>\n</div>"
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"nw_df"
]
},
{
"cell_type": "code",
"outputs": [],
"source": [],
"metadata": {
"collapsed": false,
"ExecuteTime": {
"end_time": "2024-02-16T01:29:14.974486Z",
"start_time": "2024-02-16T01:29:14.972680Z"
}
},
"id": "bfa40c9e9693481d",
"execution_count": 4
}
],
"metadata": {
"colab": {
"provenance": []
},
"kernelspec": {
"display_name": "Python 3 (ipykernel)",
"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.5"
}
},
"nbformat": 4,
"nbformat_minor": 5
}
|
