24679_HW1_MAIN_MODEL.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": []
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    },
    "widgets": {
      "application/vnd.jupyter.widget-state+json": {
        "6d64b7f2ead64ac384f48ff118d899e8": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "HBoxModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HBoxModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HBoxView",
            "box_style": "",
            "children": [
              "IPY_MODEL_12c0dc5da9f74fe68bddb8343521114f",
              "IPY_MODEL_e335f2d1879945f289e544c223c6c429",
              "IPY_MODEL_25cbac1350014631a98a4b230dc2bd09"
            ],
            "layout": "IPY_MODEL_f32dc01eefc646cba28a449e36dd05c9"
          }
        },
        "12c0dc5da9f74fe68bddb8343521114f": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "HTMLModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HTMLModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HTMLView",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_d03172088b6f4019a1b7e8834ce139f7",
            "placeholder": "​",
            "style": "IPY_MODEL_1e26ec1268b74bf39c4bd9937f0f7e43",
            "value": "100%"
          }
        },
        "e335f2d1879945f289e544c223c6c429": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "FloatProgressModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "FloatProgressModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "ProgressView",
            "bar_style": "success",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_ab0971e097b84bcaa8056a18fd190167",
            "max": 50,
            "min": 0,
            "orientation": "horizontal",
            "style": "IPY_MODEL_c0b57474a45f4ff3958d4a91a898a303",
            "value": 50
          }
        },
        "25cbac1350014631a98a4b230dc2bd09": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "HTMLModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HTMLModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HTMLView",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_88a3046c23e04db5b709d7a6743e34a3",
            "placeholder": "​",
            "style": "IPY_MODEL_7a0d0d47c0344d8abd1c5ae3a479a375",
            "value": " 50/50 [00:00&lt;00:00, 455.24it/s]"
          }
        },
        "f32dc01eefc646cba28a449e36dd05c9": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "d03172088b6f4019a1b7e8834ce139f7": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "1e26ec1268b74bf39c4bd9937f0f7e43": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "DescriptionStyleModel",
          "model_module_version": "1.5.0",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "DescriptionStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "description_width": ""
          }
        },
        "ab0971e097b84bcaa8056a18fd190167": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "c0b57474a45f4ff3958d4a91a898a303": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "ProgressStyleModel",
          "model_module_version": "1.5.0",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "ProgressStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "bar_color": null,
            "description_width": ""
          }
        },
        "88a3046c23e04db5b709d7a6743e34a3": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "7a0d0d47c0344d8abd1c5ae3a479a375": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "DescriptionStyleModel",
          "model_module_version": "1.5.0",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "DescriptionStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "description_width": ""
          }
        },
        "eaa18c65fae54b8aa69bfeedfbf026dc": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "HBoxModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HBoxModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HBoxView",
            "box_style": "",
            "children": [
              "IPY_MODEL_3aaf5c15d34c45e891a5474fbe8bbe66",
              "IPY_MODEL_0e758e069e0047f7844aa0c3d63b617c",
              "IPY_MODEL_79dc73bfb0e54f81889b342cdb2f3132"
            ],
            "layout": "IPY_MODEL_dbdae80d8a2649d99fd67e02784c1caa"
          }
        },
        "3aaf5c15d34c45e891a5474fbe8bbe66": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "HTMLModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HTMLModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HTMLView",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_ee977fb8f820424cab28d3e98fe41748",
            "placeholder": "​",
            "style": "IPY_MODEL_bfc4180bd3f344ff965d419fbc6d6e15",
            "value": "100%"
          }
        },
        "0e758e069e0047f7844aa0c3d63b617c": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "FloatProgressModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "FloatProgressModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "ProgressView",
            "bar_style": "success",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_5ea2a2bff98c40c59c00a503fef4be5d",
            "max": 50,
            "min": 0,
            "orientation": "horizontal",
            "style": "IPY_MODEL_e1fdfc953cba41dbb3edb0cec5ddb25a",
            "value": 50
          }
        },
        "79dc73bfb0e54f81889b342cdb2f3132": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "HTMLModel",
          "model_module_version": "1.5.0",
          "state": {
            "_dom_classes": [],
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "HTMLModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/controls",
            "_view_module_version": "1.5.0",
            "_view_name": "HTMLView",
            "description": "",
            "description_tooltip": null,
            "layout": "IPY_MODEL_e7c1ad7494c54fa4be1d16684714983d",
            "placeholder": "​",
            "style": "IPY_MODEL_a50a0d994d7443e29d5d85895292f5ee",
            "value": " 50/50 [00:00&lt;00:00, 468.17it/s]"
          }
        },
        "dbdae80d8a2649d99fd67e02784c1caa": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "ee977fb8f820424cab28d3e98fe41748": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "bfc4180bd3f344ff965d419fbc6d6e15": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "DescriptionStyleModel",
          "model_module_version": "1.5.0",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "DescriptionStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "description_width": ""
          }
        },
        "5ea2a2bff98c40c59c00a503fef4be5d": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "e1fdfc953cba41dbb3edb0cec5ddb25a": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "ProgressStyleModel",
          "model_module_version": "1.5.0",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "ProgressStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "bar_color": null,
            "description_width": ""
          }
        },
        "e7c1ad7494c54fa4be1d16684714983d": {
          "model_module": "@jupyter-widgets/base",
          "model_name": "LayoutModel",
          "model_module_version": "1.2.0",
          "state": {
            "_model_module": "@jupyter-widgets/base",
            "_model_module_version": "1.2.0",
            "_model_name": "LayoutModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "LayoutView",
            "align_content": null,
            "align_items": null,
            "align_self": null,
            "border": null,
            "bottom": null,
            "display": null,
            "flex": null,
            "flex_flow": null,
            "grid_area": null,
            "grid_auto_columns": null,
            "grid_auto_flow": null,
            "grid_auto_rows": null,
            "grid_column": null,
            "grid_gap": null,
            "grid_row": null,
            "grid_template_areas": null,
            "grid_template_columns": null,
            "grid_template_rows": null,
            "height": null,
            "justify_content": null,
            "justify_items": null,
            "left": null,
            "margin": null,
            "max_height": null,
            "max_width": null,
            "min_height": null,
            "min_width": null,
            "object_fit": null,
            "object_position": null,
            "order": null,
            "overflow": null,
            "overflow_x": null,
            "overflow_y": null,
            "padding": null,
            "right": null,
            "top": null,
            "visibility": null,
            "width": null
          }
        },
        "a50a0d994d7443e29d5d85895292f5ee": {
          "model_module": "@jupyter-widgets/controls",
          "model_name": "DescriptionStyleModel",
          "model_module_version": "1.5.0",
          "state": {
            "_model_module": "@jupyter-widgets/controls",
            "_model_module_version": "1.5.0",
            "_model_name": "DescriptionStyleModel",
            "_view_count": null,
            "_view_module": "@jupyter-widgets/base",
            "_view_module_version": "1.2.0",
            "_view_name": "StyleView",
            "description_width": ""
          }
        }
      }
    }
  },
  "cells": [
    {
      "cell_type": "code",
      "execution_count": 1,
      "metadata": {
        "id": "eiXdnPIVgg_F"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import matplotlib.pyplot as plt\n",
        "import seaborn as sns\n",
        "from nltk.corpus import stopwords\n",
        "\n",
        "plt.style.use('ggplot')\n",
        "\n",
        "import nltk\n",
        "from nltk.tokenize import word_tokenize"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "'''\n",
        "DATA SCRAPING CODE TAKEN FROM https://github.com/scrapehero-code/amazon-review-scraper\n",
        "SENTIMENT ANALYSIS USING NLTK MODIFIED FROM https://www.kaggle.com/code/robikscube/sentiment-analysis-python-youtube-tutorial/notebook\n",
        "'''"
      ],
      "metadata": {
        "id": "D8scSSSLhGC9"
      },
      "execution_count": null,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "nltk.download('punkt')\n",
        "nltk.download('averaged_perceptron_tagger')\n",
        "nltk.download('maxent_ne_chunker')\n",
        "nltk.download('words')\n",
        "nltk.download('vader_lexicon')\n",
        "nltk.download('stopwords')\n",
        "nltk.download('punkt')\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "QM8EB5v2mLzc",
        "outputId": "ef728e70-b8e5-4d71-c58c-08802aad05c5"
      },
      "execution_count": 2,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "[nltk_data] Downloading package punkt to /root/nltk_data...\n",
            "[nltk_data]   Unzipping tokenizers/punkt.zip.\n",
            "[nltk_data] Downloading package averaged_perceptron_tagger to\n",
            "[nltk_data]     /root/nltk_data...\n",
            "[nltk_data]   Unzipping taggers/averaged_perceptron_tagger.zip.\n",
            "[nltk_data] Downloading package maxent_ne_chunker to\n",
            "[nltk_data]     /root/nltk_data...\n",
            "[nltk_data]   Unzipping chunkers/maxent_ne_chunker.zip.\n",
            "[nltk_data] Downloading package words to /root/nltk_data...\n",
            "[nltk_data]   Unzipping corpora/words.zip.\n",
            "[nltk_data] Downloading package vader_lexicon to /root/nltk_data...\n",
            "[nltk_data] Downloading package stopwords to /root/nltk_data...\n",
            "[nltk_data]   Unzipping corpora/stopwords.zip.\n",
            "[nltk_data] Downloading package punkt to /root/nltk_data...\n",
            "[nltk_data]   Package punkt is already up-to-date!\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True"
            ]
          },
          "metadata": {},
          "execution_count": 2
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df = pd.read_csv('/content/data.csv')\n",
        "print(df.shape)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "U2meh-1EgrH7",
        "outputId": "0607d375-b09e-449a-9e9f-f6bd410611b7"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "(50, 10)\n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head()\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 858
        },
        "id": "HtsbfgBFkYJD",
        "outputId": "6e307660-7fed-4620-d226-a7c7e299a7fa"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "             title                                            content  \\\n",
              "0            Great  Bought these for my daughter and she loves the...   \n",
              "1  Cute and comfy!  My daughter loves these shoes! The colors are ...   \n",
              "2         Hermosos  Son tal cual aparecen en la foto, muy cómodos,...   \n",
              "3  Shoes are great          Easy stretch to fit ! Perfect for infants   \n",
              "4         Adorable  For granddaughter starting kindergarten .  Hav...   \n",
              "\n",
              "          date                                            variant images  \\\n",
              "0  26 Aug 2022  Special Size: Toddler (1-4 Years) Size: 9.5 To...    NaN   \n",
              "1  16 Aug 2022  Special Size: Little Kid (4-8 Years) Size: 3 L...    NaN   \n",
              "2  23 Aug 2022  Special Size: Little Kid (4-8 Years) Size: 12 ...    NaN   \n",
              "3  19 Aug 2022  Special Size: Infant (0-12 Months) Size: 3 Wid...    NaN   \n",
              "4  08 Aug 2022  Special Size: Little Kid (4-8 Years) Size: 13....    NaN   \n",
              "\n",
              "  verified          author  rating  \\\n",
              "0      Yes  southern twang       5   \n",
              "1      Yes            KBen       5   \n",
              "2      Yes  Tania Alvarado       5   \n",
              "3      Yes    David Connor       5   \n",
              "4      Yes         Dorothy       5   \n",
              "\n",
              "                                             product  \\\n",
              "0  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "1  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "2  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "3  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "4  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "\n",
              "                                                 url  \n",
              "0  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "1  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "2  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "3  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "4  https://www.amazon.com/product-reviews/B096D3W...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a43baedc-d239-4421-838c-a11251837fb1\">\n",
              "    <div 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>title</th>\n",
              "      <th>content</th>\n",
              "      <th>date</th>\n",
              "      <th>variant</th>\n",
              "      <th>images</th>\n",
              "      <th>verified</th>\n",
              "      <th>author</th>\n",
              "      <th>rating</th>\n",
              "      <th>product</th>\n",
              "      <th>url</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>Great</td>\n",
              "      <td>Bought these for my daughter and she loves the...</td>\n",
              "      <td>26 Aug 2022</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 9.5 To...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>southern twang</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>Cute and comfy!</td>\n",
              "      <td>My daughter loves these shoes! The colors are ...</td>\n",
              "      <td>16 Aug 2022</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 3 L...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>KBen</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>Hermosos</td>\n",
              "      <td>Son tal cual aparecen en la foto, muy cómodos,...</td>\n",
              "      <td>23 Aug 2022</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 12 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Tania Alvarado</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>Shoes are great</td>\n",
              "      <td>Easy stretch to fit ! Perfect for infants</td>\n",
              "      <td>19 Aug 2022</td>\n",
              "      <td>Special Size: Infant (0-12 Months) Size: 3 Wid...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>David Connor</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>Adorable</td>\n",
              "      <td>For granddaughter starting kindergarten .  Hav...</td>\n",
              "      <td>08 Aug 2022</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 13....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Dorothy</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a43baedc-d239-4421-838c-a11251837fb1')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-a43baedc-d239-4421-838c-a11251837fb1 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-a43baedc-d239-4421-838c-a11251837fb1');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 5
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "USING VADER MODEL FOR SENTIMENT ANALYSIS"
      ],
      "metadata": {
        "id": "m8B3ZPTtutoq"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "from nltk.sentiment import SentimentIntensityAnalyzer\n",
        "from tqdm.notebook import tqdm\n",
        "\n",
        "sia = SentimentIntensityAnalyzer()  #its a sentiment analyzer object"
      ],
      "metadata": {
        "id": "vxKzd71-ulkk"
      },
      "execution_count": 6,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "# Run the polarity score on the entire dataset\n",
        "res = {}\n",
        "for i, row in tqdm(df.iterrows(), total=len(df)):\n",
        "    text = row['content']\n",
        "\n",
        "    myid = row['date']\n",
        "    res[myid] = sia.polarity_scores(text)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 49,
          "referenced_widgets": [
            "6d64b7f2ead64ac384f48ff118d899e8",
            "12c0dc5da9f74fe68bddb8343521114f",
            "e335f2d1879945f289e544c223c6c429",
            "25cbac1350014631a98a4b230dc2bd09",
            "f32dc01eefc646cba28a449e36dd05c9",
            "d03172088b6f4019a1b7e8834ce139f7",
            "1e26ec1268b74bf39c4bd9937f0f7e43",
            "ab0971e097b84bcaa8056a18fd190167",
            "c0b57474a45f4ff3958d4a91a898a303",
            "88a3046c23e04db5b709d7a6743e34a3",
            "7a0d0d47c0344d8abd1c5ae3a479a375"
          ]
        },
        "id": "Bi4snaYP1TbH",
        "outputId": "7a5b257f-da43-4990-bdf0-eadbbe4db7d2"
      },
      "execution_count": 8,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "  0%|          | 0/50 [00:00<?, ?it/s]"
            ],
            "application/vnd.jupyter.widget-view+json": {
              "version_major": 2,
              "version_minor": 0,
              "model_id": "6d64b7f2ead64ac384f48ff118d899e8"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "res"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "ivE9NL2v68iG",
        "outputId": "61f13d58-7f49-496a-cbfb-d153b0b3b923"
      },
      "execution_count": 9,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "{'26 Aug 2022': {'neg': 0.115, 'neu': 0.885, 'pos': 0.0, 'compound': -0.296},\n",
              " '16 Aug 2022': {'neg': 0.059, 'neu': 0.689, 'pos': 0.252, 'compound': 0.8439},\n",
              " '23 Aug 2022': {'neg': 0.0, 'neu': 0.813, 'pos': 0.187, 'compound': 0.3182},\n",
              " '19 Aug 2022': {'neg': 0.0, 'neu': 0.299, 'pos': 0.701, 'compound': 0.8553},\n",
              " '08 Aug 2022': {'neg': 0.128, 'neu': 0.64, 'pos': 0.232, 'compound': 0.4199},\n",
              " '05 Aug 2022': {'neg': 0.0, 'neu': 0.512, 'pos': 0.488, 'compound': 0.8879},\n",
              " '30 Jun 2022': {'neg': 0.0, 'neu': 0.737, 'pos': 0.263, 'compound': 0.552},\n",
              " '16 Jun 2022': {'neg': 0.0, 'neu': 0.635, 'pos': 0.365, 'compound': 0.9296},\n",
              " '15 Jun 2022': {'neg': 0.082, 'neu': 0.604, 'pos': 0.314, 'compound': 0.8276},\n",
              " '07 May 2022': {'neg': 0.07, 'neu': 0.621, 'pos': 0.309, 'compound': 0.9214},\n",
              " '09 Apr 2022': {'neg': 0.087,\n",
              "  'neu': 0.794,\n",
              "  'pos': 0.118,\n",
              "  'compound': -0.1243},\n",
              " '15 Mar 2022': {'neg': 0.0, 'neu': 1.0, 'pos': 0.0, 'compound': 0.0},\n",
              " '08 Mar 2022': {'neg': 0.0, 'neu': 0.192, 'pos': 0.808, 'compound': 0.6369},\n",
              " '16 Dec 2021': {'neg': 0.06, 'neu': 0.866, 'pos': 0.073, 'compound': 0.09},\n",
              " '04 Sep 2021': {'neg': 0.042, 'neu': 0.866, 'pos': 0.092, 'compound': 0.4019},\n",
              " '30 Nov 2021': {'neg': 0.0, 'neu': 0.362, 'pos': 0.638, 'compound': 0.8908},\n",
              " '07 Dec 2021': {'neg': 0.088, 'neu': 0.692, 'pos': 0.22, 'compound': 0.7047},\n",
              " '17 Aug 2021': {'neg': 0.154, 'neu': 0.796, 'pos': 0.05, 'compound': -0.6684},\n",
              " '29 Jul 2020': {'neg': 0.021, 'neu': 0.869, 'pos': 0.11, 'compound': 0.8769},\n",
              " '12 May 2021': {'neg': 0.097, 'neu': 0.618, 'pos': 0.285, 'compound': 0.9206},\n",
              " '31 Aug 2022': {'neg': 0.0, 'neu': 1.0, 'pos': 0.0, 'compound': 0.0},\n",
              " '15 May 2022': {'neg': 0.077, 'neu': 0.829, 'pos': 0.094, 'compound': 0.1884},\n",
              " '12 Mar 2022': {'neg': 0.142, 'neu': 0.818, 'pos': 0.04, 'compound': -0.7272},\n",
              " '30 Mar 2022': {'neg': 0.113,\n",
              "  'neu': 0.825,\n",
              "  'pos': 0.062,\n",
              "  'compound': -0.2982},\n",
              " '17 Jan 2022': {'neg': 0.0, 'neu': 0.872, 'pos': 0.128, 'compound': 0.2263},\n",
              " '08 Jul 2021': {'neg': 0.027, 'neu': 0.894, 'pos': 0.078, 'compound': 0.5023},\n",
              " '26 Aug 2021': {'neg': 0.0, 'neu': 0.742, 'pos': 0.258, 'compound': 0.8957},\n",
              " '09 Apr 2021': {'neg': 0.053, 'neu': 0.785, 'pos': 0.162, 'compound': 0.886},\n",
              " '21 Sep 2021': {'neg': 0.0, 'neu': 0.911, 'pos': 0.089, 'compound': 0.2609},\n",
              " '11 May 2021': {'neg': 0.052, 'neu': 0.711, 'pos': 0.237, 'compound': 0.8979},\n",
              " '24 Jun 2022': {'neg': 0.17, 'neu': 0.723, 'pos': 0.107, 'compound': -0.6133},\n",
              " '03 Jan 2022': {'neg': 0.069, 'neu': 0.712, 'pos': 0.219, 'compound': 0.6901},\n",
              " '05 Dec 2021': {'neg': 0.0, 'neu': 1.0, 'pos': 0.0, 'compound': 0.0},\n",
              " '29 Oct 2021': {'neg': 0.17, 'neu': 0.83, 'pos': 0.0, 'compound': -0.762},\n",
              " '29 Mar 2021': {'neg': 0.037, 'neu': 0.917, 'pos': 0.046, 'compound': 0.1882},\n",
              " '05 Apr 2021': {'neg': 0.051, 'neu': 0.817, 'pos': 0.132, 'compound': 0.7579},\n",
              " '05 Nov 2021': {'neg': 0.0, 'neu': 0.883, 'pos': 0.117, 'compound': 0.4927},\n",
              " '29 Sep 2019': {'neg': 0.067, 'neu': 0.767, 'pos': 0.166, 'compound': 0.9118},\n",
              " '14 Aug 2022': {'neg': 0.096, 'neu': 0.824, 'pos': 0.08, 'compound': -0.1513},\n",
              " '20 Mar 2021': {'neg': 0.057, 'neu': 0.845, 'pos': 0.098, 'compound': 0.4141},\n",
              " '08 Jan 2022': {'neg': 0.0, 'neu': 0.915, 'pos': 0.085, 'compound': 0.3612},\n",
              " '06 Oct 2021': {'neg': 0.052, 'neu': 0.854, 'pos': 0.094, 'compound': 0.1987},\n",
              " '24 Dec 2019': {'neg': 0.083,\n",
              "  'neu': 0.879,\n",
              "  'pos': 0.038,\n",
              "  'compound': -0.5859},\n",
              " '14 Mar 2021': {'neg': 0.15, 'neu': 0.759, 'pos': 0.091, 'compound': -0.6242},\n",
              " '30 Aug 2021': {'neg': 0.0, 'neu': 1.0, 'pos': 0.0, 'compound': 0.0},\n",
              " '17 Oct 2021': {'neg': 0.066, 'neu': 0.934, 'pos': 0.0, 'compound': -0.2746},\n",
              " '25 Feb 2022': {'neg': 0.0, 'neu': 1.0, 'pos': 0.0, 'compound': 0.0}}"
            ]
          },
          "metadata": {},
          "execution_count": 9
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "vaders = pd.DataFrame(res).T\n",
        "vaders = vaders.reset_index().rename(columns={'index': 'date'})\n",
        "vaders = vaders.merge(df, how='left')\n",
        "\n",
        "vaders.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 878
        },
        "id": "KKbxTPng7T3O",
        "outputId": "85bd56b6-cb98-4b36-88e8-758e4edb57f5"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "          date    neg    neu    pos  compound            title  \\\n",
              "0  26 Aug 2022  0.115  0.885  0.000   -0.2960            Great   \n",
              "1  26 Aug 2022  0.115  0.885  0.000   -0.2960      Looked good   \n",
              "2  16 Aug 2022  0.059  0.689  0.252    0.8439  Cute and comfy!   \n",
              "3  23 Aug 2022  0.000  0.813  0.187    0.3182         Hermosos   \n",
              "4  19 Aug 2022  0.000  0.299  0.701    0.8553  Shoes are great   \n",
              "\n",
              "                                             content  \\\n",
              "0  Bought these for my daughter and she loves the...   \n",
              "1  Shoes slip off my child's feet. He can't even ...   \n",
              "2  My daughter loves these shoes! The colors are ...   \n",
              "3  Son tal cual aparecen en la foto, muy cómodos,...   \n",
              "4          Easy stretch to fit ! Perfect for infants   \n",
              "\n",
              "                                             variant images verified  \\\n",
              "0  Special Size: Toddler (1-4 Years) Size: 9.5 To...    NaN      Yes   \n",
              "1  Special Size: Toddler (1-4 Years) Size: 5.5 Wi...    NaN      Yes   \n",
              "2  Special Size: Little Kid (4-8 Years) Size: 3 L...    NaN      Yes   \n",
              "3  Special Size: Little Kid (4-8 Years) Size: 12 ...    NaN      Yes   \n",
              "4  Special Size: Infant (0-12 Months) Size: 3 Wid...    NaN      Yes   \n",
              "\n",
              "              author  rating  \\\n",
              "0     southern twang       5   \n",
              "1  Talisa Shelanskey       2   \n",
              "2               KBen       5   \n",
              "3     Tania Alvarado       5   \n",
              "4       David Connor       5   \n",
              "\n",
              "                                             product  \\\n",
              "0  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "1  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "2  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "3  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "4  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "\n",
              "                                                 url  \n",
              "0  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "1  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "2  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "3  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "4  https://www.amazon.com/product-reviews/B096D3W...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ad645511-54dc-42a7-bc81-7c85f5b99f5f\">\n",
              "    <div 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>date</th>\n",
              "      <th>neg</th>\n",
              "      <th>neu</th>\n",
              "      <th>pos</th>\n",
              "      <th>compound</th>\n",
              "      <th>title</th>\n",
              "      <th>content</th>\n",
              "      <th>variant</th>\n",
              "      <th>images</th>\n",
              "      <th>verified</th>\n",
              "      <th>author</th>\n",
              "      <th>rating</th>\n",
              "      <th>product</th>\n",
              "      <th>url</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>26 Aug 2022</td>\n",
              "      <td>0.115</td>\n",
              "      <td>0.885</td>\n",
              "      <td>0.000</td>\n",
              "      <td>-0.2960</td>\n",
              "      <td>Great</td>\n",
              "      <td>Bought these for my daughter and she loves the...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 9.5 To...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>southern twang</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>26 Aug 2022</td>\n",
              "      <td>0.115</td>\n",
              "      <td>0.885</td>\n",
              "      <td>0.000</td>\n",
              "      <td>-0.2960</td>\n",
              "      <td>Looked good</td>\n",
              "      <td>Shoes slip off my child's feet. He can't even ...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 5.5 Wi...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Talisa Shelanskey</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>16 Aug 2022</td>\n",
              "      <td>0.059</td>\n",
              "      <td>0.689</td>\n",
              "      <td>0.252</td>\n",
              "      <td>0.8439</td>\n",
              "      <td>Cute and comfy!</td>\n",
              "      <td>My daughter loves these shoes! The colors are ...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 3 L...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>KBen</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>23 Aug 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.813</td>\n",
              "      <td>0.187</td>\n",
              "      <td>0.3182</td>\n",
              "      <td>Hermosos</td>\n",
              "      <td>Son tal cual aparecen en la foto, muy cómodos,...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 12 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Tania Alvarado</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>19 Aug 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.299</td>\n",
              "      <td>0.701</td>\n",
              "      <td>0.8553</td>\n",
              "      <td>Shoes are great</td>\n",
              "      <td>Easy stretch to fit ! Perfect for infants</td>\n",
              "      <td>Special Size: Infant (0-12 Months) Size: 3 Wid...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>David Connor</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ad645511-54dc-42a7-bc81-7c85f5b99f5f')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-ad645511-54dc-42a7-bc81-7c85f5b99f5f 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-ad645511-54dc-42a7-bc81-7c85f5b99f5f');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 10
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "ax = sns.barplot(data=vaders, x='rating', y='compound')\n",
        "ax.set_title('Compound Score by Amazon Star Review')\n",
        "plt.show()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 299
        },
        "id": "ymJA3h7w8hFy",
        "outputId": "20a2dee6-f6b8-4c87-921d-2d6fdb99ce8b"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "<Figure size 432x288 with 1 Axes>"
            ],
            "image/png": "iVBORw0KGgoAAAANSUhEUgAAAY0AAAEaCAYAAADtxAsqAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADh0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uMy4yLjIsIGh0dHA6Ly9tYXRwbG90bGliLm9yZy+WH4yJAAAgAElEQVR4nO3deVxU9d4H8M/MIAOyz4AggprgXmqIpugFEbqVK9cWszS8WkZpe+aSirkk3dTMpUUzzOUxHutes0wt3BPpIZU0RIRAW4RgAHEDEeb7/OH16AjYQYEZ4/N+vXgN55zfnN93DsN85pzfmTkaEREQERGpoLV2AUREdPtgaBARkWoMDSIiUo2hQUREqjE0iIhINYYGERGpxtCgOte6dWvMmTPH2mXUqdGjRyMyMtLaZdBtbNeuXdBoNPjtt9+sXcotYWjUUmFhIV577TW0b98eDg4OaNasGUJDQ7F69WpUVFRYu7zbxqZNm9C3b18YDAY4OTkhMDAQjz/+OM6cOWPt0qymU6dO0Ol0SEtLs3YpDeLkyZOIjo6Gv78/9Ho9fHx8EBkZiW+//VZpExgYiJkzZ9ZrHa1bt4ZGo4FGo4GDgwMCAwMxbdo0lJeX12k/ISEhyM3Nha+vb52ut6HZWbuA28mvv/6Kvn37ws7ODrNmzcLdd9+NJk2aICkpCfPnz0eXLl3QrVs3a5dp83bs2IFhw4Zh+vTpWL58OfR6PbKysrBx40ZcvHix3vq9dOkSmjRpUm/rvxV79uxBUVERxo4di+XLl+Pdd9+1dkn16tKlS4iMjIS/vz/+53/+By1btsQff/yBXbt2obCwsM77M5vNEBHodLpql0+aNAkvvvgiysvL8f3332Ps2LEwm814880366wGe3t7+Pj41Nn6rEZItUGDBom3t7ecPn26yrLy8nI5d+6c8vukSZPE19dXmjRpIh07dpR169ZZtAcgixcvlkceeUSaNm0q/v7+smHDBjl9+rQ89thj4uzsLHfccYd89tlnyn1ycnIEgKxZs0b69+8vDg4Ocscdd8j69est1n3s2DEZMGCAODk5iZOTkwwaNEgyMzOV5fHx8aLT6Szu8+uvvwoA2blzp4iI7Ny5UwDIN998I3/729/E0dFROnbsKF9//bXF/VJTU6V3795ib28vgYGBkpCQIK1atZLZs2fXuB1feOEF6d69+w229GVZWVny4IMPioeHhzg6Ospdd90lX375pbJ88+bNEhQUJPb29uLl5SXPPPOM8jcQEYmOjpaIiAhZvHixtGrVSjQajVy4cEHy8vIkOjpaPD09xdnZWUJCQmT37t03rOXKuhYuXCi+vr7i6OgoDz30kBQWFirbS6vVyi+//GJxv08++URcXV0t6qrO448/Li+//LIkJyeLh4eHlJaWVtv/4sWLpUWLFuLk5CRjx46V8vJyef/996Vly5bi7u4uTz31lFy8eFG53zfffCNhYWHi4eEhrq6uEhoaKt9//72yPDY2VgBU+YmOjlbarFq1Sjp27ChNmjSRFi1ayOuvvy6XLl1SloeFhcnYsWNl1qxZ4u3tLR4eHjJq1Cg5e/ZsjY/30KFDAkCOHDlSY5uwsLAqdeXk5IjZbJYnn3xS2rRpo/wPTJkyRcrKyiweV0BAgHz66afSvn170el0cvTo0Wr7qe75OmzYMAkKCrKYt3jxYmnfvr3o9XoJDAyUOXPmKNth6tSp0q5duyrrjomJkT59+ojI1f+pX3/9VVmemZkpw4YNEzc3N3F3d5d7771XDh8+rCz38/OT5cuXK9NPPPGEALD4f27RooV88MEHNW7HusbQUKmwsFC0Wu0NXwyvePXVV8VgMMj//u//SkZGhsydO1c0Go0kJiYqbQCIt7e3rFq1SjIzM+WZZ54RBwcHuf/++yU+Pl4yMzNlwoQJ0rRpUzGZTCJyNTSaN28ua9eulWPHjsnrr78uWq1WDh48KCIiFy5ckJYtW0r//v3lhx9+kB9++EH69esnAQEByotJbUKjS5cusmXLFjl+/LiMHj1aXFxcpKioSOnL19dXHnjgAUlNTZWkpCQJDg4WR0fHG26nuLg4cXNzs3jxul5ubq40a9ZMIiIiZO/evZKVlSUbN26UzZs3i4jIjz/+KDqdTl588UVJT0+Xr7/+Wvz9/WXkyJHKOqKjo8XFxUWioqIkNTVVDh8+LOfOnZOOHTvKsGHDJCUlRTIzM2XOnDlib29f44vKtesaPHiwHD58WHbu3CmBgYESFRWltGnfvr3MnDnT4n59+/aVmJiYGtcrcvm5pdfrlReLDh06yCeffFJt/0888YQcPXpUNm3aJHq9Xu6//34ZNWqUHD16VL766itxcHCQ9957T7nfv//9b0lISJBjx47JTz/9JGPHjhUPDw/lOXX27FnJzc1VfjZt2iR2dnayatUqERH56quvRKvVyptvvikZGRny6aefiru7u0ybNk3pIywsTNzc3JS/xbZt28TDw8OizfV+//130Wq1EhsbaxFy12+X1q1byyuvvKLUV1FRIZWVlTJ16lRJTk6WnJwc+eKLL8THx0dmzJih3Dc2NlYcHR0lNDRUkpOTJSMjQ86cOVNtP9eHxsGDB6VZs2bSq1cvi/W1bNlS/v3vf0t2drZs3rxZ/P39lceYkZEhACQ5OVm5T1lZmXh4eMiHH34oIlVDIy8vT7y9vSUmJkYOHz4sx44dkwkTJojBYJD8/HwRERk1apQ8+uijyjr9/f3Fy8tLWeexY8cEgBw/frzGbV3XGBoqff/99wJAPv/88xu2O3/+vNjb28uyZcss5kdFRUl4eLgyDUBeeOEFZTo/P18AyIQJE5R5RUVFAkB5d30lNK7/Z+zdu7fyYvnRRx+Jo6OjFBQUKMvz8vLEwcFBeSGqTWhc+3jz8vIEgGzdulVERFasWCFOTk5KiIiIHDlyRADcMDTOnz8vgwcPFgDi4+MjQ4YMkUWLFikvZCIi06ZNE29v7xrfoY8cOVJ69OhhMW/jxo2i0WjkxIkTInL5hdbNzc3iHW98fLy0aNHC4p2yiEh4eLjF3+N60dHR4uTkZLGXuW3bNot3fQsWLJCWLVtKZWWliIikp6cLACXQa7Jw4UKLd7Xz5s1T3p1e27+Xl5fFC+yAAQPEaDRavMMeMmSIPPjggzX2VVlZKe7u7rJ27doqy3755Rfx8fGRiRMnKvP69u0rDz/8sEW7RYsWiYODg1JLWFiYdOnSxaJNTEyMxYtudd5//31xcnISBwcHCQkJkddee03+7//+z6JNQECAxMbG3nA9Ipe3YWBgoDIdGxsrGo1GTp48+af3bdWqldjb24uTk5PY29sLANHpdPKf//xHRC4/Xx0dHWXLli0W9/vkk0/Ezc1Nmb7nnnvk2WefVaY3bNggDg4OUlxcLCJVQyM2Nlbuuecei3WazWZp06aNvPPOOyJy+fnarFkzERE5fvy4ODo6yqxZs2T48OEiIvLee++Jv7//nz7GusSBcJVE5fc6ZmVloby8HKGhoRbzw8LCqgxwdu3aVfndy8sLOp0OXbp0UeZ5eHjA3t4e+fn5Fvfr3bu3xXSfPn2UdaelpaFTp07w9PRUlnt7e6N9+/Y3NcB67RiNt7c3dDod/vjjDwDA0aNH0bFjR3h4eCht7rzzTri5ud1wnU2bNsWmTZuQk5ODefPmoUWLFpg3bx7at2+P9PR0AMCBAwcQEhICJyenateRlpZW7TYWERw9elSZ17FjRzg7OyvTKSkpyMvLg7u7O5ydnZWfvXv3IjMz84Z1d+rUyeKx9enTR9kOABAdHY38/Hxs27YNAPDRRx+he/fuuPvuu2+43hUrVmD06NHK9MiRI7F///4qf6+OHTvC3t5emfbx8UH79u2h1+st5l37fMnJycGoUaMQGBgIV1dXuLq6oqSkBCdPnrRY97lz5zB48GD07t0bb731ljK/pu1cVlaGn3/+WZl37XMZAHx9fZXnSU1iYmKQl5eHzz//HPfeey92796Ne+65x6L/mqxYsQL33HMPvL294ezsjClTplR5TN7e3mjZsuWfrgsAxo8fj9TUVHz33XcYOnQonnvuOURFRQG4vA1KS0vx4IMPWjxnnn76aZSUlKCgoADA5b9/QkICLl26BABYvXo1hgwZAnd392r7TElJwYEDByzW6eLighMnTijPxfDwcOTn5+Onn37Cjh070LdvX9x///3YuXMngMvjg+Hh4aoeY11haKjUtm1baLVaixekW1XdoOz18zQaDcxmc531CQBabdU/+5Un+vWufZG6oq7qad26NUaPHo333nsP6enp0Gg0+Ne//lUn677i+tAxm83o2LEjUlNTLX7S09OxYsWKW+rLaDTioYcewooVK1BeXo7Vq1dj3LhxN7zPnj17kJ6ejpdeegl2dnaws7ND69atYTabsXz5cou21T03/uz5MmjQIPzyyy9YtmwZkpOTkZqaimbNmlmcGWQ2mzFixAg0adIEa9euhUajqfVjv/55ovZ56+zsjAEDBmDmzJlITk7GmDFjMGPGjBueubRhwwaMHz8ew4cPx9dff41Dhw5hxowZVZ7DNb3hqI7BYEBgYCB69OiBhIQEfPHFF1i3bh2Aq8/3DRs2WDxnjhw5gszMTBgMBgDAo48+irNnz2Lz5s0oKCjA1q1bER0dXWOfZrMZERERVZ6LGRkZyhljrVq1Qps2bbB9+3bs2LED/fv3R1BQEC5evIgjR45g165d6N+/v+rHWRcYGioZDAY88MADWLp0KUpKSqosv3TpEs6fP4/AwEDo9Xrs2bPHYvnu3btx55131kktycnJFtNJSUno1KkTAKBz5844evQoTCaTsvyPP/5ARkaG0n+zZs1QWVlp8U7w4MGDta6jU6dOSE9Px+nTp5V5aWlp1W6fP+Ph4WHxLrl79+5ISkrC+fPnq23fuXPnarexRqNB586da+wnODgY2dnZcHV1RWBgoMXPn50KmZ6ebnFKcFJSEgAo2x4Ann76aXz55Zf48MMPUVpaihEjRtxwncuXL8e9995b5YVj4cKFWLNmDcrKym54/xspLCzE0aNHMXnyZNx3333o1KkTHBwcquy5vvrqq/jxxx/x5ZdfomnTphbLatrOjo6OCAgIuOnaatKxY0eUl5crzyF7e3tUVlZatNmzZw/uvvtuvPzyy+jevTvatm2LEydO1FkNer0er7/+Ol599VVcuHABnTt3hoODA7Kzs6s8ZwIDA5Uzsjw8PDB48GCsWbMG69evh8FgwH333VdjP8HBwUhLS4Ofn1+VdXp5eSntwsPDsX37duzatQsRERHQ6XQICwvDokWLYDKZGjw0OKZRCydPnhQ/Pz8JCAiQdevWSVpammRmZsqaNWukS5cucujQIRERmThxoqqB8DVr1lisX6fTSXx8vMU8vV4vK1asEJGrYxq+vr6ybt06ycjIkOnTp4tGo5EDBw6IiOVA+IEDB6odCC8sLBQXFxcZPXq0HD9+XLZs2SJdunSpdkzj2jM9rq/x/Pnz4uPjIwMHDpTU1FTZv3+/9OzZ808HwmNjY+WVV16RHTt2SHZ2thw+fFheeeUVAaA81lOnTomXl5dERETId999J9nZ2fLll18qZ29dPxC+ZcuWagfCIyIiLPouLS2Vzp07S3BwsGzbtk1ycnIkOTlZ3nzzTeUYdnWuDEQPHTpUjhw5Irt375a2bdvKkCFDqrTt3Lmz2Nvby5NPPlnj+kSuDoCvXr26yrIzZ86IXq9XxqGqeyxjx46VsLAwi3lPP/20Mh5SWVkpXl5e8o9//EMyMjIkKSlJ+vbtK02bNlXGCeLj40Wv18u2bdssBsSvjN1s3rxZtFqtzJs3TzIyMiQhIaHagfCxY8da1DF79mxp1apVjY/94MGDMmjQIElISJAjR47Izz//LJ9++qk0a9bMYjxnwIABEh4eLidPnpSCggKprKyUJUuWiKOjo2zcuFGysrJk0aJFYjQa5dqXsytnT6lR3dlTZWVl4uPjI2+++aaIiMyaNUtcXFxk6dKlykkF69evl9dee83ifl988YXY29tLx44d5eWXX7ZYVt1AePPmzeXvf/+77NmzR3JycmTv3r0ydepU2bdvn3K/devWiZ2dnbi5uUlFRYWIXB5XsrOzsxjHaSgMjVrKz8+XV155Rdq2bSt6vV68vLwkNDRU1qxZowyuqj3l9mZDY/Xq1RIWFiZ6vV5at25dZd3Hjh2TBx54QDnlduDAgRan6IlcPiumQ4cOyiDk1q1bax0aIpf/+Xv16iX29vbSpk0bWb9+/Z+ecrtjxw555JFHpFWrVqLX68VoNEpISEiVwdmMjAyJiooSV1dXcXR0lC5duihnT4lYnnLr6ekpMTEx1Z5yez2TySQxMTHK38fX11eioqJuOGB9ZV1vv/22+Pj4iKOjowwbNsxi8P6KRYsWCYAqg7rXW7hwoej1eikpKal2eVRUlPICejOhISKya9cu6dKli+j1emnXrp189tlnFoPL0dHRqk657dChg7Ktpk6dWu0pt9f6s9AoKCiQF198Ubp27Squrq7StGlTadu2rUycOFE5jVlEJCUlRe6++25xcHBQTrktLy+XcePGiYeHh7i4uMiIESNkyZIldRoaIiJz584Vd3d35USPFStWSNeuXUWv14u7u7v07NnT4kw1kcv/+15eXgJAUlNTLZZV9z914sQJeeyxx8TT01Ps7e2lZcuW8vjjj0t2drbS5tSpUwLA4g3K4cOHBYCMGzdO1WOsSxoRXrnvdnHixAnccccd2Lt3L/r27WvtcqgGr732Gr799lscOnTI2qUQ1Tl+IpyojpSUlOD48eNYvnw5Fi9ebO1yiOoFB8KJ6sjQoUMRGhqKf/zjHxg5cqS1yyGqFzw8RUREqnFPg4iIVGNoEBGRan/5gfBTp05ZuwQiotvKjT7oyj0NIiJSjaFBRESqMTSIiEg1hgYREanG0CAiItUYGkREpBpDg4iIVPvLf06DiOh28dZbb8FkMsHT0xOTJk2ydjnVYmgQEdkIk8mEvLw8a5dxQzw8RUREqtnMnkZqairi4+OVi61HRUVZLDeZTFi2bBnOnz8Ps9mMxx57DEFBQVaqloiocbKJ0DCbzVi5ciWmTZsGo9GIKVOmIDg4GH5+fkqbzz//HL1798bf//53/Pbbb5g3bx5Dg4iogdnE4amsrCz4+PjA29sbdnZ2CAkJQUpKikUbjUaDCxcuAAAuXLgADw8Pa5RKRNSo2cSeRlFREYxGozJtNBqRmZlp0ebhhx/GnDlzsHXrVly8eBHTp0+vdl2JiYlITEwEAMTFxcHT07P+CiciqkM6nU65tdXXLpsIDTX27duHfv36YfDgwTh+/DiWLFmCBQsWQKu13FmKjIxEZGSkMm0ymRq6VCKim1JZWancWvO1y+a/Gt1gMKCwsFCZLiwshMFgsGizY8cO9O7dGwDQrl07XLp0CWfPnm3QOomIGjubCI2AgADk5uYiPz8fFRUVSEpKQnBwsEUbT09P/PTTTwCA3377DZcuXYKrq6s1yiUiarRs4vCUTqfDmDFjMHfuXJjNZoSHh8Pf3x8JCQkICAhAcHAwnnjiCXz44YfYvHkzAODZZ5+FRqOxcuVERI2LRkTE2kXUJ17ulYhuFxMnTkReXh58fHzw9ttvW60Omx/TICKi2wNDg4iIVGNoEBGRagwNIiJSjaFBRESqMTSIiEg1hgYREanG0CAiItUYGkREpBpDg4iIVGNoEBGRagwNIiJSjaFBRESq2cRXoxNR4/XWW2/BZDLB09MTkyZNsnY59CcYGkRkVSaTCXl5edYug1Ti4SkiIlKNoUFERKoxNIiISDWGBhERqcbQICIi1RgaRESkGkODiIhUY2gQEZFqDA0iIlKNnwgnIvoT2vQFDdNRebFy2xB9mju+Uuv7cE+DiIhUs5k9jdTUVMTHx8NsNiMiIgJRUVFV2iQlJWHDhg3QaDRo1aoVXnjhBStUSkTUeNlEaJjNZqxcuRLTpk2D0WjElClTEBwcDD8/P6VNbm4uNm7ciNmzZ8PZ2RklJSVWrJiIqHGyicNTWVlZ8PHxgbe3N+zs7BASEoKUlBSLNtu3b8d9990HZ2dnAICbm5s1SiUiatRsYk+jqKgIRqNRmTYajcjMzLRoc+rUKQDA9OnTYTab8fDDD6Nbt25V1pWYmIjExEQAQFxcHDw9PeuxciK6VTqdTrm11f/XImsXUE9uZnvbRGioYTabkZubi9jYWBQVFSE2Nhbz58+Hk5OTRbvIyEhERkYq0yaTqaFLJfpTvPDQVZWVlcqtrf6/2sQhmXpQ0/b29fWt8T42sS0MBgMKCwuV6cLCQhgMhiptgoODYWdnh2bNmqF58+bIzc1t6FKJ6sSVCw/Z6oskUU1sIjQCAgKQm5uL/Px8VFRUICkpCcHBwRZtevbsibS0NADAmTNnkJubC29vb2uUS0TUaNnE4SmdTocxY8Zg7ty5MJvNCA8Ph7+/PxISEhAQEIDg4GB07doVP/74I1566SVotVqMHDkSLi4u1i6diKhRsYnQAICgoCAEBQVZzBs+fLjyu0ajQXR0NKKjoxu6NCIi+i+bODxFRES3B4YGERGpxtAgIiLVGBpERKSazQyE018fP9BGdPtjaFCDufKBNiK6ffHwFBERqcbQICIi1RgaRESkGkODiIhUY2gQEZFqDA0iIlKNoUFERKoxNIiISDWGBhERqcbQICIi1RgaRESkGkODiIhUY2gQEZFqDA0iIlKNoUFERKoxNIiISDWGBhERqcbQICIi1RgaRESk2g2vEf7HH3+oWom3t3edFENERLbthqHx/PPPq1pJQkLCLReSmpqK+Ph4mM1mREREICoqqtp2ycnJWLhwIebNm4eAgIBb7peIiNS7YWhcGwY7d+7EkSNH8PDDD8PLywsFBQX47LPPcNddd91yEWazGStXrsS0adNgNBoxZcoUBAcHw8/Pz6JdaWkptmzZgrZt295yn0REVHuqxzQSEhIQExOD5s2bw87ODs2bN8e4cePw6aef3nIRWVlZ8PHxgbe3N+zs7BASEoKUlJRqaxg6dCiaNGlyy30SEVHt3XBP41oigvz8fIt3/wUFBTCbzbdcRFFREYxGozJtNBqRmZlp0SY7OxsmkwlBQUHYtGlTjetKTExEYmIiACAuLg6enp63XB/VDZ1Op9w29r8Lt8VVt8O2KLJ2AfXkZra36tAYOHAgZs2ahX79+sHT0xMmkwm7d+/GwIEDa91pbZnNZqxevRrPPvvsn7aNjIxEZGSkMm0ymeqzNKqFyspK5bax/124La66HbbFX/U005q2t6+vb433UR0aQ4YMQcuWLbF//36cOHEC7u7ueOaZZ9CtW7faV3odg8GAwsJCZbqwsBAGg0GZLisrw6+//oo33ngDAHD69Gn861//wmuvvcbBcCKiBqQ6NACgW7dudRIS1wsICEBubi7y8/NhMBiQlJRkceZW06ZNsXLlSmV65syZGDVqFAODiKiBqQ6NiooK7Nq1CydOnEBZWZnFsgkTJtxSETqdDmPGjMHcuXNhNpsRHh4Of39/JCQkICAgAMHBwbe0fiIiqhuqQ2Pp0qU4efIkunfvDjc3tzovJCgoCEFBQRbzhg8fXm3bmTNn1nn/RGRp8eLFDdJPcXGxctsQfar9/BlVT3Vo/Pjjj1i6dCmcnJzqsx4iokbL083e4tYWqQ4NT09PXLp0qT5rISJq1KaMsP1xWtWhERoairfffhsPPPAA3N3dLZbdeeeddV4YERHZHtWhsXXrVgDA+vXrLeZrNBosXbq0bqsiIiKbpDo0li1bVp91EBHRbeCv+kFHIiKqB6r3NJ555pkal73//vt1UgwREdk21aHx3HPPWUwXFxfj66+/Rp8+feq8KCIisk2qQ6NTp05V5nXu3Blz587FgAED6rQoIiKyTbc0pmFnZ4f8/Py6qoWIiGyc6j2N6y/pevHiRRw6dAh33313nRdFRES2SXVoXPvV5QCg1+sxaNAghIaG1nlRRERkm1SHhpoLIBER0V9bra6nkZaWht27d6O4uBgeHh4IDQ3lV4gQETUiqgfCt2/fjnfeeQfu7u7o2bMnPDw88O677yrX4yYior8+1XsamzZtwrRp09C6dWtlXkhICBYsWGBxTW6i29m2TbkN0s/5cxXKbUP0ed+Q5vXeBzUOqvc0zp49Cz8/P4t5vr6+OHfuXJ0XRUREtkl1aHTo0AGrV6/GxYsXAQBlZWVYs2YN2rVrV2/FERGRbVF9eOqpp57CokWLMHr0aDg7O+PcuXNo164dXnjhhfqsj4iIbIjq0PDw8MAbb7yBwsJC5ewpo9FYn7UREZGNqdXXiJw/fx5Hjx5Vfs6fP19fdRERkQ1SHRo//fQTxo8fjy1btiArKwtbt27F+PHjceTIkfqsj4iIbIjqw1MrV67EuHHjEBISoszbv38/Vq5ciUWLFtVLcUREZFtU72kUFxejV69eFvN69uyJ06dP13lRRERkm1SHRmhoKLZu3Wox75tvvuEXFhIRNSKqD0/l5OTg22+/xaZNm2AwGFBUVISSkhK0bdsWsbGxSrs33nijXgolIiLrUx0aERERiIiIqLdCUlNTER8fD7PZjIiICERFRVks/+qrr7B9+3bodDq4urrimWeegZeXV73VQ0REVakOjX79+tVbEWazGStXrsS0adNgNBoxZcoUBAcHW3xtSevWrREXFwe9Xo9vvvkGa9euxUsvvVRvNRERUVW1+mr09PR05OTkoKyszGL+sGHDbqmIrKws+Pj4wNvbG8DlL0JMSUmxCI1rv4K9bdu22Lt37y31SVeN/mR/g/RTeaYUAJB3prRB+lwV3bve+yBqbFSHxscff4z9+/ejQ4cOsLe3V+ZrNJpbLqKoqMji0+VGoxGZmZk1tt+xYwe6det2y/0SEVHtqA6NvXv3YsGCBTAYDPVZz5/as2cPsrOzMXPmzGqXJyYmKtf4iIuLg6enZwNWR7bk5v72DfPV6A2N/wdX3cy2KKqHOmzBzWwL1aHh6emJJk2a1LoDNQwGg8U1yAsLC6sNp8OHD+M///kPZs6cWWMtkZGRFtf3MJlMdV8w3Rb4t7+K2+Kqm9kWtfq+pdtITdvC1zoGvEsAAA5KSURBVNe3xvuoDo2YmBh8+OGH6NOnD9zc3CyWderUSe1qqhUQEIDc3Fzk5+fDYDAgKSkJzz//vEWbnJwcrFixAlOnTq3SPxERNQzVoZGdnY1Dhw4hPT3dYkwDAN5///1bKkKn02HMmDGYO3cuzGYzwsPD4e/vj4SEBAQEBCA4OBhr165FWVkZFi5cCODyns+kSZNuqV8iIqod1aGxfv16TJo0CV26dKmXQoKCghAUFGQxb/jw4crv06dPr5d+iYhIPdWH6vR6/S0fhiIiotub6tAYPnw4Vq1ahdOnT8NsNlv8EBFR46D68NSVcYtvv/22yrKEhIS6q4iIiGyW6tBYunRpfdZBRES3AdWhceXLAc1mM0pKSuDm5gat9q969jIREVVHdWhcuHABH3/8Mfbt2wez2QydToeQkBCMGTMGTZs2rc8aiYjIRqjeVYiPj0dZWRkWLFiAtWvXYv78+SgvL8fHH39cn/UREZENUR0aqampeO655+Dr64smTZrA19cXzz77LH788cf6rI+IiGyI6sNT9vb2OHPmjMWFj86cOQM7u1p9u3qj89Zbb8FkMvET7ET0l6D6Fb9///6YM2cOBg4cCC8vLxQUFGDz5s31ejW/vwKTyYS8vDxrl0FEVCdUh8awYcNgMBjw3XffoaioCAaDAUOHDkX//v3rsz4iIrIhqkMjPj4effr0sfgOqIyMDKxatQqjR4+uj9qIiMjGqB4I37dvHwICAizmtWnTBt99912dF0VERLZJdWhoNJoq3zNlNpshInVeFBER2SbVodGhQwd8+umnSnCYzWZs2LABHTp0qLfiiIjItqge0/jnP/+JuLg4PP300/D09ITJZIKHhwdPIyUiakRUh4bRaMRbb72FrKwsFBYWwmg0IjAwkN8/RUTUiNTqk3larRbt2rWrr1qIiMjGcTeBiIhUY2gQEZFqDA0iIlKNoUFERKoxNIiISDWGBhERqcbQICIi1XgFJSKyKr1eb3FLto2hQURW1b59e2uXQLVgM6GRmpqK+Ph4mM1mREREICoqymL5pUuXsHTpUmRnZ8PFxQUvvvgimjVrZqVqiYgaJ5sY0zCbzVi5ciWmTp2Kd955B/v27cNvv/1m0WbHjh1wcnLCkiVLMHDgQKxbt85K1RIRNV42ERpZWVnw8fGBt7c37OzsEBISgpSUFIs2P/zwA/r16wcA6NWrF3766Sdey4OIqIHZxOGpoqIiGI1GZdpoNCIzM7PGNjqdDk2bNsXZs2fh6upq0S4xMRGJiYkAgLi4OHh6elbb55F/RlU7v65VFJT/9/YP5E58st77uyt+Y63v89Urg+uhkqqeTP8Cv18oQQsPZ3zUQH3W1uNjqn++1LWdSXqcPQe4uunx+Ji7GqTP2po1a5a1S7Adf5tn7Qpshk2ERl2KjIxEZGSkMm0ymaxYTcOz5cdbWVmp3NpynQ2B24Jsma+vb43LbOLwlMFgQGFhoTJdWFgIg8FQY5vKykpcuHABLi4uDVonEVFjZxOhERAQgNzcXOTn56OiogJJSUkIDg62aNO9e3fs2rULAJCcnIzOnTtDo9FYoVoiosbLJg5P6XQ6jBkzBnPnzoXZbEZ4eDj8/f2RkJCAgIAABAcHo3///li6dCmee+45ODs748UXX7R22UREjY5NhAYABAUFISgoyGLe8OHDld/t7e3x8ssvN3RZRER0DZs4PEVERLcHhgYREanG0CAiItVsZkyDqDG58qHTmj58SmSrGBpEVjBp0iRrl0B0U3h4ioiIVGNoEBGRagwNIiJSjaFBRESqMTSIiEg1hgYREanWaE+5bf72Rw3Sj93EiUBeHuy8vNH87bcbpE8iovrCPQ0iIlKNoUFERKoxNIiISDWGBhERqcbQICIi1RgaRESkGkODiIhUY2gQEZFqDA0iIlKt0X4inBoer1ZHdPtjaFCD4dXqiG5/PDxFRESqMTSIiEg1hgYREalm9TGNc+fO4Z133kFBQQG8vLzw0ksvwdnZ2aLNiRMnsGLFCpSWlkKr1WLYsGEICQmxUsVERI2X1UNj48aNuOuuuxAVFYWNGzdi48aNGDlypEUbe3t7TJgwAc2bN0dRUREmT56Mrl27wsnJyUpVExE1TlY/PJWSkoKwsDAAQFhYGFJSUqq08fX1RfPmzQEABoMBbm5uOHPmTIPWSURENrCnUVJSAg8PDwCAu7s7SkpKbtg+KysLFRUV8Pb2rnZ5YmIiEhMTAQBxcXFW/0yATqdTbq1dCxHRrWqQ0Jg9ezZOnz5dZf6jjz5qMa3RaKDRaGpcT3FxMZYsWYLx48dDq61+JykyMhKRkZHKtMlkusmq60ZlZaVya+1aiIjU8PX1rXFZg4TG9OnTa1zm5uaG4uJieHh4oLi4GK6urtW2u3DhAuLi4jBixAi0a9euvkolIqIbsPqYRnBwMHbv3g0A2L17N3r06FGlTUVFBebPn4/Q0FD06tWroUskIqL/svqYRlRUFN555x3s2LFDOeUWAH7++Wd8++23iImJQVJSEtLT03H27Fns2rULADB+/Hi0bt3aeoUTETVCVg8NFxcXzJgxo8r8gIAABAQEAABCQ0MRGhra0KUREdF1rH54ioiIbh8MDSIiUo2hQUREqjE0iIhINYYGERGpxtAgIiLVGBpERKQaQ4OIiFRjaBARkWoMDSIiUo2hQUREqjE0iIhINat/YeFf3ZWr9fGqfUT0V6AREbF2EfXp1KlT1i6BiOi2cqMr9/HwFBERqcbQICIi1RgaRESkGkODiIhUY2gQEZFqDA0iIlKNoUFERKr95T+nQUREdYd7Gg1g8uTJ1i7BZnBbXMVtcRW3xVW2vi0YGkREpBpDg4iIVGNoNIDIyEhrl2AzuC2u4ra4itviKlvfFhwIJyIi1binQUREqjE0iIhINV6EqR699957OHjwINzc3LBgwQJrl2M1JpMJy5Ytw+nTp6HRaBAZGYkBAwZYuyyrKC8vR2xsLCoqKlBZWYlevXrhkUcesXZZVmU2mzF58mQYDAabP920Po0fPx4ODg7QarXQ6XSIi4uzdknVYmjUo379+uH+++/HsmXLrF2KVel0OowaNQpt2rRBaWkpJk+ejC5dusDPz8/apTW4Jk2aIDY2Fg4ODqioqMCMGTPQrVs3tGvXztqlWc3XX3+NFi1aoLS01NqlWF1sbCxcXV2tXcYN8fBUPerUqROcnZ2tXYbVeXh4oE2bNgAAR0dHtGjRAkVFRVauyjo0Gg0cHBwAAJWVlaisrIRGo7FyVdZTWFiIgwcPIiIiwtqlkErc06AGlZ+fj5ycHAQGBlq7FKsxm82YNGkS8vLycN9996Ft27bWLslqVq1ahZEjR3Iv47/mzp0LALj33ntt9tRbhgY1mLKyMixYsACjR49G06ZNrV2O1Wi1Wrz99ts4f/485s+fj19++QUtW7a0dlkN7sCBA3Bzc0ObNm2QlpZm7XKsbvbs2TAYDCgpKcGcOXPg6+uLTp06WbusKhga1CAqKiqwYMEC/O1vf8M999xj7XJsgpOTEzp37ozU1NRGGRoZGRn44YcfcOjQIZSXl6O0tBSLFy/G888/b+3SrMJgMAAA3Nzc0KNHD2RlZTE0qHESEXzwwQdo0aIFBg0aZO1yrOrMmTPQ6XRwcnJCeXk5Dh8+jKFDh1q7LKt47LHH8NhjjwEA0tLS8OWXXzbawCgrK4OIwNHREWVlZTh8+DAeeugha5dVLYZGPVq0aBGOHj2Ks2fPIiYmBo888gj69+9v7bIaXEZGBvbs2YOWLVti4sSJAIARI0YgKCjIypU1vOLiYixbtgxmsxkigt69e6N79+7WLousrKSkBPPnzwdw+QSJvn37olu3blauqnr8GhEiIlKNp9wSEZFqDA0iIlKNoUFERKoxNIiISDWGBhERqcbQILKC5cuX47PPPrN2GUS1xlNuierZrl27sH37dsyePdvapRDdMu5pEN2iyspKa5dA1GC4p0F0E8aPH497770X3333HU6dOoUHH3wQu3btQklJCYxGI0aMGIGePXvit99+w6RJk1BRUQF7e3vodDqsWrUKy5Ytg9FoxKOPPoq0tDQsWbIEAwcOxBdffAGtVosRI0YgPDwcAHD27FksW7YM6enp8PX1RdeuXZGWlsY9F7IKfo0I0U3at28fJk+eDFdXVxw4cABvvPEG3N3dkZycjCVLlmDx4sXw8/PDU0899aeHp06fPo0LFy7ggw8+wOHDh7Fw4UL06NEDzs7OWLlyJRwcHLB8+XIUFBRg7ty58PT0bMBHSnQVD08R3aQHHngAnp6esLe3R+/evWEwGKDVahESEgIfHx9kZWWpXpdOp8NDDz0EOzs7BAUFwcHBAadOnYLZbMb333+PRx55BHq9Hn5+fggLC6vHR0V0Y9zTILpJ177b3717N7766isUFBQAuPytpWfPnlW9LhcXF+h0OmVar9ejrKwMZ86cQWVlJYxGo7Ls2t+JGhpDg+gWFRQU4MMPP8SMGTPQrl07aLVaTJw4EXUxXOjq6gqdTofCwkL4+voCuHyJVCJr4eEpolt08eJFaDQauLq6AgB27tyJX3/9VVnu7u6OoqIiVFRU1HrdWq0WPXv2xIYNG3Dx4kX8/vvv2L17d53VTlRb3NMgukV+fn4YNGgQXn/9dWi1WoSGhqJ9+/bK8jvvvFMZENdqtVi5cmWt1j927FgsW7YM48aNg6+vL/r06YPs7Oy6fhhEqvCUW6LbzNq1a3H69GlMmDDB2qVQI8TDU0Q27vfff8fJkychIsjKysLOnTvRs2dPa5dFjRQPTxHZuNLSUrz77rsoLi6Gm5sbBg0ahB49eli7LGqkeHiKiIhU4+EpIiJSjaFBRESqMTSIiEg1hgYREanG0CAiItX+H0/SR5xgoSleAAAAAElFTkSuQmCC\n"
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "We can see that more the 5-star review, it gets a higher compund score"
      ],
      "metadata": {
        "id": "eBflJqDW8s5Y"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "vaders.sort_values(by=['compound']) "
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "CKzYDzIH8zPH",
        "outputId": "0bd6d89f-ef41-4199-c078-3b8e2e2c6763"
      },
      "execution_count": 12,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "           date    neg    neu    pos  compound  \\\n",
              "36  29 Oct 2021  0.170  0.830  0.000   -0.7620   \n",
              "24  12 Mar 2022  0.142  0.818  0.040   -0.7272   \n",
              "19  17 Aug 2021  0.154  0.796  0.050   -0.6684   \n",
              "46  14 Mar 2021  0.150  0.759  0.091   -0.6242   \n",
              "33  24 Jun 2022  0.170  0.723  0.107   -0.6133   \n",
              "45  24 Dec 2019  0.083  0.879  0.038   -0.5859   \n",
              "26  30 Mar 2022  0.113  0.825  0.062   -0.2982   \n",
              "25  30 Mar 2022  0.113  0.825  0.062   -0.2982   \n",
              "0   26 Aug 2022  0.115  0.885  0.000   -0.2960   \n",
              "1   26 Aug 2022  0.115  0.885  0.000   -0.2960   \n",
              "48  17 Oct 2021  0.066  0.934  0.000   -0.2746   \n",
              "41  14 Aug 2022  0.096  0.824  0.080   -0.1513   \n",
              "11  09 Apr 2022  0.087  0.794  0.118   -0.1243   \n",
              "49  25 Feb 2022  0.000  1.000  0.000    0.0000   \n",
              "35  05 Dec 2021  0.000  1.000  0.000    0.0000   \n",
              "22  31 Aug 2022  0.000  1.000  0.000    0.0000   \n",
              "47  30 Aug 2021  0.000  1.000  0.000    0.0000   \n",
              "12  15 Mar 2022  0.000  1.000  0.000    0.0000   \n",
              "14  16 Dec 2021  0.060  0.866  0.073    0.0900   \n",
              "37  29 Mar 2021  0.037  0.917  0.046    0.1882   \n",
              "23  15 May 2022  0.077  0.829  0.094    0.1884   \n",
              "44  06 Oct 2021  0.052  0.854  0.094    0.1987   \n",
              "27  17 Jan 2022  0.000  0.872  0.128    0.2263   \n",
              "31  21 Sep 2021  0.000  0.911  0.089    0.2609   \n",
              "3   23 Aug 2022  0.000  0.813  0.187    0.3182   \n",
              "43  08 Jan 2022  0.000  0.915  0.085    0.3612   \n",
              "15  04 Sep 2021  0.042  0.866  0.092    0.4019   \n",
              "42  20 Mar 2021  0.057  0.845  0.098    0.4141   \n",
              "5   08 Aug 2022  0.128  0.640  0.232    0.4199   \n",
              "39  05 Nov 2021  0.000  0.883  0.117    0.4927   \n",
              "28  08 Jul 2021  0.027  0.894  0.078    0.5023   \n",
              "7   30 Jun 2022  0.000  0.737  0.263    0.5520   \n",
              "13  08 Mar 2022  0.000  0.192  0.808    0.6369   \n",
              "34  03 Jan 2022  0.069  0.712  0.219    0.6901   \n",
              "18  07 Dec 2021  0.088  0.692  0.220    0.7047   \n",
              "17  07 Dec 2021  0.088  0.692  0.220    0.7047   \n",
              "38  05 Apr 2021  0.051  0.817  0.132    0.7579   \n",
              "9   15 Jun 2022  0.082  0.604  0.314    0.8276   \n",
              "2   16 Aug 2022  0.059  0.689  0.252    0.8439   \n",
              "4   19 Aug 2022  0.000  0.299  0.701    0.8553   \n",
              "20  29 Jul 2020  0.021  0.869  0.110    0.8769   \n",
              "30  09 Apr 2021  0.053  0.785  0.162    0.8860   \n",
              "6   05 Aug 2022  0.000  0.512  0.488    0.8879   \n",
              "16  30 Nov 2021  0.000  0.362  0.638    0.8908   \n",
              "29  26 Aug 2021  0.000  0.742  0.258    0.8957   \n",
              "32  11 May 2021  0.052  0.711  0.237    0.8979   \n",
              "40  29 Sep 2019  0.067  0.767  0.166    0.9118   \n",
              "21  12 May 2021  0.097  0.618  0.285    0.9206   \n",
              "10  07 May 2022  0.070  0.621  0.309    0.9214   \n",
              "8   16 Jun 2022  0.000  0.635  0.365    0.9296   \n",
              "\n",
              "                                                title  \\\n",
              "36  Only Lasted 1 Month - Laces Failed and Toe Bro...   \n",
              "24                                          Too tight   \n",
              "19  Love New Balance shoes, but this design is flawed   \n",
              "46                                          Too small   \n",
              "33                                   Wore out quickly   \n",
              "45                                       Poor quality   \n",
              "26                                They don't stay on.   \n",
              "25                         Good shoe but doesn’t last   \n",
              "0                                               Great   \n",
              "1                                         Looked good   \n",
              "48                             These are not durable!   \n",
              "41                         They are not true to size.   \n",
              "11                       Very comfy and great quality   \n",
              "49                                   Not true to size   \n",
              "35                           You get what you pay for   \n",
              "22                              Already falling apart   \n",
              "47  Not wide by any stretch. Very narrow and very ...   \n",
              "12                                             Narrow   \n",
              "14                         Cute but not for wide feet   \n",
              "37                 Worst pair of NB I've ever bought.   \n",
              "23         They were not wide even though picked wide   \n",
              "44                    1.5 months in and falling apart   \n",
              "27             Nice pair of shoes but won't last long   \n",
              "31                               Nice, but too small.   \n",
              "3                                            Hermosos   \n",
              "43                   Less arch support than I wanted.   \n",
              "15                    Nice shoes but not very durable   \n",
              "42            Good when they actually get delivered..   \n",
              "5                                            Adorable   \n",
              "39                                             Stains   \n",
              "28                              Somewhat disappointed   \n",
              "7                                    Beautiful colors   \n",
              "13                                                 Ok   \n",
              "34                                Not new ones for me   \n",
              "18                           Beautiful but won't last   \n",
              "17                     Muy bonitos tal como la imagen   \n",
              "38                Sent used shoes when I ordered new.   \n",
              "9                                    Great kids shoes   \n",
              "2                                     Cute and comfy!   \n",
              "4                                     Shoes are great   \n",
              "20                         Wide is still a bit narrow   \n",
              "30            Cute, but not durable or worth the cost   \n",
              "6                                 Cute bright sneaker   \n",
              "16                                          Love Them   \n",
              "29                                        Runs narrow   \n",
              "32                        Not durable, but fit nicely   \n",
              "40                 Poor Materials...Wearing out fast!   \n",
              "21                 Cute but not for super active kids   \n",
              "10                                       Great value!   \n",
              "8                                           So cute..   \n",
              "\n",
              "                                              content  \\\n",
              "36  After just 6 weeks of wearing these shoes ~5 d...   \n",
              "24  Cute shoes, but my kid could not get them on w...   \n",
              "19  In the photo they looked all black, but the wh...   \n",
              "46  These shoes didn't fit my toddler I had previo...   \n",
              "33  These are very cute and my daughter loves them...   \n",
              "45  These shoes are such poor quality. The tongue ...   \n",
              "26  They don't stay on.  The elastic does not boun...   \n",
              "25  My son tears these up every four months with h...   \n",
              "0   Bought these for my daughter and she loves the...   \n",
              "1   Shoes slip off my child's feet. He can't even ...   \n",
              "48  These are not durable! I purchased these for m...   \n",
              "41  I got NB shoes because they have sizes in wide...   \n",
              "11  Fit really well with a little room to grow. My...   \n",
              "49                                          Too small   \n",
              "35  These sneakers lasted about one month before t...   \n",
              "22  After a couple of weeks of usage (7yo) the fro...   \n",
              "47  Bought this for my 6 yr old that has wide feet...   \n",
              "12     These shoes were a bit narrower than expected.   \n",
              "14  Wouldn’t be good if your child has wide/averag...   \n",
              "37  Bought these for my 5 year old son.  We always...   \n",
              "23  I dont reccomend these sneakers on kids with w...   \n",
              "44  We've only had these for a month and a half an...   \n",
              "27  Nice style and very comfy but started wearing ...   \n",
              "31  It is a very nice pair of shoes, but I got a s...   \n",
              "3   Son tal cual aparecen en la foto, muy cómodos,...   \n",
              "43  The laces are elastic, and you cannot tie them...   \n",
              "15  These shoes are nice & look good but didn’t la...   \n",
              "42  I am a fan of New Balance and think for the va...   \n",
              "5   For granddaughter starting kindergarten .  Hav...   \n",
              "39  This shoe stains extremely easy. I wash them w...   \n",
              "28  I typically like NB, but they should be more e...   \n",
              "7   Colors are very vivid and It looks very soft a...   \n",
              "13                                          Love them   \n",
              "34  Amazon sent me some kind of used shoes. The sh...   \n",
              "18  We ordered these shoes in pink. My daughter ab...   \n",
              "17                                                 no   \n",
              "38  I just received these shoes today. I ordered n...   \n",
              "9   These shoes are great and got matching pairs f...   \n",
              "2   My daughter loves these shoes! The colors are ...   \n",
              "4           Easy stretch to fit ! Perfect for infants   \n",
              "20  These look great and my 3yo loves them. He wan...   \n",
              "30  These shoes were very lightweight and my daugh...   \n",
              "6   Gender neutral sneaker. Slip on and perfect fo...   \n",
              "16    Great Fit and Look. Very Happy with the product   \n",
              "29  I got these for my 18 month old and while they...   \n",
              "32  These are a great little running shoe for my t...   \n",
              "40  I always try and get NB shoes for my kids, bec...   \n",
              "21  My kid loved these shoes, but the mesh fabric ...   \n",
              "10  These shoes have been great for a very active ...   \n",
              "8   Bought these for my granddaughter, she loves t...   \n",
              "\n",
              "                                              variant  \\\n",
              "36                                                NaN   \n",
              "24  Special Size: Little Kid (4-8 Years) Size: 11 ...   \n",
              "19                                                NaN   \n",
              "46  Special Size: Toddler (1-4 Years) Size: 8 Todd...   \n",
              "33                                                NaN   \n",
              "45                                                NaN   \n",
              "26  Special Size: Toddler (1-4 Years) Size: 5.5 To...   \n",
              "25  Special Size: Little Kid (4-8 Years) Size: 12 ...   \n",
              "0   Special Size: Toddler (1-4 Years) Size: 9.5 To...   \n",
              "1   Special Size: Toddler (1-4 Years) Size: 5.5 Wi...   \n",
              "48                                                NaN   \n",
              "41  Special Size: Little Kid (4-8 Years) Size: 11....   \n",
              "11  Special Size: Little Kid (4-8 Years) Size: 10....   \n",
              "49  Special Size: Infant (0-12 Months) Size: 3 Inf...   \n",
              "35  Special Size: Toddler (1-4 Years) Size: 7.5 Wi...   \n",
              "22  Special Size: Little Kid (4-8 Years) Size: 2.5...   \n",
              "47                                                NaN   \n",
              "12  Special Size: Little Kid (4-8 Years) Size: 2.5...   \n",
              "14  Special Size: Little Kid (4-8 Years) Size: 11....   \n",
              "37                                                NaN   \n",
              "23  Special Size: Little Kid (4-8 Years) Size: 10....   \n",
              "44  Special Size: Big Kid (8-12 Years) Size: 4.5 B...   \n",
              "27                                                NaN   \n",
              "31  Special Size: Little Kid (4-8 Years) Size: 12....   \n",
              "3   Special Size: Little Kid (4-8 Years) Size: 12 ...   \n",
              "43  Special Size: Big Kid (8-12 Years) Size: 4.5 W...   \n",
              "15                                                NaN   \n",
              "42  Special Size: Little Kid (4-8 Years) Size: 11....   \n",
              "5   Special Size: Little Kid (4-8 Years) Size: 13....   \n",
              "39  Special Size: Little Kid (4-8 Years) Size: 1 L...   \n",
              "28  Special Size: Little Kid (4-8 Years) Size: 11 ...   \n",
              "7   Special Size: Toddler (1-4 Years) Size: 9.5 Wi...   \n",
              "13  Special Size: Toddler (1-4 Years) Size: 9 Todd...   \n",
              "34  Special Size: Toddler (1-4 Years) Size: 6 Todd...   \n",
              "18                                                NaN   \n",
              "17  Special Size: Toddler (1-4 Years) Size: 6 Wide...   \n",
              "38  Special Size: Toddler (1-4 Years) Size: 6.5 To...   \n",
              "9   Special Size: Toddler (1-4 Years) Size: 8 Todd...   \n",
              "2   Special Size: Little Kid (4-8 Years) Size: 3 L...   \n",
              "4   Special Size: Infant (0-12 Months) Size: 3 Wid...   \n",
              "20                                                NaN   \n",
              "30  Special Size: Little Kid (4-8 Years) Size: 1.5...   \n",
              "6   Special Size: Little Kid (4-8 Years) Size: 1 L...   \n",
              "16  Special Size: Toddler (1-4 Years) Size: 6 Todd...   \n",
              "29                                                NaN   \n",
              "32                                                NaN   \n",
              "40                                                NaN   \n",
              "21                                                NaN   \n",
              "10  Special Size: Toddler (1-4 Years) Size: 9.5 Wi...   \n",
              "8   Special Size: Toddler (1-4 Years) Size: 5 Wide...   \n",
              "\n",
              "                                               images verified  \\\n",
              "36                                                NaN      Yes   \n",
              "24                                                NaN      Yes   \n",
              "19                                                NaN      Yes   \n",
              "46                                                NaN      Yes   \n",
              "33                                                NaN      Yes   \n",
              "45                                                NaN      Yes   \n",
              "26                                                NaN      Yes   \n",
              "25                                                NaN      Yes   \n",
              "0                                                 NaN      Yes   \n",
              "1                                                 NaN      Yes   \n",
              "48  https://m.media-amazon.com/images/W/WEBP_40237...      Yes   \n",
              "41                                                NaN      Yes   \n",
              "11                                                NaN      Yes   \n",
              "49                                                NaN      Yes   \n",
              "35                                                NaN      Yes   \n",
              "22                                                NaN      Yes   \n",
              "47                                                NaN      Yes   \n",
              "12                                                NaN      Yes   \n",
              "14                                                NaN      Yes   \n",
              "37                                                NaN      Yes   \n",
              "23                                                NaN      Yes   \n",
              "44  https://m.media-amazon.com/images/W/WEBP_40237...      Yes   \n",
              "27  https://m.media-amazon.com/images/W/WEBP_40237...      Yes   \n",
              "31                                                NaN      Yes   \n",
              "3                                                 NaN      Yes   \n",
              "43                                                NaN      Yes   \n",
              "15                                                NaN      Yes   \n",
              "42                                                NaN      Yes   \n",
              "5                                                 NaN      Yes   \n",
              "39                                                NaN      Yes   \n",
              "28                                                NaN      Yes   \n",
              "7                                                 NaN      Yes   \n",
              "13                                                NaN      Yes   \n",
              "34                                                NaN      Yes   \n",
              "18                                                NaN      Yes   \n",
              "17  https://m.media-amazon.com/images/I/81bbNUHNV6...      Yes   \n",
              "38                                                NaN      Yes   \n",
              "9                                                 NaN      Yes   \n",
              "2                                                 NaN      Yes   \n",
              "4                                                 NaN      Yes   \n",
              "20                                                NaN      Yes   \n",
              "30                                                NaN      Yes   \n",
              "6                                                 NaN      Yes   \n",
              "16                                                NaN      Yes   \n",
              "29                                                NaN      Yes   \n",
              "32  https://images-na.ssl-images-amazon.com/images...      Yes   \n",
              "40                                                NaN      Yes   \n",
              "21                                                NaN      Yes   \n",
              "10                                                NaN      Yes   \n",
              "8                                                 NaN      Yes   \n",
              "\n",
              "                                    author  rating  \\\n",
              "36                         Amazon Customer       2   \n",
              "24                                 Miranda       3   \n",
              "19                         Amazon Customer       4   \n",
              "46                                    Zuli       1   \n",
              "33                            Piper's mama       2   \n",
              "45                                  MaeMae       1   \n",
              "26                                David S.       1   \n",
              "25                             Jackie Jara       3   \n",
              "0                           southern twang       5   \n",
              "1                        Talisa Shelanskey       2   \n",
              "48                              Jessica H.       1   \n",
              "41                         Amazon Customer       1   \n",
              "11                               Brenda J.       4   \n",
              "49                                  Simone       1   \n",
              "35                                  Becks5       2   \n",
              "22                                    L.W.       3   \n",
              "47                         Amazon Customer       1   \n",
              "12                                Shiva S.       4   \n",
              "14                                   ABarb       4   \n",
              "37                         Matt Huntsinger       2   \n",
              "23                       Illyfromphilly215       3   \n",
              "44                            MSUTheaStdnt       1   \n",
              "27                                IZ-Miami       3   \n",
              "31                                  Julian       3   \n",
              "3                           Tania Alvarado       5   \n",
              "43                                      WW       1   \n",
              "15                              Amy Parker       4   \n",
              "42                              M. Ebbecke       1   \n",
              "5                                  Dorothy       5   \n",
              "39                           Amanda Dudley       2   \n",
              "28                             MK Laughlin       3   \n",
              "7                                      SSK       5   \n",
              "13                              Bunny Rios       4   \n",
              "34                         Santiago Garcia       2   \n",
              "18                       Veronika Andrlova       2   \n",
              "17  crysthel grimaneza izurieta noblecilla       4   \n",
              "38                        Angela Donaldson       2   \n",
              "9                                    Kevin       5   \n",
              "2                                     KBen       5   \n",
              "4                             David Connor       5   \n",
              "20                                     YVV       4   \n",
              "30                                   L2Mom       3   \n",
              "6                                 Hokie 96       5   \n",
              "16                            Greg Gilmore       4   \n",
              "29                               nwhite110       3   \n",
              "32                                      ar       3   \n",
              "40                                   Trish       2   \n",
              "21                                Elsiev23       4   \n",
              "10                                b jordan       5   \n",
              "8                         Crystal Kauffman       5   \n",
              "\n",
              "                                              product  \\\n",
              "36  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "24  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "19  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "46  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "33  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "45  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "26  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "25  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "0   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "1   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "48  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "41  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "11  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "49  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "35  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "22  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "47  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "12  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "14  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "37  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "23  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "44  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "27  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "31  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "3   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "43  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "15  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "42  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "5   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "39  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "28  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "7   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "13  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "34  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "18  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "17  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "38  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "9   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "2   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "4   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "20  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "30  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "6   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "16  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "29  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "32  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "40  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "21  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "10  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "8   New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "\n",
              "                                                  url  \n",
              "36  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "24  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "19  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "46  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "33  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "45  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "26  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "25  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "0   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "1   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "48  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "41  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "11  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "49  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "35  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "22  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "47  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "12  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "14  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "37  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "23  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "44  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "27  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "31  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "3   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "43  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "15  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "42  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "5   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "39  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "28  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "7   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "13  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "34  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "18  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "17  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "38  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "9   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "2   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "4   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "20  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "30  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "6   https://www.amazon.com/product-reviews/B096D3W...  \n",
              "16  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "29  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "32  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "40  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "21  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "10  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "8   https://www.amazon.com/product-reviews/B096D3W...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-cc05a347-02c2-4cbd-843d-d9305e6b3292\">\n",
              "    <div 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>date</th>\n",
              "      <th>neg</th>\n",
              "      <th>neu</th>\n",
              "      <th>pos</th>\n",
              "      <th>compound</th>\n",
              "      <th>title</th>\n",
              "      <th>content</th>\n",
              "      <th>variant</th>\n",
              "      <th>images</th>\n",
              "      <th>verified</th>\n",
              "      <th>author</th>\n",
              "      <th>rating</th>\n",
              "      <th>product</th>\n",
              "      <th>url</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>36</th>\n",
              "      <td>29 Oct 2021</td>\n",
              "      <td>0.170</td>\n",
              "      <td>0.830</td>\n",
              "      <td>0.000</td>\n",
              "      <td>-0.7620</td>\n",
              "      <td>Only Lasted 1 Month - Laces Failed and Toe Bro...</td>\n",
              "      <td>After just 6 weeks of wearing these shoes ~5 d...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amazon Customer</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>24</th>\n",
              "      <td>12 Mar 2022</td>\n",
              "      <td>0.142</td>\n",
              "      <td>0.818</td>\n",
              "      <td>0.040</td>\n",
              "      <td>-0.7272</td>\n",
              "      <td>Too tight</td>\n",
              "      <td>Cute shoes, but my kid could not get them on w...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 11 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Miranda</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>19</th>\n",
              "      <td>17 Aug 2021</td>\n",
              "      <td>0.154</td>\n",
              "      <td>0.796</td>\n",
              "      <td>0.050</td>\n",
              "      <td>-0.6684</td>\n",
              "      <td>Love New Balance shoes, but this design is flawed</td>\n",
              "      <td>In the photo they looked all black, but the wh...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amazon Customer</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>46</th>\n",
              "      <td>14 Mar 2021</td>\n",
              "      <td>0.150</td>\n",
              "      <td>0.759</td>\n",
              "      <td>0.091</td>\n",
              "      <td>-0.6242</td>\n",
              "      <td>Too small</td>\n",
              "      <td>These shoes didn't fit my toddler I had previo...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 8 Todd...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Zuli</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>33</th>\n",
              "      <td>24 Jun 2022</td>\n",
              "      <td>0.170</td>\n",
              "      <td>0.723</td>\n",
              "      <td>0.107</td>\n",
              "      <td>-0.6133</td>\n",
              "      <td>Wore out quickly</td>\n",
              "      <td>These are very cute and my daughter loves them...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Piper's mama</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>45</th>\n",
              "      <td>24 Dec 2019</td>\n",
              "      <td>0.083</td>\n",
              "      <td>0.879</td>\n",
              "      <td>0.038</td>\n",
              "      <td>-0.5859</td>\n",
              "      <td>Poor quality</td>\n",
              "      <td>These shoes are such poor quality. The tongue ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>MaeMae</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>26</th>\n",
              "      <td>30 Mar 2022</td>\n",
              "      <td>0.113</td>\n",
              "      <td>0.825</td>\n",
              "      <td>0.062</td>\n",
              "      <td>-0.2982</td>\n",
              "      <td>They don't stay on.</td>\n",
              "      <td>They don't stay on.  The elastic does not boun...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 5.5 To...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>David S.</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>25</th>\n",
              "      <td>30 Mar 2022</td>\n",
              "      <td>0.113</td>\n",
              "      <td>0.825</td>\n",
              "      <td>0.062</td>\n",
              "      <td>-0.2982</td>\n",
              "      <td>Good shoe but doesn’t last</td>\n",
              "      <td>My son tears these up every four months with h...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 12 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Jackie Jara</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>26 Aug 2022</td>\n",
              "      <td>0.115</td>\n",
              "      <td>0.885</td>\n",
              "      <td>0.000</td>\n",
              "      <td>-0.2960</td>\n",
              "      <td>Great</td>\n",
              "      <td>Bought these for my daughter and she loves the...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 9.5 To...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>southern twang</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>26 Aug 2022</td>\n",
              "      <td>0.115</td>\n",
              "      <td>0.885</td>\n",
              "      <td>0.000</td>\n",
              "      <td>-0.2960</td>\n",
              "      <td>Looked good</td>\n",
              "      <td>Shoes slip off my child's feet. He can't even ...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 5.5 Wi...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Talisa Shelanskey</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>48</th>\n",
              "      <td>17 Oct 2021</td>\n",
              "      <td>0.066</td>\n",
              "      <td>0.934</td>\n",
              "      <td>0.000</td>\n",
              "      <td>-0.2746</td>\n",
              "      <td>These are not durable!</td>\n",
              "      <td>These are not durable! I purchased these for m...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://m.media-amazon.com/images/W/WEBP_40237...</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Jessica H.</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>41</th>\n",
              "      <td>14 Aug 2022</td>\n",
              "      <td>0.096</td>\n",
              "      <td>0.824</td>\n",
              "      <td>0.080</td>\n",
              "      <td>-0.1513</td>\n",
              "      <td>They are not true to size.</td>\n",
              "      <td>I got NB shoes because they have sizes in wide...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 11....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amazon Customer</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>11</th>\n",
              "      <td>09 Apr 2022</td>\n",
              "      <td>0.087</td>\n",
              "      <td>0.794</td>\n",
              "      <td>0.118</td>\n",
              "      <td>-0.1243</td>\n",
              "      <td>Very comfy and great quality</td>\n",
              "      <td>Fit really well with a little room to grow. My...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 10....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Brenda J.</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>49</th>\n",
              "      <td>25 Feb 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>1.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>Not true to size</td>\n",
              "      <td>Too small</td>\n",
              "      <td>Special Size: Infant (0-12 Months) Size: 3 Inf...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Simone</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>35</th>\n",
              "      <td>05 Dec 2021</td>\n",
              "      <td>0.000</td>\n",
              "      <td>1.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>You get what you pay for</td>\n",
              "      <td>These sneakers lasted about one month before t...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 7.5 Wi...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Becks5</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>22</th>\n",
              "      <td>31 Aug 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>1.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>Already falling apart</td>\n",
              "      <td>After a couple of weeks of usage (7yo) the fro...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 2.5...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>L.W.</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>47</th>\n",
              "      <td>30 Aug 2021</td>\n",
              "      <td>0.000</td>\n",
              "      <td>1.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>Not wide by any stretch. Very narrow and very ...</td>\n",
              "      <td>Bought this for my 6 yr old that has wide feet...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amazon Customer</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>12</th>\n",
              "      <td>15 Mar 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>1.000</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.0000</td>\n",
              "      <td>Narrow</td>\n",
              "      <td>These shoes were a bit narrower than expected.</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 2.5...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Shiva S.</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>14</th>\n",
              "      <td>16 Dec 2021</td>\n",
              "      <td>0.060</td>\n",
              "      <td>0.866</td>\n",
              "      <td>0.073</td>\n",
              "      <td>0.0900</td>\n",
              "      <td>Cute but not for wide feet</td>\n",
              "      <td>Wouldn’t be good if your child has wide/averag...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 11....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>ABarb</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>37</th>\n",
              "      <td>29 Mar 2021</td>\n",
              "      <td>0.037</td>\n",
              "      <td>0.917</td>\n",
              "      <td>0.046</td>\n",
              "      <td>0.1882</td>\n",
              "      <td>Worst pair of NB I've ever bought.</td>\n",
              "      <td>Bought these for my 5 year old son.  We always...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Matt Huntsinger</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>23</th>\n",
              "      <td>15 May 2022</td>\n",
              "      <td>0.077</td>\n",
              "      <td>0.829</td>\n",
              "      <td>0.094</td>\n",
              "      <td>0.1884</td>\n",
              "      <td>They were not wide even though picked wide</td>\n",
              "      <td>I dont reccomend these sneakers on kids with w...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 10....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Illyfromphilly215</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>44</th>\n",
              "      <td>06 Oct 2021</td>\n",
              "      <td>0.052</td>\n",
              "      <td>0.854</td>\n",
              "      <td>0.094</td>\n",
              "      <td>0.1987</td>\n",
              "      <td>1.5 months in and falling apart</td>\n",
              "      <td>We've only had these for a month and a half an...</td>\n",
              "      <td>Special Size: Big Kid (8-12 Years) Size: 4.5 B...</td>\n",
              "      <td>https://m.media-amazon.com/images/W/WEBP_40237...</td>\n",
              "      <td>Yes</td>\n",
              "      <td>MSUTheaStdnt</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>27</th>\n",
              "      <td>17 Jan 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.872</td>\n",
              "      <td>0.128</td>\n",
              "      <td>0.2263</td>\n",
              "      <td>Nice pair of shoes but won't last long</td>\n",
              "      <td>Nice style and very comfy but started wearing ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://m.media-amazon.com/images/W/WEBP_40237...</td>\n",
              "      <td>Yes</td>\n",
              "      <td>IZ-Miami</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>31</th>\n",
              "      <td>21 Sep 2021</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.911</td>\n",
              "      <td>0.089</td>\n",
              "      <td>0.2609</td>\n",
              "      <td>Nice, but too small.</td>\n",
              "      <td>It is a very nice pair of shoes, but I got a s...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 12....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Julian</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>23 Aug 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.813</td>\n",
              "      <td>0.187</td>\n",
              "      <td>0.3182</td>\n",
              "      <td>Hermosos</td>\n",
              "      <td>Son tal cual aparecen en la foto, muy cómodos,...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 12 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Tania Alvarado</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>43</th>\n",
              "      <td>08 Jan 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.915</td>\n",
              "      <td>0.085</td>\n",
              "      <td>0.3612</td>\n",
              "      <td>Less arch support than I wanted.</td>\n",
              "      <td>The laces are elastic, and you cannot tie them...</td>\n",
              "      <td>Special Size: Big Kid (8-12 Years) Size: 4.5 W...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>WW</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>15</th>\n",
              "      <td>04 Sep 2021</td>\n",
              "      <td>0.042</td>\n",
              "      <td>0.866</td>\n",
              "      <td>0.092</td>\n",
              "      <td>0.4019</td>\n",
              "      <td>Nice shoes but not very durable</td>\n",
              "      <td>These shoes are nice &amp; look good but didn’t la...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amy Parker</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>42</th>\n",
              "      <td>20 Mar 2021</td>\n",
              "      <td>0.057</td>\n",
              "      <td>0.845</td>\n",
              "      <td>0.098</td>\n",
              "      <td>0.4141</td>\n",
              "      <td>Good when they actually get delivered..</td>\n",
              "      <td>I am a fan of New Balance and think for the va...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 11....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>M. Ebbecke</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>5</th>\n",
              "      <td>08 Aug 2022</td>\n",
              "      <td>0.128</td>\n",
              "      <td>0.640</td>\n",
              "      <td>0.232</td>\n",
              "      <td>0.4199</td>\n",
              "      <td>Adorable</td>\n",
              "      <td>For granddaughter starting kindergarten .  Hav...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 13....</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Dorothy</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>39</th>\n",
              "      <td>05 Nov 2021</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.883</td>\n",
              "      <td>0.117</td>\n",
              "      <td>0.4927</td>\n",
              "      <td>Stains</td>\n",
              "      <td>This shoe stains extremely easy. I wash them w...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 1 L...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amanda Dudley</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>28</th>\n",
              "      <td>08 Jul 2021</td>\n",
              "      <td>0.027</td>\n",
              "      <td>0.894</td>\n",
              "      <td>0.078</td>\n",
              "      <td>0.5023</td>\n",
              "      <td>Somewhat disappointed</td>\n",
              "      <td>I typically like NB, but they should be more e...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 11 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>MK Laughlin</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>7</th>\n",
              "      <td>30 Jun 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.737</td>\n",
              "      <td>0.263</td>\n",
              "      <td>0.5520</td>\n",
              "      <td>Beautiful colors</td>\n",
              "      <td>Colors are very vivid and It looks very soft a...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 9.5 Wi...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>SSK</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>13</th>\n",
              "      <td>08 Mar 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.192</td>\n",
              "      <td>0.808</td>\n",
              "      <td>0.6369</td>\n",
              "      <td>Ok</td>\n",
              "      <td>Love them</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 9 Todd...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Bunny Rios</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>34</th>\n",
              "      <td>03 Jan 2022</td>\n",
              "      <td>0.069</td>\n",
              "      <td>0.712</td>\n",
              "      <td>0.219</td>\n",
              "      <td>0.6901</td>\n",
              "      <td>Not new ones for me</td>\n",
              "      <td>Amazon sent me some kind of used shoes. The sh...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 6 Todd...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Santiago Garcia</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>18</th>\n",
              "      <td>07 Dec 2021</td>\n",
              "      <td>0.088</td>\n",
              "      <td>0.692</td>\n",
              "      <td>0.220</td>\n",
              "      <td>0.7047</td>\n",
              "      <td>Beautiful but won't last</td>\n",
              "      <td>We ordered these shoes in pink. My daughter ab...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Veronika Andrlova</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>17</th>\n",
              "      <td>07 Dec 2021</td>\n",
              "      <td>0.088</td>\n",
              "      <td>0.692</td>\n",
              "      <td>0.220</td>\n",
              "      <td>0.7047</td>\n",
              "      <td>Muy bonitos tal como la imagen</td>\n",
              "      <td>no</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 6 Wide...</td>\n",
              "      <td>https://m.media-amazon.com/images/I/81bbNUHNV6...</td>\n",
              "      <td>Yes</td>\n",
              "      <td>crysthel grimaneza izurieta noblecilla</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>38</th>\n",
              "      <td>05 Apr 2021</td>\n",
              "      <td>0.051</td>\n",
              "      <td>0.817</td>\n",
              "      <td>0.132</td>\n",
              "      <td>0.7579</td>\n",
              "      <td>Sent used shoes when I ordered new.</td>\n",
              "      <td>I just received these shoes today. I ordered n...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 6.5 To...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Angela Donaldson</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>9</th>\n",
              "      <td>15 Jun 2022</td>\n",
              "      <td>0.082</td>\n",
              "      <td>0.604</td>\n",
              "      <td>0.314</td>\n",
              "      <td>0.8276</td>\n",
              "      <td>Great kids shoes</td>\n",
              "      <td>These shoes are great and got matching pairs f...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 8 Todd...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Kevin</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>16 Aug 2022</td>\n",
              "      <td>0.059</td>\n",
              "      <td>0.689</td>\n",
              "      <td>0.252</td>\n",
              "      <td>0.8439</td>\n",
              "      <td>Cute and comfy!</td>\n",
              "      <td>My daughter loves these shoes! The colors are ...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 3 L...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>KBen</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>19 Aug 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.299</td>\n",
              "      <td>0.701</td>\n",
              "      <td>0.8553</td>\n",
              "      <td>Shoes are great</td>\n",
              "      <td>Easy stretch to fit ! Perfect for infants</td>\n",
              "      <td>Special Size: Infant (0-12 Months) Size: 3 Wid...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>David Connor</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>20</th>\n",
              "      <td>29 Jul 2020</td>\n",
              "      <td>0.021</td>\n",
              "      <td>0.869</td>\n",
              "      <td>0.110</td>\n",
              "      <td>0.8769</td>\n",
              "      <td>Wide is still a bit narrow</td>\n",
              "      <td>These look great and my 3yo loves them. He wan...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>YVV</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>30</th>\n",
              "      <td>09 Apr 2021</td>\n",
              "      <td>0.053</td>\n",
              "      <td>0.785</td>\n",
              "      <td>0.162</td>\n",
              "      <td>0.8860</td>\n",
              "      <td>Cute, but not durable or worth the cost</td>\n",
              "      <td>These shoes were very lightweight and my daugh...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 1.5...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>L2Mom</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>6</th>\n",
              "      <td>05 Aug 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.512</td>\n",
              "      <td>0.488</td>\n",
              "      <td>0.8879</td>\n",
              "      <td>Cute bright sneaker</td>\n",
              "      <td>Gender neutral sneaker. Slip on and perfect fo...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 1 L...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Hokie 96</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>16</th>\n",
              "      <td>30 Nov 2021</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.362</td>\n",
              "      <td>0.638</td>\n",
              "      <td>0.8908</td>\n",
              "      <td>Love Them</td>\n",
              "      <td>Great Fit and Look. Very Happy with the product</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 6 Todd...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Greg Gilmore</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>29</th>\n",
              "      <td>26 Aug 2021</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.742</td>\n",
              "      <td>0.258</td>\n",
              "      <td>0.8957</td>\n",
              "      <td>Runs narrow</td>\n",
              "      <td>I got these for my 18 month old and while they...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>nwhite110</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>32</th>\n",
              "      <td>11 May 2021</td>\n",
              "      <td>0.052</td>\n",
              "      <td>0.711</td>\n",
              "      <td>0.237</td>\n",
              "      <td>0.8979</td>\n",
              "      <td>Not durable, but fit nicely</td>\n",
              "      <td>These are a great little running shoe for my t...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>https://images-na.ssl-images-amazon.com/images...</td>\n",
              "      <td>Yes</td>\n",
              "      <td>ar</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>40</th>\n",
              "      <td>29 Sep 2019</td>\n",
              "      <td>0.067</td>\n",
              "      <td>0.767</td>\n",
              "      <td>0.166</td>\n",
              "      <td>0.9118</td>\n",
              "      <td>Poor Materials...Wearing out fast!</td>\n",
              "      <td>I always try and get NB shoes for my kids, bec...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Trish</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>21</th>\n",
              "      <td>12 May 2021</td>\n",
              "      <td>0.097</td>\n",
              "      <td>0.618</td>\n",
              "      <td>0.285</td>\n",
              "      <td>0.9206</td>\n",
              "      <td>Cute but not for super active kids</td>\n",
              "      <td>My kid loved these shoes, but the mesh fabric ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Elsiev23</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>10</th>\n",
              "      <td>07 May 2022</td>\n",
              "      <td>0.070</td>\n",
              "      <td>0.621</td>\n",
              "      <td>0.309</td>\n",
              "      <td>0.9214</td>\n",
              "      <td>Great value!</td>\n",
              "      <td>These shoes have been great for a very active ...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 9.5 Wi...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>b jordan</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>8</th>\n",
              "      <td>16 Jun 2022</td>\n",
              "      <td>0.000</td>\n",
              "      <td>0.635</td>\n",
              "      <td>0.365</td>\n",
              "      <td>0.9296</td>\n",
              "      <td>So cute..</td>\n",
              "      <td>Bought these for my granddaughter, she loves t...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 5 Wide...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Crystal Kauffman</td>\n",
              "      <td>5</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-cc05a347-02c2-4cbd-843d-d9305e6b3292')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-cc05a347-02c2-4cbd-843d-d9305e6b3292 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-cc05a347-02c2-4cbd-843d-d9305e6b3292');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 12
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "bad_review_df=vaders.loc[vaders['compound'] <0.2] #taking all the rows with compound score as negative/below 3 star rating\n",
        "bad_review_df=bad_review_df.sort_values(by=['compound'])\n",
        "bad_review_df.reset_index(drop=True, inplace=True)\n",
        "\n",
        "bad_review_df.head()"
      ],
      "metadata": {
        "id": "PFksUPYVEu1o",
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 878
        },
        "outputId": "ee61bd28-7cab-42cf-8423-e66117b6ba56"
      },
      "execution_count": 13,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "          date    neg    neu    pos  compound  \\\n",
              "0  29 Oct 2021  0.170  0.830  0.000   -0.7620   \n",
              "1  12 Mar 2022  0.142  0.818  0.040   -0.7272   \n",
              "2  17 Aug 2021  0.154  0.796  0.050   -0.6684   \n",
              "3  14 Mar 2021  0.150  0.759  0.091   -0.6242   \n",
              "4  24 Jun 2022  0.170  0.723  0.107   -0.6133   \n",
              "\n",
              "                                               title  \\\n",
              "0  Only Lasted 1 Month - Laces Failed and Toe Bro...   \n",
              "1                                          Too tight   \n",
              "2  Love New Balance shoes, but this design is flawed   \n",
              "3                                          Too small   \n",
              "4                                   Wore out quickly   \n",
              "\n",
              "                                             content  \\\n",
              "0  After just 6 weeks of wearing these shoes ~5 d...   \n",
              "1  Cute shoes, but my kid could not get them on w...   \n",
              "2  In the photo they looked all black, but the wh...   \n",
              "3  These shoes didn't fit my toddler I had previo...   \n",
              "4  These are very cute and my daughter loves them...   \n",
              "\n",
              "                                             variant images verified  \\\n",
              "0                                                NaN    NaN      Yes   \n",
              "1  Special Size: Little Kid (4-8 Years) Size: 11 ...    NaN      Yes   \n",
              "2                                                NaN    NaN      Yes   \n",
              "3  Special Size: Toddler (1-4 Years) Size: 8 Todd...    NaN      Yes   \n",
              "4                                                NaN    NaN      Yes   \n",
              "\n",
              "            author  rating                                            product  \\\n",
              "0  Amazon Customer       2  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "1          Miranda       3  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "2  Amazon Customer       4  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "3             Zuli       1  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "4     Piper's mama       2  New Balance Kid's Fresh Foam Arishi V2 Bungee ...   \n",
              "\n",
              "                                                 url  \n",
              "0  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "1  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "2  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "3  https://www.amazon.com/product-reviews/B096D3W...  \n",
              "4  https://www.amazon.com/product-reviews/B096D3W...  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-062f72a0-1fdf-4bc9-9128-0d4b9dc06924\">\n",
              "    <div 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>date</th>\n",
              "      <th>neg</th>\n",
              "      <th>neu</th>\n",
              "      <th>pos</th>\n",
              "      <th>compound</th>\n",
              "      <th>title</th>\n",
              "      <th>content</th>\n",
              "      <th>variant</th>\n",
              "      <th>images</th>\n",
              "      <th>verified</th>\n",
              "      <th>author</th>\n",
              "      <th>rating</th>\n",
              "      <th>product</th>\n",
              "      <th>url</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>29 Oct 2021</td>\n",
              "      <td>0.170</td>\n",
              "      <td>0.830</td>\n",
              "      <td>0.000</td>\n",
              "      <td>-0.7620</td>\n",
              "      <td>Only Lasted 1 Month - Laces Failed and Toe Bro...</td>\n",
              "      <td>After just 6 weeks of wearing these shoes ~5 d...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amazon Customer</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>12 Mar 2022</td>\n",
              "      <td>0.142</td>\n",
              "      <td>0.818</td>\n",
              "      <td>0.040</td>\n",
              "      <td>-0.7272</td>\n",
              "      <td>Too tight</td>\n",
              "      <td>Cute shoes, but my kid could not get them on w...</td>\n",
              "      <td>Special Size: Little Kid (4-8 Years) Size: 11 ...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Miranda</td>\n",
              "      <td>3</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>17 Aug 2021</td>\n",
              "      <td>0.154</td>\n",
              "      <td>0.796</td>\n",
              "      <td>0.050</td>\n",
              "      <td>-0.6684</td>\n",
              "      <td>Love New Balance shoes, but this design is flawed</td>\n",
              "      <td>In the photo they looked all black, but the wh...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Amazon Customer</td>\n",
              "      <td>4</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>14 Mar 2021</td>\n",
              "      <td>0.150</td>\n",
              "      <td>0.759</td>\n",
              "      <td>0.091</td>\n",
              "      <td>-0.6242</td>\n",
              "      <td>Too small</td>\n",
              "      <td>These shoes didn't fit my toddler I had previo...</td>\n",
              "      <td>Special Size: Toddler (1-4 Years) Size: 8 Todd...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Zuli</td>\n",
              "      <td>1</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>24 Jun 2022</td>\n",
              "      <td>0.170</td>\n",
              "      <td>0.723</td>\n",
              "      <td>0.107</td>\n",
              "      <td>-0.6133</td>\n",
              "      <td>Wore out quickly</td>\n",
              "      <td>These are very cute and my daughter loves them...</td>\n",
              "      <td>NaN</td>\n",
              "      <td>NaN</td>\n",
              "      <td>Yes</td>\n",
              "      <td>Piper's mama</td>\n",
              "      <td>2</td>\n",
              "      <td>New Balance Kid's Fresh Foam Arishi V2 Bungee ...</td>\n",
              "      <td>https://www.amazon.com/product-reviews/B096D3W...</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-062f72a0-1fdf-4bc9-9128-0d4b9dc06924')\"\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 0 24 24\"\n",
              "       width=\"24px\">\n",
              "    <path d=\"M0 0h24v24H0V0z\" fill=\"none\"/>\n",
              "    <path d=\"M18.56 5.44l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94zm-11 1L8.5 8.5l.94-2.06 2.06-.94-2.06-.94L8.5 2.5l-.94 2.06-2.06.94zm10 10l.94 2.06.94-2.06 2.06-.94-2.06-.94-.94-2.06-.94 2.06-2.06.94z\"/><path d=\"M17.41 7.96l-1.37-1.37c-.4-.4-.92-.59-1.43-.59-.52 0-1.04.2-1.43.59L10.3 9.45l-7.72 7.72c-.78.78-.78 2.05 0 2.83L4 21.41c.39.39.9.59 1.41.59.51 0 1.02-.2 1.41-.59l7.78-7.78 2.81-2.81c.8-.78.8-2.07 0-2.86zM5.41 20L4 18.59l7.72-7.72 1.47 1.35L5.41 20z\"/>\n",
              "  </svg>\n",
              "      </button>\n",
              "      \n",
              "  <style>\n",
              "    .colab-df-container {\n",
              "      display:flex;\n",
              "      flex-wrap:wrap;\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",
              "    [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-062f72a0-1fdf-4bc9-9128-0d4b9dc06924 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-062f72a0-1fdf-4bc9-9128-0d4b9dc06924');\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",
              "  </div>\n",
              "  "
            ]
          },
          "metadata": {},
          "execution_count": 13
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "\n",
        "no_filler_words_list=[]\n",
        "\n",
        "for i, row in tqdm(df.iterrows(), total=len(df)):\n",
        "    text = row['title']\n",
        "    tokens = nltk.word_tokenize(text) #breaking down the review\n",
        "    tokens_without_sw = [word for word in tokens if not word in stopwords.words('english')] #removing stopwords\n",
        "    no_filler_words_list.append(tokens_without_sw)\n",
        "\n",
        "\n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 49,
          "referenced_widgets": [
            "eaa18c65fae54b8aa69bfeedfbf026dc",
            "3aaf5c15d34c45e891a5474fbe8bbe66",
            "0e758e069e0047f7844aa0c3d63b617c",
            "79dc73bfb0e54f81889b342cdb2f3132",
            "dbdae80d8a2649d99fd67e02784c1caa",
            "ee977fb8f820424cab28d3e98fe41748",
            "bfc4180bd3f344ff965d419fbc6d6e15",
            "5ea2a2bff98c40c59c00a503fef4be5d",
            "e1fdfc953cba41dbb3edb0cec5ddb25a",
            "e7c1ad7494c54fa4be1d16684714983d",
            "a50a0d994d7443e29d5d85895292f5ee"
          ]
        },
        "id": "_eWS8p6on_45",
        "outputId": "f56ff0fd-50fb-4e01-ed8a-439837b2d9c3"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "display_data",
          "data": {
            "text/plain": [
              "  0%|          | 0/50 [00:00<?, ?it/s]"
            ],
            "application/vnd.jupyter.widget-view+json": {
              "version_major": 2,
              "version_minor": 0,
              "model_id": "eaa18c65fae54b8aa69bfeedfbf026dc"
            }
          },
          "metadata": {}
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "no_filler_words_list[:5] #keeping only useful words in review"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "5A8Q5SikJhTj",
        "outputId": "eaf5e216-d3a2-43d3-a3eb-9cc8db73d0b9"
      },
      "execution_count": 15,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "[['Great'],\n",
              " ['Cute', 'comfy', '!'],\n",
              " ['Hermosos'],\n",
              " ['Shoes', 'great'],\n",
              " ['Adorable']]"
            ]
          },
          "metadata": {},
          "execution_count": 15
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "from collections import Counter\n",
        "import matplotlib.pyplot as plt\n",
        "\n",
        "#make a list of negative words\n",
        "\n",
        "negative_words=[\"flaw\", 'flawed', 'tight', 'narrow', 'small', 'durable', 'cost', 'durability', 'lasted', 'failed','stains' , 'arch','wore']\n",
        "negative_words_solutions=[\"Replace the Flawed Component\",\\\n",
        "                          \"Replace the Flawed Component\",\\\n",
        "                          \"Make the Front of shoe wider\",\\\n",
        "                          \"Make the Front and Back of shoe wider\",\\\n",
        "                          \"Change the material of shoe cover and sole to sweatproof and waterproof higher quality matrial\",\\\n",
        "                          \"Give a free replacement if shoe gets worn out within 2 years of purchase, and use better quality covering for shoes\",\\\n",
        "                          \"Change the material of shoe to a more durable one\",\\\n",
        "                          \"Give an extra pair of laces in shoe pack if it fails\",\\\n",
        "                          \"Dip the shoe in a protective gel coating during production to keep it long lasting against tough stains\",\\\n",
        "                          \"Make the arch wider\",\\\n",
        "                          \"Dip the shoe in a protective gel coating during production to keep it long lasting against wear and tear\"]\n",
        "\n",
        "#the appearances of negative words in the list:no_filler_words_list\n",
        "\n",
        "recurrences_of_negative_words=[]\n",
        "\n",
        "for i in no_filler_words_list:\n",
        "  n=len(i)\n",
        "  for j in range (0,n):\n",
        "    for k in negative_words:\n",
        "      if(i[j]==k):\n",
        "        recurrences_of_negative_words.append(k)\n",
        "\n",
        "#sort the negative word recurences from highest to lowest \n",
        "\n",
        "from collections import Counter\n",
        "recurrences_of_negative_words_sorted=sorted(recurrences_of_negative_words, key=Counter(recurrences_of_negative_words).get, reverse=True) \n",
        "\n",
        "#delete the repeating words in the list\n",
        "\n",
        "delete_repeating = [i for n, i in enumerate(recurrences_of_negative_words_sorted) if i not in recurrences_of_negative_words_sorted[:n]]\n",
        "\n",
        "#pick the top 3 common problems\n",
        "\n",
        "main_product_problems=delete_repeating[:3]\n",
        "\n",
        "#Display the solutions to those main 3 issues\n",
        "\n",
        "list_of_idxs=[]\n",
        "for i in main_product_problems:\n",
        "  for j in negative_words:\n",
        "    if i==j:\n",
        "      index = negative_words.index(i)\n",
        "      list_of_idxs.append(index)\n",
        "\n",
        "print(\"The 3 main categories of issues are\",main_product_problems )\n",
        "\n",
        "print(\"The redesign suggestions for each of these issues are as follows:\")\n",
        "\n",
        "for i in list_of_idxs:\n",
        "  print(negative_words_solutions[i])\n",
        "    \n"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "iC4-SIyQ9mt-",
        "outputId": "953d0ed3-108e-4c04-d205-1fd69af52c02"
      },
      "execution_count": 17,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "The 3 main categories of issues are ['durable', 'narrow', 'small']\n",
            "The redesign suggestions for each of these issues are as follows:\n",
            "Give a free replacement if shoe gets worn out within 2 years of purchase, and use better quality covering for shoes\n",
            "Make the Front and Back of shoe wider\n",
            "Change the material of shoe cover and sole to sweatproof and waterproof higher quality matrial\n"
          ]
        }
      ]
    }
  ]
}