{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "mt1Mw60b6z8A"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "!pip install pymongo"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "9kRBPHRedNY-",
        "outputId": "1042a2c1-0bba-4ae8-8dad-f9e074a338d3"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Requirement already satisfied: pymongo in /usr/local/lib/python3.10/dist-packages (4.8.0)\n",
            "Requirement already satisfied: dnspython<3.0.0,>=1.16.0 in /usr/local/lib/python3.10/dist-packages (from pymongo) (2.6.1)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "Ssn3vPsUCBhX"
      },
      "outputs": [],
      "source": [
        "from pymongo import MongoClient\n",
        "client = MongoClient(\"mongodb+srv://chhatrapaligenerate:AVJAeBd7QBYnboWc@cluster0.r3xdoxt.mongodb.net\")"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "db = client['sahl']\n",
        "orders_collection = db['orders']\n",
        "stores_collection = db['stores']\n",
        "brands_collection=db['brands']"
      ],
      "metadata": {
        "id": "UTVJLdQBc46S"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "orders_projection = {\n",
        "    'data.order.store':1,\n",
        "    'data.order.next_state':1,\n",
        "    'data.order.next_states':1,\n",
        "    'data.order.details.order_type':1,\n",
        "    'data.order.details.id':1,\n",
        "    'data.order.details.ext_platforms':1,\n",
        "    'data.order.details.discount':1,\n",
        "    'data.order.details.item_level_total_charges':1,\n",
        "    'data.order.details.item_level_total_taxes':1,\n",
        "    'data.order.details.item_taxes':1,\n",
        "    'data.order.details.order_level_total_charges':1,\n",
        "    'data.order.details.total_without_taxes':1,\n",
        "    \"data.order.details.order_state\":1,\n",
        "    \"data.order.details.order_subtotal\":1,\n",
        "    \"data.order.details.order_total\":1,\n",
        "    \"data.order.details.state\":1,\n",
        "    \"data.order.details.taxes\":1,\n",
        "    \"data.order.details.charges\":1,\n",
        "    \"data.order.details.total_charges\":1,\n",
        "    \"data.order.details.total_external_discount\":1,\n",
        "    \"data.order.details.total_taxes\":1,\n",
        "    \"data.order.details.total_tax_percentage\":1,\n",
        "    \"data.order.details.channel\":1,\n",
        "    \"data.order.details.created\":1,\n",
        "    \"data.order.details.delivery_datetime\":1,\n",
        "    \"data.order.details.orderType_label\":1,\n",
        "    \"data.order.details.qty\":1,\n",
        "    \"data.order.details.invoiceNo\":1,\n",
        "    \"data.order.details.total_charges\":1,\n",
        "    \"data.order.payment\":1,\n",
        "    \"data.order.details.created\":1,\n",
        "    \"store_id\":1,\n",
        "    \"orderCreatedAt\":1,\n",
        "    \"isOfflineOrder\":1,\n",
        "    \"createdAt\":1,\n",
        "    \"updatedAt\":1,\n",
        "\n",
        "}"
      ],
      "metadata": {
        "id": "wMe0jml8c6FE"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "stores_projection={\n",
        "    \"zip_codes\":1,\n",
        "    \"geo_longitude\":1,\n",
        "    'geo_latitude':1,\n",
        "    'active':1,\n",
        "    'isAutoAccept':1,\n",
        "    'auto_accept_in_second':1,\n",
        "    'ordering_enabled':1,\n",
        "    'included_platforms':1,\n",
        "    'excluded_platforms':1,\n",
        "    'isDeleted':1,\n",
        "    'isActive':1,\n",
        "    'islive':1,\n",
        "    'name':1,\n",
        "    'city':1,\n",
        "    'ref_id':1,\n",
        "    'min_delivery_time':1,\n",
        "    'min_order_value':1,\n",
        "    'platform_data':1,\n",
        "    'status':1,\n",
        "    'brandId':1,\n",
        "    'userId':1,\n",
        "    'region':1,\n",
        "    'createdAt':1,\n",
        "    'updatedAt':1,\n",
        "    'platform_actions':1,\n",
        "    'email':1,\n",
        "    'customQuantityEnabled':1,\n",
        "    'itemPriceIncludesTax':1,\n",
        "    'isSahlOrder':1,\n",
        "}"
      ],
      "metadata": {
        "id": "IVmLyP4XgJS5"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "brands_projection ={\n",
        "    '_id':1,\n",
        "    'isApproved':1,\n",
        "    'name':1,\n",
        "    'key':1,\n",
        "    'createdAt':1,\n",
        "    'updatedAt':1,\n",
        "    'region':1,\n",
        "    'countryCode':1,\n",
        "    'currency':1\n",
        "}"
      ],
      "metadata": {
        "id": "I5MTX0w2gMEP"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "orders_data = list(orders_collection.find({},orders_projection))"
      ],
      "metadata": {
        "id": "BajNx3y8gNgp"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "stores_data = list(stores_collection.find({},stores_projection))"
      ],
      "metadata": {
        "id": "oNxAB6pRgQJ2"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "store_dict = {str(store['_id']): store.get('name',\"not_found\") for store in stores_data}"
      ],
      "metadata": {
        "id": "oU2-HkFGmZMw"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "from bson.objectid import ObjectId\n",
        "import math"
      ],
      "metadata": {
        "id": "-DdVDs98nv6P"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "from datetime import datetime"
      ],
      "metadata": {
        "id": "lAY9cWZvwJXC"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "brands_data = list(brands_collection.find({},brands_projection))"
      ],
      "metadata": {
        "id": "14QKsF7UgQaA"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "orders_details = []\n",
        "for order in orders_data:\n",
        "    try:\n",
        "      order_created_at = order.get('orderCreatedAt')\n",
        "      timestamp_s = order_created_at / 1000\n",
        "      dt = datetime.fromtimestamp(timestamp_s)\n",
        "\n",
        "      date_only = dt.date()\n",
        "    except:\n",
        "      continue\n",
        "    order_detail = {\n",
        "        'date': date_only,\n",
        "        'store_id': str(order['store_id']),\n",
        "        'order_subtotal': order['data'][0]['order']['details']['order_total']\n",
        "    }\n",
        "    orders_details.append(order_detail)"
      ],
      "metadata": {
        "id": "tsNf1YdjwHIV"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "from collections import defaultdict"
      ],
      "metadata": {
        "id": "J4OofItQwmzm"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "store_order_counts = defaultdict(lambda: defaultdict(int))\n",
        "\n",
        "# Populate the result dictionary\n",
        "for order in orders_details:\n",
        "    store_id = order['store_id']\n",
        "    store_name = store_dict.get(store_id)\n",
        "    if store_name:\n",
        "        date_str = order['date'].strftime('%Y-%m-%d')  # Format date as string\n",
        "\n",
        "        # Increment the count for the given store and date\n",
        "        store_order_counts[store_name][date_str] += 1\n",
        "\n",
        "# Convert defaultdict to dict for readability\n",
        "store_order_counts = {store: dict(dates) for store, dates in store_order_counts.items()}\n"
      ],
      "metadata": {
        "id": "QfQl1zovwKzo"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "store_order_counts"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "dCR3LYnxwQxb",
        "outputId": "5cf749ca-7e50-4262-ee84-91b2013cca0a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'WeDesi': {'2024-01-05': 2, '2024-02-06': 3},\n",
              " '8 miles': {'2024-01-06': 3,\n",
              "  '2024-01-08': 24,\n",
              "  '2024-01-09': 13,\n",
              "  '2024-01-10': 1,\n",
              "  '2024-01-11': 9,\n",
              "  '2024-01-25': 1,\n",
              "  '2024-02-06': 5,\n",
              "  '2024-02-21': 1,\n",
              "  '2024-03-12': 3,\n",
              "  '2024-05-31': 16,\n",
              "  '2024-06-05': 8},\n",
              " 'lebanese-house-dubai': {'2024-01-08': 20,\n",
              "  '2024-01-09': 4,\n",
              "  '2024-01-10': 1,\n",
              "  '2024-01-11': 55,\n",
              "  '2024-01-12': 5,\n",
              "  '2024-01-17': 1,\n",
              "  '2024-01-23': 6,\n",
              "  '2024-01-24': 1,\n",
              "  '2024-02-01': 1,\n",
              "  '2024-02-05': 10,\n",
              "  '2024-02-06': 2},\n",
              " 'Cedar Restaurant & Grill': {'2024-01-08': 8, '2024-02-06': 1},\n",
              " 'LEMAR Resturant & Cafe': {'2024-01-08': 5,\n",
              "  '2024-01-09': 33,\n",
              "  '2024-01-10': 59,\n",
              "  '2024-01-11': 17,\n",
              "  '2024-01-12': 25,\n",
              "  '2024-01-16': 57,\n",
              "  '2024-01-17': 44,\n",
              "  '2024-01-18': 1,\n",
              "  '2024-01-19': 4,\n",
              "  '2024-01-20': 2,\n",
              "  '2024-01-21': 5,\n",
              "  '2024-01-22': 1,\n",
              "  '2024-01-23': 1,\n",
              "  '2024-01-24': 3,\n",
              "  '2024-01-25': 3,\n",
              "  '2024-01-26': 3,\n",
              "  '2024-01-29': 2,\n",
              "  '2024-01-30': 2,\n",
              "  '2024-01-31': 2,\n",
              "  '2024-02-01': 2,\n",
              "  '2024-02-05': 2,\n",
              "  '2024-03-15': 1,\n",
              "  '2024-03-22': 6,\n",
              "  '2024-05-10': 10},\n",
              " 'test foir ai': {'2024-01-08': 1,\n",
              "  '2024-01-18': 1,\n",
              "  '2024-01-20': 1,\n",
              "  '2024-01-31': 30,\n",
              "  '2024-02-01': 100,\n",
              "  '2024-02-08': 8,\n",
              "  '2024-07-10': 1},\n",
              " 'Apna Punjab Paratha': {'2024-01-09': 3,\n",
              "  '2024-01-10': 1,\n",
              "  '2024-01-11': 35,\n",
              "  '2024-01-12': 7,\n",
              "  '2024-01-16': 57,\n",
              "  '2024-01-17': 12,\n",
              "  '2024-01-18': 39,\n",
              "  '2024-01-19': 15,\n",
              "  '2024-01-20': 14,\n",
              "  '2024-01-22': 15,\n",
              "  '2024-01-23': 2,\n",
              "  '2024-01-24': 22,\n",
              "  '2024-01-25': 9,\n",
              "  '2024-01-27': 1,\n",
              "  '2024-01-29': 6,\n",
              "  '2024-01-30': 1,\n",
              "  '2024-01-31': 7,\n",
              "  '2024-02-01': 5,\n",
              "  '2024-02-02': 3,\n",
              "  '2024-02-03': 21,\n",
              "  '2024-02-05': 16,\n",
              "  '2024-02-06': 35,\n",
              "  '2024-02-07': 10,\n",
              "  '2024-02-08': 3,\n",
              "  '2024-02-09': 11,\n",
              "  '2024-02-10': 5,\n",
              "  '2024-02-12': 1,\n",
              "  '2024-02-13': 6,\n",
              "  '2024-02-14': 18,\n",
              "  '2024-02-15': 13,\n",
              "  '2024-02-16': 11,\n",
              "  '2024-02-19': 1,\n",
              "  '2024-02-21': 8,\n",
              "  '2024-02-22': 15,\n",
              "  '2024-02-23': 4,\n",
              "  '2024-02-26': 6,\n",
              "  '2024-02-27': 6,\n",
              "  '2024-02-28': 4,\n",
              "  '2024-02-29': 2,\n",
              "  '2024-03-01': 10,\n",
              "  '2024-03-02': 1,\n",
              "  '2024-03-11': 3,\n",
              "  '2024-03-12': 4,\n",
              "  '2024-03-14': 1,\n",
              "  '2024-03-15': 12,\n",
              "  '2024-03-19': 17,\n",
              "  '2024-03-20': 19,\n",
              "  '2024-03-21': 5,\n",
              "  '2024-03-24': 1,\n",
              "  '2024-03-25': 1,\n",
              "  '2024-03-28': 6,\n",
              "  '2024-03-29': 4,\n",
              "  '2024-04-01': 43,\n",
              "  '2024-04-02': 57,\n",
              "  '2024-04-03': 39,\n",
              "  '2024-04-04': 34,\n",
              "  '2024-04-05': 7,\n",
              "  '2024-04-08': 2,\n",
              "  '2024-04-09': 8,\n",
              "  '2024-04-10': 7,\n",
              "  '2024-04-11': 4,\n",
              "  '2024-04-12': 2,\n",
              "  '2024-04-16': 3,\n",
              "  '2024-05-03': 6,\n",
              "  '2024-05-06': 12,\n",
              "  '2024-05-10': 11,\n",
              "  '2024-05-13': 24,\n",
              "  '2024-05-14': 2,\n",
              "  '2024-05-15': 1,\n",
              "  '2024-05-17': 17,\n",
              "  '2024-05-18': 11,\n",
              "  '2024-05-20': 14,\n",
              "  '2024-05-24': 25,\n",
              "  '2024-05-27': 1,\n",
              "  '2024-05-28': 1,\n",
              "  '2024-06-03': 1,\n",
              "  '2024-06-05': 11,\n",
              "  '2024-06-06': 4,\n",
              "  '2024-06-07': 2,\n",
              "  '2024-06-20': 1,\n",
              "  '2024-07-31': 4},\n",
              " 'Verjus Bites': {'2024-01-09': 2, '2024-01-11': 1, '2024-01-12': 7},\n",
              " 'Super Foods': {'2024-01-10': 10,\n",
              "  '2024-01-11': 1,\n",
              "  '2024-01-16': 9,\n",
              "  '2024-01-18': 4},\n",
              " 'Baba Grill Restauarnt': {'2024-01-27': 1},\n",
              " 'Makaran': {'2024-02-05': 13,\n",
              "  '2024-02-06': 24,\n",
              "  '2024-02-07': 47,\n",
              "  '2024-02-08': 70,\n",
              "  '2024-02-09': 24,\n",
              "  '2024-02-10': 7,\n",
              "  '2024-02-12': 48,\n",
              "  '2024-02-13': 34,\n",
              "  '2024-02-14': 22,\n",
              "  '2024-02-15': 11,\n",
              "  '2024-02-16': 1,\n",
              "  '2024-02-19': 1,\n",
              "  '2024-02-20': 8,\n",
              "  '2024-02-21': 1,\n",
              "  '2024-02-22': 10,\n",
              "  '2024-02-23': 23,\n",
              "  '2024-02-26': 1,\n",
              "  '2024-02-27': 11,\n",
              "  '2024-02-28': 1,\n",
              "  '2024-02-29': 10,\n",
              "  '2024-03-01': 54,\n",
              "  '2024-03-02': 45,\n",
              "  '2024-03-05': 35,\n",
              "  '2024-03-06': 3,\n",
              "  '2024-03-08': 5,\n",
              "  '2024-03-09': 10,\n",
              "  '2024-03-11': 11,\n",
              "  '2024-03-12': 14,\n",
              "  '2024-03-14': 28,\n",
              "  '2024-03-15': 14,\n",
              "  '2024-03-20': 28,\n",
              "  '2024-03-21': 7,\n",
              "  '2024-03-26': 2,\n",
              "  '2024-03-27': 4,\n",
              "  '2024-03-28': 5,\n",
              "  '2024-04-04': 29,\n",
              "  '2024-04-05': 5,\n",
              "  '2024-04-06': 1,\n",
              "  '2024-04-09': 14,\n",
              "  '2024-04-10': 4,\n",
              "  '2024-04-11': 10,\n",
              "  '2024-04-12': 4,\n",
              "  '2024-04-15': 13,\n",
              "  '2024-04-17': 3,\n",
              "  '2024-04-18': 3,\n",
              "  '2024-04-23': 6,\n",
              "  '2024-04-24': 7,\n",
              "  '2024-04-26': 7,\n",
              "  '2024-04-29': 6,\n",
              "  '2024-04-30': 23,\n",
              "  '2024-05-01': 6,\n",
              "  '2024-05-02': 1,\n",
              "  '2024-05-09': 2,\n",
              "  '2024-05-10': 5,\n",
              "  '2024-05-13': 1,\n",
              "  '2024-05-14': 2,\n",
              "  '2024-05-27': 9,\n",
              "  '2024-05-28': 13,\n",
              "  '2024-05-29': 6,\n",
              "  '2024-05-30': 10,\n",
              "  '2024-06-03': 16,\n",
              "  '2024-06-04': 14,\n",
              "  '2024-06-05': 3,\n",
              "  '2024-06-10': 1,\n",
              "  '2024-06-11': 2,\n",
              "  '2024-06-14': 1,\n",
              "  '2024-06-18': 1,\n",
              "  '2024-07-11': 1},\n",
              " 'Kutumbari Resturant': {'2024-02-05': 10,\n",
              "  '2024-02-06': 26,\n",
              "  '2024-02-07': 1,\n",
              "  '2024-02-09': 9,\n",
              "  '2024-02-10': 3,\n",
              "  '2024-02-11': 2,\n",
              "  '2024-02-12': 10,\n",
              "  '2024-02-13': 24,\n",
              "  '2024-02-14': 10,\n",
              "  '2024-02-15': 12,\n",
              "  '2024-02-17': 1,\n",
              "  '2024-02-19': 1,\n",
              "  '2024-02-20': 9,\n",
              "  '2024-02-21': 19,\n",
              "  '2024-02-22': 7,\n",
              "  '2024-02-23': 24,\n",
              "  '2024-02-26': 60,\n",
              "  '2024-02-27': 30,\n",
              "  '2024-02-28': 50,\n",
              "  '2024-02-29': 24,\n",
              "  '2024-03-01': 27,\n",
              "  '2024-03-02': 10,\n",
              "  '2024-03-03': 2,\n",
              "  '2024-03-04': 25,\n",
              "  '2024-03-05': 26,\n",
              "  '2024-03-06': 4,\n",
              "  '2024-03-08': 39,\n",
              "  '2024-03-11': 23,\n",
              "  '2024-03-12': 15,\n",
              "  '2024-03-21': 13,\n",
              "  '2024-03-22': 3,\n",
              "  '2024-03-26': 7,\n",
              "  '2024-03-27': 35,\n",
              "  '2024-03-28': 35,\n",
              "  '2024-03-29': 6,\n",
              "  '2024-04-03': 1,\n",
              "  '2024-04-11': 9,\n",
              "  '2024-04-12': 3,\n",
              "  '2024-04-15': 1,\n",
              "  '2024-04-16': 3,\n",
              "  '2024-04-22': 1,\n",
              "  '2024-04-23': 1,\n",
              "  '2024-04-24': 2,\n",
              "  '2024-04-25': 1,\n",
              "  '2024-04-26': 39,\n",
              "  '2024-04-29': 3,\n",
              "  '2024-04-30': 9,\n",
              "  '2024-05-30': 10,\n",
              "  '2024-05-31': 22,\n",
              "  '2024-06-03': 24,\n",
              "  '2024-06-04': 19,\n",
              "  '2024-06-05': 7,\n",
              "  '2024-06-06': 1,\n",
              "  '2024-06-07': 15,\n",
              "  '2024-06-10': 12,\n",
              "  '2024-06-11': 39,\n",
              "  '2024-06-12': 33,\n",
              "  '2024-06-13': 16,\n",
              "  '2024-06-14': 70,\n",
              "  '2024-06-15': 59,\n",
              "  '2024-06-17': 6,\n",
              "  '2024-06-18': 5,\n",
              "  '2024-06-19': 3,\n",
              "  '2024-06-21': 4,\n",
              "  '2024-06-24': 11,\n",
              "  '2024-06-27': 1,\n",
              "  '2024-07-01': 1,\n",
              "  '2024-07-02': 1,\n",
              "  '2024-07-03': 11,\n",
              "  '2024-07-04': 15,\n",
              "  '2024-07-05': 4,\n",
              "  '2024-07-08': 9,\n",
              "  '2024-07-09': 6,\n",
              "  '2024-07-11': 19,\n",
              "  '2024-07-12': 2,\n",
              "  '2024-07-22': 2,\n",
              "  '2024-07-23': 8,\n",
              "  '2024-07-26': 7,\n",
              "  '2024-07-29': 4},\n",
              " 'The Barnyard Co': {'2024-02-07': 2,\n",
              "  '2024-02-08': 6,\n",
              "  '2024-02-19': 3,\n",
              "  '2024-02-20': 8},\n",
              " 'We Desi 2': {'2024-02-09': 27, '2024-02-10': 4, '2024-02-12': 1},\n",
              " 'Golden Chicken': {'2024-02-13': 1,\n",
              "  '2024-02-27': 10,\n",
              "  '2024-02-28': 21,\n",
              "  '2024-03-01': 29,\n",
              "  '2024-03-02': 1},\n",
              " 'Sushiz Chinese': {'2024-02-15': 10,\n",
              "  '2024-02-16': 4,\n",
              "  '2024-02-26': 5,\n",
              "  '2024-06-05': 2},\n",
              " 'Baba Grill Restaurant': {'2024-02-15': 4, '2024-07-03': 1},\n",
              " 'Monasabat jibla': {'2024-02-19': 3},\n",
              " 'Betawi-JLT': {'2024-02-19': 39,\n",
              "  '2024-02-20': 56,\n",
              "  '2024-02-21': 31,\n",
              "  '2024-02-22': 48,\n",
              "  '2024-02-23': 37,\n",
              "  '2024-02-24': 104,\n",
              "  '2024-02-25': 15,\n",
              "  '2024-02-26': 72,\n",
              "  '2024-02-27': 28,\n",
              "  '2024-02-28': 35,\n",
              "  '2024-02-29': 127,\n",
              "  '2024-03-01': 105,\n",
              "  '2024-03-02': 44,\n",
              "  '2024-03-04': 62,\n",
              "  '2024-03-06': 112,\n",
              "  '2024-03-08': 201,\n",
              "  '2024-03-09': 17,\n",
              "  '2024-03-11': 87,\n",
              "  '2024-03-12': 65,\n",
              "  '2024-03-13': 91,\n",
              "  '2024-03-14': 115,\n",
              "  '2024-03-15': 104,\n",
              "  '2024-03-16': 29,\n",
              "  '2024-03-17': 22,\n",
              "  '2024-03-18': 58,\n",
              "  '2024-03-19': 38,\n",
              "  '2024-03-20': 134,\n",
              "  '2024-03-21': 89,\n",
              "  '2024-03-22': 73,\n",
              "  '2024-03-23': 10,\n",
              "  '2024-03-26': 40,\n",
              "  '2024-03-27': 389,\n",
              "  '2024-03-28': 60,\n",
              "  '2024-03-29': 63,\n",
              "  '2024-03-30': 4,\n",
              "  '2024-04-01': 32,\n",
              "  '2024-04-02': 61,\n",
              "  '2024-04-03': 52,\n",
              "  '2024-04-04': 39,\n",
              "  '2024-04-05': 5,\n",
              "  '2024-04-06': 2,\n",
              "  '2024-04-07': 2,\n",
              "  '2024-04-08': 49,\n",
              "  '2024-04-09': 60,\n",
              "  '2024-04-10': 6,\n",
              "  '2024-04-11': 42,\n",
              "  '2024-04-12': 26,\n",
              "  '2024-04-15': 4,\n",
              "  '2024-04-16': 33,\n",
              "  '2024-04-17': 95,\n",
              "  '2024-04-18': 73,\n",
              "  '2024-04-19': 117,\n",
              "  '2024-04-21': 7,\n",
              "  '2024-04-22': 16,\n",
              "  '2024-04-23': 80,\n",
              "  '2024-04-24': 41,\n",
              "  '2024-04-25': 22,\n",
              "  '2024-04-26': 15,\n",
              "  '2024-04-27': 18,\n",
              "  '2024-04-28': 1,\n",
              "  '2024-04-29': 33,\n",
              "  '2024-04-30': 48,\n",
              "  '2024-05-01': 108,\n",
              "  '2024-05-02': 136,\n",
              "  '2024-05-03': 170,\n",
              "  '2024-05-04': 144,\n",
              "  '2024-05-06': 73,\n",
              "  '2024-05-07': 112,\n",
              "  '2024-05-08': 2,\n",
              "  '2024-05-09': 63,\n",
              "  '2024-05-10': 35,\n",
              "  '2024-05-13': 78,\n",
              "  '2024-05-14': 30,\n",
              "  '2024-05-15': 27,\n",
              "  '2024-05-16': 20,\n",
              "  '2024-05-17': 74,\n",
              "  '2024-05-20': 52,\n",
              "  '2024-05-21': 29,\n",
              "  '2024-05-22': 66,\n",
              "  '2024-05-23': 51,\n",
              "  '2024-05-24': 20,\n",
              "  '2024-05-25': 3,\n",
              "  '2024-05-26': 2,\n",
              "  '2024-06-04': 20,\n",
              "  '2024-06-06': 2,\n",
              "  '2024-06-07': 14,\n",
              "  '2024-06-08': 3,\n",
              "  '2024-06-11': 54,\n",
              "  '2024-06-12': 33,\n",
              "  '2024-06-13': 63,\n",
              "  '2024-06-14': 42,\n",
              "  '2024-06-17': 10,\n",
              "  '2024-06-18': 19,\n",
              "  '2024-06-19': 88,\n",
              "  '2024-06-20': 73,\n",
              "  '2024-06-21': 20,\n",
              "  '2024-06-24': 51,\n",
              "  '2024-06-25': 11,\n",
              "  '2024-06-26': 4,\n",
              "  '2024-06-27': 10,\n",
              "  '2024-06-28': 3,\n",
              "  '2024-06-29': 3,\n",
              "  '2024-07-01': 6,\n",
              "  '2024-07-02': 36,\n",
              "  '2024-07-03': 12,\n",
              "  '2024-07-04': 7,\n",
              "  '2024-07-05': 32,\n",
              "  '2024-07-08': 25,\n",
              "  '2024-07-09': 15,\n",
              "  '2024-07-10': 22,\n",
              "  '2024-07-11': 13,\n",
              "  '2024-07-12': 97,\n",
              "  '2024-07-15': 48,\n",
              "  '2024-07-16': 37,\n",
              "  '2024-07-17': 16,\n",
              "  '2024-07-18': 33,\n",
              "  '2024-07-19': 18,\n",
              "  '2024-07-22': 76,\n",
              "  '2024-07-23': 16,\n",
              "  '2024-07-24': 16,\n",
              "  '2024-07-25': 50,\n",
              "  '2024-07-26': 7,\n",
              "  '2024-07-29': 39,\n",
              "  '2024-07-30': 105,\n",
              "  '2024-07-31': 141,\n",
              "  '2024-08-01': 21},\n",
              " 'Hunnybun': {'2024-02-20': 1},\n",
              " 'DHANVI ICE CREAM PARLOUR': {'2024-02-22': 1},\n",
              " 'Toranj Restaurant': {'2024-02-29': 3,\n",
              "  '2024-03-15': 1,\n",
              "  '2024-04-17': 35,\n",
              "  '2024-06-05': 3,\n",
              "  '2024-06-06': 1},\n",
              " 'SAHL Restaurant': {'2024-02-29': 6,\n",
              "  '2024-05-14': 24,\n",
              "  '2024-05-15': 4,\n",
              "  '2024-07-01': 1},\n",
              " 'Gravies': {'2024-03-01': 1, '2024-03-05': 1},\n",
              " 'Atlass one': {'2024-03-04': 5,\n",
              "  '2024-03-05': 1,\n",
              "  '2024-03-06': 3,\n",
              "  '2024-03-08': 12,\n",
              "  '2024-03-11': 3,\n",
              "  '2024-03-12': 33,\n",
              "  '2024-03-13': 25,\n",
              "  '2024-03-14': 10,\n",
              "  '2024-03-15': 17,\n",
              "  '2024-03-18': 10,\n",
              "  '2024-03-19': 9,\n",
              "  '2024-03-20': 12,\n",
              "  '2024-03-26': 13,\n",
              "  '2024-03-27': 1,\n",
              "  '2024-03-28': 37,\n",
              "  '2024-03-29': 15,\n",
              "  '2024-04-01': 15,\n",
              "  '2024-04-02': 28,\n",
              "  '2024-04-03': 3,\n",
              "  '2024-04-04': 26,\n",
              "  '2024-04-05': 22,\n",
              "  '2024-04-06': 10,\n",
              "  '2024-04-08': 9,\n",
              "  '2024-04-09': 11,\n",
              "  '2024-04-10': 19,\n",
              "  '2024-04-11': 33,\n",
              "  '2024-04-12': 12,\n",
              "  '2024-04-15': 18,\n",
              "  '2024-04-16': 5,\n",
              "  '2024-04-17': 14,\n",
              "  '2024-04-18': 11,\n",
              "  '2024-04-19': 15,\n",
              "  '2024-04-24': 22,\n",
              "  '2024-04-25': 14},\n",
              " 'Wrap and Dip Cafe': {'2024-03-08': 3,\n",
              "  '2024-03-13': 5,\n",
              "  '2024-03-14': 4,\n",
              "  '2024-03-18': 2,\n",
              "  '2024-03-22': 2,\n",
              "  '2024-04-02': 6,\n",
              "  '2024-04-19': 7,\n",
              "  '2024-04-22': 14,\n",
              "  '2024-04-23': 2,\n",
              "  '2024-04-29': 6},\n",
              " 'Desibites Restaurant': {'2024-03-13': 7},\n",
              " 'Challet Grill Plus - Al Barsha 1': {'2024-03-13': 7,\n",
              "  '2024-03-22': 6,\n",
              "  '2024-04-17': 5,\n",
              "  '2024-05-14': 3},\n",
              " 'Novokich Restaurant': {'2024-03-19': 1},\n",
              " 'Mexican Express - Deira': {'2024-03-27': 2,\n",
              "  '2024-03-29': 4,\n",
              "  '2024-04-02': 3},\n",
              " 'Jbroz-Union Road': {'2024-04-01': 2},\n",
              " 'Chopes n Hopes': {'2024-04-04': 13, '2024-07-21': 1},\n",
              " 'Bondhu Restaurant': {'2024-04-10': 8,\n",
              "  '2024-04-11': 47,\n",
              "  '2024-04-12': 63,\n",
              "  '2024-04-15': 11,\n",
              "  '2024-04-22': 1},\n",
              " 'Paratha Central': {'2024-04-17': 200,\n",
              "  '2024-04-19': 8,\n",
              "  '2024-04-22': 19,\n",
              "  '2024-04-23': 17,\n",
              "  '2024-04-24': 22,\n",
              "  '2024-04-25': 5,\n",
              "  '2024-04-30': 1,\n",
              "  '2024-05-01': 2,\n",
              "  '2024-05-02': 9,\n",
              "  '2024-05-03': 3,\n",
              "  '2024-05-06': 4,\n",
              "  '2024-05-07': 2,\n",
              "  '2024-05-08': 8,\n",
              "  '2024-05-09': 4,\n",
              "  '2024-05-10': 4,\n",
              "  '2024-05-14': 1,\n",
              "  '2024-05-15': 1,\n",
              "  '2024-05-16': 7},\n",
              " 'Just Vada Pav - Jumeirah Village Circle': {'2024-04-26': 1,\n",
              "  '2024-05-01': 2,\n",
              "  '2024-05-16': 7,\n",
              "  '2024-05-17': 29,\n",
              "  '2024-05-22': 29,\n",
              "  '2024-06-18': 1,\n",
              "  '2024-07-01': 1,\n",
              "  '2024-07-03': 29,\n",
              "  '2024-07-04': 19,\n",
              "  '2024-07-05': 28,\n",
              "  '2024-07-08': 21,\n",
              "  '2024-07-09': 5,\n",
              "  '2024-07-11': 1,\n",
              "  '2024-07-12': 12,\n",
              "  '2024-07-15': 3,\n",
              "  '2024-07-16': 6,\n",
              "  '2024-07-17': 5,\n",
              "  '2024-07-18': 2,\n",
              "  '2024-07-19': 14,\n",
              "  '2024-07-22': 11,\n",
              "  '2024-07-23': 13,\n",
              "  '2024-07-24': 9,\n",
              "  '2024-07-25': 3,\n",
              "  '2024-07-26': 3,\n",
              "  '2024-07-29': 23,\n",
              "  '2024-07-30': 13,\n",
              "  '2024-07-31': 16,\n",
              "  '2024-08-01': 1},\n",
              " 'Deccan Delight': {'2024-05-01': 68,\n",
              "  '2024-05-21': 2,\n",
              "  '2024-05-27': 1,\n",
              "  '2024-05-28': 6},\n",
              " 'Koshari & Pastry Afandina': {'2024-05-15': 2,\n",
              "  '2024-06-07': 5,\n",
              "  '2024-06-10': 2,\n",
              "  '2024-06-12': 11,\n",
              "  '2024-06-13': 3,\n",
              "  '2024-06-14': 17,\n",
              "  '2024-06-17': 2},\n",
              " 'Just Vada Pav - Discovery Garden': {'2024-05-17': 16,\n",
              "  '2024-05-22': 31,\n",
              "  '2024-06-06': 1,\n",
              "  '2024-07-05': 6,\n",
              "  '2024-07-12': 1,\n",
              "  '2024-07-22': 1,\n",
              "  '2024-07-23': 1},\n",
              " 'Just Vada Pav - Al Karama': {'2024-05-17': 7,\n",
              "  '2024-05-22': 30,\n",
              "  '2024-06-04': 5,\n",
              "  '2024-06-10': 1,\n",
              "  '2024-06-11': 70,\n",
              "  '2024-06-12': 8,\n",
              "  '2024-06-24': 3,\n",
              "  '2024-06-25': 1,\n",
              "  '2024-07-09': 2,\n",
              "  '2024-07-11': 1,\n",
              "  '2024-07-15': 12,\n",
              "  '2024-07-22': 2,\n",
              "  '2024-07-30': 1},\n",
              " \"Joy's Pasta- Business Bay\": {'2024-06-04': 4,\n",
              "  '2024-06-05': 2,\n",
              "  '2024-06-06': 1,\n",
              "  '2024-06-10': 1,\n",
              "  '2024-06-11': 17,\n",
              "  '2024-06-13': 1,\n",
              "  '2024-06-14': 3,\n",
              "  '2024-06-17': 5,\n",
              "  '2024-06-18': 2,\n",
              "  '2024-06-25': 26,\n",
              "  '2024-06-26': 1,\n",
              "  '2024-07-08': 2,\n",
              "  '2024-07-09': 3},\n",
              " 'J5 Restaurant': {'2024-06-04': 5},\n",
              " 'Fruit time- Al Barsha': {'2024-06-05': 8,\n",
              "  '2024-06-06': 3,\n",
              "  '2024-06-11': 8,\n",
              "  '2024-06-12': 44,\n",
              "  '2024-06-13': 13,\n",
              "  '2024-06-14': 30,\n",
              "  '2024-06-15': 13,\n",
              "  '2024-06-18': 31,\n",
              "  '2024-06-19': 1,\n",
              "  '2024-06-20': 19,\n",
              "  '2024-06-21': 8,\n",
              "  '2024-06-24': 5,\n",
              "  '2024-06-25': 2,\n",
              "  '2024-06-28': 2,\n",
              "  '2024-07-23': 1},\n",
              " 'Spinzer Express Restaurant -Al QUOZ 3': {'2024-06-05': 1,\n",
              "  '2024-06-06': 3,\n",
              "  '2024-06-17': 3,\n",
              "  '2024-06-27': 1,\n",
              "  '2024-06-28': 2,\n",
              "  '2024-07-25': 3,\n",
              "  '2024-07-29': 9},\n",
              " 'joys - hessa street': {'2024-06-17': 1,\n",
              "  '2024-06-18': 8,\n",
              "  '2024-06-25': 37,\n",
              "  '2024-06-26': 6,\n",
              "  '2024-07-08': 8,\n",
              "  '2024-07-09': 3},\n",
              " 'mt store': {'2024-06-20': 1, '2024-07-12': 1},\n",
              " 'Just Curry Restaurant': {'2024-07-09': 3},\n",
              " 'test 1': {'2024-07-11': 1, '2024-07-16': 2}}"
            ]
          },
          "metadata": {},
          "execution_count": 44
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "Cfncdn8OwoZx"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}