DatabaseManagementHW2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "DatabaseManagementHW2.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "authorship_tag": "ABX9TyP5F6+y9+dLq5XfSorKqWCH",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/eabalta/dbmhw2/blob/main/DatabaseManagementHW2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "dtduI5huHyXK"
      },
      "source": [
        "# Enes Alper Balta - 05170000021"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "W52ZE1dRrpvg",
        "outputId": "ede72567-90d5-437a-aed0-57836f0fd038"
      },
      "source": [
        "import pandas as pd\n",
        "\n",
        "# Creating citiesDataFrame\n",
        "\n",
        "citiesDataFrame = pd.read_csv(\"cities.csv\",quotechar='\"',skipinitialspace=True)\n",
        "\n",
        "citiesDataFrame"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LatD</th>\n",
              "      <th>LatM</th>\n",
              "      <th>LatS</th>\n",
              "      <th>NS</th>\n",
              "      <th>LonD</th>\n",
              "      <th>LonM</th>\n",
              "      <th>LonS</th>\n",
              "      <th>EW</th>\n",
              "      <th>City</th>\n",
              "      <th>State</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>59</td>\n",
              "      <td>N</td>\n",
              "      <td>80</td>\n",
              "      <td>39</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Youngstown</td>\n",
              "      <td>OH</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>42</td>\n",
              "      <td>52</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>97</td>\n",
              "      <td>23</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Yankton</td>\n",
              "      <td>SD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>46</td>\n",
              "      <td>35</td>\n",
              "      <td>59</td>\n",
              "      <td>N</td>\n",
              "      <td>120</td>\n",
              "      <td>30</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Yakima</td>\n",
              "      <td>WA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>42</td>\n",
              "      <td>16</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>71</td>\n",
              "      <td>48</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Worcester</td>\n",
              "      <td>MA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>43</td>\n",
              "      <td>37</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>89</td>\n",
              "      <td>46</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Wisconsin Dells</td>\n",
              "      <td>WI</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>123</th>\n",
              "      <td>39</td>\n",
              "      <td>31</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>119</td>\n",
              "      <td>48</td>\n",
              "      <td>35</td>\n",
              "      <td>W</td>\n",
              "      <td>Reno</td>\n",
              "      <td>NV</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>124</th>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>N</td>\n",
              "      <td>104</td>\n",
              "      <td>39</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Regina</td>\n",
              "      <td>SA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>40</td>\n",
              "      <td>10</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>122</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Red Bluff</td>\n",
              "      <td>CA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>40</td>\n",
              "      <td>19</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>W</td>\n",
              "      <td>Reading</td>\n",
              "      <td>PA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>41</td>\n",
              "      <td>9</td>\n",
              "      <td>35</td>\n",
              "      <td>N</td>\n",
              "      <td>81</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Ravenna</td>\n",
              "      <td>OH</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>128 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     LatD  LatM  LatS NS  LonD  LonM  LonS EW             City State\n",
              "0      41     5    59  N    80    39     0  W       Youngstown    OH\n",
              "1      42    52    48  N    97    23    23  W          Yankton    SD\n",
              "2      46    35    59  N   120    30    36  W           Yakima    WA\n",
              "3      42    16    12  N    71    48     0  W        Worcester    MA\n",
              "4      43    37    48  N    89    46    11  W  Wisconsin Dells    WI\n",
              "..    ...   ...   ... ..   ...   ...   ... ..              ...   ...\n",
              "123    39    31    12  N   119    48    35  W             Reno    NV\n",
              "124    50    25    11  N   104    39     0  W           Regina    SA\n",
              "125    40    10    48  N   122    14    23  W        Red Bluff    CA\n",
              "126    40    19    48  N    75    55    48  W          Reading    PA\n",
              "127    41     9    35  N    81    14    23  W          Ravenna   OH \n",
              "\n",
              "[128 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "id": "XTXjCQ8V8W4A",
        "outputId": "b8237064-9545-4472-f098-e9b4716a3e62"
      },
      "source": [
        "# Insert\n",
        "\n",
        "# Example 1 with loc\n",
        "citiesDataFrame.loc[len(citiesDataFrame.index)] = [41,22,34,\"N\",112,44,36,\"W\",\"Denizli\",\"TR\"]\n",
        "\n",
        "citiesDataFrame.tail()"
      ],
      "execution_count": 21,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LatD</th>\n",
              "      <th>LatM</th>\n",
              "      <th>LatS</th>\n",
              "      <th>NS</th>\n",
              "      <th>LonD</th>\n",
              "      <th>LonM</th>\n",
              "      <th>LonS</th>\n",
              "      <th>EW</th>\n",
              "      <th>City</th>\n",
              "      <th>State</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>124</th>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>N</td>\n",
              "      <td>104</td>\n",
              "      <td>39</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Regina</td>\n",
              "      <td>SA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>40</td>\n",
              "      <td>10</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>122</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Red Bluff</td>\n",
              "      <td>CA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>40</td>\n",
              "      <td>19</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>W</td>\n",
              "      <td>Reading</td>\n",
              "      <td>PA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>41</td>\n",
              "      <td>9</td>\n",
              "      <td>35</td>\n",
              "      <td>N</td>\n",
              "      <td>81</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Ravenna</td>\n",
              "      <td>OH</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128</th>\n",
              "      <td>41</td>\n",
              "      <td>22</td>\n",
              "      <td>34</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>44</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Denizli</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     LatD  LatM  LatS NS  LonD  LonM  LonS EW       City State\n",
              "124    50    25    11  N   104    39     0  W     Regina    SA\n",
              "125    40    10    48  N   122    14    23  W  Red Bluff    CA\n",
              "126    40    19    48  N    75    55    48  W    Reading    PA\n",
              "127    41     9    35  N    81    14    23  W    Ravenna   OH \n",
              "128    41    22    34  N   112    44    36  W    Denizli    TR"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 21
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "id": "j2ua7cvv8k6P",
        "outputId": "130520c6-f79d-4f88-a294-53e1f5223f75"
      },
      "source": [
        "# Insert\n",
        "\n",
        "# Example 2\n",
        "data = {'LatD':50,'LatM':25,'LatS':40,'NS':\"S\",'LonD':125,'LonM':78,'LonS':45,'EW':\"W\",'City':\"Izmir\",'State':\"TR\"}\n",
        "citiesDataFrame = citiesDataFrame.append(data,ignore_index=True)\n",
        "citiesDataFrame.tail()"
      ],
      "execution_count": 22,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LatD</th>\n",
              "      <th>LatM</th>\n",
              "      <th>LatS</th>\n",
              "      <th>NS</th>\n",
              "      <th>LonD</th>\n",
              "      <th>LonM</th>\n",
              "      <th>LonS</th>\n",
              "      <th>EW</th>\n",
              "      <th>City</th>\n",
              "      <th>State</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>40</td>\n",
              "      <td>10</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>122</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Red Bluff</td>\n",
              "      <td>CA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>40</td>\n",
              "      <td>19</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>W</td>\n",
              "      <td>Reading</td>\n",
              "      <td>PA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>41</td>\n",
              "      <td>9</td>\n",
              "      <td>35</td>\n",
              "      <td>N</td>\n",
              "      <td>81</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Ravenna</td>\n",
              "      <td>OH</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128</th>\n",
              "      <td>41</td>\n",
              "      <td>22</td>\n",
              "      <td>34</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>44</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Denizli</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>129</th>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>40</td>\n",
              "      <td>S</td>\n",
              "      <td>125</td>\n",
              "      <td>78</td>\n",
              "      <td>45</td>\n",
              "      <td>W</td>\n",
              "      <td>Izmir</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     LatD  LatM  LatS NS  LonD  LonM  LonS EW       City State\n",
              "125    40    10    48  N   122    14    23  W  Red Bluff    CA\n",
              "126    40    19    48  N    75    55    48  W    Reading    PA\n",
              "127    41     9    35  N    81    14    23  W    Ravenna   OH \n",
              "128    41    22    34  N   112    44    36  W    Denizli    TR\n",
              "129    50    25    40  S   125    78    45  W      Izmir    TR"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 22
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "id": "vke9L71V9TIP",
        "outputId": "ce76ed17-a3fa-4c17-8f8c-acbd7046341c"
      },
      "source": [
        "# Update\n",
        "\n",
        "# Example 1\n",
        "citiesDataFrame.loc[citiesDataFrame['City'] == \"Youngstown\",'State'] = \"TR\"\n",
        "citiesDataFrame.head()"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LatD</th>\n",
              "      <th>LatM</th>\n",
              "      <th>LatS</th>\n",
              "      <th>NS</th>\n",
              "      <th>LonD</th>\n",
              "      <th>LonM</th>\n",
              "      <th>LonS</th>\n",
              "      <th>EW</th>\n",
              "      <th>City</th>\n",
              "      <th>State</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>59</td>\n",
              "      <td>N</td>\n",
              "      <td>80</td>\n",
              "      <td>39</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Youngstown</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>42</td>\n",
              "      <td>52</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>97</td>\n",
              "      <td>23</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Yankton</td>\n",
              "      <td>SD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>46</td>\n",
              "      <td>35</td>\n",
              "      <td>59</td>\n",
              "      <td>N</td>\n",
              "      <td>120</td>\n",
              "      <td>30</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Yakima</td>\n",
              "      <td>WA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>42</td>\n",
              "      <td>16</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>71</td>\n",
              "      <td>48</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Worcester</td>\n",
              "      <td>MA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>43</td>\n",
              "      <td>37</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>89</td>\n",
              "      <td>46</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Wisconsin Dells</td>\n",
              "      <td>WI</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "   LatD  LatM  LatS NS  LonD  LonM  LonS EW             City State\n",
              "0    41     5    59  N    80    39     0  W       Youngstown    TR\n",
              "1    42    52    48  N    97    23    23  W          Yankton    SD\n",
              "2    46    35    59  N   120    30    36  W           Yakima    WA\n",
              "3    42    16    12  N    71    48     0  W        Worcester    MA\n",
              "4    43    37    48  N    89    46    11  W  Wisconsin Dells    WI"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "id": "DgqmdjY0-sZj",
        "outputId": "0be7702f-5c17-43f5-b9dc-48320a8e0e64"
      },
      "source": [
        "# Update\n",
        "\n",
        "# Example 2\n",
        "# citiesDataFrame[128].LatM = 22 => citiesDataFrame[128].LatM = 35\n",
        "citiesDataFrame.loc[citiesDataFrame['LatM'] == 22,'LatM'] = 35\n",
        "citiesDataFrame.tail()"
      ],
      "execution_count": 24,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LatD</th>\n",
              "      <th>LatM</th>\n",
              "      <th>LatS</th>\n",
              "      <th>NS</th>\n",
              "      <th>LonD</th>\n",
              "      <th>LonM</th>\n",
              "      <th>LonS</th>\n",
              "      <th>EW</th>\n",
              "      <th>City</th>\n",
              "      <th>State</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>40</td>\n",
              "      <td>10</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>122</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Red Bluff</td>\n",
              "      <td>CA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>40</td>\n",
              "      <td>19</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>W</td>\n",
              "      <td>Reading</td>\n",
              "      <td>PA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>41</td>\n",
              "      <td>9</td>\n",
              "      <td>35</td>\n",
              "      <td>N</td>\n",
              "      <td>81</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Ravenna</td>\n",
              "      <td>OH</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128</th>\n",
              "      <td>41</td>\n",
              "      <td>35</td>\n",
              "      <td>34</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>44</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Denizli</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>129</th>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>40</td>\n",
              "      <td>S</td>\n",
              "      <td>125</td>\n",
              "      <td>78</td>\n",
              "      <td>45</td>\n",
              "      <td>W</td>\n",
              "      <td>Izmir</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     LatD  LatM  LatS NS  LonD  LonM  LonS EW       City State\n",
              "125    40    10    48  N   122    14    23  W  Red Bluff    CA\n",
              "126    40    19    48  N    75    55    48  W    Reading    PA\n",
              "127    41     9    35  N    81    14    23  W    Ravenna   OH \n",
              "128    41    35    34  N   112    44    36  W    Denizli    TR\n",
              "129    50    25    40  S   125    78    45  W      Izmir    TR"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 24
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 204
        },
        "id": "-VH1flpP92P0",
        "outputId": "4d532598-c555-4ae4-c619-14a2180eac61"
      },
      "source": [
        "# Delete\n",
        "\n",
        "citiesDataFrame = citiesDataFrame.drop([127,129])\n",
        "\n",
        "citiesDataFrame.tail()"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LatD</th>\n",
              "      <th>LatM</th>\n",
              "      <th>LatS</th>\n",
              "      <th>NS</th>\n",
              "      <th>LonD</th>\n",
              "      <th>LonM</th>\n",
              "      <th>LonS</th>\n",
              "      <th>EW</th>\n",
              "      <th>City</th>\n",
              "      <th>State</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>123</th>\n",
              "      <td>39</td>\n",
              "      <td>31</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>119</td>\n",
              "      <td>48</td>\n",
              "      <td>35</td>\n",
              "      <td>W</td>\n",
              "      <td>Reno</td>\n",
              "      <td>NV</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>124</th>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>N</td>\n",
              "      <td>104</td>\n",
              "      <td>39</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Regina</td>\n",
              "      <td>SA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>40</td>\n",
              "      <td>10</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>122</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Red Bluff</td>\n",
              "      <td>CA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>40</td>\n",
              "      <td>19</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>W</td>\n",
              "      <td>Reading</td>\n",
              "      <td>PA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>128</th>\n",
              "      <td>41</td>\n",
              "      <td>35</td>\n",
              "      <td>34</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>44</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Denizli</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "     LatD  LatM  LatS NS  LonD  LonM  LonS EW       City State\n",
              "123    39    31    12  N   119    48    35  W       Reno    NV\n",
              "124    50    25    11  N   104    39     0  W     Regina    SA\n",
              "125    40    10    48  N   122    14    23  W  Red Bluff    CA\n",
              "126    40    19    48  N    75    55    48  W    Reading    PA\n",
              "128    41    35    34  N   112    44    36  W    Denizli    TR"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 419
        },
        "id": "QNLVSiNmAAtm",
        "outputId": "6f07d07a-7c67-4d9a-eb9d-c18deb804e0a"
      },
      "source": [
        "# Reindexing primary key\n",
        "\n",
        "citiesDataFrame = citiesDataFrame.reset_index(drop=True)\n",
        "citiesDataFrame"
      ],
      "execution_count": 26,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>LatD</th>\n",
              "      <th>LatM</th>\n",
              "      <th>LatS</th>\n",
              "      <th>NS</th>\n",
              "      <th>LonD</th>\n",
              "      <th>LonM</th>\n",
              "      <th>LonS</th>\n",
              "      <th>EW</th>\n",
              "      <th>City</th>\n",
              "      <th>State</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>41</td>\n",
              "      <td>5</td>\n",
              "      <td>59</td>\n",
              "      <td>N</td>\n",
              "      <td>80</td>\n",
              "      <td>39</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Youngstown</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>42</td>\n",
              "      <td>52</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>97</td>\n",
              "      <td>23</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Yankton</td>\n",
              "      <td>SD</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>46</td>\n",
              "      <td>35</td>\n",
              "      <td>59</td>\n",
              "      <td>N</td>\n",
              "      <td>120</td>\n",
              "      <td>30</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Yakima</td>\n",
              "      <td>WA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>42</td>\n",
              "      <td>16</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>71</td>\n",
              "      <td>48</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Worcester</td>\n",
              "      <td>MA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>43</td>\n",
              "      <td>37</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>89</td>\n",
              "      <td>46</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Wisconsin Dells</td>\n",
              "      <td>WI</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>123</th>\n",
              "      <td>39</td>\n",
              "      <td>31</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>119</td>\n",
              "      <td>48</td>\n",
              "      <td>35</td>\n",
              "      <td>W</td>\n",
              "      <td>Reno</td>\n",
              "      <td>NV</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>124</th>\n",
              "      <td>50</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>N</td>\n",
              "      <td>104</td>\n",
              "      <td>39</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Regina</td>\n",
              "      <td>SA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>125</th>\n",
              "      <td>40</td>\n",
              "      <td>10</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>122</td>\n",
              "      <td>14</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Red Bluff</td>\n",
              "      <td>CA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>126</th>\n",
              "      <td>40</td>\n",
              "      <td>19</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>W</td>\n",
              "      <td>Reading</td>\n",
              "      <td>PA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>127</th>\n",
              "      <td>41</td>\n",
              "      <td>35</td>\n",
              "      <td>34</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>44</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Denizli</td>\n",
              "      <td>TR</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>128 rows × 10 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "     LatD  LatM  LatS NS  LonD  LonM  LonS EW             City State\n",
              "0      41     5    59  N    80    39     0  W       Youngstown    TR\n",
              "1      42    52    48  N    97    23    23  W          Yankton    SD\n",
              "2      46    35    59  N   120    30    36  W           Yakima    WA\n",
              "3      42    16    12  N    71    48     0  W        Worcester    MA\n",
              "4      43    37    48  N    89    46    11  W  Wisconsin Dells    WI\n",
              "..    ...   ...   ... ..   ...   ...   ... ..              ...   ...\n",
              "123    39    31    12  N   119    48    35  W             Reno    NV\n",
              "124    50    25    11  N   104    39     0  W           Regina    SA\n",
              "125    40    10    48  N   122    14    23  W        Red Bluff    CA\n",
              "126    40    19    48  N    75    55    48  W          Reading    PA\n",
              "127    41    35    34  N   112    44    36  W          Denizli    TR\n",
              "\n",
              "[128 rows x 10 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    }
  ]
}