{
"cells": [
{
"cell_type": "code",
"execution_count": 1,
"id": "6b9d9ddb-8cf4-4c9c-bdc0-0de78f0ec35d",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"#pip install km3dia"
]
},
{
"cell_type": "code",
"execution_count": 2,
"id": "4d699873-c366-4870-a262-56b4c1312855",
"metadata": {},
"outputs": [],
"source": [
"#pip install xmltodict"
]
},
{
"cell_type": "code",
"execution_count": 3,
"id": "9034b755-3525-4a06-bbd5-59fe2a1ce3d3",
"metadata": {},
"outputs": [],
"source": [
"import pandas as pd\n",
"import numpy as np\n",
"import matplotlib.pyplot as plt\n",
"import xmltodict\n",
"\n",
"import km3db\n",
"import km3dia"
]
},
{
"cell_type": "code",
"execution_count": 4,
"id": "d9bf120b-39cc-4adc-8c2f-ecb425d7cd18",
"metadata": {},
"outputs": [],
"source": [
"dia = km3dia.DBManager(container='pd')\n",
"DOMInt = km3dia.DOMIntegrationSummary()"
]
},
{
"cell_type": "code",
"execution_count": 94,
"id": "1959e023-8415-465c-90a2-7da4b9c3a93b",
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/1.909</th>\n",
" <td>909</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>2</td>\n",
" <td>1.273</td>\n",
" <td>1.491</td>\n",
" <td>1.364</td>\n",
" <td>1.102</td>\n",
" <td>1.654</td>\n",
" <td>1.623</td>\n",
" <td>1.732</td>\n",
" <td>1.285</td>\n",
" <td>1.403</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete Registered \\\n",
"UPI \n",
"3.4/TSFP/1.909 909 3.4 TSFP 1 1 14 1 0 \n",
"\n",
" NotConform Repair ... Gain 21 Gain 22 Gain 23 Gain 24 Gain 25 \\\n",
"UPI ... \n",
"3.4/TSFP/1.909 0 0 ... 2 1.273 1.491 1.364 1.102 \n",
"\n",
" Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/1.909 1.654 1.623 1.732 1.285 1.403 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"#Get measurement results\n",
"df_tests = DOMInt.test_results\n",
"df_tests = df_tests.reset_index().set_index('UPI')\n",
"\n",
"# display( df_tests[ df_tests[\"SiteID\"] == \"1\" ] )\n",
"# display( df_tests[\"SiteID\"] )\n",
"# display( df_tests )\n",
"display( df_tests[ df_tests[\"SERIAL\"] == \"909\" ] )\n"
]
},
{
"cell_type": "code",
"execution_count": 76,
"id": "8ba41596-7e7a-4925-80f9-98c697e705f4",
"metadata": {},
"outputs": [],
"source": [
"# Generate the list of relevant keys\n",
"gain_keys = [key for key in df_tests.columns if key.lower().find('gain') != -1]\n",
"dc_keys = [key for key in df_tests.columns if key.lower().find('dark') != -1]\n",
"DOM_key = ['SERIAL', 'SiteID']\n",
"pmt_keys = gain_keys + dc_keys"
]
},
{
"cell_type": "code",
"execution_count": 77,
"id": "7f681bc2-bfb5-4232-8983-de877bf2f1d4",
"metadata": {},
"outputs": [],
"source": [
"# Cut the dataframe to no NaN\n",
"df_pmt = df_tests.dropna(subset=pmt_keys)\n",
"df_pmt = df_pmt[pmt_keys + DOM_key]"
]
},
{
"cell_type": "code",
"execution_count": 81,
"id": "5d602ade-f9d6-4303-ab4c-94938eb0660a",
"metadata": {},
"outputs": [],
"source": [
"# Convert pmt results result branches to float\n",
"df_pmt = df_pmt.astype(dict(zip(pmt_keys, [float]*len(pmt_keys))))\n",
"\n",
"# display( df_pmt )\n",
"# display( df_pmt[ df_pmt[\"SiteID\"] == \"1\" ] )"
]
},
{
"cell_type": "code",
"execution_count": 14,
"id": "357eef49-fcb1-4db6-abab-133bbbf7daf1",
"metadata": {
"tags": []
},
"outputs": [],
"source": [
"# df_bad_channels = df_pmt[ df_pmt[\"Gain 22\"] > 1.6 ]\n",
"# # df_bad_channels[ df_bad_channels[\"SiteName\"] ==\"Amsterdam\"]\n",
"# display(df_bad_channels)"
]
},
{
"cell_type": "code",
"execution_count": 109,
"id": "7c303c75-fa66-48f2-a09f-a5bf146538bc",
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 860\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH22C/2.860</th>\n",
" <td>860</td>\n",
" <td>3.4</td>\n",
" <td>CH22C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>27.6</td>\n",
" <td>26.6</td>\n",
" <td>28.4</td>\n",
" <td>28.7</td>\n",
" <td>30.3</td>\n",
" <td>28.7</td>\n",
" <td>32.5</td>\n",
" <td>29.7</td>\n",
" <td>28.9</td>\n",
" <td>26.9</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH22C/2.860 860 3.4 CH22C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH22C/2.860 1 0 0 ... 27.6 26.6 28.4 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH22C/2.860 28.7 30.3 28.7 32.5 29.7 28.9 26.9 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 859\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH24C/2.859</th>\n",
" <td>859</td>\n",
" <td>3.4</td>\n",
" <td>CH24C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.5</td>\n",
" <td>29.8</td>\n",
" <td>29.6</td>\n",
" <td>27.3</td>\n",
" <td>28.7</td>\n",
" <td>30.1</td>\n",
" <td>29.1</td>\n",
" <td>28.8</td>\n",
" <td>27.5</td>\n",
" <td>28</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH24C/2.859 859 3.4 CH24C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH24C/2.859 1 0 0 ... 29.5 29.8 29.6 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH24C/2.859 27.3 28.7 30.1 29.1 28.8 27.5 28 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 858\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH26C/2.858</th>\n",
" <td>858</td>\n",
" <td>3.4</td>\n",
" <td>CH26C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>27.9</td>\n",
" <td>28.9</td>\n",
" <td>27.4</td>\n",
" <td>26.4</td>\n",
" <td>27.9</td>\n",
" <td>29.4</td>\n",
" <td>29.1</td>\n",
" <td>27.9</td>\n",
" <td>28.9</td>\n",
" <td>28.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH26C/2.858 858 3.4 CH26C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH26C/2.858 1 0 0 ... 27.9 28.9 27.4 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH26C/2.858 26.4 27.9 29.4 29.1 27.9 28.9 28.8 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 857\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH28C/2.857</th>\n",
" <td>857</td>\n",
" <td>3.4</td>\n",
" <td>CH28C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>28</td>\n",
" <td>30.8</td>\n",
" <td>27.4</td>\n",
" <td>25.8</td>\n",
" <td>30.1</td>\n",
" <td>29.3</td>\n",
" <td>27.8</td>\n",
" <td>29.3</td>\n",
" <td>27.8</td>\n",
" <td>30.7</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH28C/2.857 857 3.4 CH28C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH28C/2.857 1 0 0 ... 28 30.8 27.4 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH28C/2.857 25.8 30.1 29.3 27.8 29.3 27.8 30.7 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 856\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH30C/2.856</th>\n",
" <td>856</td>\n",
" <td>3.4</td>\n",
" <td>CH30C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>26.6</td>\n",
" <td>29.5</td>\n",
" <td>27.3</td>\n",
" <td>27.9</td>\n",
" <td>30.6</td>\n",
" <td>27.7</td>\n",
" <td>28</td>\n",
" <td>29.6</td>\n",
" <td>28.2</td>\n",
" <td>29.1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH30C/2.856 856 3.4 CH30C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH30C/2.856 1 0 0 ... 26.6 29.5 27.3 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH30C/2.856 27.9 30.6 27.7 28 29.6 28.2 29.1 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 855\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH32C/2.855</th>\n",
" <td>855</td>\n",
" <td>3.4</td>\n",
" <td>CH32C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>26.9</td>\n",
" <td>26.8</td>\n",
" <td>27.9</td>\n",
" <td>26.5</td>\n",
" <td>30.2</td>\n",
" <td>28</td>\n",
" <td>30.2</td>\n",
" <td>28.3</td>\n",
" <td>29.7</td>\n",
" <td>29.1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH32C/2.855 855 3.4 CH32C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH32C/2.855 1 0 0 ... 26.9 26.8 27.9 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH32C/2.855 26.5 30.2 28 30.2 28.3 29.7 29.1 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 854\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH34C/2.854</th>\n",
" <td>854</td>\n",
" <td>3.4</td>\n",
" <td>CH34C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30.2</td>\n",
" <td>29.8</td>\n",
" <td>27.9</td>\n",
" <td>28.7</td>\n",
" <td>28.3</td>\n",
" <td>27.4</td>\n",
" <td>29.7</td>\n",
" <td>28.5</td>\n",
" <td>27.5</td>\n",
" <td>28.2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH34C/2.854 854 3.4 CH34C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH34C/2.854 1 0 0 ... 30.2 29.8 27.9 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH34C/2.854 28.7 28.3 27.4 29.7 28.5 27.5 28.2 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 853\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH36C/2.853</th>\n",
" <td>853</td>\n",
" <td>3.4</td>\n",
" <td>CH36C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>27.9</td>\n",
" <td>28.9</td>\n",
" <td>28.6</td>\n",
" <td>27.5</td>\n",
" <td>27.6</td>\n",
" <td>29.6</td>\n",
" <td>29.2</td>\n",
" <td>29.1</td>\n",
" <td>28.6</td>\n",
" <td>30.1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH36C/2.853 853 3.4 CH36C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH36C/2.853 1 0 0 ... 27.9 28.9 28.6 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH36C/2.853 27.5 27.6 29.6 29.2 29.1 28.6 30.1 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 852\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH38C/2.852</th>\n",
" <td>852</td>\n",
" <td>3.4</td>\n",
" <td>CH38C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30</td>\n",
" <td>27.4</td>\n",
" <td>29</td>\n",
" <td>27.3</td>\n",
" <td>26.7</td>\n",
" <td>31.8</td>\n",
" <td>29.1</td>\n",
" <td>28</td>\n",
" <td>30.2</td>\n",
" <td>27.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH38C/2.852 852 3.4 CH38C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH38C/2.852 1 0 0 ... 30 27.4 29 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH38C/2.852 27.3 26.7 31.8 29.1 28 30.2 27.8 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 851\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH40C/2.851</th>\n",
" <td>851</td>\n",
" <td>3.4</td>\n",
" <td>CH40C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>28.8</td>\n",
" <td>26.8</td>\n",
" <td>27.4</td>\n",
" <td>27</td>\n",
" <td>30.2</td>\n",
" <td>30.6</td>\n",
" <td>28.9</td>\n",
" <td>28.9</td>\n",
" <td>27.6</td>\n",
" <td>29.2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH40C/2.851 851 3.4 CH40C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH40C/2.851 0 0 0 ... 28.8 26.8 27.4 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH40C/2.851 27 30.2 30.6 28.9 28.9 27.6 29.2 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 850\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH42C/2.850</th>\n",
" <td>850</td>\n",
" <td>3.4</td>\n",
" <td>CH42C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29</td>\n",
" <td>26</td>\n",
" <td>28.5</td>\n",
" <td>27.4</td>\n",
" <td>32.2</td>\n",
" <td>30.1</td>\n",
" <td>29.8</td>\n",
" <td>29.9</td>\n",
" <td>29.5</td>\n",
" <td>30.2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH42C/2.850 850 3.4 CH42C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH42C/2.850 1 0 0 ... 29 26 28.5 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH42C/2.850 27.4 32.2 30.1 29.8 29.9 29.5 30.2 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 849\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH44C/2.849</th>\n",
" <td>849</td>\n",
" <td>3.4</td>\n",
" <td>CH44C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>28.3</td>\n",
" <td>30.4</td>\n",
" <td>26.5</td>\n",
" <td>26.7</td>\n",
" <td>26.9</td>\n",
" <td>28.5</td>\n",
" <td>28.5</td>\n",
" <td>28.3</td>\n",
" <td>30.9</td>\n",
" <td>27.5</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH44C/2.849 849 3.4 CH44C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH44C/2.849 1 0 0 ... 28.3 30.4 26.5 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH44C/2.849 26.7 26.9 28.5 28.5 28.3 30.9 27.5 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 848\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH46C/2.848</th>\n",
" <td>848</td>\n",
" <td>3.4</td>\n",
" <td>CH46C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>31.9</td>\n",
" <td>29</td>\n",
" <td>27.7</td>\n",
" <td>28.8</td>\n",
" <td>30</td>\n",
" <td>29</td>\n",
" <td>27.4</td>\n",
" <td>29.7</td>\n",
" <td>28.9</td>\n",
" <td>27.3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH46C/2.848 848 3.4 CH46C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH46C/2.848 1 0 0 ... 31.9 29 27.7 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH46C/2.848 28.8 30 29 27.4 29.7 28.9 27.3 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 847\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH48C/2.847</th>\n",
" <td>847</td>\n",
" <td>3.4</td>\n",
" <td>CH48C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29</td>\n",
" <td>28.8</td>\n",
" <td>27.8</td>\n",
" <td>25</td>\n",
" <td>30.7</td>\n",
" <td>27.5</td>\n",
" <td>31.1</td>\n",
" <td>29.9</td>\n",
" <td>28.7</td>\n",
" <td>28.7</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH48C/2.847 847 3.4 CH48C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH48C/2.847 1 0 0 ... 29 28.8 27.8 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH48C/2.847 25 30.7 27.5 31.1 29.9 28.7 28.7 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 846\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH50C/2.846</th>\n",
" <td>846</td>\n",
" <td>3.4</td>\n",
" <td>CH50C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>32.4</td>\n",
" <td>27.8</td>\n",
" <td>27.7</td>\n",
" <td>27.8</td>\n",
" <td>27.9</td>\n",
" <td>25.3</td>\n",
" <td>27.6</td>\n",
" <td>29.6</td>\n",
" <td>29.5</td>\n",
" <td>29.7</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH50C/2.846 846 3.4 CH50C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH50C/2.846 1 0 0 ... 32.4 27.8 27.7 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH50C/2.846 27.8 27.9 25.3 27.6 29.6 29.5 29.7 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 845\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/CH52C/2.845</th>\n",
" <td>845</td>\n",
" <td>3.4</td>\n",
" <td>CH52C</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.1</td>\n",
" <td>27.7</td>\n",
" <td>28.8</td>\n",
" <td>25.7</td>\n",
" <td>27.9</td>\n",
" <td>31.5</td>\n",
" <td>30</td>\n",
" <td>29.2</td>\n",
" <td>28.5</td>\n",
" <td>29.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/CH52C/2.845 845 3.4 CH52C 2 0 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/CH52C/2.845 1 0 0 ... 29.1 27.7 28.8 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/CH52C/2.845 25.7 27.9 31.5 30 29.2 28.5 29.8 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1015\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1015</th>\n",
" <td>1015</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>28</td>\n",
" <td>29</td>\n",
" <td>26.5</td>\n",
" <td>30.5</td>\n",
" <td>28.8</td>\n",
" <td>30.7</td>\n",
" <td>28.1</td>\n",
" <td>28.9</td>\n",
" <td>27.7</td>\n",
" <td>28.3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1015 1015 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1015 0 0 0 ... 28 29 26.5 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1015 30.5 28.8 30.7 28.1 28.9 27.7 28.3 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1016\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1016</th>\n",
" <td>1016</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30.2</td>\n",
" <td>28</td>\n",
" <td>28.6</td>\n",
" <td>30</td>\n",
" <td>26.6</td>\n",
" <td>27.5</td>\n",
" <td>27.8</td>\n",
" <td>27.9</td>\n",
" <td>32.2</td>\n",
" <td>27.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1016 1016 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1016 0 0 0 ... 30.2 28 28.6 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1016 30 26.6 27.5 27.8 27.9 32.2 27.8 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1017\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1017</th>\n",
" <td>1017</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30.2</td>\n",
" <td>29.6</td>\n",
" <td>29.1</td>\n",
" <td>28.9</td>\n",
" <td>28.7</td>\n",
" <td>24.7</td>\n",
" <td>27.6</td>\n",
" <td>28.5</td>\n",
" <td>28.9</td>\n",
" <td>28.4</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1017 1017 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1017 0 0 0 ... 30.2 29.6 29.1 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1017 28.9 28.7 24.7 27.6 28.5 28.9 28.4 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1018\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1018</th>\n",
" <td>1018</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.3</td>\n",
" <td>28.6</td>\n",
" <td>28.5</td>\n",
" <td>29.2</td>\n",
" <td>28.8</td>\n",
" <td>30.8</td>\n",
" <td>31.7</td>\n",
" <td>29.9</td>\n",
" <td>30.3</td>\n",
" <td>28.6</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1018 1018 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1018 0 0 0 ... 29.3 28.6 28.5 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1018 29.2 28.8 30.8 31.7 29.9 30.3 28.6 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1019\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1019</th>\n",
" <td>1019</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>28.4</td>\n",
" <td>30</td>\n",
" <td>26.4</td>\n",
" <td>30</td>\n",
" <td>29.2</td>\n",
" <td>28.9</td>\n",
" <td>27.6</td>\n",
" <td>30</td>\n",
" <td>28.5</td>\n",
" <td>28.3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1019 1019 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1019 0 0 0 ... 28.4 30 26.4 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1019 30 29.2 28.9 27.6 30 28.5 28.3 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1020\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1020</th>\n",
" <td>1020</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>26.3</td>\n",
" <td>27.8</td>\n",
" <td>29.1</td>\n",
" <td>28.3</td>\n",
" <td>30.5</td>\n",
" <td>29.9</td>\n",
" <td>27.4</td>\n",
" <td>27.8</td>\n",
" <td>29.2</td>\n",
" <td>28.1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1020 1020 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1020 0 0 0 ... 26.3 27.8 29.1 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1020 28.3 30.5 29.9 27.4 27.8 29.2 28.1 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1021\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1021</th>\n",
" <td>1021</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>28.6</td>\n",
" <td>28</td>\n",
" <td>27.9</td>\n",
" <td>27.8</td>\n",
" <td>30.3</td>\n",
" <td>29.7</td>\n",
" <td>28.3</td>\n",
" <td>28.7</td>\n",
" <td>27.4</td>\n",
" <td>29.1</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1021 1021 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1021 0 0 0 ... 28.6 28 27.9 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1021 27.8 30.3 29.7 28.3 28.7 27.4 29.1 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1022\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1022</th>\n",
" <td>1022</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.2</td>\n",
" <td>29.4</td>\n",
" <td>28.6</td>\n",
" <td>28.3</td>\n",
" <td>29.7</td>\n",
" <td>30.8</td>\n",
" <td>30.6</td>\n",
" <td>29</td>\n",
" <td>28.7</td>\n",
" <td>27.9</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1022 1022 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1022 0 0 0 ... 29.2 29.4 28.6 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1022 28.3 29.7 30.8 30.6 29 28.7 27.9 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1023\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1023</th>\n",
" <td>1023</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.8</td>\n",
" <td>29.6</td>\n",
" <td>28.1</td>\n",
" <td>29.3</td>\n",
" <td>29.6</td>\n",
" <td>29.6</td>\n",
" <td>30.4</td>\n",
" <td>29.1</td>\n",
" <td>27.4</td>\n",
" <td>29.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1023 1023 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1023 0 0 0 ... 29.8 29.6 28.1 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1023 29.3 29.6 29.6 30.4 29.1 27.4 29.8 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1024\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1024</th>\n",
" <td>1024</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.5</td>\n",
" <td>26.7</td>\n",
" <td>30</td>\n",
" <td>27.4</td>\n",
" <td>26.7</td>\n",
" <td>28.5</td>\n",
" <td>28</td>\n",
" <td>27.3</td>\n",
" <td>27.9</td>\n",
" <td>27</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1024 1024 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1024 0 0 0 ... 29.5 26.7 30 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1024 27.4 26.7 28.5 28 27.3 27.9 27 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1025\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1025</th>\n",
" <td>1025</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30.4</td>\n",
" <td>27</td>\n",
" <td>28.7</td>\n",
" <td>28.7</td>\n",
" <td>29.4</td>\n",
" <td>25.8</td>\n",
" <td>29.4</td>\n",
" <td>29.1</td>\n",
" <td>30.8</td>\n",
" <td>31.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1025 1025 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1025 0 0 0 ... 30.4 27 28.7 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1025 28.7 29.4 25.8 29.4 29.1 30.8 31.8 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1026\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1026</th>\n",
" <td>1026</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.7</td>\n",
" <td>28.5</td>\n",
" <td>27.9</td>\n",
" <td>29.2</td>\n",
" <td>27.3</td>\n",
" <td>28.1</td>\n",
" <td>31.1</td>\n",
" <td>29.9</td>\n",
" <td>29.2</td>\n",
" <td>29.2</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1026 1026 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1026 0 0 0 ... 29.7 28.5 27.9 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1026 29.2 27.3 28.1 31.1 29.9 29.2 29.2 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1027\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1027</th>\n",
" <td>1027</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>28.1</td>\n",
" <td>29.6</td>\n",
" <td>30</td>\n",
" <td>29</td>\n",
" <td>28.1</td>\n",
" <td>29.6</td>\n",
" <td>27.8</td>\n",
" <td>31</td>\n",
" <td>28.8</td>\n",
" <td>29.5</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1027 1027 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1027 0 0 0 ... 28.1 29.6 30 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1027 29 28.1 29.6 27.8 31 28.8 29.5 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1028\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1028</th>\n",
" <td>1028</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>29.5</td>\n",
" <td>29.5</td>\n",
" <td>27.9</td>\n",
" <td>25.5</td>\n",
" <td>32.2</td>\n",
" <td>26.6</td>\n",
" <td>30.2</td>\n",
" <td>27</td>\n",
" <td>29.9</td>\n",
" <td>25.8</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1028 1028 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1028 0 0 0 ... 29.5 29.5 27.9 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1028 25.5 32.2 26.6 30.2 27 29.9 25.8 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1029\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1029</th>\n",
" <td>1029</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30.7</td>\n",
" <td>30.3</td>\n",
" <td>28.6</td>\n",
" <td>29</td>\n",
" <td>27.6</td>\n",
" <td>28.5</td>\n",
" <td>28.7</td>\n",
" <td>26.6</td>\n",
" <td>29.7</td>\n",
" <td>29.3</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1029 1029 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1029 0 0 0 ... 30.7 30.3 28.6 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1029 29 27.6 28.5 28.7 26.6 29.7 29.3 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1030\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1030</th>\n",
" <td>1030</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>31.1</td>\n",
" <td>31.4</td>\n",
" <td>28.7</td>\n",
" <td>25.7</td>\n",
" <td>28.6</td>\n",
" <td>29.7</td>\n",
" <td>27.6</td>\n",
" <td>29.8</td>\n",
" <td>29.2</td>\n",
" <td>28.4</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1030 1030 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1030 0 0 0 ... 31.1 31.4 28.7 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1030 25.7 28.6 29.7 27.6 29.8 29.2 28.4 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1031\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1031</th>\n",
" <td>1031</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30.6</td>\n",
" <td>28.7</td>\n",
" <td>27.1</td>\n",
" <td>29</td>\n",
" <td>30.3</td>\n",
" <td>30</td>\n",
" <td>29.7</td>\n",
" <td>28.5</td>\n",
" <td>30.7</td>\n",
" <td>27.6</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1031 1031 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1031 0 0 0 ... 30.6 28.7 27.1 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1031 29 30.3 30 29.7 28.5 30.7 27.6 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 1032\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.1032</th>\n",
" <td>1032</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>4</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>30.1</td>\n",
" <td>27.2</td>\n",
" <td>28.6</td>\n",
" <td>29.7</td>\n",
" <td>28.4</td>\n",
" <td>29.4</td>\n",
" <td>30.3</td>\n",
" <td>26.7</td>\n",
" <td>30.5</td>\n",
" <td>27.6</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete \\\n",
"UPI \n",
"3.4/TSFP/2.1032 1032 3.4 TSFP 2 4 14 1 \n",
"\n",
" Registered NotConform Repair ... Gain 21 Gain 22 Gain 23 \\\n",
"UPI ... \n",
"3.4/TSFP/2.1032 0 0 0 ... 30.1 27.2 28.6 \n",
"\n",
" Gain 24 Gain 25 Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.1032 29.7 28.4 29.4 30.3 26.7 30.5 27.6 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"bad dom 844\n"
]
},
{
"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>SERIAL</th>\n",
" <th>PBS</th>\n",
" <th>VARIANT</th>\n",
" <th>VERSION</th>\n",
" <th>SiteID</th>\n",
" <th>PhaseID</th>\n",
" <th>Complete</th>\n",
" <th>Registered</th>\n",
" <th>NotConform</th>\n",
" <th>Repair</th>\n",
" <th>...</th>\n",
" <th>Gain 21</th>\n",
" <th>Gain 22</th>\n",
" <th>Gain 23</th>\n",
" <th>Gain 24</th>\n",
" <th>Gain 25</th>\n",
" <th>Gain 26</th>\n",
" <th>Gain 27</th>\n",
" <th>Gain 28</th>\n",
" <th>Gain 29</th>\n",
" <th>Gain 30</th>\n",
" </tr>\n",
" <tr>\n",
" <th>UPI</th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" <th></th>\n",
" </tr>\n",
" </thead>\n",
" <tbody>\n",
" <tr>\n",
" <th>3.4/TSFP/2.844</th>\n",
" <td>844</td>\n",
" <td>3.4</td>\n",
" <td>TSFP</td>\n",
" <td>2</td>\n",
" <td>0</td>\n",
" <td>14</td>\n",
" <td>1</td>\n",
" <td>1</td>\n",
" <td>0</td>\n",
" <td>0</td>\n",
" <td>...</td>\n",
" <td>26.6</td>\n",
" <td>27.5</td>\n",
" <td>27</td>\n",
" <td>28.8</td>\n",
" <td>28.3</td>\n",
" <td>26.7</td>\n",
" <td>28.1</td>\n",
" <td>29.9</td>\n",
" <td>29</td>\n",
" <td>27.6</td>\n",
" </tr>\n",
" </tbody>\n",
"</table>\n",
"<p>1 rows × 182 columns</p>\n",
"</div>"
],
"text/plain": [
" SERIAL PBS VARIANT VERSION SiteID PhaseID Complete Registered \\\n",
"UPI \n",
"3.4/TSFP/2.844 844 3.4 TSFP 2 0 14 1 1 \n",
"\n",
" NotConform Repair ... Gain 21 Gain 22 Gain 23 Gain 24 Gain 25 \\\n",
"UPI ... \n",
"3.4/TSFP/2.844 0 0 ... 26.6 27.5 27 28.8 28.3 \n",
"\n",
" Gain 26 Gain 27 Gain 28 Gain 29 Gain 30 \n",
"UPI \n",
"3.4/TSFP/2.844 26.7 28.1 29.9 29 27.6 \n",
"\n",
"[1 rows x 182 columns]"
]
},
"metadata": {},
"output_type": "display_data"
}
],
"source": [
"def count_chan_above_threshold( threshold = 1.7):\n",
" \n",
" doms = []\n",
" bad_channels = []\n",
" \n",
" for index, row in df_pmt.iterrows():\n",
" bad = 0\n",
" \n",
"# if row[\"SiteID\"] != \"1\": continue # only amsterdam\n",
" \n",
" for gain_key in gain_keys:\n",
" if row[gain_key] > threshold: bad +=1\n",
" \n",
" if bad == 31: \n",
" print(\"bad dom\", row[\"SERIAL\"])\n",
" display( df_tests[ df_tests[\"SERIAL\"] == row[\"SERIAL\"] ] )\n",
" continue # why? \n",
" \n",
" doms.append( row[\"SERIAL\"] )\n",
" bad_channels.append( bad )\n",
"\n",
" return doms, bad_channels\n",
" \n",
"doms, bad_channels = count_chan_above_threshold()\n",
"bad_doms = [i for i,v in enumerate(bad_channels) if v > 3]"
]
},
{
"cell_type": "code",
"execution_count": 106,
"id": "4a9a5b4b-4d41-450d-bc2e-fdb10a870ed8",
"metadata": {},
"outputs": [
{
"data": {
"image/png": "iVBORw0KGgoAAAANSUhEUgAAAXcAAAD4CAYAAAAXUaZHAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjMuMywgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/Il7ecAAAACXBIWXMAAAsTAAALEwEAmpwYAAAOLElEQVR4nO3df6hf9X3H8edrptZqWdXmEmwiu4GGFicrysXZCUVMx2wjJn+IRLYuc0IYuNb+ABu7P/yrEFlp62ATglozJraSOhJq11VSiwxm1usP6o/oDBr1ZtHc0mq7FmZd3/vjHre7643J/Z7v9371k+cD5H7P+Z7vPe+D4ZmTc7/fc1NVSJLa8lvjHkCSNHzGXZIaZNwlqUHGXZIaZNwlqUErxj0AwMqVK2tycnLcY0jSO8pDDz30k6qaWOy5t0XcJycnmZ6eHvcYkvSOkuT5oz3nZRlJapBxl6QGGXdJapBxl6QGGXdJapBxl6QGGXdJatAx457k9iRHkjw+b91fJ3kqyY+T/GOS0+c9d0OSA0meTvJHI5pbkvQWjufM/Q7g0gXr7gPOrarfA/4duAEgyTnAZuB3u9f8XZKThjatJOm4HPMTqlX1QJLJBeu+P2/xQeCK7vFG4JtV9V/Ac0kOABcA/zqccd9sctu9o/rWizq4fcOy7k+SBjGMa+5/DvxT93g18OK852a6dW+SZGuS6STTs7OzQxhDkvSGXnFP8lfA68CdS31tVe2oqqmqmpqYWPS+N5KkAQ1847AkfwZcBqyv//tFrIeAs+dttqZbJ0laRgOduSe5FLgeuLyqfjXvqT3A5iTvTrIWWAf8W/8xJUlLccwz9yR3ARcDK5PMADcy9+6YdwP3JQF4sKr+oqqeSHI38CRzl2uurar/HtXwkqTFHc+7Za5aZPVtb7H9l4Ev9xlKktSPn1CVpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYdM+5Jbk9yJMnj89admeS+JM90X8/o1ifJ3yQ5kOTHSc4f5fCSpMUdz5n7HcClC9ZtA/ZW1Tpgb7cM8AlgXfffVuCW4YwpSVqKY8a9qh4Afrpg9UZgZ/d4J7Bp3vq/rzkPAqcnOWtIs0qSjtOg19xXVdXh7vFLwKru8WrgxXnbzXTrJEnLqPcPVKuqgFrq65JsTTKdZHp2drbvGJKkeQaN+8tvXG7pvh7p1h8Czp633Zpu3ZtU1Y6qmqqqqYmJiQHHkCQtZtC47wG2dI+3ALvnrf/T7l0zFwKvzrt8I0laJiuOtUGSu4CLgZVJZoAbge3A3UmuAZ4Hruw2/y7wSeAA8Cvg6hHMLEk6hmPGvaquOspT6xfZtoBr+w4lSerHT6hKUoOMuyQ1yLhLUoOMuyQ1yLhLUoOMuyQ1yLhLUoOMuyQ1yLhLUoOMuyQ1yLhLUoOMuyQ1yLhLUoOOeVdI/X+T2+5d1v0d3L5hWfcnqQ2euUtSg4y7JDXIuEtSg4y7JDXIuEtSg4y7JDXIuEtSg4y7JDXIuEtSg4y7JDXIuEtSg4y7JDWoV9yTfC7JE0keT3JXklOSrE2yL8mBJN9KcvKwhpUkHZ+B455kNfAZYKqqzgVOAjYDNwFfq6oPAj8DrhnGoJKk49f3sswK4D1JVgCnAoeBS4Bd3fM7gU099yFJWqKB415Vh4CvAC8wF/VXgYeAV6rq9W6zGWD1Yq9PsjXJdJLp2dnZQceQJC2iz2WZM4CNwFrgA8BpwKXH+/qq2lFVU1U1NTExMegYkqRF9Lks83HguaqarapfA/cAFwGnd5dpANYAh3rOKElaoj5xfwG4MMmpSQKsB54E7geu6LbZAuzuN6Ikaan6XHPfx9wPTh8GHuu+1w7gi8DnkxwA3g/cNoQ5JUlL0OsXZFfVjcCNC1Y/C1zQ5/tKkvrxE6qS1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1CDjLkkNMu6S1KAV4x5Ab21y273Ltq+D2zcs274kjZZn7pLUIOMuSQ0y7pLUoF5xT3J6kl1JnkqyP8lHk5yZ5L4kz3RfzxjWsJKk49P3zP1m4HtV9WHgI8B+YBuwt6rWAXu7ZUnSMho47kneB3wMuA2gql6rqleAjcDObrOdwKZ+I0qSlqrPmftaYBb4RpJHktya5DRgVVUd7rZ5CVi12IuTbE0ynWR6dna2xxiSpIX6xH0FcD5wS1WdB/ySBZdgqqqAWuzFVbWjqqaqampiYqLHGJKkhfrEfQaYqap93fIu5mL/cpKzALqvR/qNKElaqoHjXlUvAS8m+VC3aj3wJLAH2NKt2wLs7jWhJGnJ+t5+4NPAnUlOBp4FrmbuL4y7k1wDPA9c2XMfkqQl6hX3qnoUmFrkqfV9vq8kqR8/oSpJDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDTLuktQg4y5JDeod9yQnJXkkyXe65bVJ9iU5kORbSU7uP6YkaSmGceZ+HbB/3vJNwNeq6oPAz4BrhrAPSdIS9Ip7kjXABuDWbjnAJcCubpOdwKY++5AkLV3fM/evA9cDv+mW3w+8UlWvd8szwOrFXphka5LpJNOzs7M9x5AkzTdw3JNcBhypqocGeX1V7aiqqaqampiYGHQMSdIiVvR47UXA5Uk+CZwC/DZwM3B6khXd2fsa4FD/MSVJSzHwmXtV3VBVa6pqEtgM/KCq/hi4H7ii22wLsLv3lJKkJRnF+9y/CHw+yQHmrsHfNoJ9SJLeQp/LMv+rqn4I/LB7/CxwwTC+ryRpMH5CVZIaZNwlqUHGXZIaZNwlqUHGXZIaZNwlqUFDeSuk2jC57d5l3d/B7RuWdX/SicQzd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYZd0lqkHGXpAYNHPckZye5P8mTSZ5Icl23/swk9yV5pvt6xvDGlSQdjz5n7q8DX6iqc4ALgWuTnANsA/ZW1Tpgb7csSVpGA8e9qg5X1cPd418A+4HVwEZgZ7fZTmBTzxklSUs0lGvuSSaB84B9wKqqOtw99RKwahj7kCQdv95xT/Je4NvAZ6vq5/Ofq6oC6iiv25pkOsn07Oxs3zEkSfP0inuSdzEX9jur6p5u9ctJzuqePws4sthrq2pHVU1V1dTExESfMSRJC/R5t0yA24D9VfXVeU/tAbZ0j7cAuwcfT5I0iBU9XnsR8CngsSSPduu+BGwH7k5yDfA8cGWvCSVJSzZw3KvqX4Ac5en1g35fSVJ/fkJVkhpk3CWpQcZdkhpk3CWpQcZdkhpk3CWpQcZdkhpk3CWpQX0+oSr1Mrnt3mXd38HtG5Z1f9I4eeYuSQ0y7pLUIOMuSQ3ymrtOGMt5jd/r+xo3z9wlqUHGXZIaZNwlqUHGXZIaZNwlqUHGXZIaZNwlqUHGXZIaZNwlqUF+QlUaAe94qXHzzF2SGmTcJalBxl2SGjSyuCe5NMnTSQ4k2Taq/UiS3mwkP1BNchLwt8AfAjPAj5LsqaonR7E/6US33D/A1fCM6ofhozpzvwA4UFXPVtVrwDeBjSPalyRpgVG9FXI18OK85Rng9+dvkGQrsLVb/M8kT49olqNZCfxkmfe5nFo+Po/tnavl4xvo2HJTr33+ztGeGNv73KtqB7BjXPtPMl1VU+Pa/6i1fHwe2ztXy8f3dju2UV2WOQScPW95TbdOkrQMRhX3HwHrkqxNcjKwGdgzon1JkhYYyWWZqno9yV8C/wycBNxeVU+MYl89jO2S0DJp+fg8tneulo/vbXVsqapxzyBJGjI/oSpJDTLuktSgEzLurd4aIcnZSe5P8mSSJ5JcN+6Zhi3JSUkeSfKdcc8ybElOT7IryVNJ9if56LhnGpYkn+v+TD6e5K4kp4x7pj6S3J7kSJLH5607M8l9SZ7pvp4xzhlPuLjPuzXCJ4BzgKuSnDPeqYbmdeALVXUOcCFwbUPH9obrgP3jHmJEbga+V1UfBj5CI8eZZDXwGWCqqs5l7k0Wm8c7VW93AJcuWLcN2FtV64C93fLYnHBxp+FbI1TV4ap6uHv8C+bisHq8Uw1PkjXABuDWcc8ybEneB3wMuA2gql6rqlfGOtRwrQDek2QFcCrwH2Oep5eqegD46YLVG4Gd3eOdwKblnGmhEzHui90aoZkAviHJJHAesG/MowzT14Hrgd+MeY5RWAvMAt/oLjvdmuS0cQ81DFV1CPgK8AJwGHi1qr4/3qlGYlVVHe4evwSsGucwJ2Lcm5fkvcC3gc9W1c/HPc8wJLkMOFJVD417lhFZAZwP3FJV5wG/ZMz/rB+W7trzRub+AvsAcFqSPxnvVKNVc+8xH+v7zE/EuDd9a4Qk72Iu7HdW1T3jnmeILgIuT3KQuUtplyT5h/GONFQzwExVvfEvrV3Mxb4FHweeq6rZqvo1cA/wB2OeaRReTnIWQPf1yDiHORHj3uytEZKEuWu2+6vqq+OeZ5iq6oaqWlNVk8z9P/tBVTVz9ldVLwEvJvlQt2o90MrvP3gBuDDJqd2f0fU08sPiBfYAW7rHW4DdY5xlfHeFHJd3yK0RBnUR8CngsSSPduu+VFXfHd9IWoJPA3d2Jx3PAlePeZ6hqKp9SXYBDzP3jq5HeJt9VH+pktwFXAysTDID3AhsB+5Ocg3wPHDl+Cb09gOS1KQT8bKMJDXPuEtSg4y7JDXIuEtSg4y7JDXIuEtSg4y7JDXofwAXXk57+RXHNgAAAABJRU5ErkJggg==\n",
"text/plain": [
"<Figure size 432x288 with 1 Axes>"
]
},
"metadata": {
"needs_background": "light"
},
"output_type": "display_data"
},
{
"name": "stdout",
"output_type": "stream",
"text": [
"failed doms 30\n"
]
}
],
"source": [
"import matplotlib.pyplot as plt\n",
"\n",
"plt.hist(bad_channels, [-0.5, 0.5, 1.5, 2.5, 3.5, 4.5, 5.5, 6.5, 7.5, 8.5, 9.5, 10.5])\n",
"plt.plot(3, 0, 3, 40, color='red')\n",
"plt.show()\n",
"print(\"failed doms\", len(bad_doms))"
]
},
{
"cell_type": "code",
"execution_count": null,
"id": "4eaed37c-3cae-44ef-88db-fac0ce64acbf",
"metadata": {},
"outputs": [],
"source": []
},
{
"cell_type": "code",
"execution_count": null,
"id": "ca1f27e5-fecb-42d5-8e17-dd58da923f08",
"metadata": {},
"outputs": [],
"source": []
}
],
"metadata": {
"kernelspec": {
"display_name": "km3net-env-1.9",
"language": "python",
"name": "km3net-env-1.9"
},
"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.7.5"
}
},
"nbformat": 4,
"nbformat_minor": 5
}