INCLab-absentGlobalId.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "fc282382",
   "metadata": {},
   "source": [
    "# After interpolate then delete absent number in certain frameNum\n",
    "\n",
    "0709 : **11415** 번 frame 부터 2 번 입장\n",
    "\n",
    "0604 : **21120~25179** frame동안 10번 없었음\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "84986d89",
   "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>Unnamed: 0</th>\n",
       "      <th>frameNum</th>\n",
       "      <th>1_X</th>\n",
       "      <th>1_Y</th>\n",
       "      <th>2_X</th>\n",
       "      <th>2_Y</th>\n",
       "      <th>3_X</th>\n",
       "      <th>3_Y</th>\n",
       "      <th>4_X</th>\n",
       "      <th>4_Y</th>\n",
       "      <th>...</th>\n",
       "      <th>nc7</th>\n",
       "      <th>nc8</th>\n",
       "      <th>nc9</th>\n",
       "      <th>nc10</th>\n",
       "      <th>nc11</th>\n",
       "      <th>nc12</th>\n",
       "      <th>nc13</th>\n",
       "      <th>nc14</th>\n",
       "      <th>nc15</th>\n",
       "      <th>nc16</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>821.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>718.0</td>\n",
       "      <td>300.0</td>\n",
       "      <td>682.0</td>\n",
       "      <td>628.0</td>\n",
       "      <td>685.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>821.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>711.0</td>\n",
       "      <td>303.0</td>\n",
       "      <td>680.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>685.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>821.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>714.0</td>\n",
       "      <td>302.0</td>\n",
       "      <td>681.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>685.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>821.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>717.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>681.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>685.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>821.0</td>\n",
       "      <td>259.0</td>\n",
       "      <td>713.0</td>\n",
       "      <td>301.0</td>\n",
       "      <td>681.0</td>\n",
       "      <td>630.0</td>\n",
       "      <td>685.0</td>\n",
       "      <td>700.0</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</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",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47859</th>\n",
       "      <td>47859</td>\n",
       "      <td>47860</td>\n",
       "      <td>1114.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>669.0</td>\n",
       "      <td>717.0</td>\n",
       "      <td>1113.0</td>\n",
       "      <td>274.0</td>\n",
       "      <td>1056.0</td>\n",
       "      <td>819.0</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47860</th>\n",
       "      <td>47860</td>\n",
       "      <td>47861</td>\n",
       "      <td>1114.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>666.0</td>\n",
       "      <td>718.0</td>\n",
       "      <td>1113.0</td>\n",
       "      <td>274.0</td>\n",
       "      <td>1056.0</td>\n",
       "      <td>818.0</td>\n",
       "      <td>...</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47861</th>\n",
       "      <td>47861</td>\n",
       "      <td>47862</td>\n",
       "      <td>1114.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>667.0</td>\n",
       "      <td>718.0</td>\n",
       "      <td>1113.0</td>\n",
       "      <td>274.0</td>\n",
       "      <td>1054.0</td>\n",
       "      <td>819.0</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47862</th>\n",
       "      <td>47862</td>\n",
       "      <td>47863</td>\n",
       "      <td>1114.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>669.0</td>\n",
       "      <td>717.0</td>\n",
       "      <td>1113.0</td>\n",
       "      <td>274.0</td>\n",
       "      <td>1054.0</td>\n",
       "      <td>819.0</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47863</th>\n",
       "      <td>47863</td>\n",
       "      <td>47864</td>\n",
       "      <td>1114.0</td>\n",
       "      <td>276.0</td>\n",
       "      <td>666.0</td>\n",
       "      <td>718.0</td>\n",
       "      <td>1113.0</td>\n",
       "      <td>274.0</td>\n",
       "      <td>1055.0</td>\n",
       "      <td>817.0</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>47864 rows × 50 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0  frameNum     1_X    1_Y    2_X    2_Y     3_X    3_Y  \\\n",
       "0               0         1   821.0  259.0  718.0  300.0   682.0  628.0   \n",
       "1               1         2   821.0  259.0  711.0  303.0   680.0  630.0   \n",
       "2               2         3   821.0  259.0  714.0  302.0   681.0  630.0   \n",
       "3               3         4   821.0  259.0  717.0  301.0   681.0  630.0   \n",
       "4               4         5   821.0  259.0  713.0  301.0   681.0  630.0   \n",
       "...           ...       ...     ...    ...    ...    ...     ...    ...   \n",
       "47859       47859     47860  1114.0  276.0  669.0  717.0  1113.0  274.0   \n",
       "47860       47860     47861  1114.0  276.0  666.0  718.0  1113.0  274.0   \n",
       "47861       47861     47862  1114.0  276.0  667.0  718.0  1113.0  274.0   \n",
       "47862       47862     47863  1114.0  276.0  669.0  717.0  1113.0  274.0   \n",
       "47863       47863     47864  1114.0  276.0  666.0  718.0  1113.0  274.0   \n",
       "\n",
       "          4_X    4_Y  ...    nc7    nc8    nc9   nc10   nc11   nc12   nc13  \\\n",
       "0       685.0  700.0  ...  False  False  False  False  False  False  False   \n",
       "1       685.0  700.0  ...  False  False  False  False  False  False  False   \n",
       "2       685.0  700.0  ...  False  False  False  False  False  False  False   \n",
       "3       685.0  700.0  ...  False  False  False  False  False  False  False   \n",
       "4       685.0  700.0  ...  False  False  False  False  False  False  False   \n",
       "...       ...    ...  ...    ...    ...    ...    ...    ...    ...    ...   \n",
       "47859  1056.0  819.0  ...  False   True  False  False   True  False  False   \n",
       "47860  1056.0  818.0  ...  False   True  False  False   True  False  False   \n",
       "47861  1054.0  819.0  ...   True   True  False  False   True  False  False   \n",
       "47862  1054.0  819.0  ...   True   True  False  False   True  False  False   \n",
       "47863  1055.0  817.0  ...   True   True  False  False   True  False  False   \n",
       "\n",
       "        nc14  nc15  nc16  \n",
       "0      False  True  True  \n",
       "1      False  True  True  \n",
       "2      False  True  True  \n",
       "3      False  True  True  \n",
       "4      False  True  True  \n",
       "...      ...   ...   ...  \n",
       "47859  False  True  True  \n",
       "47860  False  True  True  \n",
       "47861  False  True  True  \n",
       "47862  False  True  True  \n",
       "47863  False  True  True  \n",
       "\n",
       "[47864 rows x 50 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "df= pd.read_csv(\"Result-0604-Fin.csv\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "cd338982",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\82108\\AppData\\Local\\Temp/ipykernel_22356/1907091259.py:7: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\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",
      "  df[\"10_X\"][index] = np.nan\n",
      "C:\\Users\\82108\\AppData\\Local\\Temp/ipykernel_22356/1907091259.py:8: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\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",
      "  df[\"10_Y\"][index] = np.nan\n",
      "C:\\Users\\82108\\AppData\\Local\\Temp/ipykernel_22356/1907091259.py:11: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\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",
      "  df[\"2_X\"][0] = np.nan\n",
      "C:\\Users\\82108\\AppData\\Local\\Temp/ipykernel_22356/1907091259.py:12: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame\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",
      "  df[\"2_Y\"][0] = np.nan\n"
     ]
    }
   ],
   "source": [
    "start_frame=21120\n",
    "end_frame= 25179\n",
    "\n",
    "for index in df.frameNum:\n",
    "    if index>=start_frame and index <= end_frame:\n",
    "        df[\"10_X\"][index] = np.nan\n",
    "        df[\"10_Y\"][index] = np.nan\n",
    "\n",
    "df.to_csv(\"Result_0604_#10_21120_25179.csv\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.4"
  },
  "vscode": {
   "interpreter": {
    "hash": "c5c2c3c852cea3612ae75d7177c7db88d742ce4c76218675a91b833287f5ecf2"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}