diff options
author | 2024-02-15 16:19:31 -0800 | |
---|---|---|
committer | 2024-02-15 16:19:31 -0800 | |
commit | db6f314d338b23d9c62d45f1d9ceaadd82562fbb (patch) | |
tree | b271f4f361364f8f8049532601d7c9a28102ac9f /CS105MiniProject.ipynb | |
parent | de23b77b9b17663761e10e04620bac91af567ef4 (diff) | |
download | CS105MiniProject-db6f314d338b23d9c62d45f1d9ceaadd82562fbb.tar.gz CS105MiniProject-db6f314d338b23d9c62d45f1d9ceaadd82562fbb.tar.zst CS105MiniProject-db6f314d338b23d9c62d45f1d9ceaadd82562fbb.zip |
Adds notebook
Diffstat (limited to 'CS105MiniProject.ipynb')
-rw-r--r-- | CS105MiniProject.ipynb | 422 |
1 files changed, 422 insertions, 0 deletions
diff --git a/CS105MiniProject.ipynb b/CS105MiniProject.ipynb new file mode 100644 index 0000000..495a644 --- /dev/null +++ b/CS105MiniProject.ipynb @@ -0,0 +1,422 @@ +{ + "cells": [ + { + "cell_type": "code", + "execution_count": null, + "id": "daa13044", + "metadata": { + "id": "daa13044", + "outputId": "4d440aaa-1ee7-4771-c526-f55e9458ca8a", + "colab": { + "base_uri": "https://localhost:8080/", + "height": 614 + } + }, + "outputs": [ + { + "output_type": "execute_result", + "data": { + "text/plain": [ + " Timestamp What gender do you identify as? \\\n", + "0 2/9/2024 20:12:14 Male \n", + "1 2/9/2024 20:16:34 Female \n", + "2 2/9/2024 20:18:55 Female \n", + "3 2/9/2024 20:24:00 Male \n", + "4 2/9/2024 20:26:16 Male \n", + ".. ... ... \n", + "255 2/14/2024 19:46:28 Male \n", + "256 2/15/2024 0:28:38 Male \n", + "257 2/15/2024 8:33:45 Male \n", + "258 2/15/2024 16:10:40 Female \n", + "259 2/15/2024 16:14:11 Female \n", + "\n", + " Who do you live with? How many people live in your household? \n", + "0 Neither 6 \n", + "1 Both 4 \n", + "2 Friends 4 \n", + "3 Neither 1 \n", + "4 Neither 1 \n", + ".. ... ... \n", + "255 Friends 5 \n", + "256 Family North District 4 bed 2 bath \n", + "257 Family 9 \n", + "258 Family 4 \n", + "259 Friends 3 (room), 8 (hall), ~70 (building) \n", + "\n", + "[260 rows x 4 columns]" + ], + "text/html": [ + "\n", + " <div id=\"df-a860243d-1475-4912-ac7f-83183a2056d2\" class=\"colab-df-container\">\n", + " <div>\n", + "<style scoped>\n", + " .dataframe tbody tr th:only-of-type {\n", + " vertical-align: middle;\n", + " }\n", + "\n", + " .dataframe tbody tr th {\n", + " vertical-align: top;\n", + " }\n", + "\n", + " .dataframe thead th {\n", + " text-align: right;\n", + " }\n", + "</style>\n", + "<table border=\"1\" class=\"dataframe\">\n", + " <thead>\n", + " <tr style=\"text-align: right;\">\n", + " <th></th>\n", + " <th>Timestamp</th>\n", + " <th>What gender do you identify as?</th>\n", + " <th>Who do you live with?</th>\n", + " <th>How many people live in your household?</th>\n", + " </tr>\n", + " </thead>\n", + " <tbody>\n", + " <tr>\n", + " <th>0</th>\n", + " <td>2/9/2024 20:12:14</td>\n", + " <td>Male</td>\n", + " <td>Neither</td>\n", + " <td>6</td>\n", + " </tr>\n", + " <tr>\n", + " <th>1</th>\n", + " <td>2/9/2024 20:16:34</td>\n", + " <td>Female</td>\n", + " <td>Both</td>\n", + " <td>4</td>\n", + " </tr>\n", + " <tr>\n", + " <th>2</th>\n", + " <td>2/9/2024 20:18:55</td>\n", + " <td>Female</td>\n", + " <td>Friends</td>\n", + " <td>4</td>\n", + " </tr>\n", + " <tr>\n", + " <th>3</th>\n", + " <td>2/9/2024 20:24:00</td>\n", + " <td>Male</td>\n", + " <td>Neither</td>\n", + " <td>1</td>\n", + " </tr>\n", + " <tr>\n", + " <th>4</th>\n", + " <td>2/9/2024 20:26:16</td>\n", + " <td>Male</td>\n", + " <td>Neither</td>\n", + " <td>1</td>\n", + " </tr>\n", + " <tr>\n", + " <th>...</th>\n", + " <td>...</td>\n", + " <td>...</td>\n", + " <td>...</td>\n", + " <td>...</td>\n", + " </tr>\n", + " <tr>\n", + " <th>255</th>\n", + " <td>2/14/2024 19:46:28</td>\n", + " <td>Male</td>\n", + " <td>Friends</td>\n", + " <td>5</td>\n", + " </tr>\n", + " <tr>\n", + " <th>256</th>\n", + " <td>2/15/2024 0:28:38</td>\n", + " <td>Male</td>\n", + " <td>Family</td>\n", + " <td>North District 4 bed 2 bath</td>\n", + " </tr>\n", + " <tr>\n", + " <th>257</th>\n", + " <td>2/15/2024 8:33:45</td>\n", + " <td>Male</td>\n", + " <td>Family</td>\n", + " <td>9</td>\n", + " </tr>\n", + " <tr>\n", + " <th>258</th>\n", + " <td>2/15/2024 16:10:40</td>\n", + " <td>Female</td>\n", + " <td>Family</td>\n", + " <td>4</td>\n", + " </tr>\n", + " <tr>\n", + " <th>259</th>\n", + " <td>2/15/2024 16:14:11</td>\n", + " <td>Female</td>\n", + " <td>Friends</td>\n", + " <td>3 (room), 8 (hall), ~70 (building)</td>\n", + " </tr>\n", + " </tbody>\n", + "</table>\n", + "<p>260 rows × 4 columns</p>\n", + "</div>\n", + " <div class=\"colab-df-buttons\">\n", + "\n", + " <div class=\"colab-df-container\">\n", + " <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a860243d-1475-4912-ac7f-83183a2056d2')\"\n", + " title=\"Convert this dataframe to an interactive table.\"\n", + " style=\"display:none;\">\n", + "\n", + " <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n", + " <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n", + " </svg>\n", + " </button>\n", + "\n", + " <style>\n", + " .colab-df-container {\n", + " display:flex;\n", + " gap: 12px;\n", + " }\n", + "\n", + " .colab-df-convert {\n", + " background-color: #E8F0FE;\n", + " border: none;\n", + " border-radius: 50%;\n", + " cursor: pointer;\n", + " display: none;\n", + " fill: #1967D2;\n", + " height: 32px;\n", + " padding: 0 0 0 0;\n", + " width: 32px;\n", + " }\n", + "\n", + " .colab-df-convert:hover {\n", + " background-color: #E2EBFA;\n", + " box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n", + " fill: #174EA6;\n", + " }\n", + "\n", + " .colab-df-buttons div {\n", + " margin-bottom: 4px;\n", + " }\n", + "\n", + " [theme=dark] .colab-df-convert {\n", + " background-color: #3B4455;\n", + " fill: #D2E3FC;\n", + " }\n", + "\n", + " [theme=dark] .colab-df-convert:hover {\n", + " background-color: #434B5C;\n", + " box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n", + " filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n", + " fill: #FFFFFF;\n", + " }\n", + " </style>\n", + "\n", + " <script>\n", + " const buttonEl =\n", + " document.querySelector('#df-a860243d-1475-4912-ac7f-83183a2056d2 button.colab-df-convert');\n", + " buttonEl.style.display =\n", + " google.colab.kernel.accessAllowed ? 'block' : 'none';\n", + "\n", + " async function convertToInteractive(key) {\n", + " const element = document.querySelector('#df-a860243d-1475-4912-ac7f-83183a2056d2');\n", + " const dataTable =\n", + " await google.colab.kernel.invokeFunction('convertToInteractive',\n", + " [key], {});\n", + " if (!dataTable) return;\n", + "\n", + " const docLinkHtml = 'Like what you see? Visit the ' +\n", + " '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n", + " + ' to learn more about interactive tables.';\n", + " element.innerHTML = '';\n", + " dataTable['output_type'] = 'display_data';\n", + " await google.colab.output.renderOutput(dataTable, element);\n", + " const docLink = document.createElement('div');\n", + " docLink.innerHTML = docLinkHtml;\n", + " element.appendChild(docLink);\n", + " }\n", + " </script>\n", + " </div>\n", + "\n", + "\n", + "<div id=\"df-1a09fda8-d71a-4c48-b8e2-b45a93914e4e\">\n", + " <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1a09fda8-d71a-4c48-b8e2-b45a93914e4e')\"\n", + " title=\"Suggest charts\"\n", + " style=\"display:none;\">\n", + "\n", + "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n", + " width=\"24px\">\n", + " <g>\n", + " <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n", + " </g>\n", + "</svg>\n", + " </button>\n", + "\n", + "<style>\n", + " .colab-df-quickchart {\n", + " --bg-color: #E8F0FE;\n", + " --fill-color: #1967D2;\n", + " --hover-bg-color: #E2EBFA;\n", + " --hover-fill-color: #174EA6;\n", + " --disabled-fill-color: #AAA;\n", + " --disabled-bg-color: #DDD;\n", + " }\n", + "\n", + " [theme=dark] .colab-df-quickchart {\n", + " --bg-color: #3B4455;\n", + " --fill-color: #D2E3FC;\n", + " --hover-bg-color: #434B5C;\n", + " --hover-fill-color: #FFFFFF;\n", + " --disabled-bg-color: #3B4455;\n", + " --disabled-fill-color: #666;\n", + " }\n", + "\n", + " .colab-df-quickchart {\n", + " background-color: var(--bg-color);\n", + " border: none;\n", + " border-radius: 50%;\n", + " cursor: pointer;\n", + " display: none;\n", + " fill: var(--fill-color);\n", + " height: 32px;\n", + " padding: 0;\n", + " width: 32px;\n", + " }\n", + "\n", + " .colab-df-quickchart:hover {\n", + " background-color: var(--hover-bg-color);\n", + " box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n", + " fill: var(--button-hover-fill-color);\n", + " }\n", + "\n", + " .colab-df-quickchart-complete:disabled,\n", + " .colab-df-quickchart-complete:disabled:hover {\n", + " background-color: var(--disabled-bg-color);\n", + " fill: var(--disabled-fill-color);\n", + " box-shadow: none;\n", + " }\n", + "\n", + " .colab-df-spinner {\n", + " border: 2px solid var(--fill-color);\n", + " border-color: transparent;\n", + " border-bottom-color: var(--fill-color);\n", + " animation:\n", + " spin 1s steps(1) infinite;\n", + " }\n", + "\n", + " @keyframes spin {\n", + " 0% {\n", + " border-color: transparent;\n", + " border-bottom-color: var(--fill-color);\n", + " border-left-color: var(--fill-color);\n", + " }\n", + " 20% {\n", + " border-color: transparent;\n", + " border-left-color: var(--fill-color);\n", + " border-top-color: var(--fill-color);\n", + " }\n", + " 30% {\n", + " border-color: transparent;\n", + " border-left-color: var(--fill-color);\n", + " border-top-color: var(--fill-color);\n", + " border-right-color: var(--fill-color);\n", + " }\n", + " 40% {\n", + " border-color: transparent;\n", + " border-right-color: var(--fill-color);\n", + " border-top-color: var(--fill-color);\n", + " }\n", + " 60% {\n", + " border-color: transparent;\n", + " border-right-color: var(--fill-color);\n", + " }\n", + " 80% {\n", + " border-color: transparent;\n", + " border-right-color: var(--fill-color);\n", + " border-bottom-color: var(--fill-color);\n", + " }\n", + " 90% {\n", + " border-color: transparent;\n", + " border-bottom-color: var(--fill-color);\n", + " }\n", + " }\n", + "</style>\n", + "\n", + " <script>\n", + " async function quickchart(key) {\n", + " const quickchartButtonEl =\n", + " document.querySelector('#' + key + ' button');\n", + " quickchartButtonEl.disabled = true; // To prevent multiple clicks.\n", + " quickchartButtonEl.classList.add('colab-df-spinner');\n", + " try {\n", + " const charts = await google.colab.kernel.invokeFunction(\n", + " 'suggestCharts', [key], {});\n", + " } catch (error) {\n", + " console.error('Error during call to suggestCharts:', error);\n", + " }\n", + " quickchartButtonEl.classList.remove('colab-df-spinner');\n", + " quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n", + " }\n", + " (() => {\n", + " let quickchartButtonEl =\n", + " document.querySelector('#df-1a09fda8-d71a-4c48-b8e2-b45a93914e4e button');\n", + " quickchartButtonEl.style.display =\n", + " google.colab.kernel.accessAllowed ? 'block' : 'none';\n", + " })();\n", + " </script>\n", + "</div>\n", + " </div>\n", + " </div>\n" + ], + "application/vnd.google.colaboratory.intrinsic+json": { + "type": "dataframe", + "variable_name": "df2", + "summary": "{\n \"name\": \"df2\",\n \"rows\": 260,\n \"fields\": [\n {\n \"column\": \"Timestamp\",\n \"properties\": {\n \"dtype\": \"object\",\n \"min\": \"2/10/2024 0:03:14\",\n \"max\": \"2/9/2024 23:56:18\",\n \"samples\": [\n \"2/9/2024 22:54:55\",\n \"2/12/2024 2:12:41\",\n \"2/12/2024 19:19:36\"\n ],\n \"num_unique_values\": 260,\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"What gender do you identify as?\",\n \"properties\": {\n \"dtype\": \"category\",\n \"samples\": [\n \"Female\",\n \"Non-binary\",\n \"Male\"\n ],\n \"num_unique_values\": 4,\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"Who do you live with? \",\n \"properties\": {\n \"dtype\": \"category\",\n \"samples\": [\n \"Neither\",\n \"Both\",\n \"Family, Friends, Both\"\n ],\n \"num_unique_values\": 6,\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n },\n {\n \"column\": \"How many people live in your household?\",\n \"properties\": {\n \"dtype\": \"category\",\n \"samples\": [\n \"6\",\n \"4\",\n \"2\"\n ],\n \"num_unique_values\": 17,\n \"semantic_type\": \"\",\n \"description\": \"\"\n }\n }\n ]\n}" + } + }, + "metadata": {}, + "execution_count": 1 + } + ], + "source": [ + "%matplotlib inline\n", + "import pandas as pd\n", + "import numpy as np\n", + "\n", + "df = pd.read_csv(\"CS105 W24 Survey (Responses) - Form Responses 1.csv\")\n", + "#df\n", + "df2 = df.iloc[:, [0, 5, 7, 9]]\n", + "df2" + ] + }, + { + "cell_type": "code", + "execution_count": null, + "id": "29889175", + "metadata": { + "id": "29889175" + }, + "outputs": [], + "source": [] + } + ], + "metadata": { + "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" + }, + "colab": { + "provenance": [] + } + }, + "nbformat": 4, + "nbformat_minor": 5 +}
\ No newline at end of file |