aboutsummaryrefslogtreecommitdiff
path: root/CS105MiniProject.ipynb
diff options
context:
space:
mode:
authorGravatar Anshul Gupta <ansg191@anshulg.com> 2024-02-15 16:19:31 -0800
committerGravatar Anshul Gupta <ansg191@anshulg.com> 2024-02-15 16:19:31 -0800
commitdb6f314d338b23d9c62d45f1d9ceaadd82562fbb (patch)
treeb271f4f361364f8f8049532601d7c9a28102ac9f /CS105MiniProject.ipynb
parentde23b77b9b17663761e10e04620bac91af567ef4 (diff)
downloadCS105MiniProject-db6f314d338b23d9c62d45f1d9ceaadd82562fbb.tar.gz
CS105MiniProject-db6f314d338b23d9c62d45f1d9ceaadd82562fbb.tar.zst
CS105MiniProject-db6f314d338b23d9c62d45f1d9ceaadd82562fbb.zip
Adds notebook
Diffstat (limited to 'CS105MiniProject.ipynb')
-rw-r--r--CS105MiniProject.ipynb422
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