{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "2d67457f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "   id wafer_id               batch_id            scan_time status  \\\n",
      "0   1  wafer_0  BATCH_20260317_201406  2026-02-15 20:14:17   FAIL   \n",
      "1   2  wafer_1  BATCH_20260317_201406  2026-02-15 20:14:57   FAIL   \n",
      "2   3  wafer_2  BATCH_20260317_201406  2026-02-15 20:14:59   FAIL   \n",
      "3   4  wafer_3  BATCH_20260317_201406  2026-02-15 20:14:21   FAIL   \n",
      "4   5  wafer_4  BATCH_20260317_201406  2026-02-15 20:14:36   FAIL   \n",
      "\n",
      "             ground_truth defect_type               action  confidence  \\\n",
      "0  Center+Edge-Loc+Random   Edge-Ring  MOVE_TO_MICRO_STAGE        0.90   \n",
      "1  Center+Edge-Loc+Random      Center       ROUTE_TO_SCRAP        0.96   \n",
      "2  Center+Edge-Loc+Random      Center       ROUTE_TO_SCRAP        0.88   \n",
      "3  Center+Edge-Loc+Random   Edge-Ring  MOVE_TO_MICRO_STAGE        0.91   \n",
      "4  Center+Edge-Loc+Random      Center       ROUTE_TO_SCRAP        0.85   \n",
      "\n",
      "  roi_coordinates  defect_area_px  material_wasted_pct  \n",
      "0  [1, 0, 51, 50]            2500                92.46  \n",
      "1  [1, 0, 51, 50]            2500                92.46  \n",
      "2  [1, 0, 51, 50]            2500                92.46  \n",
      "3  [1, 0, 51, 50]            2500                92.46  \n",
      "4  [1, 0, 52, 51]            2601                96.19  \n"
     ]
    }
   ],
   "source": [
    "import pandas as pd\n",
    "import sqlite3\n",
    "\n",
    "# 1. Connect to the database file\n",
    "conn = sqlite3.connect('/Users/udayan/CHITS_PR_1/middleware/wafer_control.db')\n",
    "\n",
    "# 2. Write a query to select the data you want\n",
    "query = \"SELECT * FROM wafer_logs\"\n",
    "\n",
    "# 3. Load the data into a DataFrame\n",
    "df = pd.read_sql_query(query, conn)\n",
    "\n",
    "# 4. Close the connection\n",
    "conn.close()\n",
    "\n",
    "# View the first few rows\n",
    "print(df.head())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "b287cad1",
   "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>id</th>\n",
       "      <th>wafer_id</th>\n",
       "      <th>batch_id</th>\n",
       "      <th>scan_time</th>\n",
       "      <th>status</th>\n",
       "      <th>defect_type</th>\n",
       "      <th>action</th>\n",
       "      <th>confidence</th>\n",
       "      <th>roi_coordinates</th>\n",
       "      <th>defect_area_px</th>\n",
       "      <th>material_wasted_pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>wafer_100574</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-02-15 02:15:48</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Edge-Ring</td>\n",
       "      <td>MOVE_TO_MICRO_STAGE</td>\n",
       "      <td>0.95</td>\n",
       "      <td>[1, 0, 115, 136]</td>\n",
       "      <td>15504</td>\n",
       "      <td>97.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>wafer_101787</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-02-15 02:15:09</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Center</td>\n",
       "      <td>ROUTE_TO_SCRAP</td>\n",
       "      <td>0.96</td>\n",
       "      <td>[0, 0, 43, 43]</td>\n",
       "      <td>1849</td>\n",
       "      <td>95.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>wafer_103333</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-02-15 02:14:59</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Edge-Ring</td>\n",
       "      <td>MOVE_TO_MICRO_STAGE</td>\n",
       "      <td>0.98</td>\n",
       "      <td>[0, 0, 43, 43]</td>\n",
       "      <td>1849</td>\n",
       "      <td>95.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>wafer_106281</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-02-15 02:15:19</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Loc</td>\n",
       "      <td>MOVE_TO_MICRO_STAGE</td>\n",
       "      <td>0.60</td>\n",
       "      <td>[0, 0, 30, 34]</td>\n",
       "      <td>1020</td>\n",
       "      <td>94.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>wafer_106301</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-02-15 02:15:19</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Loc</td>\n",
       "      <td>MOVE_TO_MICRO_STAGE</td>\n",
       "      <td>0.96</td>\n",
       "      <td>[0, 0, 29, 33]</td>\n",
       "      <td>957</td>\n",
       "      <td>88.20</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5099</th>\n",
       "      <td>5100</td>\n",
       "      <td>wafer_95994</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-03-16 02:15:15</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Center</td>\n",
       "      <td>ROUTE_TO_SCRAP</td>\n",
       "      <td>0.96</td>\n",
       "      <td>[0, 0, 60, 40]</td>\n",
       "      <td>2400</td>\n",
       "      <td>93.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5100</th>\n",
       "      <td>5101</td>\n",
       "      <td>wafer_96083</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-03-17 02:15:17</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Center</td>\n",
       "      <td>ROUTE_TO_SCRAP</td>\n",
       "      <td>0.96</td>\n",
       "      <td>[0, 0, 60, 40]</td>\n",
       "      <td>2400</td>\n",
       "      <td>93.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5101</th>\n",
       "      <td>5102</td>\n",
       "      <td>wafer_9637</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-03-17 02:14:52</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Edge-Loc</td>\n",
       "      <td>MOVE_TO_MICRO_STAGE</td>\n",
       "      <td>0.98</td>\n",
       "      <td>[0, 0, 28, 31]</td>\n",
       "      <td>868</td>\n",
       "      <td>90.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5102</th>\n",
       "      <td>5103</td>\n",
       "      <td>wafer_96594</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-03-17 02:15:22</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Loc</td>\n",
       "      <td>MOVE_TO_MICRO_STAGE</td>\n",
       "      <td>0.81</td>\n",
       "      <td>[0, 0, 30, 29]</td>\n",
       "      <td>870</td>\n",
       "      <td>90.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5103</th>\n",
       "      <td>5104</td>\n",
       "      <td>wafer_983</td>\n",
       "      <td>BATCH_20260317_021451</td>\n",
       "      <td>2026-03-17 02:15:00</td>\n",
       "      <td>FAIL</td>\n",
       "      <td>Edge-Loc</td>\n",
       "      <td>MOVE_TO_MICRO_STAGE</td>\n",
       "      <td>0.69</td>\n",
       "      <td>[0, 0, 25, 25]</td>\n",
       "      <td>625</td>\n",
       "      <td>92.46</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5104 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        id      wafer_id               batch_id            scan_time status  \\\n",
       "0        1  wafer_100574  BATCH_20260317_021451  2026-02-15 02:15:48   FAIL   \n",
       "1        2  wafer_101787  BATCH_20260317_021451  2026-02-15 02:15:09   FAIL   \n",
       "2        3  wafer_103333  BATCH_20260317_021451  2026-02-15 02:14:59   FAIL   \n",
       "3        4  wafer_106281  BATCH_20260317_021451  2026-02-15 02:15:19   FAIL   \n",
       "4        5  wafer_106301  BATCH_20260317_021451  2026-02-15 02:15:19   FAIL   \n",
       "...    ...           ...                    ...                  ...    ...   \n",
       "5099  5100   wafer_95994  BATCH_20260317_021451  2026-03-16 02:15:15   FAIL   \n",
       "5100  5101   wafer_96083  BATCH_20260317_021451  2026-03-17 02:15:17   FAIL   \n",
       "5101  5102    wafer_9637  BATCH_20260317_021451  2026-03-17 02:14:52   FAIL   \n",
       "5102  5103   wafer_96594  BATCH_20260317_021451  2026-03-17 02:15:22   FAIL   \n",
       "5103  5104     wafer_983  BATCH_20260317_021451  2026-03-17 02:15:00   FAIL   \n",
       "\n",
       "     defect_type               action  confidence   roi_coordinates  \\\n",
       "0      Edge-Ring  MOVE_TO_MICRO_STAGE        0.95  [1, 0, 115, 136]   \n",
       "1         Center       ROUTE_TO_SCRAP        0.96    [0, 0, 43, 43]   \n",
       "2      Edge-Ring  MOVE_TO_MICRO_STAGE        0.98    [0, 0, 43, 43]   \n",
       "3            Loc  MOVE_TO_MICRO_STAGE        0.60    [0, 0, 30, 34]   \n",
       "4            Loc  MOVE_TO_MICRO_STAGE        0.96    [0, 0, 29, 33]   \n",
       "...          ...                  ...         ...               ...   \n",
       "5099      Center       ROUTE_TO_SCRAP        0.96    [0, 0, 60, 40]   \n",
       "5100      Center       ROUTE_TO_SCRAP        0.96    [0, 0, 60, 40]   \n",
       "5101    Edge-Loc  MOVE_TO_MICRO_STAGE        0.98    [0, 0, 28, 31]   \n",
       "5102         Loc  MOVE_TO_MICRO_STAGE        0.81    [0, 0, 30, 29]   \n",
       "5103    Edge-Loc  MOVE_TO_MICRO_STAGE        0.69    [0, 0, 25, 25]   \n",
       "\n",
       "      defect_area_px  material_wasted_pct  \n",
       "0              15504                97.56  \n",
       "1               1849                95.51  \n",
       "2               1849                95.51  \n",
       "3               1020                94.01  \n",
       "4                957                88.20  \n",
       "...              ...                  ...  \n",
       "5099            2400                93.68  \n",
       "5100            2400                93.68  \n",
       "5101             868                90.70  \n",
       "5102             870                90.53  \n",
       "5103             625                92.46  \n",
       "\n",
       "[5104 rows x 11 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "299c2be8",
   "metadata": {},
   "outputs": [],
   "source": [
    "pass_wafers = df[df['status'] == 'PASS']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "46fbb2d3",
   "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>id</th>\n",
       "      <th>wafer_id</th>\n",
       "      <th>batch_id</th>\n",
       "      <th>scan_time</th>\n",
       "      <th>status</th>\n",
       "      <th>ground_truth</th>\n",
       "      <th>defect_type</th>\n",
       "      <th>action</th>\n",
       "      <th>confidence</th>\n",
       "      <th>roi_coordinates</th>\n",
       "      <th>defect_area_px</th>\n",
       "      <th>material_wasted_pct</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>33866</th>\n",
       "      <td>33867</td>\n",
       "      <td>wafer_33866</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-13 20:14:29</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33867</th>\n",
       "      <td>33868</td>\n",
       "      <td>wafer_33867</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-13 20:14:08</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33868</th>\n",
       "      <td>33869</td>\n",
       "      <td>wafer_33868</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-13 20:14:08</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33869</th>\n",
       "      <td>33870</td>\n",
       "      <td>wafer_33869</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-13 20:14:29</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33870</th>\n",
       "      <td>33871</td>\n",
       "      <td>wafer_33870</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-13 20:14:31</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823948</th>\n",
       "      <td>823949</td>\n",
       "      <td>wm811k_811442</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-16 20:14:06</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823949</th>\n",
       "      <td>823950</td>\n",
       "      <td>wm811k_811445</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-16 20:14:07</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823950</th>\n",
       "      <td>823951</td>\n",
       "      <td>wm811k_811449</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-16 20:14:07</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823951</th>\n",
       "      <td>823952</td>\n",
       "      <td>wm811k_811455</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-16 20:14:07</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>823952</th>\n",
       "      <td>823953</td>\n",
       "      <td>wm811k_811456</td>\n",
       "      <td>BATCH_20260317_201406</td>\n",
       "      <td>2026-03-16 20:14:09</td>\n",
       "      <td>PASS</td>\n",
       "      <td>Normal</td>\n",
       "      <td>None</td>\n",
       "      <td>ROUTE_TO_ASSEMBLY</td>\n",
       "      <td>1.0</td>\n",
       "      <td>[]</td>\n",
       "      <td>0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>786938 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            id       wafer_id               batch_id            scan_time  \\\n",
       "33866    33867    wafer_33866  BATCH_20260317_201406  2026-03-13 20:14:29   \n",
       "33867    33868    wafer_33867  BATCH_20260317_201406  2026-03-13 20:14:08   \n",
       "33868    33869    wafer_33868  BATCH_20260317_201406  2026-03-13 20:14:08   \n",
       "33869    33870    wafer_33869  BATCH_20260317_201406  2026-03-13 20:14:29   \n",
       "33870    33871    wafer_33870  BATCH_20260317_201406  2026-03-13 20:14:31   \n",
       "...        ...            ...                    ...                  ...   \n",
       "823948  823949  wm811k_811442  BATCH_20260317_201406  2026-03-16 20:14:06   \n",
       "823949  823950  wm811k_811445  BATCH_20260317_201406  2026-03-16 20:14:07   \n",
       "823950  823951  wm811k_811449  BATCH_20260317_201406  2026-03-16 20:14:07   \n",
       "823951  823952  wm811k_811455  BATCH_20260317_201406  2026-03-16 20:14:07   \n",
       "823952  823953  wm811k_811456  BATCH_20260317_201406  2026-03-16 20:14:09   \n",
       "\n",
       "       status ground_truth defect_type             action  confidence  \\\n",
       "33866    PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "33867    PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "33868    PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "33869    PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "33870    PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "...       ...          ...         ...                ...         ...   \n",
       "823948   PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "823949   PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "823950   PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "823951   PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "823952   PASS       Normal        None  ROUTE_TO_ASSEMBLY         1.0   \n",
       "\n",
       "       roi_coordinates  defect_area_px  material_wasted_pct  \n",
       "33866               []               0                  0.0  \n",
       "33867               []               0                  0.0  \n",
       "33868               []               0                  0.0  \n",
       "33869               []               0                  0.0  \n",
       "33870               []               0                  0.0  \n",
       "...                ...             ...                  ...  \n",
       "823948              []               0                  0.0  \n",
       "823949              []               0                  0.0  \n",
       "823950              []               0                  0.0  \n",
       "823951              []               0                  0.0  \n",
       "823952              []               0                  0.0  \n",
       "\n",
       "[786938 rows x 12 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pass_wafers"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "venv",
   "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.13.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}