{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "b3e3ebf1-3bba-41b2-9b9f-70bb80a9ad50",
   "metadata": {
    "tags": []
   },
   "source": [
    "# CPE Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "stuffed-appearance",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-06-16T12:28:38.807863Z",
     "iopub.status.busy": "2024-06-16T12:28:38.807702Z",
     "iopub.status.idle": "2024-06-16T12:28:39.340467Z",
     "shell.execute_reply": "2024-06-16T12:28:39.339858Z"
    },
    "tags": [
     "remove-cell"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<script>\n",
       "    if (document.body.dataset.jpThemeLight == \"false\" || // Jupyter Lab\n",
       "        document.body.dataset.vscodeThemeKind == \"vscode-dark\" || // VS Code\n",
       "        document.documentElement.dataset.theme == \"dark\" || // Jupyter Book\n",
       "        window.matchMedia('(prefers-color-scheme: dark)').matches) {\n",
       "        document.documentElement.classList.add('dark');\n",
       "    }\n",
       "    else {\n",
       "        document.documentElement.classList.remove('dark');\n",
       "    }\n",
       "</script>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "import glob\n",
    "import logging\n",
    "import json\n",
    "import os\n",
    "import pandas as pd\n",
    "import warnings\n",
    "from itables import init_notebook_mode, show\n",
    "import itables.options as opt\n",
    "\n",
    "opt.dom = \"tpir\"\n",
    "opt.style = \"table-layout:auto;width:auto\"\n",
    "init_notebook_mode(all_interactive=True, connected=True)\n",
    "\n",
    "logging.getLogger('matplotlib.font_manager').disabled = True\n",
    "warnings.filterwarnings(\"ignore\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "inner-count",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-06-16T12:28:39.342773Z",
     "iopub.status.busy": "2024-06-16T12:28:39.342453Z",
     "iopub.status.idle": "2024-06-16T12:29:14.436181Z",
     "shell.execute_reply": "2024-06-16T12:29:14.435531Z"
    },
    "tags": [
     "remove-cell"
    ]
   },
   "outputs": [],
   "source": [
    "row_accumulator = []\n",
    "\n",
    "for filename in glob.glob('nvdcve-1.1-*.json'):\n",
    "    with open(filename, 'r', encoding='utf-8') as f:\n",
    "        nvd_data = json.load(f)\n",
    "        for cves in nvd_data['CVE_Items']:\n",
    "            if cves['configurations']['nodes'] != []:\n",
    "                if \"children\" in cves['configurations']['nodes'][0]:\n",
    "                    for j in range(len(cves['configurations']['nodes'][0]['children'])):\n",
    "                        for cpe in cves['configurations']['nodes'][0]['children'][j]['cpe_match']:\n",
    "                            if cpe['vulnerable'] == True:\n",
    "                                        cve = cves['cve']['CVE_data_meta']['ID']\n",
    "                                        cpe_string = cpe['cpe23Uri']\n",
    "                                        try:\n",
    "                                            end = cpe['versionEndExcluding']\n",
    "                                        except: \n",
    "                                            end = 'None'\n",
    "                                        try:\n",
    "                                            end2 = cpe['versionEndIncluding']\n",
    "                                        except: \n",
    "                                            end2 = 'None' \n",
    "                                        try:\n",
    "                                            start = cpe['versionStartExcluding']\n",
    "                                        except: \n",
    "                                            start = 'None'\n",
    "                                        try:\n",
    "                                            start2 = cpe['versionStartIncluding']\n",
    "                                        except: \n",
    "                                            start2 = 'None'     \n",
    "                                        new_row = { \n",
    "                                        'CVE': cve,\n",
    "                                        'CPE' : cpe_string,\n",
    "                                        'StartI' : start,\n",
    "                                        'StartE' : start2,\n",
    "                                        'EndI' : end,\n",
    "                                        'EndE' : end2 \n",
    "                                        }\n",
    "                                        row_accumulator.append(new_row)\n",
    "        \n",
    "\n",
    "\n",
    "nvd = pd.DataFrame(row_accumulator)                            "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "833383cc-8ef0-4490-acdc-98671760b1a3",
   "metadata": {},
   "source": [
    "## CVEs With Most CPE"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "temporal-disposal",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-06-16T12:29:14.438935Z",
     "iopub.status.busy": "2024-06-16T12:29:14.438749Z",
     "iopub.status.idle": "2024-06-16T12:29:14.464419Z",
     "shell.execute_reply": "2024-06-16T12:29:14.463953Z"
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table id=\"itables_6db19fe1_43cf_4b88_95b7_e97081fc9ad0\" class=\"display nowrap\" data-quarto-disable-processing=\"true\" style=\"table-layout:auto;width:auto\">\n",
       "<thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead><tbody><tr>\n",
       "<td style=\"vertical-align:middle; text-align:left\">\n",
       "<div style=\"float:left; margin-right: 10px;\">\n",
       "<a href=https://mwouts.github.io/itables/><svg class=\"main-svg\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\"\n",
       "width=\"64\" viewBox=\"0 0 500 400\" style=\"font-family: 'Droid Sans', sans-serif;\">\n",
       "    <g style=\"fill:#d9d7fc\">\n",
       "        <path d=\"M100,400H500V357H100Z\" />\n",
       "        <path d=\"M100,300H400V257H100Z\" />\n",
       "        <path d=\"M0,200H400V157H0Z\" />\n",
       "        <path d=\"M100,100H500V57H100Z\" />\n",
       "        <path d=\"M100,350H500V307H100Z\" />\n",
       "        <path d=\"M100,250H400V207H100Z\" />\n",
       "        <path d=\"M0,150H400V107H0Z\" />\n",
       "        <path d=\"M100,50H500V7H100Z\" />\n",
       "    </g>\n",
       "    <g style=\"fill:#1a1366;stroke:#1a1366;\">\n",
       "   <rect x=\"100\" y=\"7\" width=\"400\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;400;0\"\n",
       "      dur=\"5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "      <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"100;100;500\"\n",
       "      dur=\"5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <rect x=\"0\" y=\"107\" width=\"400\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;400;0\"\n",
       "      dur=\"3.5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "    <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"0;0;400\"\n",
       "      dur=\"3.5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <rect x=\"100\" y=\"207\" width=\"300\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;300;0\"\n",
       "      dur=\"3s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "    <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"100;100;400\"\n",
       "      dur=\"3s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <rect x=\"100\" y=\"307\" width=\"400\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;400;0\"\n",
       "      dur=\"4s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "      <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"100;100;500\"\n",
       "      dur=\"4s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <g style=\"fill:transparent;stroke-width:8; stroke-linejoin:round\" rx=\"5\">\n",
       "            <g transform=\"translate(45 50) rotate(-45)\">\n",
       "                <circle r=\"33\" cx=\"0\" cy=\"0\" />\n",
       "                <rect x=\"-8\" y=\"32\" width=\"16\" height=\"30\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(450 152)\">\n",
       "                <polyline points=\"-15,-20 -35,-20 -35,40 25,40 25,20\" />\n",
       "                <rect x=\"-15\" y=\"-40\" width=\"60\" height=\"60\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(50 352)\">\n",
       "                <polygon points=\"-35,-5 0,-40 35,-5\" />\n",
       "                <polygon points=\"-35,10 0,45 35,10\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(75 250)\">\n",
       "                <polyline points=\"-30,30 -60,0 -30,-30\" />\n",
       "                <polyline points=\"0,30 -30,0 0,-30\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(425 250) rotate(180)\">\n",
       "                <polyline points=\"-30,30 -60,0 -30,-30\" />\n",
       "                <polyline points=\"0,30 -30,0 0,-30\" />\n",
       "            </g>\n",
       "        </g>\n",
       "    </g>\n",
       "</svg>\n",
       "</a>\n",
       "</div>\n",
       "<div>\n",
       "Loading ITables v2.1.1 from the internet...\n",
       "(need <a href=https://mwouts.github.io/itables/troubleshooting.html>help</a>?)</td>\n",
       "</div>\n",
       "</tr></tbody>\n",
       "\n",
       "</table>\n",
       "<link href=\"https://www.unpkg.com/dt_for_itables@2.0.10/dt_bundle.css\" rel=\"stylesheet\">\n",
       "<script type=\"module\">\n",
       "    import {DataTable, jQuery as $} from 'https://www.unpkg.com/dt_for_itables@2.0.10/dt_bundle.js';\n",
       "\n",
       "    document.querySelectorAll(\"#itables_6db19fe1_43cf_4b88_95b7_e97081fc9ad0:not(.dataTable)\").forEach(table => {\n",
       "        // Define the table data\n",
       "        const data = [[\"CVE-2021-1620\", 690], [\"CVE-2022-22160\", 364], [\"CVE-2011-3664\", 325], [\"CVE-2012-1350\", 322], [\"CVE-2007-6694\", 316], [\"CVE-2008-7256\", 303], [\"CVE-2011-1011\", 270], [\"CVE-2021-31366\", 267], [\"CVE-2012-5120\", 248], [\"CVE-2016-5995\", 243], [\"CVE-2010-0741\", 241], [\"CVE-2023-44183\", 240], [\"CVE-2022-22226\", 240], [\"CVE-2021-31382\", 239], [\"CVE-2021-0272\", 235], [\"CVE-2021-0228\", 231], [\"CVE-2020-1680\", 228], [\"CVE-2009-2711\", 226], [\"CVE-2021-0273\", 226], [\"CVE-2011-2366\", 225], [\"CVE-2011-3666\", 225], [\"CVE-2009-2486\", 222], [\"CVE-2009-2596\", 222], [\"CVE-2022-22223\", 222], [\"CVE-2020-1628\", 221], [\"CVE-2014-1506\", 217], [\"CVE-2021-0237\", 216], [\"CVE-2022-20725\", 215], [\"CVE-2023-36848\", 213], [\"CVE-2021-0285\", 210], [\"CVE-2022-22191\", 208], [\"CVE-2023-36850\", 207], [\"CVE-2012-5216\", 204], [\"CVE-2020-1618\", 203], [\"CVE-2021-0288\", 202], [\"CVE-2023-20187\", 201], [\"CVE-2021-0295\", 200], [\"CVE-2022-22249\", 197], [\"CVE-2021-0203\", 192], [\"CVE-2023-20027\", 190], [\"CVE-2021-0259\", 184], [\"CVE-2021-0230\", 182], [\"CVE-2021-31361\", 182], [\"CVE-2021-31370\", 181], [\"CVE-2023-36832\", 181], [\"CVE-2021-0242\", 180], [\"CVE-2013-0790\", 179], [\"CVE-2012-3979\", 179], [\"CVE-2010-4410\", 174], [\"CVE-2010-2761\", 174]];\n",
       "\n",
       "        // Define the dt_args\n",
       "        let dt_args = {\"scrollY\": \"400px\", \"scrollCollapse\": true, \"paging\": false, \"dom\": \"tpir\", \"order\": []};\n",
       "        dt_args[\"data\"] = data;\n",
       "\n",
       "        \n",
       "        new DataTable(table, dt_args);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "nvd_cve = nvd['CVE'].value_counts().head(50)\n",
    "show(nvd_cve, scrollY=\"400px\", scrollCollapse=True, paging=False)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "69850125-3841-48cd-a36d-1cf998c68272",
   "metadata": {},
   "source": [
    "## Most Common CPEs"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "celtic-employer",
   "metadata": {
    "execution": {
     "iopub.execute_input": "2024-06-16T12:29:14.466632Z",
     "iopub.status.busy": "2024-06-16T12:29:14.466305Z",
     "iopub.status.idle": "2024-06-16T12:29:14.498131Z",
     "shell.execute_reply": "2024-06-16T12:29:14.497691Z"
    },
    "tags": [
     "remove-input"
    ]
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<table id=\"itables_e116c6e4_f292_4a49_9380_e400a88d6d8d\" class=\"display nowrap\" data-quarto-disable-processing=\"true\" style=\"table-layout:auto;width:auto\">\n",
       "<thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>count</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CPE</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead><tbody><tr>\n",
       "<td style=\"vertical-align:middle; text-align:left\">\n",
       "<div style=\"float:left; margin-right: 10px;\">\n",
       "<a href=https://mwouts.github.io/itables/><svg class=\"main-svg\" xmlns=\"http://www.w3.org/2000/svg\" xmlns:xlink=\"http://www.w3.org/1999/xlink\"\n",
       "width=\"64\" viewBox=\"0 0 500 400\" style=\"font-family: 'Droid Sans', sans-serif;\">\n",
       "    <g style=\"fill:#d9d7fc\">\n",
       "        <path d=\"M100,400H500V357H100Z\" />\n",
       "        <path d=\"M100,300H400V257H100Z\" />\n",
       "        <path d=\"M0,200H400V157H0Z\" />\n",
       "        <path d=\"M100,100H500V57H100Z\" />\n",
       "        <path d=\"M100,350H500V307H100Z\" />\n",
       "        <path d=\"M100,250H400V207H100Z\" />\n",
       "        <path d=\"M0,150H400V107H0Z\" />\n",
       "        <path d=\"M100,50H500V7H100Z\" />\n",
       "    </g>\n",
       "    <g style=\"fill:#1a1366;stroke:#1a1366;\">\n",
       "   <rect x=\"100\" y=\"7\" width=\"400\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;400;0\"\n",
       "      dur=\"5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "      <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"100;100;500\"\n",
       "      dur=\"5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <rect x=\"0\" y=\"107\" width=\"400\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;400;0\"\n",
       "      dur=\"3.5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "    <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"0;0;400\"\n",
       "      dur=\"3.5s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <rect x=\"100\" y=\"207\" width=\"300\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;300;0\"\n",
       "      dur=\"3s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "    <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"100;100;400\"\n",
       "      dur=\"3s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <rect x=\"100\" y=\"307\" width=\"400\" height=\"43\">\n",
       "    <animate\n",
       "      attributeName=\"width\"\n",
       "      values=\"0;400;0\"\n",
       "      dur=\"4s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "      <animate\n",
       "      attributeName=\"x\"\n",
       "      values=\"100;100;500\"\n",
       "      dur=\"4s\"\n",
       "      repeatCount=\"indefinite\" />\n",
       "  </rect>\n",
       "        <g style=\"fill:transparent;stroke-width:8; stroke-linejoin:round\" rx=\"5\">\n",
       "            <g transform=\"translate(45 50) rotate(-45)\">\n",
       "                <circle r=\"33\" cx=\"0\" cy=\"0\" />\n",
       "                <rect x=\"-8\" y=\"32\" width=\"16\" height=\"30\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(450 152)\">\n",
       "                <polyline points=\"-15,-20 -35,-20 -35,40 25,40 25,20\" />\n",
       "                <rect x=\"-15\" y=\"-40\" width=\"60\" height=\"60\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(50 352)\">\n",
       "                <polygon points=\"-35,-5 0,-40 35,-5\" />\n",
       "                <polygon points=\"-35,10 0,45 35,10\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(75 250)\">\n",
       "                <polyline points=\"-30,30 -60,0 -30,-30\" />\n",
       "                <polyline points=\"0,30 -30,0 0,-30\" />\n",
       "            </g>\n",
       "\n",
       "            <g transform=\"translate(425 250) rotate(180)\">\n",
       "                <polyline points=\"-30,30 -60,0 -30,-30\" />\n",
       "                <polyline points=\"0,30 -30,0 0,-30\" />\n",
       "            </g>\n",
       "        </g>\n",
       "    </g>\n",
       "</svg>\n",
       "</a>\n",
       "</div>\n",
       "<div>\n",
       "Loading ITables v2.1.1 from the internet...\n",
       "(need <a href=https://mwouts.github.io/itables/troubleshooting.html>help</a>?)</td>\n",
       "</div>\n",
       "</tr></tbody>\n",
       "\n",
       "</table>\n",
       "<link href=\"https://www.unpkg.com/dt_for_itables@2.0.10/dt_bundle.css\" rel=\"stylesheet\">\n",
       "<script type=\"module\">\n",
       "    import {DataTable, jQuery as $} from 'https://www.unpkg.com/dt_for_itables@2.0.10/dt_bundle.js';\n",
       "\n",
       "    document.querySelectorAll(\"#itables_e116c6e4_f292_4a49_9380_e400a88d6d8d:not(.dataTable)\").forEach(table => {\n",
       "        // Define the table data\n",
       "        const data = [[\"cpe:2.3:a:adobe:acrobat_dc:*:*:*:*:classic:*:*:*\", 2015], [\"cpe:2.3:a:adobe:acrobat_reader_dc:*:*:*:*:classic:*:*:*\", 2014], [\"cpe:2.3:a:adobe:acrobat_dc:*:*:*:*:continuous:*:*:*\", 1543], [\"cpe:2.3:a:adobe:acrobat_reader_dc:*:*:*:*:continuous:*:*:*\", 1537], [\"cpe:2.3:o:google:android:12.0:*:*:*:*:*:*:*\", 897], [\"cpe:2.3:o:google:android:11.0:*:*:*:*:*:*:*\", 864], [\"cpe:2.3:a:adobe:flash_player:*:*:*:*:*:*:*:*\", 715], [\"cpe:2.3:a:adobe:acrobat:*:*:*:*:*:*:*:*\", 651], [\"cpe:2.3:o:google:android:10.0:*:*:*:*:*:*:*\", 568], [\"cpe:2.3:a:google:chrome:*:*:*:*:*:*:*:*\", 442], [\"cpe:2.3:o:google:android:13.0:*:*:*:*:*:*:*\", 433], [\"cpe:2.3:a:foxitsoftware:phantompdf:*:*:*:*:*:*:*:*\", 374], [\"cpe:2.3:a:adobe:reader:*:*:*:*:*:*:*:*\", 356], [\"cpe:2.3:o:qualcomm:apq8009_firmware:-:*:*:*:*:*:*:*\", 329], [\"cpe:2.3:a:adobe:acrobat_reader:*:*:*:*:*:*:*:*\", 300], [\"cpe:2.3:o:qualcomm:mdm9206_firmware:-:*:*:*:*:*:*:*\", 266], [\"cpe:2.3:a:microsoft:edge:-:*:*:*:*:*:*:*\", 217], [\"cpe:2.3:a:foxitsoftware:reader:*:*:*:*:*:*:*:*\", 194], [\"cpe:2.3:a:mozilla:firefox:*:*:*:*:*:*:*:*\", 190], [\"cpe:2.3:a:sandhillsdev:easy_digital_downloads:*:*:*:*:*:wordpress:*:*\", 186], [\"cpe:2.3:o:qualcomm:aqt1000_firmware:-:*:*:*:*:*:*:*\", 184], [\"cpe:2.3:a:apple:safari:*:*:*:*:*:*:*:*\", 179], [\"cpe:2.3:a:apple:webkit:*:*:*:*:*:*:*:*\", 156], [\"cpe:2.3:a:foxitsoftware:foxit_reader:*:*:*:*:*:*:*:*\", 153], [\"cpe:2.3:o:arubanetworks:arubaos:*:*:*:*:*:*:*:*\", 148], [\"cpe:2.3:a:nvidia:virtual_gpu:*:*:*:*:*:*:*:*\", 139], [\"cpe:2.3:a:foxit:pdf_editor:*:*:*:*:*:*:*:*\", 136], [\"cpe:2.3:o:cisco:adaptive_security_appliance_software:*:*:*:*:*:*:*:*\", 134], [\"cpe:2.3:a:adobe:bridge:*:*:*:*:*:*:*:*\", 125], [\"cpe:2.3:a:microsoft:edge:*:*:*:*:*:*:*:*\", 125], [\"cpe:2.3:a:adobe:illustrator:*:*:*:*:*:*:*:*\", 123], [\"cpe:2.3:a:adobe:indesign:*:*:*:*:*:*:*:*\", 117], [\"cpe:2.3:a:adobe:acrobat_reader:*:*:*:*:classic:*:*:*\", 115], [\"cpe:2.3:o:cisco:nx-os:*:*:*:*:*:*:*:*\", 115], [\"cpe:2.3:a:adobe:acrobat:*:*:*:*:classic:*:*:*\", 115], [\"cpe:2.3:o:qualcomm:ar8035_firmware:-:*:*:*:*:*:*:*\", 113], [\"cpe:2.3:a:adobe:photoshop_cc:*:*:*:*:*:*:*:*\", 113], [\"cpe:2.3:a:adobe:after_effects:*:*:*:*:*:*:*:*\", 112], [\"cpe:2.3:a:adobe:flash_player_desktop_runtime:*:*:*:*:*:*:*:*\", 111], [\"cpe:2.3:o:netgear:d7800_firmware:*:*:*:*:*:*:*:*\", 107], [\"cpe:2.3:a:adobe:photoshop:*:*:*:*:*:*:*:*\", 105], [\"cpe:2.3:o:google:android:11.0:-:*:*:*:*:*:*\", 100], [\"cpe:2.3:a:foxit:pdf_reader:*:*:*:*:*:*:*:*\", 97], [\"cpe:2.3:a:nvidia:gpu_driver:*:*:*:*:*:*:*:*\", 96], [\"cpe:2.3:o:insteon:hub_firmware:1012:*:*:*:*:*:*:*\", 95], [\"cpe:2.3:a:apple:itunes:*:*:*:*:*:*:*:*\", 91], [\"cpe:2.3:o:juniper:junos:20.4:r1:*:*:*:*:*:*\", 90], [\"cpe:2.3:o:reolink:rlc-410w_firmware:3.0.0.136_20121102:*:*:*:*:*:*:*\", 87], [\"cpe:2.3:o:juniper:junos:20.4:r1-s1:*:*:*:*:*:*\", 86], [\"cpe:2.3:a:microsoft:internet_explorer:6:*:*:*:*:*:*:*\", 86]];\n",
       "\n",
       "        // Define the dt_args\n",
       "        let dt_args = {\"scrollY\": \"400px\", \"scrollCollapse\": true, \"paging\": false, \"dom\": \"tpir\", \"order\": []};\n",
       "        dt_args[\"data\"] = data;\n",
       "\n",
       "        \n",
       "        new DataTable(table, dt_args);\n",
       "    });\n",
       "</script>\n"
      ],
      "text/plain": [
       "<IPython.core.display.HTML object>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "nvd_cpe = nvd['CPE'].value_counts().head(50)\n",
    "show(nvd_cpe, scrollY=\"400px\", scrollCollapse=True, paging=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.6 64-bit",
   "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.11.9"
  },
  "vscode": {
   "interpreter": {
    "hash": "aee8b7b246df8f9039afb4144a1f6fd8d2ca17a180786b69acc140d282b71a49"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}