Newer
Older
WasteNet / notebooks / reconst_train_csv_with_split.ipynb
@sato sato on 1 Mar 2022 30 KB 最初のコミット
{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "0bbb5e31-7578-40b5-b687-80b81064a550",
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys\n",
    "sys.path.append(\"../src\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b833f6d0-1c26-451a-b951-8dcdfba882c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "SPLIT_NUM = 10"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "bfdf015a-d937-4805-9f65-a8fc74df7b46",
   "metadata": {},
   "outputs": [],
   "source": [
    "import random\n",
    "import os.path as osp\n",
    "import matplotlib.pyplot as plt\n",
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "6d676ad4-8863-4d4e-88dd-8966dbfe6b41",
   "metadata": {},
   "outputs": [],
   "source": [
    "src = pd.read_csv(\"../input/train.csv\", header=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "5b6595d5-05e0-4a2e-b932-a2b61f97da05",
   "metadata": {},
   "outputs": [],
   "source": [
    "total_data_num = src.shape[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "24a9b217-fa3d-42f9-b2d9-c344889d22f4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "32373"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "total_data_num"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "2c255a0c-0649-48af-970e-919045c5bf18",
   "metadata": {},
   "outputs": [],
   "source": [
    "splited_data_num = 32373 // SPLIT_NUM"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "46cb1fd3-5498-4c98-bbd7-d4c0e3f30bb2",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                   0  \\\n",
       "0  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "1  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "2  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "3  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "4  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "\n",
       "                                                   1  \\\n",
       "0  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "1  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "2  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "3  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "4  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "\n",
       "                                                   2      3  \n",
       "0  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...  False  \n",
       "1  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...  False  \n",
       "2  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   True  \n",
       "3  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   True  \n",
       "4  D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   True  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "src.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "537dae35-c4a4-49f6-ab4d-69044d9999ed",
   "metadata": {},
   "outputs": [],
   "source": [
    "corrects = src[src[3] == True]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "id": "56969660-1a2b-4ae8-9a13-3c8e75411e16",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-61-5cac1ff16056>:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  corrects[\"split\"] = 999\n"
     ]
    }
   ],
   "source": [
    "corrects[\"split\"] = 999"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 63,
   "id": "fbb77cb4-0c87-4892-9d06-09678bd7ac6f",
   "metadata": {},
   "outputs": [],
   "source": [
    "corrects.to_csv(\"../input/bagging/corrects.csv\", header=None, index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "389b6072-5e35-474b-85e0-475287ba633f",
   "metadata": {},
   "outputs": [],
   "source": [
    "target = src[src[3] == False]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "0dca8960-7590-4e30-867a-c3504511e2e6",
   "metadata": {},
   "outputs": [],
   "source": [
    "seq_col = []\n",
    "for _, row in target.iterrows():\n",
    "    sample = row[0]\n",
    "    seq_name = osp.basename(osp.dirname(sample))\n",
    "    seq_col.append(int(seq_name[-1]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "d2e221ab-587c-4bab-8595-0e3b126f010a",
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp_target = target[target[\"seq\"] == 0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "d4541d6a-6a90-41e3-b5d9-529efab3b569",
   "metadata": {},
   "outputs": [],
   "source": [
    "import itertools"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "cf940f00-6106-4614-8ca2-6af12d216b61",
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp_split_num = []\n",
    "for i in itertools.cycle(range(10)):\n",
    "    tmp_split_num.append(i)\n",
    "    if len(tmp_split_num) == tmp_target.shape[0]:\n",
    "        break\n",
    "random.shuffle(tmp_split_num)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "a42ce653-fb5a-4fe1-be52-66e7dd35d15c",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n",
      "<ipython-input-44-5da5823ccadb>:10: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  tmp_target[\"split\"] = tmp_split_num\n"
     ]
    }
   ],
   "source": [
    "out_df = None\n",
    "for seq_num in range(9):\n",
    "    tmp_target = target[target[\"seq\"] == seq_num]\n",
    "    tmp_split_num = []\n",
    "    for split_num in itertools.cycle(range(10)):\n",
    "        tmp_split_num.append(split_num)\n",
    "        if len(tmp_split_num) == tmp_target.shape[0]:\n",
    "            break\n",
    "    random.shuffle(tmp_split_num)\n",
    "    tmp_target[\"split\"] = tmp_split_num\n",
    "    \n",
    "    if seq_num == 0:\n",
    "        out_df = tmp_target\n",
    "    else:\n",
    "        out_df = pd.concat([out_df, tmp_target], axis=0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "8906a080-d7b8-48a8-b247-57fe9ebedeb7",
   "metadata": {},
   "outputs": [],
   "source": [
    "tmp = out_df[out_df[\"seq\"] == 1]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 53,
   "id": "60ea9f62-e3cf-4545-aa7a-d187aefbde6d",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>seq</th>\n",
       "      <th>split</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>552</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>553</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>556</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>557</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>558</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5738</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5739</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5740</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5743</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence2\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5744</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence2\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence2\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4695 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                      0  \\\n",
       "552   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "553   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "556   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "557   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "558   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "...                                                 ...   \n",
       "5738  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5739  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5740  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5743  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5744  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "\n",
       "                                                      1  \\\n",
       "552   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "553   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "556   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "557   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "558   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "...                                                 ...   \n",
       "5738  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5739  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5740  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5743  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...   \n",
       "5744  D:\\Deep_Learning\\WasteNet\\dataset\\sequence2\\00...   \n",
       "\n",
       "                                                      2      3  seq  split  \n",
       "552   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      0  \n",
       "553   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      1  \n",
       "556   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      0  \n",
       "557   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      1  \n",
       "558   D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      2  \n",
       "...                                                 ...    ...  ...    ...  \n",
       "5738  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      0  \n",
       "5739  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      4  \n",
       "5740  D:\\Deep_Learning\\WasteNet\\dataset\\sequence1\\00...  False    1      7  \n",
       "5743  D:\\Deep_Learning\\WasteNet\\dataset\\sequence2\\00...  False    1      3  \n",
       "5744  D:\\Deep_Learning\\WasteNet\\dataset\\sequence2\\00...  False    1      3  \n",
       "\n",
       "[4695 rows x 6 columns]"
      ]
     },
     "execution_count": 53,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tmp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "8f31dfd6-4ee6-4266-8128-9fc91bae268c",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "      <th>2</th>\n",
       "      <th>3</th>\n",
       "      <th>seq</th>\n",
       "      <th>split</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26281</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26282</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26283</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26284</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence9\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26285</th>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence9\\00...</td>\n",
       "      <td>D:\\Deep_Learning\\WasteNet\\dataset\\sequence9\\00...</td>\n",
       "      <td>False</td>\n",
       "      <td>8</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>24029 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                       0  \\\n",
       "0      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "1      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "5      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "6      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "7      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "...                                                  ...   \n",
       "26281  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26282  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26283  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26284  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26285  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "\n",
       "                                                       1  \\\n",
       "0      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "1      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "5      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "6      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "7      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...   \n",
       "...                                                  ...   \n",
       "26281  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26282  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26283  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26284  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...   \n",
       "26285  D:\\Deep_Learning\\WasteNet\\dataset\\sequence9\\00...   \n",
       "\n",
       "                                                       2      3  seq  split  \n",
       "0      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...  False    0      9  \n",
       "1      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...  False    0      4  \n",
       "5      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...  False    0      7  \n",
       "6      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...  False    0      9  \n",
       "7      D:\\Deep_Learning\\WasteNet\\dataset\\sequence0\\00...  False    0      5  \n",
       "...                                                  ...    ...  ...    ...  \n",
       "26281  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...  False    8      9  \n",
       "26282  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...  False    8      3  \n",
       "26283  D:\\Deep_Learning\\WasteNet\\dataset\\sequence8\\00...  False    8      2  \n",
       "26284  D:\\Deep_Learning\\WasteNet\\dataset\\sequence9\\00...  False    8      6  \n",
       "26285  D:\\Deep_Learning\\WasteNet\\dataset\\sequence9\\00...  False    8      5  \n",
       "\n",
       "[24029 rows x 6 columns]"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "out_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 64,
   "id": "dc50ec1e-40f6-4251-b6f6-654614168942",
   "metadata": {},
   "outputs": [],
   "source": [
    "out_df.drop(\"seq\", axis=1).to_csv(\"../input/bagging/incorrects.csv\", header=None, index=False)"
   ]
<<<<<<< HEAD
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0fcff95b-80b3-4bb9-abc6-850e6e614962",
   "metadata": {},
   "outputs": [],
   "source": []
=======
>>>>>>> with_ssh
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}