MIT_ASS_.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "MIT_ASS_.ipynb",
      "provenance": [],
      "authorship_tag": "ABX9TyPtHkoNyZzoTM5G+4nMhhi/",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/vatsalcode/MIT_ASS_Intel_Extraction/blob/main/MIT_ASS_.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 667
        },
        "id": "JymIenXupbSE",
        "outputId": "a2ed02c7-5343-44f5-d43e-278aa69d6989"
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "import matplotlib.dates as mdates\n",
        "from matplotlib.ticker import MultipleLocator\n",
        "import seaborn as sns\n",
        "from datetime import datetime\n",
        "Intel_df=pd.read_csv(\"Intel_CPUs.csv\")\n",
        "Intel_df\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Product_Collection</th>\n",
              "      <th>Vertical_Segment</th>\n",
              "      <th>Processor_Number</th>\n",
              "      <th>Status</th>\n",
              "      <th>Launch_Date</th>\n",
              "      <th>Lithography</th>\n",
              "      <th>Recommended_Customer_Price</th>\n",
              "      <th>nb_of_Cores</th>\n",
              "      <th>nb_of_Threads</th>\n",
              "      <th>Processor_Base_Frequency</th>\n",
              "      <th>Max_Turbo_Frequency</th>\n",
              "      <th>Cache</th>\n",
              "      <th>Bus_Speed</th>\n",
              "      <th>TDP</th>\n",
              "      <th>Embedded_Options_Available</th>\n",
              "      <th>Conflict_Free</th>\n",
              "      <th>Max_Memory_Size</th>\n",
              "      <th>Memory_Types</th>\n",
              "      <th>Max_nb_of_Memory_Channels</th>\n",
              "      <th>Max_Memory_Bandwidth</th>\n",
              "      <th>ECC_Memory_Supported</th>\n",
              "      <th>Processor_Graphics_</th>\n",
              "      <th>Graphics_Base_Frequency</th>\n",
              "      <th>Graphics_Max_Dynamic_Frequency</th>\n",
              "      <th>Graphics_Video_Max_Memory</th>\n",
              "      <th>Graphics_Output</th>\n",
              "      <th>Support_4k</th>\n",
              "      <th>Max_Resolution_HDMI</th>\n",
              "      <th>Max_Resolution_DP</th>\n",
              "      <th>Max_Resolution_eDP_Integrated_Flat_Panel</th>\n",
              "      <th>DirectX_Support</th>\n",
              "      <th>OpenGL_Support</th>\n",
              "      <th>PCI_Express_Revision</th>\n",
              "      <th>PCI_Express_Configurations_</th>\n",
              "      <th>Max_nb_of_PCI_Express_Lanes</th>\n",
              "      <th>T</th>\n",
              "      <th>Intel_Hyper_Threading_Technology_</th>\n",
              "      <th>Intel_Virtualization_Technology_VTx_</th>\n",
              "      <th>Intel_64_</th>\n",
              "      <th>Instruction_Set</th>\n",
              "      <th>Instruction_Set_Extensions</th>\n",
              "      <th>Idle_States</th>\n",
              "      <th>Thermal_Monitoring_Technologies</th>\n",
              "      <th>Secure_Key</th>\n",
              "      <th>Execute_Disable_Bit</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>7th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-7Y75</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q3'16</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$393.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.30 GHz</td>\n",
              "      <td>3.60 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.05 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>8th Generation Intel® Core™ i5 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i5-8250U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q3'17</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$297.00</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.60 GHz</td>\n",
              "      <td>3.40 GHz</td>\n",
              "      <td>6 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>15 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>DDR4-2400, LPDDR3-2133</td>\n",
              "      <td>2.0</td>\n",
              "      <td>34.1 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>12.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>8th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-8550U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q3'17</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$409.00</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.80 GHz</td>\n",
              "      <td>4.00 GHz</td>\n",
              "      <td>8 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>15 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>DDR4-2400, LPDDR3-2133</td>\n",
              "      <td>2.0</td>\n",
              "      <td>34.1 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.15 GHz</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>12.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Intel® Core™ X-series Processors</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>i7-3820</td>\n",
              "      <td>End of Life</td>\n",
              "      <td>Q1'12</td>\n",
              "      <td>32 nm</td>\n",
              "      <td>$305.00</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>3.60 GHz</td>\n",
              "      <td>3.80 GHz</td>\n",
              "      <td>10 MB SmartCache</td>\n",
              "      <td>5 GT/s DMI2</td>\n",
              "      <td>130 W</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>64.23 GB</td>\n",
              "      <td>DDR3 1066/1333/1600</td>\n",
              "      <td>4.0</td>\n",
              "      <td>51.2 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>40.0</td>\n",
              "      <td>66.8°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.2, AVX, AES</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>7th Generation Intel® Core™ i5 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i5-7Y57</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q1'17</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$281.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.20 GHz</td>\n",
              "      <td>3.30 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>950 MHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2278</th>\n",
              "      <td>6th Generation Intel® Core™ m Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>M5-6Y54</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q3'15</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$281.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>2.70 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>900 MHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096@2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2279</th>\n",
              "      <td>6th Generation Intel® Core™ m Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>M5-6Y57</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q3'15</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$281.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>2.80 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>900 MHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096@2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2280</th>\n",
              "      <td>6th Generation Intel® Core™ m Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>M7-6Y75</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q3'15</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$393.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.20 GHz</td>\n",
              "      <td>3.10 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.00 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096@2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2281</th>\n",
              "      <td>5th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-5550U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q1'15</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$426.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.00 GHz</td>\n",
              "      <td>3.00 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>5 GT/s DMI2</td>\n",
              "      <td>15 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>DDR3L 1333/1600, LPDDR3 1600/1866</td>\n",
              "      <td>2.0</td>\n",
              "      <td>25.6 GB/s</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.00 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2560x1600@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.2/12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>4x1, 2x4</td>\n",
              "      <td>12.0</td>\n",
              "      <td>105°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2282</th>\n",
              "      <td>5th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-5557U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>Q1'15</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$426.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.10 GHz</td>\n",
              "      <td>3.40 GHz</td>\n",
              "      <td>4 MB</td>\n",
              "      <td>5 GT/s DMI2</td>\n",
              "      <td>28 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>DDR3L 1333/1600, LPDDR3 1600/1866</td>\n",
              "      <td>2.0</td>\n",
              "      <td>25.6 GB/s</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2560x1600@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.2/12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>4x1, 2x4</td>\n",
              "      <td>12.0</td>\n",
              "      <td>105°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2283 rows × 45 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Product_Collection  ... Execute_Disable_Bit\n",
              "0     7th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "1     8th Generation Intel® Core™ i5 Processors  ...                 Yes\n",
              "2     8th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "3              Intel® Core™ X-series Processors  ...                 Yes\n",
              "4     7th Generation Intel® Core™ i5 Processors  ...                 Yes\n",
              "...                                         ...  ...                 ...\n",
              "2278   6th Generation Intel® Core™ m Processors  ...                 Yes\n",
              "2279   6th Generation Intel® Core™ m Processors  ...                 Yes\n",
              "2280   6th Generation Intel® Core™ m Processors  ...                 Yes\n",
              "2281  5th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "2282  5th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "\n",
              "[2283 rows x 45 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 1
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Yn3xOiuhpqRs"
      },
      "source": [
        "Intel_df = Intel_df[np.invert(Intel_df[\"Launch_Date\"].isnull())]"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "i5aNYY0fprfQ"
      },
      "source": [
        "def sortmap(x):\n",
        "    firstPart = x[:2]\n",
        "    if firstPart[0] == \"0\":\n",
        "        temp = list(firstPart)\n",
        "        temp[0] = \"Q\"\n",
        "        firstPart = \"\".join(temp)\n",
        "    try:\n",
        "        restOfIt = int(x[3:])\n",
        "    except ValueError:\n",
        "        restOfIt = int(x[4:])\n",
        "    matcher = {\n",
        "        \"Q1\": \"-02\",\n",
        "        \"Q2\": \"-05\",\n",
        "        \"Q3\": \"-08\",\n",
        "        \"Q4\": \"-11\"\n",
        "    }\n",
        "    date = (\"20\" if restOfIt < 18 else \"19\") + str(restOfIt).rjust(2,\"0\") + matcher[firstPart]\n",
        "    return date\n",
        "\n",
        "Intel_df[\"Launch_Date\"] = Intel_df[\"Launch_Date\"].apply(sortmap)\n"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 667
        },
        "id": "bj0KHF1yqC7f",
        "outputId": "d0c7076c-a27c-47e9-a208-0edcd86cc49f"
      },
      "source": [
        "Intel_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Product_Collection</th>\n",
              "      <th>Vertical_Segment</th>\n",
              "      <th>Processor_Number</th>\n",
              "      <th>Status</th>\n",
              "      <th>Launch_Date</th>\n",
              "      <th>Lithography</th>\n",
              "      <th>Recommended_Customer_Price</th>\n",
              "      <th>nb_of_Cores</th>\n",
              "      <th>nb_of_Threads</th>\n",
              "      <th>Processor_Base_Frequency</th>\n",
              "      <th>Max_Turbo_Frequency</th>\n",
              "      <th>Cache</th>\n",
              "      <th>Bus_Speed</th>\n",
              "      <th>TDP</th>\n",
              "      <th>Embedded_Options_Available</th>\n",
              "      <th>Conflict_Free</th>\n",
              "      <th>Max_Memory_Size</th>\n",
              "      <th>Memory_Types</th>\n",
              "      <th>Max_nb_of_Memory_Channels</th>\n",
              "      <th>Max_Memory_Bandwidth</th>\n",
              "      <th>ECC_Memory_Supported</th>\n",
              "      <th>Processor_Graphics_</th>\n",
              "      <th>Graphics_Base_Frequency</th>\n",
              "      <th>Graphics_Max_Dynamic_Frequency</th>\n",
              "      <th>Graphics_Video_Max_Memory</th>\n",
              "      <th>Graphics_Output</th>\n",
              "      <th>Support_4k</th>\n",
              "      <th>Max_Resolution_HDMI</th>\n",
              "      <th>Max_Resolution_DP</th>\n",
              "      <th>Max_Resolution_eDP_Integrated_Flat_Panel</th>\n",
              "      <th>DirectX_Support</th>\n",
              "      <th>OpenGL_Support</th>\n",
              "      <th>PCI_Express_Revision</th>\n",
              "      <th>PCI_Express_Configurations_</th>\n",
              "      <th>Max_nb_of_PCI_Express_Lanes</th>\n",
              "      <th>T</th>\n",
              "      <th>Intel_Hyper_Threading_Technology_</th>\n",
              "      <th>Intel_Virtualization_Technology_VTx_</th>\n",
              "      <th>Intel_64_</th>\n",
              "      <th>Instruction_Set</th>\n",
              "      <th>Instruction_Set_Extensions</th>\n",
              "      <th>Idle_States</th>\n",
              "      <th>Thermal_Monitoring_Technologies</th>\n",
              "      <th>Secure_Key</th>\n",
              "      <th>Execute_Disable_Bit</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>7th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-7Y75</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2016-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$393.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.30 GHz</td>\n",
              "      <td>3.60 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.05 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>8th Generation Intel® Core™ i5 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i5-8250U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$297.00</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.60 GHz</td>\n",
              "      <td>3.40 GHz</td>\n",
              "      <td>6 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>15 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>DDR4-2400, LPDDR3-2133</td>\n",
              "      <td>2.0</td>\n",
              "      <td>34.1 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>12.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>8th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-8550U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$409.00</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>1.80 GHz</td>\n",
              "      <td>4.00 GHz</td>\n",
              "      <td>8 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>15 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>DDR4-2400, LPDDR3-2133</td>\n",
              "      <td>2.0</td>\n",
              "      <td>34.1 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.15 GHz</td>\n",
              "      <td>32 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>12.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Intel® Core™ X-series Processors</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>i7-3820</td>\n",
              "      <td>End of Life</td>\n",
              "      <td>2012-02</td>\n",
              "      <td>32 nm</td>\n",
              "      <td>$305.00</td>\n",
              "      <td>4</td>\n",
              "      <td>8.0</td>\n",
              "      <td>3.60 GHz</td>\n",
              "      <td>3.80 GHz</td>\n",
              "      <td>10 MB SmartCache</td>\n",
              "      <td>5 GT/s DMI2</td>\n",
              "      <td>130 W</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>64.23 GB</td>\n",
              "      <td>DDR3 1066/1333/1600</td>\n",
              "      <td>4.0</td>\n",
              "      <td>51.2 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>NaN</td>\n",
              "      <td>40.0</td>\n",
              "      <td>66.8°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.2, AVX, AES</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>7th Generation Intel® Core™ i5 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i5-7Y57</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-02</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$281.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.20 GHz</td>\n",
              "      <td>3.30 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>950 MHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2278</th>\n",
              "      <td>6th Generation Intel® Core™ m Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>M5-6Y54</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2015-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$281.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>2.70 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>900 MHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096@2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2279</th>\n",
              "      <td>6th Generation Intel® Core™ m Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>M5-6Y57</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2015-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$281.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>2.80 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>900 MHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096@2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2280</th>\n",
              "      <td>6th Generation Intel® Core™ m Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>M7-6Y75</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2015-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$393.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>1.20 GHz</td>\n",
              "      <td>3.10 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>4 GT/s OPI</td>\n",
              "      <td>4.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>LPDDR3-1866, DDR3L-1600</td>\n",
              "      <td>2.0</td>\n",
              "      <td>29.8 GB/s</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.00 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI/DVI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096@2304@24Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>1x4, 2x2, 1x2+2x1 and 4x1</td>\n",
              "      <td>10.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2281</th>\n",
              "      <td>5th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-5550U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2015-02</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$426.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>2.00 GHz</td>\n",
              "      <td>3.00 GHz</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>5 GT/s DMI2</td>\n",
              "      <td>15 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>DDR3L 1333/1600, LPDDR3 1600/1866</td>\n",
              "      <td>2.0</td>\n",
              "      <td>25.6 GB/s</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.00 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2560x1600@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.2/12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>4x1, 2x4</td>\n",
              "      <td>12.0</td>\n",
              "      <td>105°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2282</th>\n",
              "      <td>5th Generation Intel® Core™ i7 Processors</td>\n",
              "      <td>Mobile</td>\n",
              "      <td>i7-5557U</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2015-02</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$426.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.10 GHz</td>\n",
              "      <td>3.40 GHz</td>\n",
              "      <td>4 MB</td>\n",
              "      <td>5 GT/s DMI2</td>\n",
              "      <td>28 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>DDR3L 1333/1600, LPDDR3 1600/1866</td>\n",
              "      <td>2.0</td>\n",
              "      <td>25.6 GB/s</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>16 GB</td>\n",
              "      <td>eDP/DP/HDMI</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2560x1600@60Hz</td>\n",
              "      <td>3840x2160@60Hz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>11.2/12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2</td>\n",
              "      <td>4x1, 2x4</td>\n",
              "      <td>12.0</td>\n",
              "      <td>105°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1871 rows × 45 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Product_Collection  ... Execute_Disable_Bit\n",
              "0     7th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "1     8th Generation Intel® Core™ i5 Processors  ...                 Yes\n",
              "2     8th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "3              Intel® Core™ X-series Processors  ...                 Yes\n",
              "4     7th Generation Intel® Core™ i5 Processors  ...                 Yes\n",
              "...                                         ...  ...                 ...\n",
              "2278   6th Generation Intel® Core™ m Processors  ...                 Yes\n",
              "2279   6th Generation Intel® Core™ m Processors  ...                 Yes\n",
              "2280   6th Generation Intel® Core™ m Processors  ...                 Yes\n",
              "2281  5th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "2282  5th Generation Intel® Core™ i7 Processors  ...                 Yes\n",
              "\n",
              "[1871 rows x 45 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "xjKmuke4qfdt"
      },
      "source": [
        "import numpy as np\n",
        "import pandas as pd\n",
        "import matplotlib.pyplot as plt\n",
        "import matplotlib.dates as mdates\n",
        "from matplotlib.ticker import MultipleLocator\n",
        "import seaborn as sns\n",
        "from datetime import datetime\n",
        "Intel_df['year'] = pd.DatetimeIndex(Intel_df['Launch_Date']).year\n",
        "Intel_df['Processor_speed'] = Intel_df['Processor_Base_Frequency'].str.extract(r'(\\d+.\\d+)').astype('float')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 884
        },
        "id": "flLk-AQbqkn0",
        "outputId": "c411e9b1-5cbf-4565-c505-607d8831790b"
      },
      "source": [
        "Intel_df"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Product_Collection</th>\n",
              "      <th>Vertical_Segment</th>\n",
              "      <th>Processor_Number</th>\n",
              "      <th>Status</th>\n",
              "      <th>Launch_Date</th>\n",
              "      <th>Lithography</th>\n",
              "      <th>Recommended_Customer_Price</th>\n",
              "      <th>nb_of_Cores</th>\n",
              "      <th>nb_of_Threads</th>\n",
              "      <th>Processor_Base_Frequency</th>\n",
              "      <th>Max_Turbo_Frequency</th>\n",
              "      <th>Cache</th>\n",
              "      <th>Bus_Speed</th>\n",
              "      <th>TDP</th>\n",
              "      <th>Embedded_Options_Available</th>\n",
              "      <th>Conflict_Free</th>\n",
              "      <th>Max_Memory_Size</th>\n",
              "      <th>Memory_Types</th>\n",
              "      <th>Max_nb_of_Memory_Channels</th>\n",
              "      <th>Max_Memory_Bandwidth</th>\n",
              "      <th>ECC_Memory_Supported</th>\n",
              "      <th>Processor_Graphics_</th>\n",
              "      <th>Graphics_Base_Frequency</th>\n",
              "      <th>Graphics_Max_Dynamic_Frequency</th>\n",
              "      <th>Graphics_Video_Max_Memory</th>\n",
              "      <th>Graphics_Output</th>\n",
              "      <th>Support_4k</th>\n",
              "      <th>Max_Resolution_HDMI</th>\n",
              "      <th>Max_Resolution_DP</th>\n",
              "      <th>Max_Resolution_eDP_Integrated_Flat_Panel</th>\n",
              "      <th>DirectX_Support</th>\n",
              "      <th>OpenGL_Support</th>\n",
              "      <th>PCI_Express_Revision</th>\n",
              "      <th>PCI_Express_Configurations_</th>\n",
              "      <th>Max_nb_of_PCI_Express_Lanes</th>\n",
              "      <th>T</th>\n",
              "      <th>Intel_Hyper_Threading_Technology_</th>\n",
              "      <th>Intel_Virtualization_Technology_VTx_</th>\n",
              "      <th>Intel_64_</th>\n",
              "      <th>Instruction_Set</th>\n",
              "      <th>Instruction_Set_Extensions</th>\n",
              "      <th>Idle_States</th>\n",
              "      <th>Thermal_Monitoring_Technologies</th>\n",
              "      <th>Secure_Key</th>\n",
              "      <th>Execute_Disable_Bit</th>\n",
              "      <th>year</th>\n",
              "      <th>Processor_speed</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2074</th>\n",
              "      <td>Legacy Intel® Celeron® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>1999-02</td>\n",
              "      <td>250 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>128 KB L2</td>\n",
              "      <td>66 MHz FSB</td>\n",
              "      <td>17.8 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85°C</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>1999</td>\n",
              "      <td>300.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2027</th>\n",
              "      <td>Legacy Intel® Celeron® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>1999-02</td>\n",
              "      <td>250 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>366 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>128 KB L2</td>\n",
              "      <td>66 MHz FSB</td>\n",
              "      <td>21.7 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85°C</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>1999</td>\n",
              "      <td>366.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1988</th>\n",
              "      <td>Legacy Intel® Celeron® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>1999-05</td>\n",
              "      <td>250 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>433 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>128 KB L2</td>\n",
              "      <td>66 MHz FSB</td>\n",
              "      <td>24.1 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85°C</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>1999</td>\n",
              "      <td>433.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>107</th>\n",
              "      <td>Legacy Intel® Pentium® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>2000-02</td>\n",
              "      <td>180 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>700 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>256 KB L2</td>\n",
              "      <td>100 MHz FSB</td>\n",
              "      <td>18.3 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>80°C</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2000</td>\n",
              "      <td>700.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>97</th>\n",
              "      <td>Legacy Intel® Pentium® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>2000-02</td>\n",
              "      <td>180 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>866 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>256 KB L2</td>\n",
              "      <td>133 MHz FSB</td>\n",
              "      <td>26.1 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>80°C</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2000</td>\n",
              "      <td>866.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2220</th>\n",
              "      <td>7th Generation Intel® Core™ i3 Processors</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>i3-7300T</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-02</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$138.00 - $147.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.50 GHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>8 GT/s DMI3</td>\n",
              "      <td>35 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>DDR4-2133/2400, DDR3L-1333/1600 @ 1.35V</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>350 MHz</td>\n",
              "      <td>1.10 GHz</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>Up to 1x16, 2x8, 1x8+2x4</td>\n",
              "      <td>16.0</td>\n",
              "      <td>92°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>3.5</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2221</th>\n",
              "      <td>7th Generation Intel® Core™ i3 Processors</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>i3-7300</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-02</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$138.00 - $147.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.00 GHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>8 GT/s DMI3</td>\n",
              "      <td>51 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>DDR4-2133/2400, DDR3L-1333/1600 @ 1.35V</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>350 MHz</td>\n",
              "      <td>1.15 GHz</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>Up to 1x16, 2x8, 1x8+2x4</td>\n",
              "      <td>16.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>4.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2222</th>\n",
              "      <td>7th Generation Intel® Core™ i3 Processors</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>i3-7320</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-02</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$149.00 - $157.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.10 GHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4 MB SmartCache</td>\n",
              "      <td>8 GT/s DMI3</td>\n",
              "      <td>51 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>DDR4-2133/2400, DDR3L-1333/1600 @ 1.35V</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>350 MHz</td>\n",
              "      <td>1.15 GHz</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>Up to 1x16, 2x8, 1x8+2x4</td>\n",
              "      <td>16.0</td>\n",
              "      <td>100°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2, AVX 2.0</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>4.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1832</th>\n",
              "      <td>Intel® Pentium® Processor G Series</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>G4600T</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-02</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$75.00</td>\n",
              "      <td>2</td>\n",
              "      <td>4.0</td>\n",
              "      <td>3.00 GHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3 MB</td>\n",
              "      <td>8 GT/s DMI3</td>\n",
              "      <td>35 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>DDR4-2133/2400, DDR3L-1333/1600 @ 1.35V</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>350 MHz</td>\n",
              "      <td>1.05 GHz</td>\n",
              "      <td>64 GB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>4096x2304@24Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>4096x2304@60Hz</td>\n",
              "      <td>12</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>Up to 1x16, 2x8, 1x8+2x4</td>\n",
              "      <td>16.0</td>\n",
              "      <td>92°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>SSE4.1/4.2</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>3.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2081</th>\n",
              "      <td>Intel® Xeon® Scalable Processors</td>\n",
              "      <td>Server</td>\n",
              "      <td>4109T</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$501.00</td>\n",
              "      <td>8</td>\n",
              "      <td>16.0</td>\n",
              "      <td>2.00 GHz</td>\n",
              "      <td>3.00 GHz</td>\n",
              "      <td>11 MB L3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>70 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>768 GB</td>\n",
              "      <td>DDR4-2400</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>48.0</td>\n",
              "      <td>90°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Intel® SSE4.2, Intel® AVX, Intel® AVX2, Intel®...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1871 rows × 47 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                             Product_Collection  ... Processor_speed\n",
              "2074           Legacy Intel® Celeron® Processor  ...           300.0\n",
              "2027           Legacy Intel® Celeron® Processor  ...           366.0\n",
              "1988           Legacy Intel® Celeron® Processor  ...           433.0\n",
              "107            Legacy Intel® Pentium® Processor  ...           700.0\n",
              "97             Legacy Intel® Pentium® Processor  ...           866.0\n",
              "...                                         ...  ...             ...\n",
              "2220  7th Generation Intel® Core™ i3 Processors  ...             3.5\n",
              "2221  7th Generation Intel® Core™ i3 Processors  ...             4.0\n",
              "2222  7th Generation Intel® Core™ i3 Processors  ...             4.1\n",
              "1832         Intel® Pentium® Processor G Series  ...             3.0\n",
              "2081           Intel® Xeon® Scalable Processors  ...             2.0\n",
              "\n",
              "[1871 rows x 47 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 26
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 684
        },
        "id": "r-g-jb0SqyHY",
        "outputId": "365a2302-3fa9-41a7-cb9a-c90e7cf3fa04"
      },
      "source": [
        "Intel_df.sort_values(by=['year'])\n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "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>Product_Collection</th>\n",
              "      <th>Vertical_Segment</th>\n",
              "      <th>Processor_Number</th>\n",
              "      <th>Status</th>\n",
              "      <th>Launch_Date</th>\n",
              "      <th>Lithography</th>\n",
              "      <th>Recommended_Customer_Price</th>\n",
              "      <th>nb_of_Cores</th>\n",
              "      <th>nb_of_Threads</th>\n",
              "      <th>Processor_Base_Frequency</th>\n",
              "      <th>Max_Turbo_Frequency</th>\n",
              "      <th>Cache</th>\n",
              "      <th>Bus_Speed</th>\n",
              "      <th>TDP</th>\n",
              "      <th>Embedded_Options_Available</th>\n",
              "      <th>Conflict_Free</th>\n",
              "      <th>Max_Memory_Size</th>\n",
              "      <th>Memory_Types</th>\n",
              "      <th>Max_nb_of_Memory_Channels</th>\n",
              "      <th>Max_Memory_Bandwidth</th>\n",
              "      <th>ECC_Memory_Supported</th>\n",
              "      <th>Processor_Graphics_</th>\n",
              "      <th>Graphics_Base_Frequency</th>\n",
              "      <th>Graphics_Max_Dynamic_Frequency</th>\n",
              "      <th>Graphics_Video_Max_Memory</th>\n",
              "      <th>Graphics_Output</th>\n",
              "      <th>Support_4k</th>\n",
              "      <th>Max_Resolution_HDMI</th>\n",
              "      <th>Max_Resolution_DP</th>\n",
              "      <th>Max_Resolution_eDP_Integrated_Flat_Panel</th>\n",
              "      <th>DirectX_Support</th>\n",
              "      <th>OpenGL_Support</th>\n",
              "      <th>PCI_Express_Revision</th>\n",
              "      <th>PCI_Express_Configurations_</th>\n",
              "      <th>Max_nb_of_PCI_Express_Lanes</th>\n",
              "      <th>T</th>\n",
              "      <th>Intel_Hyper_Threading_Technology_</th>\n",
              "      <th>Intel_Virtualization_Technology_VTx_</th>\n",
              "      <th>Intel_64_</th>\n",
              "      <th>Instruction_Set</th>\n",
              "      <th>Instruction_Set_Extensions</th>\n",
              "      <th>Idle_States</th>\n",
              "      <th>Thermal_Monitoring_Technologies</th>\n",
              "      <th>Secure_Key</th>\n",
              "      <th>Execute_Disable_Bit</th>\n",
              "      <th>year</th>\n",
              "      <th>Processor_speed</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>2074</th>\n",
              "      <td>Legacy Intel® Celeron® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>1999-02</td>\n",
              "      <td>250 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>300 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>128 KB L2</td>\n",
              "      <td>66 MHz FSB</td>\n",
              "      <td>17.8 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85°C</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>1999</td>\n",
              "      <td>300.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2027</th>\n",
              "      <td>Legacy Intel® Celeron® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>1999-02</td>\n",
              "      <td>250 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>366 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>128 KB L2</td>\n",
              "      <td>66 MHz FSB</td>\n",
              "      <td>21.7 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85°C</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>1999</td>\n",
              "      <td>366.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1988</th>\n",
              "      <td>Legacy Intel® Celeron® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>1999-05</td>\n",
              "      <td>250 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>433 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>128 KB L2</td>\n",
              "      <td>66 MHz FSB</td>\n",
              "      <td>24.1 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>85°C</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>No</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>1999</td>\n",
              "      <td>433.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>118</th>\n",
              "      <td>Legacy Intel® Pentium® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>2000-02</td>\n",
              "      <td>180 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>733 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>256 KB L2</td>\n",
              "      <td>133 MHz FSB</td>\n",
              "      <td>22.8 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>80°C</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2000</td>\n",
              "      <td>733.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>80</th>\n",
              "      <td>Legacy Intel® Pentium® Processor</td>\n",
              "      <td>Desktop</td>\n",
              "      <td>NaN</td>\n",
              "      <td>End of Interactive Support</td>\n",
              "      <td>2000-02</td>\n",
              "      <td>180 nm</td>\n",
              "      <td>NaN</td>\n",
              "      <td>1</td>\n",
              "      <td>NaN</td>\n",
              "      <td>850 MHz</td>\n",
              "      <td>NaN</td>\n",
              "      <td>256 KB L2</td>\n",
              "      <td>100 MHz FSB</td>\n",
              "      <td>22.5 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>80°C</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>NaN</td>\n",
              "      <td>32-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2000</td>\n",
              "      <td>850.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>...</th>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "      <td>...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>541</th>\n",
              "      <td>Intel® Atom™ Processor C Series</td>\n",
              "      <td>Server</td>\n",
              "      <td>C3858</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$332.00</td>\n",
              "      <td>12</td>\n",
              "      <td>12.0</td>\n",
              "      <td>2.00 GHz</td>\n",
              "      <td>2.00 GHz</td>\n",
              "      <td>12 MB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>25 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>256 GB</td>\n",
              "      <td>DDR4: 2400</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>x2,x4,x8</td>\n",
              "      <td>16.0</td>\n",
              "      <td>83°C,100°C</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>540</th>\n",
              "      <td>Intel® Atom™ Processor C Series</td>\n",
              "      <td>Server</td>\n",
              "      <td>C3830</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$289.00</td>\n",
              "      <td>12</td>\n",
              "      <td>12.0</td>\n",
              "      <td>1.90 GHz</td>\n",
              "      <td>2.30 GHz</td>\n",
              "      <td>12 MB</td>\n",
              "      <td>NaN</td>\n",
              "      <td>21.5 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>256 GB</td>\n",
              "      <td>DDR4: 2133</td>\n",
              "      <td>2.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>x2,x4,x8</td>\n",
              "      <td>12.0</td>\n",
              "      <td>85°C,100°C</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>64-bit</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>1.9</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2124</th>\n",
              "      <td>Intel® Xeon® Scalable Processors</td>\n",
              "      <td>Server</td>\n",
              "      <td>8160F</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$4,856.00</td>\n",
              "      <td>24</td>\n",
              "      <td>48.0</td>\n",
              "      <td>2.10 GHz</td>\n",
              "      <td>3.70 GHz</td>\n",
              "      <td>33 MB L3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>160 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>768 GB</td>\n",
              "      <td>DDR4-2666</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>48.0</td>\n",
              "      <td>87°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Intel® SSE4.2, Intel® AVX, Intel® AVX2, Intel®...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>2.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2130</th>\n",
              "      <td>Intel® Xeon® Scalable Processors</td>\n",
              "      <td>Server</td>\n",
              "      <td>8170M</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$10,409.00</td>\n",
              "      <td>26</td>\n",
              "      <td>52.0</td>\n",
              "      <td>2.10 GHz</td>\n",
              "      <td>3.70 GHz</td>\n",
              "      <td>35.75 MB L3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>165 W</td>\n",
              "      <td>No</td>\n",
              "      <td>Yes</td>\n",
              "      <td>1.5 TB</td>\n",
              "      <td>DDR4-2666</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>48.0</td>\n",
              "      <td>89°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Intel® SSE4.2, Intel® AVX, Intel® AVX2, Intel®...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>2.1</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2081</th>\n",
              "      <td>Intel® Xeon® Scalable Processors</td>\n",
              "      <td>Server</td>\n",
              "      <td>4109T</td>\n",
              "      <td>Launched</td>\n",
              "      <td>2017-08</td>\n",
              "      <td>14 nm</td>\n",
              "      <td>$501.00</td>\n",
              "      <td>8</td>\n",
              "      <td>16.0</td>\n",
              "      <td>2.00 GHz</td>\n",
              "      <td>3.00 GHz</td>\n",
              "      <td>11 MB L3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>70 W</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>768 GB</td>\n",
              "      <td>DDR4-2400</td>\n",
              "      <td>6.0</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>3</td>\n",
              "      <td>NaN</td>\n",
              "      <td>48.0</td>\n",
              "      <td>90°C</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Yes</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Intel® SSE4.2, Intel® AVX, Intel® AVX2, Intel®...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>2017</td>\n",
              "      <td>2.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>1871 rows × 47 columns</p>\n",
              "</div>"
            ],
            "text/plain": [
              "                    Product_Collection Vertical_Segment  ...  year Processor_speed\n",
              "2074  Legacy Intel® Celeron® Processor          Desktop  ...  1999           300.0\n",
              "2027  Legacy Intel® Celeron® Processor          Desktop  ...  1999           366.0\n",
              "1988  Legacy Intel® Celeron® Processor          Desktop  ...  1999           433.0\n",
              "118   Legacy Intel® Pentium® Processor          Desktop  ...  2000           733.0\n",
              "80    Legacy Intel® Pentium® Processor          Desktop  ...  2000           850.0\n",
              "...                                ...              ...  ...   ...             ...\n",
              "541    Intel® Atom™ Processor C Series           Server  ...  2017             2.0\n",
              "540    Intel® Atom™ Processor C Series           Server  ...  2017             1.9\n",
              "2124  Intel® Xeon® Scalable Processors           Server  ...  2017             2.1\n",
              "2130  Intel® Xeon® Scalable Processors           Server  ...  2017             2.1\n",
              "2081  Intel® Xeon® Scalable Processors           Server  ...  2017             2.0\n",
              "\n",
              "[1871 rows x 47 columns]"
            ]
          },
          "metadata": {
            "tags": []
          },
          "execution_count": 28
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "OgmdLF9Qr4bT"
      },
      "source": [
        "Intel_df.to_csv('Modified1_data.csv')"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 264
        },
        "id": "mXpOT8GWsn17",
        "outputId": "d9575e3b-868c-4618-e42f-2d6ca996acff"
      },
      "source": [
        "import matplotlib.pyplot as plt\n",
        "import numpy as np\n",
        "import pandas as pd\n",
        "\n",
        "Graph1=pd.read_csv('Modified1_data.csv')\n",
        "plt.plot(Graph1.year,Graph1.Processor_speed,'r+')\n",
        "plt.show()"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYEAAAD4CAYAAAAKA1qZAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAS1ElEQVR4nO3dfaykZXnH8e8FK2x9gwW2SHc3HqxUQ21VeoogRk6lNUAbIClVaNXVYjamarW2qdgm3bNNmmrTSLU1VgNt0BBFUcvWYqkFlsSmUM+qoEApCxXZDS9H5KXGQKVc/WPu484eZ/bMmXnOvN3fTzI5z9vczzX3zJzfzD3PPBOZiSSpToeMugBJ0ugYApJUMUNAkipmCEhSxQwBSarYulEXAHDMMcfkzMzMqMuQpImye/fu72bmxkHaGIsQmJmZYWFhYdRlSNJEiYh7B23D4SBJqpghIEkVMwQkqWKGgCRVzBCQpIoZAk2Znx91BZK0aoZAU3bsGHUF6sRwlg7KENB0M5ylgzIEBjE/DxGtC+yf9tWnpAlhCAxifh4yWxfYP20IjJbhLPUsxuGXxWZnZ3PiTxsRsT8MND68XzTFImJ3Zs4O0obvBJqyffuoK5CkVTMEmuJQw3gynKdTE883n7OAw0GSJlETw3xTMFTocJAkaSCGgKTJ0MRRXx459mMcDpI0eRwOAhwOkiQNyBCQNHmaOOrLI8cAQ6Cl4vFAaSJ5iGhjDAHwJGOSqmUISFLF6g0BDxWTJA8RBabiUDFJ9fEQUUnSQAwBSapYvSEwN9f5M4G5uVFWJUlDtW7UBYzMrl37p/1MQFKl6n0nIEkyBAA4/fRRVyBJI2EIwIFDQ5JUEUNAkipmCEhSxXoKgYj4vYi4LSK+FRGfioj1EXF8RNwcEXsi4sqIOKxse3iZ31PWz6zlDRgbnm5iOnm/jqeZmVFXMDVWDIGI2AT8LjCbmS8BDgUuAD4AXJKZLwQeAS4qV7kIeKQsv6RsN/08E+l08n4dT/feO+oKpkavw0HrgJ+IiHXAM4H7gdcAV5X1lwPnlelzyzxl/RkRS9/IkiSNkxVDIDP3AX8JfIfWP//HgN3Ao5n5VNlsL7CpTG8C7ivXfapsf/TydiNiW0QsRMTC4uLioLdjNDwT6XTyfh1PMzOd7xeHhgay4llEI2ID8Dng9cCjwGdpvcKfL0M+RMQW4EuZ+ZKI+BZwZmbuLevuBl6Rmd/tto+Rn0W0CX7reDp5v44n7xdgeGcR/WXgvzNzMTN/CHweOA04sgwPAWwG9pXpfcCWUuA64Ajg4UGKlCStjV5C4DvAKRHxzDK2fwZwO3ADcH7ZZitwdZneWeYp66/PcfjRgrXmj1ZPJ+/X8fT854+6gqnR04/KRMQOWsNBTwFfB95Ka+z/08BRZdkbMvPJiFgPfBJ4OfA94ILMvOdg7U/FcJAkDVkTw0H+spgkTSh/WUySNBBDQJIqZghIUsUMAUmqmCEgSRUzBCSpYoYAwNzcqCuQpJEwBABuvHHUFUjSSBgCklSxekNgbq7zaWkdGpJUkXUrbzKldu3aP+1paSVVqt53ApIkQwCA008fdQWSNBKGAPg5gKRqGQIAO3aMugJJGglDQJIqVm8IzM93PkR0fn6UVUnSUPnLYuAhopImkr8sJkkaiCEAsH37qCuQpJEwBMDPASRVyxCQpIoZApJUMUOgKQ4pSZpAhkBT/NaxpAlkCEhSxQyBQfitY0kTzm8MN8VvHUsaMr8xLEkaiCHQFL91LGkCGQJN8XMASRPIEJCkihkCklQxQ0CSKtZTCETEkRFxVUT8Z0TcERGnRsRREfHliLir/N1Qto2I+HBE7ImIWyPipLW9CQ2YpvH8abot2m9ubtQVaEr1+k7gQ8A/Z+aLgZcCdwAXA9dl5gnAdWUe4CzghHLZBny00YrXwjSd8mGabov2u/HGUVegKbViCETEEcCrgcsAMvN/M/NR4Fzg8rLZ5cB5Zfpc4BPZchNwZEQc13jlkqSB9fJO4HhgEfj7iPh6RFwaEc8Cjs3M+8s2DwDHlulNwH1t199blh0gIrZFxEJELCwuLvZ/C/o1Tad8mKbbov3m5jrfrw4NqUErnjYiImaBm4DTMvPmiPgQ8Djwzsw8sm27RzJzQ0R8EXh/Zn6lLL8OeG9mdj0vxMhPGzFNp3yYptui/bxf1cGwThuxF9ibmTeX+auAk4AHl4Z5yt+Hyvp9wJa2628uyyRJY2bFEMjMB4D7IuJFZdEZwO3ATmBrWbYVuLpM7wTeVI4SOgV4rG3YaDxN0ykfpum2aL/TTx91BZpS63rc7p3AFRFxGHAP8BZaAfKZiLgIuBd4Xdn2GuBsYA/wg7KthsXPAabTrl2jrkBTylNJg+OtkiaSp5KWJA2k3hDwsEpJcjgIcDhI0kRyOEiSNBBDADysUlK1DAHwcwBJ1TIEJKlihoAkVcwQkKSKGQKSVDFDQJIqZghIUsUMAUmqmCEgSRUzBCSpYoaAJFXMEJCkihkCklQxQ0CSKmYISFLFDAFJqpghIEkVMwQkqWKGgCRVzBCQpIoZApJUsckPAX8kXpL6NvkhsGPHqCuQpIk1+SEgSerbZIbA/DxEtC6wf9qhIUlalcjMUdfA7OxsLiws9HflCBiD2yBJwxYRuzNzdpA2JvOdgCSpEZMfAtu3j7oCSZpYPYdARBwaEV+PiC+W+eMj4uaI2BMRV0bEYWX54WV+T1k/szalF34OIE2WJp6zh0z+69dxsZqefBdwR9v8B4BLMvOFwCPARWX5RcAjZfklZTtJamnisG4/B2xMTyEQEZuBXwUuLfMBvAa4qmxyOXBemT63zFPWn1G2lySNmV7fCfwV8IfA02X+aODRzHyqzO8FNpXpTcB9AGX9Y2X7A0TEtohYiIiFxcXFPsuXNBGaOKz7kEM6t+HQ0EBW7L2I+DXgoczc3eSOM/PjmTmbmbMbN25ssmlJ42Z+vjWEszSMszS9mhB4+unObTz99MGvp4Na18M2pwHnRMTZwHrgucCHgCMjYl15tb8Z2Fe23wdsAfZGxDrgCODhxiuXJA1sxXcCmfm+zNycmTPABcD1mflbwA3A+WWzrcDVZXpnmaesvz7H4RtpksZDE4d1+zFjYwYZTHsv8J6I2ENrzP+ysvwy4Oiy/D3AxYOVKGmqNHGIqENAjellOOhHMnMXsKtM3wOc3GGbJ4DfaKC23szP+10BSerT5H+s7qmkJalvkx8CkqS+TWYIeCppSWqEp5KWpAnlqaQlSQOZ/BDwVNKS1LfJDwE/B5Ckvk1+CEiS+mYISFLFDAFJqpghIEkVMwQkqWKTHwIeHSRJfZv8EPAEcpLUt8kPAUlS3yYzBDyBnCQ1whPISdKE8gRykqSBTH4IeAI5Serb5IeAnwNIUt8mPwQkSX0zBCSpYoaAJFXMEJCkihkCklQxQ0CSKmYISFLFDAFJqpghIEkVMwQkqWKGgCRVzBCQpIoZApJUMUNAkiq2YghExJaIuCEibo+I2yLiXWX5URHx5Yi4q/zdUJZHRHw4IvZExK0RcdJa3whJUn96eSfwFPD7mXkicArw9og4EbgYuC4zTwCuK/MAZwEnlMs24KONVy1JasSKIZCZ92fm18r0/wB3AJuAc4HLy2aXA+eV6XOBT2TLTcCREXFc45VLkga2qs8EImIGeDlwM3BsZt5fVj0AHFumNwH3tV1tb1m2vK1tEbEQEQuLi4urLFuS1ISeQyAing18Dnh3Zj7evi4zE8jV7DgzP56Zs5k5u3HjxtVcVZLUkJ5CICKeQSsArsjMz5fFDy4N85S/D5Xl+4AtbVffXJZJksZML0cHBXAZcEdmfrBt1U5ga5neClzdtvxN5SihU4DH2oaNJEljZF0P25wGvBH4ZkR8oyz7I+D9wGci4iLgXuB1Zd01wNnAHuAHwFsarViS1JgVQyAzvwJEl9VndNg+gbcPWJckaQj8xrAkVcwQkKSKGQKSVDFDQJIqZghIUsUMAUmqmCEgSRUzBCSpYoaAJFXMEJCkihkCklQxQ0CSKmYISFLFDAFJqpghIEkVMwQkqWKGgCRVzBCQpIoZApJUMUNAkipmCEhSxQwBSaqYISBJFTMEJKlihoAkVcwQkKSKGQKSVDFDQJIqZghIUsUMAUmqmCEgSRUzBCSpYoaAflyEbYxTDbZhG2toTUIgIs6MiDsjYk9EXLwW+2jU3NzgbczPD95GEw+G9esHb0NSNRoPgYg4FPgIcBZwInBhRJzY9H4adeONg7exY8fgbTThySdHXYGkCbJuDdo8GdiTmfcARMSngXOB29dgX2rK8nch7fOZdbUxDjXYhm0MyVoMB20C7mub31uWHSAitkXEQkQsLC4urkEZK5iba3X8UucvTa9maGh+vnMbqxkaWrrO8jZWMzS0fn3nNhwakrSCyIZTJyLOB87MzLeW+TcCr8jMd3S7zuzsbC4sLDRax6pEDJ6+tjGdbYxDDbZhG12vGrszc3aQ3a/FO4F9wJa2+c1lmSRpzKxFCHwVOCEijo+Iw4ALgJ1rsJ/mnH764G1s3z54G004/PBRVyBpgjT+wXBmPhUR7wCuBQ4F/i4zb2t6P43atWvwNpo4RLSJobknnhiPOqaljXGowTZsYw2txdFBZOY1wDVr0bYkqTl+Y1iSKmYISFLFDAFJqpghIEkVa/zLYn0VEbEI3DvCEo4BvjvC/fdqUuqEyanVOps3KbVOQ53Pz8yNgzQ+FiEwahGxMOi37oZhUuqEyanVOps3KbVaZ4vDQZJUMUNAkipmCLR8fNQF9GhS6oTJqdU6mzcptVonfiYgSVXznYAkVcwQkKSaZebEX2j9fsENtH7C8jbgXWX5UcCXgbvK3w1leQAfBvYAtwIntbW1tWx/F7C1y/46tjusOoGXAf9e2rgVeH2X/b0ZWAS+US5vHUF//l/b/nd22d/hwJXl+jcDM0Puz19qq/EbwBPAeU31Z5+1vrjcx08Cf7CsrTOBO8vtuHjEfdqxzm7tdNjfHPBYW5/+yQj689vAN8v+F7rsr+tjfEj9+aJlj9HHgXc30Z9r/g96GBfgOPY/oZ8D/BetH7n/i6UnCXAx8IEyfTbwpXLHngLc3HbH3FP+bijTP/YPvlu7Q6zzZ4ATyvRPAfcDR3bY35uBvxlVf5Z13+9hf78D/G2ZvgC4cth1trV5FPA94JlN9Weftf4k8IvAn3HgP4NDgbuBFwCHAbcAJ46wT7vV2bGdDvubA744qv4s674NHLPC/lZ87Kx1ncseAw/Q+qLYwP256gfzJFyAq4FfofVq6bi2O+POMv0x4MK27e8s6y8EPta2/IDtlm+/vN1h1dmhnVsoobBs+Zvp859WU3XSWwhcC5xaptfR+nZkjKI/gW3AFV3ab6Q/e6m1bbt5Dvzneipwbdv8+4D3japPu9XZrZ0Oy+foIwSarJPeQqCn5+Iw+hN4LfBvXdatuj+n7jOBiJgBXk7rLfCxmXl/WfUAcGyZ3gTc13a1vWVZt+XLdWt3WHW2t3MyrVeEd3fZ1a9HxK0RcVVEbOmyzVrWuT4iFiLipog4r8tufnT9zHyK1tvZo4dc55ILgE8dZFcD9ecqau2m18fosPp0te10cmpE3BIRX4qIn11NjQ3VmcC/RMTuiNjWZZte+30t61yy0mN0Vf05VSEQEc8GPkdrrOzx9nXZislsep/9tNtUnRFxHPBJ4C2Z+XSHTf6R1ljwz9Mad7x8BHU+P1tfef9N4K8i4qdXU8MQ61zqz5+j9Sq6k4H6s8la11qDfdq1neJrtB4jLwX+GviHEdT5qsw8CTgLeHtEvHo1NQyxTspP9p4DfLbLJqvuz6kJgYh4Bq1OviIzP18WP1ie2EtP8IfK8n20PrBZsrks67Z8uW7tDqtOIuK5wD8Bf5yZN3XaV2Y+nJlPltlLgV8Ydp2ZufT3HmAXrVdCy/3o+hGxDjgCeHiYdRavA76QmT/stK9B+rOPWrvp9TE6rD5dbTsHyMzHM/P7Zfoa4BkRccww62x7jD4EfAE4ucNmvfb7mtVZnAV8LTMf7LSyn/6cihCIiAAuA+7IzA+2rdpJ62gfyt+r25a/KVpOAR4rb82uBV4bERsiYgOtsbdOrwq7tTuUOsurgS8An8jMqw6yv+PaZs8B7hhynRsi4vDS5jHAabSOkliuvd3zgevLq6Oh1Nl2vQs5yNvsfvuzz1q7+SpwQkQcXx4HF5Q2lhtWn662neXbPa9suzS0eQg9hFWDdT4rIp6zNE3rOf+tDpuu9NhZ0zrbrPQYXX1/ruYDhHG9AK+i9XbqVvYfGnU2rTHQ62gdhvWvwFFl+wA+Qmsc/ZvAbFtbv03rMLA9tIZZlpZfurRdt3aHVSfwBuCHHHjI2MvKuj8FzinTf07rsLRbaB2m9uIh1/nKMn9L+XtR2z7a61xP6+3tHuA/gBeM4H6fofXK7pBl+xi4P/us9Xm0xp0fBx4t088t686mdZTJ3bTeCY6yTzvW2a2dcp23AW8r0+9o69ObgFcOuc4XlH3fUupo78/2Ors+doZ4vz+L1j/0I5btY6D+9LQRklSxqRgOkiT1xxCQpIoZApJUMUNAkipmCEhSxQwBSaqYISBJFft/Kxo+Br17brQAAAAASUVORK5CYII=\n",
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": [],
            "needs_background": "light"
          }
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "oHx3TXq9vJmm"
      },
      "source": [
        "def ProcessorMapper(x):\n",
        "    value = int(float(x[:-4]))\n",
        "    if x[-3] == \"G\":\n",
        "        value *= 1000\n",
        "    return value"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "XApgheAjNkfN"
      },
      "source": [
        "flatui = [\"#9b59b6\", \"#3498db\", \"#95a5a6\", \"#e74c3c\", \"#34495e\", \"#2ecc71\"]\n",
        "sns.set_palette(flatui)\n",
        "sns.set_style(\"ticks\", {\"xtick.major.size\": 8, \"ytick.major.size\": 8})"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YkanZG67NnHF"
      },
      "source": [
        "def cleanify(tag, func):\n",
        "    clean_df = Intel_df[np.invert(Intel_df[tag].isnull())].copy()\n",
        "    clean_df.reset_index()\n",
        "    clean_df[tag] = clean_df[tag].apply(func)\n",
        "    return clean_df\n",
        "intel_processor_base_freq = cleanify(\"Processor_Base_Frequency\", ProcessorMapper)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "PinpDDPmN6LV"
      },
      "source": [
        "def smoothify(tag, df, decreasing=False):\n",
        "    val_till_now = 0\n",
        "    if decreasing:\n",
        "        val_till_now = df[tag].max()\n",
        "    groups = df.groupby('Launch_Date')[tag].max().reset_index()\n",
        "    for index, values in groups.iterrows():\n",
        "        value = groups.loc[index,tag]\n",
        "        if decreasing:\n",
        "            if value < val_till_now:\n",
        "                val_till_now = value\n",
        "        else:\n",
        "            if value > val_till_now:\n",
        "                val_till_now = value\n",
        "        groups.loc[index,tag] = val_till_now\n",
        "    return groups\n",
        "smooth_intel_processor_base_freq = smoothify(\"Processor_Base_Frequency\", intel_processor_base_freq)"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "1a5camVDOQv0",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 998
        },
        "outputId": "802173b0-df8f-4cee-fcff-ef0ef937b299"
      },
      "source": [
        "def plot_graph(df, tag, title, y_multiples=250):\n",
        "    fig, ax = plt.subplots(figsize=(10, 7))\n",
        "\n",
        "    ax.plot(\n",
        "        pd.to_datetime(df[\"year\"]),\n",
        "        df[tag]\n",
        "    )\n",
        "    hfmt = mdates.DateFormatter(\"%Y\")\n",
        "\n",
        "    ax.xaxis.set_major_formatter(hfmt)\n",
        "    ax.yaxis.set_label_text(title)\n",
        "    ax.xaxis.set_major_locator(mdates.YearLocator())\n",
        "    ax.format_xdata = hfmt\n",
        "\n",
        "    ax.yaxis.set_major_locator(MultipleLocator(y_multiples))\n",
        "\n",
        "    plt.show()\n",
        "plot_graph(smooth_intel_processor_base_freq, \"Processor_Base_Frequency\", \"Max Processor Frequency available (in MHz)\")"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "error",
          "ename": "KeyError",
          "evalue": "ignored",
          "traceback": [
            "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
            "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2897\u001b[0m             \u001b[0;32mtry\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2898\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcasted_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2899\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
            "\u001b[0;31mKeyError\u001b[0m: 'year'",
            "\nThe above exception was the direct cause of the following exception:\n",
            "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
            "\u001b[0;32m<ipython-input-15-15a6ceeaaf02>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m     16\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     17\u001b[0m     \u001b[0mplt\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mshow\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 18\u001b[0;31m \u001b[0mplot_graph\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0msmooth_intel_processor_base_freq\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m\"Processor_Base_Frequency\"\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0;34m\"Max Processor Frequency available (in MHz)\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
            "\u001b[0;32m<ipython-input-15-15a6ceeaaf02>\u001b[0m in \u001b[0;36mplot_graph\u001b[0;34m(df, tag, title, y_multiples)\u001b[0m\n\u001b[1;32m      3\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      4\u001b[0m     ax.plot(\n\u001b[0;32m----> 5\u001b[0;31m         \u001b[0mpd\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mto_datetime\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m\"year\"\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m      6\u001b[0m         \u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mtag\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      7\u001b[0m     )\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pandas/core/frame.py\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   2904\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnlevels\u001b[0m \u001b[0;34m>\u001b[0m \u001b[0;36m1\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2905\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2906\u001b[0;31m             \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2907\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mis_integer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2908\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0;34m[\u001b[0m\u001b[0mindexer\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;32m/usr/local/lib/python3.7/dist-packages/pandas/core/indexes/base.py\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   2898\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mcasted_key\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2899\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m \u001b[0;32mas\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2900\u001b[0;31m                 \u001b[0;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;32mfrom\u001b[0m \u001b[0merr\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2901\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2902\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mtolerance\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
            "\u001b[0;31mKeyError\u001b[0m: 'year'"
          ]
        },
        {
          "output_type": "display_data",
          "data": {
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAlsAAAGfCAYAAABoVBdOAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAVRklEQVR4nO3dX2yV9f3A8U+11nCBRE085aLBLRKzhGZ4YYIXojvYNFC74QFX/0xdIpqYYFg0Mk2wM8w44qZLryANCWZiljrWaaAmbCkZTZTAzUgVlyiGOobrMZtd+OMCoTy/i2VkFfQcgQ/l7Pd63T15vn2eD/kGeOc5p+c0FUVRBAAAKS6b7gEAAP6XiS0AgERiCwAgkdgCAEgktgAAEoktAIBENWPrmWeeiVtuuSXuvPPOs54viiKef/756OjoiO7u7ti3b98FHxIAoFHVjK1KpRIbN2780vMjIyMxNjYWv//97+OnP/1pPPfccxdyPgCAhlYztm6++eaYNWvWl54fHh6OpUuXRlNTU8yfPz8OHz4cn3766QUdEgCgUTWf7wWq1Wq0traePm5tbY1qtRrXXXfdGWsHBgZiYGAgIiIOHDgQ3/jGN8739gAA6Q4dOhS7d+8+p58979j6Onp6eqKnpyci/v3y5ODg4MW8PQDAOalUKuf8s+f924ilUinGx8dPH4+Pj0epVDrfywIA/E8479gql8vxxhtvRFEUsXfv3pg5c+ZZX0IEAPj/qObLiE888UTs2bMnJiYmYuHChfH444/HyZMnIyLi3nvvjdtuuy127twZHR0dMWPGjHjhhRfShwYAaBQ1Y+vll1/+yvNNTU3xk5/85IINBADwv8QnyAMAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAECiumJrZGQkOjs7o6OjI/r7+884/8knn8QDDzwQS5cuje7u7ti5c+cFHxQAoBE111owOTkZa9eujU2bNkWpVIrly5dHuVyOG2644fSa9evXx+LFi+O+++6L/fv3x6OPPho7duxIHRwAoBHUfLI1Ojoac+bMiba2tmhpaYmurq4YHh6esqapqSmOHj0aERFHjhyJ6667LmdaAIAGU/PJVrVajdbW1tPHpVIpRkdHp6xZuXJlPPzww7F58+b417/+FZs2bTrrtQYGBmJgYCAiIiYmJs5nbgCAhnBB3iA/NDQUd911V4yMjER/f3+sXr06Tp06dca6np6eGBwcjMHBwbj66qsvxK0BAC5pNWOrVCrF+Pj46eNqtRqlUmnKmi1btsTixYsjIuKmm26K48ePe3IFABB1xFZ7e3uMjY3FwYMH48SJEzE0NBTlcnnKmtmzZ8euXbsiIuKjjz6K48ePxzXXXJMzMQBAA6n5nq3m5ubo7e2NFStWxOTkZCxbtizmzp0bfX19MW/evFi0aFE8/fTTsWbNmnjllVeiqakp1q1bF01NTRdjfgCAS1pTURTFdNy4UqnE4ODgdNwaAOBrOZ9u8QnyAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkKiu2BoZGYnOzs7o6OiI/v7+s6556623YsmSJdHV1RVPPvnkBR0SAKBRNddaMDk5GWvXro1NmzZFqVSK5cuXR7lcjhtuuOH0mrGxsejv749f//rXMWvWrPjHP/6ROjQAQKOo+WRrdHQ05syZE21tbdHS0hJdXV0xPDw8Zc3rr78e999/f8yaNSsiIq699tqcaQEAGkzNJ1vVajVaW1tPH5dKpRgdHZ2yZmxsLCIi7rnnnjh16lSsXLkyFi5ceMa1BgYGYmBgICIiJiYmzmduAICGUDO26jE5ORkff/xxvPrqqzE+Ph4/+MEPYuvWrXHVVVdNWdfT0xM9PT0REVGpVC7ErQEALmk1X0YslUoxPj5++rharUapVDpjTblcjiuuuCLa2tri+uuvP/20CwDg/7OasdXe3h5jY2Nx8ODBOHHiRAwNDUW5XJ6y5o477og9e/ZERMRnn30WY2Nj0dbWljMxAEADqfkyYnNzc/T29saKFSticnIyli1bFnPnzo2+vr6YN29eLFq0KG699dZ4++23Y8mSJXH55ZfH6tWr4+qrr74Y8wMAXNKaiqIopuPGlUolBgcHp+PWAABfy/l0i0+QBwBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgUV2xNTIyEp2dndHR0RH9/f1fum779u1x4403xrvvvnvBBgQAaGQ1Y2tycjLWrl0bGzdujKGhodi2bVvs37//jHVHjx6NX/3qV/Htb387ZVAAgEZUM7ZGR0djzpw50dbWFi0tLdHV1RXDw8NnrOvr64tHHnkkrrzyypRBAQAaUc3Yqlar0draevq4VCpFtVqdsmbfvn0xPj4et99++1dea2BgICqVSlQqlZiYmDi3iQEAGkjz+V7g1KlTsW7duvjZz35Wc21PT0/09PRERESlUjnfWwMAXPJqPtkqlUoxPj5++rharUapVDp9fOzYsfjggw/iwQcfjHK5HHv37o3HHnvMm+QBAKKOJ1vt7e0xNjYWBw8ejFKpFENDQ/HSSy+dPj9z5szYvXv36eMHHnggVq9eHe3t7TkTAwA0kJqx1dzcHL29vbFixYqYnJyMZcuWxdy5c6Ovry/mzZsXixYtuhhzAgA0pKaiKIrpuHGlUonBwcHpuDUAwNdyPt3iE+QBABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgkdgCAEgktgAAEoktAIBEYgsAIJHYAgBIJLYAABKJLQCARGILACCR2AIASCS2AAASiS0AgERiCwAgUV2xNTIyEp2dndHR0RH9/f1nnN+0aVMsWbIkuru746GHHopDhw5d8EEBABpRzdianJyMtWvXxsaNG2NoaCi2bdsW+/fvn7LmW9/6Vvz2t7+NrVu3RmdnZ/z85z9PGxgAoJHUjK3R0dGYM2dOtLW1RUtLS3R1dcXw8PCUNQsWLIgZM2ZERMT8+fNjfHw8Z1oAgAbTXGtBtVqN1tbW08elUilGR0e/dP2WLVti4cKFZz03MDAQAwMDERExMTHxdWcFAGg4NWPr63jzzTfjvffei82bN5/1fE9PT/T09ERERKVSuZC3BgC4JNWMrVKpNOVlwWq1GqVS6Yx177zzTmzYsCE2b94cLS0tF3ZKAIAGVfM9W+3t7TE2NhYHDx6MEydOxNDQUJTL5Slr3n///ejt7Y3169fHtddemzYsAECjqflkq7m5OXp7e2PFihUxOTkZy5Yti7lz50ZfX1/MmzcvFi1aFC+++GJ8/vnnsWrVqoiImD17dmzYsCF9eACAS11TURTFdNy4UqnE4ODgdNwaAOBrOZ9u8QnyAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkEhsAQAkElsAAInEFgBAIrEFAJBIbAEAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAEAisQUAkKiu2BoZGYnOzs7o6OiI/v7+M86fOHEifvSjH0VHR0fcfffd8de//vWCDwoA0Ihqxtbk5GSsXbs2Nm7cGENDQ7Ft27bYv3//lDW/+c1v4qqrroo//OEP8cMf/jB+8YtfpA0MANBIasbW6OhozJkzJ9ra2qKlpSW6urpieHh4ypodO3bEXXfdFRERnZ2dsWvXriiKImdiAIAG0lxrQbVajdbW1tPHpVIpRkdHz1gze/bsf1+wuTlmzpwZExMTcc0110xZNzAwEAMDAxER8cEHH0SlUjnvPwDTY2JiIq6++urpHoNzYO8am/1rXPausR04cOCcf7ZmbF1IPT090dPTExERlUolBgcHL+btuYDsX+Oyd43N/jUue9fYzucBUc2XEUulUoyPj58+rlarUSqVzljzt7/9LSIiTp48GUeOHFHvAABRR2y1t7fH2NhYHDx4ME6cOBFDQ0NRLpenrCmXy/G73/0uIiK2b98eCxYsiKamppyJAQAayOXPPffcc1+14LLLLovrr78+nnrqqdi8eXN897vfjc7Ozujr64tjx47FN7/5zbjxxhtj69at8fLLL8ef//znWLt2bcyaNavmzefNm3eh/hxMA/vXuOxdY7N/jcveNbZz3b+mwq8NAgCk8QnyAACJxBYAQKL02PJVP42r1t5t2rQplixZEt3d3fHQQw/FoUOHpmFKvkyt/fuP7du3x4033hjvvvvuRZyOWurZv7feeiuWLFkSXV1d8eSTT17kCfkytfbuk08+iQceeCCWLl0a3d3dsXPnzmmYkrN55pln4pZbbok777zzrOeLoojnn38+Ojo6oru7O/bt21ffhYtEJ0+eLBYtWlT85S9/KY4fP150d3cXH3744ZQ1mzdvLp599tmiKIpi27ZtxapVqzJHok717N2uXbuKzz//vCiKonjttdfs3SWknv0riqI4cuRIcd999xV33313MTo6Og2Tcjb17N+BAweK733ve8U///nPoiiK4u9///t0jMoX1LN3a9asKV577bWiKIriww8/LL7zne9Mx6icxZ49e4r33nuv6OrqOuv5P/7xj8XDDz9cnDp1qvjTn/5ULF++vK7rpj7Z8lU/jauevVuwYEHMmDEjIiLmz58/5fPYmF717F9ERF9fXzzyyCNx5ZVXTsOUfJl69u/111+P+++///Rvfl977bXTMSpfUM/eNTU1xdGjRyMi4siRI3HddddNx6icxc033/yVn6YwPDwcS5cujaamppg/f34cPnw4Pv3005rXTY2ts33VT7VaPWPN2b7qh+lVz979ty1btsTChQsvxmjUoZ7927dvX4yPj8ftt99+kaejlnr2b2xsLA4cOBD33HNPfP/734+RkZGLPSZnUc/erVy5MrZu3RoLFy6MRx99NNasWXOxx+QcfXF/W1tbv/L/xv/wBnnO25tvvhnvvfderFixYrpHoU6nTp2KdevWxY9//OPpHoVzNDk5GR9//HG8+uqr8dJLL8Wzzz4bhw8fnu6xqMPQ0FDcddddMTIyEv39/bF69eo4derUdI9FotTY8lU/jauevYuIeOedd2LDhg2xfv36aGlpuZgj8hVq7d+xY8figw8+iAcffDDK5XLs3bs3HnvsMW+Sv0TU+29nuVyOK664Itra2uL666+PsbGxizwpX1TP3m3ZsiUWL14cERE33XRTHD9+3Cs6DeKL+zs+Pn7W/xu/KDW2fNVP46pn795///3o7e2N9evXe7/IJabW/s2cOTN2794dO3bsiB07dsT8+fNj/fr10d7ePo1T8x/1/P274447Ys+ePRER8dlnn8XY2Fi0tbVNx7j8l3r2bvbs2bFr166IiPjoo4/i+PHjcc0110zHuHxN5XI53njjjSiKIvbu3RszZ86s6z13zZlDNTc3R29vb6xYsSImJydj2bJlMXfu3Ojr64t58+bFokWLYvny5fHUU09FR0dHzJo1K375y19mjkSd6tm7F198MT7//PNYtWpVRPz7H5ANGzZM8+RE1Ld/XLrq2b9bb7013n777ViyZElcfvnlsXr1aq8KXALq2bunn3461qxZE6+88ko0NTXFunXrPGS4RDzxxBOxZ8+emJiYiIULF8bjjz8eJ0+ejIiIe++9N2677bbYuXNndHR0xIwZM+KFF16o67q+rgcAIJE3yAMAJBJbAACJxBYAQCKxBQCQSGwBACQSWwAAicQWAECi/wPmHk/epw/JKQAAAABJRU5ErkJggg==\n",
            "text/plain": [
              "<Figure size 720x504 with 1 Axes>"
            ]
          },
          "metadata": {
            "tags": []
          }
        }
      ]
    }
  ]
}