Temp_Clean3.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Temp_Clean3.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyN8hIUf3MxMKwyIKM8tdDz/",
      "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/kvinne-anc/Conflict-and-Climate-Project/blob/main/Temp_Clean3.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Tpa0iuQZFwzt"
      },
      "source": [
        "import pandas as pd\n",
        "import numpy as np"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "yWTcFu42F3v-",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "138d5bfe-ba4a-4af4-a365-15207d69f3fa"
      },
      "source": [
        "Temp = pd.read_csv('/content/Temp_C2.csv')\n",
        "Temp"
      ],
      "execution_count": null,
      "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>Unnamed: 0</th>\n",
              "      <th>Unnamed: 0.1</th>\n",
              "      <th>dt</th>\n",
              "      <th>AverageTemperature</th>\n",
              "      <th>AverageTemperatureUncertainty</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>0</td>\n",
              "      <td>3239</td>\n",
              "      <td>1743-11-01</td>\n",
              "      <td>10.013</td>\n",
              "      <td>2.291</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1</td>\n",
              "      <td>3240</td>\n",
              "      <td>1743-12-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>2</td>\n",
              "      <td>3241</td>\n",
              "      <td>1744-01-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>3</td>\n",
              "      <td>3242</td>\n",
              "      <td>1744-02-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>4</td>\n",
              "      <td>3243</td>\n",
              "      <td>1744-03-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421738</th>\n",
              "      <td>495039</td>\n",
              "      <td>1447727</td>\n",
              "      <td>1875-04-01</td>\n",
              "      <td>33.094</td>\n",
              "      <td>0.414</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421739</th>\n",
              "      <td>495040</td>\n",
              "      <td>1447728</td>\n",
              "      <td>1875-05-01</td>\n",
              "      <td>34.930</td>\n",
              "      <td>0.338</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421740</th>\n",
              "      <td>495041</td>\n",
              "      <td>1447729</td>\n",
              "      <td>1875-06-01</td>\n",
              "      <td>30.957</td>\n",
              "      <td>1.280</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421741</th>\n",
              "      <td>495042</td>\n",
              "      <td>1447730</td>\n",
              "      <td>1875-07-01</td>\n",
              "      <td>26.991</td>\n",
              "      <td>0.837</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421742</th>\n",
              "      <td>495043</td>\n",
              "      <td>1447731</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>421743 rows × 9 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "        Unnamed: 0  Unnamed: 0.1          dt  ...  Country  Latitude Longitude\n",
              "0                0          3239  1743-11-01  ...   Turkey    40.99N    27.69E\n",
              "1                1          3240  1743-12-01  ...   Turkey    40.99N    27.69E\n",
              "2                2          3241  1744-01-01  ...   Turkey    40.99N    27.69E\n",
              "3                3          3242  1744-02-01  ...   Turkey    40.99N    27.69E\n",
              "4                4          3243  1744-03-01  ...   Turkey    40.99N    27.69E\n",
              "...            ...           ...         ...  ...      ...       ...       ...\n",
              "421738      495039       1447727  1875-04-01  ...    India    20.09N    78.48E\n",
              "421739      495040       1447728  1875-05-01  ...    India    20.09N    78.48E\n",
              "421740      495041       1447729  1875-06-01  ...    India    20.09N    78.48E\n",
              "421741      495042       1447730  1875-07-01  ...    India    20.09N    78.48E\n",
              "421742      495043       1447731         NaN  ...      NaN       NaN       NaN\n",
              "\n",
              "[421743 rows x 9 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "CYxWMKaFGTci",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "142ef063-732b-4b91-c05c-851cbc76f9a9"
      },
      "source": [
        "Temp_C = Temp.drop(['Unnamed: 0', 'Unnamed: 0.1', 'AverageTemperatureUncertainty'], axis=1)\n",
        "Temp_C"
      ],
      "execution_count": null,
      "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>dt</th>\n",
              "      <th>AverageTemperature</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>1743-11-01</td>\n",
              "      <td>10.013</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1743-12-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1744-01-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1744-02-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1744-03-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421738</th>\n",
              "      <td>1875-04-01</td>\n",
              "      <td>33.094</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421739</th>\n",
              "      <td>1875-05-01</td>\n",
              "      <td>34.930</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421740</th>\n",
              "      <td>1875-06-01</td>\n",
              "      <td>30.957</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421741</th>\n",
              "      <td>1875-07-01</td>\n",
              "      <td>26.991</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421742</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>421743 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                dt  AverageTemperature        City Country Latitude Longitude\n",
              "0       1743-11-01              10.013       Çorlu  Turkey   40.99N    27.69E\n",
              "1       1743-12-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "2       1744-01-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "3       1744-02-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "4       1744-03-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "...            ...                 ...         ...     ...      ...       ...\n",
              "421738  1875-04-01              33.094  Chandrapur   India   20.09N    78.48E\n",
              "421739  1875-05-01              34.930  Chandrapur   India   20.09N    78.48E\n",
              "421740  1875-06-01              30.957  Chandrapur   India   20.09N    78.48E\n",
              "421741  1875-07-01              26.991  Chandrapur   India   20.09N    78.48E\n",
              "421742         NaN                 NaN         NaN     NaN      NaN       NaN\n",
              "\n",
              "[421743 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "mHgOixQBGb_l",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "b4ddc58d-ad32-489b-b759-fb66a8e9b7fc"
      },
      "source": [
        "Temp_C.dropna()"
      ],
      "execution_count": null,
      "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>dt</th>\n",
              "      <th>AverageTemperature</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>1743-11-01</td>\n",
              "      <td>10.013</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>1744-04-01</td>\n",
              "      <td>13.685</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>1744-05-01</td>\n",
              "      <td>15.021</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>1744-06-01</td>\n",
              "      <td>19.663</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>1744-07-01</td>\n",
              "      <td>22.314</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421737</th>\n",
              "      <td>1875-03-01</td>\n",
              "      <td>29.922</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421738</th>\n",
              "      <td>1875-04-01</td>\n",
              "      <td>33.094</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421739</th>\n",
              "      <td>1875-05-01</td>\n",
              "      <td>34.930</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421740</th>\n",
              "      <td>1875-06-01</td>\n",
              "      <td>30.957</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421741</th>\n",
              "      <td>1875-07-01</td>\n",
              "      <td>26.991</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>404212 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                dt  AverageTemperature        City Country Latitude Longitude\n",
              "0       1743-11-01              10.013       Çorlu  Turkey   40.99N    27.69E\n",
              "5       1744-04-01              13.685       Çorlu  Turkey   40.99N    27.69E\n",
              "6       1744-05-01              15.021       Çorlu  Turkey   40.99N    27.69E\n",
              "7       1744-06-01              19.663       Çorlu  Turkey   40.99N    27.69E\n",
              "8       1744-07-01              22.314       Çorlu  Turkey   40.99N    27.69E\n",
              "...            ...                 ...         ...     ...      ...       ...\n",
              "421737  1875-03-01              29.922  Chandrapur   India   20.09N    78.48E\n",
              "421738  1875-04-01              33.094  Chandrapur   India   20.09N    78.48E\n",
              "421739  1875-05-01              34.930  Chandrapur   India   20.09N    78.48E\n",
              "421740  1875-06-01              30.957  Chandrapur   India   20.09N    78.48E\n",
              "421741  1875-07-01              26.991  Chandrapur   India   20.09N    78.48E\n",
              "\n",
              "[404212 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "D5_vagN3HMcL",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 935
        },
        "outputId": "c1bc55a7-c70b-4b1b-dce2-572560a6d969"
      },
      "source": [
        "Temp_C.sample(30)"
      ],
      "execution_count": null,
      "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>dt</th>\n",
              "      <th>AverageTemperature</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>338545</th>\n",
              "      <td>1861-10-01</td>\n",
              "      <td>24.917</td>\n",
              "      <td>Bihar</td>\n",
              "      <td>India</td>\n",
              "      <td>24.92N</td>\n",
              "      <td>85.12E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>116235</th>\n",
              "      <td>1950-04-01</td>\n",
              "      <td>11.087</td>\n",
              "      <td>Ardabil</td>\n",
              "      <td>Iran</td>\n",
              "      <td>37.78N</td>\n",
              "      <td>48.81E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>141205</th>\n",
              "      <td>1971-02-01</td>\n",
              "      <td>3.663</td>\n",
              "      <td>Babol</td>\n",
              "      <td>Iran</td>\n",
              "      <td>36.17N</td>\n",
              "      <td>51.71E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>91142</th>\n",
              "      <td>1832-06-01</td>\n",
              "      <td>17.374</td>\n",
              "      <td>Ankara</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>39.38N</td>\n",
              "      <td>33.29E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>84222</th>\n",
              "      <td>1889-06-01</td>\n",
              "      <td>23.856</td>\n",
              "      <td>Andijon</td>\n",
              "      <td>Uzbekistan</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>72.43E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>122368</th>\n",
              "      <td>1843-11-01</td>\n",
              "      <td>17.794</td>\n",
              "      <td>Ashdod</td>\n",
              "      <td>Israel</td>\n",
              "      <td>31.35N</td>\n",
              "      <td>33.93E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>281838</th>\n",
              "      <td>1926-09-01</td>\n",
              "      <td>17.348</td>\n",
              "      <td>Benxi</td>\n",
              "      <td>China</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>123.55E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>58173</th>\n",
              "      <td>1965-03-01</td>\n",
              "      <td>25.180</td>\n",
              "      <td>Ambarnath</td>\n",
              "      <td>India</td>\n",
              "      <td>18.48N</td>\n",
              "      <td>72.68E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>214284</th>\n",
              "      <td>1883-08-01</td>\n",
              "      <td>28.553</td>\n",
              "      <td>Barakpur</td>\n",
              "      <td>India</td>\n",
              "      <td>23.31N</td>\n",
              "      <td>88.25E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>166989</th>\n",
              "      <td>1882-10-01</td>\n",
              "      <td>6.214</td>\n",
              "      <td>Baicheng</td>\n",
              "      <td>China</td>\n",
              "      <td>45.81N</td>\n",
              "      <td>123.46E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>194313</th>\n",
              "      <td>1833-11-01</td>\n",
              "      <td>22.934</td>\n",
              "      <td>Bangalore</td>\n",
              "      <td>India</td>\n",
              "      <td>12.05N</td>\n",
              "      <td>77.26E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>105145</th>\n",
              "      <td>1833-07-01</td>\n",
              "      <td>22.250</td>\n",
              "      <td>Antalya</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>37.78N</td>\n",
              "      <td>30.51E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>270965</th>\n",
              "      <td>1992-10-01</td>\n",
              "      <td>26.833</td>\n",
              "      <td>Bellary</td>\n",
              "      <td>India</td>\n",
              "      <td>15.27N</td>\n",
              "      <td>77.50E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>235498</th>\n",
              "      <td>1929-08-01</td>\n",
              "      <td>28.719</td>\n",
              "      <td>Basirhat</td>\n",
              "      <td>India</td>\n",
              "      <td>23.31N</td>\n",
              "      <td>88.25E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>286318</th>\n",
              "      <td>1864-07-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Bhadravati</td>\n",
              "      <td>India</td>\n",
              "      <td>13.66N</td>\n",
              "      <td>75.14E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>390022</th>\n",
              "      <td>1970-09-01</td>\n",
              "      <td>29.424</td>\n",
              "      <td>Bulandshahr</td>\n",
              "      <td>India</td>\n",
              "      <td>28.13N</td>\n",
              "      <td>77.27E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>385516</th>\n",
              "      <td>1812-12-01</td>\n",
              "      <td>-1.369</td>\n",
              "      <td>Bukan</td>\n",
              "      <td>Iran</td>\n",
              "      <td>36.17N</td>\n",
              "      <td>45.75E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>337340</th>\n",
              "      <td>1979-02-01</td>\n",
              "      <td>24.670</td>\n",
              "      <td>Bidar</td>\n",
              "      <td>India</td>\n",
              "      <td>18.48N</td>\n",
              "      <td>77.75E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>88505</th>\n",
              "      <td>1871-06-01</td>\n",
              "      <td>21.542</td>\n",
              "      <td>Ankang</td>\n",
              "      <td>China</td>\n",
              "      <td>32.95N</td>\n",
              "      <td>108.19E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>69699</th>\n",
              "      <td>1880-02-01</td>\n",
              "      <td>13.572</td>\n",
              "      <td>Amritsar</td>\n",
              "      <td>India</td>\n",
              "      <td>31.35N</td>\n",
              "      <td>75.39E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49508</th>\n",
              "      <td>1905-09-01</td>\n",
              "      <td>25.510</td>\n",
              "      <td>Aizawl</td>\n",
              "      <td>India</td>\n",
              "      <td>23.31N</td>\n",
              "      <td>93.50E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>182494</th>\n",
              "      <td>1905-09-01</td>\n",
              "      <td>28.568</td>\n",
              "      <td>Bally</td>\n",
              "      <td>India</td>\n",
              "      <td>23.31N</td>\n",
              "      <td>88.25E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>213485</th>\n",
              "      <td>1817-01-01</td>\n",
              "      <td>17.814</td>\n",
              "      <td>Barakpur</td>\n",
              "      <td>India</td>\n",
              "      <td>23.31N</td>\n",
              "      <td>88.25E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46317</th>\n",
              "      <td>1857-07-01</td>\n",
              "      <td>35.812</td>\n",
              "      <td>Ahvaz</td>\n",
              "      <td>Iran</td>\n",
              "      <td>31.35N</td>\n",
              "      <td>49.01E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>152641</th>\n",
              "      <td>1928-09-01</td>\n",
              "      <td>16.612</td>\n",
              "      <td>Baglan</td>\n",
              "      <td>Afghanistan</td>\n",
              "      <td>36.17N</td>\n",
              "      <td>69.61E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>260162</th>\n",
              "      <td>1943-08-01</td>\n",
              "      <td>28.236</td>\n",
              "      <td>Beihai</td>\n",
              "      <td>China</td>\n",
              "      <td>21.70N</td>\n",
              "      <td>109.90E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>326702</th>\n",
              "      <td>1963-08-01</td>\n",
              "      <td>28.102</td>\n",
              "      <td>Bhubaneswar</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>85.31E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>404916</th>\n",
              "      <td>1932-10-01</td>\n",
              "      <td>27.862</td>\n",
              "      <td>Calcutta</td>\n",
              "      <td>India</td>\n",
              "      <td>23.31N</td>\n",
              "      <td>88.25E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>177757</th>\n",
              "      <td>1946-06-01</td>\n",
              "      <td>29.536</td>\n",
              "      <td>Baleshwar</td>\n",
              "      <td>India</td>\n",
              "      <td>21.70N</td>\n",
              "      <td>87.40E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>267104</th>\n",
              "      <td>1888-10-01</td>\n",
              "      <td>25.981</td>\n",
              "      <td>Belgaum</td>\n",
              "      <td>India</td>\n",
              "      <td>15.27N</td>\n",
              "      <td>74.17E</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>"
            ],
            "text/plain": [
              "                dt  AverageTemperature  ... Latitude Longitude\n",
              "338545  1861-10-01              24.917  ...   24.92N    85.12E\n",
              "116235  1950-04-01              11.087  ...   37.78N    48.81E\n",
              "141205  1971-02-01               3.663  ...   36.17N    51.71E\n",
              "91142   1832-06-01              17.374  ...   39.38N    33.29E\n",
              "84222   1889-06-01              23.856  ...   40.99N    72.43E\n",
              "122368  1843-11-01              17.794  ...   31.35N    33.93E\n",
              "281838  1926-09-01              17.348  ...   40.99N   123.55E\n",
              "58173   1965-03-01              25.180  ...   18.48N    72.68E\n",
              "214284  1883-08-01              28.553  ...   23.31N    88.25E\n",
              "166989  1882-10-01               6.214  ...   45.81N   123.46E\n",
              "194313  1833-11-01              22.934  ...   12.05N    77.26E\n",
              "105145  1833-07-01              22.250  ...   37.78N    30.51E\n",
              "270965  1992-10-01              26.833  ...   15.27N    77.50E\n",
              "235498  1929-08-01              28.719  ...   23.31N    88.25E\n",
              "286318  1864-07-01                 NaN  ...   13.66N    75.14E\n",
              "390022  1970-09-01              29.424  ...   28.13N    77.27E\n",
              "385516  1812-12-01              -1.369  ...   36.17N    45.75E\n",
              "337340  1979-02-01              24.670  ...   18.48N    77.75E\n",
              "88505   1871-06-01              21.542  ...   32.95N   108.19E\n",
              "69699   1880-02-01              13.572  ...   31.35N    75.39E\n",
              "49508   1905-09-01              25.510  ...   23.31N    93.50E\n",
              "182494  1905-09-01              28.568  ...   23.31N    88.25E\n",
              "213485  1817-01-01              17.814  ...   23.31N    88.25E\n",
              "46317   1857-07-01              35.812  ...   31.35N    49.01E\n",
              "152641  1928-09-01              16.612  ...   36.17N    69.61E\n",
              "260162  1943-08-01              28.236  ...   21.70N   109.90E\n",
              "326702  1963-08-01              28.102  ...   20.09N    85.31E\n",
              "404916  1932-10-01              27.862  ...   23.31N    88.25E\n",
              "177757  1946-06-01              29.536  ...   21.70N    87.40E\n",
              "267104  1888-10-01              25.981  ...   15.27N    74.17E\n",
              "\n",
              "[30 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "2so78XzrHPwF",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 402
        },
        "outputId": "0bcbf4c8-fd75-4048-aded-b21ec0055499"
      },
      "source": [
        "Temp_C"
      ],
      "execution_count": null,
      "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>dt</th>\n",
              "      <th>AverageTemperature</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>1743-11-01</td>\n",
              "      <td>10.013</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>1743-12-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1744-01-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>1744-02-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>1744-03-01</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Çorlu</td>\n",
              "      <td>Turkey</td>\n",
              "      <td>40.99N</td>\n",
              "      <td>27.69E</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",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421738</th>\n",
              "      <td>1875-04-01</td>\n",
              "      <td>33.094</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421739</th>\n",
              "      <td>1875-05-01</td>\n",
              "      <td>34.930</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421740</th>\n",
              "      <td>1875-06-01</td>\n",
              "      <td>30.957</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421741</th>\n",
              "      <td>1875-07-01</td>\n",
              "      <td>26.991</td>\n",
              "      <td>Chandrapur</td>\n",
              "      <td>India</td>\n",
              "      <td>20.09N</td>\n",
              "      <td>78.48E</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>421742</th>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>421743 rows × 6 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                dt  AverageTemperature        City Country Latitude Longitude\n",
              "0       1743-11-01              10.013       Çorlu  Turkey   40.99N    27.69E\n",
              "1       1743-12-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "2       1744-01-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "3       1744-02-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "4       1744-03-01                 NaN       Çorlu  Turkey   40.99N    27.69E\n",
              "...            ...                 ...         ...     ...      ...       ...\n",
              "421738  1875-04-01              33.094  Chandrapur   India   20.09N    78.48E\n",
              "421739  1875-05-01              34.930  Chandrapur   India   20.09N    78.48E\n",
              "421740  1875-06-01              30.957  Chandrapur   India   20.09N    78.48E\n",
              "421741  1875-07-01              26.991  Chandrapur   India   20.09N    78.48E\n",
              "421742         NaN                 NaN         NaN     NaN      NaN       NaN\n",
              "\n",
              "[421743 rows x 6 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "E-CPTzgpHT-O"
      },
      "source": [
        "Temp_C.to_csv(r'C:\\Users\\surfb\\OneDrive\\Desktop\\Temp_C3.csv', header=True)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DgLX-FVbHqXS"
      },
      "source": [
        ""
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}