ML.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "545a842c-da35-42e2-bd2a-9a75d223447c",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "\n",
    "# Assuming the \"data\" folder is in the current working directory\n",
    "file_path = 'data/data_v4.xlsx'\n",
    "\n",
    "# Read the Excel file into a dataframe\n",
    "df = pd.read_excel(file_path)\n",
    "\n",
    "# Now the variable df contains the dataframe with the data from the Excel file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "c0e7d952-59a4-4c2f-af9e-253127272b5b",
   "metadata": {
    "tags": []
   },
   "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>date</th>\n",
       "      <th>min_temp</th>\n",
       "      <th>max_temp</th>\n",
       "      <th>sunrise_time</th>\n",
       "      <th>sunset_time</th>\n",
       "      <th>hour</th>\n",
       "      <th>wc_temp</th>\n",
       "      <th>wind</th>\n",
       "      <th>middle_cloud</th>\n",
       "      <th>low_cloud</th>\n",
       "      <th>...</th>\n",
       "      <th>kma_weather_뇌우</th>\n",
       "      <th>kma_weather_눈</th>\n",
       "      <th>kma_weather_눈날림</th>\n",
       "      <th>kma_weather_맑음</th>\n",
       "      <th>kma_weather_비</th>\n",
       "      <th>kma_weather_비/눈</th>\n",
       "      <th>kma_weather_빗방울</th>\n",
       "      <th>kma_weather_빗방울/눈날림</th>\n",
       "      <th>kma_weather_소나기</th>\n",
       "      <th>kma_weather_흐림</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>742</td>\n",
       "      <td>1741</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>742</td>\n",
       "      <td>1741</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>742</td>\n",
       "      <td>1741</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>742</td>\n",
       "      <td>1741</td>\n",
       "      <td>10</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>110</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>742</td>\n",
       "      <td>1741</td>\n",
       "      <td>11</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 86 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "   date  min_temp  max_temp  sunrise_time  sunset_time  hour  wc_temp  wind  \\\n",
       "0   110         1         5           742         1741     7        1     0   \n",
       "1   110         1         5           742         1741     8        1     0   \n",
       "2   110         1         5           742         1741     9        1     0   \n",
       "3   110         1         5           742         1741    10        2     0   \n",
       "4   110         1         5           742         1741    11        2     0   \n",
       "\n",
       "   middle_cloud  low_cloud  ...  kma_weather_뇌우  kma_weather_눈  \\\n",
       "0             0          0  ...               0              0   \n",
       "1             0          0  ...               0              0   \n",
       "2             0          0  ...               0              0   \n",
       "3             0          0  ...               0              0   \n",
       "4             0          0  ...               0              0   \n",
       "\n",
       "   kma_weather_눈날림  kma_weather_맑음  kma_weather_비  kma_weather_비/눈  \\\n",
       "0                0               1              0                0   \n",
       "1                0               1              0                0   \n",
       "2                0               1              0                0   \n",
       "3                0               0              0                0   \n",
       "4                0               1              0                0   \n",
       "\n",
       "   kma_weather_빗방울  kma_weather_빗방울/눈날림  kma_weather_소나기  kma_weather_흐림  \n",
       "0                0                    0                0               0  \n",
       "1                0                    0                0               0  \n",
       "2                0                    0                0               0  \n",
       "3                0                    0                0               0  \n",
       "4                0                    0                0               0  \n",
       "\n",
       "[5 rows x 86 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b3724c57-b291-43c0-8980-3a7b460286b7",
   "metadata": {
    "tags": []
   },
   "source": [
    "# 기계학습 분류"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "421ed0ca-7da6-483a-ae31-6a193a3d27f7",
   "metadata": {},
   "source": [
    "- 지도학습 : 입력x와 출력y가 제시되는 학습방식\n",
    "- 비지도 학습 : 입력x만 주어지고 출력y 없이 군집화하는 방식\n",
    "- 강화 학습 : 입력x와 출력대신 평가치 c만 알려주는 방식"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0dca453f-f9b8-4966-a362-f5550aa58bee",
   "metadata": {},
   "source": [
    "# 지도학습"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d7af8f07-52f4-4305-886f-4c88e47fae2b",
   "metadata": {},
   "source": [
    "- 분류(Classification)\n",
    "- KNN\n",
    "- 회귀분석(Regression)\n",
    "- DBN\n",
    "- 신경망(ANN)\n",
    "- 은닉 마르코프 모델(HMM)\n",
    "- 의사결정 트리(Decision Tree)\n",
    "- 다층 신경망(MLP)\n",
    "- 지지벡터머신(SVM)\n",
    "- 베이지안망(Bayesian Network)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9cd7d612",
   "metadata": {},
   "source": [
    "# 기본으로 해야할 작업"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "1e4eca4f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 5122 entries, 0 to 5121\n",
      "Data columns (total 86 columns):\n",
      " #   Column               Non-Null Count  Dtype\n",
      "---  ------               --------------  -----\n",
      " 0   date                 5122 non-null   int64\n",
      " 1   min_temp             5122 non-null   int64\n",
      " 2   max_temp             5122 non-null   int64\n",
      " 3   sunrise_time         5122 non-null   int64\n",
      " 4   sunset_time          5122 non-null   int64\n",
      " 5   hour                 5122 non-null   int64\n",
      " 6   wc_temp              5122 non-null   int64\n",
      " 7   wind                 5122 non-null   int64\n",
      " 8   middle_cloud         5122 non-null   int64\n",
      " 9   low_cloud            5122 non-null   int64\n",
      " 10  kma_temp             5122 non-null   int64\n",
      " 11  generation           5122 non-null   int64\n",
      " 12  weather_1_가벼운눈       5122 non-null   int64\n",
      " 13  weather_1_가벼운비       5122 non-null   int64\n",
      " 14  weather_1_구름조금       5122 non-null   int64\n",
      " 15  weather_1_뇌우         5122 non-null   int64\n",
      " 16  weather_1_눈          5122 non-null   int64\n",
      " 17  weather_1_대체로화창      5122 non-null   int64\n",
      " 18  weather_1_대체로흐림      5122 non-null   int64\n",
      " 19  weather_1_비          5122 non-null   int64\n",
      " 20  weather_1_산발적인뇌우     5122 non-null   int64\n",
      " 21  weather_1_소나기        5122 non-null   int64\n",
      " 22  weather_1_소낙눈        5122 non-null   int64\n",
      " 23  weather_1_화창         5122 non-null   int64\n",
      " 24  weather_1_흐림         5122 non-null   int64\n",
      " 25  weather_2_가벼운눈       5122 non-null   int64\n",
      " 26  weather_2_가벼운비       5122 non-null   int64\n",
      " 27  weather_2_구름조금       5122 non-null   int64\n",
      " 28  weather_2_뇌우         5122 non-null   int64\n",
      " 29  weather_2_대체로화창      5122 non-null   int64\n",
      " 30  weather_2_대체로흐림      5122 non-null   int64\n",
      " 31  weather_2_바람         5122 non-null   int64\n",
      " 32  weather_2_비          5122 non-null   int64\n",
      " 33  weather_2_산발적인뇌우     5122 non-null   int64\n",
      " 34  weather_2_소나기        5122 non-null   int64\n",
      " 35  weather_2_소낙눈        5122 non-null   int64\n",
      " 36  weather_2_심한뇌우       5122 non-null   int64\n",
      " 37  weather_2_없음         5122 non-null   int64\n",
      " 38  weather_2_화창         5122 non-null   int64\n",
      " 39  weather_2_흐림         5122 non-null   int64\n",
      " 40  weather_3_가벼운비       5122 non-null   int64\n",
      " 41  weather_3_구름조금       5122 non-null   int64\n",
      " 42  weather_3_뇌우         5122 non-null   int64\n",
      " 43  weather_3_대체로화창      5122 non-null   int64\n",
      " 44  weather_3_대체로흐림      5122 non-null   int64\n",
      " 45  weather_3_바람         5122 non-null   int64\n",
      " 46  weather_3_비          5122 non-null   int64\n",
      " 47  weather_3_산발적인뇌우     5122 non-null   int64\n",
      " 48  weather_3_없음         5122 non-null   int64\n",
      " 49  weather_3_화창         5122 non-null   int64\n",
      " 50  weather_3_흐림         5122 non-null   int64\n",
      " 51  wc_weather_가벼운눈      5122 non-null   int64\n",
      " 52  wc_weather_가벼운비      5122 non-null   int64\n",
      " 53  wc_weather_구름조금      5122 non-null   int64\n",
      " 54  wc_weather_국지적인뇌우    5122 non-null   int64\n",
      " 55  wc_weather_뇌우        5122 non-null   int64\n",
      " 56  wc_weather_눈         5122 non-null   int64\n",
      " 57  wc_weather_대체로맑음     5122 non-null   int64\n",
      " 58  wc_weather_대체로화창     5122 non-null   int64\n",
      " 59  wc_weather_대체로흐림     5122 non-null   int64\n",
      " 60  wc_weather_맑음        5122 non-null   int64\n",
      " 61  wc_weather_비         5122 non-null   int64\n",
      " 62  wc_weather_비/눈       5122 non-null   int64\n",
      " 63  wc_weather_비/소낙눈     5122 non-null   int64\n",
      " 64  wc_weather_산발적이뇌우    5122 non-null   int64\n",
      " 65  wc_weather_산발적인뇌우    5122 non-null   int64\n",
      " 66  wc_weather_소나기       5122 non-null   int64\n",
      " 67  wc_weather_소낙눈       5122 non-null   int64\n",
      " 68  wc_weather_심한뇌우      5122 non-null   int64\n",
      " 69  wc_weather_폭우        5122 non-null   int64\n",
      " 70  wc_weather_한두차례소나기   5122 non-null   int64\n",
      " 71  wc_weather_한두차례소낙눈   5122 non-null   int64\n",
      " 72  wc_weather_화창        5122 non-null   int64\n",
      " 73  wc_weather_흐림        5122 non-null   int64\n",
      " 74  kma_weather_구름많음     5122 non-null   int64\n",
      " 75  kma_weather_구름조금     5122 non-null   int64\n",
      " 76  kma_weather_뇌우       5122 non-null   int64\n",
      " 77  kma_weather_눈        5122 non-null   int64\n",
      " 78  kma_weather_눈날림      5122 non-null   int64\n",
      " 79  kma_weather_맑음       5122 non-null   int64\n",
      " 80  kma_weather_비        5122 non-null   int64\n",
      " 81  kma_weather_비/눈      5122 non-null   int64\n",
      " 82  kma_weather_빗방울      5122 non-null   int64\n",
      " 83  kma_weather_빗방울/눈날림  5122 non-null   int64\n",
      " 84  kma_weather_소나기      5122 non-null   int64\n",
      " 85  kma_weather_흐림       5122 non-null   int64\n",
      "dtypes: int64(86)\n",
      "memory usage: 3.4 MB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "625ac134",
   "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>date</th>\n",
       "      <th>min_temp</th>\n",
       "      <th>max_temp</th>\n",
       "      <th>sunrise_time</th>\n",
       "      <th>sunset_time</th>\n",
       "      <th>hour</th>\n",
       "      <th>wc_temp</th>\n",
       "      <th>wind</th>\n",
       "      <th>middle_cloud</th>\n",
       "      <th>low_cloud</th>\n",
       "      <th>...</th>\n",
       "      <th>kma_weather_뇌우</th>\n",
       "      <th>kma_weather_눈</th>\n",
       "      <th>kma_weather_눈날림</th>\n",
       "      <th>kma_weather_맑음</th>\n",
       "      <th>kma_weather_비</th>\n",
       "      <th>kma_weather_비/눈</th>\n",
       "      <th>kma_weather_빗방울</th>\n",
       "      <th>kma_weather_빗방울/눈날림</th>\n",
       "      <th>kma_weather_소나기</th>\n",
       "      <th>kma_weather_흐림</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "      <td>5122.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>621.200508</td>\n",
       "      <td>12.697970</td>\n",
       "      <td>15.106599</td>\n",
       "      <td>641.474619</td>\n",
       "      <td>1836.888325</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>14.166537</td>\n",
       "      <td>0.133151</td>\n",
       "      <td>26.539242</td>\n",
       "      <td>29.362944</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000586</td>\n",
       "      <td>0.016790</td>\n",
       "      <td>0.001562</td>\n",
       "      <td>0.363530</td>\n",
       "      <td>0.096642</td>\n",
       "      <td>0.002929</td>\n",
       "      <td>0.021866</td>\n",
       "      <td>0.001367</td>\n",
       "      <td>0.000390</td>\n",
       "      <td>0.316673</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>364.485815</td>\n",
       "      <td>8.767002</td>\n",
       "      <td>8.468370</td>\n",
       "      <td>80.927712</td>\n",
       "      <td>80.366639</td>\n",
       "      <td>3.742023</td>\n",
       "      <td>8.667759</td>\n",
       "      <td>0.339771</td>\n",
       "      <td>38.579358</td>\n",
       "      <td>40.791544</td>\n",
       "      <td>...</td>\n",
       "      <td>0.024197</td>\n",
       "      <td>0.128498</td>\n",
       "      <td>0.039494</td>\n",
       "      <td>0.481062</td>\n",
       "      <td>0.295498</td>\n",
       "      <td>0.054042</td>\n",
       "      <td>0.146262</td>\n",
       "      <td>0.036947</td>\n",
       "      <td>0.019758</td>\n",
       "      <td>0.465224</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>101.000000</td>\n",
       "      <td>-8.000000</td>\n",
       "      <td>-4.000000</td>\n",
       "      <td>520.000000</td>\n",
       "      <td>1724.000000</td>\n",
       "      <td>7.000000</td>\n",
       "      <td>-9.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>303.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>8.000000</td>\n",
       "      <td>551.000000</td>\n",
       "      <td>1751.000000</td>\n",
       "      <td>10.000000</td>\n",
       "      <td>6.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>609.500000</td>\n",
       "      <td>12.500000</td>\n",
       "      <td>15.000000</td>\n",
       "      <td>638.500000</td>\n",
       "      <td>1830.500000</td>\n",
       "      <td>13.000000</td>\n",
       "      <td>14.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>924.000000</td>\n",
       "      <td>20.000000</td>\n",
       "      <td>23.000000</td>\n",
       "      <td>727.000000</td>\n",
       "      <td>1921.000000</td>\n",
       "      <td>16.000000</td>\n",
       "      <td>22.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>51.000000</td>\n",
       "      <td>63.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>1231.000000</td>\n",
       "      <td>28.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>743.000000</td>\n",
       "      <td>1952.000000</td>\n",
       "      <td>19.000000</td>\n",
       "      <td>30.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>100.000000</td>\n",
       "      <td>979.000000</td>\n",
       "      <td>...</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8 rows × 86 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              date     min_temp     max_temp  sunrise_time  sunset_time  \\\n",
       "count  5122.000000  5122.000000  5122.000000   5122.000000  5122.000000   \n",
       "mean    621.200508    12.697970    15.106599    641.474619  1836.888325   \n",
       "std     364.485815     8.767002     8.468370     80.927712    80.366639   \n",
       "min     101.000000    -8.000000    -4.000000    520.000000  1724.000000   \n",
       "25%     303.000000     5.000000     8.000000    551.000000  1751.000000   \n",
       "50%     609.500000    12.500000    15.000000    638.500000  1830.500000   \n",
       "75%     924.000000    20.000000    23.000000    727.000000  1921.000000   \n",
       "max    1231.000000    28.000000    30.000000    743.000000  1952.000000   \n",
       "\n",
       "              hour      wc_temp         wind  middle_cloud    low_cloud  ...  \\\n",
       "count  5122.000000  5122.000000  5122.000000   5122.000000  5122.000000  ...   \n",
       "mean     13.000000    14.166537     0.133151     26.539242    29.362944  ...   \n",
       "std       3.742023     8.667759     0.339771     38.579358    40.791544  ...   \n",
       "min       7.000000    -9.000000     0.000000      0.000000     0.000000  ...   \n",
       "25%      10.000000     6.000000     0.000000      0.000000     0.000000  ...   \n",
       "50%      13.000000    14.000000     0.000000      0.000000     5.000000  ...   \n",
       "75%      16.000000    22.000000     0.000000     51.000000    63.000000  ...   \n",
       "max      19.000000    30.000000     1.000000    100.000000   979.000000  ...   \n",
       "\n",
       "       kma_weather_뇌우  kma_weather_눈  kma_weather_눈날림  kma_weather_맑음  \\\n",
       "count     5122.000000    5122.000000      5122.000000     5122.000000   \n",
       "mean         0.000586       0.016790         0.001562        0.363530   \n",
       "std          0.024197       0.128498         0.039494        0.481062   \n",
       "min          0.000000       0.000000         0.000000        0.000000   \n",
       "25%          0.000000       0.000000         0.000000        0.000000   \n",
       "50%          0.000000       0.000000         0.000000        0.000000   \n",
       "75%          0.000000       0.000000         0.000000        1.000000   \n",
       "max          1.000000       1.000000         1.000000        1.000000   \n",
       "\n",
       "       kma_weather_비  kma_weather_비/눈  kma_weather_빗방울  kma_weather_빗방울/눈날림  \\\n",
       "count    5122.000000      5122.000000      5122.000000          5122.000000   \n",
       "mean        0.096642         0.002929         0.021866             0.001367   \n",
       "std         0.295498         0.054042         0.146262             0.036947   \n",
       "min         0.000000         0.000000         0.000000             0.000000   \n",
       "25%         0.000000         0.000000         0.000000             0.000000   \n",
       "50%         0.000000         0.000000         0.000000             0.000000   \n",
       "75%         0.000000         0.000000         0.000000             0.000000   \n",
       "max         1.000000         1.000000         1.000000             1.000000   \n",
       "\n",
       "       kma_weather_소나기  kma_weather_흐림  \n",
       "count      5122.000000     5122.000000  \n",
       "mean          0.000390        0.316673  \n",
       "std           0.019758        0.465224  \n",
       "min           0.000000        0.000000  \n",
       "25%           0.000000        0.000000  \n",
       "50%           0.000000        0.000000  \n",
       "75%           0.000000        1.000000  \n",
       "max           1.000000        1.000000  \n",
       "\n",
       "[8 rows x 86 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "e2b51dd3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date                   0\n",
       "min_temp               0\n",
       "max_temp               0\n",
       "sunrise_time           0\n",
       "sunset_time            0\n",
       "                      ..\n",
       "kma_weather_비/눈        0\n",
       "kma_weather_빗방울        0\n",
       "kma_weather_빗방울/눈날림    0\n",
       "kma_weather_소나기        0\n",
       "kma_weather_흐림         0\n",
       "Length: 86, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "b82dac68",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "date  min_temp  max_temp  sunrise_time  sunset_time  hour  wc_temp  wind  middle_cloud  low_cloud  kma_temp  generation  weather_1_가벼운눈  weather_1_가벼운비  weather_1_구름조금  weather_1_뇌우  weather_1_눈  weather_1_대체로화창  weather_1_대체로흐림  weather_1_비  weather_1_산발적인뇌우  weather_1_소나기  weather_1_소낙눈  weather_1_화창  weather_1_흐림  weather_2_가벼운눈  weather_2_가벼운비  weather_2_구름조금  weather_2_뇌우  weather_2_대체로화창  weather_2_대체로흐림  weather_2_바람  weather_2_비  weather_2_산발적인뇌우  weather_2_소나기  weather_2_소낙눈  weather_2_심한뇌우  weather_2_없음  weather_2_화창  weather_2_흐림  weather_3_가벼운비  weather_3_구름조금  weather_3_뇌우  weather_3_대체로화창  weather_3_대체로흐림  weather_3_바람  weather_3_비  weather_3_산발적인뇌우  weather_3_없음  weather_3_화창  weather_3_흐림  wc_weather_가벼운눈  wc_weather_가벼운비  wc_weather_구름조금  wc_weather_국지적인뇌우  wc_weather_뇌우  wc_weather_눈  wc_weather_대체로맑음  wc_weather_대체로화창  wc_weather_대체로흐림  wc_weather_맑음  wc_weather_비  wc_weather_비/눈  wc_weather_비/소낙눈  wc_weather_산발적이뇌우  wc_weather_산발적인뇌우  wc_weather_소나기  wc_weather_소낙눈  wc_weather_심한뇌우  wc_weather_폭우  wc_weather_한두차례소나기  wc_weather_한두차례소낙눈  wc_weather_화창  wc_weather_흐림  kma_weather_구름많음  kma_weather_구름조금  kma_weather_뇌우  kma_weather_눈  kma_weather_눈날림  kma_weather_맑음  kma_weather_비  kma_weather_비/눈  kma_weather_빗방울  kma_weather_빗방울/눈날림  kma_weather_소나기  kma_weather_흐림\n",
       "101   2         6         742           1734         7     2        0     0             3          3         0           0               0               1               0             0            0                0                0            0                 0              0              0             0             0               0               0               0             0                1                0             0            0                 0              0              0               0             0             0             0               0               0             0                0                0             0            0                 1             0             0             0                0                1                0                  0              0             0                 0                 0                 0              0             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               0              0                0                0                    0                1                 1\n",
       "924   21        25        625           1830         13    25       0     0             0          26        151704896   0               0               0               0             0            0                1                0            0                 0              0              0             0             0               0               1               0             0                0                0             0            0                 0              0              0               0             0             0             0               0               0             0                0                0             0            0                 1             0             0             0                0                1                0                  0              0             0                 0                 0                 0              0             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              1                 0                 0               0              0                0               0              0                0                0                    0                0                 1\n",
       "823   26        27        602           1914         7     26       0     59            79         25        0           0               0               0               1             0            0                0                0            0                 0              0              0             0             0               0               0               0             0                0                0             0            0                 0              0              1               0             0             0             0               0               0             0                0                0             0            0                 1             0             0             0                0                0                0                  1              0             0                 0                 0                 0              0             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               1              0                0                0                    0                0                 1\n",
       "822   28        29        601           1916         19    28       0     25            74         26        6286560     0               0               0               1             0            0                0                0            0                 0              0              0             0             0               0               1               0             0                0                0             0            0                 0              0              0               0             0             0             0               0               1             0                0                0             0            0                 0             0             0             0                0                0                0                  1              0             0                 0                 0                 0              0             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               0              0                0                0                    0                1                 1\n",
       "                                                     18    28       0     9             8          28        34716864    0               0               0               1             0            0                0                0            0                 0              0              0             0             0               0               1               0             0                0                0             0            0                 0              0              0               0             0             0             0               0               1             0                0                0             0            0                 0             0             0             0                0                0                0                  1              0             0                 0                 0                 0              0             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               1              0                0                0                    0                0                 1\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           ..\n",
       "405   12        14        617           1858         10    14       0     99            100        16        3121216     0               0               0               0             0            0                0                1            0                 0              0              0             0             0               0               0               0             0                0                0             0            0                 0              0              0               0             0             1             0               0               0             0                0                0             0            0                 1             0             0             0                0                0                0                  0              0             0                 0                 0                 0              1             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               1              0                0                0                    0                0                 1\n",
       "                                                     9     14       0     100           100        16        314048      0               0               0               0             0            0                0                1            0                 0              0              0             0             0               0               0               0             0                0                0             0            0                 0              0              0               0             0             1             0               0               0             0                0                0             0            0                 1             0             0             0                0                0                0                  0              0             0                 0                 0                 0              1             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               1              0                0                0                    0                0                 1\n",
       "                                                     8     13       0     100           100        15        0           0               0               0               0             0            0                0                1            0                 0              0              0             0             0               0               0               0             0                0                0             0            0                 0              0              0               0             0             1             0               0               0             0                0                0             0            0                 1             0             0             0                0                0                0                  0              0             0                 0                 0                 0              1             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               1              0                0                0                    0                0                 1\n",
       "                                                     7     13       0     100           100        15        0           0               0               0               0             0            0                0                1            0                 0              0              0             0             0               0               0               0             0                0                0             0            0                 0              0              0               0             0             1             0               0               0             0                0                0             0            0                 1             0             0             0                0                0                0                  0              0             0                 0                 0                 0              1             0               0                 0                  0                  0               0               0                0              0                   0                   0              0              0                 0                 0               0              0                0               1              0                0                0                    0                0                 1\n",
       "1231  7         8         742           1734         19    6        1     0             100        5         0           0               0               0               0             0            0                1                0            0                 0              0              0             0             0               0               0               0             0                0                0             0            0                 0              0              0               0             0             1             0               0               0             0                0                1             0            0                 0             0             0             0                0                0                0                  0              0             0                 0                 0                 0              0             0               0                 0                  0                  0               0               0                0              0                   0                   0              1              0                 0                 0               0              0                0               0              0                0                0                    0                1                 1\n",
       "Name: count, Length: 5122, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.value_counts()"
   ]
  }
 ],
 "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.11.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}