HW_2.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "HW_2.ipynb",
      "provenance": [],
      "collapsed_sections": [],
      "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/shaksiper/db/blob/main/HW_2.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "l73pQTRx9y3v"
      },
      "source": [
        "import pandas as pd\r\n",
        "raw_url = 'https://raw.githubusercontent.com/shaksiper/db/main/cities.csv'\r\n",
        "citiesDataFrame = pd.read_csv(raw_url, skipinitialspace = True, quotechar = '\"')"
      ],
      "execution_count": 1,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "ef5pJ3c698nL",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "outputId": "44b1705a-5d94-48fa-84fe-ead366847d76"
      },
      "source": [
        "citiesDataFrame.head(10)"
      ],
      "execution_count": 2,
      "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>5</th>\n",
              "      <td>36</td>\n",
              "      <td>5</td>\n",
              "      <td>59</td>\n",
              "      <td>N</td>\n",
              "      <td>80</td>\n",
              "      <td>15</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Winston-Salem</td>\n",
              "      <td>NC</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>49</td>\n",
              "      <td>52</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>97</td>\n",
              "      <td>9</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Winnipeg</td>\n",
              "      <td>MB</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>39</td>\n",
              "      <td>11</td>\n",
              "      <td>23</td>\n",
              "      <td>N</td>\n",
              "      <td>78</td>\n",
              "      <td>9</td>\n",
              "      <td>36</td>\n",
              "      <td>W</td>\n",
              "      <td>Winchester</td>\n",
              "      <td>VA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>34</td>\n",
              "      <td>14</td>\n",
              "      <td>24</td>\n",
              "      <td>N</td>\n",
              "      <td>77</td>\n",
              "      <td>55</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Wilmington</td>\n",
              "      <td>NC</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>39</td>\n",
              "      <td>45</td>\n",
              "      <td>0</td>\n",
              "      <td>N</td>\n",
              "      <td>75</td>\n",
              "      <td>33</td>\n",
              "      <td>0</td>\n",
              "      <td>W</td>\n",
              "      <td>Wilmington</td>\n",
              "      <td>DE</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    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",
              "5    36     5    59  N    80    15     0  W    Winston-Salem    NC\n",
              "6    49    52    48  N    97     9     0  W         Winnipeg    MB\n",
              "7    39    11    23  N    78     9    36  W       Winchester    VA\n",
              "8    34    14    24  N    77    55    11  W       Wilmington    NC\n",
              "9    39    45     0  N    75    33     0  W       Wilmington    DE"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "Bg9rieMej0RH",
        "outputId": "33a15627-3bf3-4ec7-e08f-178702b32b6b"
      },
      "source": [
        "citiesDataFrame.tail(10)"
      ],
      "execution_count": 3,
      "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>118</th>\n",
              "      <td>37</td>\n",
              "      <td>16</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>79</td>\n",
              "      <td>56</td>\n",
              "      <td>24</td>\n",
              "      <td>W</td>\n",
              "      <td>Roanoke</td>\n",
              "      <td>VA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>37</td>\n",
              "      <td>32</td>\n",
              "      <td>24</td>\n",
              "      <td>N</td>\n",
              "      <td>77</td>\n",
              "      <td>26</td>\n",
              "      <td>59</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>VA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>39</td>\n",
              "      <td>49</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>84</td>\n",
              "      <td>53</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>IN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121</th>\n",
              "      <td>38</td>\n",
              "      <td>46</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>5</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richfield</td>\n",
              "      <td>UT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122</th>\n",
              "      <td>45</td>\n",
              "      <td>38</td>\n",
              "      <td>23</td>\n",
              "      <td>N</td>\n",
              "      <td>89</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Rhinelander</td>\n",
              "      <td>WI</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",
              "</div>"
            ],
            "text/plain": [
              "     LatD  LatM  LatS NS  LonD  LonM  LonS EW         City State\n",
              "118    37    16    12  N    79    56    24  W      Roanoke    VA\n",
              "119    37    32    24  N    77    26    59  W     Richmond    VA\n",
              "120    39    49    48  N    84    53    23  W     Richmond    IN\n",
              "121    38    46    12  N   112     5    23  W    Richfield    UT\n",
              "122    45    38    23  N    89    25    11  W  Rhinelander    WI\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 "
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 3
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "gO-oRJ_d_V8s"
      },
      "source": [
        "Below is an example for instertion a row/tuple into the table"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "N77IshKIj6G7"
      },
      "source": [
        "#Insert row/tuple\r\n",
        "\r\n",
        "new_row = {'LatD' : 135,\r\n",
        "           'LatM' : 50,\r\n",
        "           'LatS' : 10,\r\n",
        "           'NS'   : 'S',\r\n",
        "           'LonD' : 100,\r\n",
        "           'LonM' : 100,\r\n",
        "           'LonS' : 30,\r\n",
        "           'EW'   : 'E',\r\n",
        "           'City' : 'Aydin',\r\n",
        "           'State': 'TR'}\r\n",
        "citiesDataFrame = citiesDataFrame.append(new_row, ignore_index=True)"
      ],
      "execution_count": 4,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "Ln9JSQie9ufp",
        "outputId": "8a6334b1-e2c3-44e2-cbb2-bfae35045098"
      },
      "source": [
        "citiesDataFrame.tail(10)\r\n"
      ],
      "execution_count": 5,
      "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>119</th>\n",
              "      <td>37</td>\n",
              "      <td>32</td>\n",
              "      <td>24</td>\n",
              "      <td>N</td>\n",
              "      <td>77</td>\n",
              "      <td>26</td>\n",
              "      <td>59</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>VA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>39</td>\n",
              "      <td>49</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>84</td>\n",
              "      <td>53</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>IN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121</th>\n",
              "      <td>38</td>\n",
              "      <td>46</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>5</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richfield</td>\n",
              "      <td>UT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122</th>\n",
              "      <td>45</td>\n",
              "      <td>38</td>\n",
              "      <td>23</td>\n",
              "      <td>N</td>\n",
              "      <td>89</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Rhinelander</td>\n",
              "      <td>WI</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",
              "    <tr>\n",
              "      <th>128</th>\n",
              "      <td>135</td>\n",
              "      <td>50</td>\n",
              "      <td>10</td>\n",
              "      <td>S</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>30</td>\n",
              "      <td>E</td>\n",
              "      <td>Aydin</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",
              "119    37    32    24  N    77    26    59  W     Richmond    VA\n",
              "120    39    49    48  N    84    53    23  W     Richmond    IN\n",
              "121    38    46    12  N   112     5    23  W    Richfield    UT\n",
              "122    45    38    23  N    89    25    11  W  Rhinelander    WI\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",
              "128   135    50    10  S   100   100    30  E        Aydin    TR"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "w5RLPvFc_olO"
      },
      "source": [
        "Below is an example for updating a row/tuple"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "OGRnYS0J_ULF",
        "outputId": "896d1b25-85ab-45d2-901d-f91a871da1fc"
      },
      "source": [
        "citiesDataFrame.loc[citiesDataFrame['City'] == 'Reading', ['NS', 'EW']] = ['S', 'E']\r\n",
        "citiesDataFrame.tail(10)"
      ],
      "execution_count": 6,
      "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>119</th>\n",
              "      <td>37</td>\n",
              "      <td>32</td>\n",
              "      <td>24</td>\n",
              "      <td>N</td>\n",
              "      <td>77</td>\n",
              "      <td>26</td>\n",
              "      <td>59</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>VA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>39</td>\n",
              "      <td>49</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>84</td>\n",
              "      <td>53</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>IN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121</th>\n",
              "      <td>38</td>\n",
              "      <td>46</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>5</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richfield</td>\n",
              "      <td>UT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122</th>\n",
              "      <td>45</td>\n",
              "      <td>38</td>\n",
              "      <td>23</td>\n",
              "      <td>N</td>\n",
              "      <td>89</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Rhinelander</td>\n",
              "      <td>WI</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>S</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>E</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>135</td>\n",
              "      <td>50</td>\n",
              "      <td>10</td>\n",
              "      <td>S</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>30</td>\n",
              "      <td>E</td>\n",
              "      <td>Aydin</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",
              "119    37    32    24  N    77    26    59  W     Richmond    VA\n",
              "120    39    49    48  N    84    53    23  W     Richmond    IN\n",
              "121    38    46    12  N   112     5    23  W    Richfield    UT\n",
              "122    45    38    23  N    89    25    11  W  Rhinelander    WI\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  S    75    55    48  E      Reading    PA\n",
              "127    41     9    35  N    81    14    23  W      Ravenna   OH \n",
              "128   135    50    10  S   100   100    30  E        Aydin    TR"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 6
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "SGIq4z86Avet"
      },
      "source": [
        "Below is an exaple of delete/drop of a specific row/tuple"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "qqh7Lrs-AFjv",
        "outputId": "1c759936-4597-4dfc-a7ee-81e6427bd797"
      },
      "source": [
        "citiesDataFrame.shape"
      ],
      "execution_count": 7,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(129, 10)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 7
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "sS-OQkQqCQdR",
        "outputId": "84e3b9f6-2fd3-40a8-9a4a-cbd5e7bf28ce"
      },
      "source": [
        "where = ((citiesDataFrame.LatD == 50) & (citiesDataFrame.LatM == 25) & (citiesDataFrame.LatS == 11))\r\n",
        "#124 \t50 \t25 \t11 \tN \t104 \t39 \t0 \tW \tRegina \tSA\r\n",
        "#The row is deleted\r\n",
        "citiesDataFrame = citiesDataFrame[~where]\r\n",
        "citiesDataFrame.shape\r\n"
      ],
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(128, 10)"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 8
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 363
        },
        "id": "yIUBywLPCQ5G",
        "outputId": "528410ad-098f-415a-fe45-a73c93b26e50"
      },
      "source": [
        "citiesDataFrame.tail(10)"
      ],
      "execution_count": 9,
      "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>118</th>\n",
              "      <td>37</td>\n",
              "      <td>16</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>79</td>\n",
              "      <td>56</td>\n",
              "      <td>24</td>\n",
              "      <td>W</td>\n",
              "      <td>Roanoke</td>\n",
              "      <td>VA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>119</th>\n",
              "      <td>37</td>\n",
              "      <td>32</td>\n",
              "      <td>24</td>\n",
              "      <td>N</td>\n",
              "      <td>77</td>\n",
              "      <td>26</td>\n",
              "      <td>59</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>VA</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>120</th>\n",
              "      <td>39</td>\n",
              "      <td>49</td>\n",
              "      <td>48</td>\n",
              "      <td>N</td>\n",
              "      <td>84</td>\n",
              "      <td>53</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richmond</td>\n",
              "      <td>IN</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>121</th>\n",
              "      <td>38</td>\n",
              "      <td>46</td>\n",
              "      <td>12</td>\n",
              "      <td>N</td>\n",
              "      <td>112</td>\n",
              "      <td>5</td>\n",
              "      <td>23</td>\n",
              "      <td>W</td>\n",
              "      <td>Richfield</td>\n",
              "      <td>UT</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122</th>\n",
              "      <td>45</td>\n",
              "      <td>38</td>\n",
              "      <td>23</td>\n",
              "      <td>N</td>\n",
              "      <td>89</td>\n",
              "      <td>25</td>\n",
              "      <td>11</td>\n",
              "      <td>W</td>\n",
              "      <td>Rhinelander</td>\n",
              "      <td>WI</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>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>S</td>\n",
              "      <td>75</td>\n",
              "      <td>55</td>\n",
              "      <td>48</td>\n",
              "      <td>E</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>135</td>\n",
              "      <td>50</td>\n",
              "      <td>10</td>\n",
              "      <td>S</td>\n",
              "      <td>100</td>\n",
              "      <td>100</td>\n",
              "      <td>30</td>\n",
              "      <td>E</td>\n",
              "      <td>Aydin</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",
              "118    37    16    12  N    79    56    24  W      Roanoke    VA\n",
              "119    37    32    24  N    77    26    59  W     Richmond    VA\n",
              "120    39    49    48  N    84    53    23  W     Richmond    IN\n",
              "121    38    46    12  N   112     5    23  W    Richfield    UT\n",
              "122    45    38    23  N    89    25    11  W  Rhinelander    WI\n",
              "123    39    31    12  N   119    48    35  W         Reno    NV\n",
              "125    40    10    48  N   122    14    23  W    Red Bluff    CA\n",
              "126    40    19    48  S    75    55    48  E      Reading    PA\n",
              "127    41     9    35  N    81    14    23  W      Ravenna   OH \n",
              "128   135    50    10  S   100   100    30  E        Aydin    TR"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    }
  ]
}