Question_16.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "a0740787",
   "metadata": {},
   "source": [
    "# Question 16: Which node generated the smallest number of APPUNAV events?"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "26ce9ee0",
   "metadata": {},
   "source": [
    "# Section 1: Data Preparation and Preprocessing"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bc7b3bf8",
   "metadata": {},
   "source": [
    "**IMPORTING NECESSARY LIBRARIES**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "923c79cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Importinng 'SparkSession' module which is the main entry point for DataFrame and SQL functionality. SparkSession can be used create DataFrame, register DataFrame as tables, execute SQL over tables and cache tables.\n",
    "from pyspark.sql import SparkSession\n",
    "\n",
    "# Importing 'Date (datetime.date)', 'Timestamp (datetime.datetime)' , 'Double' data type from 'Data Types' module  \n",
    "from pyspark.sql.types import DateType, TimestampType, DoubleType\n",
    "\n",
    "# importing built-in functions available for DataFrame.\n",
    "from pyspark.sql.functions import to_date, to_timestamp, col, month\n",
    "\n",
    "# Importing 'matplotlib.pyplot' module for creating and customizing plots and visualizations. \n",
    "# 'pyplot' is a part of the Matplotlib library and provides a user-friendly interface to create different types of plots.\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "# Importing'time' module for measuring execution time\n",
    "import time"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eaf7f0f0",
   "metadata": {},
   "source": [
    "**EXECUTION TIME COUNTER START**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "9520f99f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Recording the starting time of the execution using the 'time.perf_counter()' function.It provides a high-resolution timer that measures the time elapsed in seconds to measure its execution time.\n",
    "executiontimestart= time.perf_counter()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "5c8c3b29",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "23/08/11 21:30:42 WARN SparkSession: Using an existing Spark session; only runtime SQL configurations will take effect.\n"
     ]
    }
   ],
   "source": [
    "# Initializing SparkSession named 'ScpProject' using the SparkSession builder.\n",
    "session = SparkSession.builder.appName('ScpProject').getOrCreate()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "faa7ecd9",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "                                                                                \r"
     ]
    }
   ],
   "source": [
    "# Reading data from CSV file into a DataFrame 'bgl_log_df'\n",
    "bgl_log_df = session.read.csv(\"BGLnew.log\", sep=',', inferSchema=True, header=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "64976506",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Renaming the columns 'toDF()' method for better understanding into our dataframe.\n",
    "bgl_log_df = bgl_log_df.toDF('alert_message_flag', 'timestamp', 'date', 'node', 'date_and_time', 'node_repeated',\n",
    "                             'message_type', 'system_component', 'level', 'message_content')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "b83ac62a",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Parsing 'date' column to standard DateType\n",
    "bgl_log_df = bgl_log_df.withColumn('date', to_date('date', 'yyyy.MM.dd'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "fd40fd59",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Parsing 'date_and_time' column to standard TimestampType\n",
    "bgl_log_df = bgl_log_df.withColumn('date_and_time', to_timestamp('date_and_time', 'yyyy-MM-dd-HH.mm.ss.SSSSSS'))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "6a55ab84",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Casting columns to appropriate data types\n",
    "bgl_log_df = bgl_log_df.withColumn(\"timestamp\", bgl_log_df[\"timestamp\"].cast(TimestampType())) \\\n",
    "    .withColumn(\"date\", bgl_log_df[\"date\"].cast(DateType())) \\\n",
    "    .withColumn(\"date_and_time\", bgl_log_df[\"date_and_time\"].cast(TimestampType()))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "45d2410d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "root\n",
      " |-- alert_message_flag: string (nullable = true)\n",
      " |-- timestamp: timestamp (nullable = true)\n",
      " |-- date: date (nullable = true)\n",
      " |-- node: string (nullable = true)\n",
      " |-- date_and_time: timestamp (nullable = true)\n",
      " |-- node_repeated: string (nullable = true)\n",
      " |-- message_type: string (nullable = true)\n",
      " |-- system_component: string (nullable = true)\n",
      " |-- level: string (nullable = true)\n",
      " |-- message_content: string (nullable = true)\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# Using 'printSchema()' method to display the updated schema of the DataFrame 'bgl_log_df'.\n",
    "bgl_log_df.printSchema()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c51663d2",
   "metadata": {},
   "source": [
    "**DATA PREPRATION AND PREPROCESSING COMPLETED**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "e72b9e71",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "-RECORD 0------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:50                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:50.363779               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 1------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:50                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:50.527847               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 2------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:50                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:50.675872               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 3------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:50                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:50.823719               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 4------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:50                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:50.982731               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 5------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:51                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:51.131467               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 6------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:51                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:51.293532               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 7------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:51                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:51.428563               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 8------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:51                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:51.601412               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 9------------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:51                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:51.749199               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 10-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:51                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:51.885834               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 11-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:52                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:52.041388               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 12-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:52                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:52.199063               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 13-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:52                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:52.345821               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 14-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:52                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:52.493353               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 15-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:52                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:52.638135               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 16-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:52                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:52.807927               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 17-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:52                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:52.951717               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 18-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:53                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:53.12578                \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "-RECORD 19-----------------------------------------------------\n",
      " alert_message_flag | -                                        \n",
      " timestamp          | 2005-06-03 22:42:53                      \n",
      " date               | 2005-06-03                               \n",
      " node               | R02-M1-N0-C:J12-U11                      \n",
      " date_and_time      | 2005-06-03 15:42:53.276129               \n",
      " node_repeated      | R02-M1-N0-C:J12-U11                      \n",
      " message_type       | RAS                                      \n",
      " system_component   | KERNEL                                   \n",
      " level              | INFO                                     \n",
      " message_content    | instruction cache parity error corrected \n",
      "only showing top 20 rows\n",
      "\n"
     ]
    }
   ],
   "source": [
    "# We are using the 'show()' method to display the DataFrame 'bgl_log_df' in a vertical format.\n",
    "# The 'vertical=True' argument is used to display the DataFrame vertically, showing each row in a single line.\n",
    "# The 'truncate=False' argument is used to prevent truncation of column values, ensuring complete visibility of the data.\n",
    "bgl_log_df.show(truncate=False, vertical=True)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d4fa8c6f",
   "metadata": {},
   "source": [
    "# Section 2: Log Data Analysis : Spark SQL"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d77834c0",
   "metadata": {},
   "source": [
    "**TOTAL NUMBER OF LOG ENTRIES IN THE LOG DATASET COUNT**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "8a06cc1d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4747963"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Count total logs in the DataFrame\n",
    "total_logs_count = bgl_log_df.count()\n",
    "\n",
    "# Display the total number of logs\n",
    "total_logs_count"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ff7a3f8a",
   "metadata": {},
   "source": [
    "**CREATING TEMPORARY VIEW OF THE DATAFRAME**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "c2dcd0c1",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Using the 'createOrReplaceTempView()' method to create a temporary view of the DataFrame 'bgl_log_df'.\n",
    "# This temporary view, named \"bgllogtable,\" allows us to perform SQL queries and leverage the power of SQL to interact with the DataFrame and perform complex data analysis and transformations.\n",
    "# NOTE: The temporary view exists for the duration of the SparkSession and can be queried using Spark SQL syntax.\n",
    "bgl_log_df.createOrReplaceTempView(\"bgllogtable\")"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d20ecc04",
   "metadata": {},
   "source": [
    "<span style=\"color:blue\">**SQL Query for Question 16: Which node generated the smallest number of APPUNAV events?**</SPAN>\n",
    "\n",
    "***1. SELECT node, COUNT(*) AS num_appunav_events***\n",
    "   - 1. SELECT statement to retrieve the 'node' column and count the number of 'APPUNAV' events for each node.\n",
    "\n",
    "***2. FROM bgllogtable***\n",
    "   - 2. FROM clause to specify the source table 'bgllogtable'.\n",
    "\n",
    "***3. WHERE alert_message_flag = 'APPUNAV'***\n",
    "   - 3. WHERE clause to filter only 'APPUNAV' events.\n",
    "\n",
    "***4. GROUP BY node***\n",
    "   - 4. GROUP BY clause to group the results based on the 'node' column.\n",
    "\n",
    "***5. ORDER BY num_appunav_events;***\n",
    "   - 5. ORDER BY clause to order the 'num_appunav_events' in ascending order so that we have the visibility for all the nodes with smallest number of 'APPUNAV' event\n",
    "\n",
    "<span style=\"color:blue\">**The output of this SQL query will provide the count of APPUNAV events generated by each node in ascending order to show the nodes with smallest count of 'APPUNAV' event ?**<span style=\"color:blue\">"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "93c12d18",
   "metadata": {},
   "outputs": [],
   "source": [
    "SQL_question16=\"\"\"\n",
    "SELECT node, COUNT(*) AS num_appunav_events\n",
    "FROM bgllogtable\n",
    "WHERE alert_message_flag = 'APPUNAV'\n",
    "GROUP BY node\n",
    "ORDER BY num_appunav_events;\n",
    "\"\"\""
   ]
  },
  {
   "cell_type": "markdown",
   "id": "691ab842",
   "metadata": {},
   "source": [
    "**NODES WITH THE NUMBER OF 'APPUNAV' EVENTS IN ASCENDING ORDER**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "aaf2bfe4",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[Stage 6:=========>                                                 (1 + 5) / 6]\r"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-------------------+------------------+\n",
      "|               node|num_appunav_events|\n",
      "+-------------------+------------------+\n",
      "|R44-M1-NC-I:J18-U01|                 1|\n",
      "|R53-M1-N8-I:J18-U01|                 1|\n",
      "|R64-M0-NC-I:J18-U01|                 1|\n",
      "|R71-M1-NC-I:J18-U11|                 1|\n",
      "|R76-M1-N4-I:J18-U11|                 1|\n",
      "|R62-M0-N4-I:J18-U11|                 1|\n",
      "|R42-M0-N4-I:J18-U01|                 1|\n",
      "|R60-M1-N8-I:J18-U11|                 1|\n",
      "|R41-M0-N0-I:J18-U01|                 1|\n",
      "|R74-M1-N4-I:J18-U11|                 1|\n",
      "|R71-M1-NC-I:J18-U01|                 1|\n",
      "|R66-M1-NC-I:J18-U11|                 1|\n",
      "|R57-M1-N4-I:J18-U11|                 1|\n",
      "|R64-M0-N4-I:J18-U11|                 1|\n",
      "|R60-M0-N8-I:J18-U01|                 1|\n",
      "|R55-M0-N0-I:J18-U01|                 1|\n",
      "|R71-M1-N8-I:J18-U01|                 1|\n",
      "|R63-M0-NC-I:J18-U11|                 1|\n",
      "|R70-M1-NC-I:J18-U01|                 1|\n",
      "|R75-M0-N4-I:J18-U01|                 1|\n",
      "+-------------------+------------------+\n",
      "only showing top 20 rows\n",
      "\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\r",
      "                                                                                \r"
     ]
    }
   ],
   "source": [
    "# Using the 'session' object to execute an SQL query and display the results.\n",
    "sql_result_df=session.sql(SQL_question16)\n",
    "sql_result_df.show()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c70f4b05",
   "metadata": {},
   "source": [
    "**TOTAL NUMBER OF NODES WITH 'APPUNAV' EVENT**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "d1e79efb",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "                                                                                \r"
     ]
    },
    {
     "data": {
      "text/plain": [
       "1024"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sql_result_df.count()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d97112a3",
   "metadata": {},
   "source": [
    "<span style=\"color:blue\">***TOTAL NUMBER OF NODES THAT GENERATED THE SMALLEST NUMBER OF 'APPUNAV' EVENTS i.e 1***<span style=\"color:blue\">"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "3e199f56",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "                                                                                \r"
     ]
    },
    {
     "data": {
      "text/plain": [
       "512"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "smallest_num_appunav_events= sql_result_df.filter(\"num_appunav_events = 1\")\n",
    "smallest_num_appunav_events.count()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "f3a66413",
   "metadata": {},
   "source": [
    "<span style=\"color:blue\">***LIST OF NODES THAT GENERATED THE SMALLEST NUMBER OF 'APPUNAV' EVENTS i.e 1***<span style=\"color:blue\">"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "7ec88e26",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\r",
      "[Stage 21:=========>                                                (1 + 5) / 6]\r",
      "\r",
      "[Stage 21:================================================>         (5 + 1) / 6]\r"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "+-------------------+------------------+\n",
      "|               node|num_appunav_events|\n",
      "+-------------------+------------------+\n",
      "|R44-M1-NC-I:J18-U01|                 1|\n",
      "|R64-M0-NC-I:J18-U01|                 1|\n",
      "|R71-M1-NC-I:J18-U11|                 1|\n",
      "|R76-M1-N4-I:J18-U11|                 1|\n",
      "|R62-M0-N4-I:J18-U11|                 1|\n",
      "|R42-M0-N4-I:J18-U01|                 1|\n",
      "|R60-M1-N8-I:J18-U11|                 1|\n",
      "|R41-M0-N0-I:J18-U01|                 1|\n",
      "|R74-M1-N4-I:J18-U11|                 1|\n",
      "|R71-M1-NC-I:J18-U01|                 1|\n",
      "+-------------------+------------------+\n",
      "only showing top 10 rows\n",
      "\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "\r",
      "                                                                                \r"
     ]
    }
   ],
   "source": [
    "smallest_num_appunav_events.show(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "87d3d36a",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "                                                                                \r"
     ]
    }
   ],
   "source": [
    "#converting the Spark DataFrame to a Pandas DataFrame for plotting\n",
    "pandas_df = sql_result_df.toPandas()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "e97f844a",
   "metadata": {},
   "source": [
    "# Section 3: Visualization"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "fe1a45cb",
   "metadata": {},
   "source": [
    "**VISUALISING THE DISTRIBUTION BY SHOWING THE COUNT OF NODES WITH EXACTLY ONE 'APPUNAV' EVENT IN <span style=\"color:red\">RED</span> AND THE NODES WITH MORE THAN 1 'APPUNAV' EVENT IS MARKED <span style=\"color:blue\">BLUE</span>**"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "a18cd835",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "                                                                                \r"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAA1IAAAIQCAYAAACLwV/UAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjcuMiwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy8pXeV/AAAACXBIWXMAAA9hAAAPYQGoP6dpAABrwElEQVR4nO3dd3RU1d7G8WdmUgiBJAJJIIaWIFWKCALSi0YIigIqiIVyxYsgTUG9SrUCIpZrQaWJEBVFLEhTERCwUCKKVBNF3hACgglETJnZ7x/cnGRIAjkYSMDvZ61Zi9mnzP5NhrPnmdMcxhgjAAAAAECROUu6AwAAAABwoSFIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAE45yZOnCiHw3FeXqtDhw7q0KGD9fzLL7+Uw+HQe++9d15ev3///qpRo8Z5ea2zdfz4cf3rX/9S5cqV5XA4NHLkyJLukmXu3LlyOBz65ZdfSrorZ1SjRg3179+/yPN279793HYIAHBeEaQA2JLzRTfnUaZMGUVERCgmJkYvvPCCjh07Viyvk5SUpIkTJyo+Pr5Y1lecSnPfiuLJJ5/U3LlzNWTIEM2fP1933HFHofPWqFFDDodD9913X75p5zuklnY//fSTJk6ceE5CoMPh0Ny5cwuc9vLLL8vhcKhFixanXT7n4XQ6FRERoWuvvVZffvml13w5f++cR1hYmNq2basPPvgg33yFBcNNmzbl62/Ojynh4eH6888/8y1zuvX98ccfKlOmjBwOh3bs2GG1Z2VlqVKlSmrTpk2hdRtjVLVqVTVt2lRS7mf2TH+jU7dzpz6+/vrr0y5/PmzYsEETJ07UH3/8UdJdAf6xCFIAzsrkyZM1f/58vfLKK9aX7JEjR6phw4batm2b17yPPvqoTpw4YWv9SUlJmjRpku2wsnLlSq1cudLWMnadrm+vv/66du3adU5f/+/64osv1LJlS02YMEG33367rrzyyjMu8/rrryspKek89O7CsWvXLr3++uvW859++kmTJk0673vTFixYoBo1aujbb7/V3r17C53vmmuu0fz58zVv3jz9+9//1rZt29SpUyctW7bMa74mTZpo/vz5mj9/vh544AElJSWpZ8+eevXVV/92X1NSUvTKK6/YWmbRokVyOByqXLmyFixYYLX7+vrq5ptv1oYNG/Trr78WuOzatWu1f/9+3X777WfV35zt3KmPWrVqndX6itOGDRs0adIkghRQgghSAM5K165ddfvtt2vAgAF6+OGHtWLFCn322WdKSUnRDTfc4BWcfHx8VKZMmXPan5xfuf38/OTn53dOX+t0fH195e/vX2KvXxQpKSkKCQkp8vwNGjSQ2+3W008/fe46dQHy9/eXr69vifYhMTFRGzZs0LPPPqvQ0FCvoHGq2rVr6/bbb9cdd9yh8ePHa9WqVTLG6LnnnvOa79JLL9Xtt9+u22+/XWPHjtX69esVGBioGTNm/O3+NmnSRNOmTbP1w8pbb72lbt26qW/fvlq4cKHXtH79+skYo7i4uAKXXbhwoZxOp/r06XNW/c3Zzp36qFSp0lmtD8DFhSAFoNh06tRJ48aN06+//qq33nrLai/oHKlVq1apTZs2CgkJUbly5VSnTh395z//kXTy8JvmzZtLkgYMGGAdTpNzqFCHDh10+eWXa/PmzWrXrp3Kli1rLXvqOVI53G63/vOf/6hy5coKDAzUDTfcoN9++81rnsLOecm7zjP1raBzpNLT03X//feratWq8vf3V506dfTMM8/IGOM1n8Ph0LBhw7RkyRJdfvnl8vf3V4MGDbR8+fKC3/BTpKSkaNCgQQoPD1eZMmXUuHFjzZs3z5qec1hTYmKili5davX9THtQatSooTvvvLPIe6W2bt2qrl27KigoSOXKlVPnzp0LPBRq+/bt6tSpkwICAhQZGanHH39cHo+nwHUuW7ZMbdu2VWBgoMqXL6/Y2Fht377da57k5GQNGDBAkZGR8vf3V5UqVdSjR4/T1vfRRx/J4XB47UV9//335XA41LNnT69569Wrp1tvvdXrfcn5vMydO1c333yzJKljx47We3vqoXNfffWVrrrqKpUpU0ZRUVF68803C+1bUSxYsECXXHKJYmNj1bt379MGqVM1bNhQlSpVUmJi4mnnq1y5surVq3fG+Ypi/PjxOnjwYJH3Su3bt0/r1q1Tnz591KdPHys45mjdurVq1KiRL2BJJw/9e++999SxY0dFRET87b4XtP4KFSpowIAB+aalpaWpTJkyeuCBB6y2jIwMTZgwQbVq1ZK/v7+qVq2qsWPHKiMjw2vZomwHJk6cqDFjxkiSatasme//8um2rwCKD0EKQLHKOd/mdIfXbd++Xd27d1dGRoYmT56s6dOn64YbbtD69eslnfzCOnnyZEnS4MGDrcNp2rVrZ63j999/V9euXdWkSRM999xz6tix42n79cQTT2jp0qV68MEHNXz4cK1atUpdunSxfchhUfqWlzFGN9xwg2bMmKHrrrtOzz77rOrUqaMxY8Zo9OjR+eb/6quvdO+996pPnz6aOnWq/vrrL/Xq1Uu///77aft14sQJdejQQfPnz1e/fv00bdo0BQcHq3///nr++eetvs+fP1+VKlXyOnwrNDT0jHU/8sgjys7OPuNeqe3bt6tt27b6/vvvNXbsWI0bN06JiYnq0KGDvvnmG2u+5ORkdezYUfHx8XrooYc0cuRIvfnmm1Zf85o/f75iY2NVrlw5TZkyRePGjdNPP/2kNm3aeIWkXr166YMPPtCAAQP08ssva/jw4Tp27Jj27dtXaH/btGkjh8OhtWvXWm3r1q2T0+nUV199ZbUdOnRIO3fuLPTv3K5dOw0fPlyS9J///Md6b+vVq2fNs3fvXvXu3VvXXHONpk+frksuuUT9+/fPFwjtWLBggXr27Ck/Pz/17dtXe/bs0XfffVekZY8ePaqjR4+qYsWKp50vKytLv/322xnnK4q2bduqU6dOmjp1apH+78XFxSkwMFDdu3fXVVddpejoaK+w6HA4dNttt+mHH37I9z4uX75cR44cUb9+/c66v6mpqTp8+LDXI+f/oq+vr2666SYtWbJEmZmZXsstWbJEGRkZ1p4wj8ejG264Qc8884yuv/56vfjii7rxxhs1Y8YMr3Ce40zbgZ49e6pv376SpBkzZnj9Xz7T9hVAMTIAYMOcOXOMJPPdd98VOk9wcLC54oorrOcTJkwweTc3M2bMMJLMoUOHCl3Hd999ZySZOXPm5JvWvn17I8m8+uqrBU5r37699Xz16tVGkrn00ktNWlqa1f7uu+8aSeb555+32qpXr27uuuuuM67zdH276667TPXq1a3nS5YsMZLM448/7jVf7969jcPhMHv37rXaJBk/Pz+vtu+//95IMi+++GK+18rrueeeM5LMW2+9ZbVlZmaaVq1amXLlynnVXr16dRMbG3va9RU074ABA0yZMmVMUlKSMSb3vV20aJE1/4033mj8/PzMzz//bLUlJSWZ8uXLm3bt2lltI0eONJLMN998Y7WlpKSY4OBgI8kkJiYaY4w5duyYCQkJMXfffbdXv5KTk01wcLDVfvToUSPJTJs2rUh15dWgQQNzyy23WM+bNm1qbr75ZiPJ7NixwxhjzOLFi40k8/3333u9N3k/L4sWLTKSzOrVq/O9RvXq1Y0ks3btWq96/f39zf3332+7z8YYs2nTJiPJrFq1yhhjjMfjMZGRkWbEiBH55pVkBg0aZA4dOmRSUlLMN998Yzp37mwkmenTp3v189prrzWHDh0yhw4dMt9//73p06ePkWTuu+8+r/kK+wwV9P8jZxtw6NAhs2bNGiPJPPvss2dcX8OGDU2/fv2s5//5z39MpUqVTFZWltW2fft2I8k8/PDDXsv26dPHlClTxqSmphbyDhYuZztX0MPf39+ab8WKFUaS+fjjj72W79atm4mKirKez58/3zidTrNu3Tqv+V599VUjyaxfv95qK+p2YNq0aV7/V3IUZfsKoHiwRwpAsStXrtxpr96Xc37Ohx9+WOihXGfi7+9f4CE1hbnzzjtVvnx563nv3r1VpUoVffrpp2f1+kX16aefyuVyWXsrctx///0yxuQ70b9Lly6Kjo62njdq1EhBQUFKSEg44+tUrlzZ+pVaOvmL+fDhw3X8+HGtWbPmb9fy6KOPnnavlNvt1sqVK3XjjTcqKirKaq9SpYpuu+02ffXVV0pLS7P627JlS1111VXWfKGhofn2HqxatUp//PGH+vbt67VXwOVyqUWLFlq9erUkKSAgQH5+fvryyy919OhRW3W1bdtW69atkyQdO3ZM33//vQYPHqxKlSpZ7evWrVNISIguv/xyW+vOq379+mrbtq1XvXXq1Dnj37YwCxYsUHh4uLU31uFw6NZbb9Xbb78tt9udb/5Zs2YpNDRUYWFhatGihdavX6/Ro0fnu/z9ypUrFRoaqtDQUDVu3FiLFi3SHXfcoSlTppxVP0/Vrl07dezY8Yx7pbZt26YffvjB6zOd8zlYsWKF1Va/fn1dccUVevvtt6229PR0ffTRR+revbuCgoLOuq8vvfSSVq1a5fXI+3+2U6dOqlSpkt555x2r7ejRo1q1apXXnqZFixapXr16qlu3rtfnuFOnTpJkfY5znO12QCqe7SuAoiFIASh2x48f9wotp7r11lvVunVr/etf/1J4eLj69Omjd99919agf+mll9q6qMRll13m9dzhcKhWrVrn/Aprv/76qyIiIvK9HzmHfJ16tbFq1arlW8cll1xyxnDw66+/6rLLLpPT6b1ZL+x1zkZUVJTuuOMOvfbaazpw4EC+6YcOHdKff/6pOnXq5JtWr149eTwe67y0nP6e6tRl9+zZI+nkF9acL/c5j5UrVyolJUXSyWA9ZcoULVu2TOHh4WrXrp2mTp2q5OTkM9bVtm1bHThwQHv37tWGDRvkcDjUqlUrr4C1bt06tW7dOt/7a8fZ/m0L4na79fbbb6tjx45KTEzU3r17tXfvXrVo0UIHDx7U559/nm+ZHj16aNWqVfrss8/0zTff6PDhw5o+fXq+mlq0aGHNt2HDBh0+fFhvvvmmAgICbPXxdPeOmzhxopKTk097JcC33npLgYGBioqKsuorU6aMatSoke9csH79+nmdP7VkyRL9+eeff+uwPkm66qqr1KVLF69H3sOIfXx81KtXL3344YfWuU6LFy9WVlaWV5Das2ePtm/fnu8zXLt2bUmyPsc5/s5npTi2rwCKxqekOwDg4rJ//36lpqae9vLAAQEBWrt2rVavXq2lS5dq+fLleuedd9SpUyetXLlSLpfrjK9j90tdURT2xc/tdhepT8WhsNcxp1yYoqQ88sgjmj9/vqZMmaIbb7zxnL9ezpe/+fPnq3Llyvmm+/jkDmMjR47U9ddfryVLlmjFihUaN26cnnrqKX3xxRe64oorCn2NnPsQrV27VgkJCWratKkCAwPVtm1bvfDCCzp+/Li2bt2qJ5544m/VUpx/2y+++EIHDhzQ22+/7bUnJseCBQt07bXXerVFRkaqS5cuZ1x3pUqVzjhfmTJlCt2blHMFzdNdqbNdu3bq0KGDpk6dqn//+9/5ppv/XYkvPT1d9evXzzc9JSVFx48fV7ly5SSd3FM1duxYLVy4UFdffbUWLlyoSy65RN26dTttHcWhT58+mjlzppYtW6Ybb7xR7777rurWravGjRtb83g8HjVs2FDPPvtsgeuoWrWq1/O/81kpju0rgKIhSAEoVvPnz5ckxcTEnHY+p9Opzp07q3Pnznr22Wf15JNP6pFHHtHq1avVpUuX0/6afTZy9mzkMMZo7969atSokdV2ySWXFHhPll9//dXrUDU7fatevbo+++wzHTt2zGuv1M6dO63pxaF69eratm2bPB6P1x6G4n6d6Oho3X777Zo5c2a+G8CGhoaqbNmyBd5Ha+fOnXI6ndYXxurVq+f7m0jKt2zO4U1hYWFFCgHR0dG6//77df/992vPnj1q0qSJpk+f7nUVyVNVq1ZN1apV07p165SQkGAdfteuXTuNHj1aixYtktvtLvRCEzmK+zN7OgsWLFBYWJheeumlfNMWL16sDz74QK+++uo5+cFBOvn3++mnnwqclvM3PNNnbuLEierQoYNmzpyZb9qaNWu0f/9+TZ482euCHdLJQ+cGDx6sJUuWWPeHioiIUMeOHbVo0SKNGzdOq1atUv/+/c/LrRDatWunKlWq6J133lGbNm30xRdf6JFHHvGaJzo6Wt9//706d+5cbJ+T063nTNtXAMWDQ/sAFJsvvvhCjz32mGrWrHnaQ2qOHDmSr61JkyaSZB0eExgYKEnFdrPJN9980+u8rffee08HDhxQ165drbbo6Gh9/fXXXlfg+uSTT/JdJt1O37p16ya3263//ve/Xu0zZsyQw+Hwev2/o1u3bkpOTvY6VyM7O1svvviiypUrp/bt2xfL60gnz5XKysrS1KlTvdpdLpeuvfZaffjhh16HTB48eFALFy5UmzZtrPNVunXrpq+//lrffvutNd+hQ4fyHbIVExOjoKAgPfnkk8rKysrXl0OHDkk6uRfkr7/+8poWHR2t8uXL57u8dEHatm2rL774Qt9++60VpJo0aaLy5cvr6aefVkBAwBlvXFzcn9nCnDhxQosXL1b37t3Vu3fvfI9hw4bp2LFj+uijj85ZH7p166b9+/dryZIlXu0ZGRl64403FBYWpqZNm552He3bt1eHDh00ZcqUfH+7nMP6xowZk6++u+++W5dddlmBh/elpKTonnvuUVZW1t8+rK+onE6nevfurY8//ljz589XdnZ2vivx3XLLLfq///s/rxs45zhx4oTS09Ntv25hn7eibF8BFA/2SAE4K8uWLdPOnTuVnZ2tgwcP6osvvtCqVatUvXp1ffTRR6c9rGfy5Mlau3atYmNjVb16daWkpOjll19WZGSkdZhVdHS0QkJC9Oqrr6p8+fIKDAxUixYtVLNmzbPqb4UKFdSmTRsNGDBABw8e1HPPPadatWrp7rvvtub517/+pffee0/XXXedbrnlFv3888966623vE76ttu366+/Xh07dtQjjzyiX375RY0bN9bKlSv14YcfauTIkfnWfbYGDx6smTNnqn///tq8ebNq1Kih9957T+vXr9dzzz132nPW7MrZK5X3HlU5Hn/8ceseNvfee698fHw0c+ZMZWRkeAWvsWPHav78+bruuus0YsQIBQYG6rXXXrP2rOUICgrSK6+8ojvuuENNmzZVnz59FBoaqn379mnp0qVq3bq1/vvf/2r37t3q3LmzbrnlFtWvX18+Pj764IMPdPDgwSLdjLVt27ZasGCBHA6H9Rl0uVy6+uqrtWLFCnXo0OGMezeaNGkil8ulKVOmKDU1Vf7+/urUqZPCwsKK+tYWyUcffaRjx47phhtuKHB6y5YtrZvzFnRp7eIwePBgzZ49WzfffLMGDhyoK664Qr///rveeecd/fjjj3rzzTeLtDdowoQJ+W5dkJGRoffff1/XXHNNoduRG264Qc8//7xSUlKs97dXr16699579eGHH6pq1apn3INYFDnbuVNdffXVXnupb731Vr344ouaMGGCGjZsmG8v2h133KF3331X//73v7V69Wq1bt1abrdbO3fu1LvvvqsVK1aoWbNmtvqWE+wfeeQR9enTR76+vrr++uuLtH0FUExK8pKBAC48p14W2M/Pz1SuXNlcc8015vnnn/e6zHaOUy9//vnnn5sePXqYiIgI4+fnZyIiIkzfvn3N7t27vZb78MMPTf369Y2Pj4/X5ZTbt29vGjRoUGD/Crv8eVxcnHn44YdNWFiYCQgIMLGxsebXX3/Nt/z06dPNpZdeavz9/U3r1q3Npk2b8q3zdH079fLnxpy8hPeoUaNMRESE8fX1NZdddpmZNm2a8Xg8XvNJMkOHDs3Xp8Iuy36qgwcPmgEDBphKlSoZPz8/07BhwwIv0X62lz/Pa8+ePcblcuW7/LkxxmzZssXExMSYcuXKmbJly5qOHTuaDRs25FvHtm3bTPv27U2ZMmXMpZdeah577DEza9asAi/pvHr1ahMTE2OCg4NNmTJlTHR0tOnfv7/ZtGmTMcaYw4cPm6FDh5q6deuawMBAExwcbFq0aGHefffdItWZcwntevXqebU//vjjRpIZN25cge/NqX+X119/3URFRVnvTc6l0At7Hwv6bJ3J9ddfb8qUKWPS09MLnad///7G19fXHD582BhT+GfrVHY+G0ePHjWjRo0yNWvWNL6+viYoKMh07NjRLFu2LN+8eS9/fqqc2xnkvO77779vJJlZs2YV+tpffvllvtsXGGOsy9aPHTu2SDUU5nSXP8/7/z2Hx+MxVatWLfBWBzkyMzPNlClTTIMGDYy/v7+55JJLzJVXXmkmTZrkdYl2O9uBxx57zFx66aXG6XRa/2+Kun0F8Pc5jCklZzADAAAAwAWCc6QAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATdyQV5LH41FSUpLKly8vh8NR0t0BAAAAUEKMMTp27JgiIiLkdBa+34kgJSkpKUlVq1Yt6W4AAAAAKCV+++03RUZGFjqdICWpfPnykk6+WUFBQSXcGwAAAAAlJS0tTVWrVrUyQmEIUpJ1OF9QUBBBCgAAAMAZT/nhYhMAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATT4l3QEUwOEo6R4AwLljTEn34ILE0ADgYnYhDg3skQIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsKlEg9TEiRPlcDi8HnXr1rWm//XXXxo6dKgqVqyocuXKqVevXjp48KDXOvbt26fY2FiVLVtWYWFhGjNmjLKzs893KQAAAAD+QUr88ucNGjTQZ599Zj338cnt0qhRo7R06VItWrRIwcHBGjZsmHr27Kn169dLktxut2JjY1W5cmVt2LBBBw4c0J133ilfX189+eST570WAAAAAP8MJR6kfHx8VLly5XztqampmjVrlhYuXKhOnTpJkubMmaN69erp66+/VsuWLbVy5Ur99NNP+uyzzxQeHq4mTZroscce04MPPqiJEyfKz8/vfJcDAAAA4B+gxM+R2rNnjyIiIhQVFaV+/fpp3759kqTNmzcrKytLXbp0seatW7euqlWrpo0bN0qSNm7cqIYNGyo8PNyaJyYmRmlpadq+ffv5LQQAAADAP0aJ7pFq0aKF5s6dqzp16ujAgQOaNGmS2rZtqx9//FHJycny8/NTSEiI1zLh4eFKTk6WJCUnJ3uFqJzpOdMKk5GRoYyMDOt5WlqaJCk7O9s6v8rpdMrpdMrj8cjj8Vjz5rS73W6ZPLdgLqzd5XLJ4XDkO2/L5XJJOnl4Yr52h0NuX1+vdp/MTBmnU+48hz46jJErK0sep1OegtpdLnn+9zqS5PR45MzOlsfHRx5nboZ2ut1yut1y+/rKOBy57dnZcno8+dpd2dlyeDzKPmWPnysrSzJG7lPbMzOpiZqoiZpyayri9tDHx0fGGK92h8Mhl8uVb9tcWHuJbsuLuaact9PjcSo72ykfH4+cztz53W6n3G6nfH3dcjhy+56d7ZTHU1C7Sx6PQ35+3jVlZblkjOTn5933zEyXHA7J1/fUdh85nUY+PrntxjiUleWS0+mRj48nX7vL5ZHLldtOTdRETdSUnV16tuVFvd5CiQaprl27Wv9u1KiRWrRooerVq+vdd99VQEDAOXvdp556SpMmTcrXvnXrVgUGBkqSQkNDFR0drcTERB06dMiaJzIyUpGRkdq9e7dSU1Ot9qioKIWFhenHH3/UiRMnrPa6desqJCREW7du9Ro4GzVqJD8/P23atMmrD82aNVNmxYrads89VpsrM1PNp01Tao0a2tm3r9UecPiwGs+cqcONGikhNtZqD05IUL24OCW1bq39bdta7aHx8YpeulSJMTE61KRJbk3r1ily7Vrt7t1bqVFRuTUtXaqw+Hj9OHCgTlSqlFtTXJxCEhK0dcQIry95jWbOlF9amjaNGeNd07RpygwKoiZqoiZqOllTQdu9zExt27YttyaXS82bN1dqaqp27tyZW1NAgBo3bqzDhw8rISEht6bgYNWrV09JSUnav39/bk0luS0v5ppyPgrx8aFaujRaMTGJatIkt6Z16yK1dm2kevferaio3JqWLo1SfHyYBg78UZUq5dYUF1dXCQkhGjFiq9cXopkzGyktzU9jxnjXNG1aMwUFZeqee3Jrysx0adq05qpRI1V9++bWdPhwgGbObKxGjQ4rNja3poSEYMXF1VPr1klq2zb370RN1ERN1LRpU+nZlqenp6soHCZvTCsFmjdvri5duuiaa65R586ddfToUa+9UtWrV9fIkSM1atQojR8/Xh999JHi4+Ot6YmJiYqKitKWLVt0xRVXFPgaBe2Rqlq1qn7//XcFBQVJKuFfMV2uC/vX5ovxF3RqoiZqKr6asrK829kjVaSa/vc73wX7a3Pe9ovlF3RqoiZqKr6a0tNLz7Y8LS1NFStWVGpqqpUNClKqgtTx48dVrVo1TZw4UXfddZdCQ0MVFxenXr16SZJ27dqlunXrauPGjWrZsqWWLVum7t2768CBAwoLC5MkvfbaaxozZoxSUlLk7+9fpNdNS0tTcHDwGd+s8ybPFxIAuOiUnmHngsLQAOBiVpqGhqJmgxI9tO+BBx7Q9ddfr+rVqyspKUkTJkyQy+VS3759FRwcrEGDBmn06NGqUKGCgoKCdN9996lVq1Zq2bKlJOnaa69V/fr1dccdd2jq1KlKTk7Wo48+qqFDhxY5RAEAAACAXSUapPbv36++ffvq999/V2hoqNq0aaOvv/5aoaGhkqQZM2bI6XSqV69eysjIUExMjF5++WVreZfLpU8++URDhgxRq1atFBgYqLvuukuTJ08uqZIAAAAA/AOUqkP7SgqH9gHAecSwc1YYGgBczErT0FDUbFDi95ECAAAAgAsNQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNpSZIPf3003I4HBo5cqTV9tdff2no0KGqWLGiypUrp169eungwYNey+3bt0+xsbEqW7aswsLCNGbMGGVnZ5/n3gMAAAD4JykVQeq7777TzJkz1ahRI6/2UaNG6eOPP9aiRYu0Zs0aJSUlqWfPntZ0t9ut2NhYZWZmasOGDZo3b57mzp2r8ePHn+8SAAAAAPyDlHiQOn78uPr166fXX39dl1xyidWempqqWbNm6dlnn1WnTp105ZVXas6cOdqwYYO+/vprSdLKlSv1008/6a233lKTJk3UtWtXPfbYY3rppZeUmZlZUiUBAAAAuMiVeJAaOnSoYmNj1aVLF6/2zZs3Kysry6u9bt26qlatmjZu3ChJ2rhxoxo2bKjw8HBrnpiYGKWlpWn79u3npwAAAAAA/zg+Jfnib7/9trZs2aLvvvsu37Tk5GT5+fkpJCTEqz08PFzJycnWPHlDVM70nGmFycjIUEZGhvU8LS1NkpSdnW2dX+V0OuV0OuXxeOTxeKx5c9rdbreMMWdsd7lccjgc+c7bcrlckk4enpiv3eGQ29fXq90nM1PG6ZTbJ/dP5jBGrqwseZxOeQpqd7nk+d/rSJLT45EzO1seHx95nLkZ2ul2y+l2y+3rK+Nw5LZnZ8vp8eRrd2Vny+HxKNvPz7vvWVmSMXKf2p6ZSU3URE3UlFtTEbeHPj4+MsZ4tTscDrlcrnzb5sLaS3RbXsw15bydHo9T2dlO+fh45HTmzu92O+V2O+Xr65bDkdv37GynPJ6C2l3yeBzy8/OuKSvLJWMkPz/vvmdmuuRwSL6+p7b7yOk08vHJbTfGoawsl5xOj3x8PPnaXS6PXK7cdmqiJmqipuzs0rMtL+r1FkosSP32228aMWKEVq1apTJlypzX137qqac0adKkfO1bt25VYGCgJCk0NFTR0dFKTEzUoUOHrHkiIyMVGRmp3bt3KzU11WqPiopSWFiYfvzxR504ccJqr1u3rkJCQrR161avgbNRo0by8/PTpk2bvPrQrFkzZVasqG333GO1uTIz1XzaNKXWqKGdffta7QGHD6vxzJk63KiREmJjrfbghATVi4tTUuvW2t+2rdUeGh+v6KVLlRgTo0NNmuTWtG6dIteu1e7evZUaFZVb09KlCouP148DB+pEpUq5NcXFKSQhQVtHjPD6ktdo5kz5paVp05gx3jVNm6bMoCBqoiZqoqaTNRW03cvM1LZt23JrcrnUvHlzpaamaufOnbk1BQSocePGOnz4sBISEnJrCg5WvXr1lJSUpP379+fWVJLb8mKuKeejEB8fqqVLoxUTk6gmTXJrWrcuUmvXRqp3792KisqtaenSKMXHh2ngwB9VqVJuTXFxdZWQEKIRI7Z6fSGaObOR0tL8NGaMd03TpjVTUFCm7rknt6bMTJemTWuuGjVS1bdvbk2HDwdo5szGatTosGJjc2tKSAhWXFw9tW6dpLZtc/9O1ERN1ERNmzaVnm15enq6isJh8sa082jJkiW66aabrAQonUyBDodDTqdTK1asUJcuXXT06FGvvVLVq1fXyJEjNWrUKI0fP14fffSR4uPjremJiYmKiorSli1bdMUVVxT42gXtkapatap+//13BQUFSSrhXzFdrgv71+aL8Rd0aqImaiq+mrKyvNvZI1Wkmv73O98F+2tz3vaL5Rd0aqImaiq+mtLTS8+2PC0tTRUrVlRqaqqVDQpSYkHq2LFj+vXXX73aBgwYoLp16+rBBx9U1apVFRoaqri4OPXq1UuStGvXLtWtW1cbN25Uy5YttWzZMnXv3l0HDhxQWFiYJOm1117TmDFjlJKSIn9//yL1JS0tTcHBwWd8s86bPF9IAOCiUzLDzgWPoQHAxaw0DQ1FzQYldmhf+fLldfnll3u1BQYGqmLFilb7oEGDNHr0aFWoUEFBQUG677771KpVK7Vs2VKSdO2116p+/fq64447NHXqVCUnJ+vRRx/V0KFDixyiAAAAAMCuEr3YxJnMmDFDTqdTvXr1UkZGhmJiYvTyyy9b010ulz755BMNGTJErVq1UmBgoO666y5Nnjy5BHsNAAAA4GJXYof2lSYc2gcA5xHDzllhaABwMStNQ0NRs0GJ30cKAAAAAC40BCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGCT7SC1ZcsW/fDDD9bzDz/8UDfeeKP+85//KDMzs1g7BwAAAAClke0gdc8992j37t2SpISEBPXp00dly5bVokWLNHbs2GLvIAAAAACUNraD1O7du9WkSRNJ0qJFi9SuXTstXLhQc+fO1fvvv1/c/QMAAACAUsd2kDLGyOPxSJI+++wzdevWTZJUtWpVHT58uHh7BwAAAAClkO0g1axZMz3++OOaP3++1qxZo9jYWElSYmKiwsPDi72DAAAAAFDa2A5Szz33nLZs2aJhw4bpkUceUa1atSRJ7733nq6++upi7yAAAAAAlDYOY4wpjhX99ddfcrlc8vX1LY7VnVdpaWkKDg5WamqqgoKCSro7ksNR0j0AgHOneIadfxyGBgAXs9I0NBQ1G5zVfaT++OMPvfHGG3r44Yd15MgRSdJPP/2klJSUs+stAAAAAFxAfOwusG3bNnXu3FkhISH65ZdfdPfdd6tChQpavHix9u3bpzfffPNc9BMAAAAASg3be6RGjx6tAQMGaM+ePSpTpozV3q1bN61du7ZYOwcAAAAApZHtIPXdd9/pnnvuydd+6aWXKjk5uVg6BQAAAAClme0g5e/vr7S0tHztu3fvVmhoaLF0CgAAAABKM9tB6oYbbtDkyZOVlZUlSXI4HNq3b58efPBB9erVq9g7CAAAAAClje0gNX36dB0/flxhYWE6ceKE2rdvr1q1aql8+fJ64oknzkUfAQAAAKBUsX3VvuDgYK1atUpfffWVtm3bpuPHj6tp06bq0qXLuegfAAAAAJQ6xXZD3gsZN+QFgPOIYeesMDQAuJiVpqGhqNmgSHukXnjhhSK/8PDhw4s8LwAAAABciIq0R6pmzZpezw8dOqQ///xTISEhkqQ//vhDZcuWVVhYmBISEs5JR88l9kgBwHlUmn52vIAwNAC4mJWmoaGo2aBIF5tITEy0Hk888YSaNGmiHTt26MiRIzpy5Ih27Nihpk2b6rHHHiu2AgAAAACgtLJ9jlR0dLTee+89XXHFFV7tmzdvVu/evZWYmFisHTwf2CMFAOdRafrZ8QLC0ADgYlaahoZi3SOV14EDB5SdnZ2v3e126+DBg3ZXBwAAAAAXHNtBqnPnzrrnnnu0ZcsWq23z5s0aMmQIl0AHAAAA8I9gO0jNnj1blStXVrNmzeTv7y9/f39dddVVCg8P1xtvvHEu+ggAAAAApYrtG/KGhobq008/1e7du7Vjxw45HA7VrVtXtWvXPhf9AwAAAIBSx3aQylG7dm1ddtllkiQHZ8ACAAAA+AexfWifJL355ptq2LChAgICFBAQoEaNGmn+/PnF3TcAAAAAKJVs75F69tlnNW7cOA0bNkytW7eWJH311Vf697//rcOHD2vUqFHF3kkAAAAAKE1s30eqZs2amjRpku68806v9nnz5mnixIncR6o4cKgkgItZabpZyAWEoQHAxaw0DQ3n9D5SV199db72q6++WgcOHLC1rldeeUWNGjVSUFCQgoKC1KpVKy1btsya/tdff2no0KGqWLGiypUrp169euW7V9W+ffsUGxursmXLKiwsTGPGjCnwPlcAAAAAUFxsB6latWrp3Xffzdf+zjvvWBefKKrIyEg9/fTT2rx5szZt2qROnTqpR48e2r59uyRp1KhR+vjjj7Vo0SKtWbNGSUlJ6tmzp7W82+1WbGysMjMztWHDBs2bN09z587V+PHj7ZYFAAAAAEVm+9C+999/X7feequ6dOlinSO1fv16ff7553r33Xd10003/a0OVahQQdOmTVPv3r0VGhqqhQsXqnfv3pKknTt3ql69etq4caNatmypZcuWqXv37kpKSlJ4eLgk6dVXX9WDDz6oQ4cOyc/Pr0ivyaF9AHAelabjNy4gDA0ALmalaWgoajawfbGJXr166ZtvvtGMGTO0ZMkSSVK9evX07bff6oorrjjrDrvdbi1atEjp6elq1aqVNm/erKysLHXp0sWap27duqpWrZoVpDZu3KiGDRtaIUqSYmJiNGTIEG3fvr3Q/mRkZCgjI8N6npaWJknKzs62Dgt0Op1yOp3yeDzyeDzWvDntbrdbeTNoYe0ul0sOhyPf4YYul8uqO1+7wyG3r69Xu09mpozTKbdP7p/MYYxcWVnyOJ3yFNTucsnzv9eRJKfHI2d2tjw+PvI4c3dGOt1uOd1uuX19ZfKM1M7sbDk9nnztruxsOTweZZ8SVF1ZWZIxcp/anplJTdRETdSUW1MRt4c+Pj4yxni1OxwOuVyufNvmwtpLdFtezDXlvJ0ej1PZ2U75+HjkdObO73Y75XY75evrlsOR2/fsbKc8noLaXfJ4HPLz864pK8slYyQ/P+++Z2a65HBIvr6ntvvI6TTy8cltN8ahrCyXnE6PfHw8+dpdLo9crtx2aqImaqKm7OzSsy0v6mlCZ3UfqSuvvFJvvfXW2Syazw8//KBWrVrpr7/+Urly5fTBBx+ofv36io+Pl5+fn0JCQrzmDw8PV3JysiQpOTnZK0TlTM+ZVpinnnpKkyZNyte+detWBQYGSjp54+Ho6GglJibq0KFD1jyRkZGKjIzU7t27lZqaarVHRUUpLCxMP/74o06cOGG1161bVyEhIdq6davXwNmoUSP5+flp06ZNXn1o1qyZMitW1LZ77rHaXJmZaj5tmlJr1NDOvn2t9oDDh9V45kwdbtRICbGxVntwQoLqxcUpqXVr7W/b1moPjY9X9NKlSoyJ0aEmTXJrWrdOkWvXanfv3kqNisqtaelShcXH68eBA3WiUqXcmuLiFJKQoK0jRnh9yWs0c6b80tK0acwY75qmTVNmUBA1URM1UdPJmgra7mVmatu2bbk1uVxq3ry5UlNTtXPnztyaAgLUuHFjHT58WAkJCbk1BQerXr16SkpK0v79+3NrKslteTHXlPNRiI8P1dKl0YqJSVSTJrk1rVsXqbVrI9W7925FReXWtHRplOLjwzRw4I+qVCm3pri4ukpICNGIEVu9vhDNnNlIaWl+GjPGu6Zp05opKChT99yTW1NmpkvTpjVXjRqp6ts3t6bDhwM0c2ZjNWp0WLGxuTUlJAQrLq6eWrdOUtu2uX8naqImaqKmTZtKz7Y8PT1dRWH70L7ilpmZqX379ik1NVXvvfee3njjDa1Zs0bx8fEaMGCA154jSbrqqqvUsWNHTZkyRYMHD9avv/6qFStWWNP//PNPBQYG6tNPP1XXrl0LfM2C9khVrVpVv//+u7X7rkR/xXS5Luxfmy/GX9CpiZqoqfhqysrybmePVJFq+t/vfBfsr8152y+WX9CpiZqoqfhqSk8vPdvytLQ0VaxY8YyH9hU5SDmdTjnOcIB2QR2zq0uXLoqOjtatt96qzp076+jRo157papXr66RI0dq1KhRGj9+vD766CPFx8db0xMTExUVFaUtW7YU+VBDzpECgPOoNB0IfwFhaABwMStNQ0OxnyP1wQcfFDpt48aNeuGFF7wS4tnyeDzKyMjQlVdeKV9fX33++efq1auXJGnXrl3at2+fWrVqJUlq1aqVnnjiCaWkpCgsLEyStGrVKgUFBal+/fp/uy8AAAAAUJAiB6kePXrka9u1a5ceeughffzxx+rXr58mT55s68Uffvhhde3aVdWqVdOxY8e0cOFCffnll1qxYoWCg4M1aNAgjR49WhUqVFBQUJDuu+8+tWrVSi1btpQkXXvttapfv77uuOMOTZ06VcnJyXr00Uc1dOhQ+fv72+oLAAAAABTVWV1sIikpSRMmTNC8efMUExOj+Ph4XX755bbXk5KSojvvvFMHDhxQcHCwGjVqpBUrVuiaa66RJM2YMUNOp1O9evVSRkaGYmJi9PLLL1vLu1wuffLJJxoyZIhatWqlwMBA3XXXXbYDHQAAAADYYetiE6mpqXryySf14osvqkmTJpoyZYra5rni04WKc6QA4DwqTQfCX0AYGgBczErT0FDs50hNnTpVU6ZMUeXKlRUXF1fgoX4AAAAA8E9g66p9AQEB6tKli3WJwIIsXry42Dp3vrBHCgDOo9L0s+MFhKEBwMWsNA0Nxb5H6s477zzj5c8BAAAA4J+gyEFq7ty557AbAAAAAHDhcJ55FgAAAABAXgQpAAAAALCJIAUAAAAANhGkAAAAAMCmIgWppk2b6ujRo5KkyZMn688//zynnQIAAACA0qxIQWrHjh1KT0+XJE2aNEnHjx8/p50CAAAAgNKsSJc/b9KkiQYMGKA2bdrIGKNnnnlG5cqVK3De8ePHF2sHAQAAAKC0cRhz5vsI79q1SxMmTNDPP/+sLVu2qH79+vLxyZ/BHA6HtmzZck46ei4V9e7F5w03PgZwMStNt6+/gDA0ALiYlaahoajZoEhBKi+n06nk5GSFhYX97U6WFgQpADiPStNoeQFhaABwMStNQ0NRs0GRDu3Ly+Px/K2OAQAAAMCFznaQkqSff/5Zzz33nHbs2CFJql+/vkaMGKHo6Ohi7RwAAAAAlEa27yO1YsUK1a9fX99++60aNWqkRo0a6ZtvvlGDBg20atWqc9FHAAAAAChVbJ8jdcUVVygmJkZPP/20V/tDDz2klStXcrGJ4sCB8AAuZqXpQPgLCEMDgItZaRoaipoNbO+R2rFjhwYNGpSvfeDAgfrpp5/srg4AAAAALji2g1RoaKji4+PztcfHx19UV/IDAAAAgMLYvtjE3XffrcGDByshIUFXX321JGn9+vWaMmWKRo8eXewdBAAAAIDSxvY5UsYYPffcc5o+fbqSkpIkSRERERozZoyGDx8uxwV4EDfnSAHAeVSaDoS/gDA0ALiYlaah4ZzdkDevY8eOSZLKly9/tqsoFQhSAHAelabR8gLC0ADgYlaahoZzdkPevC70AAUAAAAAZ8P2xSYAAAAA4J+OIAUAAAAANhGkAAAAAMAmW0EqKytLnTt31p49e85VfwAAAACg1LMVpHx9fbVt27Zz1RcAAAAAuCDYPrTv9ttv16xZs85FXwAAAADggmD78ufZ2dmaPXu2PvvsM1155ZUKDAz0mv7ss88WW+cAAAAAoDSyHaR+/PFHNW3aVJK0e/dur2kO7hYIAAAA4B/AdpBavXr1uegHAAAAAFwwzvry53v37tWKFSt04sQJSZIxptg6BQAAAAClme0g9fvvv6tz586qXbu2unXrpgMHDkiSBg0apPvvv7/YOwgAAAAApY3tIDVq1Cj5+vpq3759Klu2rNV+6623avny5cXaOQAAAAAojWyfI7Vy5UqtWLFCkZGRXu2XXXaZfv3112LrGAAAAACUVrb3SKWnp3vticpx5MgR+fv7F0unAAAAAKA0sx2k2rZtqzfffNN67nA45PF4NHXqVHXs2LFYOwcAAAAApZHtQ/umTp2qzp07a9OmTcrMzNTYsWO1fft2HTlyROvXrz8XfQQAAACAUsX2HqnLL79cu3fvVps2bdSjRw+lp6erZ8+e2rp1q6Kjo89FHwEAAACgVHEYbgCltLQ0BQcHKzU1VUFBQSXdHcnhKOkeAMC5w7BzVhgaAFzMStPQUNRsYPvQPkk6evSoZs2apR07dkiS6tevrwEDBqhChQpn11sAAAAAuIDYPrRv7dq1qlGjhl544QUdPXpUR48e1QsvvKCaNWtq7dq156KPAAAAAFCq2D60r2HDhmrVqpVeeeUVuVwuSZLb7da9996rDRs26IcffjgnHT2XOLQPAM6j0nT8xgWEoQHAxaw0DQ1FzQa290jt3btX999/vxWiJMnlcmn06NHau3fv2fUWAAAAAC4gtoNU06ZNrXOj8tqxY4caN25cLJ0CAAAAgNKsSBeb2LZtm/Xv4cOHa8SIEdq7d69atmwpSfr666/10ksv6emnnz43vQQAAACAUqRI50g5nU45HA6daVaHwyG3211snTtfOEcKAM6j0nQg/AWEoQHAxaw0DQ3FevnzxMTEYusYAAAAAFzoihSkqlevfq77AQAAAAAXjLO6IW9SUpK++uorpaSkyOPxeE0bPnx4sXQMAAAAAEor20Fq7ty5uueee+Tn56eKFSvKkeegbYfDQZACAAAAcNGzHaTGjRun8ePH6+GHH5bTafvq6QAAAABwwbOdhP7880/16dOHEAUAAADgH8t2Gho0aJAWLVp0LvoCAAAAABeEIt1HKi+3263u3bvrxIkTatiwoXx9fb2mP/vss8XawfOB+0gBwHlUmm4WcgFhaABwMStNQ0Ox3kcqr6eeekorVqxQnTp1JCnfxSYAAAAA4GJnO0hNnz5ds2fPVv/+/c9BdwAAAACg9LN9jpS/v79at259LvoCAAAAABcE20FqxIgRevHFF89FXwAAAADggmD70L5vv/1WX3zxhT755BM1aNAg38UmFi9eXGydAwAAAIDSyHaQCgkJUc+ePc9FXwAAAADggmA7SM2ZM+dc9AMAAAAALhi2z5ECAAAAgH8623ukatasedr7RSUkJPytDgEAAABAaWc7SI0cOdLreVZWlrZu3arly5drzJgxxdUvAAAAACi1bAepESNGFNj+0ksvadOmTX+7QwAAAABQ2hXbOVJdu3bV+++/X1yrAwAAAIBSq9iC1HvvvacKFSoU1+oAAAAAoNSyfWjfFVdc4XWxCWOMkpOTdejQIb388svF2jkAAAAAKI1sB6kbb7zR67nT6VRoaKg6dOigunXrFle/AAAAAKDUchhjTEl3oqSlpaUpODhYqampCgoKKunuSKe5vDwAXPAYds4KQwOAi1lpGhqKmg24IS8AAAAA2FTkQ/ucTudpb8QrSQ6HQ9nZ2X+7UwAAAABQmhU5SH3wwQeFTtu4caNeeOEFeTyeYukUAAAAAJRmRT60r0ePHvkedevW1dy5c/XMM8/o5ptv1q5du2y9+FNPPaXmzZurfPnyCgsL04033phvHX/99ZeGDh2qihUrqly5curVq5cOHjzoNc++ffsUGxursmXLKiwsTGPGjGHPGAAAAIBz5qzOkUpKStLdd9+thg0bKjs7W/Hx8Zo3b56qV69uaz1r1qzR0KFD9fXXX2vVqlXKysrStddeq/T0dGueUaNG6eOPP9aiRYu0Zs0aJSUlqWfPntZ0t9ut2NhYZWZmasOGDZo3b57mzp2r8ePHn01pAAAAAHBmxoY//vjDjB071gQEBJhWrVqZtWvX2ln8jFJSUowks2bNGuv1fH19zaJFi6x5duzYYSSZjRs3GmOM+fTTT43T6TTJycnWPK+88ooJCgoyGRkZRXrd1NRUI8mkpqYWYzV/w8kLl/DgwYPHxfnAWSnpPxsPHjx4nMtHaVLUbFDkc6SmTp2qKVOmqHLlyoqLi1OPHj2KPdSlpqZKkipUqCBJ2rx5s7KystSlSxdrnrp166patWrauHGjWrZsqY0bN6phw4YKDw+35omJidGQIUO0fft2XXHFFfleJyMjQxkZGdbztLQ0SVJ2drZ1SKDT6ZTT6ZTH4/E69yun3e12yxhzxnaXy1XgRThcLpekk3vU8rU7HHL7+nq1+2Rmyjidcvvk/skcxsiVlSWP0ylPQe0ulzz/ex1Jcno8cmZny+PjI48zd2ek0+2W0+2W29dXJs8FRZzZ2XJ6PPnaXdnZcng8yvbz8+57VpZkjNyntmdmUhM1URM15dZUxO2hj4+PjDFe7Q6HQy6XK9+2ubD2Et2WF3NNOW+nx+NUdrZTPj4eOZ2587vdTrndTvn6uuVw5PY9O9spj6egdpc8Hof8/LxryspyyRjJz8+775mZLjkckq/vqe0+cjqNfHxy241xKCvLJafTIx8fT752l8sjlyu3nZqoiZqoKTu79GzLi3qKUJGD1EMPPaSAgADVqlVL8+bN07x58wqcb/HixUVdpRePx6ORI0eqdevWuvzyyyVJycnJ8vPzU0hIiNe84eHhSk5OtubJG6JypudMK8hTTz2lSZMm5WvfunWrAgMDJUmhoaGKjo5WYmKiDh06ZM0TGRmpyMhI7d692wp+khQVFaWwsDD9+OOPOnHihNVet25dhYSEaOvWrV4DZ6NGjeTn56dNmzZ59aFZs2bKrFhR2+65x2pzZWaq+bRpSq1RQzv79rXaAw4fVuOZM3W4USMlxMZa7cEJCaoXF6ek1q21v21bqz00Pl7RS5cqMSZGh5o0ya1p3TpFrl2r3b17KzUqKrempUsVFh+vHwcO1IlKlXJriotTSEKCto4Y4fUlr9HMmfJLS9OmMWO8a5o2TZlBQdRETdRETSdrKmi7l5mpbdu25dbkcql58+ZKTU3Vzp07c2sKCFDjxo11+PBhJSQk5NYUHKx69eopKSlJ+/fvz62pJLflxVxTzkchPj5US5dGKyYmUU2a5Na0bl2k1q6NVO/euxUVlVvT0qVRio8P08CBP6pSpdya4uLqKiEhRCNGbPX6QjRzZiOlpflpzBjvmqZNa6agoEzdc09uTZmZLk2b1lw1aqSqb9/cmg4fDtDMmY3VqNFhxcbm1pSQEKy4uHpq3TpJbdvm/p2oiZqoiZo2bSo92/K8pxmdTpFvyNu/f/8zXv5ckubMmVOkFz7VkCFDtGzZMn311VeKjIyUJC1cuFADBgzw2nskSVdddZU6duyoKVOmaPDgwfr111+1YsUKa/qff/6pwMBAffrpp+ratWu+1ypoj1TVqlX1+++/WzfdKtFfMV2uC/vX5ovxF3RqoiZqKr6asrK829kjVaSa/vc73wX7a3Pe9ovlF3RqoiZqKr6a0tNLz7Y8LS1NFStWPOMNeYscpM6lYcOG6cMPP9TatWtVs2ZNq/2LL75Q586ddfToUa+9UtWrV9fIkSM1atQojR8/Xh999JHi4+Ot6YmJiYqKitKWLVsKPLTvVEW9e/F5w+3rAVzMSn7YuSAxNAC4mJWmoaGo2eCsrtpXXIwxGjZsmD744AN98cUXXiFKkq688kr5+vrq888/t9p27dqlffv2qVWrVpKkVq1a6YcfflBKSoo1z6pVqxQUFKT69eufn0IAAAAA/KMU+Rypc2Ho0KFauHChPvzwQ5UvX946pyk4OFgBAQEKDg7WoEGDNHr0aFWoUEFBQUG677771KpVK7Vs2VKSdO2116p+/fq64447NHXqVCUnJ+vRRx/V0KFD5e/vX5LlAQAAALhIleihfYWdczVnzhz1799f0skb8t5///2Ki4tTRkaGYmJi9PLLL6ty5crW/L/++quGDBmiL7/8UoGBgbrrrrv09NNPy8enaDmRQ/sA4DwqTcdvXEAYGgBczErT0FDUbFAqzpEqaQQpADiPGHbOCkMDgItZaRoaLohzpAAAAADgQkSQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYFOJBqm1a9fq+uuvV0REhBwOh5YsWeI13Rij8ePHq0qVKgoICFCXLl20Z88er3mOHDmifv36KSgoSCEhIRo0aJCOHz9+HqsAAAAA8E9TokEqPT1djRs31ksvvVTg9KlTp+qFF17Qq6++qm+++UaBgYGKiYnRX3/9Zc3Tr18/bd++XatWrdInn3yitWvXavDgweerBAAAAAD/QA5jjCnpTkiSw+HQBx98oBtvvFHSyb1RERERuv/++/XAAw9IklJTUxUeHq65c+eqT58+2rFjh+rXr6/vvvtOzZo1kyQtX75c3bp10/79+xUREVGk105LS1NwcLBSU1MVFBR0TuqzxeEo6R4AwLlTOoadCw5DA4CLWWkaGoqaDXzOY59sSUxMVHJysrp06WK1BQcHq0WLFtq4caP69OmjjRs3KiQkxApRktSlSxc5nU598803uummmwpcd0ZGhjIyMqznaWlpkqTs7GxlZ2dLkpxOp5xOpzwejzwejzVvTrvb7VbeDFpYu8vlksPhsNabt12S3G53/naHQ25fX692n8xMGadTbp/cP5nDGLmysuRxOuUpqN3lkud/ryNJTo9HzuxseXx85HHm7ox0ut1yut1y+/rK5BmpndnZcno8+dpd2dlyeDzK9vPz7ntWlmSM3Ke2Z2ZSEzVREzXl1lTE7aGPj4+MMV7tDodDLpcr37a5sPYS3ZYXc005b6fH41R2tlM+Ph45nbnzu91Oud1O+fq65XDk9j072ymPp6B2lzweh/z8vGvKynLJGMnPz7vvmZkuORySr++p7T5yOo18fHLbjXEoK8slp9MjHx9PvnaXyyOXK7edmqiJmqgpO7v0bMtPnV6YUhukkpOTJUnh4eFe7eHh4da05ORkhYWFeU338fFRhQoVrHkK8tRTT2nSpEn52rdu3arAwEBJUmhoqKKjo5WYmKhDhw5Z80RGRioyMlK7d+9Wamqq1R4VFaWwsDD9+OOPOnHihNVet25dhYSEaOvWrV4DZ6NGjeTn56dNmzZ59aFZs2bKrFhR2+65x2pzZWaq+bRpSq1RQzv79rXaAw4fVuOZM3W4USMlxMZa7cEJCaoXF6ek1q21v21bqz00Pl7RS5cqMSZGh5o0ya1p3TpFrl2r3b17KzUqKrempUsVFh+vHwcO1IlKlXJriotTSEKCto4Y4fUlr9HMmfJLS9OmMWO8a5o2TZlBQdRETdRETSdrKmi7l5mpbdu25dbkcql58+ZKTU3Vzp07c2sKCFDjxo11+PBhJSQk5NYUHKx69eopKSlJ+/fvz62pJLflxVxTzkchPj5US5dGKyYmUU2a5Na0bl2k1q6NVO/euxUVlVvT0qVRio8P08CBP6pSpdya4uLqKiEhRCNGbPX6QjRzZiOlpflpzBjvmqZNa6agoEzdc09uTZmZLk2b1lw1aqSqb9/cmg4fDtDMmY3VqNFhxcbm1pSQEKy4uHpq3TpJbdvm/p2oiZqoiZo2bSo92/L09HQVRak9tG/Dhg1q3bq1kpKSVKVKFWu+W265RQ6HQ++8846efPJJzZs3T7t27fJaV1hYmCZNmqQhQ4YU+FoF7ZGqWrWqfv/9d2v3XYn+iulyXdi/Nl+Mv6BTEzVRU/HVlJXl3c4eqSLV9L/f+S7YX5vztl8sv6BTEzVRU/HVlJ5eerblaWlpqlix4oV7aF/lypUlSQcPHvQKUgcPHlST//1SWrlyZaWkpHgtl52drSNHjljLF8Tf31/+/v752n18fOTj4/2W5PwhTuXK8+WjKO2nrve07cbIJzMzX7PD4ymw3enxyFlQ+/++/ORrz84u8CojrlO+3JypvaC+FNpOTdQkajpd+z+qJhvbQ4fDUWB7Ydtmu+3ndFteSPvZ1nTq25md7VRB14zKyiq474W1Z2YW3PeC2o0puN3jcRTS7lRmZv4+5nyhOxU1UVNh7dR08deUd7NY0tvywqbn60+R5ioBNWvWVOXKlfX5559bbWlpafrmm2/UqlUrSVKrVq30xx9/aPPmzdY8X3zxhTwej1q0aHHe+wwAAADgn6FE90gdP35ce/futZ4nJiYqPj5eFSpUULVq1TRy5Eg9/vjjuuyyy1SzZk2NGzdOERER1uF/9erV03XXXae7775br776qrKysjRs2DD16dOnyFfsAwAAAAC7SjRIbdq0SR07drSejx49WpJ01113ae7cuRo7dqzS09M1ePBg/fHHH2rTpo2WL1+uMmXKWMssWLBAw4YNU+fOneV0OtWrVy+98MIL570WAAAAAP8cpeZiEyWJ+0gBwHnEsHNWGBoAXMxK09BQ1GxQas+RAgAAAIDSiiAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAJoIUAAAAANhEkAIAAAAAmwhSAAAAAGATQQoAAAAAbCJIAQAAAIBNBCkAAAAAsIkgBQAAAAA2EaQAAAAAwCaCFAAAAADYRJACAAAAAJsIUgAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACwiSAFAAAAADYRpAAAAADAposmSL300kuqUaOGypQpoxYtWujbb78t6S4BAAAAuEhdFEHqnXfe0ejRozVhwgRt2bJFjRs3VkxMjFJSUkq6awAAAAAuQhdFkHr22Wd19913a8CAAapfv75effVVlS1bVrNnzy7prgEAAAC4CPmUdAf+rszMTG3evFkPP/yw1eZ0OtWlSxdt3LixwGUyMjKUkZFhPU9NTZUkHTlyRNnZ2dY6nE6nPB6PPB6P17qdTqfcbreMMWdsd7lccjgc1nrztkuS2+0uuN3X16vdJytLxuGQ2yf3T+YwRq7sbHkcDnkKanc65fnf+iTJ6fHI6XbL43LJ48zN0E63W06PR24fHxmHI7c9O1tOY/K1u7Kz5TBG2af00ZWVVWDfC2unJmqipn9oTUeOeLcXsj308fGRMcar3eFwyOVy5ds2F9Ze4tvyYqwp5+30eJxyu51yuTxyOnPnd7ud8nic8vFxy+HI7Xt2tlPGFNTukjEO+fp615SVdbLvvr7uIrb7yOEw8vHJbTfGoexslxwOj3x8PPnanU6PXK7cdmqiJmqipiNHSs+2PC0t7X/9NDodhznTHKVcUlKSLr30Um3YsEGtWrWy2seOHas1a9bom2++ybfMxIkTNWnSpPPZTQAAAAAXkN9++02RkZGFTr/g90idjYcfflijR4+2nns8Hh05ckQVK1aUI8+vqsDFLi0tTVWrVtVvv/2moKCgku4OAKCUYHzAP5kxRseOHVNERMRp57vgg1SlSpXkcrl08OBBr/aDBw+qcuXKBS7j7+8vf39/r7aQkJBz1UWg1AsKCmKgBADkw/iAf6rg4OAzznPBX2zCz89PV155pT7//HOrzePx6PPPP/c61A8AAAAAissFv0dKkkaPHq277rpLzZo101VXXaXnnntO6enpGjBgQEl3DQAAAMBF6KIIUrfeeqsOHTqk8ePHKzk5WU2aNNHy5csVHh5e0l0DSjV/f39NmDAh36GuAIB/NsYH4Mwu+Kv2AQAAAMD5dsGfIwUAAAAA5xtBCgAAAABsIkgBAAAAgE0EKVzwatSooeeee66kuyFJ6t+/v2688cbTzvPll1/K4XDojz/+OC99AoBziW1w6fVPqhUoCQQpnHP9+/eXw+HQ008/7dW+ZMkSORyOEurVufH8889r7ty51vMOHTpo5MiRxbLuJ554QldffbXKli1b5BtId+jQwas/OZ566im5XC5NmzYt37S5c+fK4XDI4XDI6XQqMjJSAwYMUEpKijVPznSHw6Hg4GC1bt1aX3zxhdfrFlT33Llzvfo+ceJEORwO/fvf//aaLz4+Xg6HQ7/88ku+dcTExMjlcum7776z2u677z7Vq1evwPdg3759crlc+uijj6y+F7TevH3PW1/O49Q+nmtF+UIIFAXb4JEl1p/zqbTVunbtWl1//fWKiIiQw+HQkiVLzrjM3Llz1aFDh3zt+/fvl5+fny6//PIClzvTmJTzf8DhcMjPz0+1atXS5MmTlZ2dbb1uYeNq3r7/8ssvcjgcCgsL07Fjx7zma9KkiSZOnJhv+bi4OLlcLg0dOtRq27x5sxwOh77++usCX7Nz587q2bOn1feC1psj75id91GmTJlClzkX/qmhnSCF86JMmTKaMmWKjh49WtJdOaeCg4OLHHLsyszM1M0336whQ4b87XXNnj1bY8eO1ezZswucHhQUpAMHDmj//v16/fXXtWzZMt1xxx1e88yZM0cHDhzQ+vXrValSJXXv3l0JCQm2+1KmTBnNmjVLe/bsOeO8+/bt04YNGzRs2DCvvg8aNEg7d+7Uhg0b8i0zd+5chYWFqVu3bkXu0913360DBw54PaZOnVrk5YHShm3whSMrK6uku1As0tPT1bhxY7300kt/e11z587VLbfcorS0NH3zzTcFznOmMem6667TgQMHtGfPHt1///2aOHFigT8mFsWxY8f0zDPPFGneWbNmaezYsYqLi9Nff/0lSbryyivVuHHjAsfgX375RatXr9agQYOK3J+cMTvv49dffy3y8jh7BCmcF126dFHlypX11FNPnXa+999/Xw0aNJC/v79q1Kih6dOne01PSUnR9ddfr4CAANWsWVMLFizIt44//vhD//rXvxQaGqqgoCB16tRJ33//vTX9+++/V8eOHVW+fHkFBQXpyiuv1KZNmwrszwMPPKDu3btbz5977jk5HA4tX77caqtVq5beeOMNSd57Efr37681a9bo+eeft34hyrsnZPPmzWrWrJnKli2rq6++Wrt27TrtezNp0iSNGjVKDRs2PO18Z7JmzRqdOHFCkydPVlpaWoHhw+FwqHLlyoqIiFDXrl01fPhwffbZZzpx4oQ1T0hIiCpXrqzLL79cr7zyik6cOKFVq1bZ7k+dOnXUsWNHPfLII2ecd86cOerevbuGDBmiuLg4qz9NmjRR06ZN8w1KxhjNnTtXd911l3x8in7bvLJly6py5cpej6CgIEnS1VdfrQcffNBr/kOHDsnX11dr166VJGVkZOiBBx7QpZdeqsDAQLVo0UJffvmlNX/Or58rVqxQvXr1VK5cOWuQl07uqZs3b54+/PBD67OTd3nALrbBf28bnLMn4t1331Xbtm0VEBCg5s2ba/fu3fruu+/UrFkzlStXTl27dtWhQ4es5TwejyZPnqzIyEj5+/tb97k8db3vvPOO2rdvrzJlyljv6RtvvKF69eqpTJkyqlu3rl5++eVC+/d3av3555/Vo0cPhYeHq1y5cmrevLk+++wzr/XXqFFDTz75pAYOHKjy5curWrVqeu211wrtjyR17dpVjz/+uG666abTzncmxhjNmTNHd9xxh2677TbNmjWrwPnONCb5+/urcuXKql69uoYMGaIuXbpYRyrYdd999+nZZ5/1OlKjIImJidqwYYMeeugh1a5dW4sXL7amDRo0SO+8847+/PNPr2Xmzp2rKlWq6Lrrrityf3LG7LyPnHupvvbaa4qIiJDH4/FapkePHho4cKD1/MMPP1TTpk1VpkwZRUVFadKkSdYeu5zXeOONN3TTTTepbNmyuuyyy6z375dfflHHjh0lSZdccokcDof69+9f5P5fyAhSOC9cLpeefPJJvfjii9q/f3+B82zevFm33HKL+vTpox9++EETJ07UuHHjvA7T6N+/v3777TetXr1a7733nl5++eV8G7Kbb75ZKSkpWrZsmTZv3qymTZuqc+fOOnLkiCSpX79+ioyM1HfffafNmzfroYcekq+vb4F9at++vb766iu53W5JJ0NIpUqVrC+1//d//6eff/65wEMRnn/+ebVq1cpr70bVqlWt6Y888oimT5+uTZs2ycfHx2uDdi7NmjVLffv2la+vr/r27VvooJRXQECAPB6P10b11OnSyb1mZ+Ppp5/W+++/X+iXKSl3ML399ttVt25d1apVS++99541fdCgQXr33XeVnp5utX355ZdKTEws1ve2X79+evvtt5X3FnzvvPOOIiIi1LZtW0nSsGHDtHHjRr399tvatm2bbr75Zl133XVee93+/PNPPfPMM5o/f77Wrl2rffv26YEHHpB08svjLbfcYoWrAwcO6Oqrry62GvDPwza4eLbBEyZM0KOPPqotW7bIx8dHt912m8aOHavnn39e69at0969ezV+/HivPkyfPl3PPPOMtm3bppiYGN1www359sA/9NBDGjFihHbs2KGYmBgtWLBA48eP1xNPPKEdO3boySef1Lhx4zRv3rwC+/V3aj1+/Li6deumzz//XFu3btV1112n66+/Xvv27fN6jenTp6tZs2baunWr7r33Xg0ZMuSMPwAWh9WrV+vPP/9Uly5ddPvtt+vtt9/22s4XpChjUkBAwFmPWX379rUODzydOXPmKDY2VsHBwbr99tu9xtt+/fopIyPDaxwzxmjevHnq37+/XC7XWfXtVDfffLN+//13rV692mo7cuSIli9frn79+kmS1q1bpzvvvFMjRozQTz/9pJkzZ2ru3Ll64oknvNY1adIk3XLLLdq2bZu6deumfv366ciRI6pataref/99SdKuXbt04MABPf/888XS/1LPAOfYXXfdZXr06GGMMaZly5Zm4MCBxhhjPvjgA5P3I3jbbbeZa665xmvZMWPGmPr16xtjjNm1a5eRZL799ltr+o4dO4wkM2PGDGOMMevWrTNBQUHmr7/+8lpPdHS0mTlzpjHGmPLly5u5c+cWqe9Hjx41TqfTfPfdd8bj8ZgKFSqYp556yrRo0cIYY8xbb71lLr300gJrNcaY9u3bmxEjRnitc/Xq1UaS+eyzz6y2pUuXGknmxIkTZ+zTnDlzTHBwcJH6f6rU1FQTEBBg4uPjjTHGbN261ZQrV84cO3as0PXv3r3b1K5d2zRr1sxqk2Q++OADY4wx6enp5t577zUul8t8//33xpiC6y5o3RMmTDCNGzc2xhjTp08f06lTJ6tfkkxiYqI178qVK01oaKjJysoyxhgzY8YM0759e2v60aNHTZkyZcycOXOstjvuuMO0adOmqG+P1XdfX18TGBjo9XjrrbeMMcakpKQYHx8fs3btWmuZVq1amQcffNAYY8yvv/5qXC6X+b//+z+v9Xbu3Nk8/PDD1vsgyezdu9ea/tJLL5nw8HDr+amfJeBssQ0e4bXOs9kGJyYmGknmjTfesNri4uKMJPP5559bbU899ZSpU6eO9TwiIsI88cQTXutq3ry5uffee73W+9xzz3nNEx0dbRYuXOjV9thjj5lWrVoV2L/irNUYYxo0aGBefPFF63n16tXN7bffbj33eDwmLCzMvPLKK4WuI6+8Y4Zdt912mxk5cqT1vHHjxl7b+VPXX9CYlPdz4fF4zKpVq4y/v7954IEHjDGnH1fzrjvn77V161azfPly4+vra23HGzdubCZMmGAt53a7TdWqVc2SJUuMMcYcOnTI+Pn5mYSEBGuePn36eI1jn3/+uZFk9uzZU+T3J2c8OXXMuu6666x5evToYf2/N8aYmTNnmoiICON2u40xJ8enJ5980mu98+fPN1WqVPF6Hx599FHr+fHjx40ks2zZMmNM7mft6NGjRe77xYA9UjivpkyZonnz5mnHjh35pu3YsUOtW7f2amvdurX27Nkjt9utHTt2yMfHR1deeaU1vW7dul7Hw3///fc6fvy4KlasqHLlylmPxMRE/fzzz5Kk0aNH61//+pe6dOmip59+2movSEhIiBo3bqwvv/xSP/zwg/z8/DR48GBt3bpVx48f15o1a9S+ffuzei8aNWpk/btKlSqSdMbDBP6uuLg4RUdHq3HjxpJOHhJXvXp1vfPOO17zpaamqly5cipbtqzq1Kmj8PDwfIfw9O3bV+XKlVP58uX1/vvva9asWV412fX4449r3bp1WrlyZYHTZ8+erVtvvdU6RK9v375av3699fcLCQlRz549rcP70tLS9P7779s6zjxHv379FB8f7/W44YYbJEmhoaG69tprrfcjMTFRGzdutH7Z++GHH+R2u1W7dm2vz+CaNWu8Pmtly5ZVdHS09bxKlSrn/O8PsA3OdTbb4LzL5Bw6lfdw6/DwcGsdaWlpSkpKKvA9PfX9b9asmfXv9PR0/fzzzxo0aJDXe/j444+f9r0qar9PrfX48eN64IEHVK9ePYWEhKhcuXLasWNHvj1SedeRcyjZud5m/fHHH1q8eLFuv/12q+3UPTs5zjQmffLJJypXrpzKlCmjrl276tZbbz3tRRzOJCYmRm3atNG4ceMKnL5q1Sqlp6db5+dWqlRJ11xzjdch6AMHDtTatWutv+vs2bPVvn171apVy1Zfypcvn2/MyjncVTo5pr3//vvKyMiQJC1YsEB9+vSR03kyBnz//feaPHmy1+ctZ+9m3kMP876fgYGBCgoK+sePW0U/aQAoBu3atVNMTIwefvjhc3L87PHjx1WlSpUCzyfJGewnTpyo2267TUuXLtWyZcs0YcIEvf3224Uex92hQwd9+eWX8vf3V/v27VWhQgXVq1dPX331ldasWaP777//rPqa91CWnCtnnXoMc3GbNWuWtm/f7nW+kMfj0ezZs70CR/ny5bVlyxY5nU5VqVLFOkwirxkzZqhLly4KDg5WaGio17SgoCClpqbmW+aPP/5QcHBwgX2Ljo7W3XffrYceeijfIHnkyBF98MEHysrK0iuvvGK1u91uzZ492zr8YNCgQercubP27t2r1atXy+Vy6eabby7CO+MtODj4tANZv379NHz4cL344otauHChGjZsaH2ZOn78uFwulzZv3pzv0Ixy5cpZ/z71UCaHw+F1uCBwLrANznU22+CCljm17Wy244GBgda/jx8/Lkl6/fXX1aJFC6/5zvZwr9PV+sADD2jVqlV65plnVKtWLQUEBKh37975DnsraJt1rseshQsX6q+//vJ6H4wx8ng82r17t2rXrm21n25MkqSOHTvqlVdekZ+fnyIiIrzGwaCgIKWnp8vj8VjhQpJ1BbrCxq2nn35arVq10pgxY/JNmzVrlo4cOeI1fno8Hm3btk2TJk2S0+lU586dVa1aNc2dO1djxozR4sWLNXPmzKK/Qf/jdDpPO2Zdf/31MsZo6dKlat68udatW6cZM2ZY048fP65JkyZZVwrMK+/V/0riM1DaEaRw3j399NNq0qSJ6tSp49Ver149rV+/3qtt/fr1ql27tlwul+rWravs7Gxt3rxZzZs3l3TyWNy8l9ps2rSpkpOT5ePjoxo1ahTah9q1a6t27doaNWqU+vbtqzlz5hQ6iLdv316zZ8+Wj4+PdfJnhw4dFBcXp927dxd4bH4OPz8/69j+kvbDDz9o06ZN+vLLL1WhQgWr/ciRI+rQoYN27typunXrSjrzRlmSKleuXOg8derUKXDP0pYtW7wGvlONHz9e0dHRevvtt73aFyxYoMjIyHyXz125cqWmT5+uyZMny+VyqWPHjqpZs6bmzJmj1atXq0+fPl5fUIpLjx49NHjwYC1fvlwLFy7UnXfeaU274oor5Ha7lZKSYp0zdTZK02cHFxe2wedHUFCQIiIitH79eq+9ZuvXr9dVV11V6HLh4eGKiIhQQkKCtae7KM621vXr16t///7W+3/8+PHT3iLifJo1a5buv//+fKH/3nvv1ezZs70u6X+6MUk6GVZPN2ZlZ2crPj5eTZs2tdq3bNkiSYWOW1dddZV69uyphx56yKv9999/14cffqi3335bDRo0sNrdbrfatGmjlStX6rrrrpPT6dSAAQM0a9YsXXrppfLz81Pv3r0LreFslSlTRj179tSCBQu0d+9e1alTx6vOpk2bateuXbb3hOXl5+cnSf+4cYsghfOuYcOG6tevn1544QWv9vvvv1/NmzfXY489pltvvVUbN27Uf//7X+tKRXXq1NF1112ne+65R6+88op8fHw0cuRIr197unTpolatWunGG2/U1KlTVbt2bSUlJWnp0qW66aab1KBBA40ZM0a9e/dWzZo1tX//fn333Xfq1atXof1t166djh07pk8++cTaaHfo0EG9e/dWlSpVThsMatSooW+++Ua//PKLypUr5xVg7Nq3b5+OHDmiffv2ye12Kz4+XtLJK1bl3dNRmFmzZumqq65Su3bt8k1r3ry5Zs2addaXgj3VkCFD9N///lfDhw/Xv/71L/n7+2vp0qWKi4vTxx9/XOhy4eHhGj16dL5+zJo1S7179853D5GqVavq4Ycf1vLlyxUbGyuHw6GBAwfq2Wef1dGjR71+cbPjzz//VHJyslebv7+/LrnkEkknB+Qbb7xR48aN044dO9S3b19rvtq1a6tfv3668847NX36dF1xxRU6dOiQPv/8czVq1EixsbFF6kONGjW0YsUK7dq1SxUrVlRwcHChJ+QDdrANPn/GjBmjCRMmKDo6Wk2aNNGcOXMUHx9f4NUO85o0aZKGDx+u4OBgXXfddcrIyNCmTZt09OhRjR49usBlzrbWyy67TIsXL9b1118vh8OhcePGFctehuPHj2vv3r3W88TERMXHx6tChQqqVq3aGZePj4/Xli1btGDBAutHvhx9+/bV5MmT9fjjj9u6ImthGjRooGuvvVYDBw7U9OnTFRUVpV27dmnkyJG69dZbdemllxa67BNPPKEGDRp49WP+/PmqWLGibrnllnz3auvWrZtmzZpl/SgwYMAATZ48Wf/5z3/Ut2/fAo8AORNjTL4xS5LCwsKsPWz9+vVT9+7dtX37dq9DJaWTP2J2795d1apVU+/eveV0OvX999/rxx9/1OOPP16kPlSvXl0Oh0OffPKJunXrpoCAgCJ9N7nglewpWvgnKOik+cTEROPn52dO/Qi+9957pn79+sbX19dUq1bNTJs2zWv6gQMHTGxsrPH39zfVqlUzb775pqlevbp1orMxxqSlpZn77rvPREREGF9fX1O1alXTr18/s2/fPpORkWH69Oljqlatavz8/ExERIQZNmzYGS/y0LhxY1O5cmXr+e+//24cDofp06fPaWvdtWuXadmypQkICLAunlDQCZkFXVyhoPdRUr7H6tWrT9t3Y4zJyMgwFStWNFOnTi1w+pQpU0xYWJjJzMws0sUsVIQTh7/99ltzzTXXmNDQUBMcHGxatGiRb5m8F5vIkZqaaipVqmS9H5s2bcp3gnteXbt2NTfddJP1/LfffjNOp9M0aNDgtP0rTPv27Qt8n2NiYrzm+/TTT40k065du3zryMzMNOPHjzc1atQwvr6+pkqVKuamm24y27ZtM8YUfGLzqSf+p6SkmGuuucaUK1euyH9noCBsg//+NjjvRQZyFLSeU/9vu91uM3HiRHPppZcaX19f07hxY+vk/MLWm2PBggWmSZMmxs/Pz1xyySWmXbt2ZvHixYW+R2dba2JiounYsaMJCAgwVatWNf/973/zXbji1L+xMfkvrnCqnNc+9XHXXXcVukxew4YNsy50cqoDBw4Yp9NpPvzwQ2PMmcekoly85+jRo2b48OEmOjraBAQEmMsuu8yMHTvW62JMhf29Bg8ebCRZ70fDhg2tC4qc6p133jF+fn7m0KFDVtu111572nHudHIuNlHQ48CBA9Z8brfbVKlSxUgyP//8c771LF++3Fx99dUmICDABAUFmauuusq89tpr1vSC3uPg4GCvC39MnjzZVK5c2TgcjiL/nS90DmM4KB8AAAAA7OCqfQAAAABgE0EKAAAAAGwiSAEAAACATQQpAAAAALCJIAUAAAAANhGkAAAAAMAmghQAAAAA2ESQAgAAAACbCFIAAAAAYBNBCgAAAABsIkgBAAAAgE0EKQAAAACw6f8BserfcnEYPBUAAAAASUVORK5CYII=",
      "text/plain": [
       "<Figure size 1000x600 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "plt.figure(figsize=(10, 6))\n",
    "plt.bar([\"Nodes with 1 'APPUNAV' Event\", \"Nodes with more than 1 'APPUNAV' Event\"],\n",
    "        [smallest_num_appunav_events.count(), sql_result_df.count() - smallest_num_appunav_events.count()], color=[\"red\", \"blue\"])\n",
    "\n",
    "# Adding labels and title\n",
    "plt.ylabel(\"Number of Nodes\")\n",
    "plt.title(\"Distribution of Nodes with 'APPUNAV' Events\")\n",
    "plt.grid(axis='y', linestyle='--', alpha=0.7)\n",
    "\n",
    "# Showing the plot\n",
    "plt.show()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "f69c48b8",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Measuring end of execution time. \n",
    "#https://docs.python.org/3/library/time.html\n",
    "#returns the value (in fractional seconds) of a performance counter.It does include time elapsed during sleep and is system-wide.\n",
    "executiontimeend= time.perf_counter()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "9d897ef2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14.664776831006748"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculating the total execution time by subtracting the start time from the end time.\n",
    "# Calculating the total execution time as  time.perf_counter() returns the absolute value of the counter\n",
    "# https://stackoverflow.com/questions/25785243/understanding-time-perf-counter-and-time-process-time\n",
    "totalexecution_time= executiontimeend - executiontimestart\n",
    "totalexecution_time"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "3efd5715",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "\n",
       "            <div>\n",
       "                <p><b>SparkSession - hive</b></p>\n",
       "                \n",
       "        <div>\n",
       "            <p><b>SparkContext</b></p>\n",
       "\n",
       "            <p><a href=\"http://192.168.64.4:4041\">Spark UI</a></p>\n",
       "\n",
       "            <dl>\n",
       "              <dt>Version</dt>\n",
       "                <dd><code>v3.4.0</code></dd>\n",
       "              <dt>Master</dt>\n",
       "                <dd><code>local[*]</code></dd>\n",
       "              <dt>AppName</dt>\n",
       "                <dd><code>PySparkShell</code></dd>\n",
       "            </dl>\n",
       "        </div>\n",
       "        \n",
       "            </div>\n",
       "        "
      ],
      "text/plain": [
       "<pyspark.sql.session.SparkSession at 0xffff59e37820>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# all the information on the 'spark runtime environment', executors sumamry, jobs and its stages can be found on 'Spark UI'\n",
    "spark"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f4007b2d",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.10.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}