{ "cells": [ { "cell_type": "code", "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" }, "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]" ] }, "execution_count": 1, "metadata": {}, "output_type": "execute_result" } ], "source": [ "%matplotlib inline\n", "import pandas as pd\n", "import numpy as np\n", "\n", "df = pd.read_csv(\"data.csv\")\n", "df = df.iloc[:, [0, 2, 5, 7, 8, 9, 58, 59, 60, 61, 26]]\n", "df" ] }, { "cell_type": "code", "execution_count": 9, "id": "29889175", "metadata": { "ExecuteTime": { "end_time": "2024-02-16T01:13:23.990972Z", "start_time": "2024-02-16T01:13:23.981386Z" }, "id": "29889175" }, "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]" ] }, "execution_count": 9, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df['How many people live in your household?'] = (df['How many people live in your household?']\n", " .fillna(0)\n", " .replace('4 in total', '4')\n", " .replace('4 (Including me)', '4')\n", " .replace('at school 4 including me ', '4')\n", " .replace('3 excluding me', '3')\n", " .replace('5 including me', '5')\n", " .replace('North District 4 bed 2 bath', '4')\n", " .replace('3 (room), 8 (hall), ~70 (building)', '3')\n", " .astype(int))\n", "df.loc[df['Do you currently work?'] == 'No', 'How many hours do you work per week on average?'] = 0\n", "df" ] }, { "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/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": {}, "output_type": "execute_result" } ], "source": [ "# Working DataFrame\n", "w_df = df[df['Do you currently work?'] == 'Yes']\n", "# Not working DataFrame\n", "nw_df = df[df['Do you currently work?'] == 'No']\n", "w_df" ] }, { "cell_type": "code", "execution_count": 3, "id": "a9df972e44277de7", "metadata": { "ExecuteTime": { "end_time": "2024-02-16T01:13:24.004250Z", "start_time": "2024-02-16T01:13:24.002783Z" }, "collapsed": false }, "outputs": [], "source": [] } ], "metadata": { "colab": { "provenance": [] }, "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.11.5" } }, "nbformat": 4, "nbformat_minor": 5 }