Insights_through_AI.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "source": [
        "## Importing Libraries"
      ],
      "metadata": {
        "id": "o5tAhZyMoyYI"
      }
    },
    {
      "cell_type": "code",
      "execution_count": null,
      "metadata": {
        "id": "2uk1t8BhfbQi"
      },
      "outputs": [],
      "source": [
        "import os\n",
        "\n",
        "import google.generativeai as genai"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Model setup"
      ],
      "metadata": {
        "id": "X1ixHWCmo0rx"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# configure API Key\n",
        "genai.configure(api_key=\"AIzaSyBhjdCRZsjjua89gWk4tMTI-oyp1mpcOsY\")"
      ],
      "metadata": {
        "id": "gzb5xjszojV3"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Create the model\n",
        "# See https://ai.google.dev/api/python/google/generativeai/GenerativeModel\n",
        "generation_config = {\n",
        "  \"temperature\": 1,    # we want acc data so we set the temp is 1 if we want randam ans then we have to set close to 0\n",
        "  \"top_p\": 0.95,\n",
        "  \"top_k\": 64,\n",
        "  \"max_output_tokens\": 8192,\n",
        "  \"response_mime_type\": \"text/plain\",\n",
        "}\n"
      ],
      "metadata": {
        "id": "09-LELzgoqJa"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "model = genai.GenerativeModel(\n",
        "  model_name=\"gemini-1.5-flash\",\n",
        "  generation_config=generation_config,\n",
        "  # safety_settings = Adjust safety settings\n",
        "  # See https://ai.google.dev/gemini-api/docs/safety-settings\n",
        ")\n"
      ],
      "metadata": {
        "id": "K-Ml92ekoqvI"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Start a chat session"
      ],
      "metadata": {
        "id": "GuYbCseUo1kK"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "chat_session = model.start_chat(\n",
        "  history=[\n",
        "    {\n",
        "      \"role\": \"user\",\n",
        "      \"parts\": [\n",
        "        \"You are a professional software developer with 20 years of coding experience.\\n\",\n",
        "      ],\n",
        "    }\n",
        "  ]\n",
        ")\n",
        "response = chat_session.send_message(\"write a python code to sort an array in the most efficient way as possible.\")\n",
        "\n",
        "print(response.text)"
      ],
      "metadata": {
        "id": "FR31EeflouYg",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 908
        },
        "outputId": "a71dbe9c-5bdc-48d3-d381-20f2ffdb0f2a"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "```python\n",
            "import random\n",
            "\n",
            "def quicksort(arr):\n",
            "  \"\"\"\n",
            "  Sorts an array using the Quicksort algorithm.\n",
            "\n",
            "  Args:\n",
            "    arr: The array to be sorted.\n",
            "\n",
            "  Returns:\n",
            "    The sorted array.\n",
            "  \"\"\"\n",
            "  if len(arr) <= 1:\n",
            "    return arr\n",
            "  pivot = arr[len(arr) // 2]\n",
            "  left = [x for x in arr if x < pivot]\n",
            "  middle = [x for x in arr if x == pivot]\n",
            "  right = [x for x in arr if x > pivot]\n",
            "  return quicksort(left) + middle + quicksort(right)\n",
            "\n",
            "# Generate a random array of 10,000 integers\n",
            "array = [random.randint(0, 100000) for _ in range(10000)]\n",
            "\n",
            "# Sort the array using Quicksort\n",
            "sorted_array = quicksort(array)\n",
            "\n",
            "# Print the sorted array\n",
            "print(sorted_array)\n",
            "```\n",
            "\n",
            "**Explanation:**\n",
            "\n",
            "* **Quicksort Algorithm:** This code uses the Quicksort algorithm, which is generally considered one of the most efficient sorting algorithms for large arrays.\n",
            "* **Pivot Selection:**  The code selects the middle element as the pivot. While this isn't the most sophisticated pivot selection strategy, it generally performs well. \n",
            "* **Partitioning:** The array is partitioned into three subarrays: elements less than the pivot, elements equal to the pivot, and elements greater than the pivot.\n",
            "* **Recursive Sorting:** Quicksort is applied recursively to the left and right subarrays until the entire array is sorted.\n",
            "\n",
            "**Why Quicksort is Efficient:**\n",
            "\n",
            "* **In-Place Sorting:** Quicksort modifies the original array directly, reducing memory overhead.\n",
            "* **Average Case Performance:** It has an average time complexity of O(n log n), which is very efficient for large datasets.\n",
            "* **Adaptability:** Quicksort can be modified to handle different pivot selection strategies and partitioning techniques for improved performance in specific scenarios.\n",
            "\n",
            "**Note:** While Quicksort is generally very efficient, it's important to note that its worst-case time complexity is O(n^2). This occurs when the pivot selection repeatedly results in unbalanced partitions. \n",
            "\n",
            "Let me know if you have any more questions or would like to explore other sorting algorithms! \n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [],
      "metadata": {
        "id": "ZDmc-Ojhq2DA"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "# Module 4: Insights Through AI"
      ],
      "metadata": {
        "id": "g0U4ASvXthSg"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "Welcome to Module 4! In this module, you'll explore how to leverage Gemini AI to extract meaningful insights from your data. This module aims to introduce you to the practical applications of advanced AI models, focusing on extracting and interpreting data insights."
      ],
      "metadata": {
        "id": "Q7CPpPfPtmMT"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "### Learning Objectives:\n",
        "- Understand the basics of Gemini AI and its applications in data analysis.\n",
        "- Learn how large language models (LLMs) like Gemini AI work.\n",
        "- Utilize Gemini AI to analyze and extract insights from your dataset.\n",
        "- Interpret the results provided by Gemini AI and draw meaningful conclusions.\n",
        "\n",
        "Let's get started!\n"
      ],
      "metadata": {
        "id": "kdq80A20tplu"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Section 1: Introduction to Gemini AI\n",
        "\n",
        "### **What is Gemini AI?**\n",
        "\n",
        "[Gemini AI](https://blog.google/technology/ai/google-gemini-ai/) is an advanced language model designed to understand and generate human-like text. It can analyze large volumes of text data, summarize information, and provide insightful responses based on the input it receives.\n",
        "\n",
        "### Key Features and Capabilities:\n",
        "- **Text Analysis:** Gemini AI can process and analyze text data to identify key themes, sentiments, and insights.\n",
        "- **Summarization:** It can summarize long documents, making it easier to extract important information quickly.\n",
        "- **Conversational Abilities:** Gemini AI can engage in human-like conversations, providing relevant and coherent responses."
      ],
      "metadata": {
        "id": "5S6NzciZtvcm"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Section 2: Setting Up Gemini AI\n",
        "\n",
        "Now to work with Gemini directly from Python, we need to use its API.\n",
        "\n",
        "An API, or Application Programming Interface, is like a messenger that takes requests and tells a system what you want to do. Then it returns the system's response back to you. It's a way for different software programs to talk to each other.\n",
        "\n",
        "### Simple Example:\n",
        "Think of an API as a waiter in a restaurant. You (the user) tell the waiter (API) what you want from the menu (the system). The waiter takes your order to the kitchen (the system), and then brings your food (response) back to you.\n",
        "\n",
        "### Step-by-Step Guide to Creating and Setting Up Your Gemini AI API Key:\n",
        "1. Search for \"Gemini AI API\" on Google.\n",
        "2. Select the official Gemini AI API page on ai.google.dev.\n",
        "3. Navigate to the \"Get API key in Google AI Studio\" section.\n",
        "4. Create a new project or select an existing project to generate an API key.\n",
        "5. Copy the API key and ensure not to share it publicly for security reasons.\n",
        "\n",
        "Once you have your API key, let's start coding our system."
      ],
      "metadata": {
        "id": "cMghyXwguLRE"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Simple Chatbot Setup using Python and Gemini API"
      ],
      "metadata": {
        "id": "qiXsjhHmuct9"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import google.generativeai as genai\n",
        "\n",
        "# Function to set up a simple chatbot\n",
        "def simple_chatbot(api_key, message):\n",
        "    genai.configure(api_key=api_key)\n",
        "\n",
        "    model = genai.GenerativeModel(\n",
        "        model_name=\"gemini-1.5-flash\",\n",
        "        generation_config={\n",
        "            \"temperature\": 1,\n",
        "            \"top_p\": 0.95,\n",
        "            \"top_k\": 64,\n",
        "            \"max_output_tokens\": 8192,\n",
        "            \"response_mime_type\": \"text/plain\",\n",
        "        },\n",
        "    )\n",
        "\n",
        "    chat_session = model.start_chat(history=[])\n",
        "\n",
        "    response = chat_session.send_message(message)\n",
        "    return response.text\n",
        "\n",
        "# Replace 'your_api_key' with the actual API key\n",
        "api_key = \"AIzaSyBhjdCRZsjjua89gWk4tMTI-oyp1mpcOsY\"\n",
        "\n",
        "message = \"Write a short funny story\"\n",
        "chatbot_response = simple_chatbot(api_key, message)\n",
        "print(chatbot_response)"
      ],
      "metadata": {
        "id": "8uqQCMYDuj7F",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 327
        },
        "outputId": "3def41a2-42e3-4885-c35a-76a912095582"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Bartholomew \"Barty\" Bigglesworth, a pug of questionable hygiene and boundless confidence, strutted into the park, his tiny, sausage-shaped body wobbling with self-importance. He sniffed the air, a haughty frown wrinkling his face.  \"Honestly, the scent of this park is atrocious,\" he declared to the bewildered pigeons. \"It's like a symphony of dog poop and stale bread.\"\n",
            "\n",
            "He spotted his nemesis, a fluffy white poodle named Priscilla, lounging on a bench, a tiny pink bow perched upon her head. Priscilla, with her perfectly groomed coat and impeccable manners, was the antithesis of Barty. \n",
            "\n",
            "\"Priscilla, my dear,\" Barty wheezed, his voice a barely audible rasp. \"You look...well, you look like a marshmallow that's been dipped in sugar.\" \n",
            "\n",
            "Priscilla merely flicked her tail, her disdain evident in the way her pink nose twitched. \n",
            "\n",
            "Barty, undeterred, attempted a flirtatious maneuver. He lumbered towards Priscilla, his stubby legs flailing wildly, and tripped over a stray shoelace. He landed with a loud thud, his rear end pointed skyward.\n",
            "\n",
            "\"Oh, my dear,\" he whimpered, his voice thick with embarrassment. \"I do believe I've lost my balance. Perhaps you could lend a paw?\"\n",
            "\n",
            "Priscilla, with a look of utter disgust, turned her back on the fallen pug.  Barty, his pride crushed, watched as Priscilla sauntered off, leaving him sprawled on the ground like a discarded hot dog.\n",
            "\n",
            "\"At least they serve decent hotdogs at the park,\" he muttered, his voice laced with a hint of bitterness. He lay there for a moment, contemplating his life choices, and then, with a sigh, rolled over and began licking his backside. \"It's the little things in life,\" he mused, \"that bring a dog joy.\" \n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Section 3: Integrating Gemini AI with Your Dataset\n",
        "\n",
        "Now that you've set up the API and created a simple chatbot, let's move on to using Gemini AI with a dataset. We'll be working with a pandas DataFrame to send data to the API for analysis."
      ],
      "metadata": {
        "id": "PxlaY9Euunua"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "import pandas as pd\n",
        "import google.generativeai as genai\n",
        "\n",
        "# Load your dataset\n",
        "df = pd.read_csv('smartwatch-reviews.csv')\n",
        "\n",
        "# Replace 'your_api_key' with the actual API key\n",
        "api_key = \"AIzaSyBhjdCRZsjjua89gWk4tMTI-oyp1mpcOsY\"\n",
        "\n",
        "# Function to analyze reviews using Gemini AI\n",
        "def analyze_reviews(reviews, api_key,prompt_message):\n",
        "    genai.configure(api_key=api_key)\n",
        "\n",
        "    model = genai.GenerativeModel(\n",
        "        model_name=\"gemini-1.5-flash\",\n",
        "        generation_config={\n",
        "            \"temperature\": 1,\n",
        "            \"top_p\": 0.95,\n",
        "            \"top_k\": 64,\n",
        "            \"max_output_tokens\": 8192,\n",
        "            \"response_mime_type\": \"text/plain\",\n",
        "        },\n",
        "    )\n",
        "\n",
        "    chat_session = model.start_chat(history=[])\n",
        "\n",
        "    prompt = prompt_message + \"\\n\\n\".join(reviews)\n",
        "    response = chat_session.send_message(prompt)\n",
        "    return response.text\n",
        "\n"
      ],
      "metadata": {
        "id": "ogUY5GRFuw6B"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Select a subset of reviews\n",
        "\n",
        "reviews_column_name = 'Description'\n",
        "reviews = df[reviews_column_name].head(100).tolist()\n",
        "\n",
        "# Send prompts\n",
        "prompt_message = \"Analyze the following reviews and summarize the key insights:\"\n",
        "insights = analyze_reviews(reviews, api_key, prompt_message)\n",
        "print(insights)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 491
        },
        "id": "_RAyVu3rvRCk",
        "outputId": "c2273db0-23a2-417d-c37c-ec172d24d9dc"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "## Apple Watch SE 2023 Reviews: Key Insights\n",
            "\n",
            "The reviews highlight both the strengths and weaknesses of the Apple Watch SE 2023. \n",
            "\n",
            "**Strengths:**\n",
            "\n",
            "* **Excellent features and quality:** Users praise the watch's features and build quality, especially considering its price point.\n",
            "* **Smooth Watch OS:** The user interface is well-received for its smooth operation and intuitive design.\n",
            "* **Accurate tracking:** The watch's tracking features for sleep, steps, and heart rate are deemed accurate by users.\n",
            "* **Great call quality:** Users are impressed with the clear and consistent call quality, making it feel like a regular phone call.\n",
            "* **Good battery life for basic use:**  Users generally report a full day of battery life, but heavy usage like workouts may require charging twice a day.\n",
            "* **Value for money:**  Many users find the Apple Watch SE 2023 to be a good value considering its features and Apple's brand recognition.\n",
            "\n",
            "**Weaknesses:**\n",
            "\n",
            "* **Missing features:** The SE lacks features like Always-on Display, Blood Oxygen Monitor, and ECG which are available on more expensive Apple Watch models.\n",
            "* **Battery drains quickly during workouts:** Users report significant battery depletion during intense workout sessions.\n",
            "* **Limited water resistance:**  The watch is water resistant but does not accept input while submerged, making swimming workouts inconvenient.\n",
            "* **Smaller screen size:**  Some users find the screen size to be too small.\n",
            "* **Similar price to Apple Watch 8:**  Some users suggest that the Apple Watch 8 offers similar features at a similar price point, making the SE a less compelling option.\n",
            "\n",
            "**Overall:**\n",
            "\n",
            "The Apple Watch SE 2023 is a solid choice for users looking for a basic Apple Watch with good features and performance. It is a good entry point into the Apple Watch ecosystem, offering a smooth user experience and accurate health tracking. However, those seeking a more advanced feature set or longer battery life may be better served by the Apple Watch 8. \n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Section 4: Gathering Insights\n",
        "\n",
        "Now that you've set up Gemini AI and integrated it with your dataset, it's time to dive into gathering insights. This section will guide you through developing effective prompts, extracting key information, and interpreting the results to gain meaningful insights.\n",
        "\n",
        "### Developing Effective Prompts\n",
        "\n",
        "Creating the right prompts is crucial for getting useful responses from Gemini AI. Here, we'll explore how to craft prompts that help extract specific information, such as pain points and positive aspects from customer reviews."
      ],
      "metadata": {
        "id": "j2npJw0MwBNj"
      }
    },
    {
      "cell_type": "markdown",
      "source": [
        "**Extracting Pain Points:** To identify common issues or complaints in customer reviews, you can create a prompt that specifically asks Gemini AI to summarize the negative aspects."
      ],
      "metadata": {
        "id": "MPk_9VGhwKGA"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "# Select a subset of reviews\n",
        "\n",
        "reviews_column_name = 'Description'\n",
        "reviews = df[reviews_column_name].head(100).tolist()\n",
        "\n",
        "# Send prompts\n",
        "prompt_message = \"Analyze the negative reviews and summarize the key pain points:\"\n",
        "insights = analyze_reviews(reviews, api_key, prompt_message)\n",
        "print(insights)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 291
        },
        "id": "81VkuPjWwRE5",
        "outputId": "c2a9989d-2e7d-4d7d-afad-e7f17b9a718d"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "## Key Pain Points of Apple Watch SE 2023:\n",
            "\n",
            "**1. Battery Life:** Many users complain about the battery life being insufficient, especially with heavy use like workouts or long calls.  They report needing to charge daily or even twice a day with heavy use.\n",
            "\n",
            "**2. Screen Size:** Some users find the screen size (especially on the 40mm version) to be too small. \n",
            "\n",
            "**3.  Lack of Features:** Some users highlight the lack of features compared to higher-end Apple Watches, such as always-on display, blood oxygen monitoring, and ECG. They also mention that the price difference between the SE and Series 8 is minimal, making the Series 8 a better value proposition. \n",
            "\n",
            "**4. Water Resistance:** While the watch is water resistant, it doesn't accept input when submerged. This means users need to turn on workout mode before entering water, limiting its practicality for swimming.\n",
            "\n",
            "**5. Cellular Usage:** Some users report that the watch gets heated up during long calls, making cellular usage unreliable.\n",
            "\n",
            "**Overall:** While many users appreciate the quality, performance, and user experience of the Apple Watch SE 2023, its battery life, lack of features, and screen size are some of the key pain points. \n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Section 5: Hands-On Practice\n",
        "\n",
        "Now that you know how to use the Gemini API to gather insights, feel free to experiment as much as possible. Remember: The goal is to understand the voice of the customer through their feedback. By developing effective prompts and interpreting the AI's responses, you can uncover valuable insights that drive better decision-making."
      ],
      "metadata": {
        "id": "n8isBKmYrwpS"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()"
      ],
      "metadata": {
        "id": "41zVTiVTwxWH",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 206
        },
        "outputId": "2913c6f7-d026-4c4f-cd3d-005ba0e891f0"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "                                        Product Name         Name  Stars  \\\n",
              "0  Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...  Karthikeyan    5.0   \n",
              "1  Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...     Vishvesh    4.0   \n",
              "2  Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...        Bindu    5.0   \n",
              "3  Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...   Sandhyaram    2.0   \n",
              "4  Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...       Suresh    1.0   \n",
              "\n",
              "                                               Title  Date  \\\n",
              "0       5.0 out of 5 stars\\nGood and reliable watch.   NaN   \n",
              "1  4.0 out of 5 stars\\nThe Perfect Budget Apple W...   NaN   \n",
              "2                       5.0 out of 5 stars\\nGood One   NaN   \n",
              "3                2.0 out of 5 stars\\nBattery problem   NaN   \n",
              "4               1.0 out of 5 stars\\nNot as per image   NaN   \n",
              "\n",
              "                                         Description  \n",
              "0  Very good in terms of features and amazing qua...  \n",
              "1  This is the first time I am using an Apple Wat...  \n",
              "2        Simple look with basic features.\\nRead more  \n",
              "3                        2h charging 100%\\nRead more  \n",
              "4                    Screen is very small\\nRead more  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-e85ffed8-6874-4635-9460-e3b061638491\" class=\"colab-df-container\">\n",
              "    <div>\n",
              "<style scoped>\n",
              "    .dataframe tbody tr th:only-of-type {\n",
              "        vertical-align: middle;\n",
              "    }\n",
              "\n",
              "    .dataframe tbody tr th {\n",
              "        vertical-align: top;\n",
              "    }\n",
              "\n",
              "    .dataframe thead th {\n",
              "        text-align: right;\n",
              "    }\n",
              "</style>\n",
              "<table border=\"1\" class=\"dataframe\">\n",
              "  <thead>\n",
              "    <tr style=\"text-align: right;\">\n",
              "      <th></th>\n",
              "      <th>Product Name</th>\n",
              "      <th>Name</th>\n",
              "      <th>Stars</th>\n",
              "      <th>Title</th>\n",
              "      <th>Date</th>\n",
              "      <th>Description</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...</td>\n",
              "      <td>Karthikeyan</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0 out of 5 stars\\nGood and reliable watch.</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Very good in terms of features and amazing qua...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...</td>\n",
              "      <td>Vishvesh</td>\n",
              "      <td>4.0</td>\n",
              "      <td>4.0 out of 5 stars\\nThe Perfect Budget Apple W...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>This is the first time I am using an Apple Wat...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...</td>\n",
              "      <td>Bindu</td>\n",
              "      <td>5.0</td>\n",
              "      <td>5.0 out of 5 stars\\nGood One</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Simple look with basic features.\\nRead more</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...</td>\n",
              "      <td>Sandhyaram</td>\n",
              "      <td>2.0</td>\n",
              "      <td>2.0 out of 5 stars\\nBattery problem</td>\n",
              "      <td>NaN</td>\n",
              "      <td>2h charging 100%\\nRead more</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smar...</td>\n",
              "      <td>Suresh</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0 out of 5 stars\\nNot as per image</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Screen is very small\\nRead more</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "    <div class=\"colab-df-buttons\">\n",
              "\n",
              "  <div class=\"colab-df-container\">\n",
              "    <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-e85ffed8-6874-4635-9460-e3b061638491')\"\n",
              "            title=\"Convert this dataframe to an interactive table.\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "  <svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\" viewBox=\"0 -960 960 960\">\n",
              "    <path d=\"M120-120v-720h720v720H120Zm60-500h600v-160H180v160Zm220 220h160v-160H400v160Zm0 220h160v-160H400v160ZM180-400h160v-160H180v160Zm440 0h160v-160H620v160ZM180-180h160v-160H180v160Zm440 0h160v-160H620v160Z\"/>\n",
              "  </svg>\n",
              "    </button>\n",
              "\n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      gap: 12px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert {\n",
              "      background-color: #E8F0FE;\n",
              "      border: none;\n",
              "      border-radius: 50%;\n",
              "      cursor: pointer;\n",
              "      display: none;\n",
              "      fill: #1967D2;\n",
              "      height: 32px;\n",
              "      padding: 0 0 0 0;\n",
              "      width: 32px;\n",
              "    }\n",
              "\n",
              "    .colab-df-convert:hover {\n",
              "      background-color: #E2EBFA;\n",
              "      box-shadow: 0px 1px 2px rgba(60, 64, 67, 0.3), 0px 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "      fill: #174EA6;\n",
              "    }\n",
              "\n",
              "    .colab-df-buttons div {\n",
              "      margin-bottom: 4px;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert {\n",
              "      background-color: #3B4455;\n",
              "      fill: #D2E3FC;\n",
              "    }\n",
              "\n",
              "    [theme=dark] .colab-df-convert:hover {\n",
              "      background-color: #434B5C;\n",
              "      box-shadow: 0px 1px 3px 1px rgba(0, 0, 0, 0.15);\n",
              "      filter: drop-shadow(0px 1px 2px rgba(0, 0, 0, 0.3));\n",
              "      fill: #FFFFFF;\n",
              "    }\n",
              "  </style>\n",
              "\n",
              "    <script>\n",
              "      const buttonEl =\n",
              "        document.querySelector('#df-e85ffed8-6874-4635-9460-e3b061638491 button.colab-df-convert');\n",
              "      buttonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "\n",
              "      async function convertToInteractive(key) {\n",
              "        const element = document.querySelector('#df-e85ffed8-6874-4635-9460-e3b061638491');\n",
              "        const dataTable =\n",
              "          await google.colab.kernel.invokeFunction('convertToInteractive',\n",
              "                                                    [key], {});\n",
              "        if (!dataTable) return;\n",
              "\n",
              "        const docLinkHtml = 'Like what you see? Visit the ' +\n",
              "          '<a target=\"_blank\" href=https://colab.research.google.com/notebooks/data_table.ipynb>data table notebook</a>'\n",
              "          + ' to learn more about interactive tables.';\n",
              "        element.innerHTML = '';\n",
              "        dataTable['output_type'] = 'display_data';\n",
              "        await google.colab.output.renderOutput(dataTable, element);\n",
              "        const docLink = document.createElement('div');\n",
              "        docLink.innerHTML = docLinkHtml;\n",
              "        element.appendChild(docLink);\n",
              "      }\n",
              "    </script>\n",
              "  </div>\n",
              "\n",
              "\n",
              "<div id=\"df-1dc16950-ada9-4b01-a063-bec957fba3f0\">\n",
              "  <button class=\"colab-df-quickchart\" onclick=\"quickchart('df-1dc16950-ada9-4b01-a063-bec957fba3f0')\"\n",
              "            title=\"Suggest charts\"\n",
              "            style=\"display:none;\">\n",
              "\n",
              "<svg xmlns=\"http://www.w3.org/2000/svg\" height=\"24px\"viewBox=\"0 0 24 24\"\n",
              "     width=\"24px\">\n",
              "    <g>\n",
              "        <path d=\"M19 3H5c-1.1 0-2 .9-2 2v14c0 1.1.9 2 2 2h14c1.1 0 2-.9 2-2V5c0-1.1-.9-2-2-2zM9 17H7v-7h2v7zm4 0h-2V7h2v10zm4 0h-2v-4h2v4z\"/>\n",
              "    </g>\n",
              "</svg>\n",
              "  </button>\n",
              "\n",
              "<style>\n",
              "  .colab-df-quickchart {\n",
              "      --bg-color: #E8F0FE;\n",
              "      --fill-color: #1967D2;\n",
              "      --hover-bg-color: #E2EBFA;\n",
              "      --hover-fill-color: #174EA6;\n",
              "      --disabled-fill-color: #AAA;\n",
              "      --disabled-bg-color: #DDD;\n",
              "  }\n",
              "\n",
              "  [theme=dark] .colab-df-quickchart {\n",
              "      --bg-color: #3B4455;\n",
              "      --fill-color: #D2E3FC;\n",
              "      --hover-bg-color: #434B5C;\n",
              "      --hover-fill-color: #FFFFFF;\n",
              "      --disabled-bg-color: #3B4455;\n",
              "      --disabled-fill-color: #666;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart {\n",
              "    background-color: var(--bg-color);\n",
              "    border: none;\n",
              "    border-radius: 50%;\n",
              "    cursor: pointer;\n",
              "    display: none;\n",
              "    fill: var(--fill-color);\n",
              "    height: 32px;\n",
              "    padding: 0;\n",
              "    width: 32px;\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart:hover {\n",
              "    background-color: var(--hover-bg-color);\n",
              "    box-shadow: 0 1px 2px rgba(60, 64, 67, 0.3), 0 1px 3px 1px rgba(60, 64, 67, 0.15);\n",
              "    fill: var(--button-hover-fill-color);\n",
              "  }\n",
              "\n",
              "  .colab-df-quickchart-complete:disabled,\n",
              "  .colab-df-quickchart-complete:disabled:hover {\n",
              "    background-color: var(--disabled-bg-color);\n",
              "    fill: var(--disabled-fill-color);\n",
              "    box-shadow: none;\n",
              "  }\n",
              "\n",
              "  .colab-df-spinner {\n",
              "    border: 2px solid var(--fill-color);\n",
              "    border-color: transparent;\n",
              "    border-bottom-color: var(--fill-color);\n",
              "    animation:\n",
              "      spin 1s steps(1) infinite;\n",
              "  }\n",
              "\n",
              "  @keyframes spin {\n",
              "    0% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "      border-left-color: var(--fill-color);\n",
              "    }\n",
              "    20% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    30% {\n",
              "      border-color: transparent;\n",
              "      border-left-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    40% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-top-color: var(--fill-color);\n",
              "    }\n",
              "    60% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "    }\n",
              "    80% {\n",
              "      border-color: transparent;\n",
              "      border-right-color: var(--fill-color);\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "    90% {\n",
              "      border-color: transparent;\n",
              "      border-bottom-color: var(--fill-color);\n",
              "    }\n",
              "  }\n",
              "</style>\n",
              "\n",
              "  <script>\n",
              "    async function quickchart(key) {\n",
              "      const quickchartButtonEl =\n",
              "        document.querySelector('#' + key + ' button');\n",
              "      quickchartButtonEl.disabled = true;  // To prevent multiple clicks.\n",
              "      quickchartButtonEl.classList.add('colab-df-spinner');\n",
              "      try {\n",
              "        const charts = await google.colab.kernel.invokeFunction(\n",
              "            'suggestCharts', [key], {});\n",
              "      } catch (error) {\n",
              "        console.error('Error during call to suggestCharts:', error);\n",
              "      }\n",
              "      quickchartButtonEl.classList.remove('colab-df-spinner');\n",
              "      quickchartButtonEl.classList.add('colab-df-quickchart-complete');\n",
              "    }\n",
              "    (() => {\n",
              "      let quickchartButtonEl =\n",
              "        document.querySelector('#df-1dc16950-ada9-4b01-a063-bec957fba3f0 button');\n",
              "      quickchartButtonEl.style.display =\n",
              "        google.colab.kernel.accessAllowed ? 'block' : 'none';\n",
              "    })();\n",
              "  </script>\n",
              "</div>\n",
              "\n",
              "    </div>\n",
              "  </div>\n"
            ],
            "application/vnd.google.colaboratory.intrinsic+json": {
              "type": "dataframe",
              "variable_name": "df",
              "summary": "{\n  \"name\": \"df\",\n  \"rows\": 2750,\n  \"fields\": [\n    {\n      \"column\": \"Product Name\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 11,\n        \"samples\": [\n          \"Fitbit Inspire 3 Health & Fitness Tracker (Midnight Zen/Black) with 6-Month Premium Membership\",\n          \"Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smartwatch with Starlight Aluminum Case with Starlight Sport Loop One Size. Fitness & Sleep Tracker, Crash Detection, Heart Rate Monitor, Retina Display\",\n          \"Fossil Gen 6 Digital Black Dial Men's Watch-FTW4059\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Name\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 92,\n        \"samples\": [\n          \"Nitish Saxena\",\n          \"Tapiyar\",\n          \"Sreeraj\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Stars\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": 1.1472625820252986,\n        \"min\": 1.0,\n        \"max\": 5.0,\n        \"num_unique_values\": 5,\n        \"samples\": [\n          4.0,\n          3.0,\n          2.0\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Title\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 95,\n        \"samples\": [\n          \"Great watch, good battery life\",\n          \"5.0 out of 5 stars\\nThe product need care as it\\u2019s not cheap.\",\n          \"A fantastic watch for runners\"\n        ],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Date\",\n      \"properties\": {\n        \"dtype\": \"number\",\n        \"std\": null,\n        \"min\": null,\n        \"max\": null,\n        \"num_unique_values\": 0,\n        \"samples\": [],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    },\n    {\n      \"column\": \"Description\",\n      \"properties\": {\n        \"dtype\": \"category\",\n        \"num_unique_values\": 95,\n        \"samples\": [],\n        \"semantic_type\": \"\",\n        \"description\": \"\"\n      }\n    }\n  ]\n}"
            }
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "reviews_column_name = 'Product Name'\n",
        "reviews = df[reviews_column_name].head(100).to_list()\n",
        "\n",
        "prompt_message = 'check the all products are same or not'\n",
        "insights = analyze_reviews(reviews,api_key,prompt_message)\n",
        "print(insights)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 200
        },
        "id": "UsXqdV9ZRpfa",
        "outputId": "e7ae1fed-d41a-4ec1-fe0f-430257d66c30"
      },
      "execution_count": null,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "The products are not all the same. \n",
            "\n",
            "There are two different Apple Watch SE models listed:\n",
            "\n",
            "* **Apple Watch SE (2nd Gen, 2023) [GPS 40mm] Smartwatch with Starlight Aluminum Case with Starlight Sport Loop One Size:** This model has GPS only and comes with a Starlight Aluminum case and Starlight Sport Loop.\n",
            "* **Apple Watch SE (GPS + Cellular, 40mm) - Space Grey Aluminium Case with Midnight Sport Band - Regular:** This model has both GPS and Cellular connectivity and comes with a Space Grey Aluminium case and Midnight Sport Band.\n",
            "\n",
            "While the product descriptions are very similar, the key differences in connectivity and color options make them distinct products. \n",
            "\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [],
      "metadata": {
        "id": "lb6qXjyoSS4X"
      },
      "execution_count": null,
      "outputs": []
    }
  ]
}