Scraping_an_Iranian_Sock_Store.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "6f6f2e55-1dee-4ad2-9d89-95b7ffdf798b",
   "metadata": {},
   "source": [
    "## Scraping an Iranian Sock Store\n",
    "\n",
    "This time we are going to work with APIs for web scraping!\n",
    "\n",
    "Store web address: [amoujurabi.ir](https://amoujurabi.ir)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "7bc1e154-1935-4486-93e0-ea2bfe046359",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from requests_html import HTMLSession"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d2c17657-8f06-4ef5-a144-819fd033b0c6",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "URL = 'https://www.zarin.express/api/v1/site/index?username=saniyasocks'\n",
    "session = HTMLSession()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "99049c9e-1813-48db-9817-2d381541b61b",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "200"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response = session.get(URL)\n",
    "response.status_code"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "05a86830-28c1-47e6-88ef-e2699021b673",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'data': [{'id': 4998,\n",
       "   'title': 'اسپورت طرح پرچم(نوک مدادی)',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4998_1452306_1ee053b8-141c-67d6-bd0c-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 20000,\n",
       "   'amount_discount': 17000,\n",
       "   'discount': 15,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4997,\n",
       "   'title': 'طرح پرچم اسپورت(آمریکا)',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4997_1452306_1ee053b1-def2-637c-84b1-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 27000,\n",
       "   'amount_discount': 24300,\n",
       "   'discount': 10,\n",
       "   'inventory': 2,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4996,\n",
       "   'title': 'سوها راه راه طوسی و قهوه ای',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4996_1452306_1ee053ac-7f85-689e-ad35-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 20000,\n",
       "   'amount_discount': 18000,\n",
       "   'discount': 10,\n",
       "   'inventory': 3,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4995,\n",
       "   'title': 'طرح پرچم اسپورت',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4995_1452306_1ee053a6-9421-6916-9ef4-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 25000,\n",
       "   'amount_discount': 20000,\n",
       "   'discount': 20,\n",
       "   'inventory': 2,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4994,\n",
       "   'title': 'سوها راه راه سفید و طوسی(اسپورت)',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4994_1452306_1ee0539f-c14d-6982-bbfc-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 20000,\n",
       "   'amount_discount': 18000,\n",
       "   'discount': 10,\n",
       "   'inventory': 3,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4993,\n",
       "   'title': 'اسپورت طرح پرچم طوسی',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4993_1452306_1ee0539a-14df-688a-ab8c-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 23000,\n",
       "   'amount_discount': 19550,\n",
       "   'discount': 15,\n",
       "   'inventory': 2,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4992,\n",
       "   'title': 'مچی مشکی طرح راه راه و خال خالی',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4992_1452306_1ee05394-40e4-6ab2-b17c-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 30000,\n",
       "   'amount_discount': 22500,\n",
       "   'discount': 25,\n",
       "   'inventory': 4,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4991,\n",
       "   'title': 'مچی طرح پرچم(آلمان)',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4991_1452306_1ee0538c-f185-6f7c-9eee-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 20000,\n",
       "   'amount_discount': 19200,\n",
       "   'discount': 4,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4990,\n",
       "   'title': 'اسپورت سفید طرح گپ',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4990_1452306_1ee05387-bf56-6f60-9f29-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 15000,\n",
       "   'amount_discount': 15000,\n",
       "   'discount': 0,\n",
       "   'inventory': 4,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': -1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4989,\n",
       "   'title': 'دخترانه چهارخانه',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4989_1452306_1ee05381-2c02-6936-8e58-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 22000,\n",
       "   'amount_discount': 22000,\n",
       "   'discount': 0,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 1,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4988,\n",
       "   'title': 'تا به تا طرح رخ رنگ زرد',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4988_1452306_1ee05376-d83f-610a-b248-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 25000,\n",
       "   'amount_discount': 20000,\n",
       "   'discount': 20,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4987,\n",
       "   'title': 'طرح پرچم مشکی.خط سفید و سبز',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4987_1452306_1ee05371-7f61-6c36-834a-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 26000,\n",
       "   'amount_discount': 23400,\n",
       "   'discount': 10,\n",
       "   'inventory': 4,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4986,\n",
       "   'title': 'تا به تا طرح رخ رنگ کرم',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4986_1452306_1ee0536b-3645-6a30-8460-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 25000,\n",
       "   'amount_discount': 20000,\n",
       "   'discount': 20,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4985,\n",
       "   'title': 'تابه تا طرح رخ',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4985_1452306_1ee05361-3dff-6a46-89dc-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 25000,\n",
       "   'amount_discount': 20000,\n",
       "   'discount': 20,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4984,\n",
       "   'title': 'الوان ۳ سین',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4984_1452306_1ee0535b-4272-65de-b728-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 30000,\n",
       "   'amount_discount': 30000,\n",
       "   'discount': 0,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 1,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4983,\n",
       "   'title': 'مشکی خط دار مچی',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4983_1452306_1ee0534e-cd8c-6532-b0e2-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 25000,\n",
       "   'amount_discount': 18750,\n",
       "   'discount': 25,\n",
       "   'inventory': 4,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4982,\n",
       "   'title': 'تا به تا طرح پاندا',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4982_1452306_1ee05349-1796-6872-a491-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 25000,\n",
       "   'amount_discount': 18750,\n",
       "   'discount': 25,\n",
       "   'inventory': 1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4980,\n",
       "   'title': 'دخترانه طرح رنگین کمان',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4980_1452306_1ee0520f-dd88-66c4-b5ad-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 25000,\n",
       "   'amount_discount': 22000,\n",
       "   'discount': 12,\n",
       "   'inventory': -1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4776,\n",
       "   'title': 'بنر تبلیغاتی عموجورابی',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4776_1452306_1edf1bf4-ad7f-6876-a361-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 5,\n",
       "   'amount_discount': 5,\n",
       "   'discount': 0,\n",
       "   'inventory': -1,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0},\n",
       "  {'id': 4775,\n",
       "   'title': 'جوراب مشکی تک رنگ نیم ساق',\n",
       "   'image': 'https://file.zarin.express/uploads/products/img_product_0_product_4775_1452306_1edf1b0d-6dd9-67c2-bdc9-0242ac170002.jpg',\n",
       "   'type': 2,\n",
       "   'amount': 27000,\n",
       "   'amount_discount': 25110,\n",
       "   'discount': 7,\n",
       "   'inventory': 16,\n",
       "   'unlimited': 0,\n",
       "   'invoice_count': 1,\n",
       "   'status': 1,\n",
       "   'status_text': 'فعال',\n",
       "   'views': 0}],\n",
       " 'meta': {'count': 60,\n",
       "  'limit': 20,\n",
       "  'current_page': 1,\n",
       "  'next_page': 2,\n",
       "  'last_page': 3,\n",
       "  'previous_page': None}}"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "response = response.json()\n",
    "response"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "578a2964-426f-4f78-9afb-df2a0c86e0be",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "last_page = response['meta']['last_page']\n",
    "last_page"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "780efce5-4535-4036-ab00-f4a886afd61a",
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Scraping page 1...\n",
      "Scraping page 2...\n",
      "Scraping page 3...\n"
     ]
    }
   ],
   "source": [
    "products = []\n",
    "\n",
    "for i in range(1, last_page+1):\n",
    "    print(f'Scraping page {i}...')\n",
    "    response = session.get(f'{URL}&page={i}')\n",
    "    products_ = response.json()['data']\n",
    "\n",
    "    for product in products_:\n",
    "        products.append({\n",
    "            'Title': product['title'],\n",
    "            'Image': product['image'],\n",
    "            'Amount': product['amount'],  # Price\n",
    "            'Amount_Discount': product['amount_discount'],\n",
    "        })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "26643342-6e9e-4f76-b53b-5e582f90781c",
   "metadata": {
    "collapsed": true,
    "jupyter": {
     "outputs_hidden": true
    },
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[{'Title': 'اسپورت طرح پرچم(نوک مدادی)',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4998_1452306_1ee053b8-141c-67d6-bd0c-0242ac170002.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 17000},\n",
       " {'Title': 'طرح پرچم اسپورت(آمریکا)',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4997_1452306_1ee053b1-def2-637c-84b1-0242ac170002.jpg',\n",
       "  'Amount': 27000,\n",
       "  'Amount_Discount': 24300},\n",
       " {'Title': 'سوها راه راه طوسی و قهوه ای',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4996_1452306_1ee053ac-7f85-689e-ad35-0242ac170002.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 18000},\n",
       " {'Title': 'طرح پرچم اسپورت',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4995_1452306_1ee053a6-9421-6916-9ef4-0242ac170002.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'سوها راه راه سفید و طوسی(اسپورت)',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4994_1452306_1ee0539f-c14d-6982-bbfc-0242ac170002.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 18000},\n",
       " {'Title': 'اسپورت طرح پرچم طوسی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4993_1452306_1ee0539a-14df-688a-ab8c-0242ac170002.jpg',\n",
       "  'Amount': 23000,\n",
       "  'Amount_Discount': 19550},\n",
       " {'Title': 'مچی مشکی طرح راه راه و خال خالی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4992_1452306_1ee05394-40e4-6ab2-b17c-0242ac170002.jpg',\n",
       "  'Amount': 30000,\n",
       "  'Amount_Discount': 22500},\n",
       " {'Title': 'مچی طرح پرچم(آلمان)',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4991_1452306_1ee0538c-f185-6f7c-9eee-0242ac170002.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 19200},\n",
       " {'Title': 'اسپورت سفید طرح گپ',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4990_1452306_1ee05387-bf56-6f60-9f29-0242ac170002.jpg',\n",
       "  'Amount': 15000,\n",
       "  'Amount_Discount': 15000},\n",
       " {'Title': 'دخترانه چهارخانه',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4989_1452306_1ee05381-2c02-6936-8e58-0242ac170002.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'تا به تا طرح رخ رنگ زرد',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4988_1452306_1ee05376-d83f-610a-b248-0242ac170002.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'طرح پرچم مشکی.خط سفید و سبز',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4987_1452306_1ee05371-7f61-6c36-834a-0242ac170002.jpg',\n",
       "  'Amount': 26000,\n",
       "  'Amount_Discount': 23400},\n",
       " {'Title': 'تا به تا طرح رخ رنگ کرم',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4986_1452306_1ee0536b-3645-6a30-8460-0242ac170002.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'تابه تا طرح رخ',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4985_1452306_1ee05361-3dff-6a46-89dc-0242ac170002.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'الوان ۳ سین',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4984_1452306_1ee0535b-4272-65de-b728-0242ac170002.jpg',\n",
       "  'Amount': 30000,\n",
       "  'Amount_Discount': 30000},\n",
       " {'Title': 'مشکی خط دار مچی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4983_1452306_1ee0534e-cd8c-6532-b0e2-0242ac170002.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 18750},\n",
       " {'Title': 'تا به تا طرح پاندا',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4982_1452306_1ee05349-1796-6872-a491-0242ac170002.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 18750},\n",
       " {'Title': 'دخترانه طرح رنگین کمان',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4980_1452306_1ee0520f-dd88-66c4-b5ad-0242ac170002.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'بنر تبلیغاتی عموجورابی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4776_1452306_1edf1bf4-ad7f-6876-a361-0242ac170002.jpg',\n",
       "  'Amount': 5,\n",
       "  'Amount_Discount': 5},\n",
       " {'Title': 'جوراب مشکی تک رنگ نیم ساق',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4775_1452306_1edf1b0d-6dd9-67c2-bdc9-0242ac170002.jpg',\n",
       "  'Amount': 27000,\n",
       "  'Amount_Discount': 25110},\n",
       " {'Title': 'کالج اسپورت(پشت ژله ای)',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4774_1452306_1edf1b06-a520-62e6-9af9-0242ac170002.jpg',\n",
       "  'Amount': 23000,\n",
       "  'Amount_Discount': 23000},\n",
       " {'Title': 'رنگین کمان دخترانه فانتزی طرح خرسی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4773_1452306_1edf1a74-c87b-63cc-916e-0242ac170002.jpg',\n",
       "  'Amount': 27000,\n",
       "  'Amount_Discount': 27000},\n",
       " {'Title': 'اسپورت مچی.آقا و خانم',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4772_1452306_1edf1a6a-3c4f-643e-96f1-0242ac170002.jpg',\n",
       "  'Amount': 32000,\n",
       "  'Amount_Discount': 32000},\n",
       " {'Title': 'رنگین کمان راه راه طرح تدی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4771_1452306_1edf1a5a-0f41-6fce-9512-0242ac170002.jpg',\n",
       "  'Amount': 27000,\n",
       "  'Amount_Discount': 27000},\n",
       " {'Title': 'دخترانه مچی طرح میلک',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4740_1452306_1edede9c-f14f-619a-b52f-0242ac170002.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'اسپورت طرح پرچم',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4739_1452306_1ededd3f-a8d0-6846-8039-0242ac170002.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'مچی فانتزی طرح قلب',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4734_1452306_1eded202-e4cc-6ea0-9426-0242ac170002.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'پارازین زنانه دوربع کفه دار',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4463_1452306_1eddc8fd-d909-6dfc-b76c-0242ac160003.jpg',\n",
       "  'Amount': 15000,\n",
       "  'Amount_Discount': 15000},\n",
       " {'Title': 'پارازین دوربع کفه دار',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_1_product_4424_1452306_1eddbb7f-f1d2-6ae0-b86a-0242ac160003.jpg',\n",
       "  'Amount': 17000,\n",
       "  'Amount_Discount': 17000},\n",
       " {'Title': 'کالج اسپورت کودک.یک و دو سال',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4410_1452306_1edda38a-2ca6-6080-9b3c-0242ac160003.jpg',\n",
       "  'Amount': 19000,\n",
       "  'Amount_Discount': 19000},\n",
       " {'Title': 'اسپورت مچی طرح آدیداس',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4409_1452306_1edda383-39d3-6ed0-85ca-0242ac160003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'ساق دست',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4408_1452306_1edda37b-fe86-6ece-8de4-0242ac160003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'پارازین شیشه ای کفه دار',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4404_1452306_1edda357-6d57-667a-829b-0242ac160003.jpg',\n",
       "  'Amount': 12500,\n",
       "  'Amount_Discount': 12500},\n",
       " {'Title': 'زنانه مچی طرح موشی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4393_1452306_1edd8833-7281-62ca-90a4-0242ac160003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'زنانه مچی طرح موشی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4392_1452306_1edd882f-6b4c-6fd0-8e2d-0242ac160003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'زنانه مچی طرح موشی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4391_1452306_1edd8827-57f0-6c5a-a460-0242ac160003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'نیم ساق اسپورت ٱیدین طرح فیلا',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4125_1452306_1edbabeb-4fc7-6bba-9de1-0242ac160003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'مچی اسپورت آیدین طرح دیزل',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4124_1452306_1edbabe2-6fac-66dc-b376-0242ac160003.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'مچی سفید برند سوها',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4122_1452306_1edbabd6-032f-6286-809b-0242ac160003.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 20460},\n",
       " {'Title': 'پاپوش زنانه طرح سنتی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4069_1452306_1edb7858-6db2-6d58-8cf3-0242ac160003.jpg',\n",
       "  'Amount': 25000,\n",
       "  'Amount_Discount': 25000},\n",
       " {'Title': 'مردانه سفید طرح اسکاچ',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_4067_1452306_1edb784b-2832-6ae2-b571-0242ac160003.jpg',\n",
       "  'Amount': 300000,\n",
       "  'Amount_Discount': 300000},\n",
       " {'Title': 'مچی فانتزی دخترانه',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3968_1452306_1edaee4d-6da1-6642-a35f-0242ac160003.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'مچی مشکی طرح ستاره',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3822_1452306_1eda255a-a130-6bfa-8635-0242ac130003.jpg',\n",
       "  'Amount': 17000,\n",
       "  'Amount_Discount': 17000},\n",
       " {'Title': 'فانتزی مچی طرح خرس',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3821_1452306_1eda2553-94b9-6dd8-9e9b-0242ac130003.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 19800},\n",
       " {'Title': 'دخترانه فانتزی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3721_1452306_1ed9f4c2-301b-6da2-b5a6-0242ac130003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'مچی اسپورت طرح BTS',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3720_1452306_1ed9f4bb-0f43-6668-be17-0242ac130003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'اسپورت مچی مشکی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3719_1452306_1ed9f4b5-461b-618c-b97f-0242ac130003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'کالج طرح پرچم. اسپورت',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3641_1452306_1ed999e5-45e5-6972-bcb0-0242ac130003.jpg',\n",
       "  'Amount': 135000,\n",
       "  'Amount_Discount': 135000},\n",
       " {'Title': 'دخترانه چارخانه طرح خرسی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3629_1452306_1ed967f4-ab66-679c-955e-0242ac130003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'فانتزی مچی طرح ستاره',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3628_1452306_1ed967ef-4599-663a-bd38-0242ac130003.jpg',\n",
       "  'Amount': 15000,\n",
       "  'Amount_Discount': 15000},\n",
       " {'Title': 'مچی چهار خونه طرح خرسی',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3627_1452306_1ed964bc-dec7-68f6-ba12-0242ac130003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 18800},\n",
       " {'Title': 'مچی طرح ریبوک',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3613_1452306_1ed93ef6-de5c-6b46-891e-0242ac130003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'مچی طرح آدیداس راه راه',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3612_1452306_1ed93ede-124c-6ef6-a04f-0242ac130003.jpg',\n",
       "  'Amount': 18000,\n",
       "  'Amount_Discount': 18000},\n",
       " {'Title': 'دخترانه فانتزی طرح لاو',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3610_1452306_1ed93ec5-dfc5-68b0-889e-0242ac130003.jpg',\n",
       "  'Amount': 18000,\n",
       "  'Amount_Discount': 18000},\n",
       " {'Title': 'راه راه الوان',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3514_1452306_1ed8bf44-e8f7-6376-8915-0242ac120003.jpg',\n",
       "  'Amount': 27000,\n",
       "  'Amount_Discount': 24840},\n",
       " {'Title': 'کالج اسپورت',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3493_1452306_1ed882a7-49dc-6f90-9328-0242ac120003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 17000},\n",
       " {'Title': 'پاپوش الوان',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3469_1452306_1ed85acd-f977-62cc-97d6-0242ac120003.jpg',\n",
       "  'Amount': 20000,\n",
       "  'Amount_Discount': 20000},\n",
       " {'Title': 'مچی اسپورت طرح ایکس',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3456_1452306_1edede92-f764-6044-8dbd-0242ac170002.jpg',\n",
       "  'Amount': 22000,\n",
       "  'Amount_Discount': 22000},\n",
       " {'Title': 'قایقی بلند',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3444_1452306_1ed8529c-0ce8-6cc8-8f9f-0242ac120003.jpg',\n",
       "  'Amount': 12000,\n",
       "  'Amount_Discount': 12000},\n",
       " {'Title': 'مچی طرح دار',\n",
       "  'Image': 'https://file.zarin.express/uploads/products/img_product_0_product_3405_1452306_1ed80bed-2a9a-6492-8659-0242ac120003.jpg',\n",
       "  'Amount': 27000,\n",
       "  'Amount_Discount': 24300}]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "b04ac5b1-6730-4851-bc80-3604cd12e7bb",
   "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>Image</th>\n",
       "      <th>Amount</th>\n",
       "      <th>Amount_Discount</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>دخترانه فانتزی</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>20000</td>\n",
       "      <td>20000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>پاپوش زنانه طرح سنتی</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>25000</td>\n",
       "      <td>25000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>جوراب مشکی تک رنگ نیم ساق</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>27000</td>\n",
       "      <td>25110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>ساق دست</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>20000</td>\n",
       "      <td>20000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>مچی طرح دار</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>27000</td>\n",
       "      <td>24300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>پارازین دوربع کفه دار</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>17000</td>\n",
       "      <td>17000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>کالج اسپورت(پشت ژله ای)</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>23000</td>\n",
       "      <td>23000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>مچی فانتزی دخترانه</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>22000</td>\n",
       "      <td>22000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>مردانه سفید طرح اسکاچ</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>300000</td>\n",
       "      <td>300000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>کالج اسپورت کودک.یک و دو سال</td>\n",
       "      <td>https://file.zarin.express/uploads/products/im...</td>\n",
       "      <td>19000</td>\n",
       "      <td>19000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                           Title   \n",
       "44                دخترانه فانتزی  \\\n",
       "39          پاپوش زنانه طرح سنتی   \n",
       "19     جوراب مشکی تک رنگ نیم ساق   \n",
       "31                       ساق دست   \n",
       "59                   مچی طرح دار   \n",
       "28         پارازین دوربع کفه دار   \n",
       "20       کالج اسپورت(پشت ژله ای)   \n",
       "41            مچی فانتزی دخترانه   \n",
       "40         مردانه سفید طرح اسکاچ   \n",
       "29  کالج اسپورت کودک.یک و دو سال   \n",
       "\n",
       "                                                Image  Amount  Amount_Discount  \n",
       "44  https://file.zarin.express/uploads/products/im...   20000            20000  \n",
       "39  https://file.zarin.express/uploads/products/im...   25000            25000  \n",
       "19  https://file.zarin.express/uploads/products/im...   27000            25110  \n",
       "31  https://file.zarin.express/uploads/products/im...   20000            20000  \n",
       "59  https://file.zarin.express/uploads/products/im...   27000            24300  \n",
       "28  https://file.zarin.express/uploads/products/im...   17000            17000  \n",
       "20  https://file.zarin.express/uploads/products/im...   23000            23000  \n",
       "41  https://file.zarin.express/uploads/products/im...   22000            22000  \n",
       "40  https://file.zarin.express/uploads/products/im...  300000           300000  \n",
       "29  https://file.zarin.express/uploads/products/im...   19000            19000  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.DataFrame(products)\n",
    "df.sample(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "6b3622d4-95aa-42d0-ab34-602f01c8a87c",
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "df.to_csv('./exports/amoujurabi_socks.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "598ef02b-e41c-4b52-9746-eda35a6d4adb",
   "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.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}