pandas_exercise.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "82b115ba",
   "metadata": {},
   "source": [
    "Reza Mosavi 400222100"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "785d9cb9",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "58f4fef2",
   "metadata": {},
   "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>date</th>\n",
       "      <th>city</th>\n",
       "      <th>temperature</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>New York</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>20.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>Miami</td>\n",
       "      <td>24.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>New York</td>\n",
       "      <td>2.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>18.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>New York</td>\n",
       "      <td>4.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>15.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>New York</td>\n",
       "      <td>3.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>16.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>New York</td>\n",
       "      <td>-1.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>22.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2022-01-06</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2022-01-06</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>23.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2022-01-06</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>New York</td>\n",
       "      <td>1.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>20.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>New York</td>\n",
       "      <td>4.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>19.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2022-01-09</td>\n",
       "      <td>New York</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2022-01-09</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>18.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2022-01-09</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>New York</td>\n",
       "      <td>-1.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>22.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>New York</td>\n",
       "      <td>-4.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>21.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>New York</td>\n",
       "      <td>-7.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>24.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>20.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>Miami</td>\n",
       "      <td>19.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>2022-01-14</td>\n",
       "      <td>New York</td>\n",
       "      <td>1.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2022-01-14</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>21.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>2022-01-14</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>2022-01-15</td>\n",
       "      <td>New York</td>\n",
       "      <td>2.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>2022-01-15</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>18.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>2022-01-15</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>2022-01-16</td>\n",
       "      <td>New York</td>\n",
       "      <td>-0.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>2022-01-16</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>23.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>2022-01-16</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>Los Angeles</td>\n",
       "      <td>21.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          date         city  temperature\n",
       "0   2022-01-01     New York          0.5\n",
       "1   2022-01-01  Los Angeles         20.5\n",
       "2   2022-01-01        Miami         24.7\n",
       "3   2022-01-02     New York          2.3\n",
       "4   2022-01-02  Los Angeles         18.4\n",
       "5   2022-01-02        Miami         22.9\n",
       "6   2022-01-03     New York          4.8\n",
       "7   2022-01-03  Los Angeles         15.9\n",
       "8   2022-01-03        Miami         21.2\n",
       "9   2022-01-04     New York          3.2\n",
       "10  2022-01-04  Los Angeles         16.1\n",
       "11  2022-01-04        Miami         23.5\n",
       "12  2022-01-05     New York         -1.9\n",
       "13  2022-01-05  Los Angeles         22.8\n",
       "14  2022-01-05        Miami         20.1\n",
       "15  2022-01-06     New York         -2.1\n",
       "16  2022-01-06  Los Angeles         23.5\n",
       "17  2022-01-06        Miami         25.3\n",
       "18  2022-01-07     New York          1.3\n",
       "19  2022-01-07  Los Angeles         20.3\n",
       "20  2022-01-07        Miami         21.8\n",
       "21  2022-01-08     New York          4.2\n",
       "22  2022-01-08  Los Angeles         19.7\n",
       "23  2022-01-08        Miami         22.4\n",
       "24  2022-01-09     New York          5.8\n",
       "25  2022-01-09  Los Angeles         18.8\n",
       "26  2022-01-09        Miami         20.5\n",
       "27  2022-01-10     New York         -1.1\n",
       "28  2022-01-10  Los Angeles         22.1\n",
       "29  2022-01-10        Miami         23.1\n",
       "30  2022-01-11     New York         -4.6\n",
       "31  2022-01-11  Los Angeles         21.2\n",
       "32  2022-01-11        Miami         25.8\n",
       "33  2022-01-12     New York         -7.3\n",
       "34  2022-01-12  Los Angeles         24.4\n",
       "35  2022-01-12        Miami         22.6\n",
       "36  2022-01-13     New York         -2.4\n",
       "37  2022-01-13  Los Angeles         20.1\n",
       "38  2022-01-13        Miami         19.7\n",
       "39  2022-01-14     New York          1.5\n",
       "40  2022-01-14  Los Angeles         21.5\n",
       "41  2022-01-14        Miami         20.2\n",
       "42  2022-01-15     New York          2.1\n",
       "43  2022-01-15  Los Angeles         18.6\n",
       "44  2022-01-15        Miami         21.5\n",
       "45  2022-01-16     New York         -0.9\n",
       "46  2022-01-16  Los Angeles         23.8\n",
       "47  2022-01-16        Miami         23.9\n",
       "48  2022-01-17     New York         -2.7\n",
       "49  2022-01-17  Los Angeles         21.3\n",
       "50  2022-01-17        Miami         25.3"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temperaturesDataset = pd.read_csv(\"tempratures.csv\")\n",
    "temperaturesDataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "52690631",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(51, 3)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "temperaturesDataset.shape\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "6312dc3a",
   "metadata": {},
   "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>temperature</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>20.529412</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Miami</th>\n",
       "      <td>22.617647</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New York</th>\n",
       "      <td>0.158824</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             temperature\n",
       "city                    \n",
       "Los Angeles    20.529412\n",
       "Miami          22.617647\n",
       "New York        0.158824"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "mean = temperaturesDataset.groupby(\"city\").mean()\n",
    "mean"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "37b31611",
   "metadata": {},
   "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>date</th>\n",
       "      <th>temperature</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>24.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Miami</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>25.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New York</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>5.8</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   date  temperature\n",
       "city                                \n",
       "Los Angeles  2022-01-17         24.4\n",
       "Miami        2022-01-17         25.8\n",
       "New York     2022-01-17          5.8"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max_ = temperaturesDataset.groupby(\"city\").max()\n",
    "max_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "b84535e4",
   "metadata": {},
   "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>date</th>\n",
       "      <th>temperature</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>city</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Los Angeles</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>15.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Miami</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>19.7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>New York</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>-7.3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                   date  temperature\n",
       "city                                \n",
       "Los Angeles  2022-01-01         15.9\n",
       "Miami        2022-01-01         19.7\n",
       "New York     2022-01-01         -7.3"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "min_ = temperaturesDataset.groupby(\"city\").min()\n",
    "min_"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "bee17ca4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "city\n",
       "Los Angeles     8.5\n",
       "Miami           6.1\n",
       "New York       13.1\n",
       "Name: temperature, dtype: float64"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "max_[\"temperature\"] - min_[\"temperature\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "8992fecc",
   "metadata": {},
   "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>city</th>\n",
       "      <th>country</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>New York</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Los Angles</td>\n",
       "      <td>USA</td>\n",
       "      <td>34.0522</td>\n",
       "      <td>-118.2437</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Chicago</td>\n",
       "      <td>USA</td>\n",
       "      <td>41.8781</td>\n",
       "      <td>-87.6298</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Houston</td>\n",
       "      <td>USA</td>\n",
       "      <td>29.7604</td>\n",
       "      <td>-95.3698</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Phoenix</td>\n",
       "      <td>USA</td>\n",
       "      <td>33.4484</td>\n",
       "      <td>-112.0740</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Philadelphia</td>\n",
       "      <td>USA</td>\n",
       "      <td>39.9526</td>\n",
       "      <td>-75.1652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>San Antonio</td>\n",
       "      <td>USA</td>\n",
       "      <td>29.4241</td>\n",
       "      <td>-98.4936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>San Diego</td>\n",
       "      <td>USA</td>\n",
       "      <td>32.7157</td>\n",
       "      <td>-117.1611</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Dallas</td>\n",
       "      <td>USA</td>\n",
       "      <td>32.7767</td>\n",
       "      <td>-96.7970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>San Jose</td>\n",
       "      <td>USA</td>\n",
       "      <td>37.3382</td>\n",
       "      <td>-121.8863</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Miami</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            city country  latitude  longitude\n",
       "0       New York     USA   40.7128   -74.0060\n",
       "1     Los Angles     USA   34.0522  -118.2437\n",
       "2        Chicago     USA   41.8781   -87.6298\n",
       "3        Houston     USA   29.7604   -95.3698\n",
       "4        Phoenix     USA   33.4484  -112.0740\n",
       "5   Philadelphia     USA   39.9526   -75.1652\n",
       "6    San Antonio     USA   29.4241   -98.4936\n",
       "7      San Diego     USA   32.7157  -117.1611\n",
       "8         Dallas     USA   32.7767   -96.7970\n",
       "9       San Jose     USA   37.3382  -121.8863\n",
       "10         Miami     USA   25.7617   -80.1918"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cityDataset = pd.read_csv(\"cities.csv\")\n",
    "cityDataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "79e408ed",
   "metadata": {},
   "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>date</th>\n",
       "      <th>city</th>\n",
       "      <th>temperature</th>\n",
       "      <th>country</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>New York</td>\n",
       "      <td>0.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>New York</td>\n",
       "      <td>2.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>New York</td>\n",
       "      <td>4.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>New York</td>\n",
       "      <td>3.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>New York</td>\n",
       "      <td>-1.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-01-06</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>New York</td>\n",
       "      <td>1.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>New York</td>\n",
       "      <td>4.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2022-01-09</td>\n",
       "      <td>New York</td>\n",
       "      <td>5.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>New York</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>New York</td>\n",
       "      <td>-4.6</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>New York</td>\n",
       "      <td>-7.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.4</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2022-01-14</td>\n",
       "      <td>New York</td>\n",
       "      <td>1.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2022-01-15</td>\n",
       "      <td>New York</td>\n",
       "      <td>2.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2022-01-16</td>\n",
       "      <td>New York</td>\n",
       "      <td>-0.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.7</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>Miami</td>\n",
       "      <td>24.7</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2022-01-06</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.4</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2022-01-09</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.6</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>Miami</td>\n",
       "      <td>19.7</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2022-01-14</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2022-01-15</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2022-01-16</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          date      city  temperature country  latitude  longitude\n",
       "0   2022-01-01  New York          0.5     USA   40.7128   -74.0060\n",
       "1   2022-01-02  New York          2.3     USA   40.7128   -74.0060\n",
       "2   2022-01-03  New York          4.8     USA   40.7128   -74.0060\n",
       "3   2022-01-04  New York          3.2     USA   40.7128   -74.0060\n",
       "4   2022-01-05  New York         -1.9     USA   40.7128   -74.0060\n",
       "5   2022-01-06  New York         -2.1     USA   40.7128   -74.0060\n",
       "6   2022-01-07  New York          1.3     USA   40.7128   -74.0060\n",
       "7   2022-01-08  New York          4.2     USA   40.7128   -74.0060\n",
       "8   2022-01-09  New York          5.8     USA   40.7128   -74.0060\n",
       "9   2022-01-10  New York         -1.1     USA   40.7128   -74.0060\n",
       "10  2022-01-11  New York         -4.6     USA   40.7128   -74.0060\n",
       "11  2022-01-12  New York         -7.3     USA   40.7128   -74.0060\n",
       "12  2022-01-13  New York         -2.4     USA   40.7128   -74.0060\n",
       "13  2022-01-14  New York          1.5     USA   40.7128   -74.0060\n",
       "14  2022-01-15  New York          2.1     USA   40.7128   -74.0060\n",
       "15  2022-01-16  New York         -0.9     USA   40.7128   -74.0060\n",
       "16  2022-01-17  New York         -2.7     USA   40.7128   -74.0060\n",
       "17  2022-01-01     Miami         24.7     USA   25.7617   -80.1918\n",
       "18  2022-01-02     Miami         22.9     USA   25.7617   -80.1918\n",
       "19  2022-01-03     Miami         21.2     USA   25.7617   -80.1918\n",
       "20  2022-01-04     Miami         23.5     USA   25.7617   -80.1918\n",
       "21  2022-01-05     Miami         20.1     USA   25.7617   -80.1918\n",
       "22  2022-01-06     Miami         25.3     USA   25.7617   -80.1918\n",
       "23  2022-01-07     Miami         21.8     USA   25.7617   -80.1918\n",
       "24  2022-01-08     Miami         22.4     USA   25.7617   -80.1918\n",
       "25  2022-01-09     Miami         20.5     USA   25.7617   -80.1918\n",
       "26  2022-01-10     Miami         23.1     USA   25.7617   -80.1918\n",
       "27  2022-01-11     Miami         25.8     USA   25.7617   -80.1918\n",
       "28  2022-01-12     Miami         22.6     USA   25.7617   -80.1918\n",
       "29  2022-01-13     Miami         19.7     USA   25.7617   -80.1918\n",
       "30  2022-01-14     Miami         20.2     USA   25.7617   -80.1918\n",
       "31  2022-01-15     Miami         21.5     USA   25.7617   -80.1918\n",
       "32  2022-01-16     Miami         23.9     USA   25.7617   -80.1918\n",
       "33  2022-01-17     Miami         25.3     USA   25.7617   -80.1918"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged = pd.merge(temperaturesDataset, cityDataset, on=\"city\")\n",
    "df_merged"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "297d8cbc",
   "metadata": {},
   "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>date</th>\n",
       "      <th>city</th>\n",
       "      <th>temperature</th>\n",
       "      <th>country</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>above average</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>New York</td>\n",
       "      <td>0.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>New York</td>\n",
       "      <td>2.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>New York</td>\n",
       "      <td>4.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>New York</td>\n",
       "      <td>3.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>New York</td>\n",
       "      <td>-1.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-01-06</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>New York</td>\n",
       "      <td>1.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>New York</td>\n",
       "      <td>4.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>2022-01-09</td>\n",
       "      <td>New York</td>\n",
       "      <td>5.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>New York</td>\n",
       "      <td>-1.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>New York</td>\n",
       "      <td>-4.6</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>New York</td>\n",
       "      <td>-7.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.4</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2022-01-14</td>\n",
       "      <td>New York</td>\n",
       "      <td>1.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2022-01-15</td>\n",
       "      <td>New York</td>\n",
       "      <td>2.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2022-01-16</td>\n",
       "      <td>New York</td>\n",
       "      <td>-0.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>New York</td>\n",
       "      <td>-2.7</td>\n",
       "      <td>USA</td>\n",
       "      <td>40.7128</td>\n",
       "      <td>-74.0060</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2022-01-01</td>\n",
       "      <td>Miami</td>\n",
       "      <td>24.7</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2022-01-02</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2022-01-03</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2022-01-04</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2022-01-05</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2022-01-06</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2022-01-07</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.4</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2022-01-09</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2022-01-10</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.1</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2022-01-11</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.8</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2022-01-12</td>\n",
       "      <td>Miami</td>\n",
       "      <td>22.6</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2022-01-13</td>\n",
       "      <td>Miami</td>\n",
       "      <td>19.7</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2022-01-14</td>\n",
       "      <td>Miami</td>\n",
       "      <td>20.2</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2022-01-15</td>\n",
       "      <td>Miami</td>\n",
       "      <td>21.5</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2022-01-16</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23.9</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2022-01-17</td>\n",
       "      <td>Miami</td>\n",
       "      <td>25.3</td>\n",
       "      <td>USA</td>\n",
       "      <td>25.7617</td>\n",
       "      <td>-80.1918</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          date      city  temperature country  latitude  longitude  \\\n",
       "0   2022-01-01  New York          0.5     USA   40.7128   -74.0060   \n",
       "1   2022-01-02  New York          2.3     USA   40.7128   -74.0060   \n",
       "2   2022-01-03  New York          4.8     USA   40.7128   -74.0060   \n",
       "3   2022-01-04  New York          3.2     USA   40.7128   -74.0060   \n",
       "4   2022-01-05  New York         -1.9     USA   40.7128   -74.0060   \n",
       "5   2022-01-06  New York         -2.1     USA   40.7128   -74.0060   \n",
       "6   2022-01-07  New York          1.3     USA   40.7128   -74.0060   \n",
       "7   2022-01-08  New York          4.2     USA   40.7128   -74.0060   \n",
       "8   2022-01-09  New York          5.8     USA   40.7128   -74.0060   \n",
       "9   2022-01-10  New York         -1.1     USA   40.7128   -74.0060   \n",
       "10  2022-01-11  New York         -4.6     USA   40.7128   -74.0060   \n",
       "11  2022-01-12  New York         -7.3     USA   40.7128   -74.0060   \n",
       "12  2022-01-13  New York         -2.4     USA   40.7128   -74.0060   \n",
       "13  2022-01-14  New York          1.5     USA   40.7128   -74.0060   \n",
       "14  2022-01-15  New York          2.1     USA   40.7128   -74.0060   \n",
       "15  2022-01-16  New York         -0.9     USA   40.7128   -74.0060   \n",
       "16  2022-01-17  New York         -2.7     USA   40.7128   -74.0060   \n",
       "17  2022-01-01     Miami         24.7     USA   25.7617   -80.1918   \n",
       "18  2022-01-02     Miami         22.9     USA   25.7617   -80.1918   \n",
       "19  2022-01-03     Miami         21.2     USA   25.7617   -80.1918   \n",
       "20  2022-01-04     Miami         23.5     USA   25.7617   -80.1918   \n",
       "21  2022-01-05     Miami         20.1     USA   25.7617   -80.1918   \n",
       "22  2022-01-06     Miami         25.3     USA   25.7617   -80.1918   \n",
       "23  2022-01-07     Miami         21.8     USA   25.7617   -80.1918   \n",
       "24  2022-01-08     Miami         22.4     USA   25.7617   -80.1918   \n",
       "25  2022-01-09     Miami         20.5     USA   25.7617   -80.1918   \n",
       "26  2022-01-10     Miami         23.1     USA   25.7617   -80.1918   \n",
       "27  2022-01-11     Miami         25.8     USA   25.7617   -80.1918   \n",
       "28  2022-01-12     Miami         22.6     USA   25.7617   -80.1918   \n",
       "29  2022-01-13     Miami         19.7     USA   25.7617   -80.1918   \n",
       "30  2022-01-14     Miami         20.2     USA   25.7617   -80.1918   \n",
       "31  2022-01-15     Miami         21.5     USA   25.7617   -80.1918   \n",
       "32  2022-01-16     Miami         23.9     USA   25.7617   -80.1918   \n",
       "33  2022-01-17     Miami         25.3     USA   25.7617   -80.1918   \n",
       "\n",
       "    above average  \n",
       "0           False  \n",
       "1           False  \n",
       "2           False  \n",
       "3           False  \n",
       "4           False  \n",
       "5           False  \n",
       "6           False  \n",
       "7           False  \n",
       "8           False  \n",
       "9           False  \n",
       "10          False  \n",
       "11          False  \n",
       "12          False  \n",
       "13          False  \n",
       "14          False  \n",
       "15          False  \n",
       "16          False  \n",
       "17           True  \n",
       "18           True  \n",
       "19           True  \n",
       "20           True  \n",
       "21           True  \n",
       "22           True  \n",
       "23           True  \n",
       "24           True  \n",
       "25           True  \n",
       "26           True  \n",
       "27           True  \n",
       "28           True  \n",
       "29           True  \n",
       "30           True  \n",
       "31           True  \n",
       "32           True  \n",
       "33           True  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_merged[\"above average\"] = df_merged['temperature'] >= df_merged['temperature'].mean()\n",
    "\n",
    "df_merged"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}