231120labelEDA.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import glob\n",
    "import os\n",
    "\n",
    "def glob_files(path, file_type = '*'):\n",
    "    search_string = os.path.join(path, file_type)\n",
    "    files = glob.glob(search_string)\n",
    "    \n",
    "    paths = []\n",
    "    for f in files:\n",
    "        if os.path.isdir(f):\n",
    "            sub_paths = glob_files(f + '/')\n",
    "            paths += sub_paths\n",
    "        else:\n",
    "            paths.append(f)\n",
    "    \n",
    "    paths.sort()\n",
    "\n",
    "    return paths"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "만약 path가 폴더명이라면 뒤에 '/'를 붙여주고 다시 glob_files() 함수를 돌려라는 말."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_001.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_002.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_003.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_004.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_005.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_006.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_007.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_008.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_009.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_010.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_011.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_012.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_013.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_014.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_015.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_016.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_017.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_018.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_019.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_020.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_021.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_022.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_023.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_024.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_025.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_026.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_027.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_028.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_029.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_030.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_031.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_032.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_033.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_034.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_035.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_036.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_037.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_038.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_039.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_040.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_041.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_042.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_043.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_044.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_045.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_046.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_047.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_048.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_049.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_050.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_051.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_052.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_053.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_054.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_055.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_056.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_057.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_058.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_059.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_060.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_061.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_062.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_063.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_064.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_065.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_066.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_067.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_068.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_069.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_070.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_071.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_072.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_073.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_074.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_075.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_076.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_077.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_078.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_079.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_080.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_081.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_082.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_083.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_084.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_085.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_086.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_087.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_088.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_089.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_090.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_091.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_092.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_093.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_094.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_095.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_096.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_097.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_098.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_099.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_100.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_101.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_102.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_103.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_104.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_105.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_106.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_107.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_108.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_109.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_110.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_111.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_112.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_113.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_114.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_115.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_116.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_117.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_118.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_119.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_120.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_121.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_122.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_123.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_124.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_125.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_126.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_127.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_128.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_129.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_130.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_131.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_132.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_133.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_134.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_135.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_136.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_137.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_138.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_139.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_140.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_141.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_142.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_143.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_144.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_145.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_146.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_147.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_148.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_149.txt',\n",
       " 'highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD_150.txt']"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test = glob_files('highway/valid/label/Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD')\n",
    "test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "\n",
    "WIDTH = 1080\n",
    "HEIGHT = 1920\n",
    "\n",
    "def load_labels(path):\n",
    "    files = glob_files(path, '*.txt')\n",
    "\n",
    "    Y_data = []\n",
    "    for file in files:\n",
    "        with open(file) as f:\n",
    "            lines = f.readlines()\n",
    "\n",
    "            boxes = []\n",
    "            for line in lines:\n",
    "                tokens = line.split()\n",
    "\n",
    "                class_id = int(tokens[0])\n",
    "                xc = float(tokens[1]) * WIDTH\n",
    "                yc = float(tokens[2]) * HEIGHT\n",
    "                width = float(tokens[3]) * WIDTH\n",
    "                height = float(tokens[4]) * HEIGHT\n",
    "\n",
    "                boxes.append(np.array([class_id, xc, yc, width, height]))\n",
    "\n",
    "            Y_data.append(np.array(boxes))\n",
    "        \n",
    "    return Y_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "basePath = 'highway/valid/label/'\n",
    "Y_test = load_labels(os.path.join(basePath, 'Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['highway/valid/label\\\\Suwon_CH01_20200720_1830_MON_9m_RH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH01_20200721_1700_TUE_9m_RH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH01_20200722_1430_WED_9m_NH_highway_TW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH01_20200722_1930_WED_9m_NH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH01_20201012_1723_MON_9m_RH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH01_20201213_1200_SUN_9m_NH_highway_TW5_snow_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH02_20200720_2130_MON_9m_NH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH02_20200721_2030_TUE_9m_NH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH02_20200722_1730_WED_9m_NH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH02_20201011_1806_SUN_9m_RH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH02_20201213_0933_SUN_9m_NH_highway_TW5_snow_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH03_20200720_2030_MON_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH03_20200721_2000_TUE_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH03_20200722_1700_WED_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH03_20201011_1742_SUN_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH03_20201012_1933_MON_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH04_20200720_1830_MON_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH04_20200721_1830_TUE_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH04_20200722_1600_WED_9m_NH_highway_OW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH04_20201010_1818_SAT_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH04_20201012_1838_MON_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH05_20200720_1830_MON_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH05_20200721_1700_TUE_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH05_20200722_1430_WED_9m_NH_highway_OW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH05_20201010_1723_SAT_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH05_20201012_1807_MON_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH06_20200720_1730_MON_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH06_20200721_1600_TUE_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH06_20200722_1400_WED_9m_NH_highway_OW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH06_20200722_1900_WED_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH06_20201012_1839_MON_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH07_20200720_1900_MON_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH07_20200721_1800_TUE_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH07_20200722_1530_WED_9m_NH_highway_OW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH07_20201010_1805_SAT_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH07_20201012_1853_MON_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH08_20200720_1830_MON_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH08_20200721_1730_TUE_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH08_20200722_1500_WED_9m_NH_highway_OW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH08_20201010_1740_SAT_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH08_20201012_1858_MON_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH09_20200720_1900_MON_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH09_20200721_1730_TUE_9m_NH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH09_20200722_1530_WED_9m_NH_highway_OW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH09_20201010_1745_SAT_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH09_20201012_1903_MON_9m_RH_highway_OW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH10_20200720_1830_MON_9m_NH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH10_20200721_1700_TUE_9m_NH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH10_20200722_1500_WED_9m_NH_highway_TW5_rainy_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH10_20200722_2000_WED_9m_NH_highway_TW5_sunny_FHD.xml',\n",
       " 'highway/valid/label\\\\Suwon_CH10_20201213_0752_SUN_9m_NH_highway_OW5_snow_FHD.xml']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from glob import glob\n",
    "\n",
    "glob(os.path.join(basePath, '*.xml'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['Suwon',\n",
       "  'CH01',\n",
       "  '20200720',\n",
       "  '1830',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH01',\n",
       "  '20200721',\n",
       "  '1700',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH01',\n",
       "  '20200722',\n",
       "  '1430',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH01',\n",
       "  '20200722',\n",
       "  '1930',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH01',\n",
       "  '20201012',\n",
       "  '1723',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH01',\n",
       "  '20201213',\n",
       "  '1200',\n",
       "  'SUN',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'snow',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH02',\n",
       "  '20200720',\n",
       "  '2130',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH02',\n",
       "  '20200721',\n",
       "  '2030',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH02',\n",
       "  '20200722',\n",
       "  '1730',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH02',\n",
       "  '20201011',\n",
       "  '1806',\n",
       "  'SUN',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH02',\n",
       "  '20201213',\n",
       "  '0933',\n",
       "  'SUN',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'snow',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH03',\n",
       "  '20200720',\n",
       "  '2030',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH03',\n",
       "  '20200721',\n",
       "  '2000',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH03',\n",
       "  '20200722',\n",
       "  '1700',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH03',\n",
       "  '20201011',\n",
       "  '1742',\n",
       "  'SUN',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH03',\n",
       "  '20201012',\n",
       "  '1933',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH04',\n",
       "  '20200720',\n",
       "  '1830',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH04',\n",
       "  '20200721',\n",
       "  '1830',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH04',\n",
       "  '20200722',\n",
       "  '1600',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH04',\n",
       "  '20201010',\n",
       "  '1818',\n",
       "  'SAT',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH04',\n",
       "  '20201012',\n",
       "  '1838',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH05',\n",
       "  '20200720',\n",
       "  '1830',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH05',\n",
       "  '20200721',\n",
       "  '1700',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH05',\n",
       "  '20200722',\n",
       "  '1430',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH05',\n",
       "  '20201010',\n",
       "  '1723',\n",
       "  'SAT',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH05',\n",
       "  '20201012',\n",
       "  '1807',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH06',\n",
       "  '20200720',\n",
       "  '1730',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH06',\n",
       "  '20200721',\n",
       "  '1600',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH06',\n",
       "  '20200722',\n",
       "  '1400',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH06',\n",
       "  '20200722',\n",
       "  '1900',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH06',\n",
       "  '20201012',\n",
       "  '1839',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH07',\n",
       "  '20200720',\n",
       "  '1900',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH07',\n",
       "  '20200721',\n",
       "  '1800',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH07',\n",
       "  '20200722',\n",
       "  '1530',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH07',\n",
       "  '20201010',\n",
       "  '1805',\n",
       "  'SAT',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH07',\n",
       "  '20201012',\n",
       "  '1853',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH08',\n",
       "  '20200720',\n",
       "  '1830',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH08',\n",
       "  '20200721',\n",
       "  '1730',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH08',\n",
       "  '20200722',\n",
       "  '1500',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH08',\n",
       "  '20201010',\n",
       "  '1740',\n",
       "  'SAT',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH08',\n",
       "  '20201012',\n",
       "  '1858',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH09',\n",
       "  '20200720',\n",
       "  '1900',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH09',\n",
       "  '20200721',\n",
       "  '1730',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH09',\n",
       "  '20200722',\n",
       "  '1530',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH09',\n",
       "  '20201010',\n",
       "  '1745',\n",
       "  'SAT',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH09',\n",
       "  '20201012',\n",
       "  '1903',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'RH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH10',\n",
       "  '20200720',\n",
       "  '1830',\n",
       "  'MON',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH10',\n",
       "  '20200721',\n",
       "  '1700',\n",
       "  'TUE',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH10',\n",
       "  '20200722',\n",
       "  '1500',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'rainy',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH10',\n",
       "  '20200722',\n",
       "  '2000',\n",
       "  'WED',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'TW5',\n",
       "  'sunny',\n",
       "  'FHD'],\n",
       " ['Suwon',\n",
       "  'CH10',\n",
       "  '20201213',\n",
       "  '0752',\n",
       "  'SUN',\n",
       "  '9m',\n",
       "  'NH',\n",
       "  'highway',\n",
       "  'OW5',\n",
       "  'snow',\n",
       "  'FHD']]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "valid_filename = []\n",
    "for filepath in glob(os.path.join(basePath, '*.xml')):\n",
    "    filename = os.path.basename(filepath)  ## 상위폴더 경로 제거\n",
    "    filename = filename[:-4]  ## .xml 제거\n",
    "    filename_parsed = filename.split('_')  ## 정보 쪼개기\n",
    "    valid_filename.append(filename_parsed)  ## nested list\n",
    "\n",
    "valid_filename"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "os.path.basename() 해도 확장자명은 따라온다!"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>region</th>\n",
       "      <th>channel</th>\n",
       "      <th>ymd</th>\n",
       "      <th>time</th>\n",
       "      <th>date</th>\n",
       "      <th>camera_height</th>\n",
       "      <th>RushHour</th>\n",
       "      <th>road</th>\n",
       "      <th>road_lane</th>\n",
       "      <th>weather</th>\n",
       "      <th>resolution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200720</td>\n",
       "      <td>1830</td>\n",
       "      <td>MON</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200721</td>\n",
       "      <td>1700</td>\n",
       "      <td>TUE</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200722</td>\n",
       "      <td>1430</td>\n",
       "      <td>WED</td>\n",
       "      <td>9m</td>\n",
       "      <td>NH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>rainy</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200722</td>\n",
       "      <td>1930</td>\n",
       "      <td>WED</td>\n",
       "      <td>9m</td>\n",
       "      <td>NH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20201012</td>\n",
       "      <td>1723</td>\n",
       "      <td>MON</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  region channel       ymd  time date camera_height RushHour     road  \\\n",
       "0  Suwon    CH01  20200720  1830  MON            9m       RH  highway   \n",
       "1  Suwon    CH01  20200721  1700  TUE            9m       RH  highway   \n",
       "2  Suwon    CH01  20200722  1430  WED            9m       NH  highway   \n",
       "3  Suwon    CH01  20200722  1930  WED            9m       NH  highway   \n",
       "4  Suwon    CH01  20201012  1723  MON            9m       RH  highway   \n",
       "\n",
       "  road_lane weather resolution  \n",
       "0       TW5   sunny        FHD  \n",
       "1       TW5   sunny        FHD  \n",
       "2       TW5   rainy        FHD  \n",
       "3       TW5   sunny        FHD  \n",
       "4       TW5   sunny        FHD  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.DataFrame(valid_filename)\n",
    "df.columns = ['region', 'channel', 'ymd', 'time', 'date', 'camera_height', 'RushHour', 'road', 'road_lane', 'weather', 'resolution']\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 51 entries, 0 to 50\n",
      "Data columns (total 11 columns):\n",
      " #   Column         Non-Null Count  Dtype \n",
      "---  ------         --------------  ----- \n",
      " 0   region         51 non-null     object\n",
      " 1   channel        51 non-null     object\n",
      " 2   ymd            51 non-null     object\n",
      " 3   time           51 non-null     object\n",
      " 4   date           51 non-null     object\n",
      " 5   camera_height  51 non-null     object\n",
      " 6   RushHour       51 non-null     object\n",
      " 7   road           51 non-null     object\n",
      " 8   road_lane      51 non-null     object\n",
      " 9   weather        51 non-null     object\n",
      " 10  resolution     51 non-null     object\n",
      "dtypes: object(11)\n",
      "memory usage: 4.5+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "channel\n",
       "CH01    6\n",
       "CH02    5\n",
       "CH03    5\n",
       "CH04    5\n",
       "CH05    5\n",
       "CH06    5\n",
       "CH07    5\n",
       "CH08    5\n",
       "CH09    5\n",
       "CH10    5\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['channel'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "RushHour\n",
       "NH    34\n",
       "RH    17\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['RushHour'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "road_lane\n",
       "OW5    36\n",
       "TW5    15\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['road_lane'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "weather\n",
       "sunny    40\n",
       "rainy     8\n",
       "snow      3\n",
       "Name: count, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['weather'].value_counts()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### rush hour 시간대 확인"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     1830\n",
       "1     1700\n",
       "4     1723\n",
       "9     1806\n",
       "14    1742\n",
       "15    1933\n",
       "17    1830\n",
       "19    1818\n",
       "20    1838\n",
       "25    1807\n",
       "30    1839\n",
       "34    1805\n",
       "35    1853\n",
       "39    1740\n",
       "40    1858\n",
       "44    1745\n",
       "45    1903\n",
       "Name: time, dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['RushHour'] == 'RH']['time']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1700'"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['RushHour'] == 'RH']['time'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'1933'"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['RushHour'] == 'RH']['time'].max()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('valid_title.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>region</th>\n",
       "      <th>channel</th>\n",
       "      <th>ymd</th>\n",
       "      <th>time</th>\n",
       "      <th>date</th>\n",
       "      <th>camera_height</th>\n",
       "      <th>RushHour</th>\n",
       "      <th>road</th>\n",
       "      <th>road_lane</th>\n",
       "      <th>weather</th>\n",
       "      <th>resolution</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200720</td>\n",
       "      <td>1830</td>\n",
       "      <td>MON</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200721</td>\n",
       "      <td>1700</td>\n",
       "      <td>TUE</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200722</td>\n",
       "      <td>1430</td>\n",
       "      <td>WED</td>\n",
       "      <td>9m</td>\n",
       "      <td>NH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>rainy</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200722</td>\n",
       "      <td>1930</td>\n",
       "      <td>WED</td>\n",
       "      <td>9m</td>\n",
       "      <td>NH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20201012</td>\n",
       "      <td>1723</td>\n",
       "      <td>MON</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  region channel       ymd  time date camera_height RushHour     road  \\\n",
       "0  Suwon    CH01  20200720  1830  MON            9m       RH  highway   \n",
       "1  Suwon    CH01  20200721  1700  TUE            9m       RH  highway   \n",
       "2  Suwon    CH01  20200722  1430  WED            9m       NH  highway   \n",
       "3  Suwon    CH01  20200722  1930  WED            9m       NH  highway   \n",
       "4  Suwon    CH01  20201012  1723  MON            9m       RH  highway   \n",
       "\n",
       "  road_lane weather resolution  \n",
       "0       TW5   sunny        FHD  \n",
       "1       TW5   sunny        FHD  \n",
       "2       TW5   rainy        FHD  \n",
       "3       TW5   sunny        FHD  \n",
       "4       TW5   sunny        FHD  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv('valid_title.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>region</th>\n",
       "      <th>channel</th>\n",
       "      <th>ymd</th>\n",
       "      <th>time</th>\n",
       "      <th>date</th>\n",
       "      <th>camera_height</th>\n",
       "      <th>RushHour</th>\n",
       "      <th>road</th>\n",
       "      <th>road_lane</th>\n",
       "      <th>weather</th>\n",
       "      <th>resolution</th>\n",
       "      <th>cnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200720</td>\n",
       "      <td>1830</td>\n",
       "      <td>MON</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200721</td>\n",
       "      <td>1700</td>\n",
       "      <td>TUE</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200722</td>\n",
       "      <td>1430</td>\n",
       "      <td>WED</td>\n",
       "      <td>9m</td>\n",
       "      <td>NH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>rainy</td>\n",
       "      <td>FHD</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20200722</td>\n",
       "      <td>1930</td>\n",
       "      <td>WED</td>\n",
       "      <td>9m</td>\n",
       "      <td>NH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Suwon</td>\n",
       "      <td>CH01</td>\n",
       "      <td>20201012</td>\n",
       "      <td>1723</td>\n",
       "      <td>MON</td>\n",
       "      <td>9m</td>\n",
       "      <td>RH</td>\n",
       "      <td>highway</td>\n",
       "      <td>TW5</td>\n",
       "      <td>sunny</td>\n",
       "      <td>FHD</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  region channel       ymd  time date camera_height RushHour     road  \\\n",
       "0  Suwon    CH01  20200720  1830  MON            9m       RH  highway   \n",
       "1  Suwon    CH01  20200721  1700  TUE            9m       RH  highway   \n",
       "2  Suwon    CH01  20200722  1430  WED            9m       NH  highway   \n",
       "3  Suwon    CH01  20200722  1930  WED            9m       NH  highway   \n",
       "4  Suwon    CH01  20201012  1723  MON            9m       RH  highway   \n",
       "\n",
       "  road_lane weather resolution  cnt  \n",
       "0       TW5   sunny        FHD    1  \n",
       "1       TW5   sunny        FHD    1  \n",
       "2       TW5   rainy        FHD    1  \n",
       "3       TW5   sunny        FHD    1  \n",
       "4       TW5   sunny        FHD    1  "
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['cnt'] = 1\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th>RushHour</th>\n",
       "      <th colspan=\"6\" halign=\"left\">NH</th>\n",
       "      <th colspan=\"2\" halign=\"left\">RH</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>road_lane</th>\n",
       "      <th colspan=\"3\" halign=\"left\">OW5</th>\n",
       "      <th colspan=\"3\" halign=\"left\">TW5</th>\n",
       "      <th>OW5</th>\n",
       "      <th>TW5</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>weather</th>\n",
       "      <th>rainy</th>\n",
       "      <th>snow</th>\n",
       "      <th>sunny</th>\n",
       "      <th>rainy</th>\n",
       "      <th>snow</th>\n",
       "      <th>sunny</th>\n",
       "      <th>sunny</th>\n",
       "      <th>sunny</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>channel</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CH01</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH02</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH03</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH04</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH05</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH06</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH07</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH08</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH09</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CH10</th>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "RushHour     NH                                RH      \n",
       "road_lane   OW5              TW5              OW5   TW5\n",
       "weather   rainy snow sunny rainy snow sunny sunny sunny\n",
       "channel                                                \n",
       "CH01        NaN  NaN   NaN   1.0  1.0   1.0   NaN   3.0\n",
       "CH02        NaN  NaN   NaN   NaN  1.0   3.0   NaN   1.0\n",
       "CH03        NaN  NaN   3.0   NaN  NaN   NaN   2.0   NaN\n",
       "CH04        1.0  NaN   1.0   NaN  NaN   NaN   3.0   NaN\n",
       "CH05        1.0  NaN   3.0   NaN  NaN   NaN   1.0   NaN\n",
       "CH06        1.0  NaN   3.0   NaN  NaN   NaN   1.0   NaN\n",
       "CH07        1.0  NaN   2.0   NaN  NaN   NaN   2.0   NaN\n",
       "CH08        1.0  NaN   2.0   NaN  NaN   NaN   2.0   NaN\n",
       "CH09        1.0  NaN   2.0   NaN  NaN   NaN   2.0   NaN\n",
       "CH10        NaN  1.0   NaN   1.0  NaN   3.0   NaN   NaN"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.pivot_table(df, index='channel', columns=['RushHour', 'road_lane', 'weather'], values='cnt', aggfunc='sum')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "yolov8",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.18"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}