Updating_and_Adding_New_Products.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "d7491295",
   "metadata": {},
   "source": [
    "# NAME: Subham Surana\n",
    "# EMAIL: yashsura786@gmail.com"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ddc6264b",
   "metadata": {},
   "source": [
    "### Importing Libraries"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6b9e476f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import json"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "357eb4a3",
   "metadata": {},
   "source": [
    "### Read Data from \"record.json\" file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ed05661e",
   "metadata": {},
   "outputs": [],
   "source": [
    "fd = open(\"record.json\", 'r')\n",
    "txt = fd.read()\n",
    "fd.close()\n",
    "\n",
    "records = json.loads(txt)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "22803d0a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'12760000': {'Product': 'Wheat',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 96,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 378},\n",
       " '12760001': {'Product': 'Rye',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 117,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 18},\n",
       " '12760002': {'Product': 'Oats',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 253,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 494},\n",
       " '12760003': {'Product': 'Corn',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 84,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 500},\n",
       " '12760004': {'Product': 'Barley',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 140,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 327},\n",
       " '12760005': {'Product': 'Buckwheat',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 70,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 191},\n",
       " '12760006': {'Product': 'Rice',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 50,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 428},\n",
       " '12760007': {'Product': 'Bread',\n",
       "  'Company': 'Mondelez India Foods Pvt. Ltd.',\n",
       "  'Quantity': 277,\n",
       "  'Type': 'Grain ProductsBaked Goods',\n",
       "  'Price': 83},\n",
       " '12760008': {'Product': 'Rolls',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 196,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 265},\n",
       " '12760009': {'Product': 'Buns',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 277,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 251},\n",
       " '12760010': {'Product': 'Cakes',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 35,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 234},\n",
       " '12760011': {'Product': 'Cookies',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 74,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 338},\n",
       " '12760012': {'Product': 'Cereal',\n",
       "  'Company': 'Mondelez India Foods Pvt. Ltd.',\n",
       "  'Quantity': 98,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 262},\n",
       " '12760013': {'Product': 'Muesli',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 77,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 455},\n",
       " '12760014': {'Product': 'Popcorn',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 235,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 47},\n",
       " '12760015': {'Product': 'Corn flakes',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 282,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 46},\n",
       " '12760016': {'Product': 'Oat flakes',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 214,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 44},\n",
       " '12760017': {'Product': 'Wheat flakes',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 56,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 359},\n",
       " '12760018': {'Product': 'Rice flakes',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 216,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 30},\n",
       " '12760019': {'Product': 'Pasta',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 295,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 46},\n",
       " '12760020': {'Product': 'Pies',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 297,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 141},\n",
       " '12760021': {'Product': 'Macaroni',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 156,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 429},\n",
       " '12760022': {'Product': 'Noodles',\n",
       "  'Company': 'Mondelez India Foods Pvt. Ltd.',\n",
       "  'Quantity': 226,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 447},\n",
       " '12760023': {'Product': 'Spaghetti',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 295,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 248},\n",
       " '12760024': {'Product': 'Vermicelli',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 153,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 452},\n",
       " '12760025': {'Product': 'Ravioli',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 159,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 456},\n",
       " '12760026': {'Product': 'Dumplings',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 184,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 437},\n",
       " '12760027': {'Product': 'Flour',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 118,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 332},\n",
       " '12760028': {'Product': 'Dough',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 77,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 45},\n",
       " '12760029': {'Product': 'Batter',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 243,\n",
       "  'Type': 'Grain Products',\n",
       "  'Price': 15},\n",
       " '12760030': {'Product': 'Bread',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 146,\n",
       "  'Type': 'Grain ProductsBaked Goods',\n",
       "  'Price': 308},\n",
       " '12760031': {'Product': 'White bread',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 80,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 177},\n",
       " '12760032': {'Product': 'Roll',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 78,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 500},\n",
       " '12760033': {'Product': 'Bread roll',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 222,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 402},\n",
       " '12760034': {'Product': 'Sesame roll',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 181,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 500},\n",
       " '12760035': {'Product': 'Poppy seed roll',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 117,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 268},\n",
       " '12760036': {'Product': 'Cinnamon roll',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 82,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 306},\n",
       " '12760037': {'Product': 'Chocolate cake',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 248,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 227},\n",
       " '12760038': {'Product': 'Chocolate chip cake',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 217,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 286},\n",
       " '12760039': {'Product': 'Chocolate layer cake',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 253,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 118},\n",
       " '12760040': {'Product': 'Chocolate frosting cake',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 76,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 306},\n",
       " '12760041': {'Product': 'Honey cake',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 96,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 406},\n",
       " '12760042': {'Product': 'Pie',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 153,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 43},\n",
       " '12760043': {'Product': 'Apple pie',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 209,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 56},\n",
       " '12760044': {'Product': 'Blueberry pie',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 52,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 452},\n",
       " '12760045': {'Product': 'Cherry pie',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 92,\n",
       "  'Type': 'Baked Goods',\n",
       "  'Price': 91},\n",
       " '12760046': {'Product': 'Milk',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 225,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 258},\n",
       " '12760047': {'Product': 'Whole milk',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 140,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 275},\n",
       " '12760048': {'Product': 'Skim milk',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 127,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 86},\n",
       " '12760049': {'Product': 'Low-fat milk',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 116,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 102},\n",
       " '12760050': {'Product': 'Nonfat milk',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 188,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 68},\n",
       " '12760051': {'Product': 'Pasteurized milk',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 168,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 496},\n",
       " '12760052': {'Product': 'Cheese',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 160,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 256},\n",
       " '12760053': {'Product': 'Swiss cheese',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 91,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 270},\n",
       " '12760054': {'Product': 'Parmesan',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 126,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 23},\n",
       " '12760055': {'Product': 'Cheddar',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 210,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 37},\n",
       " '12760056': {'Product': 'Vanilla ice cream',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 274,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 51},\n",
       " '12760057': {'Product': 'Chocolate ice cream',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 96,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 314},\n",
       " '12760058': {'Product': 'Fruit ice',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 137,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 330},\n",
       " '12760059': {'Product': 'Strawberry ice cream',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 72,\n",
       "  'Type': 'Milk Products',\n",
       "  'Price': 89},\n",
       " '12760060': {'Product': 'Lemon',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 160,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 451},\n",
       " '12760061': {'Product': 'Lime',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 196,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 372},\n",
       " '12760062': {'Product': 'Orange',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 135,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 153},\n",
       " '12760063': {'Product': 'Tangerine',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 103,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 447},\n",
       " '12760064': {'Product': 'Grapefruit',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 178,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 136},\n",
       " '12760065': {'Product': 'Banana',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 293,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 423},\n",
       " '12760066': {'Product': 'Kiwi',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 245,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 436},\n",
       " '12760067': {'Product': 'Pineapple',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 133,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 58},\n",
       " '12760068': {'Product': 'Olive',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 262,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 71},\n",
       " '12760069': {'Product': 'Fig',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 88,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 352},\n",
       " '12760070': {'Product': 'Papaya',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 207,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 134},\n",
       " '12760071': {'Product': 'Mango',\n",
       "  'Company': 'Mondelez India Foods Pvt. Ltd.',\n",
       "  'Quantity': 296,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 385},\n",
       " '12760072': {'Product': 'Avocado',\n",
       "  'Company': 'Mondelez India Foods Pvt. Ltd.',\n",
       "  'Quantity': 170,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 116},\n",
       " '12760073': {'Product': 'Coconut',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 203,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 199},\n",
       " '12760074': {'Product': 'Persimmon',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 235,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 463},\n",
       " '12760075': {'Product': 'Pomegranate',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 184,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 417},\n",
       " '12760076': {'Product': 'Melon',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 111,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 351},\n",
       " '12760077': {'Product': 'Watermelon',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 244,\n",
       "  'Type': 'Fruits',\n",
       "  'Price': 120},\n",
       " '12760078': {'Product': 'Sweet pepper',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 280,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 358},\n",
       " '12760079': {'Product': 'Red pepper',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 83,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 476},\n",
       " '12760080': {'Product': 'Green pepper',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 159,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 176},\n",
       " '12760081': {'Product': 'Yellow pepper',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 266,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 213},\n",
       " '12760082': {'Product': 'Paprika',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 223,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 256},\n",
       " '12760083': {'Product': 'Hot pepper',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 106,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 109},\n",
       " '12760084': {'Product': 'Chili pepper',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 235,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 454},\n",
       " '12760085': {'Product': 'Cabbage',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 153,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 457},\n",
       " '12760086': {'Product': 'Cauliflower',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 230,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 322},\n",
       " '12760087': {'Product': 'Broccoli',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 250,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 307},\n",
       " '12760088': {'Product': 'Brussels sprouts',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 194,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 105},\n",
       " '12760089': {'Product': 'Collard',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 112,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 264},\n",
       " '12760090': {'Product': 'Kale',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 61,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 127},\n",
       " '12760091': {'Product': 'Kohlrabi',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 119,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 371},\n",
       " '12760092': {'Product': 'Mushrooms',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 121,\n",
       "  'Type': 'Vegetables',\n",
       "  'Price': 167},\n",
       " '12760093': {'Product': 'Mineral water',\n",
       "  'Company': 'Mondelez India Foods Pvt. Ltd.',\n",
       "  'Quantity': 252,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 459},\n",
       " '12760094': {'Product': 'Spring water',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 293,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 45},\n",
       " '12760095': {'Product': 'Soft drink',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 160,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 94},\n",
       " '12760096': {'Product': 'Soda water',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 214,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 145},\n",
       " '12760097': {'Product': 'Lemonade',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 77,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 310},\n",
       " '12760098': {'Product': 'Beer',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 65,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 75},\n",
       " '12760099': {'Product': 'Ale',\n",
       "  'Company': 'LT Foods Ltd.',\n",
       "  'Quantity': 244,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 235},\n",
       " '12760100': {'Product': 'Wine',\n",
       "  'Company': 'Mondelez India Foods Pvt. Ltd.',\n",
       "  'Quantity': 110,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 110},\n",
       " '12760101': {'Product': 'Red wine',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 82,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 329},\n",
       " '12760102': {'Product': 'White wine',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 122,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 132},\n",
       " '12760103': {'Product': 'Champagne',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 139,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 322},\n",
       " '12760104': {'Product': 'Vodka',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 179,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 279},\n",
       " '12760105': {'Product': 'Cognac',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 202,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 360},\n",
       " '12760106': {'Product': 'Brandy',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 206,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 374},\n",
       " '12760107': {'Product': 'Whiskey',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 233,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 396},\n",
       " '12760108': {'Product': 'Whisky',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 53,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 159},\n",
       " '12760109': {'Product': 'Gin',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 132,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 10},\n",
       " '12760110': {'Product': 'Rum',\n",
       "  'Company': 'Nestle India Ltd.',\n",
       "  'Quantity': 295,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 334},\n",
       " '12760111': {'Product': 'Cocktail',\n",
       "  'Company': 'Venkys India Ltd.',\n",
       "  'Quantity': 218,\n",
       "  'Type': 'Drinks',\n",
       "  'Price': 289},\n",
       " '12760112': {'Product': 'Candy',\n",
       "  'Company': 'Hindustan Unilever Ltd.',\n",
       "  'Quantity': 53,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 258},\n",
       " '12760113': {'Product': 'Toffee',\n",
       "  'Company': 'Britannia Industries Ltd.',\n",
       "  'Quantity': 192,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 88},\n",
       " '12760114': {'Product': 'Fudge',\n",
       "  'Company': 'MTR Foods Pvt. Ltd.',\n",
       "  'Quantity': 117,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 350},\n",
       " '12760115': {'Product': 'Caramels',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 182,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 158},\n",
       " '12760116': {'Product': 'Mint drops',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 104,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 73},\n",
       " '12760117': {'Product': 'Jelly beans',\n",
       "  'Company': 'Kohinoor Foods Ltd.',\n",
       "  'Quantity': 248,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 10},\n",
       " '12760118': {'Product': 'Lollipop',\n",
       "  'Company': 'Parle Agro Pvt. Ltd.',\n",
       "  'Quantity': 201,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 15},\n",
       " '12760119': {'Product': 'Bonbons',\n",
       "  'Company': 'McCain Foods India Pvt. Ltd.',\n",
       "  'Quantity': 212,\n",
       "  'Type': 'Sweets',\n",
       "  'Price': 10}}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "records"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "a0ff060b",
   "metadata": {},
   "source": [
    "### Update, Add and Delete Items in Inventory"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "8658200e",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "***************** \n",
      "SELECT AN OPTION\n",
      "*****************\n",
      "1. UPDATE ITEM\n",
      "2. ADD NEW ITEM\n",
      "3. DELETE ITEM\n",
      "4. EXIT\n",
      "Print enter your choice (1/2/3/4): 1\n",
      "Please enter the product id: 12760041\n",
      "Please enter the product quantity: 10\n",
      "Please enter the product price: 150\n",
      "\n",
      "\n",
      "***************** \n",
      "SELECT AN OPTION\n",
      "*****************\n",
      "1. UPDATE ITEM\n",
      "2. ADD NEW ITEM\n",
      "3. DELETE ITEM\n",
      "4. EXIT\n",
      "Print enter your choice (1/2/3/4): 2\n",
      "Enter product id: 12760120\n",
      "Enter product name: Chocobar\n",
      "Enter company name: Britannia Industries Ltd.\n",
      "Enter product quantity: 200\n",
      "Enter product type: Sweets\n",
      "Enter product price: 25\n",
      "\n",
      "\n",
      "***************** \n",
      "SELECT AN OPTION\n",
      "*****************\n",
      "1. UPDATE ITEM\n",
      "2. ADD NEW ITEM\n",
      "3. DELETE ITEM\n",
      "4. EXIT\n",
      "Print enter your choice (1/2/3/4): 3\n",
      "Enter product id: 12760120\n",
      "\n",
      "\n",
      "***************** \n",
      "SELECT AN OPTION\n",
      "*****************\n",
      "1. UPDATE ITEM\n",
      "2. ADD NEW ITEM\n",
      "3. DELETE ITEM\n",
      "4. EXIT\n",
      "Print enter your choice (1/2/3/4): 5\n",
      "\n",
      "PLEASE ENTER A VALID OPTION!!\n",
      "\n",
      "\n",
      "***************** \n",
      "SELECT AN OPTION\n",
      "*****************\n",
      "1. UPDATE ITEM\n",
      "2. ADD NEW ITEM\n",
      "3. DELETE ITEM\n",
      "4. EXIT\n",
      "Print enter your choice (1/2/3/4): 4\n",
      "Thank you!!\n"
     ]
    }
   ],
   "source": [
    "flag = True\n",
    "while(flag):\n",
    "    \n",
    "    print()\n",
    "    print()\n",
    "    print(\"*\"*17, \"\\nSELECT AN OPTION\") \n",
    "    print(\"*\"*17)\n",
    "    print(\"1. UPDATE ITEM\\n2. ADD NEW ITEM\\n3. DELETE ITEM\\n4. EXIT\")\n",
    "    \n",
    "    option = int(input(\"Print enter your choice (1/2/3/4): \"))\n",
    "    \n",
    "    if option==1:\n",
    "        prod_id = input(\"Please enter the product id: \")\n",
    "        qty = int(input(\"Please enter the product quantity: \"))\n",
    "        price = int(input(\"Please enter the product price: \"))\n",
    "        records[prod_id]['Quantity'] = records[prod_id]['Quantity'] + qty\n",
    "        records[prod_id]['Price'] = price\n",
    "        \n",
    "    elif option==2:\n",
    "        prod_id = input(\"Enter product id: \")\n",
    "        if prod_id in records:\n",
    "            print(\"Item already present in inventory. Enter 1 to update the item!!\")\n",
    "            continue\n",
    "        prod_name = input(\"Enter product name: \")\n",
    "        comp_name = input(\"Enter company name: \")\n",
    "        qty = int(input(\"Enter product quantity: \"))\n",
    "        types = input(\"Enter product type: \")\n",
    "        price = int(input(\"Enter product price: \"))\n",
    "        records[prod_id] = {'Product': prod_name, 'Company': comp_name, 'Quantity': qty, 'Type': types, 'Price': price}\n",
    "    \n",
    "    elif option==3:\n",
    "        prod_id = input(\"Enter product id: \")\n",
    "        if prod_id not in records:\n",
    "            print(\"Entered product id doesnot exist!!\")\n",
    "            continue\n",
    "        del records[prod_id]\n",
    "    \n",
    "    elif option==4:\n",
    "        print(\"Thank you!!\")\n",
    "        flag = False\n",
    "    \n",
    "    else:\n",
    "        print(\"\\nPLEASE ENTER A VALID OPTION!!\")\n",
    "        "
   ]
  },
  {
   "cell_type": "markdown",
   "id": "1ed76493",
   "metadata": {},
   "source": [
    "### Update Items in \"records.json\" file"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "b95b820a",
   "metadata": {},
   "outputs": [],
   "source": [
    "js = json.dumps(records)\n",
    "\n",
    "fd = open(\"record.json\",'w')\n",
    "fd.write(js)\n",
    "fd.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "96f9e95e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}