From aa9c60b320a3a2e5679826b471f44934ef64fdae Mon Sep 17 00:00:00 2001 From: Anshul Gupta Date: Thu, 15 Feb 2024 16:59:06 -0800 Subject: Adds some preprocessing --- CS105MiniProject.ipynb | 43 ++++++++++++++++++++++++++++++++++--------- 1 file changed, 34 insertions(+), 9 deletions(-) (limited to 'CS105MiniProject.ipynb') diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb index d19a096..dda76e0 100644 --- a/CS105MiniProject.ipynb +++ b/CS105MiniProject.ipynb @@ -12,15 +12,15 @@ "height": 614 }, "ExecuteTime": { - "end_time": "2024-02-16T00:42:12.437369Z", - "start_time": "2024-02-16T00:42:11.755307Z" + "end_time": "2024-02-16T00:58:32.054806Z", + "start_time": "2024-02-16T00:58:31.371211Z" } }, "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? \\\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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14MaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34FemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55FemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00MaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16MaleNeitherApartment1Yes10 - 20Off-campusYesNo
.................................
2552/14/2024 19:46:28MaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38MaleFamilyApartmentNorth District 4 bed 2 bathNoNaNNaNNaNNo
2572/15/2024 8:33:45MaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40FemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11FemaleFriendsDorm3 (room), 8 (hall), ~70 (building)NoNaNNaNNaNYes
\n

260 rows × 10 columns

\n
" + "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartmentNorth District 4 bed 2 bathNoNaNNaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3 (room), 8 (hall), ~70 (building)NoNaNNaNNaNYes
\n

260 rows × 11 columns

\n
" }, "execution_count": 1, "metadata": {}, @@ -33,23 +33,48 @@ "import numpy as np\n", "\n", "df = pd.read_csv(\"data.csv\")\n", - "df = df.iloc[:, [0, 5, 7, 8, 9, 58, 59, 60, 61, 26]]\n", + "df = df.iloc[:, [0, 2, 5, 7, 8, 9, 58, 59, 60, 61, 26]]\n", "df" ] }, { "cell_type": "code", - "execution_count": 1, + "execution_count": 2, "id": "29889175", "metadata": { "id": "29889175", "ExecuteTime": { - "end_time": "2024-02-16T00:42:12.440256Z", - "start_time": "2024-02-16T00:42:12.438587Z" + "end_time": "2024-02-16T00:58:32.059881Z", + "start_time": "2024-02-16T00:58:32.056070Z" } }, "outputs": [], - "source": [] + "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))" + ] + }, + { + "cell_type": "code", + "outputs": [], + "source": [], + "metadata": { + "collapsed": false, + "ExecuteTime": { + "end_time": "2024-02-16T00:58:32.062613Z", + "start_time": "2024-02-16T00:58:32.061050Z" + } + }, + "id": "de4448fd64205d85", + "execution_count": 2 } ], "metadata": { -- cgit v1.2.3 From 0441d9bdead1e968b8d05fdac0001b7609059d0e Mon Sep 17 00:00:00 2001 From: Anshul Gupta Date: Thu, 15 Feb 2024 17:13:38 -0800 Subject: Adds working and non-working dataframe --- CS105MiniProject.ipynb | 61 +++++++++++++++++++++++++++++++++++++++++--------- 1 file changed, 51 insertions(+), 10 deletions(-) (limited to 'CS105MiniProject.ipynb') diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb index dda76e0..603dbfc 100644 --- a/CS105MiniProject.ipynb +++ b/CS105MiniProject.ipynb @@ -12,8 +12,8 @@ "height": 614 }, "ExecuteTime": { - "end_time": "2024-02-16T00:58:32.054806Z", - "start_time": "2024-02-16T00:58:31.371211Z" + "end_time": "2024-02-16T01:13:23.980165Z", + "start_time": "2024-02-16T01:13:23.265957Z" } }, "outputs": [ @@ -44,11 +44,21 @@ "metadata": { "id": "29889175", "ExecuteTime": { - "end_time": "2024-02-16T00:58:32.059881Z", - "start_time": "2024-02-16T00:58:32.056070Z" + "end_time": "2024-02-16T01:13:23.990972Z", + "start_time": "2024-02-16T01:13:23.981386Z" } }, - "outputs": [], + "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 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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartment4NoNaNNaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3NoNaNNaNNaNYes
\n

260 rows × 11 columns

\n
" + }, + "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", @@ -59,9 +69,40 @@ " .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))" + " .astype(int))\n", + "df" ] }, + { + "cell_type": "code", + "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
82/9/2024 22:02:49JuniorMaleFriendsHouse6Yes10 - 20On-campusNoNo
92/9/2024 22:08:43SeniorMaleFamilyHouse5Yes1 - 5On-campusNoNo
132/9/2024 22:15:13JuniorMaleFamilyApartment4Yes10 - 20Off-campusNoNo
....................................
2462/13/2024 19:37:02GraduateMaleFamilyHouse2Yes10 - 20On-campusYesNo
2472/13/2024 21:39:14SeniorMaleFriendsApartment3Yes20 - 40Off-campusNoYes
2522/14/2024 9:48:12JuniorMaleFamilyHouse5Yes20 - 40Off-campusNoNo
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
\n

77 rows × 11 columns

\n
" + }, + "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" + ], + "metadata": { + "collapsed": false, + "ExecuteTime": { + "end_time": "2024-02-16T01:13:24.001347Z", + "start_time": "2024-02-16T01:13:23.991767Z" + } + }, + "id": "de4448fd64205d85", + "execution_count": 3 + }, { "cell_type": "code", "outputs": [], @@ -69,12 +110,12 @@ "metadata": { "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T00:58:32.062613Z", - "start_time": "2024-02-16T00:58:32.061050Z" + "end_time": "2024-02-16T01:13:24.004250Z", + "start_time": "2024-02-16T01:13:24.002783Z" } }, - "id": "de4448fd64205d85", - "execution_count": 2 + "id": "a9df972e44277de7", + "execution_count": 3 } ], "metadata": { -- cgit v1.2.3 From dd027e01f0d7919a07c67d4a2fc9f1ba5f88b8c5 Mon Sep 17 00:00:00 2001 From: Anaqvi2020 Date: Thu, 15 Feb 2024 17:21:07 -0800 Subject: Set nonworkers to 0 hours --- CS105MiniProject.ipynb | 925 +++++++++++++++++++++++++++++++++++++++++++++++-- 1 file changed, 890 insertions(+), 35 deletions(-) (limited to 'CS105MiniProject.ipynb') diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb index 603dbfc..97d8eb0 100644 --- a/CS105MiniProject.ipynb +++ b/CS105MiniProject.ipynb @@ -5,22 +5,319 @@ "execution_count": 1, "id": "daa13044", "metadata": { - "id": "daa13044", - "outputId": "4d440aaa-1ee7-4771-c526-f55e9458ca8a", + "ExecuteTime": { + "end_time": "2024-02-16T01:13:23.980165Z", + "start_time": "2024-02-16T01:13:23.265957Z" + }, "colab": { "base_uri": "https://localhost:8080/", "height": 614 }, - "ExecuteTime": { - "end_time": "2024-02-16T01:13:23.980165Z", - "start_time": "2024-02-16T01:13:23.265957Z" - } + "id": "daa13044", + "outputId": "4d440aaa-1ee7-4771-c526-f55e9458ca8a" }, "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartmentNorth District 4 bed 2 bathNoNaNNaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3 (room), 8 (hall), ~70 (building)NoNaNNaNNaNYes
\n

260 rows × 11 columns

\n
" + "text/html": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartmentNorth District 4 bed 2 bathNoNaNNaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3 (room), 8 (hall), ~70 (building)NoNaNNaNNaNYes
\n", + "

260 rows × 11 columns

\n", + "
" + ], + "text/plain": [ + " Timestamp What is your current class standing? \\\n", + "0 2/9/2024 20:12:14 Senior \n", + "1 2/9/2024 20:16:34 Junior \n", + "2 2/9/2024 20:18:55 Junior \n", + "3 2/9/2024 20:24:00 Senior \n", + "4 2/9/2024 20:26:16 Graduate \n", + ".. ... ... \n", + "255 2/14/2024 19:46:28 Junior \n", + "256 2/15/2024 0:28:38 NaN \n", + "257 2/15/2024 8:33:45 Senior \n", + "258 2/15/2024 16:10:40 Sophomore \n", + "259 2/15/2024 16:14:11 Sophomore \n", + "\n", + " What gender do you identify as? Who do you live with? \\\n", + "0 Male Neither \n", + "1 Female Both \n", + "2 Female Friends \n", + "3 Male Neither \n", + "4 Male Neither \n", + ".. ... ... \n", + "255 Male Friends \n", + "256 Male Family \n", + "257 Male Family \n", + "258 Female Family \n", + "259 Female Friends \n", + "\n", + " Do you currently live in a house, apartnment, or dorm? \\\n", + "0 House \n", + "1 Apartment \n", + "2 House \n", + "3 Apartment \n", + "4 Apartment \n", + ".. ... \n", + "255 House \n", + "256 Apartment \n", + "257 House \n", + "258 Apartment \n", + "259 Dorm \n", + "\n", + " How many people live in your household? Do you currently work? \\\n", + "0 6 Yes \n", + "1 4 No \n", + "2 4 No \n", + "3 1 No \n", + "4 1 Yes \n", + ".. ... ... \n", + "255 5 Yes \n", + "256 North District 4 bed 2 bath No \n", + "257 9 No \n", + "258 4 Yes \n", + "259 3 (room), 8 (hall), ~70 (building) No \n", + "\n", + " How many hours do you work per week on average? \\\n", + "0 5 - 10 \n", + "1 NaN \n", + "2 NaN \n", + "3 NaN \n", + "4 10 - 20 \n", + ".. ... \n", + "255 10 - 20 \n", + "256 NaN \n", + "257 1 - 5 \n", + "258 5 - 10 \n", + "259 NaN \n", + "\n", + " Do you work on or off campus? \\\n", + "0 Off-campus \n", + "1 NaN \n", + "2 NaN \n", + "3 NaN \n", + "4 Off-campus \n", + ".. ... \n", + "255 On-campus \n", + "256 NaN \n", + "257 Off-campus \n", + "258 On-campus \n", + "259 NaN \n", + "\n", + " Do you work in a department related to your major? \\\n", + "0 No \n", + "1 NaN \n", + "2 NaN \n", + "3 No \n", + "4 Yes \n", + ".. ... \n", + "255 No \n", + "256 NaN \n", + "257 No \n", + "258 No \n", + "259 NaN \n", + "\n", + " Do you have roommates that are part of your major? \n", + "0 No \n", + "1 Yes \n", + "2 No \n", + "3 No \n", + "4 No \n", + ".. ... \n", + "255 No \n", + "256 No \n", + "257 No \n", + "258 No \n", + "259 Yes \n", + "\n", + "[260 rows x 11 columns]" + ] }, "execution_count": 1, "metadata": {}, @@ -39,22 +336,282 @@ }, { "cell_type": "code", - "execution_count": 2, + "execution_count": 9, "id": "29889175", "metadata": { - "id": "29889175", "ExecuteTime": { "end_time": "2024-02-16T01:13:23.990972Z", "start_time": "2024-02-16T01:13:23.981386Z" - } + }, + "id": "29889175" }, "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 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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartment4NoNaNNaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3NoNaNNaNNaNYes
\n

260 rows × 11 columns

\n
" + "text/html": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
What is your age?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
023+NeitherHouse6Yes5 - 10Off-campusNoNo
120BothApartment4No0NaNNaNYes
223+FriendsHouse4No0NaNNaNNo
323+NeitherApartment1No0NaNNoNo
422NeitherApartment1Yes10 - 20Off-campusYesNo
..............................
25521FriendsHouse5Yes10 - 20On-campusNoNo
25621FamilyApartment4No0NaNNaNNo
25721FamilyHouse9No0Off-campusNoNo
25821FamilyApartment4Yes5 - 10On-campusNoNo
25918FriendsDorm3No0NaNNaNYes
\n", + "

260 rows × 9 columns

\n", + "
" + ], + "text/plain": [ + " What is your age? Who do you live with? \\\n", + "0 23+ Neither \n", + "1 20 Both \n", + "2 23+ Friends \n", + "3 23+ Neither \n", + "4 22 Neither \n", + ".. ... ... \n", + "255 21 Friends \n", + "256 21 Family \n", + "257 21 Family \n", + "258 21 Family \n", + "259 18 Friends \n", + "\n", + " Do you currently live in a house, apartnment, or dorm? \\\n", + "0 House \n", + "1 Apartment \n", + "2 House \n", + "3 Apartment \n", + "4 Apartment \n", + ".. ... \n", + "255 House \n", + "256 Apartment \n", + "257 House \n", + "258 Apartment \n", + "259 Dorm \n", + "\n", + " How many people live in your household? Do you currently work? \\\n", + "0 6 Yes \n", + "1 4 No \n", + "2 4 No \n", + "3 1 No \n", + "4 1 Yes \n", + ".. ... ... \n", + "255 5 Yes \n", + "256 4 No \n", + "257 9 No \n", + "258 4 Yes \n", + "259 3 No \n", + "\n", + " How many hours do you work per week on average? \\\n", + "0 5 - 10 \n", + "1 0 \n", + "2 0 \n", + "3 0 \n", + "4 10 - 20 \n", + ".. ... \n", + "255 10 - 20 \n", + "256 0 \n", + "257 0 \n", + "258 5 - 10 \n", + "259 0 \n", + "\n", + " Do you work on or off campus? \\\n", + "0 Off-campus \n", + "1 NaN \n", + "2 NaN \n", + "3 NaN \n", + "4 Off-campus \n", + ".. ... \n", + "255 On-campus \n", + "256 NaN \n", + "257 Off-campus \n", + "258 On-campus \n", + "259 NaN \n", + "\n", + " Do you work in a department related to your major? \\\n", + "0 No \n", + "1 NaN \n", + "2 NaN \n", + "3 No \n", + "4 Yes \n", + ".. ... \n", + "255 No \n", + "256 NaN \n", + "257 No \n", + "258 No \n", + "259 NaN \n", + "\n", + " Do you have roommates that are part of your major? \n", + "0 No \n", + "1 Yes \n", + "2 No \n", + "3 No \n", + "4 No \n", + ".. ... \n", + "255 No \n", + "256 No \n", + "257 No \n", + "258 No \n", + "259 Yes \n", + "\n", + "[260 rows x 9 columns]" + ] }, - "execution_count": 2, + "execution_count": 9, "metadata": {}, "output_type": "execute_result" } @@ -70,16 +627,323 @@ " .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" ] }, { "cell_type": "code", + "execution_count": 3, + "id": "de4448fd64205d85", + "metadata": { + "ExecuteTime": { + "end_time": "2024-02-16T01:13:24.001347Z", + "start_time": "2024-02-16T01:13:23.991767Z" + }, + "collapsed": false + }, "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
82/9/2024 22:02:49JuniorMaleFriendsHouse6Yes10 - 20On-campusNoNo
92/9/2024 22:08:43SeniorMaleFamilyHouse5Yes1 - 5On-campusNoNo
132/9/2024 22:15:13JuniorMaleFamilyApartment4Yes10 - 20Off-campusNoNo
....................................
2462/13/2024 19:37:02GraduateMaleFamilyHouse2Yes10 - 20On-campusYesNo
2472/13/2024 21:39:14SeniorMaleFriendsApartment3Yes20 - 40Off-campusNoYes
2522/14/2024 9:48:12JuniorMaleFamilyHouse5Yes20 - 40Off-campusNoNo
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
\n

77 rows × 11 columns

\n
" + "text/html": [ + "
\n", + "\n", + "\n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + " \n", + "
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
82/9/2024 22:02:49JuniorMaleFriendsHouse6Yes10 - 20On-campusNoNo
92/9/2024 22:08:43SeniorMaleFamilyHouse5Yes1 - 5On-campusNoNo
132/9/2024 22:15:13JuniorMaleFamilyApartment4Yes10 - 20Off-campusNoNo
....................................
2462/13/2024 19:37:02GraduateMaleFamilyHouse2Yes10 - 20On-campusYesNo
2472/13/2024 21:39:14SeniorMaleFriendsApartment3Yes20 - 40Off-campusNoYes
2522/14/2024 9:48:12JuniorMaleFamilyHouse5Yes20 - 40Off-campusNoNo
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
\n", + "

77 rows × 11 columns

\n", + "
" + ], + "text/plain": [ + " Timestamp What is your current class standing? \\\n", + "0 2/9/2024 20:12:14 Senior \n", + "4 2/9/2024 20:26:16 Graduate \n", + "8 2/9/2024 22:02:49 Junior \n", + "9 2/9/2024 22:08:43 Senior \n", + "13 2/9/2024 22:15:13 Junior \n", + ".. ... ... \n", + "246 2/13/2024 19:37:02 Graduate \n", + "247 2/13/2024 21:39:14 Senior \n", + "252 2/14/2024 9:48:12 Junior \n", + "255 2/14/2024 19:46:28 Junior \n", + "258 2/15/2024 16:10:40 Sophomore \n", + "\n", + " What gender do you identify as? Who do you live with? \\\n", + "0 Male Neither \n", + "4 Male Neither \n", + "8 Male Friends \n", + "9 Male Family \n", + "13 Male Family \n", + ".. ... ... \n", + "246 Male Family \n", + "247 Male Friends \n", + "252 Male Family \n", + "255 Male Friends \n", + "258 Female Family \n", + "\n", + " Do you currently live in a house, apartnment, or dorm? \\\n", + "0 House \n", + "4 Apartment \n", + "8 House \n", + "9 House \n", + "13 Apartment \n", + ".. ... \n", + "246 House \n", + "247 Apartment \n", + "252 House \n", + "255 House \n", + "258 Apartment \n", + "\n", + " How many people live in your household? Do you currently work? \\\n", + "0 6 Yes \n", + "4 1 Yes \n", + "8 6 Yes \n", + "9 5 Yes \n", + "13 4 Yes \n", + ".. ... ... \n", + "246 2 Yes \n", + "247 3 Yes \n", + "252 5 Yes \n", + "255 5 Yes \n", + "258 4 Yes \n", + "\n", + " How many hours do you work per week on average? \\\n", + "0 5 - 10 \n", + "4 10 - 20 \n", + "8 10 - 20 \n", + "9 1 - 5 \n", + "13 10 - 20 \n", + ".. ... \n", + "246 10 - 20 \n", + "247 20 - 40 \n", + "252 20 - 40 \n", + "255 10 - 20 \n", + "258 5 - 10 \n", + "\n", + " Do you work on or off campus? \\\n", + "0 Off-campus \n", + "4 Off-campus \n", + "8 On-campus \n", + "9 On-campus \n", + "13 Off-campus \n", + ".. ... \n", + "246 On-campus \n", + "247 Off-campus \n", + "252 Off-campus \n", + "255 On-campus \n", + "258 On-campus \n", + "\n", + " Do you work in a department related to your major? \\\n", + "0 No \n", + "4 Yes \n", + "8 No \n", + "9 No \n", + "13 No \n", + ".. ... \n", + "246 Yes \n", + "247 No \n", + "252 No \n", + "255 No \n", + "258 No \n", + "\n", + " Do you have roommates that are part of your major? \n", + "0 No \n", + "4 No \n", + "8 No \n", + "9 No \n", + "13 No \n", + ".. ... \n", + "246 No \n", + "247 Yes \n", + "252 No \n", + "255 No \n", + "258 No \n", + "\n", + "[77 rows x 11 columns]" + ] }, "execution_count": 3, "metadata": {}, @@ -92,33 +956,27 @@ "# Not working DataFrame\n", "nw_df = df[df['Do you currently work?'] == 'No']\n", "w_df" - ], - "metadata": { - "collapsed": false, - "ExecuteTime": { - "end_time": "2024-02-16T01:13:24.001347Z", - "start_time": "2024-02-16T01:13:23.991767Z" - } - }, - "id": "de4448fd64205d85", - "execution_count": 3 + ] }, { "cell_type": "code", - "outputs": [], - "source": [], + "execution_count": 3, + "id": "a9df972e44277de7", "metadata": { - "collapsed": false, "ExecuteTime": { "end_time": "2024-02-16T01:13:24.004250Z", "start_time": "2024-02-16T01:13:24.002783Z" - } + }, + "collapsed": false }, - "id": "a9df972e44277de7", - "execution_count": 3 + "outputs": [], + "source": [] } ], "metadata": { + "colab": { + "provenance": [] + }, "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", @@ -135,9 +993,6 @@ "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.5" - }, - "colab": { - "provenance": [] } }, "nbformat": 4, -- cgit v1.2.3 From 314780c72bd6d301292792d332f56a2a678c377b Mon Sep 17 00:00:00 2001 From: Anshul Gupta Date: Thu, 15 Feb 2024 17:22:11 -0800 Subject: Fixes 'Who do you live with?' --- CS105MiniProject.ipynb | 905 ++----------------------------------------------- 1 file changed, 26 insertions(+), 879 deletions(-) (limited to 'CS105MiniProject.ipynb') diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb index 97d8eb0..c141cf1 100644 --- a/CS105MiniProject.ipynb +++ b/CS105MiniProject.ipynb @@ -5,319 +5,22 @@ "execution_count": 1, "id": "daa13044", "metadata": { - "ExecuteTime": { - "end_time": "2024-02-16T01:13:23.980165Z", - "start_time": "2024-02-16T01:13:23.265957Z" - }, "colab": { "base_uri": "https://localhost:8080/", "height": 614 }, "id": "daa13044", - "outputId": "4d440aaa-1ee7-4771-c526-f55e9458ca8a" + "outputId": "4d440aaa-1ee7-4771-c526-f55e9458ca8a", + "ExecuteTime": { + "end_time": "2024-02-16T01:21:49.702719Z", + "start_time": "2024-02-16T01:21:48.928305Z" + } }, "outputs": [ { "data": { - "text/html": [ - "
\n", - "\n", - "\n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - "
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartmentNorth District 4 bed 2 bathNoNaNNaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3 (room), 8 (hall), ~70 (building)NoNaNNaNNaNYes
\n", - "

260 rows × 11 columns

\n", - "
" - ], - "text/plain": [ - " Timestamp What is your current class standing? \\\n", - "0 2/9/2024 20:12:14 Senior \n", - "1 2/9/2024 20:16:34 Junior \n", - "2 2/9/2024 20:18:55 Junior \n", - "3 2/9/2024 20:24:00 Senior \n", - "4 2/9/2024 20:26:16 Graduate \n", - ".. ... ... \n", - "255 2/14/2024 19:46:28 Junior \n", - "256 2/15/2024 0:28:38 NaN \n", - "257 2/15/2024 8:33:45 Senior \n", - "258 2/15/2024 16:10:40 Sophomore \n", - "259 2/15/2024 16:14:11 Sophomore \n", - "\n", - " What gender do you identify as? Who do you live with? \\\n", - "0 Male Neither \n", - "1 Female Both \n", - "2 Female Friends \n", - "3 Male Neither \n", - "4 Male Neither \n", - ".. ... ... \n", - "255 Male Friends \n", - "256 Male Family \n", - "257 Male Family \n", - "258 Female Family \n", - "259 Female Friends \n", - "\n", - " Do you currently live in a house, apartnment, or dorm? \\\n", - "0 House \n", - "1 Apartment \n", - "2 House \n", - "3 Apartment \n", - "4 Apartment \n", - ".. ... \n", - "255 House \n", - "256 Apartment \n", - "257 House \n", - "258 Apartment \n", - "259 Dorm \n", - "\n", - " How many people live in your household? Do you currently work? \\\n", - "0 6 Yes \n", - "1 4 No \n", - "2 4 No \n", - "3 1 No \n", - "4 1 Yes \n", - ".. ... ... \n", - "255 5 Yes \n", - "256 North District 4 bed 2 bath No \n", - "257 9 No \n", - "258 4 Yes \n", - "259 3 (room), 8 (hall), ~70 (building) No \n", - "\n", - " How many hours do you work per week on average? \\\n", - "0 5 - 10 \n", - "1 NaN \n", - "2 NaN \n", - "3 NaN \n", - "4 10 - 20 \n", - ".. ... \n", - "255 10 - 20 \n", - "256 NaN \n", - "257 1 - 5 \n", - "258 5 - 10 \n", - "259 NaN \n", - "\n", - " Do you work on or off campus? \\\n", - "0 Off-campus \n", - "1 NaN \n", - "2 NaN \n", - "3 NaN \n", - "4 Off-campus \n", - ".. ... \n", - "255 On-campus \n", - "256 NaN \n", - "257 Off-campus \n", - "258 On-campus \n", - "259 NaN \n", - "\n", - " Do you work in a department related to your major? \\\n", - "0 No \n", - "1 NaN \n", - "2 NaN \n", - "3 No \n", - "4 Yes \n", - ".. ... \n", - "255 No \n", - "256 NaN \n", - "257 No \n", - "258 No \n", - "259 NaN \n", - "\n", - " Do you have roommates that are part of your major? \n", - "0 No \n", - "1 Yes \n", - "2 No \n", - "3 No \n", - "4 No \n", - ".. ... \n", - "255 No \n", - "256 No \n", - "257 No \n", - "258 No \n", - "259 Yes \n", - "\n", - "[260 rows x 11 columns]" - ] + "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4NoNaNNaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4NoNaNNaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1NoNaNNaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartmentNorth District 4 bed 2 bathNoNaNNaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No1 - 5Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3 (room), 8 (hall), ~70 (building)NoNaNNaNNaNYes
\n

260 rows × 11 columns

\n
" }, "execution_count": 1, "metadata": {}, @@ -336,282 +39,22 @@ }, { "cell_type": "code", - "execution_count": 9, + "execution_count": 2, "id": "29889175", "metadata": { + "id": "29889175", "ExecuteTime": { - "end_time": "2024-02-16T01:13:23.990972Z", - "start_time": "2024-02-16T01:13:23.981386Z" - }, - "id": "29889175" + "end_time": "2024-02-16T01:21:49.714653Z", + "start_time": "2024-02-16T01:21:49.704177Z" + } }, "outputs": [ { "data": { - "text/html": [ - "
\n", - "\n", - "\n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - "
What is your age?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
023+NeitherHouse6Yes5 - 10Off-campusNoNo
120BothApartment4No0NaNNaNYes
223+FriendsHouse4No0NaNNaNNo
323+NeitherApartment1No0NaNNoNo
422NeitherApartment1Yes10 - 20Off-campusYesNo
..............................
25521FriendsHouse5Yes10 - 20On-campusNoNo
25621FamilyApartment4No0NaNNaNNo
25721FamilyHouse9No0Off-campusNoNo
25821FamilyApartment4Yes5 - 10On-campusNoNo
25918FriendsDorm3No0NaNNaNYes
\n", - "

260 rows × 9 columns

\n", - "
" - ], - "text/plain": [ - " What is your age? Who do you live with? \\\n", - "0 23+ Neither \n", - "1 20 Both \n", - "2 23+ Friends \n", - "3 23+ Neither \n", - "4 22 Neither \n", - ".. ... ... \n", - "255 21 Friends \n", - "256 21 Family \n", - "257 21 Family \n", - "258 21 Family \n", - "259 18 Friends \n", - "\n", - " Do you currently live in a house, apartnment, or dorm? \\\n", - "0 House \n", - "1 Apartment \n", - "2 House \n", - "3 Apartment \n", - "4 Apartment \n", - ".. ... \n", - "255 House \n", - "256 Apartment \n", - "257 House \n", - "258 Apartment \n", - "259 Dorm \n", - "\n", - " How many people live in your household? Do you currently work? \\\n", - "0 6 Yes \n", - "1 4 No \n", - "2 4 No \n", - "3 1 No \n", - "4 1 Yes \n", - ".. ... ... \n", - "255 5 Yes \n", - "256 4 No \n", - "257 9 No \n", - "258 4 Yes \n", - "259 3 No \n", - "\n", - " How many hours do you work per week on average? \\\n", - "0 5 - 10 \n", - "1 0 \n", - "2 0 \n", - "3 0 \n", - "4 10 - 20 \n", - ".. ... \n", - "255 10 - 20 \n", - "256 0 \n", - "257 0 \n", - "258 5 - 10 \n", - "259 0 \n", - "\n", - " Do you work on or off campus? \\\n", - "0 Off-campus \n", - "1 NaN \n", - "2 NaN \n", - "3 NaN \n", - "4 Off-campus \n", - ".. ... \n", - "255 On-campus \n", - "256 NaN \n", - "257 Off-campus \n", - "258 On-campus \n", - "259 NaN \n", - "\n", - " Do you work in a department related to your major? \\\n", - "0 No \n", - "1 NaN \n", - "2 NaN \n", - "3 No \n", - "4 Yes \n", - ".. ... \n", - "255 No \n", - "256 NaN \n", - "257 No \n", - "258 No \n", - "259 NaN \n", - "\n", - " Do you have roommates that are part of your major? \n", - "0 No \n", - "1 Yes \n", - "2 No \n", - "3 No \n", - "4 No \n", - ".. ... \n", - "255 No \n", - "256 No \n", - "257 No \n", - "258 No \n", - "259 Yes \n", - "\n", - "[260 rows x 9 columns]" - ] + "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 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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4No0NaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4No0NaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1No0NaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartment4No0NaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No0Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3No0NaNNaNYes
\n

260 rows × 11 columns

\n
" }, - "execution_count": 9, + "execution_count": 2, "metadata": {}, "output_type": "execute_result" } @@ -628,6 +71,7 @@ " .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" ] }, @@ -636,314 +80,17 @@ "execution_count": 3, "id": "de4448fd64205d85", "metadata": { + "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T01:13:24.001347Z", - "start_time": "2024-02-16T01:13:23.991767Z" - }, - "collapsed": false + "end_time": "2024-02-16T01:21:49.723810Z", + "start_time": "2024-02-16T01:21:49.715485Z" + } }, "outputs": [ { "data": { - "text/html": [ - "
\n", - "\n", - "\n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - " \n", - "
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
82/9/2024 22:02:49JuniorMaleFriendsHouse6Yes10 - 20On-campusNoNo
92/9/2024 22:08:43SeniorMaleFamilyHouse5Yes1 - 5On-campusNoNo
132/9/2024 22:15:13JuniorMaleFamilyApartment4Yes10 - 20Off-campusNoNo
....................................
2462/13/2024 19:37:02GraduateMaleFamilyHouse2Yes10 - 20On-campusYesNo
2472/13/2024 21:39:14SeniorMaleFriendsApartment3Yes20 - 40Off-campusNoYes
2522/14/2024 9:48:12JuniorMaleFamilyHouse5Yes20 - 40Off-campusNoNo
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
\n", - "

77 rows × 11 columns

\n", - "
" - ], - "text/plain": [ - " Timestamp What is your current class standing? \\\n", - "0 2/9/2024 20:12:14 Senior \n", - "4 2/9/2024 20:26:16 Graduate \n", - "8 2/9/2024 22:02:49 Junior \n", - "9 2/9/2024 22:08:43 Senior \n", - "13 2/9/2024 22:15:13 Junior \n", - ".. ... ... \n", - "246 2/13/2024 19:37:02 Graduate \n", - "247 2/13/2024 21:39:14 Senior \n", - "252 2/14/2024 9:48:12 Junior \n", - "255 2/14/2024 19:46:28 Junior \n", - "258 2/15/2024 16:10:40 Sophomore \n", - "\n", - " What gender do you identify as? Who do you live with? \\\n", - "0 Male Neither \n", - "4 Male Neither \n", - "8 Male Friends \n", - "9 Male Family \n", - "13 Male Family \n", - ".. ... ... \n", - "246 Male Family \n", - "247 Male Friends \n", - "252 Male Family \n", - "255 Male Friends \n", - "258 Female Family \n", - "\n", - " Do you currently live in a house, apartnment, or dorm? \\\n", - "0 House \n", - "4 Apartment \n", - "8 House \n", - "9 House \n", - "13 Apartment \n", - ".. ... \n", - "246 House \n", - "247 Apartment \n", - "252 House \n", - "255 House \n", - "258 Apartment \n", - "\n", - " How many people live in your household? Do you currently work? \\\n", - "0 6 Yes \n", - "4 1 Yes \n", - "8 6 Yes \n", - "9 5 Yes \n", - "13 4 Yes \n", - ".. ... ... \n", - "246 2 Yes \n", - "247 3 Yes \n", - "252 5 Yes \n", - "255 5 Yes \n", - "258 4 Yes \n", - "\n", - " How many hours do you work per week on average? \\\n", - "0 5 - 10 \n", - "4 10 - 20 \n", - "8 10 - 20 \n", - "9 1 - 5 \n", - "13 10 - 20 \n", - ".. ... \n", - "246 10 - 20 \n", - "247 20 - 40 \n", - "252 20 - 40 \n", - "255 10 - 20 \n", - "258 5 - 10 \n", - "\n", - " Do you work on or off campus? \\\n", - "0 Off-campus \n", - "4 Off-campus \n", - "8 On-campus \n", - "9 On-campus \n", - "13 Off-campus \n", - ".. ... \n", - "246 On-campus \n", - "247 Off-campus \n", - "252 Off-campus \n", - "255 On-campus \n", - "258 On-campus \n", - "\n", - " Do you work in a department related to your major? \\\n", - "0 No \n", - "4 Yes \n", - "8 No \n", - "9 No \n", - "13 No \n", - ".. ... \n", - "246 Yes \n", - "247 No \n", - "252 No \n", - "255 No \n", - "258 No \n", - "\n", - " Do you have roommates that are part of your major? \n", - "0 No \n", - "4 No \n", - "8 No \n", - "9 No \n", - "13 No \n", - ".. ... \n", - "246 No \n", - "247 Yes \n", - "252 No \n", - "255 No \n", - "258 No \n", - "\n", - "[77 rows x 11 columns]" - ] + "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
82/9/2024 22:02:49JuniorMaleFriendsHouse6Yes10 - 20On-campusNoNo
92/9/2024 22:08:43SeniorMaleFamilyHouse5Yes1 - 5On-campusNoNo
132/9/2024 22:15:13JuniorMaleFamilyApartment4Yes10 - 20Off-campusNoNo
....................................
2462/13/2024 19:37:02GraduateMaleFamilyHouse2Yes10 - 20On-campusYesNo
2472/13/2024 21:39:14SeniorMaleFriendsApartment3Yes20 - 40Off-campusNoYes
2522/14/2024 9:48:12JuniorMaleFamilyHouse5Yes20 - 40Off-campusNoNo
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
\n

77 rows × 11 columns

\n
" }, "execution_count": 3, "metadata": {}, @@ -963,11 +110,11 @@ "execution_count": 3, "id": "a9df972e44277de7", "metadata": { + "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T01:13:24.004250Z", - "start_time": "2024-02-16T01:13:24.002783Z" - }, - "collapsed": false + "end_time": "2024-02-16T01:21:49.726718Z", + "start_time": "2024-02-16T01:21:49.724916Z" + } }, "outputs": [], "source": [] -- cgit v1.2.3 From 2747e940cfd89f30d90d15d1fc1c3029afd0671e Mon Sep 17 00:00:00 2001 From: Anshul Gupta Date: Thu, 15 Feb 2024 17:29:22 -0800 Subject: Fixes `Do you work in a department ...` --- CS105MiniProject.ipynb | 51 ++++++++++++++++++++++++++++++++++++++------------ 1 file changed, 39 insertions(+), 12 deletions(-) (limited to 'CS105MiniProject.ipynb') diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb index c141cf1..2e6ac77 100644 --- a/CS105MiniProject.ipynb +++ b/CS105MiniProject.ipynb @@ -12,8 +12,8 @@ "id": "daa13044", "outputId": "4d440aaa-1ee7-4771-c526-f55e9458ca8a", "ExecuteTime": { - "end_time": "2024-02-16T01:21:49.702719Z", - "start_time": "2024-02-16T01:21:48.928305Z" + "end_time": "2024-02-16T01:29:14.937392Z", + "start_time": "2024-02-16T01:29:14.276865Z" } }, "outputs": [ @@ -44,15 +44,15 @@ "metadata": { "id": "29889175", "ExecuteTime": { - "end_time": "2024-02-16T01:21:49.714653Z", - "start_time": "2024-02-16T01:21:49.704177Z" + "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 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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4No0NaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4No0NaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1No0NaNNoNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartment4No0NaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No0Off-campusNoNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3No0NaNNaNYes
\n

260 rows × 11 columns

\n
" + "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
02/9/2024 20:12:14SeniorMaleNeitherHouse6Yes5 - 10Off-campusNoNo
12/9/2024 20:16:34JuniorFemaleBothApartment4No0NaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4No0NaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1No0NaNNaNNo
42/9/2024 20:26:16GraduateMaleNeitherApartment1Yes10 - 20Off-campusYesNo
....................................
2552/14/2024 19:46:28JuniorMaleFriendsHouse5Yes10 - 20On-campusNoNo
2562/15/2024 0:28:38NaNMaleFamilyApartment4No0NaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No0Off-campusNaNNo
2582/15/2024 16:10:40SophomoreFemaleFamilyApartment4Yes5 - 10On-campusNoNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3No0NaNNaNYes
\n

260 rows × 11 columns

\n
" }, "execution_count": 2, "metadata": {}, @@ -72,6 +72,7 @@ " .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" ] }, @@ -82,8 +83,8 @@ "metadata": { "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T01:21:49.723810Z", - "start_time": "2024-02-16T01:21:49.715485Z" + "end_time": "2024-02-16T01:29:14.960720Z", + "start_time": "2024-02-16T01:29:14.951Z" } }, "outputs": [ @@ -107,17 +108,43 @@ }, { "cell_type": "code", - "execution_count": 3, + "execution_count": 4, "id": "a9df972e44277de7", "metadata": { "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T01:21:49.726718Z", - "start_time": "2024-02-16T01:21:49.724916Z" + "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": "
\n\n\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
TimestampWhat is your current class standing?What gender do you identify as?Who do you live with?Do you currently live in a house, apartnment, or dorm?How many people live in your household?Do you currently work?How many hours do you work per week on average?Do you work on or off campus?Do you work in a department related to your major?Do you have roommates that are part of your major?
12/9/2024 20:16:34JuniorFemaleBothApartment4No0NaNNaNYes
22/9/2024 20:18:55JuniorFemaleFriendsHouse4No0NaNNaNNo
32/9/2024 20:24:00SeniorMaleNeitherApartment1No0NaNNaNNo
52/9/2024 20:45:09JuniorPrefer not to sayBothApartment4No0NaNNaNNo
62/9/2024 21:55:59SophomoreFemaleFriendsApartment4No0NaNNaNNo
....................................
2532/14/2024 13:45:45SeniorFemaleFamilyHouse6No0NaNNaNNo
2542/14/2024 16:26:06JuniorMaleFamilyHouse5No0NaNNaNYes
2562/15/2024 0:28:38NaNMaleFamilyApartment4No0NaNNaNNo
2572/15/2024 8:33:45SeniorMaleFamilyHouse9No0Off-campusNaNNo
2592/15/2024 16:14:11SophomoreFemaleFriendsDorm3No0NaNNaNYes
\n

176 rows × 11 columns

\n
" + }, + "execution_count": 4, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "nw_df" + ] + }, + { + "cell_type": "code", "outputs": [], - "source": [] + "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": { -- cgit v1.2.3 From a7f297c510b7dbe085fb04eeeca004e736addbf3 Mon Sep 17 00:00:00 2001 From: Anshul Gupta Date: Fri, 16 Feb 2024 11:12:27 -0800 Subject: Fixes typo --- CS105MiniProject.ipynb | 22 +++++++++++----------- 1 file changed, 11 insertions(+), 11 deletions(-) (limited to 'CS105MiniProject.ipynb') diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb index 2e6ac77..5019ea7 100644 --- a/CS105MiniProject.ipynb +++ b/CS105MiniProject.ipynb @@ -12,8 +12,8 @@ "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" + "end_time": "2024-02-16T19:08:18.600597Z", + "start_time": "2024-02-16T19:08:17.919389Z" } }, "outputs": [ @@ -44,8 +44,8 @@ "metadata": { "id": "29889175", "ExecuteTime": { - "end_time": "2024-02-16T01:29:14.950257Z", - "start_time": "2024-02-16T01:29:14.938720Z" + "end_time": "2024-02-16T19:08:18.614279Z", + "start_time": "2024-02-16T19:08:18.603114Z" } }, "outputs": [ @@ -65,7 +65,7 @@ " .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('3 excluding me', '4')\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", @@ -83,8 +83,8 @@ "metadata": { "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T01:29:14.960720Z", - "start_time": "2024-02-16T01:29:14.951Z" + "end_time": "2024-02-16T19:08:18.626145Z", + "start_time": "2024-02-16T19:08:18.615598Z" } }, "outputs": [ @@ -113,8 +113,8 @@ "metadata": { "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T01:29:14.970741Z", - "start_time": "2024-02-16T01:29:14.962311Z" + "end_time": "2024-02-16T19:08:18.636705Z", + "start_time": "2024-02-16T19:08:18.627167Z" } }, "outputs": [ @@ -139,8 +139,8 @@ "metadata": { "collapsed": false, "ExecuteTime": { - "end_time": "2024-02-16T01:29:14.974486Z", - "start_time": "2024-02-16T01:29:14.972680Z" + "end_time": "2024-02-16T19:08:18.640828Z", + "start_time": "2024-02-16T19:08:18.639236Z" } }, "id": "bfa40c9e9693481d", -- cgit v1.2.3