prototypes/CVE_JSON.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 61,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'{\\n  \"CVE_data_type\" : \"CVE\",\\n  \"CVE_data_format\" : \"MITRE\",\\n  \"CVE_data_version\" : \"4.0\",\\n  \"CVE_dat'"
      ]
     },
     "execution_count": 61,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import gzip\n",
    "\n",
    "with open (\"../demos/dataset/nvdcve-1.0-2016_short.json\", \"rt\", encoding='utf-8') as json_file:\n",
    "    json_content = json_file.read()\n",
    "    \n",
    "json_content[:100]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'CVE_Items': [{'configurations': {'CVE_data_version': '4.0',\n",
       "    'nodes': [{'cpe_match': [{'cpe23Uri': 'cpe:2.3:a:microsoft:edge:-:*:*:*:*:*:*:*',\n",
       "        'vulnerable': True}],\n",
       "      'operator': 'OR'}]},\n",
       "   'cve': {'CVE_data_meta': {'ASSIGNER': 'cve@mitre.org',\n",
       "     'ID': 'CVE-2016-0003'},\n",
       "    'affects': {'vendor': {'vendor_data': [{'product': {'product_data': [{'product_name': 'edge',\n",
       "           'version': {'version_data': [{'version_affected': '=',\n",
       "              'version_value': '-'}]}}]},\n",
       "        'vendor_name': 'microsoft'}]}},\n",
       "    'data_format': 'MITRE',\n",
       "    'data_type': 'CVE',\n",
       "    'data_version': '4.0',\n",
       "    'description': {'description_data': [{'lang': 'en',\n",
       "       'value': 'Microsoft Edge allows remote attackers to execute arbitrary code via unspecified vectors, aka \"Microsoft Edge Memory Corruption Vulnerability.\"'}]},\n",
       "    'problemtype': {'problemtype_data': [{'description': [{'lang': 'en',\n",
       "         'value': 'CWE-119'}]}]},\n",
       "    'references': {'reference_data': [{'name': '1034649',\n",
       "       'refsource': 'SECTRACK',\n",
       "       'tags': [],\n",
       "       'url': 'http://www.securitytracker.com/id/1034649'},\n",
       "      {'name': 'http://www.zerodayinitiative.com/advisories/ZDI-16-019',\n",
       "       'refsource': 'MISC',\n",
       "       'tags': [],\n",
       "       'url': 'http://www.zerodayinitiative.com/advisories/ZDI-16-019'},\n",
       "      {'name': 'MS16-002',\n",
       "       'refsource': 'MS',\n",
       "       'tags': [],\n",
       "       'url': 'https://docs.microsoft.com/en-us/security-updates/securitybulletins/2016/ms16-002'}]}},\n",
       "   'impact': {'baseMetricV2': {'cvssV2': {'accessComplexity': 'MEDIUM',\n",
       "      'accessVector': 'NETWORK',\n",
       "      'authentication': 'NONE',\n",
       "      'availabilityImpact': 'COMPLETE',\n",
       "      'baseScore': 9.3,\n",
       "      'confidentialityImpact': 'COMPLETE',\n",
       "      'integrityImpact': 'COMPLETE',\n",
       "      'vectorString': 'AV:N/AC:M/Au:N/C:C/I:C/A:C',\n",
       "      'version': '2.0'},\n",
       "     'exploitabilityScore': 8.6,\n",
       "     'impactScore': 10.0,\n",
       "     'obtainAllPrivilege': False,\n",
       "     'obtainOtherPrivilege': False,\n",
       "     'obtainUserPrivilege': False,\n",
       "     'severity': 'HIGH',\n",
       "     'userInteractionRequired': True},\n",
       "    'baseMetricV3': {'cvssV3': {'attackComplexity': 'LOW',\n",
       "      'attackVector': 'NETWORK',\n",
       "      'availabilityImpact': 'HIGH',\n",
       "      'baseScore': 9.6,\n",
       "      'baseSeverity': 'CRITICAL',\n",
       "      'confidentialityImpact': 'HIGH',\n",
       "      'integrityImpact': 'HIGH',\n",
       "      'privilegesRequired': 'NONE',\n",
       "      'scope': 'CHANGED',\n",
       "      'userInteraction': 'REQUIRED',\n",
       "      'vectorString': 'CVSS:3.0/AV:N/AC:L/PR:N/UI:R/S:C/C:H/I:H/A:H',\n",
       "      'version': '3.0'},\n",
       "     'exploitabilityScore': 2.8,\n",
       "     'impactScore': 6.0}},\n",
       "   'lastModifiedDate': '2018-10-12T22:10Z',\n",
       "   'publishedDate': '2016-01-13T05:59Z'},\n",
       "  {'configurations': {'CVE_data_version': '4.0', 'nodes': []},\n",
       "   'cve': {'CVE_data_meta': {'ASSIGNER': 'cve@mitre.org',\n",
       "     'ID': 'CVE-2016-0004'},\n",
       "    'affects': {'vendor': {'vendor_data': []}},\n",
       "    'data_format': 'MITRE',\n",
       "    'data_type': 'CVE',\n",
       "    'data_version': '4.0',\n",
       "    'description': {'description_data': [{'lang': 'en',\n",
       "       'value': '** REJECT **  DO NOT USE THIS CANDIDATE NUMBER. ConsultIDs: none. Reason: The CNA or individual who requested this candidate did not associate it with any vulnerability during 2016. Notes: none.'}]},\n",
       "    'problemtype': {'problemtype_data': [{'description': []}]},\n",
       "    'references': {'reference_data': []}},\n",
       "   'impact': {},\n",
       "   'lastModifiedDate': '2017-05-11T14:29Z',\n",
       "   'publishedDate': '2017-05-11T14:29Z'},\n",
       "  {'configurations': {'CVE_data_version': '4.0',\n",
       "    'nodes': [{'cpe_match': [{'cpe23Uri': 'cpe:2.3:a:microsoft:internet_explorer:9:*:*:*:*:*:*:*',\n",
       "        'vulnerable': True},\n",
       "       {'cpe23Uri': 'cpe:2.3:a:microsoft:internet_explorer:10:*:*:*:*:*:*:*',\n",
       "        'vulnerable': True},\n",
       "       {'cpe23Uri': 'cpe:2.3:a:microsoft:internet_explorer:11:-:*:*:*:*:*:*',\n",
       "        'vulnerable': True}],\n",
       "      'operator': 'OR'}]},\n",
       "   'cve': {'CVE_data_meta': {'ASSIGNER': 'cve@mitre.org',\n",
       "     'ID': 'CVE-2016-0005'},\n",
       "    'affects': {'vendor': {'vendor_data': [{'product': {'product_data': [{'product_name': 'internet_explorer',\n",
       "           'version': {'version_data': [{'version_affected': '=',\n",
       "              'version_value': '9'},\n",
       "             {'version_affected': '=', 'version_value': '10'},\n",
       "             {'version_affected': '=', 'version_value': '11'}]}}]},\n",
       "        'vendor_name': 'microsoft'}]}},\n",
       "    'data_format': 'MITRE',\n",
       "    'data_type': 'CVE',\n",
       "    'data_version': '4.0',\n",
       "    'description': {'description_data': [{'lang': 'en',\n",
       "       'value': 'Microsoft Internet Explorer 9 through 11 allows remote attackers to bypass the Same Origin Policy via unspecified vectors, aka \"Internet Explorer Elevation of Privilege Vulnerability.\"'}]},\n",
       "    'problemtype': {'problemtype_data': [{'description': [{'lang': 'en',\n",
       "         'value': 'CWE-20'}]}]},\n",
       "    'references': {'reference_data': [{'name': '1034648',\n",
       "       'refsource': 'SECTRACK',\n",
       "       'tags': [],\n",
       "       'url': 'http://www.securitytracker.com/id/1034648'},\n",
       "      {'name': 'MS16-001',\n",
       "       'refsource': 'MS',\n",
       "       'tags': [],\n",
       "       'url': 'https://docs.microsoft.com/en-us/security-updates/securitybulletins/2016/ms16-001'}]}},\n",
       "   'impact': {'baseMetricV2': {'cvssV2': {'accessComplexity': 'MEDIUM',\n",
       "      'accessVector': 'NETWORK',\n",
       "      'authentication': 'NONE',\n",
       "      'availabilityImpact': 'NONE',\n",
       "      'baseScore': 4.3,\n",
       "      'confidentialityImpact': 'NONE',\n",
       "      'integrityImpact': 'PARTIAL',\n",
       "      'vectorString': 'AV:N/AC:M/Au:N/C:N/I:P/A:N',\n",
       "      'version': '2.0'},\n",
       "     'exploitabilityScore': 8.6,\n",
       "     'impactScore': 2.9,\n",
       "     'obtainAllPrivilege': False,\n",
       "     'obtainOtherPrivilege': False,\n",
       "     'obtainUserPrivilege': False,\n",
       "     'severity': 'MEDIUM',\n",
       "     'userInteractionRequired': True},\n",
       "    'baseMetricV3': {'cvssV3': {'attackComplexity': 'LOW',\n",
       "      'attackVector': 'NETWORK',\n",
       "      'availabilityImpact': 'NONE',\n",
       "      'baseScore': 4.3,\n",
       "      'baseSeverity': 'MEDIUM',\n",
       "      'confidentialityImpact': 'NONE',\n",
       "      'integrityImpact': 'LOW',\n",
       "      'privilegesRequired': 'NONE',\n",
       "      'scope': 'UNCHANGED',\n",
       "      'userInteraction': 'REQUIRED',\n",
       "      'vectorString': 'CVSS:3.0/AV:N/AC:L/PR:N/UI:R/S:U/C:N/I:L/A:N',\n",
       "      'version': '3.0'},\n",
       "     'exploitabilityScore': 2.8,\n",
       "     'impactScore': 1.4}},\n",
       "   'lastModifiedDate': '2018-10-12T22:10Z',\n",
       "   'publishedDate': '2016-01-13T05:59Z'}],\n",
       " 'CVE_data_format': 'MITRE',\n",
       " 'CVE_data_numberOfCVEs': '9852',\n",
       " 'CVE_data_timestamp': '2018-11-07T08:18Z',\n",
       " 'CVE_data_type': 'CVE',\n",
       " 'CVE_data_version': '4.0'}"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "json_data = json.loads(json_content)\n",
    "json_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'cve.affects'",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-148-6667e7d58a22>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[0;32m      1\u001b[0m result = json_normalize(\n\u001b[0;32m      2\u001b[0m     \u001b[0mdata\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;34m'CVE_Items'\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m----> 3\u001b[1;33m     'cve.affects', errors='ignore')\n\u001b[0m\u001b[0;32m      4\u001b[0m \u001b[0mresult\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\dev\\apps\\Anaconda3\\lib\\site-packages\\pandas\\io\\json\\normalize.py\u001b[0m in \u001b[0;36mjson_normalize\u001b[1;34m(data, record_path, meta, meta_prefix, record_prefix, errors, sep)\u001b[0m\n\u001b[0;32m    254\u001b[0m                 \u001b[0mrecords\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mextend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mrecs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    255\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 256\u001b[1;33m     \u001b[0m_recursive_extract\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mdata\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mrecord_path\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mlevel\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    257\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    258\u001b[0m     \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mDataFrame\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mrecords\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\dev\\apps\\Anaconda3\\lib\\site-packages\\pandas\\io\\json\\normalize.py\u001b[0m in \u001b[0;36m_recursive_extract\u001b[1;34m(data, path, seen_meta, level)\u001b[0m\n\u001b[0;32m    230\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    231\u001b[0m             \u001b[1;32mfor\u001b[0m \u001b[0mobj\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mdata\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 232\u001b[1;33m                 \u001b[0mrecs\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_pull_field\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mobj\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mpath\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    233\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    234\u001b[0m                 \u001b[1;31m# For repeating the metadata later\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mC:\\dev\\apps\\Anaconda3\\lib\\site-packages\\pandas\\io\\json\\normalize.py\u001b[0m in \u001b[0;36m_pull_field\u001b[1;34m(js, spec)\u001b[0m\n\u001b[0;32m    178\u001b[0m                 \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mresult\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mfield\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    179\u001b[0m         \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 180\u001b[1;33m             \u001b[0mresult\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mresult\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mspec\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    181\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    182\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mresult\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mKeyError\u001b[0m: 'cve.affects'"
     ]
    }
   ],
   "source": [
    "result = json_normalize(\n",
    "    data[0]['CVE_Items'],'cve.affects', errors='ignore')\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'CVE_Items': [{'configurations': {'CVE_data_version': '4.0',\n",
       "     'nodes': [{'cpe_match': [{'cpe23Uri': 'cpe:2.3:a:microsoft:edge:-:*:*:*:*:*:*:*',\n",
       "         'vulnerable': True}],\n",
       "       'operator': 'OR'}]},\n",
       "    'cve': {'CVE_data_meta': {'ASSIGNER': 'cve@mitre.org',\n",
       "      'ID': 'CVE-2016-0003'},\n",
       "     'affects': {'vendor': {'vendor_data': [{'product': {'product_data': [{'product_name': 'edge',\n",
       "            'version': {'version_data': [{'version_affected': '=',\n",
       "               'version_value': '-'}]}}]},\n",
       "         'vendor_name': 'microsoft'}]}},\n",
       "     'data_format': 'MITRE',\n",
       "     'data_type': 'CVE',\n",
       "     'data_version': '4.0',\n",
       "     'description': {'description_data': [{'lang': 'en',\n",
       "        'value': 'Microsoft Edge allows remote attackers to execute arbitrary code via unspecified vectors, aka \"Microsoft Edge Memory Corruption Vulnerability.\"'}]},\n",
       "     'problemtype': {'problemtype_data': [{'description': [{'lang': 'en',\n",
       "          'value': 'CWE-119'}]}]},\n",
       "     'references': {'reference_data': [{'name': '1034649',\n",
       "        'refsource': 'SECTRACK',\n",
       "        'tags': [],\n",
       "        'url': 'http://www.securitytracker.com/id/1034649'},\n",
       "       {'name': 'http://www.zerodayinitiative.com/advisories/ZDI-16-019',\n",
       "        'refsource': 'MISC',\n",
       "        'tags': [],\n",
       "        'url': 'http://www.zerodayinitiative.com/advisories/ZDI-16-019'},\n",
       "       {'name': 'MS16-002',\n",
       "        'refsource': 'MS',\n",
       "        'tags': [],\n",
       "        'url': 'https://docs.microsoft.com/en-us/security-updates/securitybulletins/2016/ms16-002'}]}},\n",
       "    'impact': {'baseMetricV2': {'cvssV2': {'accessComplexity': 'MEDIUM',\n",
       "       'accessVector': 'NETWORK',\n",
       "       'authentication': 'NONE',\n",
       "       'availabilityImpact': 'COMPLETE',\n",
       "       'baseScore': 9.3,\n",
       "       'confidentialityImpact': 'COMPLETE',\n",
       "       'integrityImpact': 'COMPLETE',\n",
       "       'vectorString': 'AV:N/AC:M/Au:N/C:C/I:C/A:C',\n",
       "       'version': '2.0'},\n",
       "      'exploitabilityScore': 8.6,\n",
       "      'impactScore': 10.0,\n",
       "      'obtainAllPrivilege': False,\n",
       "      'obtainOtherPrivilege': False,\n",
       "      'obtainUserPrivilege': False,\n",
       "      'severity': 'HIGH',\n",
       "      'userInteractionRequired': True},\n",
       "     'baseMetricV3': {'cvssV3': {'attackComplexity': 'LOW',\n",
       "       'attackVector': 'NETWORK',\n",
       "       'availabilityImpact': 'HIGH',\n",
       "       'baseScore': 9.6,\n",
       "       'baseSeverity': 'CRITICAL',\n",
       "       'confidentialityImpact': 'HIGH',\n",
       "       'integrityImpact': 'HIGH',\n",
       "       'privilegesRequired': 'NONE',\n",
       "       'scope': 'CHANGED',\n",
       "       'userInteraction': 'REQUIRED',\n",
       "       'vectorString': 'CVSS:3.0/AV:N/AC:L/PR:N/UI:R/S:C/C:H/I:H/A:H',\n",
       "       'version': '3.0'},\n",
       "      'exploitabilityScore': 2.8,\n",
       "      'impactScore': 6.0}},\n",
       "    'lastModifiedDate': '2018-10-12T22:10Z',\n",
       "    'publishedDate': '2016-01-13T05:59Z'},\n",
       "   {'configurations': {'CVE_data_version': '4.0', 'nodes': []},\n",
       "    'cve': {'CVE_data_meta': {'ASSIGNER': 'cve@mitre.org',\n",
       "      'ID': 'CVE-2016-0004'},\n",
       "     'affects': {'vendor': {'vendor_data': []}},\n",
       "     'data_format': 'MITRE',\n",
       "     'data_type': 'CVE',\n",
       "     'data_version': '4.0',\n",
       "     'description': {'description_data': [{'lang': 'en',\n",
       "        'value': '** REJECT **  DO NOT USE THIS CANDIDATE NUMBER. ConsultIDs: none. Reason: The CNA or individual who requested this candidate did not associate it with any vulnerability during 2016. Notes: none.'}]},\n",
       "     'problemtype': {'problemtype_data': [{'description': []}]},\n",
       "     'references': {'reference_data': []}},\n",
       "    'impact': {},\n",
       "    'lastModifiedDate': '2017-05-11T14:29Z',\n",
       "    'publishedDate': '2017-05-11T14:29Z'},\n",
       "   {'configurations': {'CVE_data_version': '4.0',\n",
       "     'nodes': [{'cpe_match': [{'cpe23Uri': 'cpe:2.3:a:microsoft:internet_explorer:9:*:*:*:*:*:*:*',\n",
       "         'vulnerable': True},\n",
       "        {'cpe23Uri': 'cpe:2.3:a:microsoft:internet_explorer:10:*:*:*:*:*:*:*',\n",
       "         'vulnerable': True},\n",
       "        {'cpe23Uri': 'cpe:2.3:a:microsoft:internet_explorer:11:-:*:*:*:*:*:*',\n",
       "         'vulnerable': True}],\n",
       "       'operator': 'OR'}]},\n",
       "    'cve': {'CVE_data_meta': {'ASSIGNER': 'cve@mitre.org',\n",
       "      'ID': 'CVE-2016-0005'},\n",
       "     'affects': {'vendor': {'vendor_data': [{'product': {'product_data': [{'product_name': 'internet_explorer',\n",
       "            'version': {'version_data': [{'version_affected': '=',\n",
       "               'version_value': '9'},\n",
       "              {'version_affected': '=', 'version_value': '10'},\n",
       "              {'version_affected': '=', 'version_value': '11'}]}}]},\n",
       "         'vendor_name': 'microsoft'}]}},\n",
       "     'data_format': 'MITRE',\n",
       "     'data_type': 'CVE',\n",
       "     'data_version': '4.0',\n",
       "     'description': {'description_data': [{'lang': 'en',\n",
       "        'value': 'Microsoft Internet Explorer 9 through 11 allows remote attackers to bypass the Same Origin Policy via unspecified vectors, aka \"Internet Explorer Elevation of Privilege Vulnerability.\"'}]},\n",
       "     'problemtype': {'problemtype_data': [{'description': [{'lang': 'en',\n",
       "          'value': 'CWE-20'}]}]},\n",
       "     'references': {'reference_data': [{'name': '1034648',\n",
       "        'refsource': 'SECTRACK',\n",
       "        'tags': [],\n",
       "        'url': 'http://www.securitytracker.com/id/1034648'},\n",
       "       {'name': 'MS16-001',\n",
       "        'refsource': 'MS',\n",
       "        'tags': [],\n",
       "        'url': 'https://docs.microsoft.com/en-us/security-updates/securitybulletins/2016/ms16-001'}]}},\n",
       "    'impact': {'baseMetricV2': {'cvssV2': {'accessComplexity': 'MEDIUM',\n",
       "       'accessVector': 'NETWORK',\n",
       "       'authentication': 'NONE',\n",
       "       'availabilityImpact': 'NONE',\n",
       "       'baseScore': 4.3,\n",
       "       'confidentialityImpact': 'NONE',\n",
       "       'integrityImpact': 'PARTIAL',\n",
       "       'vectorString': 'AV:N/AC:M/Au:N/C:N/I:P/A:N',\n",
       "       'version': '2.0'},\n",
       "      'exploitabilityScore': 8.6,\n",
       "      'impactScore': 2.9,\n",
       "      'obtainAllPrivilege': False,\n",
       "      'obtainOtherPrivilege': False,\n",
       "      'obtainUserPrivilege': False,\n",
       "      'severity': 'MEDIUM',\n",
       "      'userInteractionRequired': True},\n",
       "     'baseMetricV3': {'cvssV3': {'attackComplexity': 'LOW',\n",
       "       'attackVector': 'NETWORK',\n",
       "       'availabilityImpact': 'NONE',\n",
       "       'baseScore': 4.3,\n",
       "       'baseSeverity': 'MEDIUM',\n",
       "       'confidentialityImpact': 'NONE',\n",
       "       'integrityImpact': 'LOW',\n",
       "       'privilegesRequired': 'NONE',\n",
       "       'scope': 'UNCHANGED',\n",
       "       'userInteraction': 'REQUIRED',\n",
       "       'vectorString': 'CVSS:3.0/AV:N/AC:L/PR:N/UI:R/S:U/C:N/I:L/A:N',\n",
       "       'version': '3.0'},\n",
       "      'exploitabilityScore': 2.8,\n",
       "      'impactScore': 1.4}},\n",
       "    'lastModifiedDate': '2018-10-12T22:10Z',\n",
       "    'publishedDate': '2016-01-13T05:59Z'}],\n",
       "  'CVE_data_format': 'MITRE',\n",
       "  'CVE_data_numberOfCVEs': '9852',\n",
       "  'CVE_data_timestamp': '2018-11-07T08:18Z',\n",
       "  'CVE_data_type': 'CVE',\n",
       "  'CVE_data_version': '4.0'}]"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from pandas.io.json import json_normalize\n",
    "import json\n",
    "\n",
    "data = json.loads(\"[\" + json_content + \"]\")\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "metadata": {},
   "outputs": [],
   "source": [
    "def flatten_json(y):\n",
    "    out = {}\n",
    "\n",
    "    def flatten(x, name=''):\n",
    "        if type(x) is dict:\n",
    "            for a in x:\n",
    "                flatten(x[a], name + a + '_')\n",
    "        elif type(x) is list:\n",
    "            i = 0\n",
    "            for a in x:\n",
    "                flatten(a, name + str(i) + '_')\n",
    "                i += 1\n",
    "        else:\n",
    "            out[name[:-1]] = x\n",
    "\n",
    "    flatten(y)\n",
    "    return out"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 104,
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_configurations_CVE_data_version</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_configurations_nodes_0_cpe_match_0_cpe23Uri</th>\n",
       "      <td>cpe:2.3:a:microsoft:edge:-:*:*:*:*:*:*:*</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_configurations_nodes_0_cpe_match_0_vulnerable</th>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_configurations_nodes_0_operator</th>\n",
       "      <td>OR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_CVE_data_meta_ASSIGNER</th>\n",
       "      <td>cve@mitre.org</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_CVE_data_meta_ID</th>\n",
       "      <td>CVE-2016-0003</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_affects_vendor_vendor_data_0_product_product_data_0_product_name</th>\n",
       "      <td>edge</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_affects_vendor_vendor_data_0_product_product_data_0_version_version_data_0_version_affected</th>\n",
       "      <td>=</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_affects_vendor_vendor_data_0_product_product_data_0_version_version_data_0_version_value</th>\n",
       "      <td>-</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_affects_vendor_vendor_data_0_vendor_name</th>\n",
       "      <td>microsoft</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_data_format</th>\n",
       "      <td>MITRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_data_type</th>\n",
       "      <td>CVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_data_version</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_description_description_data_0_lang</th>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_description_description_data_0_value</th>\n",
       "      <td>Microsoft Edge allows remote attackers to exec...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_problemtype_problemtype_data_0_description_0_lang</th>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_problemtype_problemtype_data_0_description_0_value</th>\n",
       "      <td>CWE-119</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_0_name</th>\n",
       "      <td>1034649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_0_refsource</th>\n",
       "      <td>SECTRACK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_0_url</th>\n",
       "      <td>http://www.securitytracker.com/id/1034649</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_1_name</th>\n",
       "      <td>http://www.zerodayinitiative.com/advisories/ZD...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_1_refsource</th>\n",
       "      <td>MISC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_1_url</th>\n",
       "      <td>http://www.zerodayinitiative.com/advisories/ZD...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_2_name</th>\n",
       "      <td>MS16-002</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_2_refsource</th>\n",
       "      <td>MS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_cve_references_reference_data_2_url</th>\n",
       "      <td>https://docs.microsoft.com/en-us/security-upda...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_impact_baseMetricV2_cvssV2_accessComplexity</th>\n",
       "      <td>MEDIUM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_impact_baseMetricV2_cvssV2_accessVector</th>\n",
       "      <td>NETWORK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_impact_baseMetricV2_cvssV2_authentication</th>\n",
       "      <td>NONE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_0_impact_baseMetricV2_cvssV2_availabilityImpact</th>\n",
       "      <td>COMPLETE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_cvssV2_vectorString</th>\n",
       "      <td>AV:N/AC:M/Au:N/C:N/I:P/A:N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_cvssV2_version</th>\n",
       "      <td>2.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_exploitabilityScore</th>\n",
       "      <td>8.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_impactScore</th>\n",
       "      <td>2.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_obtainAllPrivilege</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_obtainOtherPrivilege</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_obtainUserPrivilege</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_severity</th>\n",
       "      <td>MEDIUM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV2_userInteractionRequired</th>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_attackComplexity</th>\n",
       "      <td>LOW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_attackVector</th>\n",
       "      <td>NETWORK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_availabilityImpact</th>\n",
       "      <td>NONE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_baseScore</th>\n",
       "      <td>4.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_baseSeverity</th>\n",
       "      <td>MEDIUM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_confidentialityImpact</th>\n",
       "      <td>NONE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_integrityImpact</th>\n",
       "      <td>LOW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_privilegesRequired</th>\n",
       "      <td>NONE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_scope</th>\n",
       "      <td>UNCHANGED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_userInteraction</th>\n",
       "      <td>REQUIRED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_vectorString</th>\n",
       "      <td>CVSS:3.0/AV:N/AC:L/PR:N/UI:R/S:U/C:N/I:L/A:N</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_cvssV3_version</th>\n",
       "      <td>3.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_exploitabilityScore</th>\n",
       "      <td>2.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_impact_baseMetricV3_impactScore</th>\n",
       "      <td>1.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_lastModifiedDate</th>\n",
       "      <td>2018-10-12T22:10Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_Items_2_publishedDate</th>\n",
       "      <td>2016-01-13T05:59Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_data_format</th>\n",
       "      <td>MITRE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_data_numberOfCVEs</th>\n",
       "      <td>9852</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_data_timestamp</th>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_data_type</th>\n",
       "      <td>CVE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>CVE_data_version</th>\n",
       "      <td>4.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>136 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                                                    0\n",
       "CVE_Items_0_configurations_CVE_data_version                                                       4.0\n",
       "CVE_Items_0_configurations_nodes_0_cpe_match_0_...           cpe:2.3:a:microsoft:edge:-:*:*:*:*:*:*:*\n",
       "CVE_Items_0_configurations_nodes_0_cpe_match_0_...                                               True\n",
       "CVE_Items_0_configurations_nodes_0_operator                                                        OR\n",
       "CVE_Items_0_cve_CVE_data_meta_ASSIGNER                                                  cve@mitre.org\n",
       "CVE_Items_0_cve_CVE_data_meta_ID                                                        CVE-2016-0003\n",
       "CVE_Items_0_cve_affects_vendor_vendor_data_0_pr...                                               edge\n",
       "CVE_Items_0_cve_affects_vendor_vendor_data_0_pr...                                                  =\n",
       "CVE_Items_0_cve_affects_vendor_vendor_data_0_pr...                                                  -\n",
       "CVE_Items_0_cve_affects_vendor_vendor_data_0_ve...                                          microsoft\n",
       "CVE_Items_0_cve_data_format                                                                     MITRE\n",
       "CVE_Items_0_cve_data_type                                                                         CVE\n",
       "CVE_Items_0_cve_data_version                                                                      4.0\n",
       "CVE_Items_0_cve_description_description_data_0_...                                                 en\n",
       "CVE_Items_0_cve_description_description_data_0_...  Microsoft Edge allows remote attackers to exec...\n",
       "CVE_Items_0_cve_problemtype_problemtype_data_0_...                                                 en\n",
       "CVE_Items_0_cve_problemtype_problemtype_data_0_...                                            CWE-119\n",
       "CVE_Items_0_cve_references_reference_data_0_name                                              1034649\n",
       "CVE_Items_0_cve_references_reference_data_0_ref...                                           SECTRACK\n",
       "CVE_Items_0_cve_references_reference_data_0_url             http://www.securitytracker.com/id/1034649\n",
       "CVE_Items_0_cve_references_reference_data_1_name    http://www.zerodayinitiative.com/advisories/ZD...\n",
       "CVE_Items_0_cve_references_reference_data_1_ref...                                               MISC\n",
       "CVE_Items_0_cve_references_reference_data_1_url     http://www.zerodayinitiative.com/advisories/ZD...\n",
       "CVE_Items_0_cve_references_reference_data_2_name                                             MS16-002\n",
       "CVE_Items_0_cve_references_reference_data_2_ref...                                                 MS\n",
       "CVE_Items_0_cve_references_reference_data_2_url     https://docs.microsoft.com/en-us/security-upda...\n",
       "CVE_Items_0_impact_baseMetricV2_cvssV2_accessCo...                                             MEDIUM\n",
       "CVE_Items_0_impact_baseMetricV2_cvssV2_accessVe...                                            NETWORK\n",
       "CVE_Items_0_impact_baseMetricV2_cvssV2_authenti...                                               NONE\n",
       "CVE_Items_0_impact_baseMetricV2_cvssV2_availabi...                                           COMPLETE\n",
       "...                                                                                               ...\n",
       "CVE_Items_2_impact_baseMetricV2_cvssV2_vectorSt...                         AV:N/AC:M/Au:N/C:N/I:P/A:N\n",
       "CVE_Items_2_impact_baseMetricV2_cvssV2_version                                                    2.0\n",
       "CVE_Items_2_impact_baseMetricV2_exploitabilityS...                                                8.6\n",
       "CVE_Items_2_impact_baseMetricV2_impactScore                                                       2.9\n",
       "CVE_Items_2_impact_baseMetricV2_obtainAllPrivilege                                              False\n",
       "CVE_Items_2_impact_baseMetricV2_obtainOtherPriv...                                              False\n",
       "CVE_Items_2_impact_baseMetricV2_obtainUserPrivi...                                              False\n",
       "CVE_Items_2_impact_baseMetricV2_severity                                                       MEDIUM\n",
       "CVE_Items_2_impact_baseMetricV2_userInteraction...                                               True\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_attackCo...                                                LOW\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_attackVe...                                            NETWORK\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_availabi...                                               NONE\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_baseScore                                                  4.3\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_baseSeve...                                             MEDIUM\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_confiden...                                               NONE\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_integrit...                                                LOW\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_privileg...                                               NONE\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_scope                                                UNCHANGED\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_userInte...                                           REQUIRED\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_vectorSt...       CVSS:3.0/AV:N/AC:L/PR:N/UI:R/S:U/C:N/I:L/A:N\n",
       "CVE_Items_2_impact_baseMetricV3_cvssV3_version                                                    3.0\n",
       "CVE_Items_2_impact_baseMetricV3_exploitabilityS...                                                2.8\n",
       "CVE_Items_2_impact_baseMetricV3_impactScore                                                       1.4\n",
       "CVE_Items_2_lastModifiedDate                                                        2018-10-12T22:10Z\n",
       "CVE_Items_2_publishedDate                                                           2016-01-13T05:59Z\n",
       "CVE_data_format                                                                                 MITRE\n",
       "CVE_data_numberOfCVEs                                                                            9852\n",
       "CVE_data_timestamp                                                                  2018-11-07T08:18Z\n",
       "CVE_data_type                                                                                     CVE\n",
       "CVE_data_version                                                                                  4.0\n",
       "\n",
       "[136 rows x 1 columns]"
      ]
     },
     "execution_count": 104,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "flattened_data = flatten_json(data)\n",
    "cve = json_normalize(flattened_data)\n",
    "cve.T"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "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>CVE_Items</th>\n",
       "      <th>CVE_data_format</th>\n",
       "      <th>CVE_data_numberOfCVEs</th>\n",
       "      <th>CVE_data_timestamp</th>\n",
       "      <th>CVE_data_type</th>\n",
       "      <th>CVE_data_version</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</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>9822</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9823</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9824</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9825</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9826</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9827</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9828</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9829</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9830</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9831</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9832</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9833</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9834</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9835</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9836</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9837</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9838</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9839</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9840</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9841</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9842</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9843</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9844</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9845</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9846</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9847</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9848</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9849</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9850</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9851</th>\n",
       "      <td>{'cve': {'data_type': 'CVE', 'data_format': 'M...</td>\n",
       "      <td>MITRE</td>\n",
       "      <td>9852</td>\n",
       "      <td>2018-11-07T08:18Z</td>\n",
       "      <td>CVE</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>9852 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              CVE_Items CVE_data_format  \\\n",
       "0     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "1     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "2     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "3     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "4     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "5     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "6     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "7     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "8     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9     {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "10    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "11    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "12    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "13    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "14    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "15    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "16    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "17    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "18    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "19    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "20    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "21    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "22    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "23    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "24    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "25    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "26    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "27    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "28    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "29    {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "...                                                 ...             ...   \n",
       "9822  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9823  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9824  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9825  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9826  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9827  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9828  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9829  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9830  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9831  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9832  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9833  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9834  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9835  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9836  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9837  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9838  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9839  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9840  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9841  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9842  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9843  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9844  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9845  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9846  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9847  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9848  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9849  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9850  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "9851  {'cve': {'data_type': 'CVE', 'data_format': 'M...           MITRE   \n",
       "\n",
       "      CVE_data_numberOfCVEs CVE_data_timestamp CVE_data_type  CVE_data_version  \n",
       "0                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "1                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "2                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "3                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "4                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "5                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "6                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "7                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "8                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9                      9852  2018-11-07T08:18Z           CVE                 4  \n",
       "10                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "11                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "12                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "13                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "14                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "15                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "16                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "17                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "18                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "19                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "20                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "21                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "22                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "23                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "24                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "25                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "26                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "27                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "28                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "29                     9852  2018-11-07T08:18Z           CVE                 4  \n",
       "...                     ...                ...           ...               ...  \n",
       "9822                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9823                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9824                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9825                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9826                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9827                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9828                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9829                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9830                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9831                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9832                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9833                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9834                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9835                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9836                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9837                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9838                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9839                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9840                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9841                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9842                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9843                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9844                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9845                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9846                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9847                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9848                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9849                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9850                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "9851                   9852  2018-11-07T08:18Z           CVE                 4  \n",
       "\n",
       "[9852 rows x 6 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "\n",
    "cve = pd.read_json(\"../demos/dataset/nvdcve-1.0-2016.json.gz\")\n",
    "cve"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}