DateTime-Temperature-transformation.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "5c9a581a",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "8add8192",
   "metadata": {},
   "source": [
    "With \"basic\" csv files which i get from GEE, datetimes and sst data are transformed (also organized in df) for analysis and forecasting. In this case January 1-13 of 1985 temperatures in each of the 11 points of interest."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "0fd084d1",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfa = pd.read_csv(\"cero85.csv\")\n",
    "dfb = pd.read_csv(\"uno85.csv\")\n",
    "dfc = pd.read_csv(\"dos85.csv\")\n",
    "dfd = pd.read_csv(\"tres85.csv\")\n",
    "dfe = pd.read_csv(\"cuatro85.csv\")\n",
    "dff = pd.read_csv(\"cinco85.csv\")\n",
    "dfg = pd.read_csv(\"seis85.csv\")\n",
    "dfh = pd.read_csv(\"siete85.csv\")\n",
    "dfi = pd.read_csv(\"ocho85.csv\")\n",
    "dfj = pd.read_csv(\"nueve85.csv\")\n",
    "dfk = pd.read_csv(\"diez85.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "912ee1cd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>sst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Jan 1, 1985</td>\n",
       "      <td>2,659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Jan 2, 1985</td>\n",
       "      <td>2,630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Jan 3, 1985</td>\n",
       "      <td>2,634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Jan 4, 1985</td>\n",
       "      <td>2,763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Jan 5, 1985</td>\n",
       "      <td>2,790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Jan 6, 1985</td>\n",
       "      <td>2,717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Jan 7, 1985</td>\n",
       "      <td>2,657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Jan 8, 1985</td>\n",
       "      <td>2,669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Jan 9, 1985</td>\n",
       "      <td>2,651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Jan 10, 1985</td>\n",
       "      <td>2,643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Jan 11, 1985</td>\n",
       "      <td>2,643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Jan 12, 1985</td>\n",
       "      <td>2,643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Jan 13, 1985</td>\n",
       "      <td>2,638</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            Time    sst\n",
       "0    Jan 1, 1985  2,659\n",
       "1    Jan 2, 1985  2,630\n",
       "2    Jan 3, 1985  2,634\n",
       "3    Jan 4, 1985  2,763\n",
       "4    Jan 5, 1985  2,790\n",
       "5    Jan 6, 1985  2,717\n",
       "6    Jan 7, 1985  2,657\n",
       "7    Jan 8, 1985  2,669\n",
       "8    Jan 9, 1985  2,651\n",
       "9   Jan 10, 1985  2,643\n",
       "10  Jan 11, 1985  2,643\n",
       "11  Jan 12, 1985  2,643\n",
       "12  Jan 13, 1985  2,638"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1326b785",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Time    object\n",
       "sst     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfa.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f1522ddb",
   "metadata": {},
   "source": [
    "Converting Time column from object to DateTime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "01549d3a",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfa[\"Time\"] = pd.to_datetime(dfa[\"Time\"])\n",
    "dfb[\"Time\"] = pd.to_datetime(dfb[\"Time\"])\n",
    "dfc[\"Time\"] = pd.to_datetime(dfc[\"Time\"])\n",
    "dfd[\"Time\"] = pd.to_datetime(dfd[\"Time\"])\n",
    "dfe[\"Time\"] = pd.to_datetime(dfe[\"Time\"])\n",
    "dff[\"Time\"] = pd.to_datetime(dff[\"Time\"])\n",
    "dfg[\"Time\"] = pd.to_datetime(dfg[\"Time\"])\n",
    "dfh[\"Time\"] = pd.to_datetime(dfh[\"Time\"])\n",
    "dfi[\"Time\"] = pd.to_datetime(dfi[\"Time\"])\n",
    "dfj[\"Time\"] = pd.to_datetime(dfj[\"Time\"])\n",
    "dfk[\"Time\"] = pd.to_datetime(dfk[\"Time\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "63fa103d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>sst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1985-01-01</td>\n",
       "      <td>2,659</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1985-01-02</td>\n",
       "      <td>2,630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1985-01-03</td>\n",
       "      <td>2,634</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1985-01-04</td>\n",
       "      <td>2,763</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1985-01-05</td>\n",
       "      <td>2,790</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1985-01-06</td>\n",
       "      <td>2,717</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1985-01-07</td>\n",
       "      <td>2,657</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1985-01-08</td>\n",
       "      <td>2,669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1985-01-09</td>\n",
       "      <td>2,651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1985-01-10</td>\n",
       "      <td>2,643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1985-01-11</td>\n",
       "      <td>2,643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1985-01-12</td>\n",
       "      <td>2,643</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1985-01-13</td>\n",
       "      <td>2,638</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Time    sst\n",
       "0  1985-01-01  2,659\n",
       "1  1985-01-02  2,630\n",
       "2  1985-01-03  2,634\n",
       "3  1985-01-04  2,763\n",
       "4  1985-01-05  2,790\n",
       "5  1985-01-06  2,717\n",
       "6  1985-01-07  2,657\n",
       "7  1985-01-08  2,669\n",
       "8  1985-01-09  2,651\n",
       "9  1985-01-10  2,643\n",
       "10 1985-01-11  2,643\n",
       "11 1985-01-12  2,643\n",
       "12 1985-01-13  2,638"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "eb0f0592",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Time    datetime64[ns]\n",
       "sst             object\n",
       "dtype: object"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfa.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fb6b563f",
   "metadata": {},
   "source": [
    "Converting SST column in numeric for all DF"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "a2073c77",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfa[\"sst_replace\"] = dfa[\"sst\"].str.replace(\",\",\"\")\n",
    "dfa[\"sst_replace\"] = pd.to_numeric(dfa[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "4cb3cb08",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfb[\"sst_replace\"] = dfb[\"sst\"].str.replace(\",\",\"\")\n",
    "dfb[\"sst_replace\"] = pd.to_numeric(dfb[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "4e0636e9",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfc[\"sst_replace\"] = dfc[\"sst\"].str.replace(\",\",\"\")\n",
    "dfc[\"sst_replace\"] = pd.to_numeric(dfc[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "7098b123",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfd[\"sst_replace\"] = dfd[\"sst\"].str.replace(\",\",\"\")\n",
    "dfd[\"sst_replace\"] = pd.to_numeric(dfd[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "1a0073e1",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfe[\"sst_replace\"] = dfe[\"sst\"].str.replace(\",\",\"\")\n",
    "dfe[\"sst_replace\"] = pd.to_numeric(dfe[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "0fad13c8",
   "metadata": {},
   "outputs": [],
   "source": [
    "dff[\"sst_replace\"] = dff[\"sst\"].str.replace(\",\",\"\")\n",
    "dff[\"sst_replace\"] = pd.to_numeric(dff[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "56119698",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfg[\"sst_replace\"] = dfg[\"sst\"].str.replace(\",\",\"\")\n",
    "dfg[\"sst_replace\"] = pd.to_numeric(dfg[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "452ce26a",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfh[\"sst_replace\"] = dfh[\"sst\"].str.replace(\",\",\"\")\n",
    "dfh[\"sst_replace\"] = pd.to_numeric(dfh[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "27e52f69",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfi[\"sst_replace\"] = dfi[\"sst\"].str.replace(\",\",\"\")\n",
    "dfi[\"sst_replace\"] = pd.to_numeric(dfi[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "e2d9ecfb",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfj[\"sst_replace\"] = dfj[\"sst\"].str.replace(\",\",\"\")\n",
    "dfj[\"sst_replace\"] = pd.to_numeric(dfj[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "9a3db786",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfk[\"sst_replace\"] = dfk[\"sst\"].str.replace(\",\",\"\")\n",
    "dfk[\"sst_replace\"] = pd.to_numeric(dfk[\"sst_replace\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "bbe2b16f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst_replace</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1985-01-01</td>\n",
       "      <td>2,685</td>\n",
       "      <td>2685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1985-01-02</td>\n",
       "      <td>2,680</td>\n",
       "      <td>2680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1985-01-03</td>\n",
       "      <td>2,686</td>\n",
       "      <td>2686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1985-01-04</td>\n",
       "      <td>2,762</td>\n",
       "      <td>2762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1985-01-05</td>\n",
       "      <td>2,783</td>\n",
       "      <td>2783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1985-01-06</td>\n",
       "      <td>2,716</td>\n",
       "      <td>2716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1985-01-07</td>\n",
       "      <td>2,669</td>\n",
       "      <td>2669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1985-01-08</td>\n",
       "      <td>2,679</td>\n",
       "      <td>2679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1985-01-09</td>\n",
       "      <td>2,663</td>\n",
       "      <td>2663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1985-01-10</td>\n",
       "      <td>2,650</td>\n",
       "      <td>2650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1985-01-11</td>\n",
       "      <td>2,648</td>\n",
       "      <td>2648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1985-01-12</td>\n",
       "      <td>2,645</td>\n",
       "      <td>2645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1985-01-13</td>\n",
       "      <td>2,639</td>\n",
       "      <td>2639</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Time    sst  sst_replace\n",
       "0  1985-01-01  2,685         2685\n",
       "1  1985-01-02  2,680         2680\n",
       "2  1985-01-03  2,686         2686\n",
       "3  1985-01-04  2,762         2762\n",
       "4  1985-01-05  2,783         2783\n",
       "5  1985-01-06  2,716         2716\n",
       "6  1985-01-07  2,669         2669\n",
       "7  1985-01-08  2,679         2679\n",
       "8  1985-01-09  2,663         2663\n",
       "9  1985-01-10  2,650         2650\n",
       "10 1985-01-11  2,648         2648\n",
       "11 1985-01-12  2,645         2645\n",
       "12 1985-01-13  2,639         2639"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# new column is numeric\n",
    "dfk"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ba0b712d",
   "metadata": {},
   "source": [
    "New numeric column (sst_replace) x 0.01 to have temperatures in °C "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "df1ebd79",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfa[\"sst\"] = dfa[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "7abdcff7",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfb[\"sst\"] = dfb[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "b34708d8",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfc[\"sst\"] = dfc[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "de9d6d73",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfd[\"sst\"] = dfd[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "24f23e4f",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfe[\"sst\"] = dfe[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "6cb696e8",
   "metadata": {},
   "outputs": [],
   "source": [
    "dff[\"sst\"] = dff[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "567388de",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfg[\"sst\"] = dfg[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "43b19ab8",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfh[\"sst\"] = dfh[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "0fd43bfb",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfi[\"sst\"] = dfi[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "c755840e",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfj[\"sst\"] = dfj[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "241a7a8a",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfk[\"sst\"] = dfk[\"sst_replace\"]*(0.01)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "2095f98e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst_replace</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1985-01-01</td>\n",
       "      <td>26.85</td>\n",
       "      <td>2685</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1985-01-02</td>\n",
       "      <td>26.80</td>\n",
       "      <td>2680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1985-01-03</td>\n",
       "      <td>26.86</td>\n",
       "      <td>2686</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1985-01-04</td>\n",
       "      <td>27.62</td>\n",
       "      <td>2762</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1985-01-05</td>\n",
       "      <td>27.83</td>\n",
       "      <td>2783</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1985-01-06</td>\n",
       "      <td>27.16</td>\n",
       "      <td>2716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1985-01-07</td>\n",
       "      <td>26.69</td>\n",
       "      <td>2669</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1985-01-08</td>\n",
       "      <td>26.79</td>\n",
       "      <td>2679</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1985-01-09</td>\n",
       "      <td>26.63</td>\n",
       "      <td>2663</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1985-01-10</td>\n",
       "      <td>26.50</td>\n",
       "      <td>2650</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1985-01-11</td>\n",
       "      <td>26.48</td>\n",
       "      <td>2648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1985-01-12</td>\n",
       "      <td>26.45</td>\n",
       "      <td>2645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1985-01-13</td>\n",
       "      <td>26.39</td>\n",
       "      <td>2639</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Time    sst  sst_replace\n",
       "0  1985-01-01  26.85         2685\n",
       "1  1985-01-02  26.80         2680\n",
       "2  1985-01-03  26.86         2686\n",
       "3  1985-01-04  27.62         2762\n",
       "4  1985-01-05  27.83         2783\n",
       "5  1985-01-06  27.16         2716\n",
       "6  1985-01-07  26.69         2669\n",
       "7  1985-01-08  26.79         2679\n",
       "8  1985-01-09  26.63         2663\n",
       "9  1985-01-10  26.50         2650\n",
       "10 1985-01-11  26.48         2648\n",
       "11 1985-01-12  26.45         2645\n",
       "12 1985-01-13  26.39         2639"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#sst column in celcius\n",
    "dfk"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "805e5c59",
   "metadata": {},
   "source": [
    "### Making a clean df with all the files"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "408fd46d",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfinal = pd.concat([dfa.Time, dfa.sst, dfb.sst, dfc.sst, dfd.sst, dfe.sst, dff.sst, dfg.sst, dfh.sst, dfi.sst, dfj.sst, dfk.sst ], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "b4786354",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Time</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "      <th>sst</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1985-01-01</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1985-01-02</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1985-01-03</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1985-01-04</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1985-01-05</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1985-01-06</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1985-01-07</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1985-01-08</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1985-01-09</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1985-01-10</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1985-01-11</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1985-01-12</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1985-01-13</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         Time    sst    sst    sst    sst    sst    sst    sst    sst    sst  \\\n",
       "0  1985-01-01  26.59  26.59  26.59  26.59  26.85  26.85  26.59  26.85  26.85   \n",
       "1  1985-01-02  26.30  26.30  26.30  26.30  26.80  26.80  26.30  26.80  26.80   \n",
       "2  1985-01-03  26.34  26.34  26.34  26.34  26.86  26.86  26.34  26.86  26.86   \n",
       "3  1985-01-04  27.63  27.63  27.63  27.63  27.62  27.62  27.63  27.62  27.62   \n",
       "4  1985-01-05  27.90  27.90  27.90  27.90  27.83  27.83  27.90  27.83  27.83   \n",
       "5  1985-01-06  27.17  27.17  27.17  27.17  27.16  27.16  27.17  27.16  27.16   \n",
       "6  1985-01-07  26.57  26.57  26.57  26.57  26.69  26.69  26.57  26.69  26.69   \n",
       "7  1985-01-08  26.69  26.69  26.69  26.69  26.79  26.79  26.69  26.79  26.79   \n",
       "8  1985-01-09  26.51  26.51  26.51  26.51  26.63  26.63  26.51  26.63  26.63   \n",
       "9  1985-01-10  26.43  26.43  26.43  26.43  26.50  26.50  26.43  26.50  26.50   \n",
       "10 1985-01-11  26.43  26.43  26.43  26.43  26.48  26.48  26.43  26.48  26.48   \n",
       "11 1985-01-12  26.43  26.43  26.43  26.43  26.45  26.45  26.43  26.45  26.45   \n",
       "12 1985-01-13  26.38  26.38  26.38  26.38  26.39  26.39  26.38  26.39  26.39   \n",
       "\n",
       "      sst    sst  \n",
       "0   26.59  26.85  \n",
       "1   26.30  26.80  \n",
       "2   26.34  26.86  \n",
       "3   27.63  27.62  \n",
       "4   27.90  27.83  \n",
       "5   27.17  27.16  \n",
       "6   26.57  26.69  \n",
       "7   26.69  26.79  \n",
       "8   26.51  26.63  \n",
       "9   26.43  26.50  \n",
       "10  26.43  26.48  \n",
       "11  26.43  26.45  \n",
       "12  26.38  26.39  "
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfinal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "8959dad0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#changing columns names\n",
    "table_cols = [\"time\", \"sst1\", \"sst2\", \"sst3\", \"sst4\", \"sst5\", \"sst6\", \"sst7\", \"sst8\", \"sst9\", \"sst10\", \"sst11\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "c7ec90b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "dfinal.columns = table_cols"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "3cd8da58",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>time</th>\n",
       "      <th>sst1</th>\n",
       "      <th>sst2</th>\n",
       "      <th>sst3</th>\n",
       "      <th>sst4</th>\n",
       "      <th>sst5</th>\n",
       "      <th>sst6</th>\n",
       "      <th>sst7</th>\n",
       "      <th>sst8</th>\n",
       "      <th>sst9</th>\n",
       "      <th>sst10</th>\n",
       "      <th>sst11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1985-01-01</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.85</td>\n",
       "      <td>26.59</td>\n",
       "      <td>26.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1985-01-02</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.80</td>\n",
       "      <td>26.30</td>\n",
       "      <td>26.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1985-01-03</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.86</td>\n",
       "      <td>26.34</td>\n",
       "      <td>26.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1985-01-04</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.62</td>\n",
       "      <td>27.63</td>\n",
       "      <td>27.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1985-01-05</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.83</td>\n",
       "      <td>27.90</td>\n",
       "      <td>27.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1985-01-06</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.16</td>\n",
       "      <td>27.17</td>\n",
       "      <td>27.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1985-01-07</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.57</td>\n",
       "      <td>26.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1985-01-08</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.79</td>\n",
       "      <td>26.69</td>\n",
       "      <td>26.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1985-01-09</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.63</td>\n",
       "      <td>26.51</td>\n",
       "      <td>26.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1985-01-10</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.50</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1985-01-11</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.48</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1985-01-12</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.45</td>\n",
       "      <td>26.43</td>\n",
       "      <td>26.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1985-01-13</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.39</td>\n",
       "      <td>26.38</td>\n",
       "      <td>26.39</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         time   sst1   sst2   sst3   sst4   sst5   sst6   sst7   sst8   sst9  \\\n",
       "0  1985-01-01  26.59  26.59  26.59  26.59  26.85  26.85  26.59  26.85  26.85   \n",
       "1  1985-01-02  26.30  26.30  26.30  26.30  26.80  26.80  26.30  26.80  26.80   \n",
       "2  1985-01-03  26.34  26.34  26.34  26.34  26.86  26.86  26.34  26.86  26.86   \n",
       "3  1985-01-04  27.63  27.63  27.63  27.63  27.62  27.62  27.63  27.62  27.62   \n",
       "4  1985-01-05  27.90  27.90  27.90  27.90  27.83  27.83  27.90  27.83  27.83   \n",
       "5  1985-01-06  27.17  27.17  27.17  27.17  27.16  27.16  27.17  27.16  27.16   \n",
       "6  1985-01-07  26.57  26.57  26.57  26.57  26.69  26.69  26.57  26.69  26.69   \n",
       "7  1985-01-08  26.69  26.69  26.69  26.69  26.79  26.79  26.69  26.79  26.79   \n",
       "8  1985-01-09  26.51  26.51  26.51  26.51  26.63  26.63  26.51  26.63  26.63   \n",
       "9  1985-01-10  26.43  26.43  26.43  26.43  26.50  26.50  26.43  26.50  26.50   \n",
       "10 1985-01-11  26.43  26.43  26.43  26.43  26.48  26.48  26.43  26.48  26.48   \n",
       "11 1985-01-12  26.43  26.43  26.43  26.43  26.45  26.45  26.43  26.45  26.45   \n",
       "12 1985-01-13  26.38  26.38  26.38  26.38  26.39  26.39  26.38  26.39  26.39   \n",
       "\n",
       "    sst10  sst11  \n",
       "0   26.59  26.85  \n",
       "1   26.30  26.80  \n",
       "2   26.34  26.86  \n",
       "3   27.63  27.62  \n",
       "4   27.90  27.83  \n",
       "5   27.17  27.16  \n",
       "6   26.57  26.69  \n",
       "7   26.69  26.79  \n",
       "8   26.51  26.63  \n",
       "9   26.43  26.50  \n",
       "10  26.43  26.48  \n",
       "11  26.43  26.45  \n",
       "12  26.38  26.39  "
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dfinal"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "66df4c89",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sst1</th>\n",
       "      <th>sst2</th>\n",
       "      <th>sst3</th>\n",
       "      <th>sst4</th>\n",
       "      <th>sst5</th>\n",
       "      <th>sst6</th>\n",
       "      <th>sst7</th>\n",
       "      <th>sst8</th>\n",
       "      <th>sst9</th>\n",
       "      <th>sst10</th>\n",
       "      <th>sst11</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>13.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>26.720769</td>\n",
       "      <td>26.720769</td>\n",
       "      <td>26.720769</td>\n",
       "      <td>26.720769</td>\n",
       "      <td>26.850000</td>\n",
       "      <td>26.850000</td>\n",
       "      <td>26.720769</td>\n",
       "      <td>26.850000</td>\n",
       "      <td>26.850000</td>\n",
       "      <td>26.720769</td>\n",
       "      <td>26.850000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.516082</td>\n",
       "      <td>0.516082</td>\n",
       "      <td>0.516082</td>\n",
       "      <td>0.516082</td>\n",
       "      <td>0.443528</td>\n",
       "      <td>0.443528</td>\n",
       "      <td>0.516082</td>\n",
       "      <td>0.443528</td>\n",
       "      <td>0.443528</td>\n",
       "      <td>0.516082</td>\n",
       "      <td>0.443528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>26.300000</td>\n",
       "      <td>26.300000</td>\n",
       "      <td>26.300000</td>\n",
       "      <td>26.300000</td>\n",
       "      <td>26.390000</td>\n",
       "      <td>26.390000</td>\n",
       "      <td>26.300000</td>\n",
       "      <td>26.390000</td>\n",
       "      <td>26.390000</td>\n",
       "      <td>26.300000</td>\n",
       "      <td>26.390000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>26.430000</td>\n",
       "      <td>26.430000</td>\n",
       "      <td>26.430000</td>\n",
       "      <td>26.430000</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>26.430000</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>26.500000</td>\n",
       "      <td>26.430000</td>\n",
       "      <td>26.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>26.510000</td>\n",
       "      <td>26.510000</td>\n",
       "      <td>26.510000</td>\n",
       "      <td>26.510000</td>\n",
       "      <td>26.790000</td>\n",
       "      <td>26.790000</td>\n",
       "      <td>26.510000</td>\n",
       "      <td>26.790000</td>\n",
       "      <td>26.790000</td>\n",
       "      <td>26.510000</td>\n",
       "      <td>26.790000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>26.690000</td>\n",
       "      <td>26.690000</td>\n",
       "      <td>26.690000</td>\n",
       "      <td>26.690000</td>\n",
       "      <td>26.860000</td>\n",
       "      <td>26.860000</td>\n",
       "      <td>26.690000</td>\n",
       "      <td>26.860000</td>\n",
       "      <td>26.860000</td>\n",
       "      <td>26.690000</td>\n",
       "      <td>26.860000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>27.900000</td>\n",
       "      <td>27.900000</td>\n",
       "      <td>27.900000</td>\n",
       "      <td>27.900000</td>\n",
       "      <td>27.830000</td>\n",
       "      <td>27.830000</td>\n",
       "      <td>27.900000</td>\n",
       "      <td>27.830000</td>\n",
       "      <td>27.830000</td>\n",
       "      <td>27.900000</td>\n",
       "      <td>27.830000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            sst1       sst2       sst3       sst4       sst5       sst6  \\\n",
       "count  13.000000  13.000000  13.000000  13.000000  13.000000  13.000000   \n",
       "mean   26.720769  26.720769  26.720769  26.720769  26.850000  26.850000   \n",
       "std     0.516082   0.516082   0.516082   0.516082   0.443528   0.443528   \n",
       "min    26.300000  26.300000  26.300000  26.300000  26.390000  26.390000   \n",
       "25%    26.430000  26.430000  26.430000  26.430000  26.500000  26.500000   \n",
       "50%    26.510000  26.510000  26.510000  26.510000  26.790000  26.790000   \n",
       "75%    26.690000  26.690000  26.690000  26.690000  26.860000  26.860000   \n",
       "max    27.900000  27.900000  27.900000  27.900000  27.830000  27.830000   \n",
       "\n",
       "            sst7       sst8       sst9      sst10      sst11  \n",
       "count  13.000000  13.000000  13.000000  13.000000  13.000000  \n",
       "mean   26.720769  26.850000  26.850000  26.720769  26.850000  \n",
       "std     0.516082   0.443528   0.443528   0.516082   0.443528  \n",
       "min    26.300000  26.390000  26.390000  26.300000  26.390000  \n",
       "25%    26.430000  26.500000  26.500000  26.430000  26.500000  \n",
       "50%    26.510000  26.790000  26.790000  26.510000  26.790000  \n",
       "75%    26.690000  26.860000  26.860000  26.690000  26.860000  \n",
       "max    27.900000  27.830000  27.830000  27.900000  27.830000  "
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# now i have all temperatures of a single year in dataframes to analize it\n",
    "dfinal.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c82d219a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}