autoscrap web1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "1d32c7ef",
   "metadata": {},
   "outputs": [],
   "source": [
    "from autoscraper import AutoScraper"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "b0c2c48f",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Vitaan', 'FTX', 'AUSK', 'Swagr', 'Allen Solly', 'Winget', 'COMBRAIDED', 'LEE TEX', 'FUBAR', 'MINIMAMA', 'STONEBERG', 'Yazole', 'VeBNoR', 'TRIPR', 'XYXX', 'CYPHUS', 'Van Heusen Academy', 'VAN HEUSEN', 'Lux Venus', 'Smartees', 'Little Port', 'DIMMY', 'VTEXX', 'Henzila', 'HICODE', '3BROS', 'Whippet', 'FIBERMILL', 'MXSOX', 'COMFIT', 'Pack of 2 Men Printed Black, Beige Track Pants', 'Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt', 'Men Striped Round Neck Cotton Blend Blue, Black T-Shirt', 'Men Solid Ankle Length', 'Men Solid Polo Neck Pure Cotton Black T-Shirt', 'Men & Women Self Design Ankle Length', 'Men Slim Fit Black Lycra Blend Trousers', 'Women Regular Fit Pink Cotton Blend Trousers', 'Men Slim Fit Light Green Cotton Blend Trousers', 'Men & Women Solid Ankle Length', 'Short For Baby Boys & Baby Girls Casual Printed Cotton Blend', 'Men Slim Fit Solid Spread Collar Formal Shirt', 'Men Solid Black Track Pants', 'Men & Women Solid Peds/Footie/No-Show', 'Pack of 2 Men Solid Black, Grey Track Pants', 'Pack of 2 Men Printed Dark Blue, Black Track Pants', 'Pack of 2 Dualist Intellisoft Micro Modal Color Blocked Men Brief', 'Men Regular Fit Black Cotton Blend Trousers', 'Pack of 2 Men Printed Black, Grey Track Pants', 'Men Full Sleeve Solid Sweatshirt', 'Men Slim Fit Black Viscose Rayon Trousers', 'Men Striped Round Neck Cotton Blend Light Blue, White T-Shirt', 'Pack of 4 Men Vest', 'Men Printed, Typography Round Neck Cotton Blend Black T-Shirt', 'Unisex Color Block Low Cut', 'Pack of 2 Men Solid Cotton Blend Straight Kurta', 'Pack of 2 Solid Men Black, Grey Sports Shorts', 'Men Regular Fit Solid Spread Collar Formal Shirt', 'Men & Women Solid Low Cut', 'Men Solid Polo Neck Cotton Blend (220 gsm) Green T-Shirt', 'Men Regular Fit Printed Spread Collar Casual Shirt', 'Women Regular Fit Black Cotton Blend Trousers', 'Men Striped Ankle Length', 'Men Slim Mid Rise White Jeans', 'Men Slim Fit Silver Lycra Blend Trousers', '₹389', '₹469', '₹199', '₹599', '₹179', '₹379', '₹299', '₹499', '₹160', '₹398', '₹396', '₹292', '₹159', '₹399', '₹629', '₹419', '₹759', '₹1,429', '₹256', '₹91', '₹730', '₹349', '₹217', '₹391', '₹289', '₹229', '₹369']\n"
     ]
    }
   ],
   "source": [
    "for i in range(1,20):\n",
    "    url = 'https://www.flipkart.com/clothing-and-accessories/pr?sid=clo&otracker=categorytree'+str(i)\n",
    "\n",
    "\n",
    "    wanted_list = [\"FTX\",\"Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt\",\"₹469\"]\n",
    "\n",
    "    scraper = AutoScraper()\n",
    "    result = scraper.build(url,wanted_list)\n",
    "print(result)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "7514eabd",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'rule_fcfu': ['Vitaan',\n",
       "  'FTX',\n",
       "  'AUSK',\n",
       "  'Swagr',\n",
       "  'Allen Solly',\n",
       "  'Winget',\n",
       "  'COMBRAIDED',\n",
       "  'LEE TEX',\n",
       "  'FUBAR',\n",
       "  'Winget',\n",
       "  'STONEBERG',\n",
       "  'FTX',\n",
       "  'Yazole',\n",
       "  'Winget',\n",
       "  'VeBNoR',\n",
       "  'TRIPR',\n",
       "  'XYXX',\n",
       "  'Van Heusen Academy',\n",
       "  'CYPHUS',\n",
       "  'VeBNoR',\n",
       "  'VAN HEUSEN',\n",
       "  'DIMMY',\n",
       "  'AUSK',\n",
       "  'Lux Venus',\n",
       "  'Smartees',\n",
       "  'Little Port',\n",
       "  'Vitaan',\n",
       "  'HICODE',\n",
       "  'VTEXX',\n",
       "  'Henzila',\n",
       "  'STONEBERG',\n",
       "  'FIBERMILL',\n",
       "  '3BROS',\n",
       "  'VeBNoR',\n",
       "  'LEE TEX',\n",
       "  'Whippet',\n",
       "  'MXSOX',\n",
       "  'CHALODIA',\n",
       "  'COMFIT',\n",
       "  'COMBRAIDED'],\n",
       " 'rule_7f41': ['Vitaan',\n",
       "  'FTX',\n",
       "  'AUSK',\n",
       "  'Swagr',\n",
       "  'Allen Solly',\n",
       "  'Winget',\n",
       "  'COMBRAIDED',\n",
       "  'LEE TEX',\n",
       "  'FUBAR',\n",
       "  'Winget',\n",
       "  'STONEBERG',\n",
       "  'FTX',\n",
       "  'Yazole',\n",
       "  'Winget',\n",
       "  'VeBNoR',\n",
       "  'TRIPR',\n",
       "  'XYXX',\n",
       "  'Van Heusen Academy',\n",
       "  'CYPHUS',\n",
       "  'VeBNoR',\n",
       "  'VAN HEUSEN',\n",
       "  'DIMMY',\n",
       "  'AUSK',\n",
       "  'Lux Venus',\n",
       "  'Smartees',\n",
       "  'Little Port',\n",
       "  'Vitaan',\n",
       "  'HICODE',\n",
       "  'VTEXX',\n",
       "  'Henzila',\n",
       "  'STONEBERG',\n",
       "  'FIBERMILL',\n",
       "  '3BROS',\n",
       "  'VeBNoR',\n",
       "  'LEE TEX',\n",
       "  'Whippet',\n",
       "  'MXSOX',\n",
       "  'CHALODIA',\n",
       "  'COMFIT',\n",
       "  'COMBRAIDED'],\n",
       " 'rule_ihv2': ['Pack of 2 Men Printed Black, Beige Track Pants',\n",
       "  'Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt',\n",
       "  'Men Striped Round Neck Cotton Blend Blue, Black T-Shirt',\n",
       "  'Men Solid Ankle Length',\n",
       "  'Men Solid Polo Neck Pure Cotton Black T-Shirt',\n",
       "  'Men & Women Self Design Ankle Length',\n",
       "  'Men Slim Fit Black Lycra Blend Trousers',\n",
       "  'Women Regular Fit Pink Cotton Blend Trousers',\n",
       "  'Men Slim Fit Light Green Cotton Blend Trousers',\n",
       "  'Men & Women Solid Ankle Length',\n",
       "  'Men Slim Fit Solid Spread Collar Formal Shirt',\n",
       "  'Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt',\n",
       "  'Men Solid Black Track Pants',\n",
       "  'Men & Women Solid Peds/Footie/No-Show',\n",
       "  'Pack of 2 Men Solid Black, Grey Track Pants',\n",
       "  'Pack of 2 Men Printed Dark Blue, Black Track Pants',\n",
       "  'Pack of 2 Dualist Intellisoft Micro Modal Color Blocked Men Brief',\n",
       "  'Men Full Sleeve Solid Sweatshirt',\n",
       "  'Men Regular Fit Black Cotton Blend Trousers',\n",
       "  'Pack of 2 Men Printed Black, Grey Track Pants',\n",
       "  'Men Slim Fit Black Viscose Rayon Trousers',\n",
       "  'Pack of 2 Men Solid Cotton Blend Straight Kurta',\n",
       "  'Men Striped Round Neck Cotton Blend Light Blue, White T-Shirt',\n",
       "  'Pack of 4 Men Vest',\n",
       "  'Men Printed, Typography Round Neck Cotton Blend Black T-Shirt',\n",
       "  'Unisex Color Block Low Cut',\n",
       "  'Pack of 2 Solid Men Black, Grey Sports Shorts',\n",
       "  'Men & Women Solid Low Cut',\n",
       "  'Men Regular Fit Solid Spread Collar Formal Shirt',\n",
       "  'Pack of 2 Men Solid Black, Grey Track Pants',\n",
       "  'Men Slim Fit Solid Spread Collar Formal Shirt',\n",
       "  'Men Regular Fit Solid Spread Collar Formal Shirt',\n",
       "  'Men Solid Polo Neck Cotton Blend (220 gsm) Green T-Shirt',\n",
       "  'Men Regular Fit Printed Spread Collar Casual Shirt',\n",
       "  'Women Regular Fit Black Cotton Blend Trousers',\n",
       "  'Men & Women Solid Ankle Length',\n",
       "  'Men Striped Ankle Length',\n",
       "  'Women Regular Fit Black, White Cotton Blend Trousers',\n",
       "  'Men Slim Mid Rise White Jeans',\n",
       "  'Men Slim Fit Silver Lycra Blend Trousers'],\n",
       " 'rule_vqe9': ['Pack of 2 Men Printed Black, Beige Track Pants',\n",
       "  'Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt',\n",
       "  'Men Striped Round Neck Cotton Blend Blue, Black T-Shirt',\n",
       "  'Men Solid Ankle Length',\n",
       "  'Men Solid Polo Neck Pure Cotton Black T-Shirt',\n",
       "  'Men & Women Self Design Ankle Length',\n",
       "  'Men Slim Fit Black Lycra Blend Trousers',\n",
       "  'Women Regular Fit Pink Cotton Blend Trousers',\n",
       "  'Men Slim Fit Light Green Cotton Blend Trousers',\n",
       "  'Men & Women Solid Ankle Length',\n",
       "  'Men Slim Fit Solid Spread Collar Formal Shirt',\n",
       "  'Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt',\n",
       "  'Men Solid Black Track Pants',\n",
       "  'Men & Women Solid Peds/Footie/No-Show',\n",
       "  'Pack of 2 Men Solid Black, Grey Track Pants',\n",
       "  'Pack of 2 Men Printed Dark Blue, Black Track Pants',\n",
       "  'Pack of 2 Dualist Intellisoft Micro Modal Color Blocked Men Brief',\n",
       "  'Men Full Sleeve Solid Sweatshirt',\n",
       "  'Men Regular Fit Black Cotton Blend Trousers',\n",
       "  'Pack of 2 Men Printed Black, Grey Track Pants',\n",
       "  'Men Slim Fit Black Viscose Rayon Trousers',\n",
       "  'Pack of 2 Men Solid Cotton Blend Straight Kurta',\n",
       "  'Men Striped Round Neck Cotton Blend Light Blue, White T-Shirt',\n",
       "  'Pack of 4 Men Vest',\n",
       "  'Men Printed, Typography Round Neck Cotton Blend Black T-Shirt',\n",
       "  'Unisex Color Block Low Cut',\n",
       "  'Pack of 2 Solid Men Black, Grey Sports Shorts',\n",
       "  'Men & Women Solid Low Cut',\n",
       "  'Men Regular Fit Solid Spread Collar Formal Shirt',\n",
       "  'Pack of 2 Men Solid Black, Grey Track Pants',\n",
       "  'Men Slim Fit Solid Spread Collar Formal Shirt',\n",
       "  'Men Regular Fit Solid Spread Collar Formal Shirt',\n",
       "  'Men Solid Polo Neck Cotton Blend (220 gsm) Green T-Shirt',\n",
       "  'Men Regular Fit Printed Spread Collar Casual Shirt',\n",
       "  'Women Regular Fit Black Cotton Blend Trousers',\n",
       "  'Men & Women Solid Ankle Length',\n",
       "  'Men Striped Ankle Length',\n",
       "  'Women Regular Fit Black, White Cotton Blend Trousers',\n",
       "  'Men Slim Mid Rise White Jeans',\n",
       "  'Men Slim Fit Silver Lycra Blend Trousers'],\n",
       " 'rule_uody': ['₹389',\n",
       "  '₹469',\n",
       "  '₹199',\n",
       "  '₹199',\n",
       "  '₹599',\n",
       "  '₹179',\n",
       "  '₹379',\n",
       "  '₹299',\n",
       "  '₹499',\n",
       "  '₹160',\n",
       "  '₹396',\n",
       "  '₹469',\n",
       "  '₹292',\n",
       "  '₹159',\n",
       "  '₹399',\n",
       "  '₹399',\n",
       "  '₹629',\n",
       "  '₹759',\n",
       "  '₹419',\n",
       "  '₹399',\n",
       "  '₹1,429',\n",
       "  '₹730',\n",
       "  '₹199',\n",
       "  '₹256',\n",
       "  '₹179',\n",
       "  '₹91',\n",
       "  '₹349',\n",
       "  '₹217',\n",
       "  '₹299',\n",
       "  '₹398',\n",
       "  '₹391',\n",
       "  '₹389',\n",
       "  '₹299',\n",
       "  '₹289',\n",
       "  '₹299',\n",
       "  '₹160',\n",
       "  '₹229',\n",
       "  '₹599',\n",
       "  '₹369',\n",
       "  '₹379'],\n",
       " 'rule_h82s': ['₹389',\n",
       "  '₹469',\n",
       "  '₹199',\n",
       "  '₹199',\n",
       "  '₹599',\n",
       "  '₹179',\n",
       "  '₹379',\n",
       "  '₹299',\n",
       "  '₹499',\n",
       "  '₹160',\n",
       "  '₹396',\n",
       "  '₹469',\n",
       "  '₹292',\n",
       "  '₹159',\n",
       "  '₹399',\n",
       "  '₹399',\n",
       "  '₹629',\n",
       "  '₹759',\n",
       "  '₹419',\n",
       "  '₹399',\n",
       "  '₹1,429',\n",
       "  '₹730',\n",
       "  '₹199',\n",
       "  '₹256',\n",
       "  '₹179',\n",
       "  '₹91',\n",
       "  '₹349',\n",
       "  '₹217',\n",
       "  '₹299',\n",
       "  '₹398',\n",
       "  '₹391',\n",
       "  '₹389',\n",
       "  '₹299',\n",
       "  '₹289',\n",
       "  '₹299',\n",
       "  '₹160',\n",
       "  '₹229',\n",
       "  '₹599',\n",
       "  '₹369',\n",
       "  '₹379']}"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "scraper.get_result_similar(url,grouped=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "60a96648",
   "metadata": {},
   "outputs": [],
   "source": [
    "scraper.set_rule_aliases({'rule_fcfu':'brand','rule_ihv2':'title','rule_uody':'price'})\n",
    "scraper.keep_rules(['rule_fcfu','rule_ihv2','rule_uody'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "2352983a",
   "metadata": {},
   "outputs": [],
   "source": [
    "results=scraper.get_result_similar(url,group_by_alias=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "841c5196",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['₹469',\n",
       " '₹469',\n",
       " '₹199',\n",
       " '₹199',\n",
       " '₹599',\n",
       " '₹179',\n",
       " '₹379',\n",
       " '₹299',\n",
       " '₹499',\n",
       " '₹160',\n",
       " '₹398',\n",
       " '₹469',\n",
       " '₹292',\n",
       " '₹159',\n",
       " '₹399',\n",
       " '₹399',\n",
       " '₹730',\n",
       " '₹629',\n",
       " '₹419',\n",
       " '₹399',\n",
       " '₹759',\n",
       " '₹1,429',\n",
       " '₹199',\n",
       " '₹256',\n",
       " '₹179',\n",
       " '₹91',\n",
       " '₹349',\n",
       " '₹217',\n",
       " '₹299',\n",
       " '₹398',\n",
       " '₹519',\n",
       " '₹389',\n",
       " '₹299',\n",
       " '₹289',\n",
       " '₹299',\n",
       " '₹160',\n",
       " '₹229',\n",
       " '₹599',\n",
       " '₹369',\n",
       " '₹379']"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results['price']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "229e1013",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Pack of 4 Men Solid Round Neck Polyester Light Blue, Blue, Black, Grey T-Shirt',\n",
       " 'Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt',\n",
       " 'Men Striped Round Neck Cotton Blend Blue, Black T-Shirt',\n",
       " 'Men Solid Ankle Length',\n",
       " 'Men Solid Polo Neck Pure Cotton Black T-Shirt',\n",
       " 'Men & Women Self Design Ankle Length',\n",
       " 'Men Slim Fit Black Lycra Blend Trousers',\n",
       " 'Women Regular Fit Pink Cotton Blend Trousers',\n",
       " 'Men Slim Fit Light Green Cotton Blend Trousers',\n",
       " 'Men & Women Solid Ankle Length',\n",
       " 'Short For Baby Boys & Baby Girls Casual Printed Cotton Blend',\n",
       " 'Pack of 4 Men Solid Round Neck Polyester Multicolor T-Shirt',\n",
       " 'Men Solid Black Track Pants',\n",
       " 'Men & Women Solid Peds/Footie/No-Show',\n",
       " 'Pack of 2 Men Solid Black, Grey Track Pants',\n",
       " 'Pack of 2 Men Printed Dark Blue, Black Track Pants',\n",
       " 'Pack of 2 Men Solid Cotton Blend Straight Kurta',\n",
       " 'Pack of 2 Dualist Intellisoft Micro Modal Color Blocked Men Brief',\n",
       " 'Men Regular Fit Black Cotton Blend Trousers',\n",
       " 'Pack of 2 Men Printed Black, Grey Track Pants',\n",
       " 'Men Full Sleeve Solid Sweatshirt',\n",
       " 'Men Slim Fit Black Viscose Rayon Trousers',\n",
       " 'Men Striped Round Neck Cotton Blend Light Blue, White T-Shirt',\n",
       " 'Pack of 4 Men Vest',\n",
       " 'Men Printed, Typography Round Neck Cotton Blend Black T-Shirt',\n",
       " 'Unisex Color Block Low Cut',\n",
       " 'Pack of 2 Solid Men Black, Grey Sports Shorts',\n",
       " 'Men & Women Solid Low Cut',\n",
       " 'Men Regular Fit Solid Spread Collar Formal Shirt',\n",
       " 'Pack of 2 Men Solid Black, Grey Track Pants',\n",
       " 'Short For Boys & Girls Casual Printed Cotton Blend',\n",
       " 'Men Regular Fit Solid Spread Collar Formal Shirt',\n",
       " 'Men Solid Polo Neck Cotton Blend (220 gsm) Green T-Shirt',\n",
       " 'Men Regular Fit Printed Spread Collar Casual Shirt',\n",
       " 'Women Regular Fit Black Cotton Blend Trousers',\n",
       " 'Men & Women Solid Ankle Length',\n",
       " 'Men Striped Ankle Length',\n",
       " 'Women Regular Fit Black, White Cotton Blend Trousers',\n",
       " 'Men Slim Mid Rise White Jeans',\n",
       " 'Men Slim Fit Silver Lycra Blend Trousers']"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results['title']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d99efcb9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['FTX',\n",
       " 'FTX',\n",
       " 'AUSK',\n",
       " 'Swagr',\n",
       " 'Allen Solly',\n",
       " 'Winget',\n",
       " 'COMBRAIDED',\n",
       " 'LEE TEX',\n",
       " 'FUBAR',\n",
       " 'Winget',\n",
       " 'MINIMAMA',\n",
       " 'FTX',\n",
       " 'Yazole',\n",
       " 'Winget',\n",
       " 'VeBNoR',\n",
       " 'TRIPR',\n",
       " 'DIMMY',\n",
       " 'XYXX',\n",
       " 'CYPHUS',\n",
       " 'VeBNoR',\n",
       " 'Van Heusen Academy',\n",
       " 'VAN HEUSEN',\n",
       " 'AUSK',\n",
       " 'Lux Venus',\n",
       " 'Smartees',\n",
       " 'Little Port',\n",
       " 'Vitaan',\n",
       " 'HICODE',\n",
       " 'VTEXX',\n",
       " 'Henzila',\n",
       " 'x2o',\n",
       " 'FIBERMILL',\n",
       " '3BROS',\n",
       " 'VeBNoR',\n",
       " 'LEE TEX',\n",
       " 'Whippet',\n",
       " 'MXSOX',\n",
       " 'CHALODIA',\n",
       " 'COMFIT',\n",
       " 'COMBRAIDED']"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "results['brand']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "92395c01",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "cb06bbdb",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\HP\\anaconda3\\lib\\site-packages\\numpy\\_distributor_init.py:30: UserWarning: loaded more than 1 DLL from .libs:\n",
      "C:\\Users\\HP\\anaconda3\\lib\\site-packages\\numpy\\.libs\\libopenblas.fb5ae2tyxyh2ijrdkgdgq3xbklktf43h.gfortran-win_amd64.dll\n",
      "C:\\Users\\HP\\anaconda3\\lib\\site-packages\\numpy\\.libs\\libopenblas.PYQHXLVVQ7VESDPUVUADXEVJOBGHJPAY.gfortran-win_amd64.dll\n",
      "C:\\Users\\HP\\anaconda3\\lib\\site-packages\\numpy\\.libs\\libopenblas.WCDJNK7YVMPZQ2ME2ZZHJJRJ3JIKNDB7.gfortran-win_amd64.dll\n",
      "  warnings.warn(\"loaded more than 1 DLL from .libs:\"\n"
     ]
    }
   ],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "90601e9e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "33d23f68",
   "metadata": {},
   "outputs": [],
   "source": [
    "titles = results['title']\n",
    "prices = results['price']\n",
    "brand =results['brand']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "855ab46e",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Create a DataFrame from the scraped data\n",
    "df = pd.DataFrame({\n",
    "    \"Title\": titles,\n",
    "    \"Price\": prices,\n",
    "    \"Description\": brand\n",
    "})"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "bc8339b3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Title</th>\n",
       "      <th>Price</th>\n",
       "      <th>Description</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Pack of 4 Men Solid Round Neck Polyester Light...</td>\n",
       "      <td>₹469</td>\n",
       "      <td>FTX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Pack of 4 Men Solid Round Neck Polyester Multi...</td>\n",
       "      <td>₹469</td>\n",
       "      <td>FTX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Men Striped Round Neck Cotton Blend Blue, Blac...</td>\n",
       "      <td>₹199</td>\n",
       "      <td>AUSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Men Solid Ankle Length</td>\n",
       "      <td>₹199</td>\n",
       "      <td>Swagr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Men Solid Polo Neck Pure Cotton Black T-Shirt</td>\n",
       "      <td>₹599</td>\n",
       "      <td>Allen Solly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Men &amp; Women Self Design Ankle Length</td>\n",
       "      <td>₹179</td>\n",
       "      <td>Winget</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Men Slim Fit Black Lycra Blend Trousers</td>\n",
       "      <td>₹379</td>\n",
       "      <td>COMBRAIDED</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Women Regular Fit Pink Cotton Blend Trousers</td>\n",
       "      <td>₹299</td>\n",
       "      <td>LEE TEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Men Slim Fit Light Green Cotton Blend Trousers</td>\n",
       "      <td>₹499</td>\n",
       "      <td>FUBAR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Men &amp; Women Solid Ankle Length</td>\n",
       "      <td>₹160</td>\n",
       "      <td>Winget</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Short For Baby Boys &amp; Baby Girls Casual Printe...</td>\n",
       "      <td>₹398</td>\n",
       "      <td>MINIMAMA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Pack of 4 Men Solid Round Neck Polyester Multi...</td>\n",
       "      <td>₹469</td>\n",
       "      <td>FTX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Men Solid Black Track Pants</td>\n",
       "      <td>₹292</td>\n",
       "      <td>Yazole</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Men &amp; Women Solid Peds/Footie/No-Show</td>\n",
       "      <td>₹159</td>\n",
       "      <td>Winget</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Pack of 2 Men Solid Black, Grey Track Pants</td>\n",
       "      <td>₹399</td>\n",
       "      <td>VeBNoR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Pack of 2 Men Printed Dark Blue, Black Track P...</td>\n",
       "      <td>₹399</td>\n",
       "      <td>TRIPR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Pack of 2 Men Solid Cotton Blend Straight Kurta</td>\n",
       "      <td>₹730</td>\n",
       "      <td>DIMMY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Pack of 2 Dualist Intellisoft Micro Modal Colo...</td>\n",
       "      <td>₹629</td>\n",
       "      <td>XYXX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Men Regular Fit Black Cotton Blend Trousers</td>\n",
       "      <td>₹419</td>\n",
       "      <td>CYPHUS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Pack of 2 Men Printed Black, Grey Track Pants</td>\n",
       "      <td>₹399</td>\n",
       "      <td>VeBNoR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Men Full Sleeve Solid Sweatshirt</td>\n",
       "      <td>₹759</td>\n",
       "      <td>Van Heusen Academy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Men Slim Fit Black Viscose Rayon Trousers</td>\n",
       "      <td>₹1,429</td>\n",
       "      <td>VAN HEUSEN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Men Striped Round Neck Cotton Blend Light Blue...</td>\n",
       "      <td>₹199</td>\n",
       "      <td>AUSK</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Pack of 4 Men Vest</td>\n",
       "      <td>₹256</td>\n",
       "      <td>Lux Venus</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Men Printed, Typography Round Neck Cotton Blen...</td>\n",
       "      <td>₹179</td>\n",
       "      <td>Smartees</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Unisex Color Block Low Cut</td>\n",
       "      <td>₹91</td>\n",
       "      <td>Little Port</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Pack of 2 Solid Men Black, Grey Sports Shorts</td>\n",
       "      <td>₹349</td>\n",
       "      <td>Vitaan</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Men &amp; Women Solid Low Cut</td>\n",
       "      <td>₹217</td>\n",
       "      <td>HICODE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Men Regular Fit Solid Spread Collar Formal Shirt</td>\n",
       "      <td>₹299</td>\n",
       "      <td>VTEXX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Pack of 2 Men Solid Black, Grey Track Pants</td>\n",
       "      <td>₹398</td>\n",
       "      <td>Henzila</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Short For Boys &amp; Girls Casual Printed Cotton B...</td>\n",
       "      <td>₹519</td>\n",
       "      <td>x2o</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Men Regular Fit Solid Spread Collar Formal Shirt</td>\n",
       "      <td>₹389</td>\n",
       "      <td>FIBERMILL</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Men Solid Polo Neck Cotton Blend (220 gsm) Gre...</td>\n",
       "      <td>₹299</td>\n",
       "      <td>3BROS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Men Regular Fit Printed Spread Collar Casual S...</td>\n",
       "      <td>₹289</td>\n",
       "      <td>VeBNoR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Women Regular Fit Black Cotton Blend Trousers</td>\n",
       "      <td>₹299</td>\n",
       "      <td>LEE TEX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Men &amp; Women Solid Ankle Length</td>\n",
       "      <td>₹160</td>\n",
       "      <td>Whippet</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Men Striped Ankle Length</td>\n",
       "      <td>₹229</td>\n",
       "      <td>MXSOX</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Women Regular Fit Black, White Cotton Blend Tr...</td>\n",
       "      <td>₹599</td>\n",
       "      <td>CHALODIA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Men Slim Mid Rise White Jeans</td>\n",
       "      <td>₹369</td>\n",
       "      <td>COMFIT</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Men Slim Fit Silver Lycra Blend Trousers</td>\n",
       "      <td>₹379</td>\n",
       "      <td>COMBRAIDED</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Title   Price  \\\n",
       "0   Pack of 4 Men Solid Round Neck Polyester Light...    ₹469   \n",
       "1   Pack of 4 Men Solid Round Neck Polyester Multi...    ₹469   \n",
       "2   Men Striped Round Neck Cotton Blend Blue, Blac...    ₹199   \n",
       "3                              Men Solid Ankle Length    ₹199   \n",
       "4       Men Solid Polo Neck Pure Cotton Black T-Shirt    ₹599   \n",
       "5                Men & Women Self Design Ankle Length    ₹179   \n",
       "6             Men Slim Fit Black Lycra Blend Trousers    ₹379   \n",
       "7        Women Regular Fit Pink Cotton Blend Trousers    ₹299   \n",
       "8      Men Slim Fit Light Green Cotton Blend Trousers    ₹499   \n",
       "9                      Men & Women Solid Ankle Length    ₹160   \n",
       "10  Short For Baby Boys & Baby Girls Casual Printe...    ₹398   \n",
       "11  Pack of 4 Men Solid Round Neck Polyester Multi...    ₹469   \n",
       "12                        Men Solid Black Track Pants    ₹292   \n",
       "13              Men & Women Solid Peds/Footie/No-Show    ₹159   \n",
       "14        Pack of 2 Men Solid Black, Grey Track Pants    ₹399   \n",
       "15  Pack of 2 Men Printed Dark Blue, Black Track P...    ₹399   \n",
       "16    Pack of 2 Men Solid Cotton Blend Straight Kurta    ₹730   \n",
       "17  Pack of 2 Dualist Intellisoft Micro Modal Colo...    ₹629   \n",
       "18        Men Regular Fit Black Cotton Blend Trousers    ₹419   \n",
       "19      Pack of 2 Men Printed Black, Grey Track Pants    ₹399   \n",
       "20                   Men Full Sleeve Solid Sweatshirt    ₹759   \n",
       "21          Men Slim Fit Black Viscose Rayon Trousers  ₹1,429   \n",
       "22  Men Striped Round Neck Cotton Blend Light Blue...    ₹199   \n",
       "23                                 Pack of 4 Men Vest    ₹256   \n",
       "24  Men Printed, Typography Round Neck Cotton Blen...    ₹179   \n",
       "25                         Unisex Color Block Low Cut     ₹91   \n",
       "26      Pack of 2 Solid Men Black, Grey Sports Shorts    ₹349   \n",
       "27                          Men & Women Solid Low Cut    ₹217   \n",
       "28   Men Regular Fit Solid Spread Collar Formal Shirt    ₹299   \n",
       "29        Pack of 2 Men Solid Black, Grey Track Pants    ₹398   \n",
       "30  Short For Boys & Girls Casual Printed Cotton B...    ₹519   \n",
       "31   Men Regular Fit Solid Spread Collar Formal Shirt    ₹389   \n",
       "32  Men Solid Polo Neck Cotton Blend (220 gsm) Gre...    ₹299   \n",
       "33  Men Regular Fit Printed Spread Collar Casual S...    ₹289   \n",
       "34      Women Regular Fit Black Cotton Blend Trousers    ₹299   \n",
       "35                     Men & Women Solid Ankle Length    ₹160   \n",
       "36                           Men Striped Ankle Length    ₹229   \n",
       "37  Women Regular Fit Black, White Cotton Blend Tr...    ₹599   \n",
       "38                      Men Slim Mid Rise White Jeans    ₹369   \n",
       "39           Men Slim Fit Silver Lycra Blend Trousers    ₹379   \n",
       "\n",
       "           Description  \n",
       "0                  FTX  \n",
       "1                  FTX  \n",
       "2                 AUSK  \n",
       "3                Swagr  \n",
       "4          Allen Solly  \n",
       "5               Winget  \n",
       "6           COMBRAIDED  \n",
       "7              LEE TEX  \n",
       "8                FUBAR  \n",
       "9               Winget  \n",
       "10            MINIMAMA  \n",
       "11                 FTX  \n",
       "12              Yazole  \n",
       "13              Winget  \n",
       "14              VeBNoR  \n",
       "15               TRIPR  \n",
       "16               DIMMY  \n",
       "17                XYXX  \n",
       "18              CYPHUS  \n",
       "19              VeBNoR  \n",
       "20  Van Heusen Academy  \n",
       "21          VAN HEUSEN  \n",
       "22                AUSK  \n",
       "23           Lux Venus  \n",
       "24            Smartees  \n",
       "25         Little Port  \n",
       "26              Vitaan  \n",
       "27              HICODE  \n",
       "28               VTEXX  \n",
       "29             Henzila  \n",
       "30                 x2o  \n",
       "31           FIBERMILL  \n",
       "32               3BROS  \n",
       "33              VeBNoR  \n",
       "34             LEE TEX  \n",
       "35             Whippet  \n",
       "36               MXSOX  \n",
       "37            CHALODIA  \n",
       "38              COMFIT  \n",
       "39          COMBRAIDED  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "2edbd7e8",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}