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