WeatherData.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "ac0fabb0-b3b1-4674-b450-3a3002afaf93",
   "metadata": {},
   "source": [
    "## Пятидневный прогноз погоды в москве"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e0f81c99-faf3-44e2-8aa3-8dfee4795dab",
   "metadata": {},
   "source": [
    "#### Цель\n",
    "\n",
    "*оптимизировать передачу данных о пятидневном прогнозе погоды с https://openweathermap.org в таблицу облачного PostgreSQL сервера и на ее основе создать интеркативный дашборд в PowerBI.*"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fbb44ef6-8fde-4674-aa55-afac4227ea36",
   "metadata": {},
   "source": [
    "### Сетап \n",
    "\n",
    "##### Импорт необходимых библиотек"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 110,
   "id": "dd7aed63-fc59-481e-94d3-7a08bef0b556",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "import pandas as pd\n",
    "import pytz\n"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "2f576695-057f-4885-9bc4-3fb1665b06e2",
   "metadata": {},
   "source": [
    "##### Получение данных https://openweathermap.org с помощью api в Json формате\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "5cfe7b0a-2338-4974-b03a-26642bb8e403",
   "metadata": {},
   "outputs": [],
   "source": [
    "url = 'https://api.openweathermap.org/data/2.5/forecast?lat=55.751244&lon=37.618423&appid=62aec7a368b56755f6667fe1dd684b5b&units=metric'\n",
    "key = '62aec7a368b56755f6667fe1dd684b5b'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "fd70e40f-570d-415f-87a3-e7512dded94f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'dt': 1719705600,\n",
       "  'main': {'temp': 20.29,\n",
       "   'feels_like': 20.18,\n",
       "   'temp_min': 20.29,\n",
       "   'temp_max': 20.61,\n",
       "   'pressure': 1014,\n",
       "   'sea_level': 1014,\n",
       "   'grnd_level': 996,\n",
       "   'humidity': 69,\n",
       "   'temp_kf': -0.32},\n",
       "  'weather': [{'id': 802,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'scattered clouds',\n",
       "    'icon': '03n'}],\n",
       "  'clouds': {'all': 42},\n",
       "  'wind': {'speed': 0.64, 'deg': 311, 'gust': 0.65},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-06-30 00:00:00'},\n",
       " {'dt': 1719716400,\n",
       "  'main': {'temp': 20.62,\n",
       "   'feels_like': 20.54,\n",
       "   'temp_min': 20.62,\n",
       "   'temp_max': 21.28,\n",
       "   'pressure': 1014,\n",
       "   'sea_level': 1014,\n",
       "   'grnd_level': 996,\n",
       "   'humidity': 69,\n",
       "   'temp_kf': -0.66},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 52},\n",
       "  'wind': {'speed': 1.82, 'deg': 258, 'gust': 2.89},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-06-30 03:00:00'},\n",
       " {'dt': 1719727200,\n",
       "  'main': {'temp': 23.42,\n",
       "   'feels_like': 23.44,\n",
       "   'temp_min': 23.42,\n",
       "   'temp_max': 24.99,\n",
       "   'pressure': 1014,\n",
       "   'sea_level': 1014,\n",
       "   'grnd_level': 996,\n",
       "   'humidity': 62,\n",
       "   'temp_kf': -1.57},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 69},\n",
       "  'wind': {'speed': 2.09, 'deg': 297, 'gust': 2.65},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-06-30 06:00:00'},\n",
       " {'dt': 1719738000,\n",
       "  'main': {'temp': 28.71,\n",
       "   'feels_like': 28.87,\n",
       "   'temp_min': 28.71,\n",
       "   'temp_max': 28.71,\n",
       "   'pressure': 1014,\n",
       "   'sea_level': 1014,\n",
       "   'grnd_level': 996,\n",
       "   'humidity': 46,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 100},\n",
       "  'wind': {'speed': 1.69, 'deg': 296, 'gust': 1.95},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-06-30 09:00:00'},\n",
       " {'dt': 1719748800,\n",
       "  'main': {'temp': 31.25,\n",
       "   'feels_like': 30.68,\n",
       "   'temp_min': 31.25,\n",
       "   'temp_max': 31.25,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 994,\n",
       "   'humidity': 36,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 54},\n",
       "  'wind': {'speed': 1.66, 'deg': 251, 'gust': 3.36},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-06-30 12:00:00'},\n",
       " {'dt': 1719759600,\n",
       "  'main': {'temp': 26.96,\n",
       "   'feels_like': 27.5,\n",
       "   'temp_min': 26.96,\n",
       "   'temp_max': 26.96,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 994,\n",
       "   'humidity': 52,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10d'}],\n",
       "  'clouds': {'all': 92},\n",
       "  'wind': {'speed': 2.04, 'deg': 213, 'gust': 3.43},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.32,\n",
       "  'rain': {'3h': 0.19},\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-06-30 15:00:00'},\n",
       " {'dt': 1719770400,\n",
       "  'main': {'temp': 24.64,\n",
       "   'feels_like': 24.8,\n",
       "   'temp_min': 24.64,\n",
       "   'temp_max': 24.64,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 994,\n",
       "   'humidity': 63,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10d'}],\n",
       "  'clouds': {'all': 63},\n",
       "  'wind': {'speed': 2.91, 'deg': 266, 'gust': 6.16},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.27,\n",
       "  'rain': {'3h': 0.25},\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-06-30 18:00:00'},\n",
       " {'dt': 1719781200,\n",
       "  'main': {'temp': 21.57,\n",
       "   'feels_like': 21.98,\n",
       "   'temp_min': 21.57,\n",
       "   'temp_max': 21.57,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 995,\n",
       "   'humidity': 84,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10n'}],\n",
       "  'clouds': {'all': 10},\n",
       "  'wind': {'speed': 1.42, 'deg': 3, 'gust': 2.26},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.99,\n",
       "  'rain': {'3h': 0.78},\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-06-30 21:00:00'},\n",
       " {'dt': 1719792000,\n",
       "  'main': {'temp': 20.52,\n",
       "   'feels_like': 20.9,\n",
       "   'temp_min': 20.52,\n",
       "   'temp_max': 20.52,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 994,\n",
       "   'humidity': 87,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 802,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'scattered clouds',\n",
       "    'icon': '03n'}],\n",
       "  'clouds': {'all': 40},\n",
       "  'wind': {'speed': 0.92, 'deg': 256, 'gust': 0.88},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.73,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-01 00:00:00'},\n",
       " {'dt': 1719802800,\n",
       "  'main': {'temp': 21.19,\n",
       "   'feels_like': 21.58,\n",
       "   'temp_min': 21.19,\n",
       "   'temp_max': 21.19,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 995,\n",
       "   'humidity': 85,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 63},\n",
       "  'wind': {'speed': 1.6, 'deg': 284, 'gust': 3.07},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-01 03:00:00'},\n",
       " {'dt': 1719813600,\n",
       "  'main': {'temp': 25.13,\n",
       "   'feels_like': 25.34,\n",
       "   'temp_min': 25.13,\n",
       "   'temp_max': 25.13,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 994,\n",
       "   'humidity': 63,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10d'}],\n",
       "  'clouds': {'all': 62},\n",
       "  'wind': {'speed': 2.25, 'deg': 252, 'gust': 3.1},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.2,\n",
       "  'rain': {'3h': 0.19},\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-01 06:00:00'},\n",
       " {'dt': 1719824400,\n",
       "  'main': {'temp': 29.01,\n",
       "   'feels_like': 28.8,\n",
       "   'temp_min': 29.01,\n",
       "   'temp_max': 29.01,\n",
       "   'pressure': 1011,\n",
       "   'sea_level': 1011,\n",
       "   'grnd_level': 993,\n",
       "   'humidity': 42,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 801,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'few clouds',\n",
       "    'icon': '02d'}],\n",
       "  'clouds': {'all': 14},\n",
       "  'wind': {'speed': 3.24, 'deg': 215, 'gust': 4.08},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-01 09:00:00'},\n",
       " {'dt': 1719835200,\n",
       "  'main': {'temp': 30.45,\n",
       "   'feels_like': 29.18,\n",
       "   'temp_min': 30.45,\n",
       "   'temp_max': 30.45,\n",
       "   'pressure': 1010,\n",
       "   'sea_level': 1010,\n",
       "   'grnd_level': 992,\n",
       "   'humidity': 30,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 802,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'scattered clouds',\n",
       "    'icon': '03d'}],\n",
       "  'clouds': {'all': 48},\n",
       "  'wind': {'speed': 3.53, 'deg': 247, 'gust': 4.2},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-01 12:00:00'},\n",
       " {'dt': 1719846000,\n",
       "  'main': {'temp': 29.83,\n",
       "   'feels_like': 29.18,\n",
       "   'temp_min': 29.83,\n",
       "   'temp_max': 29.83,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 37,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 96},\n",
       "  'wind': {'speed': 2.54, 'deg': 323, 'gust': 4.72},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-01 15:00:00'},\n",
       " {'dt': 1719856800,\n",
       "  'main': {'temp': 26.62,\n",
       "   'feels_like': 26.62,\n",
       "   'temp_min': 26.62,\n",
       "   'temp_max': 26.62,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 52,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 95},\n",
       "  'wind': {'speed': 1.85, 'deg': 170, 'gust': 3.29},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-01 18:00:00'},\n",
       " {'dt': 1719867600,\n",
       "  'main': {'temp': 24.96,\n",
       "   'feels_like': 25.16,\n",
       "   'temp_min': 24.96,\n",
       "   'temp_max': 24.96,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 63,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04n'}],\n",
       "  'clouds': {'all': 99},\n",
       "  'wind': {'speed': 2.65, 'deg': 231, 'gust': 7.09},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-01 21:00:00'},\n",
       " {'dt': 1719878400,\n",
       "  'main': {'temp': 22.05,\n",
       "   'feels_like': 22.24,\n",
       "   'temp_min': 22.05,\n",
       "   'temp_max': 22.05,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 74,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04n'}],\n",
       "  'clouds': {'all': 100},\n",
       "  'wind': {'speed': 2.27, 'deg': 214, 'gust': 5},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-02 00:00:00'},\n",
       " {'dt': 1719889200,\n",
       "  'main': {'temp': 22.61,\n",
       "   'feels_like': 22.73,\n",
       "   'temp_min': 22.61,\n",
       "   'temp_max': 22.61,\n",
       "   'pressure': 1008,\n",
       "   'sea_level': 1008,\n",
       "   'grnd_level': 990,\n",
       "   'humidity': 69,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 81},\n",
       "  'wind': {'speed': 2.4, 'deg': 209, 'gust': 5.81},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-02 03:00:00'},\n",
       " {'dt': 1719900000,\n",
       "  'main': {'temp': 27.02,\n",
       "   'feels_like': 27.69,\n",
       "   'temp_min': 27.02,\n",
       "   'temp_max': 27.02,\n",
       "   'pressure': 1008,\n",
       "   'sea_level': 1008,\n",
       "   'grnd_level': 989,\n",
       "   'humidity': 54,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 83},\n",
       "  'wind': {'speed': 3.34, 'deg': 198, 'gust': 5.11},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-02 06:00:00'},\n",
       " {'dt': 1719910800,\n",
       "  'main': {'temp': 30.52,\n",
       "   'feels_like': 30.06,\n",
       "   'temp_min': 30.52,\n",
       "   'temp_max': 30.52,\n",
       "   'pressure': 1007,\n",
       "   'sea_level': 1007,\n",
       "   'grnd_level': 989,\n",
       "   'humidity': 38,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 59},\n",
       "  'wind': {'speed': 5.25, 'deg': 196, 'gust': 7.19},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-02 09:00:00'},\n",
       " {'dt': 1719921600,\n",
       "  'main': {'temp': 31.57,\n",
       "   'feels_like': 30.8,\n",
       "   'temp_min': 31.57,\n",
       "   'temp_max': 31.57,\n",
       "   'pressure': 1005,\n",
       "   'sea_level': 1005,\n",
       "   'grnd_level': 987,\n",
       "   'humidity': 34,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 60},\n",
       "  'wind': {'speed': 6.04, 'deg': 181, 'gust': 7.73},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-02 12:00:00'},\n",
       " {'dt': 1719932400,\n",
       "  'main': {'temp': 29.62,\n",
       "   'feels_like': 29.71,\n",
       "   'temp_min': 29.62,\n",
       "   'temp_max': 29.62,\n",
       "   'pressure': 1005,\n",
       "   'sea_level': 1005,\n",
       "   'grnd_level': 986,\n",
       "   'humidity': 44,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 74},\n",
       "  'wind': {'speed': 5.89, 'deg': 186, 'gust': 7.43},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-02 15:00:00'},\n",
       " {'dt': 1719943200,\n",
       "  'main': {'temp': 25.19,\n",
       "   'feels_like': 25.41,\n",
       "   'temp_min': 25.19,\n",
       "   'temp_max': 25.19,\n",
       "   'pressure': 1005,\n",
       "   'sea_level': 1005,\n",
       "   'grnd_level': 987,\n",
       "   'humidity': 63,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10d'}],\n",
       "  'clouds': {'all': 62},\n",
       "  'wind': {'speed': 4.84, 'deg': 215, 'gust': 11.08},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.2,\n",
       "  'rain': {'3h': 0.13},\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-02 18:00:00'},\n",
       " {'dt': 1719954000,\n",
       "  'main': {'temp': 23.52,\n",
       "   'feels_like': 23.76,\n",
       "   'temp_min': 23.52,\n",
       "   'temp_max': 23.52,\n",
       "   'pressure': 1005,\n",
       "   'sea_level': 1005,\n",
       "   'grnd_level': 986,\n",
       "   'humidity': 70,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 800,\n",
       "    'main': 'Clear',\n",
       "    'description': 'clear sky',\n",
       "    'icon': '01n'}],\n",
       "  'clouds': {'all': 2},\n",
       "  'wind': {'speed': 4.07, 'deg': 177, 'gust': 12.07},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-02 21:00:00'},\n",
       " {'dt': 1719964800,\n",
       "  'main': {'temp': 21.27,\n",
       "   'feels_like': 21.49,\n",
       "   'temp_min': 21.27,\n",
       "   'temp_max': 21.27,\n",
       "   'pressure': 1006,\n",
       "   'sea_level': 1006,\n",
       "   'grnd_level': 987,\n",
       "   'humidity': 78,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 802,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'scattered clouds',\n",
       "    'icon': '03n'}],\n",
       "  'clouds': {'all': 25},\n",
       "  'wind': {'speed': 3.15, 'deg': 235, 'gust': 8.46},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.09,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-03 00:00:00'},\n",
       " {'dt': 1719975600,\n",
       "  'main': {'temp': 19.49,\n",
       "   'feels_like': 19.66,\n",
       "   'temp_min': 19.49,\n",
       "   'temp_max': 19.49,\n",
       "   'pressure': 1008,\n",
       "   'sea_level': 1008,\n",
       "   'grnd_level': 989,\n",
       "   'humidity': 83,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10d'}],\n",
       "  'clouds': {'all': 99},\n",
       "  'wind': {'speed': 2.93, 'deg': 273, 'gust': 4.87},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.23,\n",
       "  'rain': {'3h': 0.23},\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-03 03:00:00'},\n",
       " {'dt': 1719986400,\n",
       "  'main': {'temp': 22.16,\n",
       "   'feels_like': 21.95,\n",
       "   'temp_min': 22.16,\n",
       "   'temp_max': 22.16,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 990,\n",
       "   'humidity': 58,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 94},\n",
       "  'wind': {'speed': 2.58, 'deg': 298, 'gust': 2.95},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-03 06:00:00'},\n",
       " {'dt': 1719997200,\n",
       "  'main': {'temp': 25.66,\n",
       "   'feels_like': 25.43,\n",
       "   'temp_min': 25.66,\n",
       "   'temp_max': 25.66,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 990,\n",
       "   'humidity': 44,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 94},\n",
       "  'wind': {'speed': 2.93, 'deg': 292, 'gust': 3.13},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-03 09:00:00'},\n",
       " {'dt': 1720008000,\n",
       "  'main': {'temp': 24.11,\n",
       "   'feels_like': 23.78,\n",
       "   'temp_min': 24.11,\n",
       "   'temp_max': 24.11,\n",
       "   'pressure': 1010,\n",
       "   'sea_level': 1010,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 46,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 804,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'overcast clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 97},\n",
       "  'wind': {'speed': 3.5, 'deg': 303, 'gust': 2.95},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-03 12:00:00'},\n",
       " {'dt': 1720018800,\n",
       "  'main': {'temp': 26.4,\n",
       "   'feels_like': 26.4,\n",
       "   'temp_min': 26.4,\n",
       "   'temp_max': 26.4,\n",
       "   'pressure': 1010,\n",
       "   'sea_level': 1010,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 40,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 803,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'broken clouds',\n",
       "    'icon': '04d'}],\n",
       "  'clouds': {'all': 57},\n",
       "  'wind': {'speed': 2.65, 'deg': 276, 'gust': 3.43},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-03 15:00:00'},\n",
       " {'dt': 1720029600,\n",
       "  'main': {'temp': 23.14,\n",
       "   'feels_like': 22.87,\n",
       "   'temp_min': 23.14,\n",
       "   'temp_max': 23.14,\n",
       "   'pressure': 1010,\n",
       "   'sea_level': 1010,\n",
       "   'grnd_level': 992,\n",
       "   'humidity': 52,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 802,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'scattered clouds',\n",
       "    'icon': '03d'}],\n",
       "  'clouds': {'all': 44},\n",
       "  'wind': {'speed': 1.83, 'deg': 335, 'gust': 3.25},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-03 18:00:00'},\n",
       " {'dt': 1720040400,\n",
       "  'main': {'temp': 20.66,\n",
       "   'feels_like': 20.43,\n",
       "   'temp_min': 20.66,\n",
       "   'temp_max': 20.66,\n",
       "   'pressure': 1012,\n",
       "   'sea_level': 1012,\n",
       "   'grnd_level': 993,\n",
       "   'humidity': 63,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 800,\n",
       "    'main': 'Clear',\n",
       "    'description': 'clear sky',\n",
       "    'icon': '01n'}],\n",
       "  'clouds': {'all': 8},\n",
       "  'wind': {'speed': 1.13, 'deg': 6, 'gust': 1.35},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-03 21:00:00'},\n",
       " {'dt': 1720051200,\n",
       "  'main': {'temp': 19.29,\n",
       "   'feels_like': 19,\n",
       "   'temp_min': 19.29,\n",
       "   'temp_max': 19.29,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 994,\n",
       "   'humidity': 66,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 800,\n",
       "    'main': 'Clear',\n",
       "    'description': 'clear sky',\n",
       "    'icon': '01n'}],\n",
       "  'clouds': {'all': 8},\n",
       "  'wind': {'speed': 1.37, 'deg': 62, 'gust': 1.64},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-04 00:00:00'},\n",
       " {'dt': 1720062000,\n",
       "  'main': {'temp': 20,\n",
       "   'feels_like': 19.78,\n",
       "   'temp_min': 20,\n",
       "   'temp_max': 20,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 995,\n",
       "   'humidity': 66,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 800,\n",
       "    'main': 'Clear',\n",
       "    'description': 'clear sky',\n",
       "    'icon': '01d'}],\n",
       "  'clouds': {'all': 9},\n",
       "  'wind': {'speed': 1.52, 'deg': 87, 'gust': 2.34},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-04 03:00:00'},\n",
       " {'dt': 1720072800,\n",
       "  'main': {'temp': 24.49,\n",
       "   'feels_like': 24.35,\n",
       "   'temp_min': 24.49,\n",
       "   'temp_max': 24.49,\n",
       "   'pressure': 1013,\n",
       "   'sea_level': 1013,\n",
       "   'grnd_level': 995,\n",
       "   'humidity': 52,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 801,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'few clouds',\n",
       "    'icon': '02d'}],\n",
       "  'clouds': {'all': 15},\n",
       "  'wind': {'speed': 1.89, 'deg': 127, 'gust': 2.1},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-04 06:00:00'},\n",
       " {'dt': 1720083600,\n",
       "  'main': {'temp': 28.67,\n",
       "   'feels_like': 28.36,\n",
       "   'temp_min': 28.67,\n",
       "   'temp_max': 28.67,\n",
       "   'pressure': 1012,\n",
       "   'sea_level': 1012,\n",
       "   'grnd_level': 994,\n",
       "   'humidity': 41,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 800,\n",
       "    'main': 'Clear',\n",
       "    'description': 'clear sky',\n",
       "    'icon': '01d'}],\n",
       "  'clouds': {'all': 9},\n",
       "  'wind': {'speed': 2.86, 'deg': 151, 'gust': 3.2},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-04 09:00:00'},\n",
       " {'dt': 1720094400,\n",
       "  'main': {'temp': 30.19,\n",
       "   'feels_like': 29.91,\n",
       "   'temp_min': 30.19,\n",
       "   'temp_max': 30.19,\n",
       "   'pressure': 1011,\n",
       "   'sea_level': 1011,\n",
       "   'grnd_level': 993,\n",
       "   'humidity': 40,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 802,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'scattered clouds',\n",
       "    'icon': '03d'}],\n",
       "  'clouds': {'all': 39},\n",
       "  'wind': {'speed': 3.17, 'deg': 148, 'gust': 3.99},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-04 12:00:00'},\n",
       " {'dt': 1720105200,\n",
       "  'main': {'temp': 30.2,\n",
       "   'feels_like': 30.3,\n",
       "   'temp_min': 30.2,\n",
       "   'temp_max': 30.2,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 43,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 801,\n",
       "    'main': 'Clouds',\n",
       "    'description': 'few clouds',\n",
       "    'icon': '02d'}],\n",
       "  'clouds': {'all': 17},\n",
       "  'wind': {'speed': 3.5, 'deg': 153, 'gust': 4.58},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0,\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-04 15:00:00'},\n",
       " {'dt': 1720116000,\n",
       "  'main': {'temp': 26.44,\n",
       "   'feels_like': 26.44,\n",
       "   'temp_min': 26.44,\n",
       "   'temp_max': 26.44,\n",
       "   'pressure': 1008,\n",
       "   'sea_level': 1008,\n",
       "   'grnd_level': 990,\n",
       "   'humidity': 65,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10d'}],\n",
       "  'clouds': {'all': 28},\n",
       "  'wind': {'speed': 2.92, 'deg': 138, 'gust': 7},\n",
       "  'visibility': 10000,\n",
       "  'pop': 0.2,\n",
       "  'rain': {'3h': 0.14},\n",
       "  'sys': {'pod': 'd'},\n",
       "  'dt_txt': '2024-07-04 18:00:00'},\n",
       " {'dt': 1720126800,\n",
       "  'main': {'temp': 20.92,\n",
       "   'feels_like': 20.82,\n",
       "   'temp_min': 20.92,\n",
       "   'temp_max': 20.92,\n",
       "   'pressure': 1009,\n",
       "   'sea_level': 1009,\n",
       "   'grnd_level': 991,\n",
       "   'humidity': 67,\n",
       "   'temp_kf': 0},\n",
       "  'weather': [{'id': 500,\n",
       "    'main': 'Rain',\n",
       "    'description': 'light rain',\n",
       "    'icon': '10n'}],\n",
       "  'clouds': {'all': 77},\n",
       "  'wind': {'speed': 4.55, 'deg': 151, 'gust': 13.41},\n",
       "  'visibility': 10000,\n",
       "  'pop': 1,\n",
       "  'rain': {'3h': 1.59},\n",
       "  'sys': {'pod': 'n'},\n",
       "  'dt_txt': '2024-07-04 21:00:00'}]"
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response = requests.get(url)\n",
    "data = response.json()\n",
    "jdata = data['list']\n",
    "jdata"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "afca563d-d6d6-4104-a6e4-e511351f0e5d",
   "metadata": {},
   "source": [
    "##### Перевод данных в pandas DF, используя библиотеку на случай отсутсвия поступления некотрых опциональных данных(например rain.3h или snow.3h)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "id": "bf74a323-5b97-4275-8296-57e57a1ca91e",
   "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>temp</th>\n",
       "      <th>feels_like</th>\n",
       "      <th>pressure</th>\n",
       "      <th>humidity</th>\n",
       "      <th>id</th>\n",
       "      <th>main</th>\n",
       "      <th>desc</th>\n",
       "      <th>clouds</th>\n",
       "      <th>wind_speed</th>\n",
       "      <th>wind_gust</th>\n",
       "      <th>visibility</th>\n",
       "      <th>rain_prob</th>\n",
       "      <th>rain(mm)</th>\n",
       "      <th>snow(mm)</th>\n",
       "      <th>date_for_forcast</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20.29</td>\n",
       "      <td>20.18</td>\n",
       "      <td>1014</td>\n",
       "      <td>69</td>\n",
       "      <td>802</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>42</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.65</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.62</td>\n",
       "      <td>20.54</td>\n",
       "      <td>1014</td>\n",
       "      <td>69</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>52</td>\n",
       "      <td>1.82</td>\n",
       "      <td>2.89</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23.42</td>\n",
       "      <td>23.44</td>\n",
       "      <td>1014</td>\n",
       "      <td>62</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>69</td>\n",
       "      <td>2.09</td>\n",
       "      <td>2.65</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28.71</td>\n",
       "      <td>28.87</td>\n",
       "      <td>1014</td>\n",
       "      <td>46</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>1.69</td>\n",
       "      <td>1.95</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>31.25</td>\n",
       "      <td>30.68</td>\n",
       "      <td>1013</td>\n",
       "      <td>36</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>54</td>\n",
       "      <td>1.66</td>\n",
       "      <td>3.36</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>26.96</td>\n",
       "      <td>27.50</td>\n",
       "      <td>1013</td>\n",
       "      <td>52</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>92</td>\n",
       "      <td>2.04</td>\n",
       "      <td>3.43</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.19</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>24.64</td>\n",
       "      <td>24.80</td>\n",
       "      <td>1013</td>\n",
       "      <td>63</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>63</td>\n",
       "      <td>2.91</td>\n",
       "      <td>6.16</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.25</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>21.57</td>\n",
       "      <td>21.98</td>\n",
       "      <td>1013</td>\n",
       "      <td>84</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>10</td>\n",
       "      <td>1.42</td>\n",
       "      <td>2.26</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.78</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-06-30 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>20.52</td>\n",
       "      <td>20.90</td>\n",
       "      <td>1013</td>\n",
       "      <td>87</td>\n",
       "      <td>802</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>40</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.88</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.73</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>21.19</td>\n",
       "      <td>21.58</td>\n",
       "      <td>1013</td>\n",
       "      <td>85</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>63</td>\n",
       "      <td>1.60</td>\n",
       "      <td>3.07</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>25.13</td>\n",
       "      <td>25.34</td>\n",
       "      <td>1013</td>\n",
       "      <td>63</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>62</td>\n",
       "      <td>2.25</td>\n",
       "      <td>3.10</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.19</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>29.01</td>\n",
       "      <td>28.80</td>\n",
       "      <td>1011</td>\n",
       "      <td>42</td>\n",
       "      <td>801</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>14</td>\n",
       "      <td>3.24</td>\n",
       "      <td>4.08</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>30.45</td>\n",
       "      <td>29.18</td>\n",
       "      <td>1010</td>\n",
       "      <td>30</td>\n",
       "      <td>802</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>48</td>\n",
       "      <td>3.53</td>\n",
       "      <td>4.20</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>29.83</td>\n",
       "      <td>29.18</td>\n",
       "      <td>1009</td>\n",
       "      <td>37</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>96</td>\n",
       "      <td>2.54</td>\n",
       "      <td>4.72</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>26.62</td>\n",
       "      <td>26.62</td>\n",
       "      <td>1009</td>\n",
       "      <td>52</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>95</td>\n",
       "      <td>1.85</td>\n",
       "      <td>3.29</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>24.96</td>\n",
       "      <td>25.16</td>\n",
       "      <td>1009</td>\n",
       "      <td>63</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>99</td>\n",
       "      <td>2.65</td>\n",
       "      <td>7.09</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-01 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>22.05</td>\n",
       "      <td>22.24</td>\n",
       "      <td>1009</td>\n",
       "      <td>74</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>100</td>\n",
       "      <td>2.27</td>\n",
       "      <td>5.00</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>22.61</td>\n",
       "      <td>22.73</td>\n",
       "      <td>1008</td>\n",
       "      <td>69</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>81</td>\n",
       "      <td>2.40</td>\n",
       "      <td>5.81</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>27.02</td>\n",
       "      <td>27.69</td>\n",
       "      <td>1008</td>\n",
       "      <td>54</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>83</td>\n",
       "      <td>3.34</td>\n",
       "      <td>5.11</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>30.52</td>\n",
       "      <td>30.06</td>\n",
       "      <td>1007</td>\n",
       "      <td>38</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>59</td>\n",
       "      <td>5.25</td>\n",
       "      <td>7.19</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>31.57</td>\n",
       "      <td>30.80</td>\n",
       "      <td>1005</td>\n",
       "      <td>34</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>60</td>\n",
       "      <td>6.04</td>\n",
       "      <td>7.73</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>29.62</td>\n",
       "      <td>29.71</td>\n",
       "      <td>1005</td>\n",
       "      <td>44</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>74</td>\n",
       "      <td>5.89</td>\n",
       "      <td>7.43</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>25.19</td>\n",
       "      <td>25.41</td>\n",
       "      <td>1005</td>\n",
       "      <td>63</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>62</td>\n",
       "      <td>4.84</td>\n",
       "      <td>11.08</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.13</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23.52</td>\n",
       "      <td>23.76</td>\n",
       "      <td>1005</td>\n",
       "      <td>70</td>\n",
       "      <td>800</td>\n",
       "      <td>Clear</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>2</td>\n",
       "      <td>4.07</td>\n",
       "      <td>12.07</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-02 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>21.27</td>\n",
       "      <td>21.49</td>\n",
       "      <td>1006</td>\n",
       "      <td>78</td>\n",
       "      <td>802</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>25</td>\n",
       "      <td>3.15</td>\n",
       "      <td>8.46</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.09</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>19.49</td>\n",
       "      <td>19.66</td>\n",
       "      <td>1008</td>\n",
       "      <td>83</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>99</td>\n",
       "      <td>2.93</td>\n",
       "      <td>4.87</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.23</td>\n",
       "      <td>0.23</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>22.16</td>\n",
       "      <td>21.95</td>\n",
       "      <td>1009</td>\n",
       "      <td>58</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>94</td>\n",
       "      <td>2.58</td>\n",
       "      <td>2.95</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>25.66</td>\n",
       "      <td>25.43</td>\n",
       "      <td>1009</td>\n",
       "      <td>44</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>94</td>\n",
       "      <td>2.93</td>\n",
       "      <td>3.13</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>24.11</td>\n",
       "      <td>23.78</td>\n",
       "      <td>1010</td>\n",
       "      <td>46</td>\n",
       "      <td>804</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>overcast clouds</td>\n",
       "      <td>97</td>\n",
       "      <td>3.50</td>\n",
       "      <td>2.95</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>26.40</td>\n",
       "      <td>26.40</td>\n",
       "      <td>1010</td>\n",
       "      <td>40</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>57</td>\n",
       "      <td>2.65</td>\n",
       "      <td>3.43</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>23.14</td>\n",
       "      <td>22.87</td>\n",
       "      <td>1010</td>\n",
       "      <td>52</td>\n",
       "      <td>802</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>44</td>\n",
       "      <td>1.83</td>\n",
       "      <td>3.25</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>20.66</td>\n",
       "      <td>20.43</td>\n",
       "      <td>1012</td>\n",
       "      <td>63</td>\n",
       "      <td>800</td>\n",
       "      <td>Clear</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>8</td>\n",
       "      <td>1.13</td>\n",
       "      <td>1.35</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-03 21:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>19.29</td>\n",
       "      <td>19.00</td>\n",
       "      <td>1013</td>\n",
       "      <td>66</td>\n",
       "      <td>800</td>\n",
       "      <td>Clear</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>8</td>\n",
       "      <td>1.37</td>\n",
       "      <td>1.64</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 00:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>20.00</td>\n",
       "      <td>19.78</td>\n",
       "      <td>1013</td>\n",
       "      <td>66</td>\n",
       "      <td>800</td>\n",
       "      <td>Clear</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>9</td>\n",
       "      <td>1.52</td>\n",
       "      <td>2.34</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>24.49</td>\n",
       "      <td>24.35</td>\n",
       "      <td>1013</td>\n",
       "      <td>52</td>\n",
       "      <td>801</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>15</td>\n",
       "      <td>1.89</td>\n",
       "      <td>2.10</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>28.67</td>\n",
       "      <td>28.36</td>\n",
       "      <td>1012</td>\n",
       "      <td>41</td>\n",
       "      <td>800</td>\n",
       "      <td>Clear</td>\n",
       "      <td>clear sky</td>\n",
       "      <td>9</td>\n",
       "      <td>2.86</td>\n",
       "      <td>3.20</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 09:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>30.19</td>\n",
       "      <td>29.91</td>\n",
       "      <td>1011</td>\n",
       "      <td>40</td>\n",
       "      <td>802</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>39</td>\n",
       "      <td>3.17</td>\n",
       "      <td>3.99</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 12:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>30.20</td>\n",
       "      <td>30.30</td>\n",
       "      <td>1009</td>\n",
       "      <td>43</td>\n",
       "      <td>801</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>few clouds</td>\n",
       "      <td>17</td>\n",
       "      <td>3.50</td>\n",
       "      <td>4.58</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 15:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>26.44</td>\n",
       "      <td>26.44</td>\n",
       "      <td>1008</td>\n",
       "      <td>65</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>28</td>\n",
       "      <td>2.92</td>\n",
       "      <td>7.00</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.14</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 18:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>20.92</td>\n",
       "      <td>20.82</td>\n",
       "      <td>1009</td>\n",
       "      <td>67</td>\n",
       "      <td>500</td>\n",
       "      <td>Rain</td>\n",
       "      <td>light rain</td>\n",
       "      <td>77</td>\n",
       "      <td>4.55</td>\n",
       "      <td>13.41</td>\n",
       "      <td>10000</td>\n",
       "      <td>1.00</td>\n",
       "      <td>1.59</td>\n",
       "      <td>None</td>\n",
       "      <td>2024-07-04 21:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     temp  feels_like  pressure  humidity   id    main              desc  \\\n",
       "0   20.29       20.18      1014        69  802  Clouds  scattered clouds   \n",
       "1   20.62       20.54      1014        69  803  Clouds     broken clouds   \n",
       "2   23.42       23.44      1014        62  803  Clouds     broken clouds   \n",
       "3   28.71       28.87      1014        46  804  Clouds   overcast clouds   \n",
       "4   31.25       30.68      1013        36  803  Clouds     broken clouds   \n",
       "5   26.96       27.50      1013        52  500    Rain        light rain   \n",
       "6   24.64       24.80      1013        63  500    Rain        light rain   \n",
       "7   21.57       21.98      1013        84  500    Rain        light rain   \n",
       "8   20.52       20.90      1013        87  802  Clouds  scattered clouds   \n",
       "9   21.19       21.58      1013        85  803  Clouds     broken clouds   \n",
       "10  25.13       25.34      1013        63  500    Rain        light rain   \n",
       "11  29.01       28.80      1011        42  801  Clouds        few clouds   \n",
       "12  30.45       29.18      1010        30  802  Clouds  scattered clouds   \n",
       "13  29.83       29.18      1009        37  804  Clouds   overcast clouds   \n",
       "14  26.62       26.62      1009        52  804  Clouds   overcast clouds   \n",
       "15  24.96       25.16      1009        63  804  Clouds   overcast clouds   \n",
       "16  22.05       22.24      1009        74  804  Clouds   overcast clouds   \n",
       "17  22.61       22.73      1008        69  803  Clouds     broken clouds   \n",
       "18  27.02       27.69      1008        54  803  Clouds     broken clouds   \n",
       "19  30.52       30.06      1007        38  803  Clouds     broken clouds   \n",
       "20  31.57       30.80      1005        34  803  Clouds     broken clouds   \n",
       "21  29.62       29.71      1005        44  803  Clouds     broken clouds   \n",
       "22  25.19       25.41      1005        63  500    Rain        light rain   \n",
       "23  23.52       23.76      1005        70  800   Clear         clear sky   \n",
       "24  21.27       21.49      1006        78  802  Clouds  scattered clouds   \n",
       "25  19.49       19.66      1008        83  500    Rain        light rain   \n",
       "26  22.16       21.95      1009        58  804  Clouds   overcast clouds   \n",
       "27  25.66       25.43      1009        44  804  Clouds   overcast clouds   \n",
       "28  24.11       23.78      1010        46  804  Clouds   overcast clouds   \n",
       "29  26.40       26.40      1010        40  803  Clouds     broken clouds   \n",
       "30  23.14       22.87      1010        52  802  Clouds  scattered clouds   \n",
       "31  20.66       20.43      1012        63  800   Clear         clear sky   \n",
       "32  19.29       19.00      1013        66  800   Clear         clear sky   \n",
       "33  20.00       19.78      1013        66  800   Clear         clear sky   \n",
       "34  24.49       24.35      1013        52  801  Clouds        few clouds   \n",
       "35  28.67       28.36      1012        41  800   Clear         clear sky   \n",
       "36  30.19       29.91      1011        40  802  Clouds  scattered clouds   \n",
       "37  30.20       30.30      1009        43  801  Clouds        few clouds   \n",
       "38  26.44       26.44      1008        65  500    Rain        light rain   \n",
       "39  20.92       20.82      1009        67  500    Rain        light rain   \n",
       "\n",
       "    clouds  wind_speed  wind_gust  visibility  rain_prob  rain(mm) snow(mm)  \\\n",
       "0       42        0.64       0.65       10000       0.00       NaN     None   \n",
       "1       52        1.82       2.89       10000       0.00       NaN     None   \n",
       "2       69        2.09       2.65       10000       0.00       NaN     None   \n",
       "3      100        1.69       1.95       10000       0.00       NaN     None   \n",
       "4       54        1.66       3.36       10000       0.00       NaN     None   \n",
       "5       92        2.04       3.43       10000       0.32      0.19     None   \n",
       "6       63        2.91       6.16       10000       0.27      0.25     None   \n",
       "7       10        1.42       2.26       10000       0.99      0.78     None   \n",
       "8       40        0.92       0.88       10000       0.73       NaN     None   \n",
       "9       63        1.60       3.07       10000       0.00       NaN     None   \n",
       "10      62        2.25       3.10       10000       0.20      0.19     None   \n",
       "11      14        3.24       4.08       10000       0.00       NaN     None   \n",
       "12      48        3.53       4.20       10000       0.00       NaN     None   \n",
       "13      96        2.54       4.72       10000       0.00       NaN     None   \n",
       "14      95        1.85       3.29       10000       0.00       NaN     None   \n",
       "15      99        2.65       7.09       10000       0.00       NaN     None   \n",
       "16     100        2.27       5.00       10000       0.00       NaN     None   \n",
       "17      81        2.40       5.81       10000       0.00       NaN     None   \n",
       "18      83        3.34       5.11       10000       0.00       NaN     None   \n",
       "19      59        5.25       7.19       10000       0.00       NaN     None   \n",
       "20      60        6.04       7.73       10000       0.00       NaN     None   \n",
       "21      74        5.89       7.43       10000       0.00       NaN     None   \n",
       "22      62        4.84      11.08       10000       0.20      0.13     None   \n",
       "23       2        4.07      12.07       10000       0.00       NaN     None   \n",
       "24      25        3.15       8.46       10000       0.09       NaN     None   \n",
       "25      99        2.93       4.87       10000       0.23      0.23     None   \n",
       "26      94        2.58       2.95       10000       0.00       NaN     None   \n",
       "27      94        2.93       3.13       10000       0.00       NaN     None   \n",
       "28      97        3.50       2.95       10000       0.00       NaN     None   \n",
       "29      57        2.65       3.43       10000       0.00       NaN     None   \n",
       "30      44        1.83       3.25       10000       0.00       NaN     None   \n",
       "31       8        1.13       1.35       10000       0.00       NaN     None   \n",
       "32       8        1.37       1.64       10000       0.00       NaN     None   \n",
       "33       9        1.52       2.34       10000       0.00       NaN     None   \n",
       "34      15        1.89       2.10       10000       0.00       NaN     None   \n",
       "35       9        2.86       3.20       10000       0.00       NaN     None   \n",
       "36      39        3.17       3.99       10000       0.00       NaN     None   \n",
       "37      17        3.50       4.58       10000       0.00       NaN     None   \n",
       "38      28        2.92       7.00       10000       0.20      0.14     None   \n",
       "39      77        4.55      13.41       10000       1.00      1.59     None   \n",
       "\n",
       "       date_for_forcast  \n",
       "0   2024-06-30 00:00:00  \n",
       "1   2024-06-30 03:00:00  \n",
       "2   2024-06-30 06:00:00  \n",
       "3   2024-06-30 09:00:00  \n",
       "4   2024-06-30 12:00:00  \n",
       "5   2024-06-30 15:00:00  \n",
       "6   2024-06-30 18:00:00  \n",
       "7   2024-06-30 21:00:00  \n",
       "8   2024-07-01 00:00:00  \n",
       "9   2024-07-01 03:00:00  \n",
       "10  2024-07-01 06:00:00  \n",
       "11  2024-07-01 09:00:00  \n",
       "12  2024-07-01 12:00:00  \n",
       "13  2024-07-01 15:00:00  \n",
       "14  2024-07-01 18:00:00  \n",
       "15  2024-07-01 21:00:00  \n",
       "16  2024-07-02 00:00:00  \n",
       "17  2024-07-02 03:00:00  \n",
       "18  2024-07-02 06:00:00  \n",
       "19  2024-07-02 09:00:00  \n",
       "20  2024-07-02 12:00:00  \n",
       "21  2024-07-02 15:00:00  \n",
       "22  2024-07-02 18:00:00  \n",
       "23  2024-07-02 21:00:00  \n",
       "24  2024-07-03 00:00:00  \n",
       "25  2024-07-03 03:00:00  \n",
       "26  2024-07-03 06:00:00  \n",
       "27  2024-07-03 09:00:00  \n",
       "28  2024-07-03 12:00:00  \n",
       "29  2024-07-03 15:00:00  \n",
       "30  2024-07-03 18:00:00  \n",
       "31  2024-07-03 21:00:00  \n",
       "32  2024-07-04 00:00:00  \n",
       "33  2024-07-04 03:00:00  \n",
       "34  2024-07-04 06:00:00  \n",
       "35  2024-07-04 09:00:00  \n",
       "36  2024-07-04 12:00:00  \n",
       "37  2024-07-04 15:00:00  \n",
       "38  2024-07-04 18:00:00  \n",
       "39  2024-07-04 21:00:00  "
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "records=[]\n",
    "for entry in jdata:\n",
    "    record = {\n",
    "    'temp': entry.get('main',{}).get('temp'),\n",
    "    'feels_like': entry.get('main',{}).get('feels_like'),\n",
    "    'pressure': entry.get('main',{}).get('pressure'),\n",
    "    'humidity': entry.get('main',{}).get('humidity'),\n",
    "    'id': entry.get('weather',[{}])[0].get('id'),\n",
    "    'main': entry.get('weather',[{}])[0].get('main'),\n",
    "    'desc': entry.get('weather',[{}])[0].get('description'),\n",
    "    'clouds': entry.get('clouds',{}).get('all'),\n",
    "    'wind_speed': entry.get('wind',{}).get('speed'),\n",
    "    'wind_gust': entry.get('wind',{}).get('gust'),\n",
    "    'visibility': entry.get('visibility',{}),\n",
    "    'rain_prob': entry.get('pop',{}),\n",
    "    'rain(mm)': entry.get('rain',{}).get('3h'),\n",
    "    'snow(mm)': entry.get('snow',{}).get('3h'),\n",
    "    'date_for_forcast': entry.get('dt_txt',{}) \n",
    "    }\n",
    "    records.append(record)\n",
    "    \n",
    "df = pd.DataFrame(records)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "id": "83d47bdc-7739-4ef9-b8f6-b1dae092aa7e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 40 entries, 0 to 39\n",
      "Data columns (total 15 columns):\n",
      " #   Column            Non-Null Count  Dtype  \n",
      "---  ------            --------------  -----  \n",
      " 0   temp              40 non-null     float64\n",
      " 1   feels_like        40 non-null     float64\n",
      " 2   pressure          40 non-null     int64  \n",
      " 3   humidity          40 non-null     int64  \n",
      " 4   id                40 non-null     int64  \n",
      " 5   main              40 non-null     object \n",
      " 6   desc              40 non-null     object \n",
      " 7   clouds            40 non-null     int64  \n",
      " 8   wind_speed        40 non-null     float64\n",
      " 9   wind_gust         40 non-null     float64\n",
      " 10  visibility        40 non-null     int64  \n",
      " 11  rain_prob         40 non-null     float64\n",
      " 12  rain(mm)          8 non-null      float64\n",
      " 13  snow(mm)          0 non-null      object \n",
      " 14  date_for_forcast  40 non-null     object \n",
      "dtypes: float64(6), int64(5), object(4)\n",
      "memory usage: 4.8+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "aef9380b-cfab-4e8e-9055-38c34ab94ea4",
   "metadata": {},
   "source": [
    "### Трансформация данных\n",
    "\n",
    "##### Изменение типа данных\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "f6c98073-27c7-4922-88bd-ac687c7057e1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "temp                       float64\n",
       "feels_like                 float64\n",
       "pressure                     int64\n",
       "humidity                     int64\n",
       "id                           int64\n",
       "main                string[python]\n",
       "desc                string[python]\n",
       "clouds                       int64\n",
       "wind_speed                 float64\n",
       "wind_gust                  float64\n",
       "visibility                   int64\n",
       "rain_prob                  float64\n",
       "rain(mm)                   float64\n",
       "snow(mm)                   float64\n",
       "date_for_forcast    datetime64[ns]\n",
       "dtype: object"
      ]
     },
     "execution_count": 127,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['date_for_forcast'] = pd.to_datetime(df['date_for_forcast'])\n",
    "df['main'] = df['main'].astype('string')\n",
    "df['desc'] = df['desc'].astype('string')\n",
    "df['snow(mm)'] = df['snow(mm)'].astype('float')\n",
    "df.dtypes"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9c615993-14f7-4632-88d8-da54e32e1434",
   "metadata": {},
   "source": [
    "##### Изменение временного пояса"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "c82fcfa1-fd1f-42bd-ad36-45928d3e58b6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['date_for_forcast'] = df['date_for_forcast'].dt.tz_localize('UTC').dt.tz_convert('Europe/Moscow').dt.tz_localize(None)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "83823150-ebe3-4b36-893e-38e046fad330",
   "metadata": {},
   "source": [
    "##### Заполнение пустых ячеек"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "7ae53ed9-4715-4cd2-aea8-652b76a80911",
   "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>temp</th>\n",
       "      <th>feels_like</th>\n",
       "      <th>pressure</th>\n",
       "      <th>humidity</th>\n",
       "      <th>id</th>\n",
       "      <th>main</th>\n",
       "      <th>desc</th>\n",
       "      <th>clouds</th>\n",
       "      <th>wind_speed</th>\n",
       "      <th>wind_gust</th>\n",
       "      <th>visibility</th>\n",
       "      <th>rain_prob</th>\n",
       "      <th>rain(mm)</th>\n",
       "      <th>snow(mm)</th>\n",
       "      <th>date_for_forcast</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20.29</td>\n",
       "      <td>20.18</td>\n",
       "      <td>1014</td>\n",
       "      <td>69</td>\n",
       "      <td>802</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>scattered clouds</td>\n",
       "      <td>42</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.65</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-06-30 03:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.62</td>\n",
       "      <td>20.54</td>\n",
       "      <td>1014</td>\n",
       "      <td>69</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>52</td>\n",
       "      <td>1.82</td>\n",
       "      <td>2.89</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-06-30 06:00:00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23.42</td>\n",
       "      <td>23.44</td>\n",
       "      <td>1014</td>\n",
       "      <td>62</td>\n",
       "      <td>803</td>\n",
       "      <td>Clouds</td>\n",
       "      <td>broken clouds</td>\n",
       "      <td>69</td>\n",
       "      <td>2.09</td>\n",
       "      <td>2.65</td>\n",
       "      <td>10000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2024-06-30 09:00:00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    temp  feels_like  pressure  humidity   id    main              desc  \\\n",
       "0  20.29       20.18      1014        69  802  Clouds  scattered clouds   \n",
       "1  20.62       20.54      1014        69  803  Clouds     broken clouds   \n",
       "2  23.42       23.44      1014        62  803  Clouds     broken clouds   \n",
       "\n",
       "   clouds  wind_speed  wind_gust  visibility  rain_prob  rain(mm)  snow(mm)  \\\n",
       "0      42        0.64       0.65       10000        0.0       0.0       0.0   \n",
       "1      52        1.82       2.89       10000        0.0       0.0       0.0   \n",
       "2      69        2.09       2.65       10000        0.0       0.0       0.0   \n",
       "\n",
       "     date_for_forcast  \n",
       "0 2024-06-30 03:00:00  \n",
       "1 2024-06-30 06:00:00  \n",
       "2 2024-06-30 09:00:00  "
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['rain(mm)'] = df['rain(mm)'].fillna(0)\n",
    "df['snow(mm)'] = df['snow(mm)'].fillna(0)\n",
    "df.head(3)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4d3ca1eb-aa95-48b0-81a7-dc8cb205b87a",
   "metadata": {},
   "source": [
    "### Передача данных в облачную БД"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "6b7ceaa1-bc60-4ae1-babf-d254e9c9348a",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Defaulting to user installation because normal site-packages is not writeable\n",
      "Requirement already satisfied: psycopg2 in c:\\users\\ева\\appdata\\roaming\\python\\python311\\site-packages (2.9.9)\n"
     ]
    }
   ],
   "source": [
    "!pip install psycopg2 "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "4eaeeec2-13c7-46c8-a9f8-6caa1dba9dcc",
   "metadata": {},
   "outputs": [],
   "source": [
    "import psycopg2 as ps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "65aa573b-5d49-44d6-bd04-23adc539a832",
   "metadata": {},
   "outputs": [],
   "source": [
    "host='85.193.89.81'\n",
    "port='5432'\n",
    "database='default_db'\n",
    "user='gen_user'\n",
    "password='@Dm1C21W$Acoq1'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "9f7e66b1-dbd4-41da-80b0-6c1759cc1161",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Connected\n"
     ]
    }
   ],
   "source": [
    "try: conn = ps.connect(host=host,port=port,database=database,user=user,password=password)\n",
    "except ps.OperationalError as er:\n",
    " raise er\n",
    "else: print('Connected')"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "4cd4cc6a-01ee-461a-87e4-3541e6a7dfbe",
   "metadata": {},
   "source": [
    "##### Создание пустых строк в таблице БД"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "id": "8a2f21b0-d18b-4bd9-95b5-f869036ebafd",
   "metadata": {},
   "outputs": [],
   "source": [
    "def create_rows(table,rows):\n",
    " cursor = conn.cursor()\n",
    " for i in range(rows):\n",
    "    insert_query = f\"\"\" INSERT INTO {table} DEFAULT VALUES \"\"\"\n",
    "    cursor.execute(insert_query)\n",
    "    conn.commit() \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "365cdb55-6c28-4505-ba57-3ee194b8595a",
   "metadata": {},
   "outputs": [],
   "source": [
    "#create_rows(\"weather_forcast_5day\",len(df))"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "426965e7-bfc0-465e-a6f2-4713c4d5f4af",
   "metadata": {},
   "source": [
    "##### Обновление данных в таблице"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 157,
   "id": "6e62dc39-a056-4fe3-a16a-cf09ed991e4a",
   "metadata": {},
   "outputs": [],
   "source": [
    "queryW = (\"\"\"UPDATE \"weather_forcast_5day\" \n",
    "          set  visibility = %s,\n",
    "          rain_prob = %s,\t\n",
    "          date_for_forcast = %s,\t\n",
    "          \"temp\"\t= %s,\n",
    "          \"feels_like\" = %s,\t\t\n",
    "          \"pressure\" = %s,\n",
    "          \"humidity\" = %s,\t\t\n",
    "          \"clouds\" = %s,\t\t\n",
    "          \"wind_speed\" = %s,\t\n",
    "          \"wind_gust\"\t= %s,\t\t\t\t\t\n",
    "          \"id\" = %s,\t\t\n",
    "          \"main\" = %s, \t\t\n",
    "          \"desc\" = %s\n",
    "          WHERE row_num = %s;\"\"\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 163,
   "id": "a898b011-258f-437f-881b-7fbb7dc000ac",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\u001b[1;31mDocstring:\u001b[0m execute(query, vars=None) -- Execute query with bound vars.\n",
       "\u001b[1;31mType:\u001b[0m      builtin_function_or_method"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "cursor.execute?"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "fcafda5f-a3e5-460d-892f-ae0cc0b3a91c",
   "metadata": {},
   "outputs": [],
   "source": [
    "cursor = conn.cursor()\n",
    "for index, row in df.iterrows():\n",
    "    cursor.execute(queryW,(row['visibility'],row['rain_prob'],row['date_for_forcast'],row['temp'],row['feels_like'],row['pressure'],row['humidity'],row['clouds'],row['wind_speed'],row['wind_gust'],row['id'],row['main'],row['desc'],index+1))\n",
    "conn.commit()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d6e22ecb-9581-4e86-82c6-9f5ae7b54c07",
   "metadata": {},
   "source": [
    "##### Проверка обновления данных"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "id": "510586c1-ff12-4b3f-806e-0e4edff1989d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1 rows updated in the \"Fweather\" table.\n"
     ]
    }
   ],
   "source": [
    "    if cursor.rowcount > 0:\n",
    "        print(f'{cursor.rowcount} rows updated in the \"Fweather\" table.')\n",
    "        conn.commit()\n",
    "    else:\n",
    "        print('No rows were updated in the \"Fweather\" table.')\n"
   ]
  }
 ],
 "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.12.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}