build_database_from_pickle_dir.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "d1d310f1",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.728078Z",
     "start_time": "2021-07-21T08:16:45.705079Z"
    }
   },
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import pickle\n",
    "from datetime import datetime"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "29191577",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.743077Z",
     "start_time": "2021-07-21T08:16:45.732080Z"
    },
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "all_files = os.listdir('saved_superpoints/pickle/test_realdata')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "6cc922e8",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.773108Z",
     "start_time": "2021-07-21T08:16:45.748079Z"
    }
   },
   "outputs": [],
   "source": [
    "all_abs_path = []\n",
    "for path, folders, files in os.walk('saved_superpoints/pickle/test_realdata'):\n",
    "    for file in files:\n",
    "        all_abs_path.append(os.path.abspath(os.path.join(path,file)).replace(os.sep,'/'))\n",
    "    # print(path, folder, file, '\\n')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "4d67aaa6",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.821077Z",
     "start_time": "2021-07-21T08:16:45.775078Z"
    }
   },
   "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>file_name</th>\n",
       "      <th>abspath</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1020.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1080.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1140.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>120.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1200.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1260.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1320.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1380.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1440.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1500.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1560.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1620.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1680.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1740.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>180.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1800.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1860.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1920.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1980.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2040.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2100.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2160.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2220.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2280.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2340.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>240.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2400.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2460.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2520.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2580.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2640.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2700.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2760.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2820.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2880.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2940.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>300.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>3000.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>3060.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>360.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>420.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>480.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>540.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>60.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>600.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>660.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>720.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>780.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>840.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>900.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>960.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      file_name                                            abspath\n",
       "0      0.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "1   1020.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "2   1080.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "3   1140.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "4    120.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "5   1200.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "6   1260.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "7   1320.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "8   1380.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "9   1440.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "10  1500.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "11  1560.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "12  1620.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "13  1680.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "14  1740.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "15   180.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "16  1800.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "17  1860.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "18  1920.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "19  1980.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "20  2040.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "21  2100.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "22  2160.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "23  2220.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "24  2280.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "25  2340.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "26   240.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "27  2400.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "28  2460.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "29  2520.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "30  2580.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "31  2640.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "32  2700.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "33  2760.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "34  2820.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "35  2880.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "36  2940.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "37   300.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "38  3000.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "39  3060.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "40   360.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "41   420.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "42   480.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "43   540.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "44    60.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "45   600.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "46   660.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "47   720.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "48   780.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "49   840.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "50   900.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...\n",
       "51   960.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup..."
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame({'file_name':all_files, 'abspath':all_abs_path})\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "31a59111",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.836077Z",
     "start_time": "2021-07-21T08:16:45.824079Z"
    }
   },
   "outputs": [],
   "source": [
    "df['location'] = range(1, len(df)+1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "f277cdc5",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.851075Z",
     "start_time": "2021-07-21T08:16:45.840081Z"
    }
   },
   "outputs": [],
   "source": [
    "df['date_taken'] = datetime.now().strftime('%m/%d/%Y')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "d65486f8",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.882078Z",
     "start_time": "2021-07-21T08:16:45.852079Z"
    },
    "scrolled": true
   },
   "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>file_name</th>\n",
       "      <th>abspath</th>\n",
       "      <th>location</th>\n",
       "      <th>date_taken</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>1</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1020.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>2</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1080.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>3</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1140.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>4</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>120.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>5</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1200.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>6</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1260.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>7</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1320.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>8</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1380.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>9</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1440.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>10</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1500.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>11</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1560.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>12</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1620.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>13</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1680.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>14</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1740.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>15</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>180.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>16</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1800.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>17</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1860.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>18</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1920.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>19</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1980.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>20</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2040.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>21</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2100.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>22</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2160.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>23</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2220.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>24</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2280.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>25</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2340.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>26</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>240.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>27</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2400.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>28</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2460.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>29</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2520.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>30</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2580.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>31</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2640.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>32</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>2700.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>33</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>2760.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>34</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>2820.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>35</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>2880.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>36</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>2940.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>37</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>300.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>38</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>3000.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>39</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>3060.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>40</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>360.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>41</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>420.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>42</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>480.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>43</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>540.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>44</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>60.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>45</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>600.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>46</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>660.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>47</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>720.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>48</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>780.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>49</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>840.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>50</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>900.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>51</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>960.pickle</td>\n",
       "      <td>C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...</td>\n",
       "      <td>52</td>\n",
       "      <td>07/21/2021</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "      file_name                                            abspath  location  \\\n",
       "0      0.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         1   \n",
       "1   1020.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         2   \n",
       "2   1080.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         3   \n",
       "3   1140.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         4   \n",
       "4    120.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         5   \n",
       "5   1200.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         6   \n",
       "6   1260.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         7   \n",
       "7   1320.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         8   \n",
       "8   1380.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...         9   \n",
       "9   1440.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        10   \n",
       "10  1500.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        11   \n",
       "11  1560.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        12   \n",
       "12  1620.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        13   \n",
       "13  1680.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        14   \n",
       "14  1740.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        15   \n",
       "15   180.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        16   \n",
       "16  1800.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        17   \n",
       "17  1860.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        18   \n",
       "18  1920.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        19   \n",
       "19  1980.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        20   \n",
       "20  2040.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        21   \n",
       "21  2100.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        22   \n",
       "22  2160.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        23   \n",
       "23  2220.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        24   \n",
       "24  2280.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        25   \n",
       "25  2340.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        26   \n",
       "26   240.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        27   \n",
       "27  2400.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        28   \n",
       "28  2460.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        29   \n",
       "29  2520.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        30   \n",
       "30  2580.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        31   \n",
       "31  2640.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        32   \n",
       "32  2700.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        33   \n",
       "33  2760.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        34   \n",
       "34  2820.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        35   \n",
       "35  2880.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        36   \n",
       "36  2940.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        37   \n",
       "37   300.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        38   \n",
       "38  3000.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        39   \n",
       "39  3060.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        40   \n",
       "40   360.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        41   \n",
       "41   420.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        42   \n",
       "42   480.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        43   \n",
       "43   540.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        44   \n",
       "44    60.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        45   \n",
       "45   600.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        46   \n",
       "46   660.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        47   \n",
       "47   720.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        48   \n",
       "48   780.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        49   \n",
       "49   840.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        50   \n",
       "50   900.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        51   \n",
       "51   960.pickle  C:/Users/Admin/SuperGlue (Obodroid Intern)/Sup...        52   \n",
       "\n",
       "    date_taken  \n",
       "0   07/21/2021  \n",
       "1   07/21/2021  \n",
       "2   07/21/2021  \n",
       "3   07/21/2021  \n",
       "4   07/21/2021  \n",
       "5   07/21/2021  \n",
       "6   07/21/2021  \n",
       "7   07/21/2021  \n",
       "8   07/21/2021  \n",
       "9   07/21/2021  \n",
       "10  07/21/2021  \n",
       "11  07/21/2021  \n",
       "12  07/21/2021  \n",
       "13  07/21/2021  \n",
       "14  07/21/2021  \n",
       "15  07/21/2021  \n",
       "16  07/21/2021  \n",
       "17  07/21/2021  \n",
       "18  07/21/2021  \n",
       "19  07/21/2021  \n",
       "20  07/21/2021  \n",
       "21  07/21/2021  \n",
       "22  07/21/2021  \n",
       "23  07/21/2021  \n",
       "24  07/21/2021  \n",
       "25  07/21/2021  \n",
       "26  07/21/2021  \n",
       "27  07/21/2021  \n",
       "28  07/21/2021  \n",
       "29  07/21/2021  \n",
       "30  07/21/2021  \n",
       "31  07/21/2021  \n",
       "32  07/21/2021  \n",
       "33  07/21/2021  \n",
       "34  07/21/2021  \n",
       "35  07/21/2021  \n",
       "36  07/21/2021  \n",
       "37  07/21/2021  \n",
       "38  07/21/2021  \n",
       "39  07/21/2021  \n",
       "40  07/21/2021  \n",
       "41  07/21/2021  \n",
       "42  07/21/2021  \n",
       "43  07/21/2021  \n",
       "44  07/21/2021  \n",
       "45  07/21/2021  \n",
       "46  07/21/2021  \n",
       "47  07/21/2021  \n",
       "48  07/21/2021  \n",
       "49  07/21/2021  \n",
       "50  07/21/2021  \n",
       "51  07/21/2021  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "d0a8f081",
   "metadata": {
    "ExecuteTime": {
     "end_time": "2021-07-21T08:16:45.897077Z",
     "start_time": "2021-07-21T08:16:45.884078Z"
    }
   },
   "outputs": [],
   "source": [
    "df.to_csv('superpoints_database.csv', index=True)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "fastai-torch",
   "language": "python",
   "name": "fastai-torch"
  },
  "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.9.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}