Inventory_Management_System.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "name": "Inventory Management System.ipynb",
      "provenance": [],
      "collapsed_sections": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "metadata": {
        "id": "UZQbUufvPJFq"
      },
      "source": [
        "records ={ \n",
        "          1001:{\"product\":\"Brush\",\"price\":18,\"quantity\":100,\"expire\":'2023-07-01',\"mfg\":2021,\"discount\":10},\n",
        "          1002:{\"product\":\"Colgate\",\"price\":50,\"quantity\":150,\"expire\":'2024-04-21',\"mfg\":2020,\"discount\":3},\n",
        "          1003:{\"product\":\"Soap\",\"price\":50,\"quantity\":80,\"expire\":'2021-01-15',\"mfg\":2019,\"discount\":5},\n",
        "          1004:{\"product\":\"Cake\",\"price\":100,\"quantity\":250,\"expire\":'2021-02-03',\"mfg\":2020,\"discount\":50},\n",
        "          1005:{\"product\":\"Toffee\",\"price\":2,\"quantity\":1000,\"expire\":'2026-10-20',\"mfg\":2021,\"discount\":3},\n",
        "          1006:{\"product\":\"Chocolates\",\"price\":10,\"quantity\":400,\"expire\":'2025-07-09',\"mfg\":2019,\"discount\":2},\n",
        "          1007:{\"product\":\"Banana\",\"price\":20,\"quantity\":90,\"expire\":'2022-12-01',\"mfg\":2021,\"discount\":20},\n",
        "          1008:{\"product\":\"Juice\",\"price\":100,\"quantity\":10,\"expire\":'2024-10-10',\"mfg\":2020,\"discount\":8},\n",
        "          1009:{\"product\":\"Bag\",\"price\":500,\"quantity\":50,\"expire\":'2023-05-10',\"mfg\":2021,\"discount\":15},\n",
        "          1010:{\"product\":\"Chair\",\"price\":1000,\"quantity\":20,\"expire\":'2025-12-20',\"mfg\":2020,\"discount\":17},\n",
        "          1011:{\"product\":\"Shirt\",\"price\":500,\"quantity\":70,\"expire\":'2025-03-17',\"mfg\":2021,\"discount\":11},\n",
        "          1012:{\"product\":\"Bottle\",\"price\":400,\"quantity\":30,\"expire\":'2024-12-12',\"mfg\":2020,\"discount\":15},\n",
        "          1013:{\"product\":\"Pant\",\"price\":350,\"quantity\":70,\"expire\":'2024-08-13',\"mfg\":2021,\"discount\":13},\n",
        "          1014:{\"product\":\"Icecream\",\"price\":20,\"quantity\":100,\"expire\":'2023-04-28',\"mfg\":2020,\"discount\":25},\n",
        "          1015:{\"product\":\"Table\",\"price\":5000,\"quantity\":10,\"expire\":'2025-08-10',\"mfg\":2019,\"discount\":5},\n",
        "          1016:{\"product\":\"Tubelight\",\"price\":200,\"quantity\":50,\"expire\":'2023-10-29',\"mfg\":2021,\"discount\":13},\n",
        "          1017:{\"product\":\"Bike\",\"price\":45000,\"quantity\":15,\"expire\":'2026-11-16',\"mfg\":2021,\"discount\":16},\n",
        "          1018:{\"product\":\"Umbrella\",\"price\":100,\"quantity\":60,\"expire\":'2023-12-20',\"mfg\":2021,\"discount\":19},\n",
        "          1019:{\"product\":\"Monitor\",\"price\":500,\"quantity\":10,\"expire\":'2023-01-01',\"mfg\":2021,\"discount\":1},\n",
        "          1020:{\"product\":\"CPU\",\"price\":1000,\"quantity\":7,\"expire\":'2024-03-07',\"mfg\":2021,\"discount\":18},\n",
        "          1021:{\"product\":\"Mouse\",\"price\":450,\"quantity\":20,\"expire\":'2023-02-17',\"mfg\":2021,\"discount\":25},\n",
        "          1022:{\"product\":\"Keyboard\",\"price\":550,\"quantity\":10,\"expire\":'2023-10-17',\"mfg\":2021,\"discount\":6},\n",
        "          1023:{\"product\":\"Fan\",\"price\":290,\"quantity\":35,\"expire\":'2023-05-15',\"mfg\":2021,\"discount\":20},\n",
        "          1024:{\"product\":\"Laptop\",\"price\":40000,\"quantity\":50,\"expire\":'2027-10-20',\"mfg\":2021,\"discount\":10},\n",
        "          1025:{\"product\":\"Pen\",\"price\":10,\"quantity\":1000,\"expire\":'2023-05-11',\"mfg\":2021,\"discount\":1},\n",
        "          1026:{\"product\":\"Eraser\",\"price\":5,\"quantity\":500,\"expire\":'2023-07-19',\"mfg\":2021,\"discount\":15},\n",
        "          1027:{\"product\":\"Wire\",\"price\":18,\"quantity\":50,\"expire\":'2023-05-19',\"mfg\":2021,\"discount\":2},\n",
        "          1028:{\"product\":\"Shoe\",\"price\":500,\"quantity\":80,\"expire\":'2025-10-30',\"mfg\":2021,\"discount\":4},\n",
        "          1029:{\"product\":\"Mobile\",\"price\":10000,\"quantity\":10,\"expire\":'2026-10-29',\"mfg\":2021,\"discount\":18},\n",
        "          1030:{\"product\":\"Milk\",\"price\":15,\"quantity\":40,\"expire\":'2023-04-14',\"mfg\":2021,\"discount\":1},\n",
        "}"
      ],
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "7FaVQCN6Bxm-",
        "outputId": "ff986eb2-7506-42d9-e6fa-aed40a05e735"
      },
      "source": [
        "records"
      ],
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{1001: {'discount': 10,\n",
              "  'expire': '2023-07-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Brush',\n",
              "  'quantity': 100},\n",
              " 1002: {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " 1003: {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " 1004: {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " 1005: {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " 1006: {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " 1007: {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " 1008: {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " 1009: {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " 1010: {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 20},\n",
              " 1011: {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " 1012: {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " 1013: {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " 1014: {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " 1015: {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " 1016: {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " 1017: {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " 1018: {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " 1019: {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " 1020: {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " 1021: {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " 1022: {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " 1023: {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " 1024: {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " 1025: {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " 1026: {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " 1027: {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " 1028: {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " 1029: {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " 1030: {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 40}}"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "xh7AarY2UTA3"
      },
      "source": [
        "# **Reading data**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "YkVMmgbhURil"
      },
      "source": [
        "fd=open(\"records.json\",\"r\")\n",
        "r=fd.read()\n",
        "fd.close()\n",
        "record=json.loads(r)"
      ],
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hpFsokzMUoJW",
        "outputId": "08ebaaea-7191-476a-9fcf-929004ab4393"
      },
      "source": [
        "record"
      ],
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2023-07-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Brush',\n",
              "  'quantity': 100},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 20},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 40}}"
            ]
          },
          "metadata": {},
          "execution_count": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "cHd5I9NLNSwU"
      },
      "source": [
        "import json\n",
        "js=json.dumps(records)"
      ],
      "execution_count": 19,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 154
        },
        "id": "GVFTR9UXNd80",
        "outputId": "48e1dd82-dde4-4516-b1ea-2f14d6a364a2"
      },
      "source": [
        "js"
      ],
      "execution_count": 20,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'{\"1001\": {\"product\": \"Brush\", \"price\": 18, \"quantity\": 100, \"expire\": \"2023-07-01\", \"mfg\": 2021, \"discount\": 10}, \"1002\": {\"product\": \"Colgate\", \"price\": 50, \"quantity\": 150, \"expire\": \"2024-04-21\", \"mfg\": 2020, \"discount\": 3}, \"1003\": {\"product\": \"Soap\", \"price\": 50, \"quantity\": 80, \"expire\": \"2021-01-15\", \"mfg\": 2019, \"discount\": 5}, \"1004\": {\"product\": \"Cake\", \"price\": 100, \"quantity\": 250, \"expire\": \"2021-02-03\", \"mfg\": 2020, \"discount\": 50}, \"1005\": {\"product\": \"Toffee\", \"price\": 2, \"quantity\": 1000, \"expire\": \"2026-10-20\", \"mfg\": 2021, \"discount\": 3}, \"1006\": {\"product\": \"Chocolates\", \"price\": 10, \"quantity\": 400, \"expire\": \"2025-07-09\", \"mfg\": 2019, \"discount\": 2}, \"1007\": {\"product\": \"Banana\", \"price\": 20, \"quantity\": 90, \"expire\": \"2022-12-01\", \"mfg\": 2021, \"discount\": 20}, \"1008\": {\"product\": \"Juice\", \"price\": 100, \"quantity\": 10, \"expire\": \"2024-10-10\", \"mfg\": 2020, \"discount\": 8}, \"1009\": {\"product\": \"Bag\", \"price\": 500, \"quantity\": 50, \"expire\": \"2023-05-10\", \"mfg\": 2021, \"discount\": 15}, \"1010\": {\"product\": \"Chair\", \"price\": 1000, \"quantity\": 20, \"expire\": \"2025-12-20\", \"mfg\": 2020, \"discount\": 17}, \"1011\": {\"product\": \"Shirt\", \"price\": 500, \"quantity\": 70, \"expire\": \"2025-03-17\", \"mfg\": 2021, \"discount\": 11}, \"1012\": {\"product\": \"Bottle\", \"price\": 400, \"quantity\": 30, \"expire\": \"2024-12-12\", \"mfg\": 2020, \"discount\": 15}, \"1013\": {\"product\": \"Pant\", \"price\": 350, \"quantity\": 70, \"expire\": \"2024-08-13\", \"mfg\": 2021, \"discount\": 13}, \"1014\": {\"product\": \"Icecream\", \"price\": 20, \"quantity\": 100, \"expire\": \"2023-04-28\", \"mfg\": 2020, \"discount\": 25}, \"1015\": {\"product\": \"Table\", \"price\": 5000, \"quantity\": 10, \"expire\": \"2025-08-10\", \"mfg\": 2019, \"discount\": 5}, \"1016\": {\"product\": \"Tubelight\", \"price\": 200, \"quantity\": 50, \"expire\": \"2023-10-29\", \"mfg\": 2021, \"discount\": 13}, \"1017\": {\"product\": \"Bike\", \"price\": 45000, \"quantity\": 15, \"expire\": \"2026-11-16\", \"mfg\": 2021, \"discount\": 16}, \"1018\": {\"product\": \"Umbrella\", \"price\": 100, \"quantity\": 60, \"expire\": \"2023-12-20\", \"mfg\": 2021, \"discount\": 19}, \"1019\": {\"product\": \"Monitor\", \"price\": 500, \"quantity\": 10, \"expire\": \"2023-01-01\", \"mfg\": 2021, \"discount\": 1}, \"1020\": {\"product\": \"CPU\", \"price\": 1000, \"quantity\": 7, \"expire\": \"2024-03-07\", \"mfg\": 2021, \"discount\": 18}, \"1021\": {\"product\": \"Mouse\", \"price\": 450, \"quantity\": 20, \"expire\": \"2023-02-17\", \"mfg\": 2021, \"discount\": 25}, \"1022\": {\"product\": \"Keyboard\", \"price\": 550, \"quantity\": 10, \"expire\": \"2023-10-17\", \"mfg\": 2021, \"discount\": 6}, \"1023\": {\"product\": \"Fan\", \"price\": 290, \"quantity\": 35, \"expire\": \"2023-05-15\", \"mfg\": 2021, \"discount\": 20}, \"1024\": {\"product\": \"Laptop\", \"price\": 40000, \"quantity\": 50, \"expire\": \"2027-10-20\", \"mfg\": 2021, \"discount\": 10}, \"1025\": {\"product\": \"Pen\", \"price\": 10, \"quantity\": 1000, \"expire\": \"2023-05-11\", \"mfg\": 2021, \"discount\": 1}, \"1026\": {\"product\": \"Eraser\", \"price\": 5, \"quantity\": 500, \"expire\": \"2023-07-19\", \"mfg\": 2021, \"discount\": 15}, \"1027\": {\"product\": \"Wire\", \"price\": 18, \"quantity\": 50, \"expire\": \"2023-05-19\", \"mfg\": 2021, \"discount\": 2}, \"1028\": {\"product\": \"Shoe\", \"price\": 500, \"quantity\": 80, \"expire\": \"2025-10-30\", \"mfg\": 2021, \"discount\": 4}, \"1029\": {\"product\": \"Mobile\", \"price\": 10000, \"quantity\": 10, \"expire\": \"2026-10-29\", \"mfg\": 2021, \"discount\": 18}, \"1030\": {\"product\": \"Milk\", \"price\": 15, \"quantity\": 40, \"expire\": \"2023-04-14\", \"mfg\": 2021, \"discount\": 1}}'"
            ]
          },
          "metadata": {},
          "execution_count": 20
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Yo1LXHJXQKGe"
      },
      "source": [
        "fd=open(\"records.json\",\"w\")\n",
        "fd.write(js)\n",
        "fd.close()"
      ],
      "execution_count": 21,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "SVGsBpNHQk3r"
      },
      "source": [
        "fd=open(\"records.json\",\"r\")\n",
        "tx=fd.read()\n",
        "fd.close()"
      ],
      "execution_count": 22,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 154
        },
        "id": "5VHtlnHvSNIy",
        "outputId": "1ed552b1-d2de-45d4-9d85-7f22e8930042"
      },
      "source": [
        "tx"
      ],
      "execution_count": 23,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'{\"1001\": {\"product\": \"Brush\", \"price\": 18, \"quantity\": 100, \"expire\": \"2023-07-01\", \"mfg\": 2021, \"discount\": 10}, \"1002\": {\"product\": \"Colgate\", \"price\": 50, \"quantity\": 150, \"expire\": \"2024-04-21\", \"mfg\": 2020, \"discount\": 3}, \"1003\": {\"product\": \"Soap\", \"price\": 50, \"quantity\": 80, \"expire\": \"2021-01-15\", \"mfg\": 2019, \"discount\": 5}, \"1004\": {\"product\": \"Cake\", \"price\": 100, \"quantity\": 250, \"expire\": \"2021-02-03\", \"mfg\": 2020, \"discount\": 50}, \"1005\": {\"product\": \"Toffee\", \"price\": 2, \"quantity\": 1000, \"expire\": \"2026-10-20\", \"mfg\": 2021, \"discount\": 3}, \"1006\": {\"product\": \"Chocolates\", \"price\": 10, \"quantity\": 400, \"expire\": \"2025-07-09\", \"mfg\": 2019, \"discount\": 2}, \"1007\": {\"product\": \"Banana\", \"price\": 20, \"quantity\": 90, \"expire\": \"2022-12-01\", \"mfg\": 2021, \"discount\": 20}, \"1008\": {\"product\": \"Juice\", \"price\": 100, \"quantity\": 10, \"expire\": \"2024-10-10\", \"mfg\": 2020, \"discount\": 8}, \"1009\": {\"product\": \"Bag\", \"price\": 500, \"quantity\": 50, \"expire\": \"2023-05-10\", \"mfg\": 2021, \"discount\": 15}, \"1010\": {\"product\": \"Chair\", \"price\": 1000, \"quantity\": 20, \"expire\": \"2025-12-20\", \"mfg\": 2020, \"discount\": 17}, \"1011\": {\"product\": \"Shirt\", \"price\": 500, \"quantity\": 70, \"expire\": \"2025-03-17\", \"mfg\": 2021, \"discount\": 11}, \"1012\": {\"product\": \"Bottle\", \"price\": 400, \"quantity\": 30, \"expire\": \"2024-12-12\", \"mfg\": 2020, \"discount\": 15}, \"1013\": {\"product\": \"Pant\", \"price\": 350, \"quantity\": 70, \"expire\": \"2024-08-13\", \"mfg\": 2021, \"discount\": 13}, \"1014\": {\"product\": \"Icecream\", \"price\": 20, \"quantity\": 100, \"expire\": \"2023-04-28\", \"mfg\": 2020, \"discount\": 25}, \"1015\": {\"product\": \"Table\", \"price\": 5000, \"quantity\": 10, \"expire\": \"2025-08-10\", \"mfg\": 2019, \"discount\": 5}, \"1016\": {\"product\": \"Tubelight\", \"price\": 200, \"quantity\": 50, \"expire\": \"2023-10-29\", \"mfg\": 2021, \"discount\": 13}, \"1017\": {\"product\": \"Bike\", \"price\": 45000, \"quantity\": 15, \"expire\": \"2026-11-16\", \"mfg\": 2021, \"discount\": 16}, \"1018\": {\"product\": \"Umbrella\", \"price\": 100, \"quantity\": 60, \"expire\": \"2023-12-20\", \"mfg\": 2021, \"discount\": 19}, \"1019\": {\"product\": \"Monitor\", \"price\": 500, \"quantity\": 10, \"expire\": \"2023-01-01\", \"mfg\": 2021, \"discount\": 1}, \"1020\": {\"product\": \"CPU\", \"price\": 1000, \"quantity\": 7, \"expire\": \"2024-03-07\", \"mfg\": 2021, \"discount\": 18}, \"1021\": {\"product\": \"Mouse\", \"price\": 450, \"quantity\": 20, \"expire\": \"2023-02-17\", \"mfg\": 2021, \"discount\": 25}, \"1022\": {\"product\": \"Keyboard\", \"price\": 550, \"quantity\": 10, \"expire\": \"2023-10-17\", \"mfg\": 2021, \"discount\": 6}, \"1023\": {\"product\": \"Fan\", \"price\": 290, \"quantity\": 35, \"expire\": \"2023-05-15\", \"mfg\": 2021, \"discount\": 20}, \"1024\": {\"product\": \"Laptop\", \"price\": 40000, \"quantity\": 50, \"expire\": \"2027-10-20\", \"mfg\": 2021, \"discount\": 10}, \"1025\": {\"product\": \"Pen\", \"price\": 10, \"quantity\": 1000, \"expire\": \"2023-05-11\", \"mfg\": 2021, \"discount\": 1}, \"1026\": {\"product\": \"Eraser\", \"price\": 5, \"quantity\": 500, \"expire\": \"2023-07-19\", \"mfg\": 2021, \"discount\": 15}, \"1027\": {\"product\": \"Wire\", \"price\": 18, \"quantity\": 50, \"expire\": \"2023-05-19\", \"mfg\": 2021, \"discount\": 2}, \"1028\": {\"product\": \"Shoe\", \"price\": 500, \"quantity\": 80, \"expire\": \"2025-10-30\", \"mfg\": 2021, \"discount\": 4}, \"1029\": {\"product\": \"Mobile\", \"price\": 10000, \"quantity\": 10, \"expire\": \"2026-10-29\", \"mfg\": 2021, \"discount\": 18}, \"1030\": {\"product\": \"Milk\", \"price\": 15, \"quantity\": 40, \"expire\": \"2023-04-14\", \"mfg\": 2021, \"discount\": 1}}'"
            ]
          },
          "metadata": {},
          "execution_count": 23
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "JwCYGjy3uDo5"
      },
      "source": [
        "rec=json.loads(tx)"
      ],
      "execution_count": 24,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "yxJdZttLuTf5",
        "outputId": "b26e181c-1627-4c54-9dba-d845963d8405"
      },
      "source": [
        "rec"
      ],
      "execution_count": 25,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2023-07-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Brush',\n",
              "  'quantity': 100},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 20},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 40}}"
            ]
          },
          "metadata": {},
          "execution_count": 25
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Q17JPbbxa44M"
      },
      "source": [
        "# **Add New Items**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "TbwmPYg_bCA6",
        "outputId": "7d9c9cf0-883d-4667-8111-d40a0e7d5e0d"
      },
      "source": [
        "prod_id = str(input(\"Enter product id: \"))\n",
        "prod_name=str(input(\"Enter product name: \"))\n",
        "prod_discount=int(input(\"Enter discount: \"))\n",
        "prod_expire=str(input(\"Enter expiry date: \"))\n",
        "prod_mfg=int(input(\"Enter mfg: \"))\n",
        "prod_price=int(input(\"Enter product price\"))\n",
        "prod_quantity=int(input(\"Enter quantity\"))\n",
        "\n",
        "\n",
        "rec[prod_id] ={\"product\":prod_name,\"price\":prod_price,\"quantity\":prod_quantity,\"expire\":prod_expire,\"mfg\":prod_mfg,\"discount\":prod_discount}\n",
        "js=json.dumps(rec)\n",
        "\n",
        "fd=open(\"records.json\",\"w\")\n",
        "fd.write(js)\n",
        "fd.close()\n",
        "\n"
      ],
      "execution_count": 28,
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Enter product id: 1031\n",
            "Enter product name: Rubber\n",
            "Enter discount: 3\n",
            "Enter expiry date: 2024-10-20\n",
            "Enter mfg: 2020\n",
            "Enter product price5\n",
            "Enter quantity100\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "5BnQU3_PlMZX",
        "outputId": "97309c6e-1984-4d39-8c3f-fa8e1a902a16"
      },
      "source": [
        "rec"
      ],
      "execution_count": 29,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2023-07-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Brush',\n",
              "  'quantity': 100},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 20},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 40},\n",
              " '1031': {'discount': 3,\n",
              "  'expire': '2024-10-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 5,\n",
              "  'product': 'Rubber',\n",
              "  'quantity': 100}}"
            ]
          },
          "metadata": {},
          "execution_count": 29
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "0TC4NaCvlSHP"
      },
      "source": [
        "del rec['1031']"
      ],
      "execution_count": 30,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "xGOCdJaTlWJa",
        "outputId": "b651f7b9-3e7f-463f-845c-86da438c786b"
      },
      "source": [
        "rec"
      ],
      "execution_count": 31,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2023-07-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Brush',\n",
              "  'quantity': 100},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 20},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 40}}"
            ]
          },
          "metadata": {},
          "execution_count": 31
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "-SYxKMo2Ftz3"
      },
      "source": [
        "# **Editing an items**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "JzgLhJBFFyRm",
        "outputId": "eb6dcf2b-7db6-49be-f75f-26d1b05f5163"
      },
      "source": [
        "prod_id = str(input(\"Enter product id: \"))\n",
        "prod_discount=int(input(\"Enter discount: \"))\n",
        "prod_price=int(input(\"Enter product price\"))\n",
        "prod_quantity=int(input(\"Enter quantity\"))\n",
        "\n",
        "rec[prod_id]['discount']=prod_discount\n",
        "rec[prod_id]['price']=prod_price\n",
        "rec[prod_id]['quantity']=prod_quantity\n"
      ],
      "execution_count": 32,
      "outputs": [
        {
          "name": "stdout",
          "output_type": "stream",
          "text": [
            "Enter product id: 1030\n",
            "Enter discount: 2\n",
            "Enter product price10\n",
            "Enter quantity120\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "vc5AG5vkHA3d",
        "outputId": "31b051fc-65f9-4825-b166-4533f942eeda"
      },
      "source": [
        "rec"
      ],
      "execution_count": 33,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2023-07-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Brush',\n",
              "  'quantity': 100},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 20},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 2,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 120}}"
            ]
          },
          "metadata": {},
          "execution_count": 33
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "6thZ1qYKp6P6"
      },
      "source": [
        "# **Purchasing an item**\n"
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "ZNogplqG2D6r"
      },
      "source": [
        ""
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "i_Bu38WAqEl0",
        "outputId": "b8bb53e0-ce7b-4762-8ea3-df52e7cd52b4"
      },
      "source": [
        "print(\"Our inventory have \",end=\"\")\n",
        "for i in rec:\n",
        "  print(\"item id \" + i, end=\" \")\n",
        "  print(\"and item \" + rec[i]['product'], end =\", \")\n",
        "item=str(input(\"Enter your item id : \"))\n",
        "quant=int(input(\"Enter quantity : \"))\n",
        "name=str(input(\"Enter your name: \"))\n",
        "\n",
        "total_bill =rec[item]['price']*quant -(rec[item]['price']*rec[item]['discount'])/100\n",
        "\n",
        "if (rec[item]['quantity']>0):\n",
        "  if (rec[item]['quantity']<quant):\n",
        "    print(\"Sorry {} we have only {} quantity!\".format(name,rec[item]['quantity']))\n",
        "  else:\n",
        "    out=\"Hello {} ,thank you so much for purchasing the {} having MFG - {} and Expires at {} .Your billing amount is {}₹ with giving you {} % discount\".format(name,rec[item]['product'],rec[item]['mfg'],rec[item]['expire'],total_bill,rec[item]['discount'])\n",
        "    print(\"###########################################################################\")\n",
        "    print(out)\n",
        "else:\n",
        "  print(\"Sorry {} , We are out of stock!\".format(name))  \n",
        "\n",
        "\n",
        "rec[item]['quantity']=rec[item]['quantity']-quant"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Our inventory have item id 1001 and item Apple, item id 1002 and item Colgate, item id 1003 and item Soap, item id 1004 and item Cake, item id 1005 and item Toffee, item id 1006 and item Chocolates, item id 1007 and item Banana, item id 1008 and item Juice, item id 1009 and item Bag, item id 1010 and item Chair, item id 1011 and item Shirt, item id 1012 and item Bottle, item id 1013 and item Pant, item id 1014 and item Icecream, item id 1015 and item Table, item id 1016 and item Tubelight, item id 1017 and item Bike, item id 1018 and item Umbrella, item id 1019 and item Monitor, item id 1020 and item CPU, item id 1021 and item Mouse, item id 1022 and item Keyboard, item id 1023 and item Fan, item id 1024 and item Laptop, item id 1025 and item Pen, item id 1026 and item Eraser, item id 1027 and item Wire, item id 1028 and item Shoe, item id 1029 and item Mobile, item id 1030 and item Milk, Enter your item id : 1019\n",
            "Enter quantity : 3\n",
            "Enter your name: Sachin\n",
            "###########################################################################\n",
            "Hello Sachin ,thank you so much for purchasing the Monitor having MFG - 2021 and Expires at 2023-01-01 .Your billing amount is 1495.0₹ with giving you 1 % discount\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "uYGzW9T3MrPn"
      },
      "source": [
        ""
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ckj3tL2L_QGe",
        "outputId": "2d6af7e3-d3d9-424e-b820-2b365d8b27cd"
      },
      "source": [
        "rec"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2022-03-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Apple',\n",
              "  'quantity': 100},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 18},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 40}}"
            ]
          },
          "metadata": {},
          "execution_count": 244
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "Yxi6IK_6MoDQ"
      },
      "source": [
        "# **Refunding an items**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ErHy6Me8MtkL",
        "outputId": "fb8b92db-9bea-451e-e035-c8bb52d0e33f"
      },
      "source": [
        "prod=str(input(\"Enter your item id : \"))\n",
        "print(\"************** Hello your previous item id and quantity of product {} is {} and {} *****************\".format(rec[item]['product'],item,quant))\n",
        "qua=int(input(\"Enter how much quantity do you want to refund : \"))\n",
        "nam=str(input(\"Enter your name: \"))\n",
        "\n",
        "if name==nam:\n",
        "  if qua<=quant and prod == item:\n",
        "    rec[prod]['quantity']=rec[prod]['quantity']+qua\n",
        "    print(\"Hello {} Your refund is done! Your refund Amount {}₹ has been credited.\".format(name,rec[item]['price']*qua -(rec[item]['price']*rec[item]['discount'])/100))\n",
        "  else:\n",
        "    print(\"You are exceeding the quantity nd maybe you are entered incorrect product id\")  \n",
        "else:\n",
        "  print(\"Your name is not in the inventroy. Please correct your details.\")    \n"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Enter your item id : 1001\n",
            "************** Hello your previous item id and quantity of product Brush is 1001 and 2 *****************\n",
            "Enter how much quantity do you want to refund : 2\n",
            "Enter your name: Karan\n",
            "Hello Karan Your refund is done! Your refund Amount 34.2₹ has been credited.\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "OC9Xh7-KRcM_",
        "outputId": "a6257f37-f9b7-4c2a-b929-ce7d08882a91"
      },
      "source": [
        "rec"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2022-03-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Apple',\n",
              "  'quantity': 97},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 149},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 249},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 85},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 16},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 69},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 7},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 1},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 996},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 46},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 39}}"
            ]
          },
          "metadata": {},
          "execution_count": 321
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "CLwQIlyxZ5ip"
      },
      "source": [
        "#**Expiry item**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Zjy1loIIaIxV",
        "outputId": "45f42204-ba72-4f01-b552-1c7b3f92d5e9"
      },
      "source": [
        "import datetime\n",
        "itemex=str(input(\"Enter the item id which you want to check expiry date: \"))\n",
        "today_date= datetime.date.today()\n",
        "\n",
        "if rec[itemex]['expire']== str(today_date):\n",
        "  print(\"Your item is expired!\")\n",
        "  del rec[itemex]\n",
        "else:\n",
        "  print(\"Your item is not expired at this moment!\")"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Enter the item id which you want to check expiry date: 1020\n",
            "Your item is not expired at this moment!\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "hOoWRjzKlJu2",
        "outputId": "fe6755f6-0afc-47bf-db74-0455c79fdd58"
      },
      "source": [
        "rec"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'1001': {'discount': 10,\n",
              "  'expire': '2023-07-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Brush',\n",
              "  'quantity': 100},\n",
              " '1002': {'discount': 3,\n",
              "  'expire': '2024-04-21',\n",
              "  'mfg': 2020,\n",
              "  'price': 50,\n",
              "  'product': 'Colgate',\n",
              "  'quantity': 150},\n",
              " '1003': {'discount': 5,\n",
              "  'expire': '2021-01-15',\n",
              "  'mfg': 2019,\n",
              "  'price': 50,\n",
              "  'product': 'Soap',\n",
              "  'quantity': 80},\n",
              " '1004': {'discount': 50,\n",
              "  'expire': '2021-02-03',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Cake',\n",
              "  'quantity': 250},\n",
              " '1005': {'discount': 3,\n",
              "  'expire': '2026-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 2,\n",
              "  'product': 'Toffee',\n",
              "  'quantity': 1000},\n",
              " '1006': {'discount': 2,\n",
              "  'expire': '2025-07-09',\n",
              "  'mfg': 2019,\n",
              "  'price': 10,\n",
              "  'product': 'Chocolates',\n",
              "  'quantity': 400},\n",
              " '1007': {'discount': 20,\n",
              "  'expire': '2022-12-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 20,\n",
              "  'product': 'Banana',\n",
              "  'quantity': 90},\n",
              " '1008': {'discount': 8,\n",
              "  'expire': '2024-10-10',\n",
              "  'mfg': 2020,\n",
              "  'price': 100,\n",
              "  'product': 'Juice',\n",
              "  'quantity': 10},\n",
              " '1009': {'discount': 15,\n",
              "  'expire': '2023-05-10',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Bag',\n",
              "  'quantity': 50},\n",
              " '1010': {'discount': 17,\n",
              "  'expire': '2025-12-20',\n",
              "  'mfg': 2020,\n",
              "  'price': 1000,\n",
              "  'product': 'Chair',\n",
              "  'quantity': 20},\n",
              " '1011': {'discount': 11,\n",
              "  'expire': '2025-03-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shirt',\n",
              "  'quantity': 70},\n",
              " '1012': {'discount': 15,\n",
              "  'expire': '2024-12-12',\n",
              "  'mfg': 2020,\n",
              "  'price': 400,\n",
              "  'product': 'Bottle',\n",
              "  'quantity': 30},\n",
              " '1013': {'discount': 13,\n",
              "  'expire': '2024-08-13',\n",
              "  'mfg': 2021,\n",
              "  'price': 350,\n",
              "  'product': 'Pant',\n",
              "  'quantity': 70},\n",
              " '1014': {'discount': 25,\n",
              "  'expire': '2023-04-28',\n",
              "  'mfg': 2020,\n",
              "  'price': 20,\n",
              "  'product': 'Icecream',\n",
              "  'quantity': 100},\n",
              " '1015': {'discount': 5,\n",
              "  'expire': '2025-08-10',\n",
              "  'mfg': 2019,\n",
              "  'price': 5000,\n",
              "  'product': 'Table',\n",
              "  'quantity': 10},\n",
              " '1016': {'discount': 13,\n",
              "  'expire': '2023-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 200,\n",
              "  'product': 'Tubelight',\n",
              "  'quantity': 50},\n",
              " '1017': {'discount': 16,\n",
              "  'expire': '2026-11-16',\n",
              "  'mfg': 2021,\n",
              "  'price': 45000,\n",
              "  'product': 'Bike',\n",
              "  'quantity': 15},\n",
              " '1018': {'discount': 19,\n",
              "  'expire': '2023-12-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 100,\n",
              "  'product': 'Umbrella',\n",
              "  'quantity': 60},\n",
              " '1019': {'discount': 1,\n",
              "  'expire': '2023-01-01',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Monitor',\n",
              "  'quantity': 10},\n",
              " '1020': {'discount': 18,\n",
              "  'expire': '2024-03-07',\n",
              "  'mfg': 2021,\n",
              "  'price': 1000,\n",
              "  'product': 'CPU',\n",
              "  'quantity': 7},\n",
              " '1021': {'discount': 25,\n",
              "  'expire': '2023-02-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 450,\n",
              "  'product': 'Mouse',\n",
              "  'quantity': 20},\n",
              " '1022': {'discount': 6,\n",
              "  'expire': '2023-10-17',\n",
              "  'mfg': 2021,\n",
              "  'price': 550,\n",
              "  'product': 'Keyboard',\n",
              "  'quantity': 10},\n",
              " '1023': {'discount': 20,\n",
              "  'expire': '2023-05-15',\n",
              "  'mfg': 2021,\n",
              "  'price': 290,\n",
              "  'product': 'Fan',\n",
              "  'quantity': 35},\n",
              " '1024': {'discount': 10,\n",
              "  'expire': '2027-10-20',\n",
              "  'mfg': 2021,\n",
              "  'price': 40000,\n",
              "  'product': 'Laptop',\n",
              "  'quantity': 50},\n",
              " '1025': {'discount': 1,\n",
              "  'expire': '2023-05-11',\n",
              "  'mfg': 2021,\n",
              "  'price': 10,\n",
              "  'product': 'Pen',\n",
              "  'quantity': 1000},\n",
              " '1026': {'discount': 15,\n",
              "  'expire': '2023-07-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 5,\n",
              "  'product': 'Eraser',\n",
              "  'quantity': 500},\n",
              " '1027': {'discount': 2,\n",
              "  'expire': '2023-05-19',\n",
              "  'mfg': 2021,\n",
              "  'price': 18,\n",
              "  'product': 'Wire',\n",
              "  'quantity': 50},\n",
              " '1028': {'discount': 4,\n",
              "  'expire': '2025-10-30',\n",
              "  'mfg': 2021,\n",
              "  'price': 500,\n",
              "  'product': 'Shoe',\n",
              "  'quantity': 80},\n",
              " '1029': {'discount': 18,\n",
              "  'expire': '2026-10-29',\n",
              "  'mfg': 2021,\n",
              "  'price': 10000,\n",
              "  'product': 'Mobile',\n",
              "  'quantity': 10},\n",
              " '1030': {'discount': 1,\n",
              "  'expire': '2023-04-14',\n",
              "  'mfg': 2021,\n",
              "  'price': 15,\n",
              "  'product': 'Milk',\n",
              "  'quantity': 40}}"
            ]
          },
          "metadata": {},
          "execution_count": 204
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "MzGvQh7GxoYr"
      },
      "source": [
        "# **Updating an items**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "m7h7FrUMxsgC"
      },
      "source": [
        "js= json.dumps(rec)\n",
        "fd=open(\"records.json\",\"w\")\n",
        "fd.write(js)\n",
        "fd.close()"
      ],
      "execution_count": 34,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "TlTI34TtMZoF"
      },
      "source": [
        "fd=open(\"records.json\",\"r\")\n",
        "r=fd.read()\n",
        "fd.close()"
      ],
      "execution_count": 36,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 154
        },
        "id": "KKOKA9lUM1l7",
        "outputId": "bfce5107-091d-4b96-ced2-01aee9bbc0a5"
      },
      "source": [
        "r"
      ],
      "execution_count": 37,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'{\"1001\": {\"product\": \"Brush\", \"price\": 18, \"quantity\": 100, \"expire\": \"2023-07-01\", \"mfg\": 2021, \"discount\": 10}, \"1002\": {\"product\": \"Colgate\", \"price\": 50, \"quantity\": 150, \"expire\": \"2024-04-21\", \"mfg\": 2020, \"discount\": 3}, \"1003\": {\"product\": \"Soap\", \"price\": 50, \"quantity\": 80, \"expire\": \"2021-01-15\", \"mfg\": 2019, \"discount\": 5}, \"1004\": {\"product\": \"Cake\", \"price\": 100, \"quantity\": 250, \"expire\": \"2021-02-03\", \"mfg\": 2020, \"discount\": 50}, \"1005\": {\"product\": \"Toffee\", \"price\": 2, \"quantity\": 1000, \"expire\": \"2026-10-20\", \"mfg\": 2021, \"discount\": 3}, \"1006\": {\"product\": \"Chocolates\", \"price\": 10, \"quantity\": 400, \"expire\": \"2025-07-09\", \"mfg\": 2019, \"discount\": 2}, \"1007\": {\"product\": \"Banana\", \"price\": 20, \"quantity\": 90, \"expire\": \"2022-12-01\", \"mfg\": 2021, \"discount\": 20}, \"1008\": {\"product\": \"Juice\", \"price\": 100, \"quantity\": 10, \"expire\": \"2024-10-10\", \"mfg\": 2020, \"discount\": 8}, \"1009\": {\"product\": \"Bag\", \"price\": 500, \"quantity\": 50, \"expire\": \"2023-05-10\", \"mfg\": 2021, \"discount\": 15}, \"1010\": {\"product\": \"Chair\", \"price\": 1000, \"quantity\": 20, \"expire\": \"2025-12-20\", \"mfg\": 2020, \"discount\": 17}, \"1011\": {\"product\": \"Shirt\", \"price\": 500, \"quantity\": 70, \"expire\": \"2025-03-17\", \"mfg\": 2021, \"discount\": 11}, \"1012\": {\"product\": \"Bottle\", \"price\": 400, \"quantity\": 30, \"expire\": \"2024-12-12\", \"mfg\": 2020, \"discount\": 15}, \"1013\": {\"product\": \"Pant\", \"price\": 350, \"quantity\": 70, \"expire\": \"2024-08-13\", \"mfg\": 2021, \"discount\": 13}, \"1014\": {\"product\": \"Icecream\", \"price\": 20, \"quantity\": 100, \"expire\": \"2023-04-28\", \"mfg\": 2020, \"discount\": 25}, \"1015\": {\"product\": \"Table\", \"price\": 5000, \"quantity\": 10, \"expire\": \"2025-08-10\", \"mfg\": 2019, \"discount\": 5}, \"1016\": {\"product\": \"Tubelight\", \"price\": 200, \"quantity\": 50, \"expire\": \"2023-10-29\", \"mfg\": 2021, \"discount\": 13}, \"1017\": {\"product\": \"Bike\", \"price\": 45000, \"quantity\": 15, \"expire\": \"2026-11-16\", \"mfg\": 2021, \"discount\": 16}, \"1018\": {\"product\": \"Umbrella\", \"price\": 100, \"quantity\": 60, \"expire\": \"2023-12-20\", \"mfg\": 2021, \"discount\": 19}, \"1019\": {\"product\": \"Monitor\", \"price\": 500, \"quantity\": 10, \"expire\": \"2023-01-01\", \"mfg\": 2021, \"discount\": 1}, \"1020\": {\"product\": \"CPU\", \"price\": 1000, \"quantity\": 7, \"expire\": \"2024-03-07\", \"mfg\": 2021, \"discount\": 18}, \"1021\": {\"product\": \"Mouse\", \"price\": 450, \"quantity\": 20, \"expire\": \"2023-02-17\", \"mfg\": 2021, \"discount\": 25}, \"1022\": {\"product\": \"Keyboard\", \"price\": 550, \"quantity\": 10, \"expire\": \"2023-10-17\", \"mfg\": 2021, \"discount\": 6}, \"1023\": {\"product\": \"Fan\", \"price\": 290, \"quantity\": 35, \"expire\": \"2023-05-15\", \"mfg\": 2021, \"discount\": 20}, \"1024\": {\"product\": \"Laptop\", \"price\": 40000, \"quantity\": 50, \"expire\": \"2027-10-20\", \"mfg\": 2021, \"discount\": 10}, \"1025\": {\"product\": \"Pen\", \"price\": 10, \"quantity\": 1000, \"expire\": \"2023-05-11\", \"mfg\": 2021, \"discount\": 1}, \"1026\": {\"product\": \"Eraser\", \"price\": 5, \"quantity\": 500, \"expire\": \"2023-07-19\", \"mfg\": 2021, \"discount\": 15}, \"1027\": {\"product\": \"Wire\", \"price\": 18, \"quantity\": 50, \"expire\": \"2023-05-19\", \"mfg\": 2021, \"discount\": 2}, \"1028\": {\"product\": \"Shoe\", \"price\": 500, \"quantity\": 80, \"expire\": \"2025-10-30\", \"mfg\": 2021, \"discount\": 4}, \"1029\": {\"product\": \"Mobile\", \"price\": 10000, \"quantity\": 10, \"expire\": \"2026-10-29\", \"mfg\": 2021, \"discount\": 18}, \"1030\": {\"product\": \"Milk\", \"price\": 10, \"quantity\": 120, \"expire\": \"2023-04-14\", \"mfg\": 2021, \"discount\": 2}}'"
            ]
          },
          "metadata": {},
          "execution_count": 37
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "qYf-7CjgxfrS"
      },
      "source": [
        "# **Sales**"
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "Zc8NsdXnIGrJ",
        "outputId": "db70d61d-f904-442b-c68c-19168a563cf2"
      },
      "source": [
        "{'name':name,'prod':item,'qnt':quant,\"billing_amt\":total_bill}"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'billing_amt': 290.0, 'name': 'Karan', 'prod': '1001', 'qnt': 3}"
            ]
          },
          "metadata": {},
          "execution_count": 253
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "Mkj-07oAIi9B"
      },
      "source": [
        "sales={1:{'name':name,'prod':item,'qnt':quant,\"billing_amt\":total_bill},\n",
        "       2:{'name':name,'prod':item,'qnt':quant,\"billing_amt\":total_bill}}"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "FA2YAYq6IKjz"
      },
      "source": [
        ""
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "l4xh-o5Mxl7R"
      },
      "source": [
        "sales={(len(sales)+1):{'name':name,'prod':item,'qnt':quant,\"billing_amt\":total_bill}}"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "pKnU5RxpSAvH"
      },
      "source": [
        ""
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "DFwBvKNsQ1EC"
      },
      "source": [
        "sales[(len(sales)+1)]={'name':name,'prod':item,'qnt':quant,\"billing_amt\":total_bill}"
      ],
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 119
        },
        "id": "GpW2PPVKSmrP",
        "outputId": "44b86a8e-aaf2-487f-d20a-0d8e44368716"
      },
      "source": [
        "sale=json.dumps(sales)\n",
        "sale"
      ],
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "string"
            },
            "text/plain": [
              "'{\"1\": {\"name\": \"Sohail\", \"prod\": \"1004\", \"qnt\": 1, \"billing_amt\": 50.0}, \"2\": {\"name\": \"Sohail\", \"prod\": \"1004\", \"qnt\": 1, \"billing_amt\": 50.0}, \"3\": {\"name\": \"Sohail\", \"prod\": \"1004\", \"qnt\": 1, \"billing_amt\": 50.0}, \"4\": {\"name\": \"Karan\", \"prod\": \"1002\", \"qnt\": 1, \"billing_amt\": 48.5}, \"5\": {\"name\": \"Happy\", \"prod\": \"1020\", \"qnt\": 2, \"billing_amt\": 1820.0}, \"6\": {\"name\": \"Tanvir\", \"prod\": \"1025\", \"qnt\": 4, \"billing_amt\": 39.9}, \"7\": {\"name\": \"Bumrah\", \"prod\": \"1013\", \"qnt\": 1, \"billing_amt\": 304.5}, \"8\": {\"name\": \"Shami\", \"prod\": \"1027\", \"qnt\": 4, \"billing_amt\": 71.64}, \"9\": {\"name\": \"Sourav\", \"prod\": \"1007\", \"qnt\": 5, \"billing_amt\": 96.0}, \"10\": {\"name\": \"Sourav\", \"prod\": \"1007\", \"qnt\": 5, \"billing_amt\": 96.0}, \"11\": {\"name\": \"Sachin\", \"prod\": \"1019\", \"qnt\": 3, \"billing_amt\": 1495.0}}'"
            ]
          },
          "metadata": {},
          "execution_count": 323
        }
      ]
    },
    {
      "cell_type": "code",
      "metadata": {
        "id": "loT4Ed7QSz5V"
      },
      "source": [
        "fd=open(\"sales.json\",\"w\")\n",
        "r=fd.write(sale)\n",
        "fd.close()"
      ],
      "execution_count": null,
      "outputs": []
    }
  ]
}