clean_meal_temp_data.ipynb

{
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/ellaclauz/Meal_Temperature-Data/blob/main/clean_meal_temp_data.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "9tgVA-9le2R_"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import openpyxl\n",
        "import numpy as np\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sn"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "drwDVmfMe2SA"
      },
      "source": [
        "         Working with data from Poll 1"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import files\n",
        "uploaded = files.upload()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 73
        },
        "id": "mRHhJWcwfHvu",
        "outputId": "3f54f0e3-c9ae-41d7-e0bb-d17c95d52842"
      },
      "execution_count": 3,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ],
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-a3bd5d66-704a-4184-b73c-3341b50e05e7\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-a3bd5d66-704a-4184-b73c-3341b50e05e7\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script>// Copyright 2017 Google LLC\n",
              "//\n",
              "// Licensed under the Apache License, Version 2.0 (the \"License\");\n",
              "// you may not use this file except in compliance with the License.\n",
              "// You may obtain a copy of the License at\n",
              "//\n",
              "//      http://www.apache.org/licenses/LICENSE-2.0\n",
              "//\n",
              "// Unless required by applicable law or agreed to in writing, software\n",
              "// distributed under the License is distributed on an \"AS IS\" BASIS,\n",
              "// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n",
              "// See the License for the specific language governing permissions and\n",
              "// limitations under the License.\n",
              "\n",
              "/**\n",
              " * @fileoverview Helpers for google.colab Python module.\n",
              " */\n",
              "(function(scope) {\n",
              "function span(text, styleAttributes = {}) {\n",
              "  const element = document.createElement('span');\n",
              "  element.textContent = text;\n",
              "  for (const key of Object.keys(styleAttributes)) {\n",
              "    element.style[key] = styleAttributes[key];\n",
              "  }\n",
              "  return element;\n",
              "}\n",
              "\n",
              "// Max number of bytes which will be uploaded at a time.\n",
              "const MAX_PAYLOAD_SIZE = 100 * 1024;\n",
              "\n",
              "function _uploadFiles(inputId, outputId) {\n",
              "  const steps = uploadFilesStep(inputId, outputId);\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  // Cache steps on the outputElement to make it available for the next call\n",
              "  // to uploadFilesContinue from Python.\n",
              "  outputElement.steps = steps;\n",
              "\n",
              "  return _uploadFilesContinue(outputId);\n",
              "}\n",
              "\n",
              "// This is roughly an async generator (not supported in the browser yet),\n",
              "// where there are multiple asynchronous steps and the Python side is going\n",
              "// to poll for completion of each step.\n",
              "// This uses a Promise to block the python side on completion of each step,\n",
              "// then passes the result of the previous step as the input to the next step.\n",
              "function _uploadFilesContinue(outputId) {\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  const steps = outputElement.steps;\n",
              "\n",
              "  const next = steps.next(outputElement.lastPromiseValue);\n",
              "  return Promise.resolve(next.value.promise).then((value) => {\n",
              "    // Cache the last promise value to make it available to the next\n",
              "    // step of the generator.\n",
              "    outputElement.lastPromiseValue = value;\n",
              "    return next.value.response;\n",
              "  });\n",
              "}\n",
              "\n",
              "/**\n",
              " * Generator function which is called between each async step of the upload\n",
              " * process.\n",
              " * @param {string} inputId Element ID of the input file picker element.\n",
              " * @param {string} outputId Element ID of the output display.\n",
              " * @return {!Iterable<!Object>} Iterable of next steps.\n",
              " */\n",
              "function* uploadFilesStep(inputId, outputId) {\n",
              "  const inputElement = document.getElementById(inputId);\n",
              "  inputElement.disabled = false;\n",
              "\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  outputElement.innerHTML = '';\n",
              "\n",
              "  const pickedPromise = new Promise((resolve) => {\n",
              "    inputElement.addEventListener('change', (e) => {\n",
              "      resolve(e.target.files);\n",
              "    });\n",
              "  });\n",
              "\n",
              "  const cancel = document.createElement('button');\n",
              "  inputElement.parentElement.appendChild(cancel);\n",
              "  cancel.textContent = 'Cancel upload';\n",
              "  const cancelPromise = new Promise((resolve) => {\n",
              "    cancel.onclick = () => {\n",
              "      resolve(null);\n",
              "    };\n",
              "  });\n",
              "\n",
              "  // Wait for the user to pick the files.\n",
              "  const files = yield {\n",
              "    promise: Promise.race([pickedPromise, cancelPromise]),\n",
              "    response: {\n",
              "      action: 'starting',\n",
              "    }\n",
              "  };\n",
              "\n",
              "  cancel.remove();\n",
              "\n",
              "  // Disable the input element since further picks are not allowed.\n",
              "  inputElement.disabled = true;\n",
              "\n",
              "  if (!files) {\n",
              "    return {\n",
              "      response: {\n",
              "        action: 'complete',\n",
              "      }\n",
              "    };\n",
              "  }\n",
              "\n",
              "  for (const file of files) {\n",
              "    const li = document.createElement('li');\n",
              "    li.append(span(file.name, {fontWeight: 'bold'}));\n",
              "    li.append(span(\n",
              "        `(${file.type || 'n/a'}) - ${file.size} bytes, ` +\n",
              "        `last modified: ${\n",
              "            file.lastModifiedDate ? file.lastModifiedDate.toLocaleDateString() :\n",
              "                                    'n/a'} - `));\n",
              "    const percent = span('0% done');\n",
              "    li.appendChild(percent);\n",
              "\n",
              "    outputElement.appendChild(li);\n",
              "\n",
              "    const fileDataPromise = new Promise((resolve) => {\n",
              "      const reader = new FileReader();\n",
              "      reader.onload = (e) => {\n",
              "        resolve(e.target.result);\n",
              "      };\n",
              "      reader.readAsArrayBuffer(file);\n",
              "    });\n",
              "    // Wait for the data to be ready.\n",
              "    let fileData = yield {\n",
              "      promise: fileDataPromise,\n",
              "      response: {\n",
              "        action: 'continue',\n",
              "      }\n",
              "    };\n",
              "\n",
              "    // Use a chunked sending to avoid message size limits. See b/62115660.\n",
              "    let position = 0;\n",
              "    do {\n",
              "      const length = Math.min(fileData.byteLength - position, MAX_PAYLOAD_SIZE);\n",
              "      const chunk = new Uint8Array(fileData, position, length);\n",
              "      position += length;\n",
              "\n",
              "      const base64 = btoa(String.fromCharCode.apply(null, chunk));\n",
              "      yield {\n",
              "        response: {\n",
              "          action: 'append',\n",
              "          file: file.name,\n",
              "          data: base64,\n",
              "        },\n",
              "      };\n",
              "\n",
              "      let percentDone = fileData.byteLength === 0 ?\n",
              "          100 :\n",
              "          Math.round((position / fileData.byteLength) * 100);\n",
              "      percent.textContent = `${percentDone}% done`;\n",
              "\n",
              "    } while (position < fileData.byteLength);\n",
              "  }\n",
              "\n",
              "  // All done.\n",
              "  yield {\n",
              "    response: {\n",
              "      action: 'complete',\n",
              "    }\n",
              "  };\n",
              "}\n",
              "\n",
              "scope.google = scope.google || {};\n",
              "scope.google.colab = scope.google.colab || {};\n",
              "scope.google.colab._files = {\n",
              "  _uploadFiles,\n",
              "  _uploadFilesContinue,\n",
              "};\n",
              "})(self);\n",
              "</script> "
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Saving 25June2022_Poll1.csv to 25June2022_Poll1.csv\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 4,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 658
        },
        "id": "bvx30VQhe2SC",
        "outputId": "1c48f7ce-7175-40a2-b3c3-12ea989026e8"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     Timestamp                   Username  \\\n",
              "0   2022/06/25 11:56:51 AM MDT   oluwaseyi.bola@gmail.com   \n",
              "1   2022/06/25 11:57:11 AM MDT        lizzyajai@gmail.com   \n",
              "2   2022/06/25 11:58:02 AM MDT  maryannmwangi36@gmail.com   \n",
              "3   2022/06/25 11:58:47 AM MDT       tjshotunde@yahoo.com   \n",
              "4   2022/06/25 12:00:01 PM MDT    winfredplt583@gmail.com   \n",
              "..                         ...                        ...   \n",
              "61  2022/06/25 12:59:28 PM MDT    cynthiakuzira@gmail.com   \n",
              "62  2022/06/25 12:59:29 PM MDT   berylakinyi150@gmail.com   \n",
              "63  2022/06/25 12:59:58 PM MDT     kamisandra22@gmail.com   \n",
              "64   2022/06/25 1:11:47 PM MDT      rungibarbra@gmail.com   \n",
              "65   2022/06/25 1:26:49 PM MDT    adeoolarhneye@gmail.com   \n",
              "\n",
              "                         Name  \\\n",
              "0          Oluwaseyi Olukemi    \n",
              "1   Ajayi Elizabeth Damilola    \n",
              "2             Maryann Mwangi    \n",
              "3      Oreoluwa Jimi-Shotunde   \n",
              "4              Winfred Apolot   \n",
              "..                        ...   \n",
              "61             Kuzira Cynthia   \n",
              "62       Ochieng Beril Akinyi   \n",
              "63           Sandra Kamikazi    \n",
              "64             Barbra Birungi   \n",
              "65           Tolulope Adeneye   \n",
              "\n",
              "   In your area, right now, what is the temperature?  \\\n",
              "0                                                 28   \n",
              "1                                                 29   \n",
              "2                                                 19   \n",
              "3                                                28    \n",
              "4                                                 20   \n",
              "..                                               ...   \n",
              "61                                                37   \n",
              "62                                               19    \n",
              "63                                                22   \n",
              "64                                                22   \n",
              "65                                                27   \n",
              "\n",
              "   Did you provide that temperature in degrees Fahrenhait (F) or in degrees Celsius (C)?  \n",
              "0                                                   C                                     \n",
              "1                                                   C                                     \n",
              "2                                                   C                                     \n",
              "3                                                   C                                     \n",
              "4                                                   C                                     \n",
              "..                                                ...                                     \n",
              "61                                                  C                                     \n",
              "62                                                  C                                     \n",
              "63                                                  C                                     \n",
              "64                                                  C                                     \n",
              "65                                                  C                                     \n",
              "\n",
              "[66 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b75b9f8f-9a4d-4710-8097-120241adafa6\">\n",
              "    <div 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>Username</th>\n",
              "      <th>Name</th>\n",
              "      <th>In your area, right now, what is the temperature?</th>\n",
              "      <th>Did you provide that temperature in degrees Fahrenhait (F) or in degrees Celsius (C)?</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022/06/25 11:56:51 AM MDT</td>\n",
              "      <td>oluwaseyi.bola@gmail.com</td>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>28</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2022/06/25 11:57:11 AM MDT</td>\n",
              "      <td>lizzyajai@gmail.com</td>\n",
              "      <td>Ajayi Elizabeth Damilola</td>\n",
              "      <td>29</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2022/06/25 11:58:02 AM MDT</td>\n",
              "      <td>maryannmwangi36@gmail.com</td>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>19</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2022/06/25 11:58:47 AM MDT</td>\n",
              "      <td>tjshotunde@yahoo.com</td>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>28</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2022/06/25 12:00:01 PM MDT</td>\n",
              "      <td>winfredplt583@gmail.com</td>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>20</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>2022/06/25 12:59:28 PM MDT</td>\n",
              "      <td>cynthiakuzira@gmail.com</td>\n",
              "      <td>Kuzira Cynthia</td>\n",
              "      <td>37</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>2022/06/25 12:59:29 PM MDT</td>\n",
              "      <td>berylakinyi150@gmail.com</td>\n",
              "      <td>Ochieng Beril Akinyi</td>\n",
              "      <td>19</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>2022/06/25 12:59:58 PM MDT</td>\n",
              "      <td>kamisandra22@gmail.com</td>\n",
              "      <td>Sandra Kamikazi</td>\n",
              "      <td>22</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>2022/06/25 1:11:47 PM MDT</td>\n",
              "      <td>rungibarbra@gmail.com</td>\n",
              "      <td>Barbra Birungi</td>\n",
              "      <td>22</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>2022/06/25 1:26:49 PM MDT</td>\n",
              "      <td>adeoolarhneye@gmail.com</td>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>27</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>66 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b75b9f8f-9a4d-4710-8097-120241adafa6')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-b75b9f8f-9a4d-4710-8097-120241adafa6 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-b75b9f8f-9a4d-4710-8097-120241adafa6');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ],
      "source": [
        "Temp_data = pd.read_csv(\"25June2022_Poll1.csv\")\n",
        "Temp_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 5,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ccBWYjoZe2SE",
        "outputId": "e63f112f-b1b2-40cb-ca91-2dae622f8a23"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Index(['Timestamp', 'Username', 'Name',\n",
              "       'In your area, right now, what is the temperature?',\n",
              "       'Did you provide that temperature in degrees Fahrenhait (F) or in degrees Celsius (C)?'],\n",
              "      dtype='object')"
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ],
      "source": [
        "Temp_data.columns"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 6,
      "metadata": {
        "id": "vTlGri1Ue2SF"
      },
      "outputs": [],
      "source": [
        "# rename column \n",
        "Temp_data = Temp_data.rename(columns= {\"Username\":\"Email\", \"In your area, right now, what is the temperature?\":\"Temperature\", \"Did you provide that temperature in degrees Fahrenhait (F) or in degrees Celsius (C)?\":\"Metrics\" })"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 7,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "CSSEA-dae2SF",
        "outputId": "5a49dc45-e019-4acb-a125-724ac9c306cd"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     Timestamp                      Email  \\\n",
              "0   2022/06/25 11:56:51 AM MDT   oluwaseyi.bola@gmail.com   \n",
              "1   2022/06/25 11:57:11 AM MDT        lizzyajai@gmail.com   \n",
              "2   2022/06/25 11:58:02 AM MDT  maryannmwangi36@gmail.com   \n",
              "3   2022/06/25 11:58:47 AM MDT       tjshotunde@yahoo.com   \n",
              "4   2022/06/25 12:00:01 PM MDT    winfredplt583@gmail.com   \n",
              "..                         ...                        ...   \n",
              "61  2022/06/25 12:59:28 PM MDT    cynthiakuzira@gmail.com   \n",
              "62  2022/06/25 12:59:29 PM MDT   berylakinyi150@gmail.com   \n",
              "63  2022/06/25 12:59:58 PM MDT     kamisandra22@gmail.com   \n",
              "64   2022/06/25 1:11:47 PM MDT      rungibarbra@gmail.com   \n",
              "65   2022/06/25 1:26:49 PM MDT    adeoolarhneye@gmail.com   \n",
              "\n",
              "                         Name Temperature Metrics  \n",
              "0          Oluwaseyi Olukemi           28       C  \n",
              "1   Ajayi Elizabeth Damilola           29       C  \n",
              "2             Maryann Mwangi           19       C  \n",
              "3      Oreoluwa Jimi-Shotunde         28        C  \n",
              "4              Winfred Apolot          20       C  \n",
              "..                        ...         ...     ...  \n",
              "61             Kuzira Cynthia          37       C  \n",
              "62       Ochieng Beril Akinyi         19        C  \n",
              "63           Sandra Kamikazi           22       C  \n",
              "64             Barbra Birungi          22       C  \n",
              "65           Tolulope Adeneye          27       C  \n",
              "\n",
              "[66 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-d363004a-77c1-4c23-bbaa-f5524a879705\">\n",
              "    <div 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>Email</th>\n",
              "      <th>Name</th>\n",
              "      <th>Temperature</th>\n",
              "      <th>Metrics</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022/06/25 11:56:51 AM MDT</td>\n",
              "      <td>oluwaseyi.bola@gmail.com</td>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>28</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2022/06/25 11:57:11 AM MDT</td>\n",
              "      <td>lizzyajai@gmail.com</td>\n",
              "      <td>Ajayi Elizabeth Damilola</td>\n",
              "      <td>29</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2022/06/25 11:58:02 AM MDT</td>\n",
              "      <td>maryannmwangi36@gmail.com</td>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>19</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2022/06/25 11:58:47 AM MDT</td>\n",
              "      <td>tjshotunde@yahoo.com</td>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>28</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2022/06/25 12:00:01 PM MDT</td>\n",
              "      <td>winfredplt583@gmail.com</td>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>20</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>2022/06/25 12:59:28 PM MDT</td>\n",
              "      <td>cynthiakuzira@gmail.com</td>\n",
              "      <td>Kuzira Cynthia</td>\n",
              "      <td>37</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>2022/06/25 12:59:29 PM MDT</td>\n",
              "      <td>berylakinyi150@gmail.com</td>\n",
              "      <td>Ochieng Beril Akinyi</td>\n",
              "      <td>19</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>2022/06/25 12:59:58 PM MDT</td>\n",
              "      <td>kamisandra22@gmail.com</td>\n",
              "      <td>Sandra Kamikazi</td>\n",
              "      <td>22</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>2022/06/25 1:11:47 PM MDT</td>\n",
              "      <td>rungibarbra@gmail.com</td>\n",
              "      <td>Barbra Birungi</td>\n",
              "      <td>22</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>2022/06/25 1:26:49 PM MDT</td>\n",
              "      <td>adeoolarhneye@gmail.com</td>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>27</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>66 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-d363004a-77c1-4c23-bbaa-f5524a879705')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-d363004a-77c1-4c23-bbaa-f5524a879705 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-d363004a-77c1-4c23-bbaa-f5524a879705');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 7
        }
      ],
      "source": [
        "Temp_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 8,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "CUnXv7xFe2SG",
        "outputId": "b60c623b-536d-4860-fef5-67394e8a0878"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['28', '29', '19', '28 ', '20', '30', '18', '27', '36',\n",
              "       '28 Celsius', '17', '71', '22 ', '26', '38', '24', '45', '16',\n",
              "       '21 Degrees ', '21', '25', '35', '70', '40', '37.5', '65', '37',\n",
              "       '19 ', '22'], dtype=object)"
            ]
          },
          "metadata": {},
          "execution_count": 8
        }
      ],
      "source": [
        "# Taking a look at the distinct value in the temperature column\n",
        "Temp_data[\"Temperature\"].unique()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "I5zAlysOe2SH"
      },
      "source": []
    },
    {
      "cell_type": "code",
      "execution_count": 9,
      "metadata": {
        "id": "YO4JkkXXe2SH"
      },
      "outputs": [],
      "source": [
        "def clean_temp(temp_val):\n",
        "    if \"Degrees\" in temp_val:\n",
        "        return temp_val.replace(\"Degrees\", \"\").strip()\n",
        "    elif \"Celsius\" in temp_val:\n",
        "        return temp_val.replace(\"Celsius\", \"\").strip()\n",
        "    elif \"Fahrenheit\" in temp_val:\n",
        "        return temp_val.replace(\"Fahrenheit\", \"\").strip()\n",
        "    else:\n",
        "        return temp_val"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 10,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QAVmzUgRe2SI",
        "outputId": "798f77b8-2414-4cb0-ec52-cc5b1635c2a9"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "0      28\n",
              "1      29\n",
              "2      19\n",
              "3     28 \n",
              "4      20\n",
              "     ... \n",
              "61     37\n",
              "62    19 \n",
              "63     22\n",
              "64     22\n",
              "65     27\n",
              "Name: Temperature, Length: 66, dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ],
      "source": [
        "Temp_data[\"Temperature\"] = Temp_data[\"Temperature\"].apply(clean_temp)\n",
        "Temp_data[\"Temperature\"]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 11,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "1nISa77ie2SJ",
        "outputId": "b4ff431e-465d-4a13-ffdc-cc701d85b842"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['28', '29', '19', '28 ', '20', '30', '18', '27', '36', '17', '71',\n",
              "       '22 ', '26', '38', '24', '45', '16', '21', '25', '35', '70', '40',\n",
              "       '37.5', '65', '37', '19 ', '22'], dtype=object)"
            ]
          },
          "metadata": {},
          "execution_count": 11
        }
      ],
      "source": [
        "Temp_data[\"Temperature\"].unique()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 12,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vp1V9STSe2SJ",
        "outputId": "34edd9c5-bd57-4e6c-a940-bb336b79c625"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(66, 5)"
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ],
      "source": [
        "Temp_data.shape"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 13,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "geq3Tz-Je2SK",
        "outputId": "20d20477-df9a-4043-9842-26f15860e491"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "5"
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ],
      "source": [
        "Temp_data.shape[1]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 14,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "iUIgBFqke2SK",
        "outputId": "0a393c55-76d6-4d57-ce4c-5b524671be52"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "C    61\n",
              "F     5\n",
              "Name: Metrics, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ],
      "source": [
        "Temp_data[\"Metrics\"].value_counts()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 15,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JGvAi30ee2SK",
        "outputId": "02b341be-1095-46af-8efd-5c44129dfd7c"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Timestamp      object\n",
              "Email          object\n",
              "Name           object\n",
              "Temperature    object\n",
              "Metrics        object\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ],
      "source": [
        "Temp_data.dtypes"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 16,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sTU7Hs66e2SL",
        "outputId": "6bac5af5-0e51-4111-8ea4-643d2707c15a"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "str"
            ]
          },
          "metadata": {},
          "execution_count": 16
        }
      ],
      "source": [
        "type(Temp_data[\"Temperature\"].iloc[0])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 17,
      "metadata": {
        "id": "6G9oDFree2SL"
      },
      "outputs": [],
      "source": [
        "Temp_data[\"Temperature\"] = pd.to_numeric(Temp_data[\"Temperature\"])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 18,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "huIRCgJce2SL",
        "outputId": "4177009a-f6a7-45a3-c552-7191b02bd469"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Timestamp       object\n",
              "Email           object\n",
              "Name            object\n",
              "Temperature    float64\n",
              "Metrics         object\n",
              "dtype: object"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ],
      "source": [
        "Temp_data.dtypes"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 19,
      "metadata": {
        "id": "-i0Bg5JPe2SM"
      },
      "outputs": [],
      "source": [
        "Temp_in_f = np.array([])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 20,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "VhVROgxce2SM",
        "outputId": "1093b8aa-c55e-4261-e49b-075c55d3d7b7"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([], dtype=float64)"
            ]
          },
          "metadata": {},
          "execution_count": 20
        }
      ],
      "source": [
        "Temp_in_f"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 21,
      "metadata": {
        "id": "BL8vLIyZe2SM"
      },
      "outputs": [],
      "source": [
        "# for each row in the dataframe,\n",
        "# if metric is C, convert temperature to F and add converted value to numpy array\n",
        "# else add original temperature value to numpy array\n",
        "for i in range(0, 66):\n",
        "    # vist each row \n",
        "    # if metric C --> conert to F \n",
        "    row = Temp_data.iloc[i] \n",
        "    if row[\"Metrics\"] == \"C\":\n",
        "        Temp_in_f = np.append(Temp_in_f, (row[\"Temperature\"] * \n",
        "        (9/5)) + 32)\n",
        "    else:\n",
        "        Temp_in_f = np.append(Temp_in_f, row[\"Temperature\"])"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 22,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "txG9Fgv0e2SN",
        "outputId": "0c357e46-9466-4e78-cb49-2cea59936885"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array([ 82.4,  84.2,  66.2,  82.4,  68. ,  86. ,  64.4,  66.2,  66.2,\n",
              "        68. ,  80.6,  68. ,  96.8,  82.4,  64.4,  62.6,  64.4,  64.4,\n",
              "        82.4,  71. ,  71.6,  78.8,  82.4, 100.4,  64.4,  75.2,  86. ,\n",
              "        82.4,  78.8,  75.2, 113. ,  82.4,  82.4,  60.8,  78.8,  80.6,\n",
              "        69.8,  62.6,  69.8,  78.8,  25. ,  84.2,  20. ,  80.6,  86. ,\n",
              "        95. ,  64.4,  80.6,  80.6,  84.2,  82.4,  70. ,  78.8, 104. ,\n",
              "        68. ,  84.2,  99.5,  84.2,  65. ,  80.6,  80.6,  98.6,  66.2,\n",
              "        71.6,  71.6,  80.6])"
            ]
          },
          "metadata": {},
          "execution_count": 22
        }
      ],
      "source": [
        "Temp_in_f"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 23,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "odyqHT7ge2SN",
        "outputId": "856eb78e-3b32-4453-f88a-8fd673e590ae"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "66"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ],
      "source": [
        "len(Temp_in_f)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 24,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "EH71X2g_e2SN",
        "outputId": "6d3ba586-e201-41e7-eea6-0a2e69c0ea29"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[82.4,\n",
              " 84.2,\n",
              " 66.2,\n",
              " 82.4,\n",
              " 68.0,\n",
              " 86.0,\n",
              " 64.4,\n",
              " 66.2,\n",
              " 66.2,\n",
              " 68.0,\n",
              " 80.6,\n",
              " 68.0,\n",
              " 96.8,\n",
              " 82.4,\n",
              " 64.4,\n",
              " 62.6,\n",
              " 64.4,\n",
              " 64.4,\n",
              " 82.4,\n",
              " 71.0,\n",
              " 71.6,\n",
              " 78.8,\n",
              " 82.4,\n",
              " 100.4,\n",
              " 64.4,\n",
              " 75.2,\n",
              " 86.0,\n",
              " 82.4,\n",
              " 78.8,\n",
              " 75.2,\n",
              " 113.0,\n",
              " 82.4,\n",
              " 82.4,\n",
              " 60.8,\n",
              " 78.8,\n",
              " 80.6,\n",
              " 69.8,\n",
              " 62.6,\n",
              " 69.8,\n",
              " 78.8,\n",
              " 25.0,\n",
              " 84.2,\n",
              " 20.0,\n",
              " 80.6,\n",
              " 86.0,\n",
              " 95.0,\n",
              " 64.4,\n",
              " 80.6,\n",
              " 80.6,\n",
              " 84.2,\n",
              " 82.4,\n",
              " 70.0,\n",
              " 78.8,\n",
              " 104.0,\n",
              " 68.0,\n",
              " 84.2,\n",
              " 99.5,\n",
              " 84.2,\n",
              " 65.0,\n",
              " 80.6,\n",
              " 80.6,\n",
              " 98.6,\n",
              " 66.2,\n",
              " 71.6,\n",
              " 71.6,\n",
              " 80.6]"
            ]
          },
          "metadata": {},
          "execution_count": 24
        }
      ],
      "source": [
        "# if you want 68. to show up as 68.0 \n",
        "# call the built-in round function in python\n",
        "# and use list comprehension\n",
        "[round(val, 1) for val in Temp_in_f]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 25,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xYLu5c1ne2SO",
        "outputId": "20efd2c2-aa5a-4532-b671-69109b933855"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "76.2378787878788"
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ],
      "source": [
        "Temp_in_f.mean()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 26,
      "metadata": {
        "id": "BLO9gVJde2SO"
      },
      "outputs": [],
      "source": [
        "Temp_data[\"Temperature\"] = Temp_in_f"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 27,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "rocc_aLUe2SO",
        "outputId": "9f018e98-5492-4d16-f74e-4f2c78cf50bb"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     Timestamp                      Email  \\\n",
              "0   2022/06/25 11:56:51 AM MDT   oluwaseyi.bola@gmail.com   \n",
              "1   2022/06/25 11:57:11 AM MDT        lizzyajai@gmail.com   \n",
              "2   2022/06/25 11:58:02 AM MDT  maryannmwangi36@gmail.com   \n",
              "3   2022/06/25 11:58:47 AM MDT       tjshotunde@yahoo.com   \n",
              "4   2022/06/25 12:00:01 PM MDT    winfredplt583@gmail.com   \n",
              "..                         ...                        ...   \n",
              "61  2022/06/25 12:59:28 PM MDT    cynthiakuzira@gmail.com   \n",
              "62  2022/06/25 12:59:29 PM MDT   berylakinyi150@gmail.com   \n",
              "63  2022/06/25 12:59:58 PM MDT     kamisandra22@gmail.com   \n",
              "64   2022/06/25 1:11:47 PM MDT      rungibarbra@gmail.com   \n",
              "65   2022/06/25 1:26:49 PM MDT    adeoolarhneye@gmail.com   \n",
              "\n",
              "                         Name  Temperature Metrics  \n",
              "0          Oluwaseyi Olukemi          82.4       C  \n",
              "1   Ajayi Elizabeth Damilola          84.2       C  \n",
              "2             Maryann Mwangi          66.2       C  \n",
              "3      Oreoluwa Jimi-Shotunde         82.4       C  \n",
              "4              Winfred Apolot         68.0       C  \n",
              "..                        ...          ...     ...  \n",
              "61             Kuzira Cynthia         98.6       C  \n",
              "62       Ochieng Beril Akinyi         66.2       C  \n",
              "63           Sandra Kamikazi          71.6       C  \n",
              "64             Barbra Birungi         71.6       C  \n",
              "65           Tolulope Adeneye         80.6       C  \n",
              "\n",
              "[66 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-5fc3c54b-6638-42ba-b1f9-b8ed27e597c7\">\n",
              "    <div 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>Email</th>\n",
              "      <th>Name</th>\n",
              "      <th>Temperature</th>\n",
              "      <th>Metrics</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022/06/25 11:56:51 AM MDT</td>\n",
              "      <td>oluwaseyi.bola@gmail.com</td>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2022/06/25 11:57:11 AM MDT</td>\n",
              "      <td>lizzyajai@gmail.com</td>\n",
              "      <td>Ajayi Elizabeth Damilola</td>\n",
              "      <td>84.2</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2022/06/25 11:58:02 AM MDT</td>\n",
              "      <td>maryannmwangi36@gmail.com</td>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>66.2</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2022/06/25 11:58:47 AM MDT</td>\n",
              "      <td>tjshotunde@yahoo.com</td>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2022/06/25 12:00:01 PM MDT</td>\n",
              "      <td>winfredplt583@gmail.com</td>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>68.0</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>2022/06/25 12:59:28 PM MDT</td>\n",
              "      <td>cynthiakuzira@gmail.com</td>\n",
              "      <td>Kuzira Cynthia</td>\n",
              "      <td>98.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>2022/06/25 12:59:29 PM MDT</td>\n",
              "      <td>berylakinyi150@gmail.com</td>\n",
              "      <td>Ochieng Beril Akinyi</td>\n",
              "      <td>66.2</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>2022/06/25 12:59:58 PM MDT</td>\n",
              "      <td>kamisandra22@gmail.com</td>\n",
              "      <td>Sandra Kamikazi</td>\n",
              "      <td>71.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>2022/06/25 1:11:47 PM MDT</td>\n",
              "      <td>rungibarbra@gmail.com</td>\n",
              "      <td>Barbra Birungi</td>\n",
              "      <td>71.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>2022/06/25 1:26:49 PM MDT</td>\n",
              "      <td>adeoolarhneye@gmail.com</td>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>66 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-5fc3c54b-6638-42ba-b1f9-b8ed27e597c7')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-5fc3c54b-6638-42ba-b1f9-b8ed27e597c7 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-5fc3c54b-6638-42ba-b1f9-b8ed27e597c7');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 27
        }
      ],
      "source": [
        "Temp_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 28,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 295
        },
        "id": "-dEjhJcye2SO",
        "outputId": "33ddd482-b099-42af-808a-de15c8df23bf"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAEWCAYAAABhffzLAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAbAklEQVR4nO3de5ycVX3H8c+XhIskKQGyDdew3MRSrGCDglCbAkWuoi1yEW2kYLQqgoIKgm1ascJLREutKLeG+x0lXCoggiAiNInhGlEaAgmEXFAgAQUDv/5xzsKTyczubHZnJtnzfb9e89rnNuf89nlmv/PMmdlnFBGYmVk51uh0AWZm1l4OfjOzwjj4zcwK4+A3MyuMg9/MrDAOfjOzwjj4hwhJ35P0lUFqa5ykpZKG5fk7JR09GG3n9v5H0sTBaq8f/Z4qabGkZ9vdtzUmaYKkeZ2uoyQO/tWApDmSfi9piaTnJf1c0iclvXH8IuKTEfHVJtvaq7dtIuKpiBgZEa8NQu2TJV1S0/6+EXHhQNvuZx3jgOOB7SNio5p1R+QnuqV5P79emV/azjoHi8PUeuPgX30cGBGjgC2A04AvAecPdieShg92m6uIccBzEbGwdkVEXJqf6EYC+wLP9MznZasUJS392x3CjwPDwb/aiYgXImIqcCgwUdIOAJKmSDo1T4+RdGN+dfBbSXdLWkPSxaQAvCGfzX5RUrekkHSUpKeAn1SWVf/4t5Z0v6QXJV0vaYPc1wpnlj2vKiTtA3wZODT390Be/8bQUa7rFElPSloo6SJJ6+V1PXVMlPRUHqY5udG+kbRevv+i3N4puf29gNuATXIdU5rd35I2kXRtbvMJSZ+trJss6WpJl+RXYw9Jequkk/LvMlfS3pXt75T09Xr7Ma/fJb+ae17SA5Im1Nz3a5LuAV4GtpJ0pKRZue/Zkj6Rtx0B/E/l912af483HiP1jl0+bl+S9CDwkqThvdVUs5++JOmammX/IemsPF231gZthaRtKvO1dR8gaabefPX7FzV1PJ37eUzSno36KVpE+LaK34A5wF51lj8F/FOengKcmqe/DnwPWDPf/gpQvbaAbiCAi4ARwFsqy4bnbe4EngZ2yNtcC1yS100A5jWqF5jcs21l/Z3A0Xn6H4HHga2AkcB1wMU1tZ2b63oH8ArwZw3200XA9cCofN9fA0c1qrNBG29sRzoxmg78M7BWrnE28L7K7/YH4H3A8Nz/E8DJeb9/HHii5vdutB83BZ4D9sv9/m2e76rc9yngz3NfawL7A1sDAv6a9ITwzl6OyxTyY6TeNvm4zQQ2z/u715pq2t4i9z8qzw8D5gO75Pmma83HfJt6dQM7AQuBd+c+Jua61wa2A+YCm1QeP1t3+u93Vbz5jH/19gywQZ3lfwQ2BraIiD9GxN2R/xJ6MTkiXoqI3zdYf3FEPBwRLwFfAQ5RfvN3gI4AzoyI2RGxFDgJOKzm1ca/RsTvI+IB4AHSE8Byci2HASdFxJKImAN8E/joAGrbmRRy/xYRr0bEbNKT0GGVbe6OiFsiYhlwNdAFnBYRfwSuALolja5s32g/fgS4OSJujojXI+I2YBopdHtMiYhHImJZPq43RcT/RfJT4FbSk/xAnBURc/PjoJmaAIiIJ4EZwAfzoj2AlyPiF3n9YNU6Cfh+RNwXEa9Feq/oFWAX4DXSE8D2ktaMiDkR8X8r0ceQ5+BfvW0K/LbO8m+QzqJvzS+rT2yirbn9WP8k6YxzTFNV9m6T3F617eHA2Mqy6qdwXia9Mqg1JtdU29amA6htC9JwyfM9N9LQVbW2BZXp3wOL4803xXueRKv1NtqPWwAfqulrd9ITeL37ImlfSb9QGs57nhTIAz0m1T6aqanqMuDwPP3hPD/YtW4BHF9T0+aks/zHgeNIr8QWSrpC0iYr0ceQ5+BfTUnamRRqP6tdl894j4+IrYD3A5+vjHU2OvPv6xXB5pXpcaRXFYuBl4B1K3UNI531NtvuM6Q/5mrby1g+UJuxONdU29bT/Wynai5pqGZ05TYqIlY44+2HRvtxLunVQLWvERFxWmX7N/alpLVJQ0VnAGMjYjRwM2koZbltK5Y7VsBGdbap3q+ZmqquBiZI2ox05n9Zk7XWermXOucCX6upad2IuBwgIi6LiN1Jj4MATm/QR9Ec/KsZSX8i6QDSMMIlEfFQnW0OkLSNJAEvkF4Cv55XLyCNVffXRyRtL2ld4N+Aa/KZ7a+BdSTtL2lN4BTSy+0eC0jDHY0ea5cDn5O0paSRwL8DV+ahk6blWq4CviZplKQtgM8Dl/R+z17dDyzJbxi+RdIwSTvkJ92V1Wg/XgIcKOl9uZ918puvmzVoZy3Sfl4ELJO0L7B3Zf0CYEPlN8qzmcB+kjaQtBHp7Lg3/aopIhaR3ov4b9IT5qwma601E/hw7nMf0nsCPc4FPinp3UpG5MfeKEnbSdojP9H8gfSK6/U67RfPwb/6uEHSEtIZz8nAmcCRDbbdFvgxsBS4F/huRNyR130dOCW/TD6hH/1fTHqT7VlgHeCzkD5lBHwKOI90dv0SUP2Uz9X553OSZtRp94Lc9l2kN0b/ABzTj7qqjsn9zya9Erost79SciAfAOyYa1tM+j3X6+1+fWi0H+cCB5GGkhaRjvMXaPA3GhFL8n2vAn5HGlqZWln/K9KT6ux8rDfJfT9AejP0VuDK3grtb03ZZcBeVIZ5+qq1jmOBA4HnSe8B/bDS1jTSm+bfyW09Dnwsr16b9FHnxaT9+6ek94ysRs8nPcysxSTdSXqVdl6na7Gy+YzfzKwwDn4zs8J4qMfMrDA+4zczK8xqcSGmMWPGRHd3d6fLMDNbrUyfPn1xRHTVLl8tgr+7u5tp06Z1ugwzs9WKpCfrLfdQj5lZYRz8ZmaFcfCbmRXGwW9mVhgHv5lZYRz8ZmaFcfCbmRXGwW9mVhgHv5lZYVaL/9w1sxV1n3hTR/qdc9r+HenXBo/P+M3MCuPgNzMrjIPfzKwwDn4zs8I4+M3MCuPgNzMrjIPfzKwwDn4zs8I4+M3MCuPgNzMrjIPfzKwwLQt+SZtLukPSo5IekXRsXj5Z0tOSZubbfq2qwczMVtTKi7QtA46PiBmSRgHTJd2W130rIs5oYd9mZtZAy4I/IuYD8/P0EkmzgE1b1Z+ZmTWnLWP8krqBnYD78qLPSHpQ0gWS1m9wn0mSpkmatmjRonaUaWZWhJYHv6SRwLXAcRHxInA2sDWwI+kVwTfr3S8izomI8RExvqurq9VlmpkVo6XBL2lNUuhfGhHXAUTEgoh4LSJeB84F3tXKGszMbHmt/FSPgPOBWRFxZmX5xpXNPgg83KoazMxsRa38VM9uwEeBhyTNzMu+DBwuaUcggDnAJ1pYg5mZ1Wjlp3p+BqjOqptb1aeZmfXN/7lrZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlaYlgW/pM0l3SHpUUmPSDo2L99A0m2SfpN/rt+qGszMbEWtPONfBhwfEdsDuwCflrQ9cCJwe0RsC9ye583MrE1aFvwRMT8iZuTpJcAsYFPgIODCvNmFwAdaVYOZma2oLWP8krqBnYD7gLERMT+vehYY2+A+kyRNkzRt0aJF7SjTzKwILQ9+SSOBa4HjIuLF6rqICCDq3S8izomI8RExvqurq9VlmpkVo6XBL2lNUuhfGhHX5cULJG2c128MLGxlDWZmtrxWfqpHwPnArIg4s7JqKjAxT08Erm9VDWZmtqLhLWx7N+CjwEOSZuZlXwZOA66SdBTwJHBIC2swM7MaLQv+iPgZoAar92xVv2Zm1jv/566ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVxsFvZlYYB7+ZWWEc/GZmhXHwm5kVpqngl7RbM8vMzGzV1+wZ/382uczMzFZxw3tbKWlX4D1Al6TPV1b9CTCslYWZmVlr9HXGvxYwkvQEMapyexE4uLc7SrpA0kJJD1eWTZb0tKSZ+bbfwMo3M7P+6vWMPyJ+CvxU0pSIeLKfbU8BvgNcVLP8WxFxRj/bMjOzQdJr8FesLekcoLt6n4jYo9EdIuIuSd0DKc7MzAZfs8F/NfA94DzgtQH2+RlJ/wBMA46PiN/V20jSJGASwLhx4wbYpZmZ9Wj2Uz3LIuLsiLg/Iqb33Faiv7OBrYEdgfnANxttGBHnRMT4iBjf1dW1El2ZmVk9zQb/DZI+JWljSRv03PrbWUQsiIjXIuJ14FzgXf1tw8zMBqbZoZ6J+ecXKssC2Ko/nUnaOCLm59kPAg/3tr2ZmQ2+poI/Irbsb8OSLgcmAGMkzQP+BZggaUfSk8Yc4BP9bdfMzAamqeDPb8auICJqP6pZXXd4ncXnN1mXmZm1SLNDPTtXptcB9gRmsOJn9M3MbBXX7FDPMdV5SaOBK1pSkdlK6D7xpo70O+e0/TvSr9lArOxlmV8C+j3ub2ZmndfsGP8NpDdkIV2c7c+Aq1pVlJmZtU6zY/zVa+ssA56MiHktqMfMzFqsqaGefLG2X5GuzLk+8GorizIzs9Zp9hu4DgHuBz4EHALcJ6nXyzKbmdmqqdmhnpOBnSNiIYCkLuDHwDWtKszMzFqj2U/1rNET+tlz/bivmZmtQpo94/+RpFuAy/P8ocDNrSnJbPXRqf8fMBuIvr5zdxtgbER8QdLfAbvnVfcCl7a6ODMzG3x9nfF/GzgJICKuA64DkPT2vO7AllZnZmaDrq9x+rER8VDtwrysuyUVmZlZS/UV/KN7WfeWwSzEzMzao6/gnybp47ULJR0NrMxXL5qZWYf1NcZ/HPADSUfwZtCPB9YifYOWmZmtZnoN/ohYALxH0t8AO+TFN0XET1pemZmZtUSz1+O/A7ijxbWYmVkb+L9vzcwK4+A3MyuMg9/MrDAOfjOzwjj4zcwK4+A3MyuMg9/MrDAOfjOzwjj4zcwK4+A3MyuMg9/MrDAtC35JF0haKOnhyrINJN0m6Tf55/qt6t/MzOpr5Rn/FGCfmmUnArdHxLbA7XnezMzaqGXBHxF3Ab+tWXwQcGGevhD4QKv6NzOz+to9xj82Iubn6WeBsY02lDRJ0jRJ0xYtWtSe6szMCtCxN3cjIoDoZf05ETE+IsZ3dXW1sTIzs6Gt3cG/QNLGAPnnwjb3b2ZWvHYH/1RgYp6eCFzf5v7NzIrXyo9zXg7cC2wnaZ6ko4DTgL+V9BtgrzxvZmZt1NR37q6MiDi8wao9W9WnmZn1zf+5a2ZWGAe/mVlhHPxmZoVx8JuZFcbBb2ZWGAe/mVlhHPxmZoVx8JuZFcbBb2ZWGAe/mVlhHPxmZoVx8JuZFcbBb2ZWGAe/mVlhHPxmZoVx8JuZFcbBb2ZWGAe/mVlhHPxmZoVx8JuZFcbBb2ZWGAe/mVlhHPxmZoVx8JuZFcbBb2ZWGAe/mVlhHPxmZoVx8JuZFcbBb2ZWmOGd6FTSHGAJ8BqwLCLGd6IOM7MSdST4s7+JiMUd7N/MrEge6jEzK0ynzvgDuFVSAN+PiHNqN5A0CZgEMG7cuDaXZ2arou4Tb+pIv3NO278j/bZKp874d4+IdwL7Ap+W9N7aDSLinIgYHxHju7q62l+hmdkQ1ZHgj4in88+FwA+Ad3WiDjOzErU9+CWNkDSqZxrYG3i43XWYmZWqE2P8Y4EfSOrp/7KI+FEH6jAzK1Lbgz8iZgPvaHe/ZmaW+OOcZmaFcfCbmRXGwW9mVhgHv5lZYRz8ZmaFcfCbmRXGwW9mVhgHv5lZYRz8ZmaFcfCbmRWmk9/AZWaroU5dE98Gj8/4zcwK4+A3MyuMg9/MrDAOfjOzwjj4zcwK4+A3MyvMkP84Zyc/ejbntP071reZDZ6hliM+4zczK4yD38ysMA5+M7PCOPjNzArj4DczK4yD38ysMA5+M7PCOPjNzArj4DczK4yD38ysMA5+M7PCOPjNzArTkeCXtI+kxyQ9LunETtRgZlaqtge/pGHAfwH7AtsDh0vavt11mJmVqhNn/O8CHo+I2RHxKnAFcFAH6jAzK1Inrse/KTC3Mj8PeHftRpImAZPy7FJJj61kf2OAxSt53wHR6Z3otaGO7YdViPdB4v2wGu2DAebIFvUWrrJfxBIR5wDnDLQdSdMiYvwglLRa837wPujh/eB90ImhnqeBzSvzm+VlZmbWBp0I/v8FtpW0paS1gMOAqR2ow8ysSG0f6omIZZI+A9wCDAMuiIhHWtjlgIeLhgjvB++DHt4Phe8DRUSnazAzszbyf+6amRXGwW9mVpghFfySNpd0h6RHJT0i6di8fANJt0n6Tf65fqdrbTVJwyT9UtKNeX5LSffly2Rcmd9YH9IkjZZ0jaRfSZoladfSHguSPpf/Fh6WdLmkdUp4LEi6QNJCSQ9XltU99krOyvvjQUnv7Fzl7TGkgh9YBhwfEdsDuwCfzpeDOBG4PSK2BW7P80PdscCsyvzpwLciYhvgd8BRHamqvf4D+FFEvA14B2l/FPNYkLQp8FlgfETsQPowxWGU8ViYAuxTs6zRsd8X2DbfJgFnt6nGjhlSwR8R8yNiRp5eQvpD35R0SYgL82YXAh/oTIXtIWkzYH/gvDwvYA/gmrxJCftgPeC9wPkAEfFqRDxPYY8F0if33iJpOLAuMJ8CHgsRcRfw25rFjY79QcBFkfwCGC1p4/ZU2hlDKvirJHUDOwH3AWMjYn5e9SwwtkNltcu3gS8Cr+f5DYHnI2JZnp9HekIcyrYEFgH/nYe8zpM0goIeCxHxNHAG8BQp8F8AplPeY6FHo2Nf7zIyQ3qfDMnglzQSuBY4LiJerK6L9PnVIfsZVkkHAAsjYnqna+mw4cA7gbMjYifgJWqGdQp4LKxPOpvdEtgEGMGKwx9FGurHvi9DLvglrUkK/Usj4rq8eEHPS7f8c2Gn6muD3YD3S5pDuvLpHqSx7tH55T6UcZmMecC8iLgvz19DeiIo6bGwF/BERCyKiD8C15EeH6U9Fno0OvbFXUZmSAV/Hss+H5gVEWdWVk0FJubpicD17a6tXSLipIjYLCK6SW/k/SQijgDuAA7Omw3pfQAQEc8CcyVtlxftCTxKQY8F0hDPLpLWzX8bPfugqMdCRaNjPxX4h/zpnl2AFypDQkPSkPrPXUm7A3cDD/Hm+PaXSeP8VwHjgCeBQyKi9o2fIUfSBOCEiDhA0lakVwAbAL8EPhIRr3SyvlaTtCPpDe61gNnAkaSTnWIeC5L+FTiU9Im3XwJHk8avh/RjQdLlwATS5ZcXAP8C/JA6xz4/KX6HNAz2MnBkREzrRN3tMqSC38zM+jakhnrMzKxvDn4zs8I4+M3MCuPgNzMrjIPfzKwwDv5CSNpQ0sx8e1bS05X5VerqjJImSHpPC9v/+QDu21294uOqKF+F80FJn+tlmymSDm60foD9z5E0ph/bj5d0Vp5u6bG3pO1fvWidERHPATsCSJoMLI2IMzpVj6ThlevF1JoALAWaDug+2ltORKwSwSJpWES8NshtbgTsnK+8OdC2mt6nA5E/M9/zufkJ9PPYW//5jL9gkv5S0k8lTZd0S+Xf2e+U9C1J0/J17HeWdF2+jvmpeZvufJ37S/M210hat4l2vy1pGnCspAPzdeF/KenHksbmi+t9EvhcfjXyV7Vnp5KW5p8TJN0taSrwqNJ3EHxD0v/mM95PNPi9q/e/U29es//S/M889fbTA5IeAD5dWV63P0lrSPpubvM2STf31J/Phk+XNAP4kKS9Jd0raYakq5WuM9XbPvys0vdNPCjpijq/3q3AppV99/Fc3wOSru05Rtl7Jf1c0uxKfU3t0yb23TH5d3pI0tvyfUYoXSf//nzMD6q0dWO9Y1/v+NkgiAjfCrsBk4EvkM6quvKyQ0lffA9wJ3B6nj4WeAbYGFibdA2cDYFu0kWudsvbXQCcAKzZR7vfrdSxPm/+E+HRwDcr9Z1Q2W4KcHBlfmn+OYF08bUt8/wk4JQ8vTbpLHLLOr9/9f4vkK7NsgZwL7B7ne0fBN6bp78BPNxbf6TLIdyc29yIdM37g/N2c4Av5ukxwF3AiDz/JeCf+9iHzwBr5+nRdWrt7qkvz29YmT4VOKayT6/ONW4PPN6ffdrbvsu/Y08/nwLOy9P/TvovYYDRwK9JF46bANxY79j71pqbh3rKtTawA3BbPlEbRrp0b4+p+edDwCORr10iaTbpglbPA3Mj4p683SWkL/34UR/tXlmZ3gy4Mp/NrgU8sRK/x/0R0XO/vYG/qLw6WI/05Rq9tXt/RMzLv9tMUnD+rGelpNGkgL0rL7qY9MUdvfW3O3B1RLwOPCvpjpo+e/bBLqTQvSfvq7VIAbodjffhg8Clkn5IugRBX3bIr9JGAyOBWyrrfphrfFRS9fLUzezTV+l93/VcIHE68HeVtt4v6YQ8vw7p8gnWZg7+cokU6Ls2WN9z7ZbXK9M98z2Pm9rrfUQT7b5Umf5P4MyImKp0XaHJDe6zjDwsKWkNUkDWa0+kM81quPWl+ru9Rv/+Jur2J2m/Pu7XU7OA2yLi8Jr7v53G+3B/0hfMHAicLOnt0fs4/BTgAxHxgKSPkc6ue1R/9+owTZ/7NB+v3vbdK3WWC/j7iHispq0h+50IqyqP8ZfrFaBL0q6QLmct6c/72ca4nvsDHyad7T3Wj3bX483L306sLF8CjKrMzwH+Mk+/nzQUUs8twD8pXZobSW9V+vKVlRbpW7ueV7oAIMARTfR3D/D3eax/LMuHbdUvgN0kbZPvP0LSW2mwD/OT3uYRcQdpWGg90ll8b0YB83ONR/SxbT2DuU9vIY39K7e1U51tao+9tYCDv1yvk8aiT89vWs4E+vtpl8dI32s8izRef3ZEvNqPdicDV0uaDiyuLL8B+GDlDb5zgb/O7e3K8mekVeeRLjs8Q+kjl99ncF7VHgn8Vx7OqJ4ZN+rvWtJ7IY+ShsBmkMbDlxMRi4CPAZdLepA0zPO2XvbhMOASSQ+Rrqp5Vn5i6s1XSFenvQf4Vf9/9UHdp18lPWk/KOmRPF+r9thbC/jqnLZS8icwboz0Jd5WQ9LIiFgqaUPgftKb4M92ui4z8Bi/WavcmN8YXgv4qkPfViU+4zczK4zH+M3MCuPgNzMrjIPfzKwwDn4zs8I4+M3MCvP/+rw7Opa0/hoAAAAASUVORK5CYII=\n"
          },
          "metadata": {
            "needs_background": "light"
          }
        }
      ],
      "source": [
        "# create a histogram to visualize the distribution of temperature values in F\n",
        "plt.hist(Temp_data[\"Temperature\"])\n",
        "plt.title(\"Distribution of Temperature values\")\n",
        "plt.xlabel(\"Temperature in degrees fahrenheit\")\n",
        "plt.ylabel(\"Count\")\n",
        "plt.show()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "GBhkBf0ne2SO"
      },
      "source": [
        "Simple Random Sampling"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 29,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 676
        },
        "id": "LVqhAFKve2SP",
        "outputId": "dcaa36ac-e8b3-483b-8c73-5985740112bd"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                     Timestamp                             Email  \\\n",
              "45  2022/06/25 12:37:12 PM MDT      nwaodorifechukwude@gmail.com   \n",
              "28  2022/06/25 12:12:27 PM MDT        samanthaerskine1@gmail.com   \n",
              "29  2022/06/25 12:12:56 PM MDT            roseheromini@gmail.com   \n",
              "55  2022/06/25 12:49:41 PM MDT               r.adeagbo@gmail.com   \n",
              "63  2022/06/25 12:59:58 PM MDT            kamisandra22@gmail.com   \n",
              "31  2022/06/25 12:14:39 PM MDT      sobowalemoyinoluwa@gmail.com   \n",
              "51  2022/06/25 12:41:04 PM MDT         janice.gbedemah@gmail.com   \n",
              "46  2022/06/25 12:37:30 PM MDT        yvonneakinyi1997@gmail.com   \n",
              "34  2022/06/25 12:19:03 PM MDT             ednadzottsi@gmail.com   \n",
              "4   2022/06/25 12:00:01 PM MDT           winfredplt583@gmail.com   \n",
              "35  2022/06/25 12:19:22 PM MDT           chrissyosei12@gmail.com   \n",
              "40  2022/06/25 12:34:39 PM MDT           Waakaeloveday@gmail.com   \n",
              "33  2022/06/25 12:17:29 PM MDT           winniekiprono@gmail.com   \n",
              "48  2022/06/25 12:39:21 PM MDT               adebimpew@gmail.com   \n",
              "65   2022/06/25 1:26:49 PM MDT           adeoolarhneye@gmail.com   \n",
              "2   2022/06/25 11:58:02 AM MDT         maryannmwangi36@gmail.com   \n",
              "11  2022/06/25 12:03:40 PM MDT           annakarungi15@gmail.com   \n",
              "30  2022/06/25 12:14:16 PM MDT            edithngozi01@gmail.com   \n",
              "10  2022/06/25 12:03:23 PM MDT  oluwatobiibironkeoluwa@gmail.com   \n",
              "22  2022/06/25 12:09:32 PM MDT               iryntracy@gmail.com   \n",
              "\n",
              "                           Name  Temperature Metrics  \n",
              "45  Nwaodor ifechukwude destiny         95.0       C  \n",
              "28             Samantha Erskine         78.8       C  \n",
              "29          Rozi Hieromini Mlay         75.2       C  \n",
              "55              Roselyn Adeagbo         84.2       C  \n",
              "63             Sandra Kamikazi          71.6       C  \n",
              "31          Moyinoluwa Sobowale         82.4       C  \n",
              "51         Janice Afi Gbedemah          70.0       F  \n",
              "46        Yvonne Akinyi Okello          64.4       C  \n",
              "34         EDNA SEYRAM DZOTTSI          78.8       C  \n",
              "4                Winfred Apolot         68.0       C  \n",
              "35      Christiana Osei Hwedie          80.6       C  \n",
              "40      Inaania Waakae Loveday          25.0       F  \n",
              "33    Winnie Chepchirchir Rono          60.8       C  \n",
              "48              Adebimpe Wahab          80.6       C  \n",
              "65             Tolulope Adeneye         80.6       C  \n",
              "2               Maryann Mwangi          66.2       C  \n",
              "11                 Karungi Anna         68.0       C  \n",
              "30          Edith Ngozi Anyogu         113.0       C  \n",
              "10              Oluwatobi Oluwa         80.6       C  \n",
              "22             Irene Nakiyingi          82.4       C  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-0a57ae3c-6fb6-4aba-8de5-e4327eaa883b\">\n",
              "    <div 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>Email</th>\n",
              "      <th>Name</th>\n",
              "      <th>Temperature</th>\n",
              "      <th>Metrics</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>2022/06/25 12:37:12 PM MDT</td>\n",
              "      <td>nwaodorifechukwude@gmail.com</td>\n",
              "      <td>Nwaodor ifechukwude destiny</td>\n",
              "      <td>95.0</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>2022/06/25 12:12:27 PM MDT</td>\n",
              "      <td>samanthaerskine1@gmail.com</td>\n",
              "      <td>Samantha Erskine</td>\n",
              "      <td>78.8</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2022/06/25 12:12:56 PM MDT</td>\n",
              "      <td>roseheromini@gmail.com</td>\n",
              "      <td>Rozi Hieromini Mlay</td>\n",
              "      <td>75.2</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>55</th>\n",
              "      <td>2022/06/25 12:49:41 PM MDT</td>\n",
              "      <td>r.adeagbo@gmail.com</td>\n",
              "      <td>Roselyn Adeagbo</td>\n",
              "      <td>84.2</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>2022/06/25 12:59:58 PM MDT</td>\n",
              "      <td>kamisandra22@gmail.com</td>\n",
              "      <td>Sandra Kamikazi</td>\n",
              "      <td>71.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>2022/06/25 12:14:39 PM MDT</td>\n",
              "      <td>sobowalemoyinoluwa@gmail.com</td>\n",
              "      <td>Moyinoluwa Sobowale</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>51</th>\n",
              "      <td>2022/06/25 12:41:04 PM MDT</td>\n",
              "      <td>janice.gbedemah@gmail.com</td>\n",
              "      <td>Janice Afi Gbedemah</td>\n",
              "      <td>70.0</td>\n",
              "      <td>F</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>2022/06/25 12:37:30 PM MDT</td>\n",
              "      <td>yvonneakinyi1997@gmail.com</td>\n",
              "      <td>Yvonne Akinyi Okello</td>\n",
              "      <td>64.4</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>2022/06/25 12:19:03 PM MDT</td>\n",
              "      <td>ednadzottsi@gmail.com</td>\n",
              "      <td>EDNA SEYRAM DZOTTSI</td>\n",
              "      <td>78.8</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2022/06/25 12:00:01 PM MDT</td>\n",
              "      <td>winfredplt583@gmail.com</td>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>68.0</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>2022/06/25 12:19:22 PM MDT</td>\n",
              "      <td>chrissyosei12@gmail.com</td>\n",
              "      <td>Christiana Osei Hwedie</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>2022/06/25 12:34:39 PM MDT</td>\n",
              "      <td>Waakaeloveday@gmail.com</td>\n",
              "      <td>Inaania Waakae Loveday</td>\n",
              "      <td>25.0</td>\n",
              "      <td>F</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>2022/06/25 12:17:29 PM MDT</td>\n",
              "      <td>winniekiprono@gmail.com</td>\n",
              "      <td>Winnie Chepchirchir Rono</td>\n",
              "      <td>60.8</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>2022/06/25 12:39:21 PM MDT</td>\n",
              "      <td>adebimpew@gmail.com</td>\n",
              "      <td>Adebimpe Wahab</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>2022/06/25 1:26:49 PM MDT</td>\n",
              "      <td>adeoolarhneye@gmail.com</td>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2022/06/25 11:58:02 AM MDT</td>\n",
              "      <td>maryannmwangi36@gmail.com</td>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>66.2</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>2022/06/25 12:03:40 PM MDT</td>\n",
              "      <td>annakarungi15@gmail.com</td>\n",
              "      <td>Karungi Anna</td>\n",
              "      <td>68.0</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>2022/06/25 12:14:16 PM MDT</td>\n",
              "      <td>edithngozi01@gmail.com</td>\n",
              "      <td>Edith Ngozi Anyogu</td>\n",
              "      <td>113.0</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>2022/06/25 12:03:23 PM MDT</td>\n",
              "      <td>oluwatobiibironkeoluwa@gmail.com</td>\n",
              "      <td>Oluwatobi Oluwa</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>2022/06/25 12:09:32 PM MDT</td>\n",
              "      <td>iryntracy@gmail.com</td>\n",
              "      <td>Irene Nakiyingi</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-0a57ae3c-6fb6-4aba-8de5-e4327eaa883b')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-0a57ae3c-6fb6-4aba-8de5-e4327eaa883b 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-0a57ae3c-6fb6-4aba-8de5-e4327eaa883b');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ],
      "source": [
        "Temp_data.sample(n=20, random_state=0)"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "lhtSZnKCe2SP"
      },
      "source": [
        "       Working with data from Poll 2"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from google.colab import files\n",
        "uploaded = files.upload()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 73
        },
        "id": "_wefWRAQf2hI",
        "outputId": "1da9f0d3-23f3-49fd-9219-6c322f1026d9"
      },
      "execution_count": 30,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<IPython.core.display.HTML object>"
            ],
            "text/html": [
              "\n",
              "     <input type=\"file\" id=\"files-c12567db-8145-402a-bb7b-445b5cb27935\" name=\"files[]\" multiple disabled\n",
              "        style=\"border:none\" />\n",
              "     <output id=\"result-c12567db-8145-402a-bb7b-445b5cb27935\">\n",
              "      Upload widget is only available when the cell has been executed in the\n",
              "      current browser session. Please rerun this cell to enable.\n",
              "      </output>\n",
              "      <script>// Copyright 2017 Google LLC\n",
              "//\n",
              "// Licensed under the Apache License, Version 2.0 (the \"License\");\n",
              "// you may not use this file except in compliance with the License.\n",
              "// You may obtain a copy of the License at\n",
              "//\n",
              "//      http://www.apache.org/licenses/LICENSE-2.0\n",
              "//\n",
              "// Unless required by applicable law or agreed to in writing, software\n",
              "// distributed under the License is distributed on an \"AS IS\" BASIS,\n",
              "// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.\n",
              "// See the License for the specific language governing permissions and\n",
              "// limitations under the License.\n",
              "\n",
              "/**\n",
              " * @fileoverview Helpers for google.colab Python module.\n",
              " */\n",
              "(function(scope) {\n",
              "function span(text, styleAttributes = {}) {\n",
              "  const element = document.createElement('span');\n",
              "  element.textContent = text;\n",
              "  for (const key of Object.keys(styleAttributes)) {\n",
              "    element.style[key] = styleAttributes[key];\n",
              "  }\n",
              "  return element;\n",
              "}\n",
              "\n",
              "// Max number of bytes which will be uploaded at a time.\n",
              "const MAX_PAYLOAD_SIZE = 100 * 1024;\n",
              "\n",
              "function _uploadFiles(inputId, outputId) {\n",
              "  const steps = uploadFilesStep(inputId, outputId);\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  // Cache steps on the outputElement to make it available for the next call\n",
              "  // to uploadFilesContinue from Python.\n",
              "  outputElement.steps = steps;\n",
              "\n",
              "  return _uploadFilesContinue(outputId);\n",
              "}\n",
              "\n",
              "// This is roughly an async generator (not supported in the browser yet),\n",
              "// where there are multiple asynchronous steps and the Python side is going\n",
              "// to poll for completion of each step.\n",
              "// This uses a Promise to block the python side on completion of each step,\n",
              "// then passes the result of the previous step as the input to the next step.\n",
              "function _uploadFilesContinue(outputId) {\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  const steps = outputElement.steps;\n",
              "\n",
              "  const next = steps.next(outputElement.lastPromiseValue);\n",
              "  return Promise.resolve(next.value.promise).then((value) => {\n",
              "    // Cache the last promise value to make it available to the next\n",
              "    // step of the generator.\n",
              "    outputElement.lastPromiseValue = value;\n",
              "    return next.value.response;\n",
              "  });\n",
              "}\n",
              "\n",
              "/**\n",
              " * Generator function which is called between each async step of the upload\n",
              " * process.\n",
              " * @param {string} inputId Element ID of the input file picker element.\n",
              " * @param {string} outputId Element ID of the output display.\n",
              " * @return {!Iterable<!Object>} Iterable of next steps.\n",
              " */\n",
              "function* uploadFilesStep(inputId, outputId) {\n",
              "  const inputElement = document.getElementById(inputId);\n",
              "  inputElement.disabled = false;\n",
              "\n",
              "  const outputElement = document.getElementById(outputId);\n",
              "  outputElement.innerHTML = '';\n",
              "\n",
              "  const pickedPromise = new Promise((resolve) => {\n",
              "    inputElement.addEventListener('change', (e) => {\n",
              "      resolve(e.target.files);\n",
              "    });\n",
              "  });\n",
              "\n",
              "  const cancel = document.createElement('button');\n",
              "  inputElement.parentElement.appendChild(cancel);\n",
              "  cancel.textContent = 'Cancel upload';\n",
              "  const cancelPromise = new Promise((resolve) => {\n",
              "    cancel.onclick = () => {\n",
              "      resolve(null);\n",
              "    };\n",
              "  });\n",
              "\n",
              "  // Wait for the user to pick the files.\n",
              "  const files = yield {\n",
              "    promise: Promise.race([pickedPromise, cancelPromise]),\n",
              "    response: {\n",
              "      action: 'starting',\n",
              "    }\n",
              "  };\n",
              "\n",
              "  cancel.remove();\n",
              "\n",
              "  // Disable the input element since further picks are not allowed.\n",
              "  inputElement.disabled = true;\n",
              "\n",
              "  if (!files) {\n",
              "    return {\n",
              "      response: {\n",
              "        action: 'complete',\n",
              "      }\n",
              "    };\n",
              "  }\n",
              "\n",
              "  for (const file of files) {\n",
              "    const li = document.createElement('li');\n",
              "    li.append(span(file.name, {fontWeight: 'bold'}));\n",
              "    li.append(span(\n",
              "        `(${file.type || 'n/a'}) - ${file.size} bytes, ` +\n",
              "        `last modified: ${\n",
              "            file.lastModifiedDate ? file.lastModifiedDate.toLocaleDateString() :\n",
              "                                    'n/a'} - `));\n",
              "    const percent = span('0% done');\n",
              "    li.appendChild(percent);\n",
              "\n",
              "    outputElement.appendChild(li);\n",
              "\n",
              "    const fileDataPromise = new Promise((resolve) => {\n",
              "      const reader = new FileReader();\n",
              "      reader.onload = (e) => {\n",
              "        resolve(e.target.result);\n",
              "      };\n",
              "      reader.readAsArrayBuffer(file);\n",
              "    });\n",
              "    // Wait for the data to be ready.\n",
              "    let fileData = yield {\n",
              "      promise: fileDataPromise,\n",
              "      response: {\n",
              "        action: 'continue',\n",
              "      }\n",
              "    };\n",
              "\n",
              "    // Use a chunked sending to avoid message size limits. See b/62115660.\n",
              "    let position = 0;\n",
              "    do {\n",
              "      const length = Math.min(fileData.byteLength - position, MAX_PAYLOAD_SIZE);\n",
              "      const chunk = new Uint8Array(fileData, position, length);\n",
              "      position += length;\n",
              "\n",
              "      const base64 = btoa(String.fromCharCode.apply(null, chunk));\n",
              "      yield {\n",
              "        response: {\n",
              "          action: 'append',\n",
              "          file: file.name,\n",
              "          data: base64,\n",
              "        },\n",
              "      };\n",
              "\n",
              "      let percentDone = fileData.byteLength === 0 ?\n",
              "          100 :\n",
              "          Math.round((position / fileData.byteLength) * 100);\n",
              "      percent.textContent = `${percentDone}% done`;\n",
              "\n",
              "    } while (position < fileData.byteLength);\n",
              "  }\n",
              "\n",
              "  // All done.\n",
              "  yield {\n",
              "    response: {\n",
              "      action: 'complete',\n",
              "    }\n",
              "  };\n",
              "}\n",
              "\n",
              "scope.google = scope.google || {};\n",
              "scope.google.colab = scope.google.colab || {};\n",
              "scope.google.colab._files = {\n",
              "  _uploadFiles,\n",
              "  _uploadFilesContinue,\n",
              "};\n",
              "})(self);\n",
              "</script> "
            ]
          },
          "metadata": {}
        },
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Saving 25June2022_Poll2.xlsx to 25June2022_Poll2.xlsx\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 31,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "XpQCw-oOe2SP",
        "outputId": "a815c222-b2f1-41a6-a68b-02937b73cb7e"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   What is your favorite meal of the day typically? Unnamed: 1 Unnamed: 2  \\\n",
              "0           https://strawpoll.com/polls/X3nk6NdxVyE        NaN        NaN   \n",
              "1                                               NaN        NaN        NaN   \n",
              "2                                    Answer Options      Votes    Percent   \n",
              "3                                         Breakfast         30     48.39%   \n",
              "4                                             Lunch         22     35.48%   \n",
              "..                                              ...        ...        ...   \n",
              "67                                    Jane Ndambuki          0          0   \n",
              "68                              Modupeoluwa Adedeji          1          0   \n",
              "69                                  Yvanie KAMIKAZI          1          0   \n",
              "70                                 Tolulope Adeneye          0          0   \n",
              "71                                    Total ✓ Votes         30         22   \n",
              "\n",
              "   Unnamed: 3  \n",
              "0         NaN  \n",
              "1         NaN  \n",
              "2         NaN  \n",
              "3         NaN  \n",
              "4         NaN  \n",
              "..        ...  \n",
              "67          1  \n",
              "68          0  \n",
              "69          0  \n",
              "70          1  \n",
              "71         10  \n",
              "\n",
              "[72 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ebe27818-b705-47d4-a49c-0147c20ccf3f\">\n",
              "    <div 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>What is your favorite meal of the day typically?</th>\n",
              "      <th>Unnamed: 1</th>\n",
              "      <th>Unnamed: 2</th>\n",
              "      <th>Unnamed: 3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>https://strawpoll.com/polls/X3nk6NdxVyE</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Answer Options</td>\n",
              "      <td>Votes</td>\n",
              "      <td>Percent</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Breakfast</td>\n",
              "      <td>30</td>\n",
              "      <td>48.39%</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Lunch</td>\n",
              "      <td>22</td>\n",
              "      <td>35.48%</td>\n",
              "      <td>NaN</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>67</th>\n",
              "      <td>Jane Ndambuki</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>Modupeoluwa Adedeji</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>Yvanie KAMIKAZI</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71</th>\n",
              "      <td>Total ✓ Votes</td>\n",
              "      <td>30</td>\n",
              "      <td>22</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>72 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ebe27818-b705-47d4-a49c-0147c20ccf3f')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-ebe27818-b705-47d4-a49c-0147c20ccf3f 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-ebe27818-b705-47d4-a49c-0147c20ccf3f');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ],
      "source": [
        "Meal_data = pd.read_excel(\"25June2022_Poll2.xlsx\")\n",
        "Meal_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 32,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "dNzwD13se2SP",
        "outputId": "9736dd2e-125f-46da-ad61-5bfdf4bc39fb"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "  What is your favorite meal of the day typically? Unnamed: 1 Unnamed: 2  \\\n",
              "0          https://strawpoll.com/polls/X3nk6NdxVyE        NaN        NaN   \n",
              "1                                              NaN        NaN        NaN   \n",
              "2                                   Answer Options      Votes    Percent   \n",
              "3                                        Breakfast         30     48.39%   \n",
              "4                                            Lunch         22     35.48%   \n",
              "5                                           Dinner         10     16.13%   \n",
              "6                                      Total Votes         62       100%   \n",
              "7                                              NaN        NaN        NaN   \n",
              "8                                             Name  Breakfast      Lunch   \n",
              "9                                Oluwaseyi Olukemi          0          1   \n",
              "\n",
              "  Unnamed: 3  \n",
              "0        NaN  \n",
              "1        NaN  \n",
              "2        NaN  \n",
              "3        NaN  \n",
              "4        NaN  \n",
              "5        NaN  \n",
              "6        NaN  \n",
              "7        NaN  \n",
              "8     Dinner  \n",
              "9          0  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fa128255-e8dd-4434-8d6e-002281376bc1\">\n",
              "    <div 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>What is your favorite meal of the day typically?</th>\n",
              "      <th>Unnamed: 1</th>\n",
              "      <th>Unnamed: 2</th>\n",
              "      <th>Unnamed: 3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>https://strawpoll.com/polls/X3nk6NdxVyE</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Answer Options</td>\n",
              "      <td>Votes</td>\n",
              "      <td>Percent</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Breakfast</td>\n",
              "      <td>30</td>\n",
              "      <td>48.39%</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Lunch</td>\n",
              "      <td>22</td>\n",
              "      <td>35.48%</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>Dinner</td>\n",
              "      <td>10</td>\n",
              "      <td>16.13%</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>Total Votes</td>\n",
              "      <td>62</td>\n",
              "      <td>100%</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>Name</td>\n",
              "      <td>Breakfast</td>\n",
              "      <td>Lunch</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fa128255-e8dd-4434-8d6e-002281376bc1')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-fa128255-e8dd-4434-8d6e-002281376bc1 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-fa128255-e8dd-4434-8d6e-002281376bc1');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 32
        }
      ],
      "source": [
        "Meal_data.head(10)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 33,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Pupmu0cbe2SP",
        "outputId": "5a86c7a8-81ce-4ef1-d680-9d9d0790ec75"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "array(['Name', 'Breakfast', 'Lunch', 'Dinner'], dtype=object)"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ],
      "source": [
        "Meal_data.iloc[8].values"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 34,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "bxAfHeHTe2SQ",
        "outputId": "a007fb98-6f6c-4871-e83c-4cc322f3e7ad"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   What is your favorite meal of the day typically? Unnamed: 1 Unnamed: 2  \\\n",
              "62                    Esther Ugochukwu Amaka Okolie          0          1   \n",
              "63                                Gertrude Abarinde          0          1   \n",
              "64                                  Roselyn Adeagbo          1          0   \n",
              "65                                Victoria Bamikole          1          0   \n",
              "66                                   Fiona Masagbor          1          0   \n",
              "67                                    Jane Ndambuki          0          0   \n",
              "68                              Modupeoluwa Adedeji          1          0   \n",
              "69                                  Yvanie KAMIKAZI          1          0   \n",
              "70                                 Tolulope Adeneye          0          0   \n",
              "71                                    Total ✓ Votes         30         22   \n",
              "\n",
              "   Unnamed: 3  \n",
              "62          0  \n",
              "63          0  \n",
              "64          0  \n",
              "65          0  \n",
              "66          0  \n",
              "67          1  \n",
              "68          0  \n",
              "69          0  \n",
              "70          1  \n",
              "71         10  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b9db9c88-b583-4eef-b29f-df9273790648\">\n",
              "    <div 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>What is your favorite meal of the day typically?</th>\n",
              "      <th>Unnamed: 1</th>\n",
              "      <th>Unnamed: 2</th>\n",
              "      <th>Unnamed: 3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>62</th>\n",
              "      <td>Esther Ugochukwu Amaka Okolie</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>63</th>\n",
              "      <td>Gertrude Abarinde</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>64</th>\n",
              "      <td>Roselyn Adeagbo</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>65</th>\n",
              "      <td>Victoria Bamikole</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>66</th>\n",
              "      <td>Fiona Masagbor</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>Jane Ndambuki</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>Modupeoluwa Adedeji</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>Yvanie KAMIKAZI</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>71</th>\n",
              "      <td>Total ✓ Votes</td>\n",
              "      <td>30</td>\n",
              "      <td>22</td>\n",
              "      <td>10</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b9db9c88-b583-4eef-b29f-df9273790648')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-b9db9c88-b583-4eef-b29f-df9273790648 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-b9db9c88-b583-4eef-b29f-df9273790648');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 34
        }
      ],
      "source": [
        "Meal_data.tail(10)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 35,
      "metadata": {
        "id": "NWE91r5ee2SQ"
      },
      "outputs": [],
      "source": [
        "# let's start cleaning\n",
        "# select just all the rows corresponding to individual respondents, \n",
        "# and put the resulting dataframe into a new variable\n",
        "Meal_data_cleaned = Meal_data.iloc[9:71]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 36,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "s7YOtGrje2SQ",
        "outputId": "aad294b5-3b01-4e52-eb91-802ce491dc8f"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "   What is your favorite meal of the day typically? Unnamed: 1 Unnamed: 2  \\\n",
              "9                                 Oluwaseyi Olukemi          0          1   \n",
              "10                         Ajayi Elizabeth Damilola          0          1   \n",
              "11                                   Maryann Mwangi          1          0   \n",
              "12                           Oreoluwa Jimi-Shotunde          1          0   \n",
              "13                                   Winfred Apolot          0          1   \n",
              "..                                              ...        ...        ...   \n",
              "66                                   Fiona Masagbor          1          0   \n",
              "67                                    Jane Ndambuki          0          0   \n",
              "68                              Modupeoluwa Adedeji          1          0   \n",
              "69                                  Yvanie KAMIKAZI          1          0   \n",
              "70                                 Tolulope Adeneye          0          0   \n",
              "\n",
              "   Unnamed: 3  \n",
              "9           0  \n",
              "10          0  \n",
              "11          0  \n",
              "12          0  \n",
              "13          0  \n",
              "..        ...  \n",
              "66          0  \n",
              "67          1  \n",
              "68          0  \n",
              "69          0  \n",
              "70          1  \n",
              "\n",
              "[62 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-00fa0c22-02e3-442b-8c5d-694ade84bb23\">\n",
              "    <div 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>What is your favorite meal of the day typically?</th>\n",
              "      <th>Unnamed: 1</th>\n",
              "      <th>Unnamed: 2</th>\n",
              "      <th>Unnamed: 3</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Ajayi Elizabeth Damilola</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</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>66</th>\n",
              "      <td>Fiona Masagbor</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>Jane Ndambuki</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>Modupeoluwa Adedeji</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>Yvanie KAMIKAZI</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>62 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-00fa0c22-02e3-442b-8c5d-694ade84bb23')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-00fa0c22-02e3-442b-8c5d-694ade84bb23 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-00fa0c22-02e3-442b-8c5d-694ade84bb23');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 36
        }
      ],
      "source": [
        "Meal_data_cleaned"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 37,
      "metadata": {
        "id": "j_2IlDjpe2SQ"
      },
      "outputs": [],
      "source": [
        "# rename the columns\n",
        "Meal_data_cleaned = Meal_data_cleaned.rename(columns={\"What is your favorite meal of the day typically?\":\"Name\",\n",
        "                                                     \"Unnamed: 1\":\"Breakfast\",\n",
        "                                                     \"Unnamed: 2\":\"Lunch\",\n",
        "                                                     \"Unnamed: 3\":\"Dinner\"})\n"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 38,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "MIg-DyGte2SR",
        "outputId": "ba9fe376-02c7-40a2-bfb0-ebfdeadcf2ec"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                        Name Breakfast Lunch Dinner\n",
              "9          Oluwaseyi Olukemi         0     1      0\n",
              "10  Ajayi Elizabeth Damilola         0     1      0\n",
              "11            Maryann Mwangi         1     0      0\n",
              "12    Oreoluwa Jimi-Shotunde         1     0      0\n",
              "13            Winfred Apolot         0     1      0\n",
              "..                       ...       ...   ...    ...\n",
              "66            Fiona Masagbor         1     0      0\n",
              "67             Jane Ndambuki         0     0      1\n",
              "68       Modupeoluwa Adedeji         1     0      0\n",
              "69           Yvanie KAMIKAZI         1     0      0\n",
              "70          Tolulope Adeneye         0     0      1\n",
              "\n",
              "[62 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-8f888616-d8d7-4e4e-9e2e-2b0faf7593c0\">\n",
              "    <div 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>Name</th>\n",
              "      <th>Breakfast</th>\n",
              "      <th>Lunch</th>\n",
              "      <th>Dinner</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>Ajayi Elizabeth Damilola</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</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>66</th>\n",
              "      <td>Fiona Masagbor</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>67</th>\n",
              "      <td>Jane Ndambuki</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>68</th>\n",
              "      <td>Modupeoluwa Adedeji</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69</th>\n",
              "      <td>Yvanie KAMIKAZI</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>70</th>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>62 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-8f888616-d8d7-4e4e-9e2e-2b0faf7593c0')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-8f888616-d8d7-4e4e-9e2e-2b0faf7593c0 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-8f888616-d8d7-4e4e-9e2e-2b0faf7593c0');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 38
        }
      ],
      "source": [
        "Meal_data_cleaned"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 39,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "tP3_O_VMe2SR",
        "outputId": "00612dd2-b2f3-45a8-d5f2-979c155e087e"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                        Name Breakfast Lunch Dinner\n",
              "0          Oluwaseyi Olukemi         0     1      0\n",
              "1   Ajayi Elizabeth Damilola         0     1      0\n",
              "2             Maryann Mwangi         1     0      0\n",
              "3     Oreoluwa Jimi-Shotunde         1     0      0\n",
              "4             Winfred Apolot         0     1      0\n",
              "..                       ...       ...   ...    ...\n",
              "57            Fiona Masagbor         1     0      0\n",
              "58             Jane Ndambuki         0     0      1\n",
              "59       Modupeoluwa Adedeji         1     0      0\n",
              "60           Yvanie KAMIKAZI         1     0      0\n",
              "61          Tolulope Adeneye         0     0      1\n",
              "\n",
              "[62 rows x 4 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-98c7ebea-0cec-4343-9677-a0a88026a485\">\n",
              "    <div 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>Name</th>\n",
              "      <th>Breakfast</th>\n",
              "      <th>Lunch</th>\n",
              "      <th>Dinner</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Ajayi Elizabeth Damilola</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</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>57</th>\n",
              "      <td>Fiona Masagbor</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>Jane Ndambuki</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>Modupeoluwa Adedeji</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>Yvanie KAMIKAZI</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>62 rows × 4 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-98c7ebea-0cec-4343-9677-a0a88026a485')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-98c7ebea-0cec-4343-9677-a0a88026a485 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-98c7ebea-0cec-4343-9677-a0a88026a485');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 39
        }
      ],
      "source": [
        "# reset the row indices of the cleaned dataframe and drop the existing row indices\n",
        "Meal_data_cleaned = Meal_data_cleaned.reset_index(drop=True)\n",
        "Meal_data_cleaned"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 40,
      "metadata": {
        "id": "05Ho0nIge2SR"
      },
      "outputs": [],
      "source": [
        "# create an empty list that we can use to store the preferred meal for each respondent\n",
        "Meal = []"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 41,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "pU2QkHRle2SR",
        "outputId": "524eec77-484a-445f-d504-bfc0bcab9eb7"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[]"
            ]
          },
          "metadata": {},
          "execution_count": 41
        }
      ],
      "source": [
        "Meal"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 42,
      "metadata": {
        "id": "jpwkZdVde2SR"
      },
      "outputs": [],
      "source": [
        "# for each row in the cleaned dataframe,\n",
        "# if the value in the Breakfast column is 1, add \"Breakfast\" to the meal list,\n",
        "# elif the value in the Lunch column is 1, add \"Lunch\" to the meal list,\n",
        "# else add \"Dinner\" to the meal list\n",
        "for i in range(0, 62):\n",
        "    row = Meal_data_cleaned.iloc[i]\n",
        "    if row[\"Breakfast\"] == 1:\n",
        "        Meal.append(\"Breakfast\")\n",
        "    elif row[\"Lunch\"] == 1:\n",
        "        Meal.append(\"Lunch\")\n",
        "    else:\n",
        "        Meal.append(\"Dinner\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 43,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "BHdlDS4Oe2SS",
        "outputId": "9da09a53-cece-40fa-f455-6bb3326b66f6"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "['Lunch',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Dinner',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Dinner',\n",
              " 'Breakfast',\n",
              " 'Dinner',\n",
              " 'Breakfast',\n",
              " 'Dinner',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Dinner',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Dinner',\n",
              " 'Lunch',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Lunch',\n",
              " 'Dinner',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Lunch',\n",
              " 'Dinner',\n",
              " 'Breakfast',\n",
              " 'Lunch',\n",
              " 'Lunch',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Dinner',\n",
              " 'Breakfast',\n",
              " 'Breakfast',\n",
              " 'Dinner']"
            ]
          },
          "metadata": {},
          "execution_count": 43
        }
      ],
      "source": [
        "# take a look at the meal list now\n",
        "Meal"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 44,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "nWYCHIm2e2SS",
        "outputId": "90fceddf-7a21-4a51-fc7f-accc6941b4d9"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "62"
            ]
          },
          "metadata": {},
          "execution_count": 44
        }
      ],
      "source": [
        "len(Meal)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 45,
      "metadata": {
        "id": "B9ojMAjXe2SS"
      },
      "outputs": [],
      "source": [
        "Meal_data_cleaned[\"Meal\"] = Meal"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 46,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 423
        },
        "id": "RhLi4-Nae2SS",
        "outputId": "f3276d0c-a6ae-4167-a9db-433b0fce2688"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                        Name Breakfast Lunch Dinner       Meal\n",
              "0          Oluwaseyi Olukemi         0     1      0      Lunch\n",
              "1   Ajayi Elizabeth Damilola         0     1      0      Lunch\n",
              "2             Maryann Mwangi         1     0      0  Breakfast\n",
              "3     Oreoluwa Jimi-Shotunde         1     0      0  Breakfast\n",
              "4             Winfred Apolot         0     1      0      Lunch\n",
              "..                       ...       ...   ...    ...        ...\n",
              "57            Fiona Masagbor         1     0      0  Breakfast\n",
              "58             Jane Ndambuki         0     0      1     Dinner\n",
              "59       Modupeoluwa Adedeji         1     0      0  Breakfast\n",
              "60           Yvanie KAMIKAZI         1     0      0  Breakfast\n",
              "61          Tolulope Adeneye         0     0      1     Dinner\n",
              "\n",
              "[62 rows x 5 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-603e8138-33f1-4f6e-9688-a5c8e49e563e\">\n",
              "    <div 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>Name</th>\n",
              "      <th>Breakfast</th>\n",
              "      <th>Lunch</th>\n",
              "      <th>Dinner</th>\n",
              "      <th>Meal</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Oluwaseyi Olukemi</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Ajayi Elizabeth Damilola</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Maryann Mwangi</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>57</th>\n",
              "      <td>Fiona Masagbor</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58</th>\n",
              "      <td>Jane Ndambuki</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>59</th>\n",
              "      <td>Modupeoluwa Adedeji</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>60</th>\n",
              "      <td>Yvanie KAMIKAZI</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>61</th>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>62 rows × 5 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-603e8138-33f1-4f6e-9688-a5c8e49e563e')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-603e8138-33f1-4f6e-9688-a5c8e49e563e 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-603e8138-33f1-4f6e-9688-a5c8e49e563e');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 46
        }
      ],
      "source": [
        "Meal_data_cleaned"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 47,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Eu4Xu_2Je2SS",
        "outputId": "ffb12235-ee41-41a5-cbe5-f7e0fb7ae48c"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Breakfast    30\n",
              "Lunch        22\n",
              "Dinner       10\n",
              "Name: Meal, dtype: int64"
            ]
          },
          "metadata": {},
          "execution_count": 47
        }
      ],
      "source": [
        "Meal_data_cleaned[\"Meal\"].value_counts()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 48,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 279
        },
        "id": "Swbn2JToe2SS",
        "outputId": "11930c12-1418-46f5-914f-2a9fc9e85839"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAEGCAYAAABiq/5QAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAARPklEQVR4nO3dfZBddX3H8feHBwV5EDBbRDAGEbWMlSArPmAtalG0raDVKlUMrW1sR6h2aGcYaxWtrVZRxqLVwYKAVRALFkRHZFIt9aFggjwE0IEiWmgk8QFBpmITvv3jni23m92wCXvuzeb3fs3c2XN/5+m7e/Z+9tzfnvO7qSokSe3YbtwFSJJGy+CXpMYY/JLUGINfkhpj8EtSY3YYdwFzsWjRolqyZMm4y5CkBWXVqlU/rKqJ6e0LIviXLFnCypUrx12GJC0oSb43U7tdPZLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxvQV/kp2SXJXk2iQ3JHlH175/kiuT3JLk00ke1lcNkqSN9XnGfx/w/Ko6GFgKHJXkmcDfAqdV1ROAnwCv77EGSdI0vQV/Dfyse7pj9yjg+cA/de3nAMf0VYMkaWO93rmbZHtgFfAE4MPAfwB3VdX6bpHbgX1nWXc5sBxg8eLFfZaprcj33/kr4y5hm7f4bdePuwSNWa//3K2qDVW1FNgPOAx48mase0ZVTVbV5MTERkNNSJK20Eiu6qmqu4AvA88C9kgy9U5jP+COUdQgSRro86qeiSR7dNM7A0cCNzH4A/CKbrFlwMV91SBJ2lifffz7AOd0/fzbARdU1aVJbgTOT/Iu4FvAmT3WIEmaprfgr6rrgENmaL+VQX+/JGkMvHNXkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhrTW/AneWySLye5MckNSd7UtZ+S5I4k13SPl/RVgyRpYzv0uO31wElVdXWS3YBVSS7v5p1WVaf2uG9J0ix6C/6qWgOs6abvSXITsG9f+5Mkzc1I+viTLAEOAa7smk5Icl2Ss5LsOcs6y5OsTLJy3bp1oyhTkprQe/An2RW4EHhzVd0NfAQ4AFjK4B3B+2dar6rOqKrJqpqcmJjou0xJakavwZ9kRwah/8mqugigqu6sqg1VdT/wMeCwPmuQJP1/fV7VE+BM4Kaq+sBQ+z5Di70MWN1XDZKkjfV5Vc/hwHHA9Umu6dreAhybZClQwG3AG3qsQZI0TZ9X9XwVyAyzvtDXPiVJD847dyWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWpMnx/EMhaH/vm54y5hm7fqfa8bdwmSHgLP+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1prfgT/LYJF9OcmOSG5K8qWvfK8nlSW7uvu7ZVw2SpI31eca/Hjipqg4Cngm8MclBwMnAiqo6EFjRPZckjUhvwV9Va6rq6m76HuAmYF/gaOCcbrFzgGP6qkGStLGR9PEnWQIcAlwJ7F1Va7pZPwD2nmWd5UlWJlm5bt26UZQpSU3oPfiT7ApcCLy5qu4enldVBdRM61XVGVU1WVWTExMTfZcpSc3oNfiT7Mgg9D9ZVRd1zXcm2aebvw+wts8aJEn/X59X9QQ4E7ipqj4wNOsSYFk3vQy4uK8aJEkb6/MTuA4HjgOuT3JN1/YW4D3ABUleD3wP+J0ea5AkTdNb8FfVV4HMMvsFfe1XkrRp3rkrSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMbMKfiTrJhLmyRp67fJ0TmT7AQ8AliUZE8eGG1zdwafnytJWmAebFjmNwBvBh4DrOKB4L8b+FCPdUmSerLJ4K+qDwIfTHJiVZ0+opokST2a0wexVNXpSZ4NLBlep6rO7akuSVJP5hT8ST4BHABcA2zomgsw+CVpgZnrRy9OAgdVVfVZjCSpf3O9jn818Og+C5EkjcZcz/gXATcmuQq4b6qxql7aS1WSpN7MNfhP6bMISdLozPWqnn/tuxBJ0mjM9aqeexhcxQPwMGBH4N6q2r2vwiRJ/ZjrGf9uU9NJAhwNPLOvoiRJ/dns0Tlr4J+BF21quSRnJVmbZPVQ2ylJ7khyTfd4yRbULEl6COba1fPyoafbMbiu/+cPstrZDMbzmX6T12lVdepcC5Qkza+5XtXzW0PT64HbGHT3zKqqrkiyZIuqkiT1Zq59/L83j/s8IcnrgJXASVX1k5kWSrIcWA6wePHiedy9JLVtrh/Esl+Sz3Z99muTXJhkvy3Y30cYjPmzFFgDvH+2BavqjKqarKrJiYmJLdiVJGkmc/3n7seBSxiMy/8Y4HNd22apqjurakNV3Q98DDhsc7chSXpo5hr8E1X18apa3z3OBjb7NDzJPkNPX8ZgDCBJ0gjN9Z+7P0ryWuC87vmxwI82tUKS84AjGHxs4+3A24EjkixlcDPYbQw+4UuSNEJzDf7fB04HTmMQ2l8Hjt/UClV17AzNZ25OcZKk+TfX4H8nsGzqCpwkewGnMviDIElaQObax//U4csuq+rHwCH9lCRJ6tNcg3+7JHtOPenO+Of6bkGStBWZa3i/H/hGks90z18J/HU/JUmS+jTXO3fPTbISeH7X9PKqurG/siRJfZlzd00X9Ia9JC1wmz0ssyRpYTP4JakxBr8kNcbgl6TGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMb0FvxJzkqyNsnqoba9klye5Obu65597V+SNLM+z/jPBo6a1nYysKKqDgRWdM8lSSPUW/BX1RXAj6c1Hw2c002fAxzT1/4lSTPbYcT727uq1nTTPwD2nm3BJMuB5QCLFy8eQWmSHorDTz983CU04Wsnfu0hb2Ns/9ytqgJqE/PPqKrJqpqcmJgYYWWStG0bdfDfmWQfgO7r2hHvX5KaN+rgvwRY1k0vAy4e8f4lqXl9Xs55HvAN4ElJbk/yeuA9wJFJbgZ+vXsuSRqh3v65W1XHzjLrBX3tU5L04LxzV5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1BiDX5Ias8M4dprkNuAeYAOwvqomx1GHJLVoLMHfeV5V/XCM+5ekJtnVI0mNGVfwF/ClJKuSLJ9pgSTLk6xMsnLdunUjLk+Stl3jCv7nVNXTgBcDb0zy3OkLVNUZVTVZVZMTExOjr1CStlFjCf6quqP7uhb4LHDYOOqQpBaNPPiT7JJkt6lp4IXA6lHXIUmtGsdVPXsDn00ytf9PVdUXx1CHJDVp5MFfVbcCB496v5KkAS/nlKTGGPyS1BiDX5IaY/BLUmMMfklqjMEvSY0x+CWpMQa/JDXG4Jekxhj8ktQYg1+SGmPwS1JjDH5JaozBL0mNMfglqTEGvyQ1xuCXpMYY/JLUGINfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TGGPyS1JixBH+So5J8J8ktSU4eRw2S1KqRB3+S7YEPAy8GDgKOTXLQqOuQpFaN44z/MOCWqrq1qn4BnA8cPYY6JKlJqarR7jB5BXBUVf1B9/w44BlVdcK05ZYDy7unTwK+M9JCR2sR8MNxF6Et4rFb2Lb14/e4qpqY3rjDOCqZi6o6Azhj3HWMQpKVVTU57jq0+Tx2C1urx28cXT13AI8der5f1yZJGoFxBP83gQOT7J/kYcCrgUvGUIckNWnkXT1VtT7JCcBlwPbAWVV1w6jr2Mo00aW1jfLYLWxNHr+R/3NXkjRe3rkrSY0x+CWpMQb/PErysx63fUqSP+tr+9u6JBuSXJPk2iRXJ3n2PG13SZLVs8w7L8l1Sf50M7e5NMlL5qO+bd3Qcb2hO7YnJdmumzeZ5O/GXePWaKu9jl+aZ/9dVUsBkrwIeDfwa8MLJNmhqtbPx86SPBp4elU9YQtWXwpMAl+Yj1q2ccPH9ZeATwG7A2+vqpXAyj53Pp+/M6PkGX/PknwlyWQ3vSjJbd308UkuSvLFJDcnee/QOkd1Z6XXJlkxtLmDuu3dmuRPRvudbFN2B34CkOSIJP+W5BLgxiTbJ3lfkm92Z+tv6JbbNcmK7rhcn2SjYUaSPD7Jt5I8HfgSsG93NvqrSf6w2+a1SS5M8ohunVcmWd21X9Fd4vxO4FXduq8a1Q9loauqtQzu9j8hA0ckuRT+7x3zWdNfP907tpuSfKx71/ClJDt38w7oXp+rut+RJ3ftZyf5aJIrgffOUs7Wrap8zNMD+NkMbV8BJrvpRcBt3fTxwK3AI4GdgO8xuLFtAvhPYP9uub26r6cAXwce3m3nR8CO4/6eF8oD2ABcA3wb+ClwaNd+BHDv0M97OfDWbvrhDM4Y92fw7nj3oeN4CxBgCbCawbAi3wIO7pZZAqwe2v+jhqbfBZzYTV8P7NtN7zH0u/Ghcf/MFsJjltfcXcDe3bG9tGub8fXTHaf1wNJuuQuA13bTK4ADu+lnAP/STZ8NXApsP+7vf0sfdvWM14qq+ilAkhuBxwF7AldU1XcBqurHQ8t/vqruA+5LspbBL/ftI655oRruEngWcG6Sp3Tzrpr6eQMvBJ7ajSkFgz/MBzL4Of9NkucC9wP7Mvj5w+CP9cXAy6vqxln2/5Qk7wL2AHZlcB8LwNeAs5NcAFw0D9+nZjfT6wfgu1V1TTe9CliSZFfg2cBnkkyt//ChbX2mqjaMoug+GPz9W88DXWo7TZt339D0Bh78eGzu8ppBVX0jySIGgQ2DM/4pYXA2ftnwOkmO75Y/tKr+p+uymzqePwW+DzwHmC34zwaOqapru20d0dXyR0meAfwGsCrJoQ/pm2tcksczeG2sBX552uzZXj/T23dm8Jq9a+pkYQb3ztK+INjH37/bgKkX8ys2sdyUfweem2R/gCR79VRXs7q+2u0ZvN2f7jLgj5Ps2C37xCS7MDjzX9uF/vMYvDub8gvgZcDrkvzuLLvdDVjTbfc1Q7UcUFVXVtXbgHUMuvvu6ZbXZkgyAXyUQTfZQ7oztaruBr6b5JXdtpPk4Hkoc6vgGeP8ekSS4a6XDwCnAhdkMMz05x9sA1W1rlv2ou6ytLXAkb1U25adk0y9nQ+wrKo2DL2Nn/IPDPp9r85g5jrgGOCTwOeSXM+g3//bwytV1b1JfhO4PIPLeq+btt2/BK7stnclDwT7+5Ic2NW0AriWwbuHk7t6311Vn35I3/m2beq47sjg3fUnGLzu5sNrgI8keWu3/fMZHJ8FzyEbJKkxdvVIUmMMfklqjMEvSY0x+CWpMQa/JDXG4JemSVJJ/nHo+Q5J1k2N+7IF25t1BE9pHAx+aWP3MhhiYefu+ZHAHWOsR5pXBr80sy8wGEYB4FjgvKkZSXbpRnq8qhuN8+iufUk3iuPVmccx/6X5ZvBLMzsfeHWSnYCnMrjbdspfMBip8TDgeQzuvt2F7i7rqnoa8CrADwHRVskhG6QZVNV1SZYwONuf/oEoLwRemgc+EW0nYDHwX8CHkixlMNjXE0dTrbR5DH5pdpcwGGvpCOBRQ+0BfruqvjO8cJJTgDuBgxm8m/75SKqUNpNdPdLszgLeUVXXT2u/DDixG8SNJId07Y8E1lTV/cBxDEYAlbY6Br80i6q6vapm6qf/KwajNV6X5IbuOcDfA8uSXAs8mQU+Zru2XY7OKUmN8Yxfkhpj8EtSYwx+SWqMwS9JjTH4JakxBr8kNcbgl6TG/C9zkYma7S531gAAAABJRU5ErkJggg==\n"
          },
          "metadata": {
            "needs_background": "light"
          }
        }
      ],
      "source": [
        "# create a countplot to visualize the breakdown of number of votes per meal\n",
        "sn.countplot(x = \"Meal\", data = Meal_data_cleaned)\n",
        "plt.show()"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "AAqM8tOGe2ST"
      },
      "source": [
        "    Merging the Temperature data (post cleaning) with the Meal data (post cleaning)"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 49,
      "metadata": {
        "id": "uwpe73zPe2ST"
      },
      "outputs": [],
      "source": [
        "# merge the two specified dataframes, and store the resulting dataframe in a new variable\n",
        "Temp_meal_data = pd.merge(Temp_data, Meal_data_cleaned, how=\"inner\", on=\"Name\")"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "5tEa0enGe2ST",
        "outputId": "91589674-c32c-471b-9b9a-34a347fee109"
      },
      "outputs": [
        {
          "data": {
            "text/html": [
              "<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>Email</th>\n",
              "      <th>Name</th>\n",
              "      <th>Temperature</th>\n",
              "      <th>Metrics</th>\n",
              "      <th>Breakfast</th>\n",
              "      <th>Lunch</th>\n",
              "      <th>Dinner</th>\n",
              "      <th>Meal</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>2022/06/25 11:58:47 AM MDT</td>\n",
              "      <td>tjshotunde@yahoo.com</td>\n",
              "      <td>Oreoluwa Jimi-Shotunde</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>2022/06/25 12:00:01 PM MDT</td>\n",
              "      <td>winfredplt583@gmail.com</td>\n",
              "      <td>Winfred Apolot</td>\n",
              "      <td>68.0</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2022/06/25 12:02:14 PM MDT</td>\n",
              "      <td>missonyango.so@gmail.com</td>\n",
              "      <td>Shereen Onyango</td>\n",
              "      <td>64.4</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>2022/06/25 12:02:25 PM MDT</td>\n",
              "      <td>njerimacharia07@gmail.com</td>\n",
              "      <td>Njeri Macharia</td>\n",
              "      <td>66.2</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>2022/06/25 12:02:47 PM MDT</td>\n",
              "      <td>rachealsibindi@gmail.com</td>\n",
              "      <td>Racheal Sibindi</td>\n",
              "      <td>66.2</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>2022/06/25 12:02:53 PM MDT</td>\n",
              "      <td>halimatshaddiya@gmail.com</td>\n",
              "      <td>Halimat Raji</td>\n",
              "      <td>68.0</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>2022/06/25 12:03:23 PM MDT</td>\n",
              "      <td>oluwatobiibironkeoluwa@gmail.com</td>\n",
              "      <td>Oluwatobi Oluwa</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>2022/06/25 12:03:40 PM MDT</td>\n",
              "      <td>annakarungi15@gmail.com</td>\n",
              "      <td>Karungi Anna</td>\n",
              "      <td>68.0</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>2022/06/25 12:04:43 PM MDT</td>\n",
              "      <td>Fatimaisokrari@gmail.com</td>\n",
              "      <td>Fatima Isokrari</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>2022/06/25 12:04:44 PM MDT</td>\n",
              "      <td>wacheramaina@gmail.com</td>\n",
              "      <td>Mary Wacera Maina</td>\n",
              "      <td>64.4</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>2022/06/25 12:04:47 PM MDT</td>\n",
              "      <td>faithwmbg@gmail.com</td>\n",
              "      <td>Faith Wambugu</td>\n",
              "      <td>62.6</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>2022/06/25 12:05:38 PM MDT</td>\n",
              "      <td>tsonniemaina@gmail.com</td>\n",
              "      <td>Grace M. Maina</td>\n",
              "      <td>64.4</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>2022/06/25 12:05:38 PM MDT</td>\n",
              "      <td>tsonniemaina@gmail.com</td>\n",
              "      <td>Grace M. Maina</td>\n",
              "      <td>64.4</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>2022/06/25 12:06:37 PM MDT</td>\n",
              "      <td>lvijayan1@berkeley.edu</td>\n",
              "      <td>Lavanya Vijayan</td>\n",
              "      <td>71.0</td>\n",
              "      <td>F</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>2022/06/25 12:10:01 PM MDT</td>\n",
              "      <td>muniragebi@gmail.com</td>\n",
              "      <td>Gebi Muniratu Ibrahim</td>\n",
              "      <td>100.4</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>2022/06/25 12:12:27 PM MDT</td>\n",
              "      <td>samanthaerskine1@gmail.com</td>\n",
              "      <td>Samantha Erskine</td>\n",
              "      <td>78.8</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>2022/06/25 12:12:56 PM MDT</td>\n",
              "      <td>roseheromini@gmail.com</td>\n",
              "      <td>Rozi Hieromini Mlay</td>\n",
              "      <td>75.2</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>2022/06/25 12:14:39 PM MDT</td>\n",
              "      <td>sobowalemoyinoluwa@gmail.com</td>\n",
              "      <td>Moyinoluwa Sobowale</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>2022/06/25 12:14:45 PM MDT</td>\n",
              "      <td>Paula.mordi@yahoo.com</td>\n",
              "      <td>Paula Mordi</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>2022/06/25 12:23:16 PM MDT</td>\n",
              "      <td>chepkemoileila39@gmail.com</td>\n",
              "      <td>Leila Maritim</td>\n",
              "      <td>62.6</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>2022/06/25 12:34:56 PM MDT</td>\n",
              "      <td>erracyallen@gmail.com</td>\n",
              "      <td>Tracy-Allen Ezechukwu</td>\n",
              "      <td>84.2</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>2022/06/25 12:35:40 PM MDT</td>\n",
              "      <td>zinalucy@gmail.com</td>\n",
              "      <td>Ugoeze Unegbu</td>\n",
              "      <td>20.0</td>\n",
              "      <td>F</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>2022/06/25 12:36:30 PM MDT</td>\n",
              "      <td>anietie_umoekam@yahoo.com</td>\n",
              "      <td>Anietie Mbora Etim</td>\n",
              "      <td>86.0</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>2022/06/25 12:37:12 PM MDT</td>\n",
              "      <td>nwaodorifechukwude@gmail.com</td>\n",
              "      <td>Nwaodor ifechukwude destiny</td>\n",
              "      <td>95.0</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>2022/06/25 12:37:44 PM MDT</td>\n",
              "      <td>enyeneoton@gmail.com</td>\n",
              "      <td>Enyeneobong Oton</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>2022/06/25 12:40:52 PM MDT</td>\n",
              "      <td>boladale.olubunmi@gmail.com</td>\n",
              "      <td>Olubunmi Boladale</td>\n",
              "      <td>82.4</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>2022/06/25 12:44:40 PM MDT</td>\n",
              "      <td>etther.eo@gmail.com</td>\n",
              "      <td>Esther Ugochukwu Amaka Okolie</td>\n",
              "      <td>78.8</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>Lunch</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>2022/06/25 12:49:41 PM MDT</td>\n",
              "      <td>r.adeagbo@gmail.com</td>\n",
              "      <td>Roselyn Adeagbo</td>\n",
              "      <td>84.2</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>2022/06/25 12:50:58 PM MDT</td>\n",
              "      <td>modupeade89@gmail.com</td>\n",
              "      <td>Modupeoluwa Adedeji</td>\n",
              "      <td>99.5</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>2022/06/25 12:51:12 PM MDT</td>\n",
              "      <td>fionamasagbor@gmail.com</td>\n",
              "      <td>Fiona Masagbor</td>\n",
              "      <td>84.2</td>\n",
              "      <td>C</td>\n",
              "      <td>1</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>Breakfast</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>2022/06/25 1:26:49 PM MDT</td>\n",
              "      <td>adeoolarhneye@gmail.com</td>\n",
              "      <td>Tolulope Adeneye</td>\n",
              "      <td>80.6</td>\n",
              "      <td>C</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1</td>\n",
              "      <td>Dinner</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                     Timestamp                             Email  \\\n",
              "0   2022/06/25 11:58:47 AM MDT              tjshotunde@yahoo.com   \n",
              "1   2022/06/25 12:00:01 PM MDT           winfredplt583@gmail.com   \n",
              "2   2022/06/25 12:02:14 PM MDT          missonyango.so@gmail.com   \n",
              "3   2022/06/25 12:02:25 PM MDT         njerimacharia07@gmail.com   \n",
              "4   2022/06/25 12:02:47 PM MDT          rachealsibindi@gmail.com   \n",
              "5   2022/06/25 12:02:53 PM MDT         halimatshaddiya@gmail.com   \n",
              "6   2022/06/25 12:03:23 PM MDT  oluwatobiibironkeoluwa@gmail.com   \n",
              "7   2022/06/25 12:03:40 PM MDT           annakarungi15@gmail.com   \n",
              "8   2022/06/25 12:04:43 PM MDT          Fatimaisokrari@gmail.com   \n",
              "9   2022/06/25 12:04:44 PM MDT            wacheramaina@gmail.com   \n",
              "10  2022/06/25 12:04:47 PM MDT               faithwmbg@gmail.com   \n",
              "11  2022/06/25 12:05:38 PM MDT            tsonniemaina@gmail.com   \n",
              "12  2022/06/25 12:05:38 PM MDT            tsonniemaina@gmail.com   \n",
              "13  2022/06/25 12:06:37 PM MDT            lvijayan1@berkeley.edu   \n",
              "14  2022/06/25 12:10:01 PM MDT              muniragebi@gmail.com   \n",
              "15  2022/06/25 12:12:27 PM MDT        samanthaerskine1@gmail.com   \n",
              "16  2022/06/25 12:12:56 PM MDT            roseheromini@gmail.com   \n",
              "17  2022/06/25 12:14:39 PM MDT      sobowalemoyinoluwa@gmail.com   \n",
              "18  2022/06/25 12:14:45 PM MDT             Paula.mordi@yahoo.com   \n",
              "19  2022/06/25 12:23:16 PM MDT        chepkemoileila39@gmail.com   \n",
              "20  2022/06/25 12:34:56 PM MDT             erracyallen@gmail.com   \n",
              "21  2022/06/25 12:35:40 PM MDT                zinalucy@gmail.com   \n",
              "22  2022/06/25 12:36:30 PM MDT         anietie_umoekam@yahoo.com   \n",
              "23  2022/06/25 12:37:12 PM MDT      nwaodorifechukwude@gmail.com   \n",
              "24  2022/06/25 12:37:44 PM MDT              enyeneoton@gmail.com   \n",
              "25  2022/06/25 12:40:52 PM MDT       boladale.olubunmi@gmail.com   \n",
              "26  2022/06/25 12:44:40 PM MDT               etther.eo@gmail.com   \n",
              "27  2022/06/25 12:49:41 PM MDT               r.adeagbo@gmail.com   \n",
              "28  2022/06/25 12:50:58 PM MDT             modupeade89@gmail.com   \n",
              "29  2022/06/25 12:51:12 PM MDT           fionamasagbor@gmail.com   \n",
              "30   2022/06/25 1:26:49 PM MDT           adeoolarhneye@gmail.com   \n",
              "\n",
              "                             Name  Temperature Metrics Breakfast Lunch Dinner  \\\n",
              "0          Oreoluwa Jimi-Shotunde         82.4       C         1     0      0   \n",
              "1                  Winfred Apolot         68.0       C         0     1      0   \n",
              "2                 Shereen Onyango         64.4       C         0     0      1   \n",
              "3                  Njeri Macharia         66.2       C         1     0      0   \n",
              "4                 Racheal Sibindi         66.2       C         0     1      0   \n",
              "5                    Halimat Raji         68.0       C         1     0      0   \n",
              "6                 Oluwatobi Oluwa         80.6       C         0     0      1   \n",
              "7                    Karungi Anna         68.0       C         1     0      0   \n",
              "8                 Fatima Isokrari         82.4       C         0     0      1   \n",
              "9               Mary Wacera Maina         64.4       C         1     0      0   \n",
              "10                  Faith Wambugu         62.6       C         1     0      0   \n",
              "11                 Grace M. Maina         64.4       C         1     0      0   \n",
              "12                 Grace M. Maina         64.4       C         1     0      0   \n",
              "13                Lavanya Vijayan         71.0       F         0     0      1   \n",
              "14          Gebi Muniratu Ibrahim        100.4       C         1     0      0   \n",
              "15               Samantha Erskine         78.8       C         0     1      0   \n",
              "16            Rozi Hieromini Mlay         75.2       C         0     1      0   \n",
              "17            Moyinoluwa Sobowale         82.4       C         1     0      0   \n",
              "18                    Paula Mordi         82.4       C         0     1      0   \n",
              "19                  Leila Maritim         62.6       C         1     0      0   \n",
              "20          Tracy-Allen Ezechukwu         84.2       C         0     1      0   \n",
              "21                  Ugoeze Unegbu         20.0       F         1     0      0   \n",
              "22             Anietie Mbora Etim         86.0       C         0     1      0   \n",
              "23    Nwaodor ifechukwude destiny         95.0       C         0     0      1   \n",
              "24               Enyeneobong Oton         80.6       C         0     1      0   \n",
              "25              Olubunmi Boladale         82.4       C         0     0      1   \n",
              "26  Esther Ugochukwu Amaka Okolie         78.8       C         0     1      0   \n",
              "27                Roselyn Adeagbo         84.2       C         1     0      0   \n",
              "28            Modupeoluwa Adedeji         99.5       C         1     0      0   \n",
              "29                 Fiona Masagbor         84.2       C         1     0      0   \n",
              "30               Tolulope Adeneye         80.6       C         0     0      1   \n",
              "\n",
              "         Meal  \n",
              "0   Breakfast  \n",
              "1       Lunch  \n",
              "2      Dinner  \n",
              "3   Breakfast  \n",
              "4       Lunch  \n",
              "5   Breakfast  \n",
              "6      Dinner  \n",
              "7   Breakfast  \n",
              "8      Dinner  \n",
              "9   Breakfast  \n",
              "10  Breakfast  \n",
              "11  Breakfast  \n",
              "12  Breakfast  \n",
              "13     Dinner  \n",
              "14  Breakfast  \n",
              "15      Lunch  \n",
              "16      Lunch  \n",
              "17  Breakfast  \n",
              "18      Lunch  \n",
              "19  Breakfast  \n",
              "20      Lunch  \n",
              "21  Breakfast  \n",
              "22      Lunch  \n",
              "23     Dinner  \n",
              "24      Lunch  \n",
              "25     Dinner  \n",
              "26      Lunch  \n",
              "27  Breakfast  \n",
              "28  Breakfast  \n",
              "29  Breakfast  \n",
              "30     Dinner  "
            ]
          },
          "execution_count": 58,
          "metadata": {},
          "output_type": "execute_result"
        }
      ],
      "source": [
        "Temp_meal_data"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 50,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ZVztzXOqe2ST",
        "outputId": "a7a8a860-bc3e-4099-ed61-5204854a690a"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "31"
            ]
          },
          "metadata": {},
          "execution_count": 50
        }
      ],
      "source": [
        "# number of rows in merged\n",
        "Temp_meal_data.shape[0]\n",
        "# this number also represents how many respondents in the two polls matched in terms of name. \n",
        "# this number is small because some people did not respond to both polls (only responded to one of them)\n",
        "# and some people did not enter their name consistently between the two polls"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 51,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "uiBRygaKe2SU",
        "outputId": "e5d0574a-5668-4726-a59b-ca4c54f3b379"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "9"
            ]
          },
          "metadata": {},
          "execution_count": 51
        }
      ],
      "source": [
        "Temp_meal_data.shape[1]"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 52,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "D8AvbHQve2SU",
        "outputId": "f754dfbf-e36a-465f-ee3a-686b526e9b65"
      },
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "Meal\n",
              "Breakfast    71.580000\n",
              "Dinner       79.485714\n",
              "Lunch        77.800000\n",
              "Name: Temperature, dtype: float64"
            ]
          },
          "metadata": {},
          "execution_count": 52
        }
      ],
      "source": [
        "# group by meal and get the average temperature in F\n",
        "Temp_meal_data.groupby(by = \"Meal\")[\"Temperature\"].mean()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 53,
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 279
        },
        "id": "vSuVNQVte2SU",
        "outputId": "dbd0c143-3647-4b36-ea84-911918816177"
      },
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAX4AAAEGCAYAAABiq/5QAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAVdElEQVR4nO3dfbRldX3f8ffHGZAnkafrFEEcggRKrWC4QZTUgIAlMQWaGoVaM7Y0k3b5EMW20tQEo65oYlZsoolmIoYxNSASDIQYkTVBTUiKDo/DYyAIBDIw1wdAsYLgt3+c35XjnbkzZ+7cfe7c2e/XWnedvX/76XvnzPncfX5nn99OVSFJ6o9nLHQBkqTxMvglqWcMfknqGYNfknrG4Jeknlm60AWMYr/99qvly5cvdBmStKhce+21X6uqiZntiyL4ly9fztq1axe6DElaVJLcu6l2u3okqWcMfknqGYNfknrG4Jeknuk0+JO8LcktSW5OckGSXZIcnOSaJHcl+VSSnbusQZL0wzoL/iQHAG8BJqvqhcAS4AzgN4APVtULgG8CZ3VVgyRpY1139SwFdk2yFNgNWA+8Ari4LV8NnN5xDZKkIZ0Ff1U9APwWcB+DwH8EuBZ4uKqebKvdDxywqe2TrEyyNsnaqamprsqUpN7psqtnb+A04GDgucDuwCmjbl9Vq6pqsqomJyY2+uKZJGmOuvzm7knAV6tqCiDJJcBxwF5Jlraz/gOBBzqsQdKYHPeh4xa6hB3e1W++el7202Uf/33AsUl2SxLgROBW4Crg1W2dFcClHdYgSZqhyz7+axh8iHsdsK4daxXwDuDsJHcB+wLndVWDJGljnQ7SVlXnAufOaL4bOKbL40qSZrcoRudUf9z37n+50CXs8A761XULXYIWmEM2SFLPGPyS1DMGvyT1jMEvST1j8EtSzxj8ktQzBr8k9YzBL0k9Y/BLUs8Y/JLUMwa/JPWMwS9JPWPwS1LPGPyS1DMGvyT1zA43Hv/R//0TC13CDu/aD/z8QpcgaRt0dsaf5LAkNwz9PJrkrUn2SXJlkjvb495d1SBJ2liX99y9o6qOqqqjgKOB7wCfAc4B1lTVocCaNi9JGpNx9fGfCPxDVd0LnAasbu2rgdPHVIMkifEF/xnABW16WVWtb9MPAss2tUGSlUnWJlk7NTU1jholqRc6D/4kOwOnAp+euayqCqhNbVdVq6pqsqomJyYmOq5SkvpjHGf8PwVcV1UPtfmHkuwP0B43jKEGSVIzjuA/k6e7eQAuA1a06RXApWOoQZLUdBr8SXYHTgYuGWp+P3BykjuBk9q8JGlMOv0CV1U9Buw7o+3rDK7ykSQtAIdskKSeMfglqWcMfknqGYNfknrG4JeknjH4JalnDH5J6hmDX5J6xuCXpJ4x+CWpZwx+SeoZg1+Sesbgl6SeMfglqWcMfknqGYNfknrG4Jeknun61ot7Jbk4ye1Jbkvy0iT7JLkyyZ3tce8ua5Ak/bCuz/h/B/hcVR0OHAncBpwDrKmqQ4E1bV6SNCadBX+SZwMvB84DqKonquph4DRgdVttNXB6VzVIkjbW5Rn/wcAU8EdJrk/ysSS7A8uqan1b50Fg2aY2TrIyydoka6empjosU5L6pcvgXwr8GPCRqnox8BgzunWqqoDa1MZVtaqqJqtqcmJiosMyJalfugz++4H7q+qaNn8xgz8EDyXZH6A9buiwBknSDJ0Ff1U9CPxjksNa04nArcBlwIrWtgK4tKsaJEkbW9rx/t8MfDLJzsDdwH9k8MfmoiRnAfcCr+m4BknSkE6Dv6puACY3sejELo8rSZqd39yVpJ4x+CWpZwx+SeoZg1+Sesbgl6SeMfglqWcMfknqGYNfknrG4JeknjH4JalnDH5J6hmDX5J6ZqTgT/L8JCe16V2TPKvbsiRJXdli8Cf5BQY3UfmD1nQg8GddFiVJ6s4oZ/xvBI4DHgWoqjuB53RZlCSpO6ME/+NV9cT0TJKlzHKfXEnS9m+U4P9ikl8Gdk1yMvBp4M+7LUuS1JVRgv8dwBSwDvhF4LPAO0fZeZJ7kqxLckOSta1tnyRXJrmzPe491+IlSVtvs7deTLIEuKWqDgf+cI7HOKGqvjY0fw6wpqren+ScNv+OOe5bkrSVNnvGX1VPAXckOWgej3kasLpNrwZOn8d9S5K2YJSbre8N3JLky8Bj041VdeoI2xbw+SQF/EFVrQKWVdX6tvxBYNlW1ixJ2gajBP+vbMP+f6KqHkjyHODKJLcPL6yqan8UNpJkJbAS4KCD5vMNhyT12xaDv6q+ONedV9UD7XFDks8AxwAPJdm/qtYn2R/YMMu2q4BVAJOTk14+KknzZJRv7n4ryaPt57tJnkry6Ajb7T49tEOS3YFXAjcDlwEr2morgEvnXr4kaWuNcsb/g3F5koTBh7PHjrDvZcBnBpuwFPiTqvpckq8AFyU5C7gXeM1cCpckzc0offw/UFUF/FmScxlchrm5de8GjtxE+9eBE7fmuJKk+bPF4E/ys0OzzwAmge92VpEkqVOjnPH/m6HpJ4F7GHT3SJIWoVGC/2NVdfVwQ5LjmOVqHEnS9m2UsXo+NGKbJGkRmPWMP8lLgZcBE0nOHlq0J7Ck68IkSd3YXFfPzsAebZ3hWy0+Cry6y6IkSd2ZNfjbN3a/mOT8qrp3jDVJkjo0yoe730nyAeBfALtMN1bVKzqrSpLUmVE+3P0kcDtwMPBrDC7n/EqHNUmSOjRK8O9bVecB36uqL1bVfwI825ekRWqUrp7vtcf1SV4F/BOwT3clSZK6NErwvzfJs4G3M7h+f0/gbZ1WJUnqzCj33D20qi4HHgFOGEtVkqTOjHLP3TPHVIskaQxG6eq5OsmHgU/xw/fcva6zqiRJnRkl+I9qj+8eaiu8skeSFqVR7sBlv74k7UBGuefusiTnJfnLNn9Eu23iSJIsSXJ9ksvb/MFJrklyV5JPJdl57uVLkrbWKF/gOh+4Anhum/974K1bcYxfAm4bmv8N4INV9QLgm8DIf0QkSdtulODfr6ouAr4PUFVPAk+NsvMkBwKvAj7W5sPgs4GL2yqrgdO3smZJ0jYYJfgfS7Ivgw90SXIsg2v6R/G/gf9B+6MB7As83P54ANwPHDB6uZKkbTXKVT1nA5cBhyS5GphghPH4k/wMsKGqrk1y/NYWlmQlsBLgoIMO2trNJUmzGOWqnuuS/CRwGBDgjqr63hY2AzgOODXJTzMYznlP4HeAvZIsbWf9BwIPzHLcVcAqgMnJyRrll5EkbdkoV/XsArwFeA+DYZnf2No2q6r+Z1UdWFXLgTOAv6qq1wFX8fQ7hhXApXOsXZI0B6P08X+CwU1YPgR8uE3/8TYc8x3A2UnuYtDnf9427EuStJVG6eN/YVUdMTR/VZJbt+YgVfUF4Att+m7gmK3ZXpI0f0Y547+uXckDQJKXAGu7K0mS1KVRzviPBv42yX1t/iDgjiTrgKqqF3VWnSRp3o0S/Kd0XoUkaWxGuZzz3iR7A88bXt9hmSVpcdpi8Cd5D/AG4B9o397FYZkladEapavnNcAhVfVE18VIkro3ylU9NwN7dV2IJGk8Rjnjfx9wfZKbgcenG6vq1M6qkiR1ZpTgX81gDP11PD3KpiRpkRol+L9TVb/beSWSpLEYJfj/Osn7GAzNPNzV4+WckrQIjRL8L26Pxw61eTmnJC1So3yB64RxFCJJGo9RxuNfluS8JH/Z5o9I4g3SJWmRGuU6/vOBK4Dntvm/B97aVUGSpG7NGvxJpruB9quqi2iXcrZbJj41htokSR3Y3Bn/l9vjY0n2pY3T08bmf6TrwiRJ3djch7tpj2czuJTzkCRXAxM8fc/c2Tce3Jf3S8Az23EurqpzkxwMXMjgtovXAq93HCBJGp/NBf9EkrPb9GeAzzL4Y/A4cBJw0xb2/Tjwiqr6dpKdgL9pHxCfDXywqi5M8lHgLOAj2/JLSJJGt7muniXAHsCzgN0Z/JFYAuzW2jarBr7dZndqP9PX/1/c2lcDp8+pcknSnGzujH99Vb17W3aeZAmD7pwXAL/HYEz/h9sHxAD3AwdsyzEkSVtnc2f82cyykVTVU1V1FHAgcAxw+KjbJlmZZG2StVNTU9taiiSp2VzwnzhfB6mqh4GrgJcCew1dKnog8MAs26yqqsmqmpyYmJivUiSp92YN/qr6xrbsOMlEkr3a9K7AycBtDP4ATF8VtAK4dFuOI0naOqMM0jZX+wOrWz//M4CLquryJLcCFyZ5L3A9cF6HNUiSZugs+KvqJp4e2XO4/W4G/f2SpAUwylg9kqQdiMEvST1j8EtSzxj8ktQzBr8k9YzBL0k9Y/BLUs8Y/JLUMwa/JPWMwS9JPWPwS1LPGPyS1DMGvyT1jMEvST1j8EtSzxj8ktQzBr8k9YzBL0k901nwJ3lekquS3JrkliS/1Nr3SXJlkjvb495d1SBJ2liXZ/xPAm+vqiOAY4E3JjkCOAdYU1WHAmvavCRpTDoL/qpaX1XXtelvAbcBBwCnAavbaquB07uqQZK0sbH08SdZDrwYuAZYVlXr26IHgWWzbLMyydoka6empsZRpiT1QufBn2QP4E+Bt1bVo8PLqqqA2tR2VbWqqiaranJiYqLrMiWpNzoN/iQ7MQj9T1bVJa35oST7t+X7Axu6rEGS9MO6vKonwHnAbVX120OLLgNWtOkVwKVd1SBJ2tjSDvd9HPB6YF2SG1rbLwPvBy5KchZwL/CaDmuQJM3QWfBX1d8AmWXxiV0dV5K0eX5zV5J6xuCXpJ4x+CWpZwx+SeoZg1+Sesbgl6SeMfglqWcMfknqGYNfknrG4JeknjH4JalnDH5J6hmDX5J6xuCXpJ4x+CWpZwx+SeoZg1+SeqbLe+5+PMmGJDcPte2T5Mokd7bHvbs6viRp07o84z8fOGVG2znAmqo6FFjT5iVJY9RZ8FfVl4BvzGg+DVjdplcDp3d1fEnSpo27j39ZVa1v0w8Cy2ZbMcnKJGuTrJ2amhpPdZLUAwv24W5VFVCbWb6qqiaranJiYmKMlUnSjm3cwf9Qkv0B2uOGMR9fknpv3MF/GbCiTa8ALh3z8SWp97q8nPMC4O+Aw5Lcn+Qs4P3AyUnuBE5q85KkMVra1Y6r6sxZFp3Y1TElSVvmN3clqWcMfknqGYNfknrG4JeknjH4JalnDH5J6hmDX5J6xuCXpJ4x+CWpZwx+SeoZg1+Sesbgl6SeMfglqWcMfknqGYNfknrG4JeknjH4JalnFiT4k5yS5I4kdyU5ZyFqkKS+GnvwJ1kC/B7wU8ARwJlJjhh3HZLUVwtxxn8McFdV3V1VTwAXAqctQB2S1EupqvEeMHk1cEpV/ec2/3rgJVX1phnrrQRWttnDgDvGWuh47Qd8baGL0Jz43C1uO/rz9/yqmpjZuHQhKhlFVa0CVi10HeOQZG1VTS50Hdp6PneLW1+fv4Xo6nkAeN7Q/IGtTZI0BgsR/F8BDk1ycJKdgTOAyxagDknqpbF39VTVk0neBFwBLAE+XlW3jLuO7UwvurR2UD53i1svn7+xf7grSVpYfnNXknrG4JeknjH4R5TkqSQ3JLkxyXVJXjZP+12e5OZZll2Q5KYkb9vKfR6V5Kfno76+SPLtDvf9riT/rav999nQ6/KW9tp8e5JntGWTSX53oWvcHm231/Fvh/5fVR0FkORfA+8DfnJ4hSRLq+rJ+ThYkn8G/HhVvWAOmx8FTAKfnY9apO3Y8OvyOcCfAHsC51bVWmBtlwefz9f8OHnGPzd7At8ESHJ8kr9Ochlwa5IlST6Q5CvtbP0X23p7JFnT3i2sS7LRMBVJfiTJ9Ul+HPg8cEA7m/lXSX6h7fPGJH+aZLe2zc8lubm1f6ldIvtu4LVt29eO6x9lR5PkC0km2/R+Se5p029IckmSzyW5M8lvDm1zSnuOb0yyZmh3R7T93Z3kLeP9TfqhqjYw+Lb/mzJwfJLL4Qfvuj4+8zlo77hvS/KH7V3D55Ps2pYd0p7ja9tr/PDWfn6Sjya5BvjNWcrZvlWVPyP8AE8BNwC3A48AR7f244HHgIPb/ErgnW36mQzOOA5m8O5qz9a+H3AXEGA5cDODYSmuB45s6ywHbh46/r5D0+8F3tym1wEHtOm92uMbgA8v9L/ZYvoBvr2Jti8Ak0PP2T1D/753A88GdgHuZfClxAngH4f+L+zTHt8F/G37/7Af8HVgp4X+nXeEn1met4eBZe21efnmnoP2OnsSOKqtdxHwH9r0GuDQNv0S4K/a9PnA5cCShf795/pjV8/oht9SvhT4RJIXtmVfrqqvtulXAi9qYxLBIBwOBe4Hfj3Jy4HvAwcw+M8Jg8C4FPjZqrp1luO/MMl7gb2APRh8DwLgauD8JBcBl8zD76nRrKmqRwCS3Ao8H9gb+NL0/4Wq+sbQ+n9RVY8DjyfZwOC5v3/MNffdpp4DgK9W1Q1t+lpgeZI9gJcBn04yvf0zh/b16ap6ahxFd8Hgn4Oq+rsk+zEIbBic8U8Lg7PxK4a3SfKGtv7RVfW91m2wS1v8CHAf8BPAbMF/PnB6Vd3Y9nV8q+W/JHkJ8Crg2iRHb9Mvp2FP8nR36C4zlj0+NP0UW34tbe36moMkP8Lg33cD8M9nLJ7tOZjZviuD5/3h6ZO9TXhslvZFwT7+OWh9fUsYvF2c6QrgvybZqa37o0l2Z3Dmv6GF/gkMzhCnPQH8W+Dnk/z7WQ77LGB92+/rhmo5pKquqapfBaYYdDl8q62vbXMPMP2H9NWbWW/a/wVenuRggCT7dFSXNiHJBPBRBt2c2/TN1Kp6FPhqkp9r+06SI+ehzO2CZx2j2zXJ9NvBACuq6qmht4HTPsag3/C6DBZOAacDnwT+PMk6Bv3+tw9vVFWPJfkZ4Mp2aeFNM/b7K8A1bX/X8HSwfyDJoa2mNcCNDN49nNPqfV9VfWqbfvN+2C3JcNfLbwO/BVyUwRDhf7GlHVTVVFv3knZJ4Qbg5E6q1bTp1+VODN6h/TGD524+vA74SJJ3tv1fyOD1teg5ZIMk9YxdPZLUMwa/JPWMwS9JPWPwS1LPGPyS1DMGvzRDkkryf4bmlyaZmh73ZQ77m3UEVmkhGPzSxh5jMETGrm3+ZOCBBaxHmlcGv7Rpn2UwDAbAmcAF0wuS7N5GevxyG031tNa+vI3ieF3m8Z4N0nwz+KVNuxA4I8kuwIsYfFt62v9iMFLjMcAJDL49vTvtm7pV9WPAawFvAqLtkkM2SJtQVTclWc7gbH/mDW1eCZyap++qtQtwEPBPwIeTHMVgsK8fHU+10tYx+KXZXcZgvJ7jgX2H2gP8u6q6Y3jlJO8CHgKOZPBu+rtjqVLaSnb1SLP7OPBrVbVuRvsVwJvbIHwkeXFrfzawvqq+D7yewQiu0nbH4JdmUVX3V9Wm+unfw2C0xpuS3NLmAX4fWJHkRuBwFvmY7dpxOTqnJPWMZ/yS1DMGvyT1jMEvST1j8EtSzxj8ktQzBr8k9YzBL0k98/8B+rXbIp8wFdwAAAAASUVORK5CYII=\n"
          },
          "metadata": {
            "needs_background": "light"
          }
        }
      ],
      "source": [
        "# create a barplot to visualize the average local temperature in F of respondents grouped by preferred meal\n",
        "sn.barplot(x = \"Meal\", y = \"Temperature\", data = Temp_meal_data, ci = False)\n",
        "plt.show()"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 54,
      "metadata": {
        "id": "B48lKLDte2SU"
      },
      "outputs": [],
      "source": [
        "Temp_meal_data.to_csv(\"Temp_meal_data.csv\")"
      ]
    }
  ],
  "metadata": {
    "kernelspec": {
      "display_name": "Python 3.10.6 64-bit (windows store)",
      "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.10.6"
    },
    "orig_nbformat": 4,
    "vscode": {
      "interpreter": {
        "hash": "0ad27ec13ec98793578d4e8ca718d2536b3825e875b73a9cd789d40489666333"
      }
    },
    "colab": {
      "provenance": [],
      "include_colab_link": true
    }
  },
  "nbformat": 4,
  "nbformat_minor": 0
}