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