network_report_server/network.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "cbead187",
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: pymongo in /Users/simplicoltd./.pyenv/versions/3.10.4/lib/python3.10/site-packages (4.5.0)\n",
      "Requirement already satisfied: pandas in /Users/simplicoltd./.pyenv/versions/3.10.4/lib/python3.10/site-packages (1.5.1)\n",
      "Requirement already satisfied: dnspython<3.0.0,>=1.16.0 in /Users/simplicoltd./.pyenv/versions/3.10.4/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages (from pymongo) (2.2.1)\n",
      "Requirement already satisfied: python-dateutil>=2.8.1 in /Users/simplicoltd./.pyenv/versions/3.10.4/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages (from pandas) (2.8.2)\n",
      "Requirement already satisfied: pytz>=2020.1 in /Users/simplicoltd./.pyenv/versions/3.10.4/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages (from pandas) (2021.3)\n",
      "Requirement already satisfied: numpy>=1.21.0 in /Users/simplicoltd./.pyenv/versions/3.10.4/lib/python3.10/site-packages (from pandas) (1.23.1)\n",
      "Requirement already satisfied: six>=1.5 in /Users/simplicoltd./.pyenv/versions/3.10.4/Library/Frameworks/Python.framework/Versions/3.10/lib/python3.10/site-packages (from python-dateutil>=2.8.1->pandas) (1.16.0)\n",
      "\n",
      "\u001b[1m[\u001b[0m\u001b[34;49mnotice\u001b[0m\u001b[1;39;49m]\u001b[0m\u001b[39;49m A new release of pip is available: \u001b[0m\u001b[31;49m23.1.2\u001b[0m\u001b[39;49m -> \u001b[0m\u001b[32;49m23.3.2\u001b[0m\n",
      "\u001b[1m[\u001b[0m\u001b[34;49mnotice\u001b[0m\u001b[1;39;49m]\u001b[0m\u001b[39;49m To update, run: \u001b[0m\u001b[32;49mpython -m pip install --upgrade pip\u001b[0m\n"
     ]
    }
   ],
   "source": [
    "!pip install pymongo pandas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "5c862da4",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pymongo import MongoClient\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "a6f31c7d",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "MongoClient(host=['localhost:27017'], document_class=dict, tz_aware=False, connect=True)"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "client = MongoClient(\"mongodb://localhost\")\n",
    "client"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "de7a5475",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['admin', 'config', 'local', 'network_report']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "client.list_database_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "df095a21",
   "metadata": {},
   "outputs": [],
   "source": [
    "db = client.network_report"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "192de864",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['exfo_api', 'mascot']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "db.list_collection_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "90bed42d",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>_id</th>\n",
       "      <th>ids</th>\n",
       "      <th>sla_uri_result</th>\n",
       "      <th>test_instance_class_result</th>\n",
       "      <th>test_status_result</th>\n",
       "      <th>created</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>65893c1d178d19558e1be8fb</td>\n",
       "      <td>{'cur_sla_version': 571, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[{'config': {'interface_categories': [{'name':...</td>\n",
       "      <td>[{'sla_name': 'POC-Expansion-SLA_BRAS_88_Priva...</td>\n",
       "      <td>2023-12-25 08:23:57.676</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>65893c1f178d19558e1be902</td>\n",
       "      <td>{'cur_sla_version': 571, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[{'config': {'interface_categories': [{'name':...</td>\n",
       "      <td>[{'sla_name': 'POC-Expansion-SLA_BRAS_88_Priva...</td>\n",
       "      <td>2023-12-25 08:23:59.615</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>65895ea2b6630cab2c9aebde</td>\n",
       "      <td>{'cur_sla_version': 571, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 10:51:14.829</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>65895ea4071ee1d4559aebde</td>\n",
       "      <td>{'cur_sla_version': 571, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 10:51:16.702</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>65895edfed1cfbcda79aebde</td>\n",
       "      <td>{'cur_sla_version': 571, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 10:52:15.282</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>211</th>\n",
       "      <td>65899098b6630cab2c9af4d8</td>\n",
       "      <td>{'cur_sla_version': 574, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 14:24:24.588</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>212</th>\n",
       "      <td>658990de071ee1d4559af486</td>\n",
       "      <td>{'cur_sla_version': 574, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 14:25:34.871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>213</th>\n",
       "      <td>65899123b6630cab2c9af4ee</td>\n",
       "      <td>{'cur_sla_version': 574, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 14:26:43.482</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>214</th>\n",
       "      <td>65899159ed1cfbcda79aec4c</td>\n",
       "      <td>{'cur_sla_version': 574, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 14:27:37.016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>215</th>\n",
       "      <td>65899190071ee1d4559af49c</td>\n",
       "      <td>{'cur_sla_version': 574, 'cur_sla_version_uri'...</td>\n",
       "      <td>{'attributes': {'author': 'administrator', 'bi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2023-12-25 14:28:32.700</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>216 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          _id  \\\n",
       "0    65893c1d178d19558e1be8fb   \n",
       "1    65893c1f178d19558e1be902   \n",
       "2    65895ea2b6630cab2c9aebde   \n",
       "3    65895ea4071ee1d4559aebde   \n",
       "4    65895edfed1cfbcda79aebde   \n",
       "..                        ...   \n",
       "211  65899098b6630cab2c9af4d8   \n",
       "212  658990de071ee1d4559af486   \n",
       "213  65899123b6630cab2c9af4ee   \n",
       "214  65899159ed1cfbcda79aec4c   \n",
       "215  65899190071ee1d4559af49c   \n",
       "\n",
       "                                                   ids  \\\n",
       "0    {'cur_sla_version': 571, 'cur_sla_version_uri'...   \n",
       "1    {'cur_sla_version': 571, 'cur_sla_version_uri'...   \n",
       "2    {'cur_sla_version': 571, 'cur_sla_version_uri'...   \n",
       "3    {'cur_sla_version': 571, 'cur_sla_version_uri'...   \n",
       "4    {'cur_sla_version': 571, 'cur_sla_version_uri'...   \n",
       "..                                                 ...   \n",
       "211  {'cur_sla_version': 574, 'cur_sla_version_uri'...   \n",
       "212  {'cur_sla_version': 574, 'cur_sla_version_uri'...   \n",
       "213  {'cur_sla_version': 574, 'cur_sla_version_uri'...   \n",
       "214  {'cur_sla_version': 574, 'cur_sla_version_uri'...   \n",
       "215  {'cur_sla_version': 574, 'cur_sla_version_uri'...   \n",
       "\n",
       "                                        sla_uri_result  \\\n",
       "0    {'attributes': {'author': 'administrator', 'bi...   \n",
       "1    {'attributes': {'author': 'administrator', 'bi...   \n",
       "2    {'attributes': {'author': 'administrator', 'bi...   \n",
       "3    {'attributes': {'author': 'administrator', 'bi...   \n",
       "4    {'attributes': {'author': 'administrator', 'bi...   \n",
       "..                                                 ...   \n",
       "211  {'attributes': {'author': 'administrator', 'bi...   \n",
       "212  {'attributes': {'author': 'administrator', 'bi...   \n",
       "213  {'attributes': {'author': 'administrator', 'bi...   \n",
       "214  {'attributes': {'author': 'administrator', 'bi...   \n",
       "215  {'attributes': {'author': 'administrator', 'bi...   \n",
       "\n",
       "                            test_instance_class_result  \\\n",
       "0    [{'config': {'interface_categories': [{'name':...   \n",
       "1    [{'config': {'interface_categories': [{'name':...   \n",
       "2                                                   []   \n",
       "3                                                   []   \n",
       "4                                                   []   \n",
       "..                                                 ...   \n",
       "211                                                 []   \n",
       "212                                                 []   \n",
       "213                                                 []   \n",
       "214                                                 []   \n",
       "215                                                 []   \n",
       "\n",
       "                                    test_status_result                 created  \n",
       "0    [{'sla_name': 'POC-Expansion-SLA_BRAS_88_Priva... 2023-12-25 08:23:57.676  \n",
       "1    [{'sla_name': 'POC-Expansion-SLA_BRAS_88_Priva... 2023-12-25 08:23:59.615  \n",
       "2                                                   [] 2023-12-25 10:51:14.829  \n",
       "3                                                   [] 2023-12-25 10:51:16.702  \n",
       "4                                                   [] 2023-12-25 10:52:15.282  \n",
       "..                                                 ...                     ...  \n",
       "211                                                 [] 2023-12-25 14:24:24.588  \n",
       "212                                                 [] 2023-12-25 14:25:34.871  \n",
       "213                                                 [] 2023-12-25 14:26:43.482  \n",
       "214                                                 [] 2023-12-25 14:27:37.016  \n",
       "215                                                 [] 2023-12-25 14:28:32.700  \n",
       "\n",
       "[216 rows x 6 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_result = list(db['exfo_api'].find({'ids.sla_id': 1350}))\n",
    "all_df = pd.DataFrame(all_result)\n",
    "all_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "104fe30a",
   "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>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>test_status_result</th>\n",
       "      <th>test_instance_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>203061.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[{'sla_name': 'BV110_CMI', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[{'sla_name': 'BV110_CMI', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'sla_name': 'BV110_CMI', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'sla_name': 'BV110_CMI', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[{'sla_name': 'BV110_CMI', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43831</th>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'sla_name': 'BV110_PTY', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43832</th>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>[{'sla_name': 'BV110_PTY', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43833</th>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[{'sla_name': 'BV110_PTY', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43834</th>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>40.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>[{'sla_name': 'BV110_PTY', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43835</th>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>5698.5</td>\n",
       "      <td>100.0</td>\n",
       "      <td>[{'sla_name': 'BV110_PTY', 'test_instance_id':...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>43836 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                        name  raw_value  score  \\\n",
       "0      totalPageDownloadTime   203061.0  100.0   \n",
       "1                     result      100.0  100.0   \n",
       "2      totalPageDownloadTime        NaN    NaN   \n",
       "3                     result        NaN    NaN   \n",
       "4                     result      100.0  100.0   \n",
       "...                      ...        ...    ...   \n",
       "43831    endToEndDelayMedian        NaN    NaN   \n",
       "43832                 result        NaN    NaN   \n",
       "43833                 result      100.0  100.0   \n",
       "43834     percentLostPackets       40.0   80.0   \n",
       "43835    endToEndDelayMedian     5698.5  100.0   \n",
       "\n",
       "                                      test_status_result test_instance_id  \n",
       "0      [{'sla_name': 'BV110_CMI', 'test_instance_id':...              NaN  \n",
       "1      [{'sla_name': 'BV110_CMI', 'test_instance_id':...              NaN  \n",
       "2      [{'sla_name': 'BV110_CMI', 'test_instance_id':...              NaN  \n",
       "3      [{'sla_name': 'BV110_CMI', 'test_instance_id':...              NaN  \n",
       "4      [{'sla_name': 'BV110_CMI', 'test_instance_id':...              NaN  \n",
       "...                                                  ...              ...  \n",
       "43831  [{'sla_name': 'BV110_PTY', 'test_instance_id':...              NaN  \n",
       "43832  [{'sla_name': 'BV110_PTY', 'test_instance_id':...              NaN  \n",
       "43833  [{'sla_name': 'BV110_PTY', 'test_instance_id':...              NaN  \n",
       "43834  [{'sla_name': 'BV110_PTY', 'test_instance_id':...              NaN  \n",
       "43835  [{'sla_name': 'BV110_PTY', 'test_instance_id':...              NaN  \n",
       "\n",
       "[43836 rows x 5 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r0 = list(db['exfo_api'].find().sort(\"created\", -1).limit(30))\n",
    "pd.json_normalize(r0, ['test_status_result','status', 'results_scores'], ['test_status_result','test_instance_id'], errors='ignore')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "6ca946d4",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "500\n",
      "5394\n",
      "500\n"
     ]
    }
   ],
   "source": [
    "from pprint import pprint\n",
    "list_test_status_result = list(db['exfo_api'].find({}, {'test_status_result':1, 'ids': 1}).sort(\"created\", -1).skip(1000).limit(500))\n",
    "print(len(list_test_status_result))\n",
    "data = []\n",
    "data2 = []\n",
    "for l in list_test_status_result:\n",
    "    data = data + l['test_status_result']\n",
    "    data2.append(l['ids'])\n",
    "print(len(data))\n",
    "print(len(data2))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "9ceb1f79",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "5394\n"
     ]
    }
   ],
   "source": [
    "df0 = pd.json_normalize(data)\n",
    "df0\n",
    "print(len(data))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "7a280028",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['BV110_NMA', 'BV110_PLK', 'BV110_KKN', 'BV110_RBI', 'BV110_HYI',\n",
       "       'BV110_SNI', 'BV1100_BRK', 'BV110_PTY', 'ATP-Expansion BRIX',\n",
       "       'BV110_CMI', 'BV110_NWS',\n",
       "       'POC-Expansion-SLA_BNG_144_Private (VLAN10)',\n",
       "       'POC-Expansion-SLA_BRAS_88_Public (VLAN20)'], dtype=object)"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df0['sla_name'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "56b6333a",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['BV110_NMA', 'BV110_PLK', 'BV110_KKN', 'BV110_RBI', 'BV110_HYI',\n",
       "       'BV110_SNI', 'BV1100_BRK', 'BV110_PTY', 'ATP-Expansion BRIX',\n",
       "       'BV110_CMI', 'BV110_NWS',\n",
       "       'POC-Expansion-SLA_BNG_144_Private (VLAN10)',\n",
       "       'POC-Expansion-SLA_BRAS_88_Public (VLAN20)'], dtype=object)"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df0['sla_name'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "f90699e6",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "500"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(data2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "e0ad1893",
   "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>cur_sla_version</th>\n",
       "      <th>cur_sla_version_uri</th>\n",
       "      <th>sla_id</th>\n",
       "      <th>sla_name</th>\n",
       "      <th>sla_status_uri</th>\n",
       "      <th>sla_uri</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>29</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1150/Version/29</td>\n",
       "      <td>1150</td>\n",
       "      <td>ppp-vlan-999</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1150</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1125/Version/20</td>\n",
       "      <td>1125</td>\n",
       "      <td>BV110_PCB pppoe test</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1125</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>71</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1034/Version/71</td>\n",
       "      <td>1034</td>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1034</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>73</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1026/Version/73</td>\n",
       "      <td>1026</td>\n",
       "      <td>BV110_PLK</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1026</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1026</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>75</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1033/Version/75</td>\n",
       "      <td>1033</td>\n",
       "      <td>BV110_KKN</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1033</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1033</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>495</th>\n",
       "      <td>574</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1350/Version/574</td>\n",
       "      <td>1350</td>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Private (VLAN10)</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1350</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>496</th>\n",
       "      <td>29</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1150/Version/29</td>\n",
       "      <td>1150</td>\n",
       "      <td>ppp-vlan-999</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1150</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1150</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>497</th>\n",
       "      <td>20</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1125/Version/20</td>\n",
       "      <td>1125</td>\n",
       "      <td>BV110_PCB pppoe test</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1125</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1125</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>498</th>\n",
       "      <td>71</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1034/Version/71</td>\n",
       "      <td>1034</td>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1034</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1034</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>499</th>\n",
       "      <td>73</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1026/Version/73</td>\n",
       "      <td>1026</td>\n",
       "      <td>BV110_PLK</td>\n",
       "      <td>/API/REST/Status/v1/SLAStatus/1026</td>\n",
       "      <td>/API/REST/SLAs/v1/SLA/1026</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>500 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     cur_sla_version                     cur_sla_version_uri  sla_id  \\\n",
       "0                 29   /API/REST/SLAs/v1/SLA/1150/Version/29    1150   \n",
       "1                 20   /API/REST/SLAs/v1/SLA/1125/Version/20    1125   \n",
       "2                 71   /API/REST/SLAs/v1/SLA/1034/Version/71    1034   \n",
       "3                 73   /API/REST/SLAs/v1/SLA/1026/Version/73    1026   \n",
       "4                 75   /API/REST/SLAs/v1/SLA/1033/Version/75    1033   \n",
       "..               ...                                     ...     ...   \n",
       "495              574  /API/REST/SLAs/v1/SLA/1350/Version/574    1350   \n",
       "496               29   /API/REST/SLAs/v1/SLA/1150/Version/29    1150   \n",
       "497               20   /API/REST/SLAs/v1/SLA/1125/Version/20    1125   \n",
       "498               71   /API/REST/SLAs/v1/SLA/1034/Version/71    1034   \n",
       "499               73   /API/REST/SLAs/v1/SLA/1026/Version/73    1026   \n",
       "\n",
       "                                       sla_name  \\\n",
       "0                                  ppp-vlan-999   \n",
       "1                          BV110_PCB pppoe test   \n",
       "2                                     BV110_NMA   \n",
       "3                                     BV110_PLK   \n",
       "4                                     BV110_KKN   \n",
       "..                                          ...   \n",
       "495  POC-Expansion-SLA_BRAS_88_Private (VLAN10)   \n",
       "496                                ppp-vlan-999   \n",
       "497                        BV110_PCB pppoe test   \n",
       "498                                   BV110_NMA   \n",
       "499                                   BV110_PLK   \n",
       "\n",
       "                         sla_status_uri                     sla_uri  \n",
       "0    /API/REST/Status/v1/SLAStatus/1150  /API/REST/SLAs/v1/SLA/1150  \n",
       "1    /API/REST/Status/v1/SLAStatus/1125  /API/REST/SLAs/v1/SLA/1125  \n",
       "2    /API/REST/Status/v1/SLAStatus/1034  /API/REST/SLAs/v1/SLA/1034  \n",
       "3    /API/REST/Status/v1/SLAStatus/1026  /API/REST/SLAs/v1/SLA/1026  \n",
       "4    /API/REST/Status/v1/SLAStatus/1033  /API/REST/SLAs/v1/SLA/1033  \n",
       "..                                  ...                         ...  \n",
       "495  /API/REST/Status/v1/SLAStatus/1350  /API/REST/SLAs/v1/SLA/1350  \n",
       "496  /API/REST/Status/v1/SLAStatus/1150  /API/REST/SLAs/v1/SLA/1150  \n",
       "497  /API/REST/Status/v1/SLAStatus/1125  /API/REST/SLAs/v1/SLA/1125  \n",
       "498  /API/REST/Status/v1/SLAStatus/1034  /API/REST/SLAs/v1/SLA/1034  \n",
       "499  /API/REST/Status/v1/SLAStatus/1026  /API/REST/SLAs/v1/SLA/1026  \n",
       "\n",
       "[500 rows x 6 columns]"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_ids = pd.json_normalize(data2)\n",
    "df_ids"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "cae27a52",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>255083.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>53024</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>53024</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>53024</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>385728.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>53024</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>53024</td>\n",
       "      <td>12/23/2023 01:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014167</th>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53037</td>\n",
       "      <td>12/24/2023 19:45 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014168</th>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53037</td>\n",
       "      <td>12/24/2023 19:45 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014169</th>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53037</td>\n",
       "      <td>12/24/2023 19:30 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014170</th>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53037</td>\n",
       "      <td>12/24/2023 19:30 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014171</th>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>53037</td>\n",
       "      <td>12/24/2023 19:30 +07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1014172 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          name  raw_value  score test_instance_id  \\\n",
       "0        totalPageDownloadTime   255083.0  100.0            53024   \n",
       "1                       result      100.0  100.0            53024   \n",
       "2                       result      100.0  100.0            53024   \n",
       "3        totalPageDownloadTime   385728.0  100.0            53024   \n",
       "4                       result      100.0  100.0            53024   \n",
       "...                        ...        ...    ...              ...   \n",
       "1014167    endToEndDelayMedian        NaN    NaN            53037   \n",
       "1014168     percentLostPackets        NaN    NaN            53037   \n",
       "1014169                 result        NaN    NaN            53037   \n",
       "1014170    endToEndDelayMedian        NaN    NaN            53037   \n",
       "1014171     percentLostPackets        NaN    NaN            53037   \n",
       "\n",
       "        status.time_stamp_display  \n",
       "0            12/25/2023 13:00 +07  \n",
       "1            12/25/2023 13:00 +07  \n",
       "2            12/24/2023 07:00 +07  \n",
       "3            12/24/2023 07:00 +07  \n",
       "4            12/23/2023 01:00 +07  \n",
       "...                           ...  \n",
       "1014167      12/24/2023 19:45 +07  \n",
       "1014168      12/24/2023 19:45 +07  \n",
       "1014169      12/24/2023 19:30 +07  \n",
       "1014170      12/24/2023 19:30 +07  \n",
       "1014171      12/24/2023 19:30 +07  \n",
       "\n",
       "[1014172 rows x 5 columns]"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.json_normalize(data, record_path=['status', 'results_scores'], \n",
    "                       meta=['test_instance_id', ['status','time_stamp_display']],  errors='ignore')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "08b0ecb5",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>status</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>255083.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>385728.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/23/2023 01:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512650</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512651</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512652</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512653</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512654</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23512655 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           sla_name test_instance_id  \\\n",
       "0                                         BV110_NMA            53024   \n",
       "1                                         BV110_NMA            53024   \n",
       "2                                         BV110_NMA            53024   \n",
       "3                                         BV110_NMA            53024   \n",
       "4                                         BV110_NMA            53024   \n",
       "...                                             ...              ...   \n",
       "23512650  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512651  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512652  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512653  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512654  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "\n",
       "                            type_type_name  test_instance_class_id  \\\n",
       "0         com.brixnet.securehttpactivetest                   17138   \n",
       "1         com.brixnet.securehttpactivetest                   17138   \n",
       "2         com.brixnet.securehttpactivetest                   17138   \n",
       "3         com.brixnet.securehttpactivetest                   17138   \n",
       "4         com.brixnet.securehttpactivetest                   17138   \n",
       "...                                    ...                     ...   \n",
       "23512650        com.brixnet.pingactivetest                   48425   \n",
       "23512651        com.brixnet.pingactivetest                   48425   \n",
       "23512652        com.brixnet.pingactivetest                   48425   \n",
       "23512653        com.brixnet.pingactivetest                   48425   \n",
       "23512654        com.brixnet.pingactivetest                   48425   \n",
       "\n",
       "                                                     status  \\\n",
       "0         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "1         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "2         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "3         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "4         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "...                                                     ...   \n",
       "23512650                                                 []   \n",
       "23512651                                                 []   \n",
       "23512652                                                 []   \n",
       "23512653                                                 []   \n",
       "23512654                                                 []   \n",
       "\n",
       "          service.service_id               service.service_name  \\\n",
       "0                       1151             HTTPS Web Performances   \n",
       "1                       1151             HTTPS Web Performances   \n",
       "2                       1151             HTTPS Web Performances   \n",
       "3                       1151             HTTPS Web Performances   \n",
       "4                       1151             HTTPS Web Performances   \n",
       "...                      ...                                ...   \n",
       "23512650                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512651                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512652                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512653                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512654                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "\n",
       "                                    service.service_uri  \\\n",
       "0          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "1          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "2          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "3          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "4          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "...                                                 ...   \n",
       "23512650  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512651  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512652  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512653  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512654  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "\n",
       "          service.service_version service.slt_id target.target_param  \\\n",
       "0                               6           2157                 url   \n",
       "1                               6           2157                 url   \n",
       "2                               6           2157                 url   \n",
       "3                               6           2157                 url   \n",
       "4                               6           2157                 url   \n",
       "...                           ...            ...                 ...   \n",
       "23512650                       16           2631                host   \n",
       "23512651                       16           2631                host   \n",
       "23512652                       16           2631                host   \n",
       "23512653                       16           2631                host   \n",
       "23512654                       16           2631                host   \n",
       "\n",
       "         target.target_value  target                   name  raw_value  score  \\\n",
       "0             www.sanook.com     NaN  totalPageDownloadTime   255083.0  100.0   \n",
       "1             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "2             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "3             www.sanook.com     NaN  totalPageDownloadTime   385728.0  100.0   \n",
       "4             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "...                      ...     ...                    ...        ...    ...   \n",
       "23512650        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512651        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512652        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512653        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512654        159.192.3.60     NaN     percentLostPackets        NaN    NaN   \n",
       "\n",
       "         status.time_stamp_display  \n",
       "0             12/25/2023 13:00 +07  \n",
       "1             12/25/2023 13:00 +07  \n",
       "2             12/24/2023 07:00 +07  \n",
       "3             12/24/2023 07:00 +07  \n",
       "4             12/23/2023 01:00 +07  \n",
       "...                            ...  \n",
       "23512650      12/25/2023 20:20 +07  \n",
       "23512651      12/25/2023 20:20 +07  \n",
       "23512652      12/25/2023 20:20 +07  \n",
       "23512653      12/25/2023 20:20 +07  \n",
       "23512654      12/25/2023 20:20 +07  \n",
       "\n",
       "[23512655 rows x 17 columns]"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3 = pd.merge(df0, df, on='test_instance_id')\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "8059c5bb",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>255083.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>385728.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/23/2023 01:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512650</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512651</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512652</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512653</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512654</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23512655 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           sla_name test_instance_id  \\\n",
       "0                                         BV110_NMA            53024   \n",
       "1                                         BV110_NMA            53024   \n",
       "2                                         BV110_NMA            53024   \n",
       "3                                         BV110_NMA            53024   \n",
       "4                                         BV110_NMA            53024   \n",
       "...                                             ...              ...   \n",
       "23512650  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512651  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512652  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512653  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512654  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "\n",
       "                            type_type_name  test_instance_class_id  \\\n",
       "0         com.brixnet.securehttpactivetest                   17138   \n",
       "1         com.brixnet.securehttpactivetest                   17138   \n",
       "2         com.brixnet.securehttpactivetest                   17138   \n",
       "3         com.brixnet.securehttpactivetest                   17138   \n",
       "4         com.brixnet.securehttpactivetest                   17138   \n",
       "...                                    ...                     ...   \n",
       "23512650        com.brixnet.pingactivetest                   48425   \n",
       "23512651        com.brixnet.pingactivetest                   48425   \n",
       "23512652        com.brixnet.pingactivetest                   48425   \n",
       "23512653        com.brixnet.pingactivetest                   48425   \n",
       "23512654        com.brixnet.pingactivetest                   48425   \n",
       "\n",
       "          service.service_id               service.service_name  \\\n",
       "0                       1151             HTTPS Web Performances   \n",
       "1                       1151             HTTPS Web Performances   \n",
       "2                       1151             HTTPS Web Performances   \n",
       "3                       1151             HTTPS Web Performances   \n",
       "4                       1151             HTTPS Web Performances   \n",
       "...                      ...                                ...   \n",
       "23512650                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512651                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512652                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512653                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512654                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "\n",
       "                                    service.service_uri  \\\n",
       "0          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "1          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "2          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "3          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "4          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "...                                                 ...   \n",
       "23512650  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512651  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512652  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512653  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512654  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "\n",
       "          service.service_version service.slt_id target.target_param  \\\n",
       "0                               6           2157                 url   \n",
       "1                               6           2157                 url   \n",
       "2                               6           2157                 url   \n",
       "3                               6           2157                 url   \n",
       "4                               6           2157                 url   \n",
       "...                           ...            ...                 ...   \n",
       "23512650                       16           2631                host   \n",
       "23512651                       16           2631                host   \n",
       "23512652                       16           2631                host   \n",
       "23512653                       16           2631                host   \n",
       "23512654                       16           2631                host   \n",
       "\n",
       "         target.target_value  target                   name  raw_value  score  \\\n",
       "0             www.sanook.com     NaN  totalPageDownloadTime   255083.0  100.0   \n",
       "1             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "2             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "3             www.sanook.com     NaN  totalPageDownloadTime   385728.0  100.0   \n",
       "4             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "...                      ...     ...                    ...        ...    ...   \n",
       "23512650        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512651        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512652        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512653        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512654        159.192.3.60     NaN     percentLostPackets        NaN    NaN   \n",
       "\n",
       "         status.time_stamp_display  \n",
       "0             12/25/2023 13:00 +07  \n",
       "1             12/25/2023 13:00 +07  \n",
       "2             12/24/2023 07:00 +07  \n",
       "3             12/24/2023 07:00 +07  \n",
       "4             12/23/2023 01:00 +07  \n",
       "...                            ...  \n",
       "23512650      12/25/2023 20:20 +07  \n",
       "23512651      12/25/2023 20:20 +07  \n",
       "23512652      12/25/2023 20:20 +07  \n",
       "23512653      12/25/2023 20:20 +07  \n",
       "23512654      12/25/2023 20:20 +07  \n",
       "\n",
       "[23512655 rows x 16 columns]"
      ]
     },
     "execution_count": 38,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.drop(['status'], axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "177dea19",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>status</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5019318</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'result', 'raw_v...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5019319</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'result', 'raw_v...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5019320</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'result', 'raw_v...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5019321</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'result', 'raw_v...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 19:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5019322</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'result', 'raw_v...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 19:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5192113</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/21/2023 18:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5192114</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/21/2023 18:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5192115</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>29793.0</td>\n",
       "      <td>84.0</td>\n",
       "      <td>12/21/2023 17:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5192116</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/21/2023 17:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5192117</th>\n",
       "      <td>BV110_RBI</td>\n",
       "      <td>52952</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>1554</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/21/2023 17:00 +07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>172800 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "          sla_name test_instance_id              type_type_name  \\\n",
       "5019318  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5019319  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5019320  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5019321  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5019322  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "...            ...              ...                         ...   \n",
       "5192113  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5192114  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5192115  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5192116  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "5192117  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
       "\n",
       "         test_instance_class_id  \\\n",
       "5019318                    1554   \n",
       "5019319                    1554   \n",
       "5019320                    1554   \n",
       "5019321                    1554   \n",
       "5019322                    1554   \n",
       "...                         ...   \n",
       "5192113                    1554   \n",
       "5192114                    1554   \n",
       "5192115                    1554   \n",
       "5192116                    1554   \n",
       "5192117                    1554   \n",
       "\n",
       "                                                    status  \\\n",
       "5019318  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
       "5019319  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
       "5019320  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
       "5019321  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
       "5019322  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
       "...                                                    ...   \n",
       "5192113  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "5192114  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "5192115  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "5192116  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "5192117  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "\n",
       "         service.service_id service.service_name  \\\n",
       "5019318                1051            Ping test   \n",
       "5019319                1051            Ping test   \n",
       "5019320                1051            Ping test   \n",
       "5019321                1051            Ping test   \n",
       "5019322                1051            Ping test   \n",
       "...                     ...                  ...   \n",
       "5192113                1051            Ping test   \n",
       "5192114                1051            Ping test   \n",
       "5192115                1051            Ping test   \n",
       "5192116                1051            Ping test   \n",
       "5192117                1051            Ping test   \n",
       "\n",
       "                                  service.service_uri  \\\n",
       "5019318  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5019319  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5019320  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5019321  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5019322  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "...                                               ...   \n",
       "5192113  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5192114  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5192115  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5192116  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "5192117  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "\n",
       "         service.service_version service.slt_id target.target_param  \\\n",
       "5019318                        8           2171                host   \n",
       "5019319                        8           2171                host   \n",
       "5019320                        8           2171                host   \n",
       "5019321                        8           2171                host   \n",
       "5019322                        8           2171                host   \n",
       "...                          ...            ...                 ...   \n",
       "5192113                        8           2171                host   \n",
       "5192114                        8           2171                host   \n",
       "5192115                        8           2171                host   \n",
       "5192116                        8           2171                host   \n",
       "5192117                        8           2171                host   \n",
       "\n",
       "        target.target_value  target                 name  raw_value  score  \\\n",
       "5019318             8.8.8.8     NaN               result        NaN    NaN   \n",
       "5019319             8.8.8.8     NaN   percentLostPackets        NaN    NaN   \n",
       "5019320             8.8.8.8     NaN  endToEndDelayMedian        NaN    NaN   \n",
       "5019321             8.8.8.8     NaN               result      100.0  100.0   \n",
       "5019322             8.8.8.8     NaN   percentLostPackets        0.0  100.0   \n",
       "...                     ...     ...                  ...        ...    ...   \n",
       "5192113             8.8.8.8     NaN   percentLostPackets        0.0  100.0   \n",
       "5192114             8.8.8.8     NaN               result      100.0  100.0   \n",
       "5192115             8.8.8.8     NaN  endToEndDelayMedian    29793.0   84.0   \n",
       "5192116             8.8.8.8     NaN   percentLostPackets        0.0  100.0   \n",
       "5192117             8.8.8.8     NaN               result      100.0  100.0   \n",
       "\n",
       "        status.time_stamp_display  \n",
       "5019318      12/25/2023 20:00 +07  \n",
       "5019319      12/25/2023 20:00 +07  \n",
       "5019320      12/25/2023 20:00 +07  \n",
       "5019321      12/25/2023 19:00 +07  \n",
       "5019322      12/25/2023 19:00 +07  \n",
       "...                           ...  \n",
       "5192113      12/21/2023 18:00 +07  \n",
       "5192114      12/21/2023 18:00 +07  \n",
       "5192115      12/21/2023 17:00 +07  \n",
       "5192116      12/21/2023 17:00 +07  \n",
       "5192117      12/21/2023 17:00 +07  \n",
       "\n",
       "[172800 rows x 17 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.query('test_instance_class_id == 1554')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "69bbfd3f",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50784</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53053</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>17150</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>0.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 20:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50785</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53053</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>17150</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>40983.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>12/25/2023 20:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50786</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53053</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>17150</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 20:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50787</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53053</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>17150</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 19:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50788</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53053</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>17150</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>8.8.8.8</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>40959.0</td>\n",
       "      <td>78.0</td>\n",
       "      <td>12/25/2023 19:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23019594</th>\n",
       "      <td>BV110_NWS</td>\n",
       "      <td>52959</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>21892</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>110.78.191.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/21/2023 18:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23019595</th>\n",
       "      <td>BV110_NWS</td>\n",
       "      <td>52959</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>21892</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>110.78.191.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/21/2023 18:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23019596</th>\n",
       "      <td>BV110_NWS</td>\n",
       "      <td>52959</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>21892</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>110.78.191.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/21/2023 17:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23019597</th>\n",
       "      <td>BV110_NWS</td>\n",
       "      <td>52959</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>21892</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>110.78.191.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/21/2023 17:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23019598</th>\n",
       "      <td>BV110_NWS</td>\n",
       "      <td>52959</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>21892</td>\n",
       "      <td>1051</td>\n",
       "      <td>Ping test</td>\n",
       "      <td>/API/REST/Services/v1/Service/1051/Version/8</td>\n",
       "      <td>8</td>\n",
       "      <td>2171</td>\n",
       "      <td>host</td>\n",
       "      <td>110.78.191.21</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/21/2023 17:00 +07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4935600 rows × 16 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "           sla_name test_instance_id              type_type_name  \\\n",
       "50784     BV110_NMA            53053  com.brixnet.pingactivetest   \n",
       "50785     BV110_NMA            53053  com.brixnet.pingactivetest   \n",
       "50786     BV110_NMA            53053  com.brixnet.pingactivetest   \n",
       "50787     BV110_NMA            53053  com.brixnet.pingactivetest   \n",
       "50788     BV110_NMA            53053  com.brixnet.pingactivetest   \n",
       "...             ...              ...                         ...   \n",
       "23019594  BV110_NWS            52959  com.brixnet.pingactivetest   \n",
       "23019595  BV110_NWS            52959  com.brixnet.pingactivetest   \n",
       "23019596  BV110_NWS            52959  com.brixnet.pingactivetest   \n",
       "23019597  BV110_NWS            52959  com.brixnet.pingactivetest   \n",
       "23019598  BV110_NWS            52959  com.brixnet.pingactivetest   \n",
       "\n",
       "          test_instance_class_id  service.service_id service.service_name  \\\n",
       "50784                      17150                1051            Ping test   \n",
       "50785                      17150                1051            Ping test   \n",
       "50786                      17150                1051            Ping test   \n",
       "50787                      17150                1051            Ping test   \n",
       "50788                      17150                1051            Ping test   \n",
       "...                          ...                 ...                  ...   \n",
       "23019594                   21892                1051            Ping test   \n",
       "23019595                   21892                1051            Ping test   \n",
       "23019596                   21892                1051            Ping test   \n",
       "23019597                   21892                1051            Ping test   \n",
       "23019598                   21892                1051            Ping test   \n",
       "\n",
       "                                   service.service_uri  \\\n",
       "50784     /API/REST/Services/v1/Service/1051/Version/8   \n",
       "50785     /API/REST/Services/v1/Service/1051/Version/8   \n",
       "50786     /API/REST/Services/v1/Service/1051/Version/8   \n",
       "50787     /API/REST/Services/v1/Service/1051/Version/8   \n",
       "50788     /API/REST/Services/v1/Service/1051/Version/8   \n",
       "...                                                ...   \n",
       "23019594  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "23019595  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "23019596  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "23019597  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "23019598  /API/REST/Services/v1/Service/1051/Version/8   \n",
       "\n",
       "          service.service_version service.slt_id target.target_param  \\\n",
       "50784                           8           2171                host   \n",
       "50785                           8           2171                host   \n",
       "50786                           8           2171                host   \n",
       "50787                           8           2171                host   \n",
       "50788                           8           2171                host   \n",
       "...                           ...            ...                 ...   \n",
       "23019594                        8           2171                host   \n",
       "23019595                        8           2171                host   \n",
       "23019596                        8           2171                host   \n",
       "23019597                        8           2171                host   \n",
       "23019598                        8           2171                host   \n",
       "\n",
       "         target.target_value  target                 name  raw_value  score  \\\n",
       "50784                8.8.8.8     NaN   percentLostPackets        0.0  100.0   \n",
       "50785                8.8.8.8     NaN  endToEndDelayMedian    40983.0   78.0   \n",
       "50786                8.8.8.8     NaN               result      100.0  100.0   \n",
       "50787                8.8.8.8     NaN               result      100.0  100.0   \n",
       "50788                8.8.8.8     NaN  endToEndDelayMedian    40959.0   78.0   \n",
       "...                      ...     ...                  ...        ...    ...   \n",
       "23019594       110.78.191.21     NaN  endToEndDelayMedian        NaN    NaN   \n",
       "23019595       110.78.191.21     NaN   percentLostPackets        NaN    NaN   \n",
       "23019596       110.78.191.21     NaN  endToEndDelayMedian        NaN    NaN   \n",
       "23019597       110.78.191.21     NaN   percentLostPackets        NaN    NaN   \n",
       "23019598       110.78.191.21     NaN               result        NaN    NaN   \n",
       "\n",
       "         status.time_stamp_display  \n",
       "50784         12/25/2023 20:00 +07  \n",
       "50785         12/25/2023 20:00 +07  \n",
       "50786         12/25/2023 20:00 +07  \n",
       "50787         12/25/2023 19:00 +07  \n",
       "50788         12/25/2023 19:00 +07  \n",
       "...                            ...  \n",
       "23019594      12/21/2023 18:00 +07  \n",
       "23019595      12/21/2023 18:00 +07  \n",
       "23019596      12/21/2023 17:00 +07  \n",
       "23019597      12/21/2023 17:00 +07  \n",
       "23019598      12/21/2023 17:00 +07  \n",
       "\n",
       "[4935600 rows x 16 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "ping_test = df3.query(\"`service.service_name` == 'Ping test'\").drop([\"status\"],axis=1)\n",
    "ping_test"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "5d42cbdd",
   "metadata": {},
   "outputs": [
    {
     "ename": "ValueError",
     "evalue": "This sheet is too large! Your sheet size is: 4935600, 16 Max sheet size is: 1048576, 16384",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mValueError\u001b[0m                                Traceback (most recent call last)",
      "Input \u001b[0;32mIn [20]\u001b[0m, in \u001b[0;36m<cell line: 1>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0m \u001b[43mping_test\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mto_excel\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[38;5;124;43mping_test.xlsx\u001b[39;49m\u001b[38;5;124;43m\"\u001b[39;49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/util/_decorators.py:211\u001b[0m, in \u001b[0;36mdeprecate_kwarg.<locals>._deprecate_kwarg.<locals>.wrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    209\u001b[0m     \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m    210\u001b[0m         kwargs[new_arg_name] \u001b[38;5;241m=\u001b[39m new_arg_value\n\u001b[0;32m--> 211\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mfunc\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/util/_decorators.py:211\u001b[0m, in \u001b[0;36mdeprecate_kwarg.<locals>._deprecate_kwarg.<locals>.wrapper\u001b[0;34m(*args, **kwargs)\u001b[0m\n\u001b[1;32m    209\u001b[0m     \u001b[38;5;28;01melse\u001b[39;00m:\n\u001b[1;32m    210\u001b[0m         kwargs[new_arg_name] \u001b[38;5;241m=\u001b[39m new_arg_value\n\u001b[0;32m--> 211\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[43mfunc\u001b[49m\u001b[43m(\u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43margs\u001b[49m\u001b[43m,\u001b[49m\u001b[43m \u001b[49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[38;5;241;43m*\u001b[39;49m\u001b[43mkwargs\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/core/generic.py:2374\u001b[0m, in \u001b[0;36mNDFrame.to_excel\u001b[0;34m(self, excel_writer, sheet_name, na_rep, float_format, columns, header, index, index_label, startrow, startcol, engine, merge_cells, encoding, inf_rep, verbose, freeze_panes, storage_options)\u001b[0m\n\u001b[1;32m   2361\u001b[0m \u001b[38;5;28;01mfrom\u001b[39;00m \u001b[38;5;21;01mpandas\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mio\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mformats\u001b[39;00m\u001b[38;5;21;01m.\u001b[39;00m\u001b[38;5;21;01mexcel\u001b[39;00m \u001b[38;5;28;01mimport\u001b[39;00m ExcelFormatter\n\u001b[1;32m   2363\u001b[0m formatter \u001b[38;5;241m=\u001b[39m ExcelFormatter(\n\u001b[1;32m   2364\u001b[0m     df,\n\u001b[1;32m   2365\u001b[0m     na_rep\u001b[38;5;241m=\u001b[39mna_rep,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   2372\u001b[0m     inf_rep\u001b[38;5;241m=\u001b[39minf_rep,\n\u001b[1;32m   2373\u001b[0m )\n\u001b[0;32m-> 2374\u001b[0m \u001b[43mformatter\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mwrite\u001b[49m\u001b[43m(\u001b[49m\n\u001b[1;32m   2375\u001b[0m \u001b[43m    \u001b[49m\u001b[43mexcel_writer\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2376\u001b[0m \u001b[43m    \u001b[49m\u001b[43msheet_name\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43msheet_name\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2377\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstartrow\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstartrow\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2378\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstartcol\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstartcol\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2379\u001b[0m \u001b[43m    \u001b[49m\u001b[43mfreeze_panes\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mfreeze_panes\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2380\u001b[0m \u001b[43m    \u001b[49m\u001b[43mengine\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mengine\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2381\u001b[0m \u001b[43m    \u001b[49m\u001b[43mstorage_options\u001b[49m\u001b[38;5;241;43m=\u001b[39;49m\u001b[43mstorage_options\u001b[49m\u001b[43m,\u001b[49m\n\u001b[1;32m   2382\u001b[0m \u001b[43m\u001b[49m\u001b[43m)\u001b[49m\n",
      "File \u001b[0;32m~/.pyenv/versions/3.10.4/lib/python3.10/site-packages/pandas/io/formats/excel.py:899\u001b[0m, in \u001b[0;36mExcelFormatter.write\u001b[0;34m(self, writer, sheet_name, startrow, startcol, freeze_panes, engine, storage_options)\u001b[0m\n\u001b[1;32m    897\u001b[0m num_rows, num_cols \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mdf\u001b[38;5;241m.\u001b[39mshape\n\u001b[1;32m    898\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m num_rows \u001b[38;5;241m>\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_rows \u001b[38;5;129;01mor\u001b[39;00m num_cols \u001b[38;5;241m>\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_cols:\n\u001b[0;32m--> 899\u001b[0m     \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mValueError\u001b[39;00m(\n\u001b[1;32m    900\u001b[0m         \u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mThis sheet is too large! Your sheet size is: \u001b[39m\u001b[38;5;132;01m{\u001b[39;00mnum_rows\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m, \u001b[39m\u001b[38;5;132;01m{\u001b[39;00mnum_cols\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m \u001b[39m\u001b[38;5;124m\"\u001b[39m\n\u001b[1;32m    901\u001b[0m         \u001b[38;5;124mf\u001b[39m\u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mMax sheet size is: \u001b[39m\u001b[38;5;132;01m{\u001b[39;00m\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_rows\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m, \u001b[39m\u001b[38;5;132;01m{\u001b[39;00m\u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mmax_cols\u001b[38;5;132;01m}\u001b[39;00m\u001b[38;5;124m\"\u001b[39m\n\u001b[1;32m    902\u001b[0m     )\n\u001b[1;32m    904\u001b[0m formatted_cells \u001b[38;5;241m=\u001b[39m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mget_formatted_cells()\n\u001b[1;32m    905\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(writer, ExcelWriter):\n",
      "\u001b[0;31mValueError\u001b[0m: This sheet is too large! Your sheet size is: 4935600, 16 Max sheet size is: 1048576, 16384"
     ]
    }
   ],
   "source": [
    "ping_test.to_excel(\"ping_test.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b79607c9",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "ping_test.dtypes\n",
    "ping_test.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4434b628",
   "metadata": {},
   "outputs": [],
   "source": [
    "ping_test[\"service.service_name\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "f8b637fc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'results_scores': [{'name': 'totalPageDownloadTime',\n",
       "    'raw_value': 255083,\n",
       "    'score': 100},\n",
       "   {'name': 'result', 'raw_value': 100, 'score': 100}],\n",
       "  'score': 100,\n",
       "  'service_id': 1151,\n",
       "  'service_instance_name': 'HTTPS Web Performances',\n",
       "  'service_name': 'HTTPS Web Performances',\n",
       "  'sla_id': 1034,\n",
       "  'sla_name': 'BV110_NMA',\n",
       "  'sla_version': 0,\n",
       "  'sld_id': 4953,\n",
       "  'slt_id': 2157,\n",
       "  'slt_instance_id': 1249,\n",
       "  'slt_version': 6,\n",
       "  'test_instance_id': 53024,\n",
       "  'test_status_calculation_interval': 1800,\n",
       "  'time_stamp': '1703484000000000000',\n",
       "  'time_stamp_display': '12/25/2023 13:00 +07',\n",
       "  'verifier_id': 1009},\n",
       " {'results_scores': [{'name': 'result', 'raw_value': 100, 'score': 100},\n",
       "   {'name': 'totalPageDownloadTime', 'raw_value': 385728, 'score': 100}],\n",
       "  'score': 100,\n",
       "  'service_id': 1151,\n",
       "  'service_instance_name': 'HTTPS Web Performances',\n",
       "  'service_name': 'HTTPS Web Performances',\n",
       "  'sla_id': 1034,\n",
       "  'sla_name': 'BV110_NMA',\n",
       "  'sla_version': 0,\n",
       "  'sld_id': 4953,\n",
       "  'slt_id': 2157,\n",
       "  'slt_instance_id': 1249,\n",
       "  'slt_version': 6,\n",
       "  'test_instance_id': 53024,\n",
       "  'test_status_calculation_interval': 1800,\n",
       "  'time_stamp': '1703376000000000000',\n",
       "  'time_stamp_display': '12/24/2023 07:00 +07',\n",
       "  'verifier_id': 1009},\n",
       " {'results_scores': [{'name': 'result', 'raw_value': 100, 'score': 100},\n",
       "   {'name': 'totalPageDownloadTime', 'raw_value': 298670, 'score': 100}],\n",
       "  'score': 100,\n",
       "  'service_id': 1151,\n",
       "  'service_instance_name': 'HTTPS Web Performances',\n",
       "  'service_name': 'HTTPS Web Performances',\n",
       "  'sla_id': 1034,\n",
       "  'sla_name': 'BV110_NMA',\n",
       "  'sla_version': 0,\n",
       "  'sld_id': 4953,\n",
       "  'slt_id': 2157,\n",
       "  'slt_instance_id': 1249,\n",
       "  'slt_version': 6,\n",
       "  'test_instance_id': 53024,\n",
       "  'test_status_calculation_interval': 1800,\n",
       "  'time_stamp': '1703268000000000000',\n",
       "  'time_stamp_display': '12/23/2023 01:00 +07',\n",
       "  'verifier_id': 1009},\n",
       " {'results_scores': [{'name': 'totalPageDownloadTime',\n",
       "    'raw_value': 295973,\n",
       "    'score': 100},\n",
       "   {'name': 'result', 'raw_value': 100, 'score': 100}],\n",
       "  'score': 100,\n",
       "  'service_id': 1151,\n",
       "  'service_instance_name': 'HTTPS Web Performances',\n",
       "  'service_name': 'HTTPS Web Performances',\n",
       "  'sla_id': 1034,\n",
       "  'sla_name': 'BV110_NMA',\n",
       "  'sla_version': 0,\n",
       "  'sld_id': 4953,\n",
       "  'slt_id': 2157,\n",
       "  'slt_instance_id': 1249,\n",
       "  'slt_version': 6,\n",
       "  'test_instance_id': 53024,\n",
       "  'test_status_calculation_interval': 1800,\n",
       "  'time_stamp': '1703160000000000000',\n",
       "  'time_stamp_display': '12/21/2023 19:00 +07',\n",
       "  'verifier_id': 1009},\n",
       " {'results_scores': [{'name': 'result', 'raw_value': 100, 'score': 100},\n",
       "   {'name': 'totalPageDownloadTime', 'raw_value': 159730, 'score': 100}],\n",
       "  'score': 100,\n",
       "  'service_id': 1151,\n",
       "  'service_instance_name': 'HTTPS Web Performances',\n",
       "  'service_name': 'HTTPS Web Performances',\n",
       "  'sla_id': 1034,\n",
       "  'sla_name': 'BV110_NMA',\n",
       "  'sla_version': 0,\n",
       "  'sld_id': 4953,\n",
       "  'slt_id': 2157,\n",
       "  'slt_instance_id': 1249,\n",
       "  'slt_version': 6,\n",
       "  'test_instance_id': 53024,\n",
       "  'test_status_calculation_interval': 1800,\n",
       "  'time_stamp': '1703052000000000000',\n",
       "  'time_stamp_display': '12/20/2023 13:00 +07',\n",
       "  'verifier_id': 1009},\n",
       " {'results_scores': [{'name': 'totalPageDownloadTime',\n",
       "    'raw_value': 163513,\n",
       "    'score': 100},\n",
       "   {'name': 'result', 'raw_value': 100, 'score': 100}],\n",
       "  'score': 100,\n",
       "  'service_id': 1151,\n",
       "  'service_instance_name': 'HTTPS Web Performances',\n",
       "  'service_name': 'HTTPS Web Performances',\n",
       "  'sla_id': 1034,\n",
       "  'sla_name': 'BV110_NMA',\n",
       "  'sla_version': 0,\n",
       "  'sld_id': 4953,\n",
       "  'slt_id': 2157,\n",
       "  'slt_instance_id': 1249,\n",
       "  'slt_version': 6,\n",
       "  'test_instance_id': 53024,\n",
       "  'test_status_calculation_interval': 1800,\n",
       "  'time_stamp': '1702944000000000000',\n",
       "  'time_stamp_display': '12/19/2023 07:00 +07',\n",
       "  'verifier_id': 1009}]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3['status'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "c88afc9a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "sla_name                      object\n",
       "test_instance_id              object\n",
       "type_type_name                object\n",
       "test_instance_class_id         int64\n",
       "status                        object\n",
       "service.service_id             int64\n",
       "service.service_name          object\n",
       "service.service_uri           object\n",
       "service.service_version        int64\n",
       "service.slt_id                object\n",
       "target.target_param           object\n",
       "target.target_value           object\n",
       "target                       float64\n",
       "name                          object\n",
       "raw_value                    float64\n",
       "score                        float64\n",
       "status.time_stamp_display     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "e77f5152",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>status</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>255083.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>385728.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/23/2023 01:00 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512650</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512651</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512652</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512653</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512654</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23512655 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           sla_name test_instance_id  \\\n",
       "0                                         BV110_NMA            53024   \n",
       "1                                         BV110_NMA            53024   \n",
       "2                                         BV110_NMA            53024   \n",
       "3                                         BV110_NMA            53024   \n",
       "4                                         BV110_NMA            53024   \n",
       "...                                             ...              ...   \n",
       "23512650  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512651  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512652  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512653  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512654  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "\n",
       "                            type_type_name  test_instance_class_id  \\\n",
       "0         com.brixnet.securehttpactivetest                   17138   \n",
       "1         com.brixnet.securehttpactivetest                   17138   \n",
       "2         com.brixnet.securehttpactivetest                   17138   \n",
       "3         com.brixnet.securehttpactivetest                   17138   \n",
       "4         com.brixnet.securehttpactivetest                   17138   \n",
       "...                                    ...                     ...   \n",
       "23512650        com.brixnet.pingactivetest                   48425   \n",
       "23512651        com.brixnet.pingactivetest                   48425   \n",
       "23512652        com.brixnet.pingactivetest                   48425   \n",
       "23512653        com.brixnet.pingactivetest                   48425   \n",
       "23512654        com.brixnet.pingactivetest                   48425   \n",
       "\n",
       "                                                     status  \\\n",
       "0         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "1         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "2         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "3         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "4         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "...                                                     ...   \n",
       "23512650                                                 []   \n",
       "23512651                                                 []   \n",
       "23512652                                                 []   \n",
       "23512653                                                 []   \n",
       "23512654                                                 []   \n",
       "\n",
       "          service.service_id               service.service_name  \\\n",
       "0                       1151             HTTPS Web Performances   \n",
       "1                       1151             HTTPS Web Performances   \n",
       "2                       1151             HTTPS Web Performances   \n",
       "3                       1151             HTTPS Web Performances   \n",
       "4                       1151             HTTPS Web Performances   \n",
       "...                      ...                                ...   \n",
       "23512650                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512651                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512652                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512653                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512654                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "\n",
       "                                    service.service_uri  \\\n",
       "0          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "1          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "2          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "3          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "4          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "...                                                 ...   \n",
       "23512650  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512651  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512652  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512653  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512654  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "\n",
       "          service.service_version service.slt_id target.target_param  \\\n",
       "0                               6           2157                 url   \n",
       "1                               6           2157                 url   \n",
       "2                               6           2157                 url   \n",
       "3                               6           2157                 url   \n",
       "4                               6           2157                 url   \n",
       "...                           ...            ...                 ...   \n",
       "23512650                       16           2631                host   \n",
       "23512651                       16           2631                host   \n",
       "23512652                       16           2631                host   \n",
       "23512653                       16           2631                host   \n",
       "23512654                       16           2631                host   \n",
       "\n",
       "         target.target_value  target                   name  raw_value  score  \\\n",
       "0             www.sanook.com     NaN  totalPageDownloadTime   255083.0  100.0   \n",
       "1             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "2             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "3             www.sanook.com     NaN  totalPageDownloadTime   385728.0  100.0   \n",
       "4             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "...                      ...     ...                    ...        ...    ...   \n",
       "23512650        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512651        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512652        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512653        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512654        159.192.3.60     NaN     percentLostPackets        NaN    NaN   \n",
       "\n",
       "         status.time_stamp_display  \n",
       "0             12/25/2023 13:00 +07  \n",
       "1             12/25/2023 13:00 +07  \n",
       "2             12/24/2023 07:00 +07  \n",
       "3             12/24/2023 07:00 +07  \n",
       "4             12/23/2023 01:00 +07  \n",
       "...                            ...  \n",
       "23512650      12/25/2023 20:20 +07  \n",
       "23512651      12/25/2023 20:20 +07  \n",
       "23512652      12/25/2023 20:20 +07  \n",
       "23512653      12/25/2023 20:20 +07  \n",
       "23512654      12/25/2023 20:20 +07  \n",
       "\n",
       "[23512655 rows x 17 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "4988e295",
   "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>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>status</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "      <th>value_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>255083.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "      <td>255083.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "      <td>100.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "      <td>100.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>385728.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "      <td>385728.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/23/2023 01:00 +07</td>\n",
       "      <td>100.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512650</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512651</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512652</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512653</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512654</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23512655 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           sla_name test_instance_id  \\\n",
       "0                                         BV110_NMA            53024   \n",
       "1                                         BV110_NMA            53024   \n",
       "2                                         BV110_NMA            53024   \n",
       "3                                         BV110_NMA            53024   \n",
       "4                                         BV110_NMA            53024   \n",
       "...                                             ...              ...   \n",
       "23512650  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512651  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512652  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512653  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512654  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "\n",
       "                            type_type_name  test_instance_class_id  \\\n",
       "0         com.brixnet.securehttpactivetest                   17138   \n",
       "1         com.brixnet.securehttpactivetest                   17138   \n",
       "2         com.brixnet.securehttpactivetest                   17138   \n",
       "3         com.brixnet.securehttpactivetest                   17138   \n",
       "4         com.brixnet.securehttpactivetest                   17138   \n",
       "...                                    ...                     ...   \n",
       "23512650        com.brixnet.pingactivetest                   48425   \n",
       "23512651        com.brixnet.pingactivetest                   48425   \n",
       "23512652        com.brixnet.pingactivetest                   48425   \n",
       "23512653        com.brixnet.pingactivetest                   48425   \n",
       "23512654        com.brixnet.pingactivetest                   48425   \n",
       "\n",
       "                                                     status  \\\n",
       "0         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "1         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "2         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "3         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "4         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "...                                                     ...   \n",
       "23512650                                                 []   \n",
       "23512651                                                 []   \n",
       "23512652                                                 []   \n",
       "23512653                                                 []   \n",
       "23512654                                                 []   \n",
       "\n",
       "          service.service_id               service.service_name  \\\n",
       "0                       1151             HTTPS Web Performances   \n",
       "1                       1151             HTTPS Web Performances   \n",
       "2                       1151             HTTPS Web Performances   \n",
       "3                       1151             HTTPS Web Performances   \n",
       "4                       1151             HTTPS Web Performances   \n",
       "...                      ...                                ...   \n",
       "23512650                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512651                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512652                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512653                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512654                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "\n",
       "                                    service.service_uri  \\\n",
       "0          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "1          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "2          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "3          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "4          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "...                                                 ...   \n",
       "23512650  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512651  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512652  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512653  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512654  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "\n",
       "          service.service_version service.slt_id target.target_param  \\\n",
       "0                               6           2157                 url   \n",
       "1                               6           2157                 url   \n",
       "2                               6           2157                 url   \n",
       "3                               6           2157                 url   \n",
       "4                               6           2157                 url   \n",
       "...                           ...            ...                 ...   \n",
       "23512650                       16           2631                host   \n",
       "23512651                       16           2631                host   \n",
       "23512652                       16           2631                host   \n",
       "23512653                       16           2631                host   \n",
       "23512654                       16           2631                host   \n",
       "\n",
       "         target.target_value  target                   name  raw_value  score  \\\n",
       "0             www.sanook.com     NaN  totalPageDownloadTime   255083.0  100.0   \n",
       "1             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "2             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "3             www.sanook.com     NaN  totalPageDownloadTime   385728.0  100.0   \n",
       "4             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "...                      ...     ...                    ...        ...    ...   \n",
       "23512650        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512651        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512652        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512653        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512654        159.192.3.60     NaN     percentLostPackets        NaN    NaN   \n",
       "\n",
       "         status.time_stamp_display     value_score  \n",
       "0             12/25/2023 13:00 +07  255083.0/100.0  \n",
       "1             12/25/2023 13:00 +07     100.0/100.0  \n",
       "2             12/24/2023 07:00 +07     100.0/100.0  \n",
       "3             12/24/2023 07:00 +07  385728.0/100.0  \n",
       "4             12/23/2023 01:00 +07     100.0/100.0  \n",
       "...                            ...             ...  \n",
       "23512650      12/25/2023 20:20 +07             NaN  \n",
       "23512651      12/25/2023 20:20 +07             NaN  \n",
       "23512652      12/25/2023 20:20 +07             NaN  \n",
       "23512653      12/25/2023 20:20 +07             NaN  \n",
       "23512654      12/25/2023 20:20 +07             NaN  \n",
       "\n",
       "[23512655 rows x 18 columns]"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3[\"value_score\"] = df[[\"raw_value\",\"score\"]].astype(str).agg(\"/\".join, axis=1)\n",
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "1fbd6b17",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>status</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "      <th>value_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>255083.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "      <td>255083.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/25/2023 13:00 +07</td>\n",
       "      <td>100.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "      <td>100.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>totalPageDownloadTime</td>\n",
       "      <td>385728.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/24/2023 07:00 +07</td>\n",
       "      <td>385728.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BV110_NMA</td>\n",
       "      <td>53024</td>\n",
       "      <td>com.brixnet.securehttpactivetest</td>\n",
       "      <td>17138</td>\n",
       "      <td>[{'results_scores': [{'name': 'totalPageDownlo...</td>\n",
       "      <td>1151</td>\n",
       "      <td>HTTPS Web Performances</td>\n",
       "      <td>/API/REST/Services/v1/Service/1151/Version/6</td>\n",
       "      <td>6</td>\n",
       "      <td>2157</td>\n",
       "      <td>url</td>\n",
       "      <td>www.sanook.com</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>100.0</td>\n",
       "      <td>100.0</td>\n",
       "      <td>12/23/2023 01:00 +07</td>\n",
       "      <td>100.0/100.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512650</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512651</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512652</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512653</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512654</th>\n",
       "      <td>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</td>\n",
       "      <td>56066</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>48425</td>\n",
       "      <td>[]</td>\n",
       "      <td>1375</td>\n",
       "      <td>Ping catspeedtest (Public-VLAN20)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1375/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2631</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:20 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>23512655 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           sla_name test_instance_id  \\\n",
       "0                                         BV110_NMA            53024   \n",
       "1                                         BV110_NMA            53024   \n",
       "2                                         BV110_NMA            53024   \n",
       "3                                         BV110_NMA            53024   \n",
       "4                                         BV110_NMA            53024   \n",
       "...                                             ...              ...   \n",
       "23512650  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512651  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512652  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512653  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "23512654  POC-Expansion-SLA_BRAS_88_Public (VLAN20)            56066   \n",
       "\n",
       "                            type_type_name  test_instance_class_id  \\\n",
       "0         com.brixnet.securehttpactivetest                   17138   \n",
       "1         com.brixnet.securehttpactivetest                   17138   \n",
       "2         com.brixnet.securehttpactivetest                   17138   \n",
       "3         com.brixnet.securehttpactivetest                   17138   \n",
       "4         com.brixnet.securehttpactivetest                   17138   \n",
       "...                                    ...                     ...   \n",
       "23512650        com.brixnet.pingactivetest                   48425   \n",
       "23512651        com.brixnet.pingactivetest                   48425   \n",
       "23512652        com.brixnet.pingactivetest                   48425   \n",
       "23512653        com.brixnet.pingactivetest                   48425   \n",
       "23512654        com.brixnet.pingactivetest                   48425   \n",
       "\n",
       "                                                     status  \\\n",
       "0         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "1         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "2         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "3         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "4         [{'results_scores': [{'name': 'totalPageDownlo...   \n",
       "...                                                     ...   \n",
       "23512650                                                 []   \n",
       "23512651                                                 []   \n",
       "23512652                                                 []   \n",
       "23512653                                                 []   \n",
       "23512654                                                 []   \n",
       "\n",
       "          service.service_id               service.service_name  \\\n",
       "0                       1151             HTTPS Web Performances   \n",
       "1                       1151             HTTPS Web Performances   \n",
       "2                       1151             HTTPS Web Performances   \n",
       "3                       1151             HTTPS Web Performances   \n",
       "4                       1151             HTTPS Web Performances   \n",
       "...                      ...                                ...   \n",
       "23512650                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512651                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512652                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512653                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "23512654                1375  Ping catspeedtest (Public-VLAN20)   \n",
       "\n",
       "                                    service.service_uri  \\\n",
       "0          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "1          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "2          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "3          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "4          /API/REST/Services/v1/Service/1151/Version/6   \n",
       "...                                                 ...   \n",
       "23512650  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512651  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512652  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512653  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "23512654  /API/REST/Services/v1/Service/1375/Version/16   \n",
       "\n",
       "          service.service_version service.slt_id target.target_param  \\\n",
       "0                               6           2157                 url   \n",
       "1                               6           2157                 url   \n",
       "2                               6           2157                 url   \n",
       "3                               6           2157                 url   \n",
       "4                               6           2157                 url   \n",
       "...                           ...            ...                 ...   \n",
       "23512650                       16           2631                host   \n",
       "23512651                       16           2631                host   \n",
       "23512652                       16           2631                host   \n",
       "23512653                       16           2631                host   \n",
       "23512654                       16           2631                host   \n",
       "\n",
       "         target.target_value  target                   name  raw_value  score  \\\n",
       "0             www.sanook.com     NaN  totalPageDownloadTime   255083.0  100.0   \n",
       "1             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "2             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "3             www.sanook.com     NaN  totalPageDownloadTime   385728.0  100.0   \n",
       "4             www.sanook.com     NaN                 result      100.0  100.0   \n",
       "...                      ...     ...                    ...        ...    ...   \n",
       "23512650        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512651        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512652        159.192.3.60     NaN                 result        NaN    NaN   \n",
       "23512653        159.192.3.60     NaN    endToEndDelayMedian        NaN    NaN   \n",
       "23512654        159.192.3.60     NaN     percentLostPackets        NaN    NaN   \n",
       "\n",
       "         status.time_stamp_display     value_score  \n",
       "0             12/25/2023 13:00 +07  255083.0/100.0  \n",
       "1             12/25/2023 13:00 +07     100.0/100.0  \n",
       "2             12/24/2023 07:00 +07     100.0/100.0  \n",
       "3             12/24/2023 07:00 +07  385728.0/100.0  \n",
       "4             12/23/2023 01:00 +07     100.0/100.0  \n",
       "...                            ...             ...  \n",
       "23512650      12/25/2023 20:20 +07             NaN  \n",
       "23512651      12/25/2023 20:20 +07             NaN  \n",
       "23512652      12/25/2023 20:20 +07             NaN  \n",
       "23512653      12/25/2023 20:20 +07             NaN  \n",
       "23512654      12/25/2023 20:20 +07             NaN  \n",
       "\n",
       "[23512655 rows x 18 columns]"
      ]
     },
     "execution_count": 44,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "5d2ff574",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "          sla_name test_instance_id              type_type_name  \\\n",
      "5019318  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
      "5019319  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
      "5019320  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
      "5019321  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
      "5019322  BV110_RBI            52952  com.brixnet.pingactivetest   \n",
      "...            ...              ...                         ...   \n",
      "6776689  BV110_RBI            52983  com.brixnet.pingactivetest   \n",
      "6776690  BV110_RBI            52983  com.brixnet.pingactivetest   \n",
      "6776691  BV110_RBI            52983  com.brixnet.pingactivetest   \n",
      "6776692  BV110_RBI            52983  com.brixnet.pingactivetest   \n",
      "6776693  BV110_RBI            52983  com.brixnet.pingactivetest   \n",
      "\n",
      "         test_instance_class_id  \\\n",
      "5019318                    1554   \n",
      "5019319                    1554   \n",
      "5019320                    1554   \n",
      "5019321                    1554   \n",
      "5019322                    1554   \n",
      "...                         ...   \n",
      "6776689                   52983   \n",
      "6776690                   52983   \n",
      "6776691                   52983   \n",
      "6776692                   52983   \n",
      "6776693                   52983   \n",
      "\n",
      "                                                    status  \\\n",
      "5019318  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "5019319  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "5019320  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "5019321  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "5019322  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "...                                                    ...   \n",
      "6776689  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "6776690  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "6776691  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "6776692  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "6776693  [{'results_scores': [{'name': 'result', 'raw_v...   \n",
      "\n",
      "         service.service_id service.service_name  \\\n",
      "5019318                1051            Ping test   \n",
      "5019319                1051            Ping test   \n",
      "5019320                1051            Ping test   \n",
      "5019321                1051            Ping test   \n",
      "5019322                1051            Ping test   \n",
      "...                     ...                  ...   \n",
      "6776689                1327  Ping PNOC Speedtest   \n",
      "6776690                1327  Ping PNOC Speedtest   \n",
      "6776691                1327  Ping PNOC Speedtest   \n",
      "6776692                1327  Ping PNOC Speedtest   \n",
      "6776693                1327  Ping PNOC Speedtest   \n",
      "\n",
      "                                  service.service_uri  \\\n",
      "5019318  /API/REST/Services/v1/Service/1051/Version/8   \n",
      "5019319  /API/REST/Services/v1/Service/1051/Version/8   \n",
      "5019320  /API/REST/Services/v1/Service/1051/Version/8   \n",
      "5019321  /API/REST/Services/v1/Service/1051/Version/8   \n",
      "5019322  /API/REST/Services/v1/Service/1051/Version/8   \n",
      "...                                               ...   \n",
      "6776689  /API/REST/Services/v1/Service/1327/Version/6   \n",
      "6776690  /API/REST/Services/v1/Service/1327/Version/6   \n",
      "6776691  /API/REST/Services/v1/Service/1327/Version/6   \n",
      "6776692  /API/REST/Services/v1/Service/1327/Version/6   \n",
      "6776693  /API/REST/Services/v1/Service/1327/Version/6   \n",
      "\n",
      "         service.service_version service.slt_id target.target_param  \\\n",
      "5019318                        8           2171                host   \n",
      "5019319                        8           2171                host   \n",
      "5019320                        8           2171                host   \n",
      "5019321                        8           2171                host   \n",
      "5019322                        8           2171                host   \n",
      "...                          ...            ...                 ...   \n",
      "6776689                        6           2606                host   \n",
      "6776690                        6           2606                host   \n",
      "6776691                        6           2606                host   \n",
      "6776692                        6           2606                host   \n",
      "6776693                        6           2606                host   \n",
      "\n",
      "        target.target_value  target                 name  raw_value  score  \\\n",
      "5019318             8.8.8.8     NaN               result        NaN    NaN   \n",
      "5019319             8.8.8.8     NaN   percentLostPackets        NaN    NaN   \n",
      "5019320             8.8.8.8     NaN  endToEndDelayMedian        NaN    NaN   \n",
      "5019321             8.8.8.8     NaN               result      100.0  100.0   \n",
      "5019322             8.8.8.8     NaN   percentLostPackets        0.0  100.0   \n",
      "...                     ...     ...                  ...        ...    ...   \n",
      "6776689        159.192.3.60     NaN  endToEndDelayMedian        NaN    NaN   \n",
      "6776690        159.192.3.60     NaN   percentLostPackets        NaN    NaN   \n",
      "6776691        159.192.3.60     NaN               result      100.0  100.0   \n",
      "6776692        159.192.3.60     NaN   percentLostPackets        0.0  100.0   \n",
      "6776693        159.192.3.60     NaN  endToEndDelayMedian     3411.5  100.0   \n",
      "\n",
      "        status.time_stamp_display value_score  \n",
      "5019318      12/25/2023 20:00 +07         NaN  \n",
      "5019319      12/25/2023 20:00 +07         NaN  \n",
      "5019320      12/25/2023 20:00 +07         NaN  \n",
      "5019321      12/25/2023 19:00 +07         NaN  \n",
      "5019322      12/25/2023 19:00 +07         NaN  \n",
      "...                           ...         ...  \n",
      "6776689      12/24/2023 19:45 +07         NaN  \n",
      "6776690      12/24/2023 19:45 +07         NaN  \n",
      "6776691      12/24/2023 19:30 +07         NaN  \n",
      "6776692      12/24/2023 19:30 +07         NaN  \n",
      "6776693      12/24/2023 19:30 +07         NaN  \n",
      "\n",
      "[1757376 rows x 18 columns]\n",
      "['BV110_NMA' 'BV110_PLK' 'BV110_KKN' 'BV110_RBI' 'BV110_HYI' 'BV110_SNI'\n",
      " 'BV1100_BRK' 'BV110_PTY' 'ATP-Expansion BRIX' 'BV110_CMI' 'BV110_NWS'\n",
      " 'POC-Expansion-SLA_BNG_144_Private (VLAN10)'\n",
      " 'POC-Expansion-SLA_BRAS_88_Public (VLAN20)']\n"
     ]
    }
   ],
   "source": [
    "print(df3.query(\"sla_name == 'BV110_RBI'\"))\n",
    "print(df3[\"sla_name\"].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "f32b91c3",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>sla_name</th>\n",
       "      <th>test_instance_id</th>\n",
       "      <th>type_type_name</th>\n",
       "      <th>test_instance_class_id</th>\n",
       "      <th>status</th>\n",
       "      <th>service.service_id</th>\n",
       "      <th>service.service_name</th>\n",
       "      <th>service.service_uri</th>\n",
       "      <th>service.service_version</th>\n",
       "      <th>service.slt_id</th>\n",
       "      <th>target.target_param</th>\n",
       "      <th>target.target_value</th>\n",
       "      <th>target</th>\n",
       "      <th>name</th>\n",
       "      <th>raw_value</th>\n",
       "      <th>score</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "      <th>value_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>23512079</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56068</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>30286</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>ntspeedtest.net</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512080</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56068</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>30286</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>ntspeedtest.net</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512081</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56068</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>30286</td>\n",
       "      <td>[{'results_scores': [{'name': 'percentLostPack...</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>ntspeedtest.net</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512082</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56068</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>30286</td>\n",
       "      <td>[]</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>ntspeedtest.net</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512083</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56068</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>30286</td>\n",
       "      <td>[]</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>ntspeedtest.net</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512164</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56069</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>44133</td>\n",
       "      <td>[]</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512165</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56069</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>44133</td>\n",
       "      <td>[]</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512166</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56069</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>44133</td>\n",
       "      <td>[]</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>result</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512167</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56069</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>44133</td>\n",
       "      <td>[]</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>percentLostPackets</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23512168</th>\n",
       "      <td>POC-Expansion-SLA_BNG_144_Private (VLAN10)</td>\n",
       "      <td>56069</td>\n",
       "      <td>com.brixnet.pingactivetest</td>\n",
       "      <td>44133</td>\n",
       "      <td>[]</td>\n",
       "      <td>1376</td>\n",
       "      <td>Ping catspeedtest (Private-VLAN10)</td>\n",
       "      <td>/API/REST/Services/v1/Service/1376/Version/16</td>\n",
       "      <td>16</td>\n",
       "      <td>2582</td>\n",
       "      <td>host</td>\n",
       "      <td>159.192.3.60</td>\n",
       "      <td>NaN</td>\n",
       "      <td>endToEndDelayMedian</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>12/25/2023 20:40 +07</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>90 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                            sla_name test_instance_id  \\\n",
       "23512079  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56068   \n",
       "23512080  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56068   \n",
       "23512081  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56068   \n",
       "23512082  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56068   \n",
       "23512083  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56068   \n",
       "...                                              ...              ...   \n",
       "23512164  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56069   \n",
       "23512165  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56069   \n",
       "23512166  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56069   \n",
       "23512167  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56069   \n",
       "23512168  POC-Expansion-SLA_BNG_144_Private (VLAN10)            56069   \n",
       "\n",
       "                      type_type_name  test_instance_class_id  \\\n",
       "23512079  com.brixnet.pingactivetest                   30286   \n",
       "23512080  com.brixnet.pingactivetest                   30286   \n",
       "23512081  com.brixnet.pingactivetest                   30286   \n",
       "23512082  com.brixnet.pingactivetest                   30286   \n",
       "23512083  com.brixnet.pingactivetest                   30286   \n",
       "...                              ...                     ...   \n",
       "23512164  com.brixnet.pingactivetest                   44133   \n",
       "23512165  com.brixnet.pingactivetest                   44133   \n",
       "23512166  com.brixnet.pingactivetest                   44133   \n",
       "23512167  com.brixnet.pingactivetest                   44133   \n",
       "23512168  com.brixnet.pingactivetest                   44133   \n",
       "\n",
       "                                                     status  \\\n",
       "23512079  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "23512080  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "23512081  [{'results_scores': [{'name': 'percentLostPack...   \n",
       "23512082                                                 []   \n",
       "23512083                                                 []   \n",
       "...                                                     ...   \n",
       "23512164                                                 []   \n",
       "23512165                                                 []   \n",
       "23512166                                                 []   \n",
       "23512167                                                 []   \n",
       "23512168                                                 []   \n",
       "\n",
       "          service.service_id                service.service_name  \\\n",
       "23512079                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512080                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512081                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512082                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512083                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "...                      ...                                 ...   \n",
       "23512164                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512165                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512166                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512167                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "23512168                1376  Ping catspeedtest (Private-VLAN10)   \n",
       "\n",
       "                                    service.service_uri  \\\n",
       "23512079  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512080  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512081  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512082  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512083  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "...                                                 ...   \n",
       "23512164  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512165  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512166  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512167  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "23512168  /API/REST/Services/v1/Service/1376/Version/16   \n",
       "\n",
       "          service.service_version service.slt_id target.target_param  \\\n",
       "23512079                       16           2582                host   \n",
       "23512080                       16           2582                host   \n",
       "23512081                       16           2582                host   \n",
       "23512082                       16           2582                host   \n",
       "23512083                       16           2582                host   \n",
       "...                           ...            ...                 ...   \n",
       "23512164                       16           2582                host   \n",
       "23512165                       16           2582                host   \n",
       "23512166                       16           2582                host   \n",
       "23512167                       16           2582                host   \n",
       "23512168                       16           2582                host   \n",
       "\n",
       "         target.target_value  target                 name  raw_value  score  \\\n",
       "23512079     ntspeedtest.net     NaN   percentLostPackets        NaN    NaN   \n",
       "23512080     ntspeedtest.net     NaN  endToEndDelayMedian        NaN    NaN   \n",
       "23512081     ntspeedtest.net     NaN               result        NaN    NaN   \n",
       "23512082     ntspeedtest.net     NaN   percentLostPackets        NaN    NaN   \n",
       "23512083     ntspeedtest.net     NaN  endToEndDelayMedian        NaN    NaN   \n",
       "...                      ...     ...                  ...        ...    ...   \n",
       "23512164        159.192.3.60     NaN   percentLostPackets        NaN    NaN   \n",
       "23512165        159.192.3.60     NaN  endToEndDelayMedian        NaN    NaN   \n",
       "23512166        159.192.3.60     NaN               result        NaN    NaN   \n",
       "23512167        159.192.3.60     NaN   percentLostPackets        NaN    NaN   \n",
       "23512168        159.192.3.60     NaN  endToEndDelayMedian        NaN    NaN   \n",
       "\n",
       "         status.time_stamp_display value_score  \n",
       "23512079      12/25/2023 20:40 +07         NaN  \n",
       "23512080      12/25/2023 20:40 +07         NaN  \n",
       "23512081      12/25/2023 20:40 +07         NaN  \n",
       "23512082      12/25/2023 20:40 +07         NaN  \n",
       "23512083      12/25/2023 20:40 +07         NaN  \n",
       "...                            ...         ...  \n",
       "23512164      12/25/2023 20:40 +07         NaN  \n",
       "23512165      12/25/2023 20:40 +07         NaN  \n",
       "23512166      12/25/2023 20:40 +07         NaN  \n",
       "23512167      12/25/2023 20:40 +07         NaN  \n",
       "23512168      12/25/2023 20:40 +07         NaN  \n",
       "\n",
       "[90 rows x 18 columns]"
      ]
     },
     "execution_count": 46,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df4 = df3.query(\"sla_name in ('POC-Expansion-SLA_BRAS_88_Private (VLAN10)','POC-Expansion-SLA_BNG_144_Public (VLAN20)','POC-Expansion-SLA_BNG_144_Private (VLAN10)')\")\n",
    "df4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "da506b94",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['BV110_NMA', 'BV110_PLK', 'BV110_KKN', 'BV110_RBI', 'BV110_HYI',\n",
       "       'BV110_SNI', 'BV1100_BRK', 'BV110_PTY', 'ATP-Expansion BRIX',\n",
       "       'BV110_CMI', 'BV110_NWS',\n",
       "       'POC-Expansion-SLA_BNG_144_Private (VLAN10)',\n",
       "       'POC-Expansion-SLA_BRAS_88_Public (VLAN20)'], dtype=object)"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df3['sla_name'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "e3a9645f",
   "metadata": {
    "scrolled": false
   },
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th colspan=\"21\" halign=\"left\">raw_value</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>service.service_name</th>\n",
       "      <th colspan=\"10\" halign=\"left\">DNS Test (Private-VLAN10)</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"2\" halign=\"left\">Traceroute (Private-VLAN10)</th>\n",
       "      <th colspan=\"6\" halign=\"left\">Traceroute test</th>\n",
       "      <th colspan=\"2\" halign=\"left\">UDP Echo (Private-VLAN10)</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>target.target_value</th>\n",
       "      <th colspan=\"2\" halign=\"left\">1.1.1.1</th>\n",
       "      <th colspan=\"2\" halign=\"left\">110.78.191.20</th>\n",
       "      <th colspan=\"2\" halign=\"left\">110.78.191.21</th>\n",
       "      <th colspan=\"2\" halign=\"left\">159.192.32.20</th>\n",
       "      <th colspan=\"2\" halign=\"left\">8.8.8.8</th>\n",
       "      <th>...</th>\n",
       "      <th colspan=\"2\" halign=\"left\">8.8.8.8</th>\n",
       "      <th colspan=\"3\" halign=\"left\">110.78.191.20</th>\n",
       "      <th colspan=\"3\" halign=\"left\">8.8.8.8</th>\n",
       "      <th colspan=\"2\" halign=\"left\">10.0.0.8</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>name</th>\n",
       "      <th>responseTime</th>\n",
       "      <th>result</th>\n",
       "      <th>responseTime</th>\n",
       "      <th>result</th>\n",
       "      <th>responseTime</th>\n",
       "      <th>result</th>\n",
       "      <th>responseTime</th>\n",
       "      <th>result</th>\n",
       "      <th>responseTime</th>\n",
       "      <th>result</th>\n",
       "      <th>...</th>\n",
       "      <th>hopCountDest</th>\n",
       "      <th>result</th>\n",
       "      <th>EEDMedianDest</th>\n",
       "      <th>hopCountDest</th>\n",
       "      <th>result</th>\n",
       "      <th>EEDMedianDest</th>\n",
       "      <th>hopCountDest</th>\n",
       "      <th>result</th>\n",
       "      <th>lostPackets</th>\n",
       "      <th>result</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>sla_name</th>\n",
       "      <th>status.time_stamp_display</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <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 rowspan=\"5\" valign=\"top\">ATP-Expansion BRIX</th>\n",
       "      <th>12/24/2023 11:00 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12/24/2023 11:20 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12/24/2023 11:40 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12/24/2023 12:00 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12/24/2023 12:20 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th rowspan=\"3\" valign=\"top\">BV110_SNI</th>\n",
       "      <th>12/23/2023 05:00 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12/23/2023 16:00 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12/23/2023 21:00 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POC-Expansion-SLA_BNG_144_Private (VLAN10)</th>\n",
       "      <th>12/25/2023 20:40 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>POC-Expansion-SLA_BRAS_88_Public (VLAN20)</th>\n",
       "      <th>12/25/2023 20:20 +07</th>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1781 rows × 128 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                     raw_value  \\\n",
       "service.service_name                                                 DNS Test (Private-VLAN10)   \n",
       "target.target_value                                                                    1.1.1.1   \n",
       "name                                                                              responseTime   \n",
       "sla_name                                   status.time_stamp_display                             \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                            NaN   \n",
       "                                           12/24/2023 11:20 +07                            NaN   \n",
       "                                           12/24/2023 11:40 +07                            NaN   \n",
       "                                           12/24/2023 12:00 +07                            NaN   \n",
       "                                           12/24/2023 12:20 +07                            NaN   \n",
       "...                                                                                        ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                            NaN   \n",
       "                                           12/23/2023 16:00 +07                            NaN   \n",
       "                                           12/23/2023 21:00 +07                            NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                            NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                            NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                                    \\\n",
       "service.service_name                                                                 \n",
       "target.target_value                                                  110.78.191.20   \n",
       "name                                                                  responseTime   \n",
       "sla_name                                   status.time_stamp_display                 \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                NaN   \n",
       "                                           12/24/2023 11:20 +07                NaN   \n",
       "                                           12/24/2023 11:40 +07                NaN   \n",
       "                                           12/24/2023 12:00 +07                NaN   \n",
       "                                           12/24/2023 12:20 +07                NaN   \n",
       "...                                                                            ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                NaN   \n",
       "                                           12/23/2023 16:00 +07                NaN   \n",
       "                                           12/23/2023 21:00 +07                NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                                    \\\n",
       "service.service_name                                                                 \n",
       "target.target_value                                                  110.78.191.21   \n",
       "name                                                                  responseTime   \n",
       "sla_name                                   status.time_stamp_display                 \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                NaN   \n",
       "                                           12/24/2023 11:20 +07                NaN   \n",
       "                                           12/24/2023 11:40 +07                NaN   \n",
       "                                           12/24/2023 12:00 +07                NaN   \n",
       "                                           12/24/2023 12:20 +07                NaN   \n",
       "...                                                                            ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                NaN   \n",
       "                                           12/23/2023 16:00 +07                NaN   \n",
       "                                           12/23/2023 21:00 +07                NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                                    \\\n",
       "service.service_name                                                                 \n",
       "target.target_value                                                  159.192.32.20   \n",
       "name                                                                  responseTime   \n",
       "sla_name                                   status.time_stamp_display                 \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                NaN   \n",
       "                                           12/24/2023 11:20 +07                NaN   \n",
       "                                           12/24/2023 11:40 +07                NaN   \n",
       "                                           12/24/2023 12:00 +07                NaN   \n",
       "                                           12/24/2023 12:20 +07                NaN   \n",
       "...                                                                            ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                NaN   \n",
       "                                           12/23/2023 16:00 +07                NaN   \n",
       "                                           12/23/2023 21:00 +07                NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                                   \\\n",
       "service.service_name                                                                \n",
       "target.target_value                                                       8.8.8.8   \n",
       "name                                                                 responseTime   \n",
       "sla_name                                   status.time_stamp_display                \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07               NaN   \n",
       "                                           12/24/2023 11:20 +07               NaN   \n",
       "                                           12/24/2023 11:40 +07               NaN   \n",
       "                                           12/24/2023 12:00 +07               NaN   \n",
       "                                           12/24/2023 12:20 +07               NaN   \n",
       "...                                                                           ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07               NaN   \n",
       "                                           12/23/2023 16:00 +07               NaN   \n",
       "                                           12/23/2023 21:00 +07               NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07               NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07               NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                      ...  \\\n",
       "service.service_name                                                  ...   \n",
       "target.target_value                                                   ...   \n",
       "name                                                                  ...   \n",
       "sla_name                                   status.time_stamp_display  ...   \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07       ...   \n",
       "                                           12/24/2023 11:20 +07       ...   \n",
       "                                           12/24/2023 11:40 +07       ...   \n",
       "                                           12/24/2023 12:00 +07       ...   \n",
       "                                           12/24/2023 12:20 +07       ...   \n",
       "...                                                                   ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07       ...   \n",
       "                                           12/23/2023 16:00 +07       ...   \n",
       "                                           12/23/2023 21:00 +07       ...   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07       ...   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07       ...   \n",
       "\n",
       "                                                                                                  \\\n",
       "service.service_name                                                 Traceroute (Private-VLAN10)   \n",
       "target.target_value                                                                      8.8.8.8   \n",
       "name                                                                                hopCountDest   \n",
       "sla_name                                   status.time_stamp_display                               \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                              NaN   \n",
       "                                           12/24/2023 11:20 +07                              NaN   \n",
       "                                           12/24/2023 11:40 +07                              NaN   \n",
       "                                           12/24/2023 12:00 +07                              NaN   \n",
       "                                           12/24/2023 12:20 +07                              NaN   \n",
       "...                                                                                          ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                              NaN   \n",
       "                                           12/23/2023 16:00 +07                              NaN   \n",
       "                                           12/23/2023 21:00 +07                              NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                              NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                              NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                                      \\\n",
       "service.service_name                                                 Traceroute test   \n",
       "target.target_value                                                    110.78.191.20   \n",
       "name                                                                   EEDMedianDest   \n",
       "sla_name                                   status.time_stamp_display                   \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                  NaN   \n",
       "                                           12/24/2023 11:20 +07                  NaN   \n",
       "                                           12/24/2023 11:40 +07                  NaN   \n",
       "                                           12/24/2023 12:00 +07                  NaN   \n",
       "                                           12/24/2023 12:20 +07                  NaN   \n",
       "...                                                                              ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                  NaN   \n",
       "                                           12/23/2023 16:00 +07                  NaN   \n",
       "                                           12/23/2023 21:00 +07                  NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                  NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                  NaN   \n",
       "\n",
       "                                                                                   \\\n",
       "service.service_name                                                                \n",
       "target.target_value                                                                 \n",
       "name                                                                 hopCountDest   \n",
       "sla_name                                   status.time_stamp_display                \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07               NaN   \n",
       "                                           12/24/2023 11:20 +07               NaN   \n",
       "                                           12/24/2023 11:40 +07               NaN   \n",
       "                                           12/24/2023 12:00 +07               NaN   \n",
       "                                           12/24/2023 12:20 +07               NaN   \n",
       "...                                                                           ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07               NaN   \n",
       "                                           12/23/2023 16:00 +07               NaN   \n",
       "                                           12/23/2023 21:00 +07               NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07               NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07               NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                                    \\\n",
       "service.service_name                                                                 \n",
       "target.target_value                                                        8.8.8.8   \n",
       "name                                                                 EEDMedianDest   \n",
       "sla_name                                   status.time_stamp_display                 \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                NaN   \n",
       "                                           12/24/2023 11:20 +07                NaN   \n",
       "                                           12/24/2023 11:40 +07                NaN   \n",
       "                                           12/24/2023 12:00 +07                NaN   \n",
       "                                           12/24/2023 12:20 +07                NaN   \n",
       "...                                                                            ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                NaN   \n",
       "                                           12/23/2023 16:00 +07                NaN   \n",
       "                                           12/23/2023 21:00 +07                NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                NaN   \n",
       "\n",
       "                                                                                   \\\n",
       "service.service_name                                                                \n",
       "target.target_value                                                                 \n",
       "name                                                                 hopCountDest   \n",
       "sla_name                                   status.time_stamp_display                \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07               NaN   \n",
       "                                           12/24/2023 11:20 +07               NaN   \n",
       "                                           12/24/2023 11:40 +07               NaN   \n",
       "                                           12/24/2023 12:00 +07               NaN   \n",
       "                                           12/24/2023 12:20 +07               NaN   \n",
       "...                                                                           ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07               NaN   \n",
       "                                           12/23/2023 16:00 +07               NaN   \n",
       "                                           12/23/2023 21:00 +07               NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07               NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07               NaN   \n",
       "\n",
       "                                                                             \\\n",
       "service.service_name                                                          \n",
       "target.target_value                                                           \n",
       "name                                                                 result   \n",
       "sla_name                                   status.time_stamp_display          \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN   \n",
       "                                           12/24/2023 11:20 +07         NaN   \n",
       "                                           12/24/2023 11:40 +07         NaN   \n",
       "                                           12/24/2023 12:00 +07         NaN   \n",
       "                                           12/24/2023 12:20 +07         NaN   \n",
       "...                                                                     ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN   \n",
       "                                           12/23/2023 16:00 +07         NaN   \n",
       "                                           12/23/2023 21:00 +07         NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN   \n",
       "\n",
       "                                                                                                \\\n",
       "service.service_name                                                 UDP Echo (Private-VLAN10)   \n",
       "target.target_value                                                                   10.0.0.8   \n",
       "name                                                                               lostPackets   \n",
       "sla_name                                   status.time_stamp_display                             \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07                            NaN   \n",
       "                                           12/24/2023 11:20 +07                            NaN   \n",
       "                                           12/24/2023 11:40 +07                            NaN   \n",
       "                                           12/24/2023 12:00 +07                            NaN   \n",
       "                                           12/24/2023 12:20 +07                            NaN   \n",
       "...                                                                                        ...   \n",
       "BV110_SNI                                  12/23/2023 05:00 +07                            NaN   \n",
       "                                           12/23/2023 16:00 +07                            NaN   \n",
       "                                           12/23/2023 21:00 +07                            NaN   \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07                            NaN   \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07                            NaN   \n",
       "\n",
       "                                                                             \n",
       "service.service_name                                                         \n",
       "target.target_value                                                          \n",
       "name                                                                 result  \n",
       "sla_name                                   status.time_stamp_display         \n",
       "ATP-Expansion BRIX                         12/24/2023 11:00 +07         NaN  \n",
       "                                           12/24/2023 11:20 +07         NaN  \n",
       "                                           12/24/2023 11:40 +07         NaN  \n",
       "                                           12/24/2023 12:00 +07         NaN  \n",
       "                                           12/24/2023 12:20 +07         NaN  \n",
       "...                                                                     ...  \n",
       "BV110_SNI                                  12/23/2023 05:00 +07         NaN  \n",
       "                                           12/23/2023 16:00 +07         NaN  \n",
       "                                           12/23/2023 21:00 +07         NaN  \n",
       "POC-Expansion-SLA_BNG_144_Private (VLAN10) 12/25/2023 20:40 +07         NaN  \n",
       "POC-Expansion-SLA_BRAS_88_Public (VLAN20)  12/25/2023 20:20 +07         NaN  \n",
       "\n",
       "[1781 rows x 128 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "table = pd.pivot_table(df3, index=['sla_name', 'status.time_stamp_display'], \n",
    "                       columns=['service.service_name',  \"target.target_value\", \"name\"], values=[\"raw_value\",])\n",
    "table"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "6cd36934",
   "metadata": {},
   "outputs": [],
   "source": [
    "import time\n",
    " \n",
    "# ts stores the time in seconds\n",
    "ts = int(time.time())\n",
    "table.to_excel(f\"table{ts}.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9df0fb4d",
   "metadata": {},
   "outputs": [],
   "source": [
    "df3['status'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "600c7d65",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "df = pd.json_normalize(list_test_status_result, record_path=[\"test_status_result\",\"status\"], meta=[\"\"])\n",
    "df "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "89e92340",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a1970a62",
   "metadata": {},
   "outputs": [],
   "source": [
    "def dict_list_to_df(df, col):\n",
    "    \"\"\"Return a Pandas dataframe based on a column that contains a list of JSON objects or dictionaries.\n",
    "    Args:\n",
    "        df (Pandas dataframe): The dataframe to be flattened.\n",
    "        col (str): The name of the column that contains the JSON objects or dictionaries.\n",
    "    Returns:\n",
    "        Pandas dataframe: A new dataframe with the JSON objects or dictionaries expanded into columns.\n",
    "    \"\"\"\n",
    "\n",
    "    rows = []\n",
    "    for index, row in df[col].iteritems():\n",
    "        for item in row:\n",
    "            rows.append(item)\n",
    "    df = pd.DataFrame(rows)\n",
    "    return df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "0f710508",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = dict_list_to_df(df, \"status\")\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ebfa9aad",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = dict_list_to_df(df1, \"results_scores\")\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "907787a4",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "!pip install flatten-json\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e429f61f",
   "metadata": {},
   "outputs": [],
   "source": [
    "from flatten_json import flatten\n",
    "df['status_r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "4ca94eb4",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_flat = pd.io.json.json_normalize(json_struct)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3eec9f31",
   "metadata": {},
   "outputs": [],
   "source": [
    "import ast\n",
    "from pandas.io.json import json_normalize\n",
    "\n",
    "def only_dict(d):\n",
    "    '''\n",
    "    Convert json string representation of dictionary to a python dict\n",
    "    '''\n",
    "    return ast.literal_eval(d)\n",
    "\n",
    "def list_of_dicts(ld):\n",
    "    '''\n",
    "    Create a mapping of the tuples formed after \n",
    "    converting json strings of list to a python list   \n",
    "    '''\n",
    "    return dict([(list(d.values())[1], list(d.values())[0]) for d in ast.literal_eval(ld)])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "84abce60",
   "metadata": {},
   "outputs": [],
   "source": [
    "A = json_normalize(df['status'].apply(only_dict).tolist()).add_prefix('status.')\n",
    "A"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c6cad4f4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "43e75e42",
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.json_normalize(list(df['status']))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f3aa03a3",
   "metadata": {},
   "outputs": [],
   "source": [
    "new_temp = df.explode('status')\n",
    "new_temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "43c223e4",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "df2 = df.merge(new_temp, left_index=True, right_index=True, suffixes=(\"_test\",\"_status\"))\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "23c07db6",
   "metadata": {},
   "outputs": [],
   "source": [
    "df2.to_excel(\"test.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "63fd1c63",
   "metadata": {},
   "outputs": [],
   "source": [
    "temp = df.explode('status.results_scores')\n",
    "temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "c29d6c22",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "temp"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "3f70e1ce",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "l1 = []\n",
    "for l in list_test_status_result:\n",
    "    l1 = l1 + l['test_status_result']\n",
    "df = pd.DataFrame(l1)\n",
    "df = pd.concat([df, df[\"service\"].apply(pd.Series)], axis=1)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b5ed3a07",
   "metadata": {},
   "outputs": [],
   "source": [
    "df['results_scores']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e2d3cea1",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "\n",
    "df1 = pd.DataFrame(df['status'][0])\n",
    "temp_df = pd.DataFrame.from_dict(np.concatenate(df1['results_scores']).tolist())\n",
    "temp_df[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "53f33c73",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_df = df1.merge(temp_df, how='inner', left_index=True, right_index=True)\n",
    "final_df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "dbdce3be",
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "df = pd.DataFrame(list_test_status_result)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a9335321",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.explode('test_status_result')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "06233024",
   "metadata": {
    "scrolled": false
   },
   "outputs": [],
   "source": [
    "l0 = []\n",
    "for l in list_test_status_result:\n",
    "    for t in l['test_status_result']:\n",
    "        for st in t['status']:\n",
    "            for rs in st['results_scores']:\n",
    "                temp = t['service'] | (t['target'] or {}) | rs\n",
    "                temp['sla_name'] = st['sla_name'] \n",
    "                temp['time_stamp'] = st['time_stamp']\n",
    "                temp['time_stamp_display'] = st['time_stamp_display']\n",
    "                l0.append(temp)\n",
    "l0[:10]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "bda1d24c",
   "metadata": {},
   "outputs": [],
   "source": [
    "list_test_status_result = list(db['exfo_api'].find({}, {'test_status_result':1}))\n",
    "list_test_status_result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "31b9ddcb",
   "metadata": {},
   "outputs": [],
   "source": [
    "pd.set_option('display.max_rows', 500)\n",
    "pd.set_option('display.max_columns', 500)\n",
    "pd.set_option('display.width', 1000)\n",
    "\n",
    "temp = []\n",
    "for l in list_test_status_result:\n",
    "    for d in l['test_status_result']:\n",
    "        for s in d['status']:\n",
    "            for rs in s['results_scores']:\n",
    "                t2 = {rs['name']: [rs['raw_value'], rs['score']]}\n",
    "                temp.append({**d, **s, **t2})\n",
    "temp\n",
    "df = pd.json_normalize(temp)\n",
    "#df.set_index(['time_stamp_display'], inplace=True)\n",
    "df['sla_service'] = df['sla_name'] + \"/\" + df['service_name']\n",
    "df['sla_service'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9eff937a",
   "metadata": {},
   "outputs": [],
   "source": [
    "f = df[df['sla_service'] == 'BV110_CMI/HTTPS Web Performances']\n",
    "f.set_index(['time_stamp_display'], inplace=True)\n",
    "f"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "fa8e2f18",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f0515da8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}