G10.csv,project.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# csv"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "A CSV file (Comma Separated Values file) is a type of plain text file that uses specific structuring to arrange tabular data."
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "PYTHON PROGRAM ON CSV FILE TO FECTH THE DATA THROUGH THE EXCEL SHEET TO FIND THE PATICULAR PARAMETER"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# INDIAN FOOD"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Boondi : Rajasthan sweet\n"
     ]
    }
   ],
   "source": [
    "'''This is the excel sheet of indianfood like Sweets and Spicy form Diffrent State's \n",
    " condition is to find there paticular (parameters)'''\n",
    "\n",
    "# INDIAN FOOD \n",
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/indian_food.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    # i=0\n",
    "    for line in data:\n",
    "        # i=i+1\n",
    "        # if i==1:\n",
    "            \n",
    "     # Finding paticular food from which state it is and it's sweet or spicy\n",
    "    \n",
    "      if line[0] == \"Boondi\":\n",
    "        print(line[0],\":\",line[7],line[5])\n",
    "              \n",
    "      #   # Finding all the food like Sweet and spicy\n",
    "       \n",
    "      #   if line[7] == \"Karnataka\":\n",
    "      #     print(line[7],line[0])\n",
    "\n",
    "      #     # paticular igredent used for sweet or spicy\n",
    "          \n",
    "      #     if line[0]==\"Lassi\":\n",
    "      #       print(line[0],line[1])\n",
    "\n",
    "      #       # to chack it is veg or non veg food\n",
    "            \n",
    "      #       if line[0]==\"Biryani\":\n",
    "      #           print(line[0],\"is\",line[2])\n",
    "               \n",
    "      #           # to check it is sweet or spicy,\n",
    "                \n",
    "      #           if line[0]==\"Obbattu holige\":\n",
    "      #             print(line[0],\"is\",line[5])\n"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The program to print all the food from paticular (STATE)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Karnataka : Dharwad pedha\n",
      "Karnataka : Mysore pak\n",
      "Karnataka : Obbattu holige\n",
      "Karnataka : Bisi bele bath\n",
      "Karnataka : Koshambri\n",
      "Karnataka : Sandige\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/indian_food.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    for line in data:\n",
    "\n",
    "# Finding all the food like Sweet and spicy from paticular state\n",
    "\n",
    "        if line[7] == \"Karnataka\":\n",
    "            print(line[7],\":\",line[0])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This  is the program to print all ingredents of a specific food"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Dharwad pedha : Milk, Sugar, Dharwadi buffalo milk\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/indian_food.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    # i=0\n",
    "    for line in data:\n",
    "\n",
    " \n",
    "# paticular ingredent used for sweet or spicy\n",
    "          \n",
    "        if line[0]==\"Dharwad pedha\":\n",
    "            print(line[0],\":\",line[1])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The program to know wether the food is (Veg or Non-Veg)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Biryani is non vegetarian\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/indian_food.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    # i=0\n",
    "    for line in data:\n",
    "\n",
    "# to chack it is veg or non veg food\n",
    "            \n",
    "            if line[0]==\"Biryani\":\n",
    "                print(line[0],\"is\",line[2])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# STUDENT INFORMATION"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Surname', 'First name', 'Email address', 'Grade/30.00']\n",
      "['Tanveer', 'Muhammad Usama', 'cs181017@kfueit.edu.pk', '18']\n",
      "['Khan', 'Muneeb Hassan', 'cosc18131128@kfueit.edu.pk', '23']\n",
      "['Ali', 'Usama', 'cosc19231030@kfueit.edu.pk', '21']\n",
      "['.', 'Zulqarnane', 'cs171203@kfueit.edu.pk', '26']\n",
      "['Ali', 'Mohammad Muneeb', 'cs171137@kfueit.edu.pk', '26']\n",
      "['Rafiq', 'Zainab Shakir', 'cs172076@kfueit.edu.pk', '16']\n",
      "['Shahid', 'Muhammad Hamza', 'cs171198@kfueit.edu.pk', '26']\n",
      "['Ahmad', 'Ahmad Bilal', 'cs171185@kfueit.edu.pk', '25']\n",
      "['NAEEM', 'NAJAF', 'cosc19131003@kfueit.edu.pk', '21']\n",
      "['Ijaz', 'Aman', 'cs181029@kfueit.edu.pk', '24']\n",
      "['Sajjad', 'Mian Talha', 'cs172126@kfueit.edu.pk', '23']\n",
      "['Ahmad', 'Usama', 'cs181053@kfueit.edu.pk', '15']\n",
      "['ALI', 'MAISIM', 'cosc19131015@kfueit.edu.pk', '15']\n",
      "['ALI', 'QADIR', 'cosc19131007@kfueit.edu.pk', '27']\n",
      "['Ali', 'Mohammad Haseeb', 'cs171194@kfueit.edu.pk', '26']\n",
      "['AHMED', 'JAM', 'cosc19131052@kfueit.edu.pk', '18']\n",
      "['Imtiaz', 'Sikandar', 'cs171009@kfueit.edu.pk', '27']\n",
      "['KUMAR', 'DALEEP', 'cosc19131029@kfueit.edu.pk', '28']\n",
      "['FAROOQ', 'JUNAID', 'cosc19131001@kfueit.edu.pk', '27']\n",
      "['Almas', 'Mah Jabeen', 'cosc19231016@kfueit.edu.pk', '15']\n",
      "['IRFAN', 'KHANSA', 'cosc19231014@kfueit.edu.pk', '12']\n",
      "['ASHRAF', 'REHMAN', 'cosc19131035@kfueit.edu.pk', '14']\n",
      "['.', 'Hina Murtaza', 'cosc19231034@kfueit.edu.pk', '7']\n",
      "['FATIMA', 'GHULAM', 'cosc19131032@kfueit.edu.pk', '11']\n",
      "['IKRAM', 'HAMZA', 'cosc19131018@kfueit.edu.pk', '28']\n",
      "['HAMZA', 'MUHAMMAD ALI', 'cosc19131043@kfueit.edu.pk', '28']\n",
      "['KUMAR', 'VIJAY', 'cosc19131030@kfueit.edu.pk', '27']\n",
      "['SALEEM', 'SANA', 'cosc19131005@kfueit.edu.pk', '16']\n",
      "['ALI', 'ARSLAN', 'cosc19131034@kfueit.edu.pk', '28']\n",
      "['SAKHAWAT', 'MARIA', 'cosc19131045@kfueit.edu.pk', '11']\n",
      "['ASGHAR', 'ALI', 'cosc19131036@kfueit.edu.pk', '27']\n",
      "['LIAQAT', 'USMAN', 'cosc19131008@kfueit.edu.pk', '17']\n",
      "['Saeed', 'Iqra', 'cosc19231011@kfueit.edu.pk', '12']\n",
      "['Bilal', 'Muhammad', 'cs181048@kfueit.edu.pk', '11']\n",
      "['RAHEEL', 'MUHAMMAD', 'cosc19131022@kfueit.edu.pk', '24']\n",
      "['SATTAR', 'FAREEHA', 'cosc19131017@kfueit.edu.pk', '24']\n",
      "['Farooq', 'Saim', 'cosc18131073@kfueit.edu.pk', '22']\n",
      "['.', 'MUHAMMAD NAZIM', 'cosc19131026@kfueit.edu.pk', '15']\n",
      "['Azhar', 'Hamza', 'cs172167@kfueit.edu.pk', '24']\n",
      "['QASIM', 'HINA', 'cosc19131013@kfueit.edu.pk', '16']\n",
      "['IRSHAD', 'KANWAL', 'cosc19131012@kfueit.edu.pk', '17']\n",
      "['HUSSAIN', 'ALI', 'cosc19131044@kfueit.edu.pk', '18']\n",
      "['KOMAL', 'KAINAT', 'cosc19131011@kfueit.edu.pk', '14']\n",
      "['ABID', 'MUHAMMAD TALHA', 'cosc19131024@kfueit.edu.pk', '23']\n",
      "['IFTIKHAR', 'SHIZA', 'cosc19131014@kfueit.edu.pk', '16']\n",
      "['KFUEIT', 'cosc19131051', 'cosc19131051@kfueit.edu.pk', '23']\n",
      "['BILAL', 'MUHAMMAD', 'cosc19131033@kfueit.edu.pk', '19']\n",
      "['ZIA', 'KASHAF', 'cosc19131040@kfueit.edu.pk', '18']\n",
      "['JAVAID', 'ASAD', 'cosc19131039@kfueit.edu.pk', '18']\n",
      "['FAROOQ', 'KHANSA', 'cosc19131049@kfueit.edu.pk', '26']\n",
      "['ARSHAD', 'MUHAMMAD', 'cosc19131002@kfueit.edu.pk', '17']\n",
      "['TALIB', 'KIRAN', 'cosc19131028@kfueit.edu.pk', '14']\n",
      "['RAUF', 'FAIZA ABDUL', 'cosc19131048@kfueit.edu.pk', '15']\n",
      "['AFZAL', 'MOAZAM', 'cosc19131041@kfueit.edu.pk', '18']\n",
      "['SHOUKAT', 'AYESHA', 'cosc19131004@kfueit.edu.pk', '20']\n",
      "['Ghous', 'Muhammad Safdar', 'cs181021@kfueit.edu.pk', '12']\n",
      "['Afzal', 'Abu Nasar', 'cosc18131111@kfueit.edu.pk', '21']\n",
      "['Shoaib', 'Syed Muhammad', 'cs181039@kfueit.edu.pk', '23']\n",
      "['IMRAN', 'MUHAMMAD', 'cosc19131019@kfueit.edu.pk', '19']\n",
      "['BIBI', 'SUMAIRA', 'cosc19131031@kfueit.edu.pk', '15']\n",
      "['Javed', 'Arbaz', 'cs181042@kfueit.edu.pk', '14']\n",
      "['AFZAL', 'MINAHIL', 'cosc19131009@kfueit.edu.pk', '12']\n",
      "['Arshad', 'Kiran', 'cosc18131106@kfueit.edu.pk', '18']\n",
      "['ASLAM', 'SAMINA', 'cosc19131027@kfueit.edu.pk', '17']\n",
      "['ILYAS', 'MUHAMMAD', 'cosc19131037@kfueit.edu.pk', '30']\n",
      "['Kamiii', 'KAMRAN AKBAR', 'cosc19131042@kfueit.edu.pk', '30']\n",
      "['Ejaz', 'Zawar', 'cs181043@kfueit.edu.pk', '12']\n",
      "['ATTIQ', 'RIZWAN', 'cosc19131021@kfueit.edu.pk', '22']\n",
      "['ASHIQ', 'AYESHA', 'cosc19131023@kfueit.edu.pk', '11']\n",
      "['Khan', 'Sallar', 'cs171128@kfueit.edu.pk', '13']\n",
      "['.', 'ESHA AMJAD', 'cosc19131038@kfueit.edu.pk', '12']\n",
      "['AMANAT', 'KAINAT', 'cosc19131010@kfueit.edu.pk', '5']\n",
      "['NAWAZ', 'RIMSHA', 'cosc19131046@kfueit.edu.pk', '5']\n",
      "['Salar', ' Khan', 'cs171128@kfueit.edu.pk', '10']\n",
      "['Hafiz', 'Fahad', 'cs171135', '12']\n"
     ]
    }
   ],
   "source": [
    "# STUDENT INFORMATION\n",
    "import csv\n",
    "\n",
    "#  this csv file have 4 data\n",
    "# ([0],surname).([1]firstname).([2],email.id).([3],grade)\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/MCS-3A-MID-1.csv\",\"r\") as file:\n",
    "   data=csv.reader(file)\n",
    "    # copy the path were the excel(csv) file  is saved\n",
    "   for line in data:\n",
    "      print(line)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "This is to add a paticular Student name and to check there Grade"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fahad 12\n"
     ]
    }
   ],
   "source": [
    "if line[1]==\"Fahad\":\n",
    "    print(line[1],line[3])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# LAPTOP DETAILS"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Manufacturer', 'Model Name', 'Category', 'Screen Size', 'Screen', 'CPU', 'RAM', ' Storage', 'GPU', 'Operating System', 'Operating System Version', 'Weight', 'Price']\n",
      "['HP', '15-bs053od (i7-7500U/6GB/1TB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 7500U 2.7GHz', '6GB', '1TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.04kg', '5148468']\n",
      "['Asus', 'Rog GL753VE-DS74', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050 Ti', 'Windows', '10', '2.99kg', '15552108']\n",
      "['Dell', 'Inspiron 7579', '2 in 1 Convertible', '15.6\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 7500U 2.7GHz', '12GB', '512GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.19kg', '11550708']\n",
      "['Toshiba', 'Portege Z30-C-1CV', 'Notebook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.2kg', '10625940']\n",
      "['Lenovo', 'IdeaPad 320-15ABR', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A12-Series 9720P 3.6GHz', '6GB', '256GB SSD', 'AMD Radeon 530', 'Windows', '10', '2.2kg', '4881708']\n",
      "['Fujitsu', 'LifeBook A556', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '2.3kg', '5770908']\n",
      "['Toshiba', 'Tecra A40-C-1KF', 'Notebook', '14.0\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '1.75kg', '8136180']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'AMD Radeon R5 M430', 'Windows', '10', '2.25kg', '5326308']\n",
      "['HP', 'Probook 450', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '1TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.04kg', '7166952']\n",
      "['Lenovo', 'Legion Y520-15IKBN', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.5kg', '10572588']\n",
      "['Dell', 'Inspiron 5567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 7500U 2.7GHz', '8GB', '1TB HDD', 'AMD Radeon R7 M445', 'Windows', '10', '2.36kg', '6660108']\n",
      "['Dell', 'Latitude 5480', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '128GB SSD', 'Intel HD Graphics 620 ', 'Windows', '10', '1.6kg', '9950148']\n",
      "['HP', 'EliteBook Folio', 'Netbook', '12.5\"', 'Full HD 1920x1080', 'Intel Core M 6Y75 1.2GHz', '8GB', '512GB SSD', 'Intel HD Graphics 515', 'Windows', '10', '0.97kg', '16965936']\n",
      "['HP', '15-bs005nv (i3-6006U/4GB/1TB', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i3 6006U 2GHz', '4GB', '128GB SSD +  1TB HDD', 'AMD Radeon 520', 'Windows', '10', '2.1kg', '4437108']\n",
      "['Lenovo', 'V110-15IAP (N3350/4GB/128GB/No', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3350 1.1GHz', '4GB', '128GB SSD', 'Intel HD Graphics 500', 'No OS', '', '1.9kg', '2406353.04']\n",
      "['Lenovo', 'ThinkPad T560', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '2.3kg', '11995308']\n",
      "['Dell', 'Inspiron 5378', '2 in 1 Convertible', '13.3\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.68kg', '7904988']\n",
      "['Asus', 'ZenBook UX310UA-FB485T', 'Notebook', '13.3\"', 'Quad HD+ 3200x1800', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.4kg', '10225800']\n",
      "['HP', 'Spectre 13-V111dx', 'Ultrabook', '13.3\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.11kg', '11995308']\n",
      "['Acer', 'Aspire ES1-533', 'Notebook', '15.6\"', '1366x768', 'Intel Pentium Quad Core N4200 1.1GHz', '4GB', '500GB HDD', 'Intel HD Graphics 505', 'Windows', '10', '2.4kg', '3378960']\n",
      "['Asus', 'Rog GL553VE-DS74', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050 Ti', 'Windows', '10', '2.5kg', '15996708']\n",
      "['HP', 'EliteBook 840', 'Ultrabook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '512GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.48kg', '18575388']\n",
      "['Acer', 'Nitro 5', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.7kg', '11203920']\n",
      "['HP', 'ENVY -', 'Notebook', '13.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.34kg', '10572588']\n",
      "['Dell', 'Vostro 3568', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '4GB', '128GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.18kg', '4863924']\n",
      "['HP', 'Probook 440', 'Notebook', '14.0\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '1.64kg', '6926868']\n",
      "['Toshiba', 'Portege Z30-C-16H', 'Notebook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.2kg', '10625940']\n",
      "['HP', 'EliteBook 840', 'Notebook', '14.0\"', '1366x768', 'Intel Core i5 6300U 2.4GHz', '4GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.48kg', '9781111.08']\n",
      "['HP', 'ProBook 640', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '4GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.95kg', '10714860']\n",
      "['HP', 'EliteBook 1040', 'Ultrabook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 6600U 2.6GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.43kg', '12884508']\n",
      "['HP', 'ProBook 440', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Nvidia GeForce 930MX', 'Windows', '10', '1.64kg', '9330019.92']\n",
      "['HP', 'Probook 440', 'Notebook', '14.0\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '1.64kg', '6082128']\n",
      "['Dell', 'Inspiron 7567', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7300HQ 2.5GHz', '8GB', '1TB Hybrid', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.65kg', '8438508']\n",
      "['HP', 'EliteBook 820', 'Ultrabook', '12.5\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '1.26kg', '13684788']\n",
      "['HP', 'Elitebook 840', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '4GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.48kg', '14138280']\n",
      "['HP', 'EliteBook 840', 'Ultrabook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.54kg', '16781071.32']\n",
      "['HP', 'Probook 430', 'Notebook', '13.3\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '1.49kg', '7113600']\n",
      "['Toshiba', 'Portege A30-C-1CZ', 'Notebook', '13.3\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.5kg', '10759320']\n",
      "['HP', 'ProBook 450', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '4GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.04kg', '6846751.08']\n",
      "['Lenovo', 'ThinkPad P70', 'Notebook', '17.3\"', 'IPS Panel 4K Ultra HD 3840x2160', 'Intel Core i7 6820HQ 2.7GHz', '16GB', '512GB SSD', 'Nvidia Quadro 3000M', 'Windows', '7', '2.4kg', '26391456']\n",
      "['Toshiba', 'Tecra Z40-C-12Z', 'Notebook', '14.0\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.47kg', '13249080']\n",
      "['HP', 'EliteBook 1040', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.43kg', '19820268']\n",
      "['Dell', 'Inspiron 5568', '2 in 1 Convertible', '15.6\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i3 6100U 2.3GHz', '4GB', '1TB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.08kg', '7077943.08']\n",
      "['Toshiba', 'PortÃ©gÃ© Z30-C-16K', 'Ultrabook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.2kg', '14138280']\n",
      "['HP', 'Spectre 13-V100nv', 'Notebook', '13.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.11kg', '10216908']\n",
      "['HP', 'ProBook 440', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Nvidia GeForce 930MX', 'Windows', '10', '1.64kg', '10540843.56']\n",
      "['Dell', 'Latitude E5570', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6300U 2.4GHz', '8GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.09kg', '9304944.48']\n",
      "['HP', 'Elitebook 820', 'Ultrabook', '12.5\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.26kg', '13862628']\n",
      "['HP', 'ProBook 650', 'Notebook', '14.0\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.31kg', '10572588']\n",
      "['HP', 'ProBook 640', 'Notebook', '14.0\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '1.95kg', '9425520']\n",
      "['Dell', 'XPS 13', 'Ultrabook', '13.3\"', 'Quad HD+ / Touchscreen 3200x1800', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.29kg', '14440608']\n",
      "['HP', 'Probook 470', 'Notebook', '17.3\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Nvidia GeForce 930MX', 'Windows', '10', '2.63kg', '9603360']\n",
      "['HP', 'ProBook 440', 'Notebook', '14.0\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.64kg', '8651916']\n",
      "['Acer', 'Aspire 3', 'Notebook', '15.6\"', '1366x768', 'AMD A9-Series 9420 3GHz', '6GB', '1TB HDD', 'AMD Radeon R5', 'Windows', '10', '2.1kg', '3636828']\n",
      "['MSI', 'GL72M 7RDX', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.7kg', '10597485.6']\n",
      "['HP', 'Probook 640', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.95kg', '10625940']\n",
      "['HP', 'EliteBook 850', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.84kg', '10928179.08']\n",
      "['HP', 'EliteBook 820', 'Ultrabook', '12.5\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.26kg', '11995308']\n",
      "['HP', 'ProBook 450', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.04kg', '6597864']\n",
      "['Toshiba', 'Tecra Z40-C-136', 'Ultrabook', '14.0\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6600U 2.6GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.47kg', '15338700']\n",
      "['Dell', 'Latitude E5570', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6300U 2.4GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '2.09kg', '9451751.4']\n",
      "['HP', 'ProBook 440', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.64kg', '8985454.92']\n",
      "['Lenovo', 'Yoga 500-15ISK', '2 in 1 Convertible', '15.6\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.5GHz', '4GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.8kg', '7531524']\n",
      "['Vero', 'V142 (X5-Z8350/2GB/32GB/W10)', 'Notebook', '14.0\"', '1366x768', 'Intel Atom X5-Z8350 1.44GHz', '2GB', '32GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '1.45kg', '1874433.6']\n",
      "['Toshiba', 'Tecra A50-C-218', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '16GB', '256GB SSD', 'Nvidia GeForce 930M', 'Windows', '10', '2.4kg', '12671100']\n",
      "['Lenovo', 'Thinkpad L560', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '2.3kg', '9333043.2']\n",
      "['HP', 'EliteBook 840', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '1.54kg', '8892000']\n",
      "['HP', 'EliteBook 850', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6300U 2.4GHz', '8GB', '256GB SSD +  500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '1.84kg', '18702899.28']\n",
      "['HP', 'EliteBook 1040', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.43kg', '13062348']\n",
      "['MSI', 'GT72S Dominator', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6820HK 2.7GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 980M', 'Windows', '10', '3.78kg', '13743830.88']\n",
      "['Lenovo', 'IdeaPad Y900-17ISK', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 980M', 'Windows', '10', '4.6kg', '20362591.08']\n",
      "['Asus', 'Chromebook C202SA', 'Netbook', '11.6\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '4GB', '16GB Flash Storage', 'Intel HD Graphics 400', 'Chrome OS', '', '1.2kg', '2560006.8']\n",
      "['Lenovo', 'ThinkPad X1', 'Notebook', '14.0\"', 'IPS Panel 2560x1440', 'Intel Core i7 6600U 2.6GHz', '16GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.1kg', '23297040']\n",
      "['HP', 'Noteb Pav', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '1TB HDD', 'Nvidia GeForce 940MX', 'Windows', '10', '1.91kg', '8705268']\n",
      "['Dell', 'Inspiron 5578', '2 in 1 Convertible', '15.6\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i5 7200U 2.7GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.3kg', '9727848']\n",
      "['HP', 'ProBook 450', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.04kg', '8705268']\n",
      "['Dell', 'XPS 13', 'Ultrabook', '13.3\"', 'Quad HD+ / Touchscreen 3200x1800', 'Intel Core i7 7500U 2.7GHz', '16GB', '1TB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.2kg', '20042568']\n",
      "['HP', 'ProBook 650', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6100U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.31kg', '6270193.8']\n",
      "['HP', '250 G5', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'No OS', '', '1.96kg', '4437108']\n",
      "['Acer', 'Aspire ES1-523', 'Notebook', '15.6\"', '1366x768', 'AMD A8-Series 7410 2.2GHz', '8GB', '1TB HDD', 'AMD Radeon R5', 'Windows', '10', '2.4kg', '3992508']\n",
      "['Dell', 'Inspiron 7378', '2 in 1 Convertible', '13.3\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 7500U 2.7GHz', '12GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.6kg', '11550708']\n",
      "['MSI', 'GT62VR 6RD', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.94kg', '16174548']\n",
      "['HP', 'ProBook 450', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.04kg', '9514440']\n",
      "['Asus', 'Rog G752VL-GC088D', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '1TB HDD', 'Nvidia GeForce GTX 965M', 'No OS', '', '4kgs', '8874216']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '4GB', '1TB HDD', 'Intel HD Graphics', 'Windows', '10', '2.25kg', '4970628']\n",
      "['Dell', 'Inspiron 5567', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '16GB', '2TB HDD', 'AMD Radeon R7 M445', 'Windows', '10', '2.32kg', '8802991.08']\n",
      "['MSI', 'GS63VR 6RF', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '1.8kg', '17152668']\n",
      "['Dell', 'XPS 13', 'Ultrabook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.29kg', '12964536']\n",
      "['Asus', 'ROG G701VO', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6820HK 2.7GHz', '64GB', '1TB SSD', 'Nvidia GeForce GTX 980 ', 'Windows', '10', '3.58kg', '35345700']\n",
      "['Dell', 'Inspiron 5368', '2 in 1 Convertible', '13.3\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.62kg', '7095904.92']\n",
      "['Dell', 'Alienware 15', 'Gaming', '15.6\"', '4K Ultra HD 3840x2160', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 970M', 'Windows', '10', '3.21kg', '11817468']\n",
      "['Apple', 'MacBook 12\"', 'Ultrabook', '12.0\"', 'IPS Panel Retina Display 2304x1440', 'Intel Core M 1.1GHz', '8GB', '256GB Flash Storage', 'Intel HD Graphics 515', 'Mac OS', 'X', '0.920kg', '11559600']\n",
      "['Dell', 'Latitude 3570', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6100U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.06kg', '4285766.16']\n",
      "['HP', 'ProBook 650', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.31kg', '10661508']\n",
      "['HP', 'EliteBook 820', 'Ultrabook', '12.5\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.26kg', '10661508']\n",
      "['HP', 'ProBook 430', 'Notebook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.49kg', '9692280']\n",
      "['Lenovo', 'ThinkPad Yoga', 'Ultrabook', '12.5\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.3kg', '15236353.08']\n",
      "['Lenovo', 'IdeaPad 300-17ISK', 'Notebook', '17.3\"', '1600x900', 'Intel Core i5 6200U 2.3GHz', '8GB', '1TB HDD', 'AMD Radeon R5 M330', 'Windows', '10', '3.0kg', '5859828']\n",
      "['Lenovo', 'Ideapad 700-15ISK', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 6300HQ 2.3GHz', '4GB', '1TB HDD', 'Nvidia GeForce GTX 950M', 'Windows', '10', '2.3kg', '8687484']\n",
      "['MSI', 'GT72VR Dominator', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1070', 'Windows', '10', '3.78kg', '22221108']\n",
      "['Lenovo', 'V110-15ISK (i5-6200U/4GB/500GB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.1kg', '4801680']\n",
      "['HP', 'Probook 650', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '7', '2.31kg', '8358480']\n",
      "['Lenovo', 'Yoga 900S-12ISK', 'Ultrabook', '12.5\"', 'IPS Panel Touchscreen 2560x1440', 'Intel Core M 6Y75 1.2GHz', '8GB', '512GB SSD', 'Intel HD Graphics 515', 'Windows', '10', '0.99kg', '12439908']\n",
      "['Lenovo', 'IdeaPad Y900-17ISK', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6820HK 2.7GHz', '32GB', '512GB SSD +  1TB Hybrid', 'Nvidia GeForce GTX 980M', 'Windows', '10', '4.6kg', '28810080']\n",
      "['Lenovo', 'Yoga Book', '2 in 1 Convertible', '10.1\"', 'IPS Panel Touchscreen 1920x1200', 'Intel Atom x5-Z8550 1.44GHz', '4GB', '64GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '0.69kg', '5746632.84']\n",
      "['HP', 'Spectre x360', 'Ultrabook', '13.3\"', 'IPS Panel 4K Ultra HD 3840x2160', 'Intel Core i7 7500U 2.7GHz', '16GB', '512GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.3kg', '18219708']\n",
      "['Dell', 'Vostro 3568', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.18kg', '6669000']\n",
      "['HP', 'EliteBook 840', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '7', '1.54kg', '9167563.08']\n",
      "['HP', 'ZBook 15u', 'Workstation', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'AMD FirePro W4190M', 'Windows', '7', '1.9kg', '13293540']\n",
      "['Lenovo', 'ThinkPad T460', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '1GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.7kg', '10661508']\n",
      "['HP', 'Chromebook 13', 'Notebook', '13.3\"', 'Quad HD+ 3200x1800', 'Intel Pentium Dual Core 4405Y 1.5GHz', '4GB', '32GB Flash Storage', 'Intel HD Graphics 515', 'Chrome OS', '', '1.29kg', '5468580']\n",
      "['Acer', 'Aspire ES1-523', 'Notebook', '15.6\"', '1366x768', 'AMD A8-Series 7410 2.2GHz', '4GB', '500GB HDD', 'AMD Radeon R5', 'Windows', '10', '2.4kg', '3441204']\n",
      "['Dell', 'Inspiron 3552', 'Notebook', '15.6\"', '1366x768', 'Intel Pentium Quad Core N3700 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics', 'Linux', '', '2.2kg', '3498913.08']\n",
      "['HP', '250 G6', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2GHz', '4GB', '1TB HDD', 'Intel HD Graphics 520', 'No OS', '', '1.86kg', '3076543.08']\n",
      "['Asus', 'Rog GL702VM-GC354T', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.7kg', '14218308']\n",
      "['Dell', 'Inspiron 5370', 'Ultrabook', '13.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 8250U 1.6GHz', '4GB', '256GB SSD', 'AMD Radeon 530', 'Windows', '10', '1.4kg', '7276768.2']\n",
      "['HP', 'Elitebook 820', 'Netbook', '12.5\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '2.4kg', '14218308']\n",
      "['Acer', 'Aspire F5-573G', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 950M', 'Windows', '10', '2.4kg', '7104708']\n",
      "['Dell', 'Inspiron 5567', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '1TB HDD', 'AMD Radeon R7 M445', 'Windows', '10', '2.36kg', '5680209.6']\n",
      "['MSI', 'GS70 Stealth', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '256GB SSD', 'Nvidia GeForce GTX 965M', 'Windows', '10', '2.6kg', '14218308']\n",
      "['HP', '250 G5', 'Notebook', '15.6\"', '1366x768', 'Intel Pentium Quad Core N3710 1.6GHz', '4GB', '1TB HDD', 'Intel HD Graphics 405', 'Windows', '10', '1.96kg', '4446000']\n",
      "['Asus', 'G752VY-GC162T (i7-6700HQ/16GB/1TB', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 980M', 'Windows', '10', '4.3kg', '20442708']\n",
      "['Dell', 'Latitude E5270', 'Ultrabook', '12.5\"', '1366x768', 'Intel Core i3 6100U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '7', '1.5kg', '10093753.8']\n",
      "['Dell', 'Latitude E5270', 'Ultrabook', '12.5\"', '1366x768', 'Intel Core i3 6100U 2.3GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.5kg', '10376697.24']\n",
      "['Acer', 'Chromebook 15', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core 3205U 1.5GHz', '4GB', '16GB SSD', 'Intel HD Graphics', 'Chrome OS', '', '2.20kg', '1858428']\n",
      "['HP', 'ZBook 17', 'Workstation', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '1TB HDD', 'AMD FirePro W6150M', 'Windows', '7', '3.0kg', '25777908']\n",
      "['Lenovo', 'Legion Y520-15IKBN', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '512GB SSD', 'Nvidia GeForce GTX 1050 Ti', 'Windows', '10', '2.4kg', '10661508']\n",
      "['Dell', 'Latitude E5270', 'Ultrabook', '12.5\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.5kg', '12565285.2']\n",
      "['MSI', 'GE72 Apache', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.9kg', '13437501.48']\n",
      "['Lenovo', 'Yoga 500-15ISK', '2 in 1 Convertible', '15.6\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '2.1kg', '7709364']\n",
      "['HP', '15-bw011nv (A6-9220/4GB/1TB/FHD/W10)', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A6-Series 9220 2.5GHz', '4GB', '1TB HDD', 'AMD Radeon R4', 'Windows', '10', '2.1kg', '3539016']\n",
      "['Asus', 'Rog GL552VW-CN470T', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.59kg', '11906388']\n",
      "['HP', 'EliteBook 1030', 'Notebook', '13.3\"', 'Quad HD+ / Touchscreen 3200x1800', 'Intel Core M 6Y54 1.1GHz', '8GB', '256GB SSD', 'Intel HD Graphics 515', 'Windows', '10', '1.16kg', '15107508']\n",
      "['Dell', 'Vostro 3559', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'AMD Radeon R5 M315', 'Windows', '7', '2.24kg', '6839281.8']\n",
      "['Lenovo', 'V110-15ISK (i3-6006U/4GB/128GB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2.0GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '2.1kg', '3814668']\n",
      "['HP', 'Spectre Pro', 'Ultrabook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.16kg', '17508348']\n",
      "['Lenovo', 'Yoga Book', '2 in 1 Convertible', '10.1\"', 'IPS Panel Touchscreen 1920x1200', 'Intel Atom x5-Z8550 1.44GHz', '4GB', '64GB Flash Storage', 'Intel HD Graphics 400', 'Android', '', '0.69kg', '4881708']\n",
      "['Dell', 'XPS 13', 'Ultrabook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i7 7560U 2.4GHz', '8GB', '256GB SSD', 'Intel Iris Plus Graphics 640', 'Windows', '10', '1.23kg', '12262068']\n",
      "['Lenovo', 'IdeaPad Y900-17ISK', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6820HK 2.7GHz', '16GB', '256GB SSD +  1TB Hybrid', 'Nvidia GeForce GTX 980M', 'Windows', '10', '4.6kg', '24452911.08']\n",
      "['Razer', 'Blade Stealth', 'Ultrabook', '12.5\"', 'Touchscreen / 4K Ultra HD 3840x2160', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.25kg', '9149868']\n",
      "['Toshiba', 'Portege X30-D-10K', 'Ultrabook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '16GB', '512GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.05kg', '19793592']\n",
      "['Asus', 'Rog GL752VW-T4308T', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '3.52kg', '11670661.08']\n",
      "['Vero', 'V131 (X5-Z8350/4GB/32GB/FHD/W10)', 'Notebook', '13.3\"', 'Full HD 1920x1080', 'Intel Atom X5-Z8350 1.44GHz', '4GB', '32GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '1.35kg', '1742832']\n",
      "['HP', 'Spectre Pro', 'Notebook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.16kg', '15027480']\n",
      "['HP', 'EliteBook 1040', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.43kg', '13453596']\n",
      "['Dell', 'Latitude E5570', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Linux', '', '2.09kg', '4656117.96']\n",
      "['Asus', 'VivoBook Max', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '4GB', '1TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2kg', '3868020']\n",
      "['Lenovo', 'ThinkPad Yoga', '2 in 1 Convertible', '14.0\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.8kg', '14840748']\n",
      "['Lenovo', 'Yoga Book', '2 in 1 Convertible', '10.1\"', 'IPS Panel Touchscreen 1920x1200', 'Intel Atom x5-Z8550 1.44GHz', '4GB', '64GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '0.69kg', '4259268']\n",
      "['HP', 'EliteBook 820', 'Ultrabook', '12.5\"', '1366x768', 'Intel Core i5 6300U 2.4GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.26kg', '16850340']\n",
      "['Lenovo', 'Legion Y520-15IKBN', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 7300HQ 2.5GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'No OS', '', '2.4kg', '8794188']\n",
      "['HP', 'Omen -', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 6300HQ 2.3GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '3.35kg', '10039068']\n",
      "['HP', '15-bs078cl (i7-7500U/8GB/2TB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 7500U 2.7GHz', '8GB', '2TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.04kg', '5593068']\n",
      "['Lenovo', 'ThinkPad P40', '2 in 1 Convertible', '14.0\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6600U 2.6GHz', '8GB', '512GB SSD', 'Nvidia Quadro M500M', 'Windows', '7', '1.8kg', '18231978.96']\n",
      "['Asus', 'L403NA-GA013TS (N3350/4GB/32GB/W10)', 'Notebook', '14.0\"', '1366x768', 'Intel Celeron Dual Core N3350 1.1GHz', '4GB', '32GB Flash Storage', 'Intel HD Graphics 500', 'Windows', '10', '1.5kg', '2471976']\n",
      "['HP', '250 G6', 'Ultrabook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.84kg', '6686784']\n",
      "['Acer', 'Aspire E5-576G', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '4GB', '1TB HDD', 'Nvidia GeForce 940MX', 'Windows', '10', '2.23kg', '5477472']\n",
      "['Lenovo', 'IdeaPad 500-15ISK', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '16GB', '1TB Hybrid', 'AMD Radeon R7 M360', 'Windows', '10', '2.5kg', '9772308']\n",
      "['HP', 'ZBook 17', 'Workstation', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '256GB SSD', 'Nvidia Quadro M3000M', 'Windows', '7', '3kg', '35118064.8']\n",
      "['Dell', 'Inspiron 5567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '8GB', '1TB HDD', 'AMD Radeon R7 M445', 'Windows', '10', '2.5kg', '6971328']\n",
      "['MSI', 'GT72S Dominator', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 6820HQ 2.7GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 980M', 'Windows', '10', '3.78kg', '21331908']\n",
      "['HP', 'EliteBook 850', 'Ultrabook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.88kg', '19310934.24']\n",
      "['Lenovo', 'ThinkPad X1', '2 in 1 Convertible', '14.0\"', 'IPS Panel Touchscreen 2560x1440', 'Intel Core i7 6600U 2.6GHz', '16GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '2.8kg', '21696480']\n",
      "['MSI', 'GP62M 7RDX', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.4kg', '10161777.6']\n",
      "['HP', 'Spectre Pro', '2 in 1 Convertible', '13.3\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i5 6300U 2.4GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.48kg', '14485068']\n",
      "['HP', 'ZBook 15', 'Workstation', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '256GB SSD', 'Nvidia Quadro M1000M', 'Windows', '7', '2.59kg', '19820268']\n",
      "['HP', 'Spectre Pro', '2 in 1 Convertible', '13.3\"', 'Touchscreen 2560x1440', 'Intel Core i7 6600U 2.6GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.48kg', '15996708']\n",
      "['HP', 'ZBook Studio', 'Workstation', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '256GB SSD', 'Nvidia Quadro M1000M', 'Windows', '7', '2.0kg', '16885908']\n",
      "['HP', 'EliteBook 820', 'Ultrabook', '12.5\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.50GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.26kg', '20424479.4']\n",
      "['Dell', 'Vostro 5568', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Nvidia GeForce 940MX', 'Windows', '10', '2.18kg', '8980030.8']\n",
      "['HP', 'EliteBook 850', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.88kg', '14040468']\n",
      "['Lenovo', 'ThinkPad X1', '2 in 1 Convertible', '14.0\"', 'IPS Panel Touchscreen 2560x1440', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.27kg', '20798388']\n",
      "['Lenovo', 'V110-15ISK (i3-6006U/4GB/1TB/No', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2.0GHz', '4GB', '1TB HDD', 'Intel HD Graphics 520', 'No OS', '', '1.9kg', '3014388']\n",
      "['HP', '15-BA015wm (E2-7110/4GB/500GB/W10)', 'Notebook', '15.6\"', '1366x768', 'AMD E-Series 7110 1.8GHz', '4GB', '500GB HDD', 'AMD Radeon R2 Graphics', 'Windows', '10', '1.86kg', '2640924']\n",
      "['Lenovo', 'B51-80 (i5-6200U/8GB/1TB/Radeon', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '1TB HDD', 'AMD Radeon R5 M330', 'No OS', '', '2.32kg', '5326308']\n",
      "['Dell', 'Inspiron 7567', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 1050Ti', 'Windows', '10', '2.62kg', '10661508']\n",
      "['Dell', 'XPS 15', 'Notebook', '15.6\"', 'IPS Panel Touchscreen / 4K Ultra HD 3840x2160', 'Intel Core i5 6300HQ 2.3GHz', '8GB', '256GB SSD', 'Nvidia GeForce 960M', 'Windows', '10', '2.04kg', '20013046.56']\n",
      "['HP', '15-bw002nv (A6-9220/4GB/256GB/Radeon', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A6-Series A6-9220 2.5GHz', '4GB', '256GB SSD', 'AMD Radeon 520', 'Windows', '10', '1.91kg', '4258289.88']\n",
      "['MSI', 'GP72M 7REX', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050 Ti', 'Windows', '10', '2.7kg', '13273977.6']\n",
      "['Lenovo', 'ThinkPad T460s', 'Ultrabook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 6600U 2.6GHz', '12GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.4kg', '20442708']\n",
      "['Lenovo', 'B51-80 (i5-6200U/8GB/1008GB/Radeon', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '1TB Hybrid', 'AMD Radeon R5 M330', 'Windows', '10', '2.5kg', '7011253.08']\n",
      "['HP', 'Spectre Pro', '2 in 1 Convertible', '13.3\"', 'Touchscreen 2560x1440', 'Intel Core i7 6600U 2.6GHz', '8GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.48kg', '18148572']\n",
      "['Lenovo', 'ThinkPad T460', 'Ultrabook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 6600U 2.6GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.7kg', '13329108']\n",
      "['MSI', 'GS40 Phantom', 'Gaming', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 970M', 'Windows', '10', '1.7kg', '15729948']\n",
      "['HP', 'Pavilion 15-cb003nv', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.62kg', '7993908']\n",
      "['Lenovo', 'IdeaPad 310-15ISK', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2.0GHz', '8GB', '1TB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.2kg', '4081428']\n",
      "['HP', '250 G4', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'No OS', '', '2.1kg', '4241395.08']\n",
      "['Dell', 'Inspiron 7567', 'Gaming', '15.6\"', '4K Ultra HD 3840x2160', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050 Ti', 'Windows', '10', '2.62kg', '13320216']\n",
      "['Lenovo', 'ThinkPad T570', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.95kg', '12359880']\n",
      "['Lenovo', '320-15ISK (i3-6006U/4GB/1TB/GeForce', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i3 6006U 2GHz', '4GB', '1TB HDD', 'Nvidia GeForce 920MX ', 'Windows', '10', '2.2kg', '4161456']\n",
      "['HP', 'Stream 14-AX000nv', 'Notebook', '14.0\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '2GB', '32GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '1.44kg', '2214108']\n",
      "['MSI', 'PL60 7RD', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.2kg', '7460388']\n",
      "['HP', '250 G5', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.96kg', '6037668']\n",
      "['HP', 'ProBook 450', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 8550U 1.8GHz', '16GB', '512GB SSD', 'Intel UHD Graphics 620', 'Windows', '10', '2.1kg', '10305828']\n",
      "['Asus', 'X553SA-XX021T (N3050/4GB/500GB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.2kg', '3281148']\n",
      "['Lenovo', 'V110-15ISK (i5-6200U/4GB/500GB/No', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'No OS', '', '2.1kg', '3539016']\n",
      "['Lenovo', 'IdeaPad 510-15IKB', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '1TB HDD', 'Nvidia GeForce 940MX', 'No OS', '', '2.2kg', '6304428']\n",
      "['Asus', 'UX410UA-GV097T (i3-7100U/4GB/256GB/FHD/W10)', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i3 7100U 2.4GHz', '4GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2kg', '6837948']\n",
      "['Lenovo', 'B51-80 (i7-6500U/4GB/1008GB/FHD/W7)', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '4GB', '1TB Hybrid', 'Intel HD Graphics 520', 'Windows', '7', '2.32kg', '7335900']\n",
      "['Lenovo', 'IdeaPad Y700-15ISK', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '512GB SSD', 'Nvidia GeForce GTX 960', 'Windows', '10', '3.31kg', '11604060']\n",
      "['MSI', 'GS60 Ghost', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 970M', 'Windows', '10', '1.91kg', '19147766.04']\n",
      "['HP', 'ProBook 450', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6100U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.07kg', '5779800']\n",
      "['Lenovo', 'ThinkPad X1', '2 in 1 Convertible', '14.0\"', 'IPS Panel Touchscreen 2560x1440', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.36kg', '14556204']\n",
      "['Lenovo', 'IdeaPad 310-15IKB', 'Ultrabook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '6GB', '256GB SSD', 'Nvidia GeForce 920M', 'Windows', '10', '1.54kg', '7389252']\n",
      "['Dell', 'Vostro 5568', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Nvidia GeForce GT 940MX', 'Linux', '', '1.98kg', '7958428.92']\n",
      "['Acer', 'Aspire 3', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3350 2GHz', '4GB', '500GB HDD', 'Intel HD Graphics 500', 'Windows', '10', '2.1kg', '2961036']\n",
      "['HP', 'Pavilion 15-BC000nv', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '6GB', '1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.18kg', '7104708']\n",
      "['Asus', 'Rog GL552VW-DM201T', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.591kg', '8082828']\n",
      "['Dell', 'Inspiron 5578', '2 in 1 Convertible', '15.6\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i7 7500U 2.7GHz', '16GB', '512GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.09kg', '10483668']\n",
      "['Acer', 'Aspire E5-576G', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '4GB', '256GB SSD', 'Nvidia GeForce 940MX', 'Windows', '10', '2.23kg', '6144372']\n",
      "['Dell', 'XPS 13', 'Ultrabook', '13.3\"', 'Quad HD+ / Touchscreen 3200x1800', 'Intel Core i5 6300U 2.4GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Linux', '', '1.23kg', '9772308']\n",
      "['Acer', 'Predator G9-793', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1070', 'Windows', '10', '4.2kg', '23110308']\n",
      "['Lenovo', 'Legion Y520-15IKBN', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 7300HQ 2.5GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.4kg', '7282548']\n",
      "['Samsung', 'Chromebook Plus', '2 in 1 Convertible', '12.3\"', 'IPS Panel Touchscreen 2400x1600', 'Samsung Cortex A72&A53 2.0GHz', '4GB', '32GB Flash Storage', 'ARM Mali T860 MP4', 'Chrome OS', '', '1.15kg', '5859828']\n",
      "['HP', '250 G6', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '1.86kg', '4312620']\n",
      "['Apple', 'MacBook 12\"', 'Ultrabook', '12.0\"', 'IPS Panel Retina Display 2304x1440', 'Intel Core M 1.1GHz', '8GB', '256GB Flash Storage', 'Intel HD Graphics 5300', 'Mac OS', 'X', '0.920kg', '10341396']\n",
      "['Dell', 'Inspiron 7378', '2 in 1 Convertible', '13.3\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.6kg', '10661508']\n",
      "['HP', 'Pavilion Power', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '12GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.21kg', '11799684']\n",
      "['Lenovo', 'V110-15ISK (i3-6006U/4GB/1TB/Radeon', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2GHz', '4GB', '1TB HDD', 'AMD Radeon R5 M430', 'No OS', '', '1.9kg', '3272256']\n",
      "['Asus', 'Rog G752VY-GC229T', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '512GB SSD +  1TB HDD', 'Nvidia GeForce GTX 980M', 'Windows', '10', '4.3kg', '19117800']\n",
      "['Acer', 'Aspire 3', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3350 2GHz', '4GB', '1TB HDD', 'Intel HD Graphics 500', 'Linux', '', '2.1kg', '2418624']\n",
      "['MSI', 'GS73VR 7RF', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.43kg', '18218818.8']\n",
      "['Dell', 'Inspiron 5567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2.0GHz', '4GB', '128GB SSD', 'AMD Radeon R7 M440', 'Windows', '10', '2.3kg', '4437108']\n",
      "['Lenovo', 'IdeaPad 310-15ISK', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 6500U 2.5GHz', '8GB', '500GB HDD', 'Nvidia GeForce 920MX', 'No OS', '', '2.2kg', '5593068']\n",
      "['Dell', 'Inspiron 5579', '2 in 1 Convertible', '15.6\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i7 8550U 1.8GHz', '16GB', '512GB SSD', 'Intel UHD Graphics 620', 'Windows', '10', '2kg', '11426220']\n",
      "['Dell', 'XPS 13', 'Ultrabook', '13.3\"', 'Quad HD+ / Touchscreen 3200x1800', 'Intel Core i7 7500U 2.7GHz', '16GB', '512GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.2kg', '23830560']\n",
      "['Asus', 'FX502VM-DM105T (i7-6700HQ/8GB/1TB/GeForce', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.2kg', '10394748']\n",
      "['Dell', 'Inspiron 5567', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'AMD Radeon R7 M445', 'Windows', '10', '2.36kg', '7904988']\n",
      "['HP', '15-bs025nv (i5-7200U/8GB/256GB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.91kg', '5148468']\n",
      "['Lenovo', 'IdeaPad 320-15AST', 'Notebook', '15.6\"', '1366x768', 'AMD E-Series 9000 2.2GHz', '4GB', '500GB HDD', 'AMD Radeon R2 Graphics', 'Windows', '10', '2.2kg', '2658708']\n",
      "['Acer', 'Aspire E5-774G', 'Notebook', '17.3\"', '1600x900', 'Intel Core i3 6006U 2.0GHz', '8GB', '1TB HDD', 'Nvidia GeForce 940MX', 'Windows', '10', '3.3kg', '5593068']\n",
      "['Asus', 'Rog Strix', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1070', 'Windows', '10', '2.2kg', '21776508']\n",
      "['Apple', 'MacBook 12\"', 'Ultrabook', '12.0\"', 'IPS Panel Retina Display 2304x1440', 'Intel Core M 1.2GHz', '8GB', '512GB Flash Storage', 'Intel HD Graphics 515', 'Mac OS', 'X', '0.920kg', '11372868']\n",
      "['Asus', 'FX502VM-AS73 (i7-7700HQ/16GB/1TB', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.2kg', '15552108']\n",
      "['MSI', 'GS73VR Stealth', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.43kg', '17330419.08']\n",
      "['Dell', 'Inspiron 7579', '2 in 1 Convertible', '15.6\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '2.191kg', '8883108']\n",
      "['Asus', 'ROG Strix', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.9kg', '17330508']\n",
      "['Acer', 'C740-C9QX (3205U/2GB/32GB/Chrome', 'Netbook', '11.6\"', '1366x768', 'Intel Celeron Dual Core 3205U 1.5GHz', '2GB', '32GB SSD', 'Intel HD Graphics', 'Chrome OS', '', '1.3kg', '1547208']\n",
      "['Acer', 'E5 774G', 'Notebook', '17.3\"', '1600x900', 'Intel Core i3 6006U 2GHz', '4GB', '1TB HDD', 'Nvidia GeForce 940MX', 'Windows', '10', '3.3kg', '5317416']\n",
      "['Lenovo', 'IdeaPad 320-17IKB', 'Notebook', '17.3\"', '1600x900', 'Intel Core i5 7200U 2.5GHz', '8GB', '1TB HDD', 'Intel HD Graphics 620', 'No OS', '', '2.8kg', '4792788']\n",
      "['Lenovo', 'IdeaPad Y700-15ISK', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960<U+039C>', 'Windows', '10', '2.6kg', '11310624']\n",
      "['Acer', 'SP714-51 (i7-7Y75/8GB/256GB/FHD/W10)', '2 in 1 Convertible', '14.0\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 7Y75 1.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 615', 'Windows', '10', '1.2kg', '10216908']\n",
      "['Lenovo', 'Thinkpad T560', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6600U 2.6GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '2.3kg', '13595868']\n",
      "['MSI', 'GP62MVR 6RF', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.2kg', '13125570.12']\n",
      "['HP', '15-bw009nv (A12-9720P/6GB/1TB/Radeon', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A12-Series 9720P 2.7GHz', '6GB', '1TB HDD', 'AMD Radeon 530', 'Windows', '10', '2.1kg', '4703868']\n",
      "['Dell', 'Latitude E7270', 'Ultrabook', '12.5\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i5 6300U 2.4GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.26kg', '15235286.04']\n",
      "['Dell', 'Inspiron 5578', '2 in 1 Convertible', '15.0\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i3 7100U 2.4GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.08kg', '4526028']\n",
      "['Asus', 'X540SA-RBPDN09 (N3710/4GB/1TB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Pentium Quad Core N3710 1.6GHz', '4GB', '1TB HDD', 'Intel HD Graphics 405', 'Windows', '10', '2.65kg', '2747628']\n",
      "['Dell', 'XPS 13', 'Ultrabook', '13.3\"', 'Quad HD+ / Touchscreen 3200x1800', 'Intel Core i7 7500U 2.7GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.29kg', '13133484']\n",
      "['Dell', 'Vostro 3568', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '1TB HDD', 'Intel HD Graphics 520', 'Linux', '', '2.18kg', '4640379.12']\n",
      "['Lenovo', 'IdeaPad Y700-15ISK', 'Gaming', '15.6\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.6kg', '9149868']\n",
      "['MSI', 'GL62M 7RDX', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050', 'Windows', '10', '2.2kg', '10216908']\n",
      "['Lenovo', 'ThinkPad Yoga', 'Netbook', '12.5\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.50GHz', '16GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.3kg', '14671800']\n",
      "['Razer', 'Blade Pro', 'Gaming', '14.0\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '1TB SSD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '1.95kg', '31113108']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', 'Touchscreen 1366x768', 'Intel Core i3 7100U 2.4GHz', '8GB', '1TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.3kg', '4170436.92']\n",
      "['MSI', 'GE72VR Apache', 'Gaming', '17.3\"', 'Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1060', 'Windows', '10', '2.7kg', '14209416']\n",
      "['Apple', 'MacBook Air', 'Ultrabook', '11.6\"', '1366x768', 'Intel Core i5 1.6GHz', '4GB', '256GB Flash Storage', 'Intel HD Graphics 6000', 'Mac OS', 'X', '1.08kg', '8527428']\n",
      "['HP', '15-bs023nv (i3-6006U/4GB/1TB/FHD/W10)', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i3 6006U 2GHz', '4GB', '1TB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.1kg', '4250376']\n",
      "['HP', 'EliteBook 840', 'Ultrabook', '14.0\"', '2560x1440', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.54kg', '19546305.48']\n",
      "['Dell', 'Vostro 3559', 'Notebook', '15.6\"', '1366x768', 'Intel Core i5 6200U 2.3GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '7', '2.24kg', '6553404']\n",
      "['MSI', 'GL62 6QF', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.3kg', '10394748']\n",
      "['Lenovo', 'ThinkPad 13', 'Notebook', '13.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7500U 2.7GHz', '16GB', '512GB SSD', 'Intel HD Graphics 620', 'Windows', '10', '1.4kg', '13329108']\n",
      "['Lenovo', 'IdeaPad 320-15ABR', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A12-Series 9720P 3.6GHz', '6GB', '256GB SSD', 'AMD Radeon 530', 'Windows', '10', '2.2kg', '5313592.44']\n",
      "['Asus', 'ZenBook UX310UA-WB71', 'Ultrabook', '13.3\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.45kg', '11381760']\n",
      "['Acer', 'Aspire ES1-572', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2.0GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Linux', '', '2.4kg', '3217125.6']\n",
      "['Dell', 'Inspiron 7779', '2 in 1 Convertible', '17.3\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i7 7500U 2.7GHz', '16GB', '512GB SSD', 'Nvidia GeForce 940MX', 'Windows', '10', '2.77kg', '15996708']\n",
      "['HP', 'EliteBook 840', 'Notebook', '14.0\"', 'Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '7', '1.54kg', '9781111.08']\n",
      "['Asus', 'Rog GL553VE-FY052T', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 7700HQ 2.8GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1050 Ti', 'Windows', '10', '2.5kg', '14227200']\n",
      "['Dell', 'Latitude 5480', 'Notebook', '14.0\"', '1366x768', 'Intel Core i5 7200U 2.5GHz', '4GB', '500GB HDD', 'Intel HD Graphics 620', 'Windows', '10', '1.6kg', '7780500']\n",
      "['Asus', 'Rog GL502VS', 'Gaming', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '256GB SSD +  1TB HDD', 'Nvidia GeForce GTX 1070', 'Windows', '10', '2.34kg', '20673900']\n",
      "['Lenovo', 'V510-15IKB (i5-7200U/8GB/256GB/FHD/No', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 7200U 2.5GHz', '8GB', '256GB SSD', 'Intel HD Graphics 620', 'No OS', '', '2.3kg', '5095116']\n",
      "['Dell', 'XPS 13', '2 in 1 Convertible', '13.3\"', 'Quad HD+ / Touchscreen 3200x1800', 'Intel Core i5 7Y54 1.2GHz', '8GB', '256GB SSD', 'Intel HD Graphics 615', 'Windows', '10', '1.24kg', '16121196']\n",
      "['Dell', 'Inspiron 3552', 'Notebook', '15.6\"', '1366x768', 'Intel Pentium Quad Core N3710 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics', 'Linux', '', '2.2kg', '2881008']\n",
      "['HP', '255 G6', 'Notebook', '15.6\"', '1366x768', 'AMD A6-Series 9220 2.5GHz', '4GB', '500GB HDD', 'AMD Radeon R4 Graphics', 'Windows', '10', '1.86kg', '3547908']\n",
      "['Lenovo', 'IdeaPad 310-15ISK', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i3 6100U 2.3GHz', '6GB', '128GB SSD', 'Nvidia GeForce 920MX', 'Windows', '10', '2.4kg', '5059548']\n",
      "['Lenovo', 'ThinkPad L460', 'Notebook', '14.0\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i5 6200U 2.3GHz', '8GB', '256GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.9kg', '9532224']\n",
      "['Dell', 'Inspiron 3552', 'Notebook', '15.6\"', '1366x768', 'Intel Pentium Quad Core N3700 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.2kg', '3947959.08']\n",
      "['Asus', 'X541NA-GO020T (N3350/4GB/1TB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3350 1.1GHz', '4GB', '1TB HDD', 'Intel HD Graphics 500', 'Windows', '10', '2kg', '3014388']\n",
      "['Asus', 'Rog G752VT-GC073T', 'Gaming', '17.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '16GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 970M', 'Windows', '10', '4.0kg', '16894800']\n",
      "['Dell', 'Vostro 3568', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 6006U 2GHz', '4GB', '500GB HDD', 'Intel HD Graphics 520', 'Windows', '10', '2.29kg', '4357080']\n",
      "['Lenovo', 'B51-80 (i7-6500U/8GB/1008GB/Radeon', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6500U 2.5GHz', '8GB', '1TB Hybrid', 'AMD Radeon R5 M330', 'Windows', '7', '2.32kg', '7958340']\n",
      "['MSI', 'GE62 Apache', 'Gaming', '15.6\"', 'Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '128GB SSD +  1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.4kg', '10928268']\n",
      "['Lenovo', 'Yoga 500-14IBD', '2 in 1 Convertible', '14.0\"', 'Full HD / Touchscreen 1920x1080', 'Intel Core i5 6200U 2.3GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.8kg', '7407124.92']\n",
      "['Asus', 'ZenBook UX305CA-UBM1', 'Ultrabook', '13.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core M 6Y30 0.9GHz', '8GB', '512GB SSD', 'Intel HD Graphics 515', 'Windows', '10', '1.2kg', '6482268']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '6GB', '1TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.3kg', '4081428']\n",
      "['Acer', 'Aspire ES1-531', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics 400', 'Linux', '', '2.4kg', '2569788']\n",
      "['Dell', 'Inspiron 3552', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '2GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.20kg', '3370068']\n",
      "['Lenovo', 'IdeaPad Y700-15ISK', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.6kg', '7993908']\n",
      "['HP', 'Pavilion 15-AW003nv', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A9-Series 9410 2.9GHz', '6GB', '1TB Hybrid', 'AMD Radeon R7 M440', 'Windows', '10', '2.04kg', '4890511.08']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 7500U 2.7GHz', '8GB', '1TB HDD', 'AMD Radeon R5 M430', 'Linux', '', '2.3kg', '7166863.08']\n",
      "['HP', 'Stream 11-Y000na', 'Netbook', '11.6\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '2GB', '32GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '1.17kg', '1858428']\n",
      "['Asus', 'X556UJ-XO044T (i7-6500U/4GB/500GB/GeForce', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 6500U 2.5GHz', '4GB', '500GB HDD', 'Nvidia GeForce 920M', 'Windows', '10', '2.2kg', '6405085.44']\n",
      "['Lenovo', 'Yoga 500-14ISK', '2 in 1 Convertible', '14.0\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.5GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.8kg', '5673096']\n",
      "['Lenovo', 'Yoga 900-13ISK', '2 in 1 Convertible', '13.3\"', 'IPS Panel Quad HD+ / Touchscreen 3200x1800', 'Intel Core i7 6500U 2.5GHz', '16GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.3kg', '13329108']\n",
      "['Lenovo', 'IdeaPad 100S-14IBR', 'Notebook', '14.0\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '2GB', '64GB Flash Storage', 'Intel HD Graphics', 'Windows', '10', '1.5kg', '2036268']\n",
      "['HP', '15-AC110nv (i7-6500U/6GB/1TB/Radeon', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 6500U 2.5GHz', '6GB', '1TB HDD', 'AMD Radeon R5 M330', 'Windows', '10', '2.19kg', '6793488']\n",
      "['Asus', 'X553SA-XX031T (N3050/4GB/500GB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.2kg', '3281148']\n",
      "['Asus', 'ZenBook UX305CA-UBM1', 'Ultrabook', '13.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core M 6Y30 0.9GHz', '8GB', '512GB SSD', 'Intel HD Graphics 515', 'Windows', '10', '1.2kg', '6482268']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '6GB', '1TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.3kg', '4081428']\n",
      "['Acer', 'Aspire ES1-531', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics 400', 'Linux', '', '2.4kg', '2569788']\n",
      "['Dell', 'Inspiron 3552', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '2GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.20kg', '3370068']\n",
      "['Lenovo', 'IdeaPad Y700-15ISK', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.6kg', '7993908']\n",
      "['HP', 'Pavilion 15-AW003nv', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A9-Series 9410 2.9GHz', '6GB', '1TB Hybrid', 'AMD Radeon R7 M440', 'Windows', '10', '2.04kg', '4890511.08']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 7500U 2.7GHz', '8GB', '1TB HDD', 'AMD Radeon R5 M430', 'Linux', '', '2.3kg', '7166863.08']\n",
      "['HP', 'Stream 11-Y000na', 'Netbook', '11.6\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '2GB', '32GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '1.17kg', '1858428']\n",
      "['Asus', 'X556UJ-XO044T (i7-6500U/4GB/500GB/GeForce', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 6500U 2.5GHz', '4GB', '500GB HDD', 'Nvidia GeForce 920M', 'Windows', '10', '2.2kg', '6405085.44']\n",
      "['Lenovo', 'Yoga 500-14ISK', '2 in 1 Convertible', '14.0\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.5GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.8kg', '5673096']\n",
      "['Lenovo', 'Yoga 900-13ISK', '2 in 1 Convertible', '13.3\"', 'IPS Panel Quad HD+ / Touchscreen 3200x1800', 'Intel Core i7 6500U 2.5GHz', '16GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.3kg', '13329108']\n",
      "['Lenovo', 'IdeaPad 100S-14IBR', 'Notebook', '14.0\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '2GB', '64GB Flash Storage', 'Intel HD Graphics', 'Windows', '10', '1.5kg', '2036268']\n",
      "['HP', '15-AC110nv (i7-6500U/6GB/1TB/Radeon', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 6500U 2.5GHz', '6GB', '1TB HDD', 'AMD Radeon R5 M330', 'Windows', '10', '2.19kg', '6793488']\n",
      "['Asus', 'X553SA-XX031T (N3050/4GB/500GB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.2kg', '3281148']\n",
      "['Asus', 'ZenBook UX305CA-UBM1', 'Ultrabook', '13.3\"', 'IPS Panel Full HD 1920x1080', 'Intel Core M 6Y30 0.9GHz', '8GB', '512GB SSD', 'Intel HD Graphics 515', 'Windows', '10', '1.2kg', '6482268']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i3 7100U 2.4GHz', '6GB', '1TB HDD', 'Intel HD Graphics 620', 'Windows', '10', '2.3kg', '4081428']\n",
      "['Acer', 'Aspire ES1-531', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics 400', 'Linux', '', '2.4kg', '2569788']\n",
      "['Dell', 'Inspiron 3552', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '2GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.20kg', '3370068']\n",
      "['Lenovo', 'IdeaPad Y700-15ISK', 'Notebook', '15.6\"', 'IPS Panel Full HD 1920x1080', 'Intel Core i7 6700HQ 2.6GHz', '8GB', '1TB HDD', 'Nvidia GeForce GTX 960M', 'Windows', '10', '2.6kg', '7993908']\n",
      "['HP', 'Pavilion 15-AW003nv', 'Notebook', '15.6\"', 'Full HD 1920x1080', 'AMD A9-Series 9410 2.9GHz', '6GB', '1TB Hybrid', 'AMD Radeon R7 M440', 'Windows', '10', '2.04kg', '4890511.08']\n",
      "['Dell', 'Inspiron 3567', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 7500U 2.7GHz', '8GB', '1TB HDD', 'AMD Radeon R5 M430', 'Linux', '', '2.3kg', '7166863.08']\n",
      "['HP', 'Stream 11-Y000na', 'Netbook', '11.6\"', '1366x768', 'Intel Celeron Dual Core N3060 1.6GHz', '2GB', '32GB Flash Storage', 'Intel HD Graphics 400', 'Windows', '10', '1.17kg', '1858428']\n",
      "['Asus', 'X556UJ-XO044T (i7-6500U/4GB/500GB/GeForce', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 6500U 2.5GHz', '4GB', '500GB HDD', 'Nvidia GeForce 920M', 'Windows', '10', '2.2kg', '6405085.44']\n",
      "['Lenovo', 'Yoga 500-14ISK', '2 in 1 Convertible', '14.0\"', 'IPS Panel Full HD / Touchscreen 1920x1080', 'Intel Core i7 6500U 2.5GHz', '4GB', '128GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.8kg', '5673096']\n",
      "['Lenovo', 'Yoga 900-13ISK', '2 in 1 Convertible', '13.3\"', 'IPS Panel Quad HD+ / Touchscreen 3200x1800', 'Intel Core i7 6500U 2.5GHz', '16GB', '512GB SSD', 'Intel HD Graphics 520', 'Windows', '10', '1.3kg', '13329108']\n",
      "['Lenovo', 'IdeaPad 100S-14IBR', 'Notebook', '14.0\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '2GB', '64GB Flash Storage', 'Intel HD Graphics', 'Windows', '10', '1.5kg', '2036268']\n",
      "['HP', '15-AC110nv (i7-6500U/6GB/1TB/Radeon', 'Notebook', '15.6\"', '1366x768', 'Intel Core i7 6500U 2.5GHz', '6GB', '1TB HDD', 'AMD Radeon R5 M330', 'Windows', '10', '2.19kg', '6793488']\n",
      "['Asus', 'X553SA-XX031T (N3050/4GB/500GB/W10)', 'Notebook', '15.6\"', '1366x768', 'Intel Celeron Dual Core N3050 1.6GHz', '4GB', '500GB HDD', 'Intel HD Graphics', 'Windows', '10', '2.2kg', '3281148']\n"
     ]
    }
   ],
   "source": [
    "# LAPTOP DETAILS\n",
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/laptops_test.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:          \n",
    "        print(line)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "To print all manufacture company"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Manufacturer\n",
      "HP\n",
      "Asus\n",
      "Dell\n",
      "Toshiba\n",
      "Lenovo\n",
      "Fujitsu\n",
      "Toshiba\n",
      "Dell\n",
      "HP\n",
      "Lenovo\n",
      "Dell\n",
      "Dell\n",
      "HP\n",
      "HP\n",
      "Lenovo\n",
      "Lenovo\n",
      "Dell\n",
      "Asus\n",
      "HP\n",
      "Acer\n",
      "Asus\n",
      "HP\n",
      "Acer\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "Toshiba\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "Toshiba\n",
      "HP\n",
      "Lenovo\n",
      "Toshiba\n",
      "HP\n",
      "Dell\n",
      "Toshiba\n",
      "HP\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "HP\n",
      "Acer\n",
      "MSI\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "Toshiba\n",
      "Dell\n",
      "HP\n",
      "Lenovo\n",
      "Vero\n",
      "Toshiba\n",
      "Lenovo\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "MSI\n",
      "Lenovo\n",
      "Asus\n",
      "Lenovo\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "HP\n",
      "Acer\n",
      "Dell\n",
      "MSI\n",
      "HP\n",
      "Asus\n",
      "Dell\n",
      "Dell\n",
      "MSI\n",
      "Dell\n",
      "Asus\n",
      "Dell\n",
      "Dell\n",
      "Apple\n",
      "Dell\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "Lenovo\n",
      "Lenovo\n",
      "Lenovo\n",
      "MSI\n",
      "Lenovo\n",
      "HP\n",
      "Lenovo\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "HP\n",
      "Lenovo\n",
      "HP\n",
      "Acer\n",
      "Dell\n",
      "HP\n",
      "Asus\n",
      "Dell\n",
      "HP\n",
      "Acer\n",
      "Dell\n",
      "MSI\n",
      "HP\n",
      "Asus\n",
      "Dell\n",
      "Dell\n",
      "Acer\n",
      "HP\n",
      "Lenovo\n",
      "Dell\n",
      "MSI\n",
      "Lenovo\n",
      "HP\n",
      "Asus\n",
      "HP\n",
      "Dell\n",
      "Lenovo\n",
      "HP\n",
      "Lenovo\n",
      "Dell\n",
      "Lenovo\n",
      "Razer\n",
      "Toshiba\n",
      "Asus\n",
      "Vero\n",
      "HP\n",
      "HP\n",
      "Dell\n",
      "Asus\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "Lenovo\n",
      "HP\n",
      "HP\n",
      "Lenovo\n",
      "Asus\n",
      "HP\n",
      "Acer\n",
      "Lenovo\n",
      "HP\n",
      "Dell\n",
      "MSI\n",
      "HP\n",
      "Lenovo\n",
      "MSI\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "Lenovo\n",
      "Dell\n",
      "Dell\n",
      "HP\n",
      "MSI\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "Lenovo\n",
      "MSI\n",
      "HP\n",
      "Lenovo\n",
      "HP\n",
      "Dell\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "MSI\n",
      "HP\n",
      "HP\n",
      "Asus\n",
      "Lenovo\n",
      "Lenovo\n",
      "Asus\n",
      "Lenovo\n",
      "Lenovo\n",
      "MSI\n",
      "HP\n",
      "Lenovo\n",
      "Lenovo\n",
      "Dell\n",
      "Acer\n",
      "HP\n",
      "Asus\n",
      "Dell\n",
      "Acer\n",
      "Dell\n",
      "Acer\n",
      "Lenovo\n",
      "Samsung\n",
      "HP\n",
      "Apple\n",
      "Dell\n",
      "HP\n",
      "Lenovo\n",
      "Asus\n",
      "Acer\n",
      "MSI\n",
      "Dell\n",
      "Lenovo\n",
      "Dell\n",
      "Dell\n",
      "Asus\n",
      "Dell\n",
      "HP\n",
      "Lenovo\n",
      "Acer\n",
      "Asus\n",
      "Apple\n",
      "Asus\n",
      "MSI\n",
      "Dell\n",
      "Asus\n",
      "Acer\n",
      "Acer\n",
      "Lenovo\n",
      "Lenovo\n",
      "Acer\n",
      "Lenovo\n",
      "MSI\n",
      "HP\n",
      "Dell\n",
      "Dell\n",
      "Asus\n",
      "Dell\n",
      "Dell\n",
      "Lenovo\n",
      "MSI\n",
      "Lenovo\n",
      "Razer\n",
      "Dell\n",
      "MSI\n",
      "Apple\n",
      "HP\n",
      "HP\n",
      "Dell\n",
      "MSI\n",
      "Lenovo\n",
      "Lenovo\n",
      "Asus\n",
      "Acer\n",
      "Dell\n",
      "HP\n",
      "Asus\n",
      "Dell\n",
      "Asus\n",
      "Lenovo\n",
      "Dell\n",
      "Dell\n",
      "HP\n",
      "Lenovo\n",
      "Lenovo\n",
      "Dell\n",
      "Asus\n",
      "Asus\n",
      "Dell\n",
      "Lenovo\n",
      "MSI\n",
      "Lenovo\n",
      "Asus\n",
      "Dell\n",
      "Acer\n",
      "Dell\n",
      "Lenovo\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "Asus\n",
      "Lenovo\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "Asus\n",
      "Asus\n",
      "Dell\n",
      "Acer\n",
      "Dell\n",
      "Lenovo\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "Asus\n",
      "Lenovo\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "Asus\n",
      "Asus\n",
      "Dell\n",
      "Acer\n",
      "Dell\n",
      "Lenovo\n",
      "HP\n",
      "Dell\n",
      "HP\n",
      "Asus\n",
      "Lenovo\n",
      "Lenovo\n",
      "Lenovo\n",
      "HP\n",
      "Asus\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/laptops_test.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        print(line[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "HP 5148468\n",
      "HP 7166952\n",
      "HP 16965936\n",
      "HP 4437108\n",
      "HP 11995308\n",
      "HP 18575388\n",
      "HP 10572588\n",
      "HP 6926868\n",
      "HP 9781111.08\n",
      "HP 10714860\n",
      "HP 12884508\n",
      "HP 9330019.92\n",
      "HP 6082128\n",
      "HP 13684788\n",
      "HP 14138280\n",
      "HP 16781071.32\n",
      "HP 7113600\n",
      "HP 6846751.08\n",
      "HP 19820268\n",
      "HP 10216908\n",
      "HP 10540843.56\n",
      "HP 13862628\n",
      "HP 10572588\n",
      "HP 9425520\n",
      "HP 9603360\n",
      "HP 8651916\n",
      "HP 10625940\n",
      "HP 10928179.08\n",
      "HP 11995308\n",
      "HP 6597864\n",
      "HP 8985454.92\n",
      "HP 8892000\n",
      "HP 18702899.28\n",
      "HP 13062348\n",
      "HP 8705268\n",
      "HP 8705268\n",
      "HP 6270193.8\n",
      "HP 4437108\n",
      "HP 9514440\n",
      "HP 10661508\n",
      "HP 10661508\n",
      "HP 9692280\n",
      "HP 8358480\n",
      "HP 18219708\n",
      "HP 9167563.08\n",
      "HP 13293540\n",
      "HP 5468580\n",
      "HP 3076543.08\n",
      "HP 14218308\n",
      "HP 4446000\n",
      "HP 25777908\n",
      "HP 3539016\n",
      "HP 15107508\n",
      "HP 17508348\n",
      "HP 15027480\n",
      "HP 13453596\n",
      "HP 16850340\n",
      "HP 10039068\n",
      "HP 5593068\n",
      "HP 6686784\n",
      "HP 35118064.8\n",
      "HP 19310934.24\n",
      "HP 14485068\n",
      "HP 19820268\n",
      "HP 15996708\n",
      "HP 16885908\n",
      "HP 20424479.4\n",
      "HP 14040468\n",
      "HP 2640924\n",
      "HP 4258289.88\n",
      "HP 18148572\n",
      "HP 7993908\n",
      "HP 4241395.08\n",
      "HP 2214108\n",
      "HP 6037668\n",
      "HP 10305828\n",
      "HP 5779800\n",
      "HP 7104708\n",
      "HP 4312620\n",
      "HP 11799684\n",
      "HP 5148468\n",
      "HP 4703868\n",
      "HP 4250376\n",
      "HP 19546305.48\n",
      "HP 9781111.08\n",
      "HP 3547908\n",
      "HP 4890511.08\n",
      "HP 1858428\n",
      "HP 6793488\n",
      "HP 4890511.08\n",
      "HP 1858428\n",
      "HP 6793488\n",
      "HP 4890511.08\n",
      "HP 1858428\n",
      "HP 6793488\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/laptops_test.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        if line[0]==\"HP\":\n",
    "            print(line[0],line[12])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "laptop and it storage data,"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Manufacturer RAM\n",
      "HP 6GB\n",
      "Lenovo 6GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "Dell 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "Dell 8GB\n",
      "Asus 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Acer 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "Toshiba 8GB\n",
      "Toshiba 8GB\n",
      "HP 8GB\n",
      "Toshiba 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "Acer 6GB\n",
      "MSI 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Toshiba 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "Acer 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "Asus 64GB\n",
      "Dell 8GB\n",
      "Apple 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "Lenovo 8GB\n",
      "Lenovo 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "Asus 8GB\n",
      "Acer 8GB\n",
      "Dell 8GB\n",
      "MSI 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "MSI 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "Razer 8GB\n",
      "Asus 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "MSI 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "HP 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "Lenovo 8GB\n",
      "Dell 8GB\n",
      "Dell 8GB\n",
      "Lenovo 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "Dell 8GB\n",
      "Lenovo 8GB\n",
      "MSI 8GB\n",
      "HP 8GB\n",
      "Lenovo 8GB\n",
      "Lenovo 8GB\n",
      "Lenovo 6GB\n",
      "Dell 8GB\n",
      "HP 6GB\n",
      "Asus 8GB\n",
      "Dell 8GB\n",
      "Lenovo 8GB\n",
      "Apple 8GB\n",
      "Dell 8GB\n",
      "Lenovo 8GB\n",
      "Asus 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "Acer 8GB\n",
      "Apple 8GB\n",
      "Dell 8GB\n",
      "Lenovo 8GB\n",
      "Lenovo 8GB\n",
      "Acer 8GB\n",
      "Lenovo 8GB\n",
      "MSI 8GB\n",
      "HP 6GB\n",
      "Dell 8GB\n",
      "Dell 8GB\n",
      "MSI 8GB\n",
      "Dell 8GB\n",
      "HP 8GB\n",
      "MSI 8GB\n",
      "Lenovo 6GB\n",
      "Asus 8GB\n",
      "Lenovo 8GB\n",
      "Dell 8GB\n",
      "Lenovo 6GB\n",
      "Lenovo 8GB\n",
      "Lenovo 8GB\n",
      "MSI 8GB\n",
      "Asus 8GB\n",
      "Dell 6GB\n",
      "Lenovo 8GB\n",
      "HP 6GB\n",
      "Dell 8GB\n",
      "HP 6GB\n",
      "Asus 8GB\n",
      "Dell 6GB\n",
      "Lenovo 8GB\n",
      "HP 6GB\n",
      "Dell 8GB\n",
      "HP 6GB\n",
      "Asus 8GB\n",
      "Dell 6GB\n",
      "Lenovo 8GB\n",
      "HP 6GB\n",
      "Dell 8GB\n",
      "HP 6GB\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/laptops_test.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        if line[6]>=\"6\": \n",
    "            print(line[0],line[6]) "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "weight of laptop of paticular company"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Toshiba 1.2kg\n",
      "Toshiba 1.75kg\n",
      "Dell 1.6kg\n",
      "HP 0.97kg\n",
      "Lenovo 1.9kg\n",
      "Dell 1.68kg\n",
      "Asus 1.4kg\n",
      "HP 1.11kg\n",
      "HP 1.48kg\n",
      "HP 1.34kg\n",
      "HP 1.64kg\n",
      "Toshiba 1.2kg\n",
      "HP 1.48kg\n",
      "HP 1.95kg\n",
      "HP 1.43kg\n",
      "HP 1.64kg\n",
      "HP 1.64kg\n",
      "HP 1.26kg\n",
      "HP 1.48kg\n",
      "HP 1.54kg\n",
      "HP 1.49kg\n",
      "Toshiba 1.5kg\n",
      "Toshiba 1.47kg\n",
      "HP 1.43kg\n",
      "Toshiba 1.2kg\n",
      "HP 1.11kg\n",
      "HP 1.64kg\n",
      "HP 1.26kg\n",
      "HP 1.95kg\n",
      "Dell 1.29kg\n",
      "HP 1.64kg\n",
      "HP 1.95kg\n",
      "HP 1.84kg\n",
      "HP 1.26kg\n",
      "Toshiba 1.47kg\n",
      "HP 1.64kg\n",
      "Lenovo 1.8kg\n",
      "Vero 1.45kg\n",
      "HP 1.54kg\n",
      "HP 1.84kg\n",
      "HP 1.43kg\n",
      "Asus 1.2kg\n",
      "Lenovo 1.1kg\n",
      "HP 1.91kg\n",
      "Dell 1.2kg\n",
      "HP 1.96kg\n",
      "Dell 1.6kg\n",
      "MSI 1.8kg\n",
      "Dell 1.29kg\n",
      "Dell 1.62kg\n",
      "Apple 0.920kg\n",
      "HP 1.26kg\n",
      "HP 1.49kg\n",
      "Lenovo 1.3kg\n",
      "Lenovo 0.99kg\n",
      "Lenovo 0.69kg\n",
      "HP 1.3kg\n",
      "HP 1.54kg\n",
      "HP 1.9kg\n",
      "Lenovo 1.7kg\n",
      "HP 1.29kg\n",
      "HP 1.86kg\n",
      "Dell 1.4kg\n",
      "HP 1.96kg\n",
      "Dell 1.5kg\n",
      "Dell 1.5kg\n",
      "Dell 1.5kg\n",
      "HP 1.16kg\n",
      "HP 1.16kg\n",
      "Lenovo 0.69kg\n",
      "Dell 1.23kg\n",
      "Razer 1.25kg\n",
      "Toshiba 1.05kg\n",
      "Vero 1.35kg\n",
      "HP 1.16kg\n",
      "HP 1.43kg\n",
      "Lenovo 1.8kg\n",
      "Lenovo 0.69kg\n",
      "HP 1.26kg\n",
      "Lenovo 1.8kg\n",
      "Asus 1.5kg\n",
      "HP 1.84kg\n",
      "HP 1.88kg\n",
      "HP 1.48kg\n",
      "HP 1.48kg\n",
      "HP 1.26kg\n",
      "HP 1.88kg\n",
      "Lenovo 1.27kg\n",
      "Lenovo 1.9kg\n",
      "HP 1.86kg\n",
      "HP 1.91kg\n",
      "Lenovo 1.4kg\n",
      "HP 1.48kg\n",
      "Lenovo 1.7kg\n",
      "MSI 1.7kg\n",
      "Lenovo 1.95kg\n",
      "HP 1.44kg\n",
      "HP 1.96kg\n",
      "MSI 1.91kg\n",
      "Lenovo 1.36kg\n",
      "Lenovo 1.54kg\n",
      "Dell 1.98kg\n",
      "Dell 1.23kg\n",
      "Samsung 1.15kg\n",
      "HP 1.86kg\n",
      "Apple 0.920kg\n",
      "Dell 1.6kg\n",
      "Lenovo 1.9kg\n",
      "Dell 1.2kg\n",
      "HP 1.91kg\n",
      "Apple 0.920kg\n",
      "Acer 1.3kg\n",
      "Acer 1.2kg\n",
      "Dell 1.26kg\n",
      "Dell 1.29kg\n",
      "Lenovo 1.3kg\n",
      "Razer 1.95kg\n",
      "Apple 1.08kg\n",
      "HP 1.54kg\n",
      "Lenovo 1.4kg\n",
      "Asus 1.45kg\n",
      "HP 1.54kg\n",
      "Dell 1.6kg\n",
      "Dell 1.24kg\n",
      "HP 1.86kg\n",
      "Lenovo 1.9kg\n",
      "Lenovo 1.8kg\n",
      "Asus 1.2kg\n",
      "HP 1.17kg\n",
      "Lenovo 1.8kg\n",
      "Lenovo 1.3kg\n",
      "Lenovo 1.5kg\n",
      "Asus 1.2kg\n",
      "HP 1.17kg\n",
      "Lenovo 1.8kg\n",
      "Lenovo 1.3kg\n",
      "Lenovo 1.5kg\n",
      "Asus 1.2kg\n",
      "HP 1.17kg\n",
      "Lenovo 1.8kg\n",
      "Lenovo 1.3kg\n",
      "Lenovo 1.5kg\n"
     ]
    }
   ],
   "source": [
    "\n",
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/laptops_test.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        if line[11]<=\"2\":\n",
    "            print(line[0],line[11])  "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "laptop screen size"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Manufacturer Screen\n",
      "Asus Full HD 1920x1080\n",
      "Dell IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Toshiba Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "Asus Quad HD+ 3200x1800\n",
      "HP IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Asus Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Acer IPS Panel Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "Toshiba Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel 4K Ultra HD 3840x2160\n",
      "Toshiba IPS Panel Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Dell IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Toshiba Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "Dell Quad HD+ / Touchscreen 3200x1800\n",
      "HP Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Toshiba IPS Panel Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Toshiba IPS Panel Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "MSI IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel 2560x1440\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "Dell IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Dell Quad HD+ / Touchscreen 3200x1800\n",
      "Dell IPS Panel Full HD / Touchscreen 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Apple IPS Panel Retina Display 2304x1440\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Touchscreen 2560x1440\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Touchscreen 1920x1200\n",
      "HP IPS Panel 4K Ultra HD 3840x2160\n",
      "Dell Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "HP Quad HD+ 3200x1800\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Dell IPS Panel Full HD 1920x1080\n",
      "Acer Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "HP Quad HD+ / Touchscreen 3200x1800\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Touchscreen 1920x1200\n",
      "Dell Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Razer Touchscreen / 4K Ultra HD 3840x2160\n",
      "Toshiba Full HD 1920x1080\n",
      "Asus Full HD 1920x1080\n",
      "Vero Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Lenovo IPS Panel Touchscreen 1920x1200\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Acer Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Touchscreen 2560x1440\n",
      "MSI Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "HP Touchscreen 2560x1440\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Touchscreen 2560x1440\n",
      "Lenovo Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "Dell IPS Panel Touchscreen / 4K Ultra HD 3840x2160\n",
      "HP Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "HP Touchscreen 2560x1440\n",
      "Lenovo Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "MSI IPS Panel Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "Asus Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Lenovo IPS Panel Touchscreen 2560x1440\n",
      "Lenovo Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Acer Full HD 1920x1080\n",
      "Dell Quad HD+ / Touchscreen 3200x1800\n",
      "Acer IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Samsung IPS Panel Touchscreen 2400x1600\n",
      "Apple IPS Panel Retina Display 2304x1440\n",
      "Dell IPS Panel Full HD / Touchscreen 1920x1080\n",
      "HP IPS Panel Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Dell Quad HD+ / Touchscreen 3200x1800\n",
      "Asus Full HD 1920x1080\n",
      "Dell Full HD 1920x1080\n",
      "Asus Full HD 1920x1080\n",
      "Apple IPS Panel Retina Display 2304x1440\n",
      "Asus Full HD 1920x1080\n",
      "MSI IPS Panel Full HD 1920x1080\n",
      "Dell IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Asus Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Acer IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Dell Quad HD+ / Touchscreen 3200x1800\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Razer Full HD 1920x1080\n",
      "Dell Touchscreen 1366x768\n",
      "MSI Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "Asus Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Dell Quad HD+ / Touchscreen 3200x1800\n",
      "Lenovo Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Lenovo Full HD 1920x1080\n",
      "MSI Full HD 1920x1080\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Lenovo IPS Panel Quad HD+ / Touchscreen 3200x1800\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Lenovo IPS Panel Quad HD+ / Touchscreen 3200x1800\n",
      "Asus IPS Panel Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD 1920x1080\n",
      "HP Full HD 1920x1080\n",
      "Lenovo IPS Panel Full HD / Touchscreen 1920x1080\n",
      "Lenovo IPS Panel Quad HD+ / Touchscreen 3200x1800\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/laptops_test.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        if line[4]>=\"Full HD 1920x1080\": \n",
    "            print(line[0],line[4])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# EMPLOYEE DETAILES"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Age', 'Gender', 'Education Level', 'Job Title', 'Years of Experience', 'Salary']\n",
      "['32', 'Male', \"Bachelor's\", 'Software Engineer', '5', '90000']\n",
      "['28', 'Female', \"Master's\", 'Data Analyst', '3', '65000']\n",
      "['45', 'Male', 'PhD', 'Senior Manager', '15', '150000']\n",
      "['36', 'Female', \"Bachelor's\", 'Sales Associate', '7', '60000']\n",
      "['52', 'Male', \"Master's\", 'Director', '20', '200000']\n",
      "['29', 'Male', \"Bachelor's\", 'Marketing Analyst', '2', '55000']\n",
      "['42', 'Female', \"Master's\", 'Product Manager', '12', '120000']\n",
      "['31', 'Male', \"Bachelor's\", 'Sales Manager', '4', '80000']\n",
      "['26', 'Female', \"Bachelor's\", 'Marketing Coordinator', '1', '45000']\n",
      "['38', 'Male', 'PhD', 'Senior Scientist', '10', '110000']\n",
      "['29', 'Male', \"Master's\", 'Software Developer', '3', '75000']\n",
      "['48', 'Female', \"Bachelor's\", 'HR Manager', '18', '140000']\n",
      "['35', 'Male', \"Bachelor's\", 'Financial Analyst', '6', '65000']\n",
      "['40', 'Female', \"Master's\", 'Project Manager', '14', '130000']\n",
      "['27', 'Male', \"Bachelor's\", 'Customer Service Rep', '2', '40000']\n",
      "['44', 'Male', \"Bachelor's\", 'Operations Manager', '16', '125000']\n",
      "['33', 'Female', \"Master's\", 'Marketing Manager', '7', '90000']\n",
      "['39', 'Male', 'PhD', 'Senior Engineer', '12', '115000']\n",
      "['25', 'Female', \"Bachelor's\", 'Data Entry Clerk', '0', '35000']\n",
      "['51', 'Male', \"Bachelor's\", 'Sales Director', '22', '180000']\n",
      "['34', 'Female', \"Master's\", 'Business Analyst', '5', '80000']\n",
      "['47', 'Male', \"Master's\", 'VP of Operations', '19', '190000']\n",
      "['30', 'Male', \"Bachelor's\", 'IT Support', '2', '50000']\n",
      "['36', 'Female', \"Bachelor's\", 'Recruiter', '9', '60000']\n",
      "['41', 'Male', \"Master's\", 'Financial Manager', '13', '140000']\n",
      "['28', 'Female', \"Bachelor's\", 'Social Media Specialist', '3', '45000']\n",
      "['37', 'Female', \"Master's\", 'Software Manager', '11', '110000']\n",
      "['24', 'Male', \"Bachelor's\", 'Junior Developer', '1', '40000']\n",
      "['43', 'Female', 'PhD', 'Senior Consultant', '15', '140000']\n",
      "['33', 'Male', \"Master's\", 'Product Designer', '6', '90000']\n",
      "['50', 'Male', \"Bachelor's\", 'CEO', '25', '250000']\n",
      "['31', 'Female', \"Bachelor's\", 'Accountant', '4', '55000']\n",
      "['29', 'Male', \"Master's\", 'Data Scientist', '3', '75000']\n",
      "['39', 'Female', \"Bachelor's\", 'Marketing Specialist', '10', '65000']\n",
      "['46', 'Male', 'PhD', 'Senior Manager', '20', '170000']\n",
      "['27', 'Male', \"Bachelor's\", 'Technical Writer', '2', '45000']\n",
      "['35', 'Female', \"Bachelor's\", 'HR Generalist', '7', '60000']\n",
      "['42', 'Male', \"Master's\", 'Project Engineer', '14', '115000']\n",
      "['26', 'Female', \"Bachelor's\", 'Customer Success Rep', '1', '40000']\n",
      "['49', 'Male', \"Bachelor's\", 'Sales Executive', '21', '160000']\n",
      "['34', 'Female', \"Master's\", 'UX Designer', '5', '80000']\n",
      "['48', 'Male', \"Master's\", 'Operations Director', '18', '190000']\n",
      "['30', 'Male', \"Bachelor's\", 'Network Engineer', '3', '60000']\n",
      "['36', 'Female', \"Bachelor's\", 'Administrative Assistant', '8', '45000']\n",
      "['41', 'Male', \"Master's\", 'Strategy Consultant', '13', '130000']\n",
      "['28', 'Female', \"Bachelor's\", 'Copywriter', '2', '40000']\n",
      "['32', 'Male', \"Bachelor's\", 'Account Manager', '5', '75000']\n",
      "['45', 'Female', \"Master's\", 'Director of Marketing', '16', '180000']\n",
      "['38', 'Male', 'PhD', 'Senior Scientist', '11', '120000']\n",
      "['25', 'Male', \"Bachelor's\", 'Help Desk Analyst', '0', '35000']\n",
      "['51', 'Female', \"Bachelor's\", 'Customer Service Manager', '22', '130000']\n",
      "['33', 'Male', \"Master's\", 'Business Intelligence Analyst', '7', '85000']\n",
      "['40', 'Female', \"Bachelor's\", 'Event Coordinator', '12', '60000']\n",
      "['47', 'Male', \"Master's\", 'VP of Finance', '19', '200000']\n",
      "['29', 'Female', \"Bachelor's\", 'Graphic Designer', '3', '50000']\n",
      "['36', 'Male', \"Bachelor's\", 'Sales Manager', '9', '95000']\n",
      "['27', 'Female', \"Master's\", 'UX Researcher', '2', '65000']\n",
      "['43', 'Male', 'PhD', 'Senior Engineer', '17', '140000']\n",
      "['30', 'Female', \"Bachelor's\", 'Social Media Manager', '4', '55000']\n",
      "['35', 'Male', \"Master's\", 'Product Manager', '7', '105000']\n",
      "['51', 'Female', \"Master's\", 'Director of Operations', '23', '170000']\n",
      "['29', 'Male', \"Bachelor's\", 'Marketing Analyst', '3', '50000']\n",
      "['40', 'Female', \"Bachelor's\", 'HR Manager', '12', '80000']\n",
      "['47', 'Male', 'PhD', 'Senior Data Scientist', '21', '180000']\n",
      "['26', 'Male', \"Bachelor's\", 'Junior Accountant', '1', '35000']\n",
      "['38', 'Female', \"Master's\", 'Digital Marketing Manager', '10', '90000']\n",
      "['46', 'Male', \"Bachelor's\", 'IT Manager', '19', '120000']\n",
      "['31', 'Female', \"Bachelor's\", 'Customer Service Representative', '5', '45000']\n",
      "['34', 'Male', \"Master's\", 'Business Development Manager', '8', '90000']\n",
      "['49', 'Female', \"Master's\", 'Senior Financial Analyst', '18', '150000']\n",
      "['33', 'Male', \"Bachelor's\", 'Web Developer', '6', '65000']\n",
      "['39', 'Female', \"Bachelor's\", 'Recruiter', '11', '70000']\n",
      "['45', 'Male', 'PhD', 'Research Director', '16', '190000']\n",
      "['28', 'Male', \"Bachelor's\", 'Technical Support Specialist', '2', '40000']\n",
      "['42', 'Female', \"Master's\", 'Creative Director', '14', '120000']\n",
      "['37', 'Male', \"Bachelor's\", 'Project Manager', '10', '95000']\n",
      "['50', 'Female', \"Bachelor's\", 'Operations Manager', '22', '160000']\n",
      "['32', 'Male', \"Master's\", 'Senior Software Engineer', '6', '100000']\n",
      "['48', 'Female', \"Master's\", 'Human Resources Director', '20', '180000']\n",
      "['30', 'Female', \"Bachelor's\", 'Content Marketing Manager', '3', '55000']\n",
      "['36', 'Male', \"Bachelor's\", 'Technical Recruiter', '8', '70000']\n",
      "['41', 'Female', \"Master's\", 'Data Analyst', '13', '80000']\n",
      "['25', 'Male', \"Bachelor's\", 'Sales Representative', '0', '30000']\n",
      "['52', 'Male', 'PhD', 'Chief Technology Officer', '24', '250000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Designer', '2', '40000']\n",
      "['34', 'Female', \"Master's\", 'Financial Advisor', '10', '95000']\n",
      "['27', 'Male', \"Bachelor's\", 'Junior Account Manager', '2', '45000']\n",
      "['40', 'Female', \"Bachelor's\", 'HR Generalist', '15', '80000']\n",
      "['46', 'Male', \"Master's\", 'Senior Project Manager', '21', '135000']\n",
      "['31', 'Female', \"Bachelor's\", 'Marketing Coordinator', '6', '55000']\n",
      "['36', 'Male', 'PhD', 'Principal Scientist', '11', '120000']\n",
      "['29', 'Female', \"Bachelor's\", 'Sales Associate', '3', '40000']\n",
      "['43', 'Male', \"Bachelor's\", 'Supply Chain Manager', '18', '105000']\n",
      "['52', 'Female', \"Master's\", 'Senior Marketing Manager', '25', '170000']\n",
      "['33', 'Male', \"Bachelor's\", 'Business Analyst', '7', '75000']\n",
      "['39', 'Female', \"Bachelor's\", 'Training Specialist', '12', '65000']\n",
      "['47', 'Male', 'PhD', 'Research Scientist', '22', '160000']\n",
      "['26', 'Male', \"Bachelor's\", 'Junior Software Developer', '1', '35000']\n",
      "['38', 'Female', \"Master's\", 'Public Relations Manager', '10', '90000']\n",
      "['45', 'Male', \"Bachelor's\", 'Operations Analyst', '20', '110000']\n",
      "['31', 'Female', \"Bachelor's\", 'Event Coordinator', '5', '45000']\n",
      "['35', 'Male', \"Master's\", 'Product Marketing Manager', '8', '95000']\n",
      "['49', 'Female', \"Master's\", 'Senior HR Manager', '19', '150000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Web Developer', '5', '50000']\n",
      "['39', 'Female', \"Master's\", 'Senior Project Coordinator', '13', '80000']\n",
      "['44', 'Male', 'PhD', 'Chief Data Officer', '16', '220000']\n",
      "['30', 'Female', \"Bachelor's\", 'Digital Content Producer', '3', '50000']\n",
      "['36', 'Male', \"Bachelor's\", 'IT Support Specialist', '7', '60000']\n",
      "['41', 'Female', \"Master's\", 'Senior Marketing Analyst', '14', '100000']\n",
      "['28', 'Male', \"Bachelor's\", 'Customer Success Manager', '2', '40000']\n",
      "['42', 'Female', \"Master's\", 'Senior Graphic Designer', '15', '110000']\n",
      "['37', 'Male', \"Bachelor's\", 'Software Project Manager', '9', '95000']\n",
      "['50', 'Female', \"Bachelor's\", 'Supply Chain Analyst', '22', '130000']\n",
      "['32', 'Male', \"Master's\", 'Senior Business Analyst', '6', '90000']\n",
      "['23', 'Female', \"Bachelor's\", 'Junior Marketing Analyst', '0.5', '35000']\n",
      "['31', 'Male', \"Master's\", 'Senior Financial Analyst', '6', '95000']\n",
      "['40', 'Female', \"Bachelor's\", 'Office Manager', '15', '65000']\n",
      "['48', 'Male', 'PhD', 'Principal Engineer', '20', '170000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior HR Generalist', '3', '45000']\n",
      "['35', 'Male', \"Master's\", 'Senior Product Manager', '10', '120000']\n",
      "['42', 'Female', \"Bachelor's\", 'Sales Manager', '17', '100000']\n",
      "['53', 'Male', \"Master's\", 'Director of Marketing', '25', '180000']\n",
      "['33', 'Female', \"Bachelor's\", 'Junior Operations Analyst', '5', '50000']\n",
      "['38', 'Male', \"Bachelor's\", 'Customer Service Manager', '11', '80000']\n",
      "['44', 'Female', 'PhD', 'Senior Scientist', '16', '140000']\n",
      "['26', 'Male', \"Bachelor's\", 'Junior Accountant', '2', '40000']\n",
      "['37', 'Female', \"Master's\", 'Senior HR Generalist', '9', '95000']\n",
      "['45', 'Male', \"Bachelor's\", 'Sales Operations Manager', '18', '110000']\n",
      "['32', 'Female', \"Bachelor's\", 'Marketing Coordinator', '4', '50000']\n",
      "['34', 'Male', \"Master's\", 'Senior Software Developer', '8', '105000']\n",
      "['50', 'Female', \"Master's\", 'Director of Operations', '21', '160000']\n",
      "['29', 'Male', \"Bachelor's\", 'Junior Web Designer', '3', '45000']\n",
      "['40', 'Female', \"Master's\", 'Senior Training Specialist', '12', '100000']\n",
      "['47', 'Male', 'PhD', 'Senior Research Scientist', '22', '160000']\n",
      "['27', 'Male', \"Bachelor's\", 'Junior Sales Representative', '1', '35000']\n",
      "['39', 'Female', \"Bachelor's\", 'Administrative Assistant', '10', '55000']\n",
      "['46', 'Male', \"Master's\", 'Senior Project Manager', '19', '140000']\n",
      "['30', 'Female', \"Bachelor's\", 'Junior Marketing Manager', '4', '50000']\n",
      "['36', 'Male', \"Bachelor's\", 'Junior Data Analyst', '7', '60000']\n",
      "['43', 'Female', \"Master's\", 'Senior Product Marketing Manager', '14', '120000']\n",
      "['28', 'Male', \"Bachelor's\", 'Junior Business Analyst', '2', '40000']\n",
      "['41', 'Female', \"Master's\", 'Senior Marketing Manager', '13', '110000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Software Developer', '5', '50000']\n",
      "['47', 'Male', \"Bachelor's\", 'Senior Sales Manager', '20', '135000']\n",
      "['25', 'Female', \"Master's\", 'Junior Marketing Specialist', '1.5', '40000']\n",
      "['34', 'Male', \"Bachelor's\", 'Senior Business Analyst', '8', '90000']\n",
      "['42', 'Female', 'PhD', 'Senior Data Scientist', '16', '150000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior Project Manager', '4', '60000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Accountant', '10', '80000']\n",
      "['45', 'Male', \"Master's\", 'Director of Sales', '19', '175000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Recruiter', '3', '45000']\n",
      "['36', 'Male', \"Master's\", 'Senior Business Development Manager', '11', '120000']\n",
      "['43', 'Female', 'PhD', 'Senior Product Designer', '18', '140000']\n",
      "['26', 'Male', \"Bachelor's\", 'Junior Customer Support Specialist', '2', '35000']\n",
      "['37', 'Female', \"Master's\", 'Senior Marketing Analyst', '9', '95000']\n",
      "['44', 'Male', \"Bachelor's\", 'Senior IT Support Specialist', '14', '110000']\n",
      "['32', 'Female', \"Bachelor's\", 'Junior Financial Analyst', '5', '50000']\n",
      "['33', 'Male', \"Master's\", 'Senior Operations Manager', '7', '115000']\n",
      "['51', 'Female', 'PhD', 'Director of Human Resources', '23', '185000']\n",
      "['28', 'Male', \"Bachelor's\", 'Junior Software Engineer', '2', '40000']\n",
      "['39', 'Female', \"Bachelor's\", 'Senior Sales Representative', '12', '90000']\n",
      "['48', 'Male', \"Master's\", 'Director of Product Management', '21', '175000']\n",
      "['30', 'Female', \"Bachelor's\", 'Junior Copywriter', '3', '45000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Marketing Coordinator', '7', '80000']\n",
      "['41', 'Female', \"Master's\", 'Senior Human Resources Manager', '13', '120000']\n",
      "['27', 'Male', \"Bachelor's\", 'Junior Business Development Associate', '1.5', '35000']\n",
      "['40', 'Female', \"Bachelor's\", 'Senior Account Manager', '14', '110000']\n",
      "['46', 'Male', 'PhD', 'Senior Researcher', '18', '150000']\n",
      "['31', 'Female', \"Bachelor's\", 'Junior HR Coordinator', '4', '50000']\n",
      "['34', 'Male', \"Master's\", 'Senior Software Engineer', '9', '105000']\n",
      "['50', 'Female', \"Master's\", 'Director of Finance', '20', '180000']\n",
      "['29', 'Male', \"Bachelor's\", 'Junior Marketing Coordinator', '2', '40000']\n",
      "['', '', '', '', '', '']\n",
      "['43', 'Male', \"Bachelor's\", 'Senior Project Manager', '16', '140000']\n",
      "['26', 'Female', \"Master's\", 'Junior Data Scientist', '1.5', '45000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Operations Analyst', '7', '85000']\n",
      "['42', 'Female', 'PhD', 'Senior Marketing Manager', '18', '140000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior Accountant', '4', '50000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Human Resources Coordinator', '10', '80000']\n",
      "['46', 'Male', \"Master's\", 'Director of Operations', '20', '170000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Sales Representative', '2', '40000']\n",
      "['37', 'Male', \"Master's\", 'Senior Business Analyst', '9', '105000']\n",
      "['44', 'Female', 'PhD', 'Senior UX Designer', '15', '145000']\n",
      "['27', 'Male', \"Bachelor's\", 'Junior Product Manager', '2', '40000']\n",
      "['36', 'Female', \"Bachelor's\", 'Senior Marketing Specialist', '8', '85000']\n",
      "['43', 'Male', \"Bachelor's\", 'Senior IT Project Manager', '14', '130000']\n",
      "['33', 'Female', \"Master's\", 'Senior Financial Analyst', '6', '95000']\n",
      "['34', 'Male', \"Bachelor's\", 'Senior Quality Assurance Analyst', '9', '100000']\n",
      "['50', 'Female', 'PhD', 'Director of Sales and Marketing', '22', '180000']\n",
      "['28', 'Male', \"Bachelor's\", 'Junior Operations Analyst', '1.5', '35000']\n",
      "['39', 'Female', \"Bachelor's\", 'Senior Account Executive', '12', '95000']\n",
      "['47', 'Male', \"Master's\", 'Director of Business Development', '19', '170000']\n",
      "['30', 'Female', \"Bachelor's\", 'Junior Social Media Manager', '3', '45000']\n",
      "['34', 'Male', \"Bachelor's\", 'Senior Product Manager', '7', '95000']\n",
      "['40', 'Female', \"Master's\", 'Senior Human Resources Specialist', '13', '120000']\n",
      "['28', 'Male', \"Bachelor's\", 'Junior Business Analyst', '2', '40000']\n",
      "['41', 'Female', \"Bachelor's\", 'Senior Marketing Coordinator', '11', '90000']\n",
      "['45', 'Male', 'PhD', 'Senior Data Analyst', '17', '155000']\n",
      "['32', 'Female', \"Bachelor's\", 'Junior Account Manager', '5', '55000']\n",
      "['35', 'Male', \"Master's\", 'Senior Software Developer', '9', '110000']\n",
      "['49', 'Female', \"Master's\", 'Director of Human Capital', '21', '180000']\n",
      "['30', 'Male', \"Bachelor's\", 'Junior Advertising Coordinator', '3', '45000']\n",
      "['44', 'Male', \"Bachelor's\", 'Senior Sales Manager', '16', '130000']\n",
      "['27', 'Female', \"Master's\", 'Junior UX Designer', '1.5', '45000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Accountant', '7', '90000']\n",
      "['41', 'Female', 'PhD', 'Senior Marketing Director', '17', '160000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior HR Generalist', '4', '50000']\n",
      "['39', 'Female', \"Bachelor's\", 'Senior Operations Manager', '10', '120000']\n",
      "['47', 'Male', \"Master's\", 'Director of Finance', '20', '170000']\n",
      "['30', 'Female', \"Bachelor's\", 'Junior Marketing Coordinator', '2', '40000']\n",
      "['38', 'Male', \"Master's\", 'Senior IT Consultant', '9', '110000']\n",
      "['45', 'Female', 'PhD', 'Senior Product Designer', '15', '150000']\n",
      "['28', 'Male', \"Bachelor's\", 'Junior Business Development Associate', '2', '40000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Marketing Analyst', '8', '85000']\n",
      "['44', 'Male', \"Bachelor's\", 'Senior Software Engineer', '14', '130000']\n",
      "['34', 'Female', \"Master's\", 'Senior Financial Advisor', '6', '100000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Project Coordinator', '9', '95000']\n",
      "['50', 'Female', 'PhD', 'Director of Operations', '22', '180000']\n",
      "['29', 'Male', \"Bachelor's\", 'Junior Business Operations Analyst', '1.5', '35000']\n",
      "['40', 'Female', \"Bachelor's\", 'Senior Sales Representative', '12', '100000']\n",
      "['48', 'Male', \"Master's\", 'Director of Marketing', '19', '170000']\n",
      "['31', 'Female', \"Bachelor's\", 'Junior Social Media Specialist', '3', '45000']\n",
      "['33', 'Male', \"Bachelor's\", 'Senior Product Development Manager', '7', '100000']\n",
      "['42', 'Female', \"Master's\", 'Senior Human Resources Manager', '13', '140000']\n",
      "['28', 'Male', \"Bachelor's\", 'Junior Financial Analyst', '2', '40000']\n",
      "['40', 'Female', \"Bachelor's\", 'Senior Marketing Manager', '11', '105000']\n",
      "['46', 'Male', 'PhD', 'Senior Data Scientist', '18', '160000']\n",
      "['33', 'Female', \"Bachelor's\", 'Junior Operations Manager', '5', '70000']\n",
      "['37', 'Male', \"Master's\", 'Senior Software Architect', '9', '120000']\n",
      "['51', 'Female', \"Master's\", 'Director of Human Resources', '21', '190000']\n",
      "['30', 'Male', \"Bachelor's\", 'Junior Marketing Specialist', '3', '45000']\n",
      "['43', 'Male', \"Bachelor's\", 'Senior Project Manager', '15', '120000']\n",
      "['27', 'Female', \"Master's\", 'Junior Research Scientist', '1.5', '50000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Operations Analyst', '8', '85000']\n",
      "['42', 'Female', 'PhD', 'Senior Marketing Manager', '13', '140000']\n",
      "['32', 'Male', \"Bachelor's\", 'Junior Sales Representative', '3', '45000']\n",
      "['37', 'Female', \"Bachelor's\", 'Senior Financial Analyst', '9', '100000']\n",
      "['45', 'Male', \"Master's\", 'Senior Software Developer', '16', '140000']\n",
      "['33', 'Female', \"Bachelor's\", 'Junior Operations Analyst', '5', '70000']\n",
      "['39', 'Male', \"Bachelor's\", 'Senior Marketing Specialist', '10', '120000']\n",
      "['44', 'Female', 'PhD', 'Senior HR Manager', '18', '160000']\n",
      "['29', 'Male', \"Bachelor's\", 'Junior Business Analyst', '1.5', '40000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Product Manager', '10', '120000']\n",
      "['46', 'Male', 'PhD', 'Senior Data Analyst', '19', '150000']\n",
      "['34', 'Female', \"Bachelor's\", 'Junior Marketing Analyst', '6', '70000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Operations Manager', '8', '95000']\n",
      "['49', 'Female', \"Master's\", 'Director of Marketing', '21', '180000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior Financial Analyst', '3', '50000']\n",
      "['41', 'Female', \"Bachelor's\", 'Senior Project Coordinator', '11', '95000']\n",
      "['47', 'Male', \"Master's\", 'Director of Operations', '20', '170000']\n",
      "['30', 'Female', \"Bachelor's\", 'Junior Marketing Coordinator', '2', '40000']\n",
      "['38', 'Male', \"Master's\", 'Senior IT Consultant', '9', '110000']\n",
      "['45', 'Female', 'PhD', 'Senior Product Designer', '15', '150000']\n",
      "['28', 'Male', \"Bachelor's\", 'Junior Business Development Associate', '2', '40000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Marketing Analyst', '8', '85000']\n",
      "['44', 'Male', \"Bachelor's\", 'Senior Software Engineer', '14', '130000']\n",
      "['34', 'Female', \"Master's\", 'Senior Financial Advisor', '6', '100000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Project Coordinator', '9', '95000']\n",
      "['50', 'Female', 'PhD', 'Director of Operations', '22', '180000']\n",
      "['29', 'Male', \"Bachelor's\", 'Junior Business Operations Analyst', '1.5', '350']\n",
      "['', '', '', '', '', '']\n",
      "['37', 'Female', \"Bachelor's\", 'Senior Financial Manager', '10', '120000']\n",
      "['46', 'Male', 'PhD', 'Senior Data Scientist', '18', '160000']\n",
      "['31', 'Female', \"Bachelor's\", 'Junior Marketing Coordinator', '3', '50000']\n",
      "['42', 'Male', \"Bachelor's\", 'Senior Operations Manager', '12', '110000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Sales Representative', '1.5', '40000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Marketing Specialist', '8', '95000']\n",
      "['44', 'Female', \"Master's\", 'Senior HR Specialist', '15', '140000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Operations Manager', '4', '60000']\n",
      "['39', 'Female', \"Bachelor's\", 'Senior Marketing Coordinator', '9', '110000']\n",
      "['45', 'Male', 'PhD', 'Senior Data Engineer', '16', '150000']\n",
      "['32', 'Female', \"Bachelor's\", 'Junior Marketing Manager', '4', '60000']\n",
      "['37', 'Male', \"Bachelor's\", 'Senior Financial Analyst', '8', '90000']\n",
      "['47', 'Female', \"Master's\", 'Director of Marketing', '20', '180000']\n",
      "['30', 'Male', \"Bachelor's\", 'Junior Business Analyst', '2', '40000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Project Manager', '9', '120000']\n",
      "['46', 'Male', 'PhD', 'Senior Data Analyst', '17', '160000']\n",
      "['34', 'Female', \"Bachelor's\", 'Junior Financial Analyst', '5', '70000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Product Manager', '8', '95000']\n",
      "['49', 'Female', \"Master's\", 'Director of Operations', '21', '180000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior Operations Analyst', '3', '50000']\n",
      "['41', 'Female', \"Bachelor's\", 'Senior Project Coordinator', '11', '95000']\n",
      "['47', 'Male', \"Master's\", 'Director of Marketing', '19', '170000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Business Development Associate', '1.5', '35000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Financial Manager', '9', '100000']\n",
      "['44', 'Female', 'PhD', 'Senior Product Designer', '15', '150000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Business Analyst', '4', '60000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Marketing Analyst', '8', '85000']\n",
      "['44', 'Male', \"Bachelor's\", 'Senior Software Engineer', '13', '130000']\n",
      "['32', 'Male', \"Bachelor's\", 'Junior Product Manager', '4', '65000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Business Analyst', '10', '110000']\n",
      "['49', 'Male', 'PhD', 'Director of Operations', '21', '180000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Marketing Specialist', '2', '40000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Business Development Manager', '7', '90000']\n",
      "['45', 'Female', \"Master's\", 'Senior HR Manager', '14', '140000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Financial Analyst', '4', '60000']\n",
      "['40', 'Female', \"Bachelor's\", 'Senior Marketing Manager', '12', '130000']\n",
      "['44', 'Male', 'PhD', 'Senior Data Scientist', '16', '160000']\n",
      "['30', 'Female', \"Bachelor's\", 'Junior Operations Coordinator', '2', '40000']\n",
      "['37', 'Male', \"Bachelor's\", 'Senior Marketing Analyst', '9', '100000']\n",
      "['48', 'Female', \"Master's\", 'Director of HR', '20', '180000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior Project Manager', '3', '55000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Operations Coordinator', '9', '120000']\n",
      "['45', 'Male', 'PhD', 'Senior Data Engineer', '16', '150000']\n",
      "['33', 'Female', \"Bachelor's\", 'Junior Marketing Manager', '5', '70000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Business Analyst', '8', '95000']\n",
      "['49', 'Female', \"Master's\", 'Director of Marketing', '21', '180000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior Operations Analyst', '3', '50000']\n",
      "['42', 'Female', \"Bachelor's\", 'Senior Project Manager', '12', '120000']\n",
      "['47', 'Male', \"Master's\", 'Director of Marketing', '19', '170000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Business Development Associate', '1.5', '35000']\n",
      "['35', 'Male', \"Bachelor's\", 'Senior Financial Manager', '9', '100000']\n",
      "['44', 'Female', 'PhD', 'Senior Product Designer', '15', '150000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Business Analyst', '4', '60000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Marketing Analyst', '8', '85000']\n",
      "['44', 'Male', \"Bachelor's\", 'Senior Software Engineer', '13', '130000']\n",
      "['34', 'Female', \"Master's\", 'Senior Financial Advisor', '6', '80000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Marketing Specialist', '8', '95000']\n",
      "['30', 'Female', \"Bachelor's\", 'Junior HR Coordinator', '2', '40000']\n",
      "['37', 'Male', \"Bachelor's\", 'Senior Business Development Manager', '10', '120000']\n",
      "['45', 'Female', \"Master's\", 'Senior Marketing Manager', '16', '160000']\n",
      "['32', 'Male', \"Bachelor's\", 'Junior Financial Advisor', '4', '65000']\n",
      "['39', 'Female', \"Bachelor's\", 'Senior Project Manager', '12', '130000']\n",
      "['47', 'Male', 'PhD', 'Director of Engineering', '20', '180000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Marketing Analyst', '2', '40000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Operations Manager', '9', '100000']\n",
      "['43', 'Female', 'PhD', 'Senior Data Scientist', '15', '150000']\n",
      "['32', 'Male', \"Bachelor's\", 'Junior Marketing Coordinator', '3', '55000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Business Analyst', '10', '110000']\n",
      "['48', 'Male', \"Master's\", 'Director of Marketing', '21', '180000']\n",
      "['31', 'Female', \"Bachelor's\", 'Junior Business Development Associate', '3', '50000']\n",
      "['40', 'Male', \"Bachelor's\", 'Senior Financial Analyst', '12', '130000']\n",
      "['45', 'Female', 'PhD', 'Senior UX Designer', '16', '160000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Product Manager', '4', '60000']\n",
      "['36', 'Female', \"Bachelor's\", 'Senior Marketing Manager', '8', '95000']\n",
      "['47', 'Male', \"Master's\", 'Director of Operations', '19', '170000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Project Manager', '2', '40000']\n",
      "['34', 'Male', \"Bachelor's\", 'Senior Operations Coordinator', '7', '90000']\n",
      "['44', 'Female', 'PhD', 'Senior Business Analyst', '15', '150000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Marketing Specialist', '5', '70000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Financial Manager', '8', '90000']\n",
      "['43', 'Male', \"Master's\", 'Director of Marketing', '18', '170000']\n",
      "['31', 'Female', \"Bachelor's\", 'Junior Financial Analyst', '3', '50000']\n",
      "['41', 'Male', \"Bachelor's\", 'Senior Product Manager', '14', '150000']\n",
      "['44', 'Female', 'PhD', 'Senior Data Engineer', '16', '160000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Business Analyst', '4', '60000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Marketing Analyst', '8', '85000']\n",
      "['45', 'Male', \"Master's\", 'Director of Engineering', '19', '180000']\n",
      "['28', 'Female', \"Bachelor's\", 'Junior Operations Manager', '1', '35000']\n",
      "['36', 'Male', \"Bachelor's\", 'Senior Business Development Manager', '8', '110000']\n",
      "['44', 'Female', 'PhD', 'Senior Data Scientist', '16', '160000']\n",
      "['31', 'Male', \"Bachelor's\", 'Junior Marketing Coordinator', '3', '55000']\n",
      "['38', 'Female', \"Bachelor's\", 'Senior Business Analyst', '10', '110000']\n",
      "['48', 'Male', \"Master's\", 'Director of Marketing', '21', '180000']\n",
      "['31', 'Female', \"Bachelor's\", 'Junior Business Development Associate', '3', '50000']\n",
      "['40', 'Male', \"Bachelor's\", 'Senior Financial Analyst', '12', '130000']\n",
      "['45', 'Female', 'PhD', 'Senior UX Designer', '16', '160000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Product Manager', '4', '60000']\n",
      "['36', 'Female', \"Bachelor's\", 'Senior Marketing Manager', '8', '95000']\n",
      "['47', 'Male', \"Master's\", 'Director of Operations', '19', '170000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Project Manager', '2', '40000']\n",
      "['34', 'Male', \"Bachelor's\", 'Senior Operations Coordinator', '7', '90000']\n",
      "['44', 'Female', 'PhD', 'Senior Business Analyst', '15', '150000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Marketing Specialist', '5', '70000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Financial Manager', '8', '90000']\n",
      "['43', 'Male', \"Master's\", 'Director of Marketing', '18', '170000']\n",
      "['31', 'Female', \"Bachelor's\", 'Junior Financial Analyst', '3', '50000']\n",
      "['41', 'Male', \"Bachelor's\", 'Senior Product Manager', '14', '150000']\n",
      "['44', 'Female', 'PhD', 'Senior Data Engineer', '16', '160000']\n",
      "['33', 'Male', \"Bachelor's\", 'Junior Business Analyst', '4', '60000']\n",
      "['35', 'Female', \"Bachelor's\", 'Senior Marketing Analyst', '8', '85000']\n",
      "['43', 'Male', \"Master's\", 'Director of Operations', '19', '170000']\n",
      "['29', 'Female', \"Bachelor's\", 'Junior Project Manager', '2', '40000']\n",
      "['34', 'Male', \"Bachelor's\", 'Senior Operations Coordinator', '7', '90000']\n",
      "['44', 'Female', 'PhD', 'Senior Business Analyst', '15', '150000']\n"
     ]
    }
   ],
   "source": [
    "#  EMPLOYEE DETAILES\n",
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/Salary Data.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        print(line)\n",
    "\n",
    "                    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "32 Software Engineer\n",
      "32 Account Manager\n",
      "32 Senior Software Engineer\n",
      "32 Senior Business Analyst\n",
      "32 Marketing Coordinator\n",
      "32 Junior Financial Analyst\n",
      "32 Junior Account Manager\n",
      "32 Junior Sales Representative\n",
      "32 Junior Marketing Manager\n",
      "32 Junior Product Manager\n",
      "32 Junior Financial Advisor\n",
      "32 Junior Marketing Coordinator\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/Salary Data.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        if line[0] == \"32\":           # it picks employee age equale to 32,\n",
    "            print(line[0],line[3])    #[3] JOB TITTL"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The employee who takes above 50000: salary with there age"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Age Salary\n",
      "32 90000\n",
      "28 65000\n",
      "36 60000\n",
      "29 55000\n",
      "31 80000\n",
      "29 75000\n",
      "35 65000\n",
      "33 90000\n",
      "34 80000\n",
      "36 60000\n",
      "33 90000\n",
      "31 55000\n",
      "29 75000\n",
      "39 65000\n",
      "35 60000\n",
      "34 80000\n",
      "30 60000\n",
      "32 75000\n",
      "33 85000\n",
      "40 60000\n",
      "36 95000\n",
      "27 65000\n",
      "30 55000\n",
      "40 80000\n",
      "38 90000\n",
      "34 90000\n",
      "33 65000\n",
      "39 70000\n",
      "37 95000\n",
      "30 55000\n",
      "36 70000\n",
      "41 80000\n",
      "34 95000\n",
      "40 80000\n",
      "31 55000\n",
      "33 75000\n",
      "39 65000\n",
      "38 90000\n",
      "35 95000\n",
      "39 80000\n",
      "36 60000\n",
      "37 95000\n",
      "32 90000\n",
      "31 95000\n",
      "40 65000\n",
      "38 80000\n",
      "37 95000\n",
      "39 55000\n",
      "36 60000\n",
      "34 90000\n",
      "31 60000\n",
      "38 80000\n",
      "37 95000\n",
      "39 90000\n",
      "35 80000\n",
      "35 85000\n",
      "38 80000\n",
      "36 85000\n",
      "33 95000\n",
      "39 95000\n",
      "34 95000\n",
      "41 90000\n",
      "32 55000\n",
      "36 90000\n",
      "35 85000\n",
      "35 95000\n",
      "33 70000\n",
      "35 85000\n",
      "33 70000\n",
      "34 70000\n",
      "36 95000\n",
      "41 95000\n",
      "35 85000\n",
      "35 95000\n",
      "36 95000\n",
      "33 60000\n",
      "32 60000\n",
      "37 90000\n",
      "34 70000\n",
      "36 95000\n",
      "41 95000\n",
      "33 60000\n",
      "35 85000\n",
      "32 65000\n",
      "35 90000\n",
      "33 60000\n",
      "31 55000\n",
      "33 70000\n",
      "36 95000\n",
      "33 60000\n",
      "35 85000\n",
      "34 80000\n",
      "36 95000\n",
      "32 65000\n",
      "32 55000\n",
      "33 60000\n",
      "36 95000\n",
      "34 90000\n",
      "33 70000\n",
      "35 90000\n",
      "33 60000\n",
      "35 85000\n",
      "31 55000\n",
      "33 60000\n",
      "36 95000\n",
      "34 90000\n",
      "33 70000\n",
      "35 90000\n",
      "33 60000\n",
      "35 85000\n",
      "34 90000\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/Salary Data.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        if line[5]>str(50000):\n",
    "            print(line[0],line[5])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "we can check the experience employee"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Years of Experience\n",
      "5\n",
      "7\n",
      "6\n",
      "7\n",
      "5\n",
      "9\n",
      "6\n",
      "7\n",
      "5\n",
      "8\n",
      "5\n",
      "7\n",
      "9\n",
      "7\n",
      "5\n",
      "8\n",
      "6\n",
      "6\n",
      "8\n",
      "6\n",
      "7\n",
      "5\n",
      "8\n",
      "5\n",
      "7\n",
      "9\n",
      "6\n",
      "6\n",
      "5\n",
      "9\n",
      "8\n",
      "7\n",
      "5\n",
      "8\n",
      "9\n",
      "5\n",
      "7\n",
      "7\n",
      "9\n",
      "7\n",
      "9\n",
      "8\n",
      "6\n",
      "9\n",
      "7\n",
      "5\n",
      "9\n",
      "7\n",
      "9\n",
      "8\n",
      "6\n",
      "9\n",
      "7\n",
      "5\n",
      "9\n",
      "8\n",
      "9\n",
      "5\n",
      "6\n",
      "8\n",
      "9\n",
      "8\n",
      "6\n",
      "9\n",
      "8\n",
      "9\n",
      "8\n",
      "9\n",
      "5\n",
      "8\n",
      "9\n",
      "8\n",
      "7\n",
      "9\n",
      "9\n",
      "5\n",
      "8\n",
      "9\n",
      "8\n",
      "6\n",
      "8\n",
      "9\n",
      "8\n",
      "7\n",
      "5\n",
      "8\n",
      "8\n",
      "8\n",
      "8\n",
      "7\n",
      "5\n",
      "8\n",
      "8\n",
      "7\n"
     ]
    }
   ],
   "source": [
    "import csv\n",
    "\n",
    "with open(\"C:/Users/91843/Desktop/GPYTHON/Excel Dataset for CSV/Salary Data.csv\",\"r\") as file:\n",
    "    data=csv.reader(file)\n",
    "    \n",
    "    for line in data:\n",
    "        if line[4]>=str(5):\n",
    "            print(line[4])"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}