Create_Combined_Business_and_Review_File.ipynb

{
  "nbformat": 4,
  "nbformat_minor": 0,
  "metadata": {
    "colab": {
      "provenance": [],
      "authorship_tag": "ABX9TyPZRQLRnBA6KuCTU7XCKkzm",
      "include_colab_link": true
    },
    "kernelspec": {
      "name": "python3",
      "display_name": "Python 3"
    },
    "language_info": {
      "name": "python"
    }
  },
  "cells": [
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "view-in-github",
        "colab_type": "text"
      },
      "source": [
        "<a href=\"https://colab.research.google.com/github/EAName/yelp-reviews/blob/main/Create_Combined_Business_and_Review_File.ipynb\" target=\"_parent\"><img src=\"https://colab.research.google.com/assets/colab-badge.svg\" alt=\"Open In Colab\"/></a>"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 13,
      "metadata": {
        "id": "A4cNq1ya5nVW"
      },
      "outputs": [],
      "source": [
        "import pandas as pd\n",
        "import numpy as np\n",
        "import re\n",
        "import string\n",
        "import matplotlib.pyplot as plt\n",
        "import matplotlib as mpl\n",
        "import seaborn as sns\n",
        "import statistics\n",
        "\n",
        "import nltk\n",
        "from nltk.corpus import stopwords\n",
        "from nltk.stem import PorterStemmer\n",
        "from nltk.stem import WordNetLemmatizer\n",
        "from nltk.tokenize import word_tokenize \n"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "nltk.download('stopwords')\n",
        "nltk.download('wordnet')\n",
        "nltk.download('omw-1.4')"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "3xBUrqXw3QM9",
        "outputId": "01a5225d-9572-4c83-a9f6-d453e90437fe"
      },
      "execution_count": 14,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "[nltk_data] Downloading package stopwords to /root/nltk_data...\n",
            "[nltk_data]   Unzipping corpora/stopwords.zip.\n",
            "[nltk_data] Downloading package wordnet to /root/nltk_data...\n",
            "[nltk_data] Downloading package omw-1.4 to /root/nltk_data...\n"
          ]
        },
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "True"
            ]
          },
          "metadata": {},
          "execution_count": 14
        }
      ]
    },
    {
      "cell_type": "markdown",
      "metadata": {
        "id": "kdlCk2h65nVZ"
      },
      "source": [
        "## Mount Google Drive to Colab environment"
      ]
    },
    {
      "cell_type": "code",
      "execution_count": 2,
      "metadata": {
        "id": "3_tETfHF5nVZ",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "71a3c1be-0838-47b1-b75a-091e884228e4"
      },
      "outputs": [
        {
          "output_type": "stream",
          "name": "stdout",
          "text": [
            "Mounted at /content/gdrive\n"
          ]
        }
      ],
      "source": [
        "from google.colab import drive\n",
        "drive.mount('/content/gdrive')"
      ]
    },
    {
      "cell_type": "markdown",
      "source": [
        "## Load Business Dataset"
      ],
      "metadata": {
        "id": "4xyVuMmrm44P"
      }
    },
    {
      "cell_type": "code",
      "source": [
        "df_stlouis =pd.read_csv('/content/gdrive/MyDrive/yelp_dataset/business_df_stlouis.csv')"
      ],
      "metadata": {
        "id": "Dd6K3Rz_m7wy"
      },
      "execution_count": 3,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df_stlouis.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "4wgCbVRom8UX",
        "outputId": "1c5ca7dd-2e9f-4bd7-e02c-41bef5727221"
      },
      "execution_count": 4,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(3181, 69)"
            ]
          },
          "metadata": {},
          "execution_count": 4
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df_stlouis.head()"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 525
        },
        "id": "ptj_XWFlm8WQ",
        "outputId": "3f766147-88fa-434c-e1ea-80ef4ddbd4c2"
      },
      "execution_count": 5,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              business_id                                 name  \\\n",
              "0  k0hlBqXX-Bt0vf1op7Jr1w                Tsevi's Pub And Grill   \n",
              "1  ljxNT9p0y7YMPx0fcNBGig  Tony's Restaurant & 3rd Street Cafe   \n",
              "2  1MeIwdbTnZOBFCKOrgaxuw               Ricardo's Italian Cafe   \n",
              "3  VrGxoSNZfSiT-G4OqRRGIw                     Sunset 44 Bistro   \n",
              "4  wjyUxHxkrvUvCOVqy4g_wg                         Oscar's Cafe   \n",
              "\n",
              "                  address         city state  postal_code   latitude  \\\n",
              "0       8025 Mackenzie Rd       Affton    MO      63123.0  38.565165   \n",
              "1            312 Piasa St        Alton    IL      62002.0  38.896563   \n",
              "2           1931 Park Ave  Saint Louis    MO      63104.0  38.617272   \n",
              "3         118 W Adams Ave  Saint Louis    MO      63122.0  38.583223   \n",
              "4  7520 Natural Bridge Rd     Normandy    MO      63121.0  38.704765   \n",
              "\n",
              "   longitude  stars  review_count  ...  Chicken Wings Sports Bars  \\\n",
              "0 -90.321087    3.0            19  ...              0           0   \n",
              "1 -90.186203    3.0            94  ...              0           0   \n",
              "2 -90.212784    3.5            80  ...              0           0   \n",
              "3 -90.407187    4.0            73  ...              0           0   \n",
              "4 -90.299811    4.0            11  ...              0           0   \n",
              "\n",
              "  JapaneseTotal HasTV_NA  RestaurantsPriceRange2_NA  \\\n",
              "0             0      0.0                        0.0   \n",
              "1             0      0.0                        0.0   \n",
              "2             0      0.0                        0.0   \n",
              "3             0      0.0                        0.0   \n",
              "4             0      1.0                        0.0   \n",
              "\n",
              "   RestaurantsReservations_NA  garage_NA validated_NA  lot_NA  valet_NA  \n",
              "0                         0.0        0.0          0.0     0.0       0.0  \n",
              "1                         0.0        0.0          0.0     0.0       0.0  \n",
              "2                         0.0        0.0          0.0     0.0       0.0  \n",
              "3                         0.0        0.0          0.0     0.0       0.0  \n",
              "4                         1.0        0.0          0.0     0.0       0.0  \n",
              "\n",
              "[5 rows x 69 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-ecb995d8-aa4c-4936-85c5-d5a326d3db4f\">\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>business_id</th>\n",
              "      <th>name</th>\n",
              "      <th>address</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "      <th>postal_code</th>\n",
              "      <th>latitude</th>\n",
              "      <th>longitude</th>\n",
              "      <th>stars</th>\n",
              "      <th>review_count</th>\n",
              "      <th>...</th>\n",
              "      <th>Chicken Wings</th>\n",
              "      <th>Sports Bars</th>\n",
              "      <th>JapaneseTotal</th>\n",
              "      <th>HasTV_NA</th>\n",
              "      <th>RestaurantsPriceRange2_NA</th>\n",
              "      <th>RestaurantsReservations_NA</th>\n",
              "      <th>garage_NA</th>\n",
              "      <th>validated_NA</th>\n",
              "      <th>lot_NA</th>\n",
              "      <th>valet_NA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>k0hlBqXX-Bt0vf1op7Jr1w</td>\n",
              "      <td>Tsevi's Pub And Grill</td>\n",
              "      <td>8025 Mackenzie Rd</td>\n",
              "      <td>Affton</td>\n",
              "      <td>MO</td>\n",
              "      <td>63123.0</td>\n",
              "      <td>38.565165</td>\n",
              "      <td>-90.321087</td>\n",
              "      <td>3.0</td>\n",
              "      <td>19</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>ljxNT9p0y7YMPx0fcNBGig</td>\n",
              "      <td>Tony's Restaurant &amp; 3rd Street Cafe</td>\n",
              "      <td>312 Piasa St</td>\n",
              "      <td>Alton</td>\n",
              "      <td>IL</td>\n",
              "      <td>62002.0</td>\n",
              "      <td>38.896563</td>\n",
              "      <td>-90.186203</td>\n",
              "      <td>3.0</td>\n",
              "      <td>94</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>2</th>\n",
              "      <td>1MeIwdbTnZOBFCKOrgaxuw</td>\n",
              "      <td>Ricardo's Italian Cafe</td>\n",
              "      <td>1931 Park Ave</td>\n",
              "      <td>Saint Louis</td>\n",
              "      <td>MO</td>\n",
              "      <td>63104.0</td>\n",
              "      <td>38.617272</td>\n",
              "      <td>-90.212784</td>\n",
              "      <td>3.5</td>\n",
              "      <td>80</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>3</th>\n",
              "      <td>VrGxoSNZfSiT-G4OqRRGIw</td>\n",
              "      <td>Sunset 44 Bistro</td>\n",
              "      <td>118 W Adams Ave</td>\n",
              "      <td>Saint Louis</td>\n",
              "      <td>MO</td>\n",
              "      <td>63122.0</td>\n",
              "      <td>38.583223</td>\n",
              "      <td>-90.407187</td>\n",
              "      <td>4.0</td>\n",
              "      <td>73</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>4</th>\n",
              "      <td>wjyUxHxkrvUvCOVqy4g_wg</td>\n",
              "      <td>Oscar's Cafe</td>\n",
              "      <td>7520 Natural Bridge Rd</td>\n",
              "      <td>Normandy</td>\n",
              "      <td>MO</td>\n",
              "      <td>63121.0</td>\n",
              "      <td>38.704765</td>\n",
              "      <td>-90.299811</td>\n",
              "      <td>4.0</td>\n",
              "      <td>11</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>5 rows × 69 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-ecb995d8-aa4c-4936-85c5-d5a326d3db4f')\"\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-ecb995d8-aa4c-4936-85c5-d5a326d3db4f 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-ecb995d8-aa4c-4936-85c5-d5a326d3db4f');\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",
      "metadata": {
        "id": "4l7SoL-w5nVa"
      },
      "source": [
        "## Load Reviews Dataset"
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df =pd.read_csv('/content/gdrive/MyDrive/yelp_dataset/yelp_reviews_clean_version4_st_louis.csv')"
      ],
      "metadata": {
        "id": "p2KLuijTcWil"
      },
      "execution_count": 8,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df = df.groupby(['business_id'])['text'].apply(lambda x: ','.join(x)).reset_index()"
      ],
      "metadata": {
        "id": "VFClgfecy16O"
      },
      "execution_count": 9,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "pd.set_option('display.width', None)\n",
        "pd.set_option('display.max_colwidth', -1)"
      ],
      "metadata": {
        "id": "BJBaUViez3Np",
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "outputId": "471ddd80-7564-490f-beb4-38c1eed1cc46"
      },
      "execution_count": 10,
      "outputs": [
        {
          "output_type": "stream",
          "name": "stderr",
          "text": [
            "/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:2: FutureWarning: Passing a negative integer is deprecated in version 1.0 and will not be supported in future version. Instead, use None to not limit the column width.\n",
            "  \n"
          ]
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "df.head(2)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "UikM3hNDy1-Z",
        "outputId": "b9d7a351-65ed-4803-ac62-d72ca0d9e42c"
      },
      "execution_count": 11,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              business_id  \\\n",
              "0  -1wnOZFsvsJPEXh_hWcmMA   \n",
              "1  -2gmbMDzKgYZ_8DOnJtPyw   \n",
              "\n",
              "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          text  \n",
              "0  Tried their chicken adobo tacos tonight. Food looked and tasted fresh. Chicken seasoning was very good. The chips tasted like they were freshly made. Overall it was a wonderful experience. The staff was also super friendly. I'll definitely be back!,Amazing atmosphere only to be outdone by the tasty food. Can't wait for my next meal!,The best burgers in O'Fallon hands down! The Monday special is a fantastic deal. Great staff and family friendly.,Nice clean sports bar.  Had Fish Fry Friday and it was great!!!  New place so come check it out!!!,One of O'fallon's best family friendly neighborhood bar and restaurant. It's nice to have such a gem in the downtown. Prices are very reasonable and whether you are there for a few beers with friends or bringing your kids for a dinner, this place is the perfect. \\n\\nThe food is hand prepared and you can tell they take the time and energy to ensure it's fresh and tasty. Everything is great but a special shout out to the chips and salsa and burgers. Also they have a pretty legit fish fry on Friday's. \\n\\nLastly, whether you are a bud light drinker, prefer the craft brews, or a wino, they have it all.,Just went there for taco Tuesday! They were very busy but still had a few tables available. The way she says were amazing and worked their butts off. Taco plates were only eight dollars each for two shrimp tacos and chips and salsa. They were absolutely delicious this will be my new Tuesday dinner location,Brought my family in for lunch, we got seated and received drinks quickly. Our server was very nice and recommended a couple different items. We ordered and then waited, and waited, and waited. Finally after about 30 min I asked how much longer and did not get an answer. So we waited a few more minutes. Finally our server came over and told us they had moved our ticket up in line and we were next. Unfortunately, after waiting over 45 min the burgers and wraps we had ordered didn't seem worth it. We ended up leaving and never ate. Very disappointing experience.,My boyfriend and I stopped in about 12 am while he was in town working an event.  I have to tell you all the staff were great.  Since our names are Tom and Tracee, we got introduced to the owners who happen to have the same name.  They were very grateful we stopped in.  I also got the opportunity to try St Louis favorite root beer! We had their pizza, which was very delicious! Next time we are in town we will definitely stop by again,Swung in for a quick, late lunch.\\nI was immediately impressed with the crowd in a Monday afternoon.\\nI was under the impression that I would get a cold beer and some so/so bar food.\\nBoy! I was wrong!\\nI asked for a menu and the Bartender asked if I wanted to hear the special.\\nI said \"ok,\" she said \"$5 burger with fries.\" I didn't need the menu any longer.\\nMy drink was then made and was made correctly! (The vodka to soda, to ice, to glass, ratio was perfect!)\\nMy meal arrived as I ordered a second (and final) drink.\\nThe lettuce, tomatoes, pickles, and onions were served on the side. The burger was perfectly grilled as was the bun.\\nThe fries were fresh cut, homemade with skin on!\\nI can't believe this was a $5.00 meal!\\nI will definitely be back!,Was severly dissapointed and underwhelmed. Not a fan of pre-packaged food. My expectations were too high maybe. Portion size was good. Food quality and taste was poor at best...never again. Not even if starving.,Clean and updated bar/restaurant. Great service and great food. Burgers are hand patted and buns are grilled. Delicious! Amber at the bar was fantastic. Fries are fresh cut and plentiful.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  \n",
              "1  Used to be my favorite.  Ate there one hot summer day last year. Not the coolest temp in the dinning area and staff looked a bit over warm too. Got my favorite beef and broccoli which tasted good I thought.  Couple hours later at home got sicker than a dog. ER staff said \"tainted food or lack of sanitation\" caused my vomiting and pain.  They took the name of where I ate but I did not file a report.  I Don't Advise eating there. I will never go there again!    It was not worth a trip to the ER and my stomach \\nBeing pumped out.     BEWARE.,The place had great food. This was the tops as far as what I've experienced in Chinese cuisine in the area. The people were nice and the food was reasonably priced. It was quite busy while my family was there. I recommend it.,This place has typical Chinese dishes. average and not at all outstanding food but even the mediocrity of the food is ruined by the owners attitude towards employees and then in turn from all the employees to the customers. I will never go here again.,I order at 3:44 and they said 40 minutes.  So far it has been an hour and no call.  I called\\nStore and no apology from staff. I was told sorry I wasn't here when you placed your order. \\n???customer service???   Really?  It is now after 5pm and I still don't have my ordered food.  I don't mind waiting, but this is silly.  The place is only a few minutes away.    I would have spent\\nmy money someplace else.  I called and the owner was upset with me.  I just called to cancel the order and he said he could not cancel because I paid with credit card.  REALLY!!!  Customer Service????,The man on the phone was friendly and helped me figure out the best portions for my order.  The delivery was fast and the food was the best I've had around here for your typical Chinese delivery.  This is now my go to Chinese!,Food is mediocre and the guy answering the phone was rude!  I've ordered the same thing a few times and it's always different,Awesome, great, fast delivery, food was fantastic, exactly what I ordered and it was hot (that doesn't always happen other places).  The Chicken Fried Rice was superb and the Crab Rangoon was incredible.  Definitely give this place a try...... I'm sure you'll like it.  Try to remember this is Collinsville, IL and they're trying as hard as they can.,just the kind of cruddy \"chinese food\" american's have come to expect that \"real\" chinese deign not to eat. chinese food in china is great. i feel bad seeing what passes as \"healthy\" chinese food in these parts.\\n\\ni got the snow pea/beef offering. they sure don't skimp on the rice. there was more rice than entree. (in china, you get one small bowl of rice...totaling less than 1/4 bulk of the entree) the beef that was stringy and unchewable was passable. the snow peas were good. the brown sauce of the platter had the consistency of old motor oil.\\n\\nthe egg drop soup came hot in a syrofoam cup. it tasted, well...chemically. i told the counter lady and she countered with \"that's the way we always make it\" and offered another choice.\\n\\nmy choice is to not return.,why is the staff always so angry? the profit margin in Chinese shops is huge. lighten up, both the Chinese and the local staff. bad vibes...,The food is cheaply priced, but always good. The inside could use renovating, but who eats Chinese food inside a restaurant anyways?,We ordered 3 different meals for lunch.  Pineapple Chicken , Pork Egg Foo Young and Cashew Chicken.  Comes with choice of fried rice or white.  Also soup or egg roll or crab Rangoon.  Our meal today was hot and delicious, a huge amount of food for two people.  We heated a plate for supper and it was delicious again.  Everything was great, we've bought many meals from them and never had a bad meal yet.  I ordered it on the Internet for the first time and it was simple to pick up as we were coming home.,Order food for delivery, advised I was in a wheelchair they needed extra time to get to the door. Delivery man left before getting to the door then ask me to come and get my refund from the store, instead of placing it back on my debit card. I spoke with manager he told me I was a idiot and hung up on me. Terrible customer service and will never give this restaurant my business again.,In town on a business trip and my usual go to place Peking Garden was closed for the week. The owners were on vacation. So I decided to give this place a whirl.\\n\\nI had the pork chow mein and a few other side items and they were all really really tasty and I would definitely come here again if Peking Garden is closed. \\n\\nI didn't have a problem with the staff like some other reviews had but they really didn't seem to care and I wasn't expecting much and besides I took my order to go.,This is my go to place for cheap delicious Chinese food. \\n\\nI wish I could talk about their menu in full, but the first time I ate from here I got the mushroom chicken and haven't been tempted to try anything else. I go with the fried rice with decent chunks of chicken giant pieces of halved button mushrooms, crunchy snap peas, carrots, and water chestnuts. All of this is served with soy sauce. My only complaint is the rice is sometimes a bit overcooked/dry but I can over look that. Possibly the real reason I keep coming back is the crab rangoon. With your order you get the choice of a side of crab rangoon or egg rolls. There is nothing unique about the crab rangoon, they just serve it with that golden brown crunchy exterior, and the sweet creamy crab filling you expect. For me they are kinda addictive.\\n\\nThere are 3 ways to get your dose of New China: Dine-In, Delivery, or Take Out. I've never dined in, small dining area with one large table that could probably seat 6, delivery in my experiences has been very slow, so I recommend take out. \\n\\nIt might not be the best Chinese food in the area, but for the portion and the price it works for me.,This all occurred on Monday, the 23 of April. First time ever eating from this restaurant, I had ordered pork fried rice and pot stickers. My mother had ordered Lou mien and crab Rangoon's, my sister had the same. It was all take out, I'm not sure if it was delivered. I thought it was a bit odd because the rice was yellow, I never had yellow rice before. Though I know there are different breads of rice. The rice was a little bland, though the pot stickers and the dipping sauce was very tasteful. Later that night I had decided to eat up the rest of my food to eat. The next day towards the evening, do you know what hit me. Instant throwing up and diarrhea. It takes up to 24 to 48 hours for food poisoning to occur in the body. All three of us were hit with food poisoning, my mother, my sister, and I. Be careful from now on eating from this restaurant, I would really consider it especially if you read all these reviews.,Food is pretty good, I liked it a lot better until I started getting the same delivery guy.  I won't order from there anymore unless I'm picking it up myself.  He is always late, and my food smells horribly of cigarette smoke.  Can't even enjoy it anymore.  It's so bad that I have to leave the bag outside or my house stinks of cigarettes.  It's a shame, I would give it 3-1/2 or 4 if not for that.,This food is AWESOME!  Everytime I order it is on time and fresh and excellent!  The beef and broccolli is outstanding!  Shrimp fried rice and crab rangoon are also excellent.  Delivery drivers are also so nice too!,New China does not honor their coupons. Jerks that work there would rather loose a LOT of business than honor a coupon when I was spending 40 bucks on lunch. There are many other places to eat. They will never get another dime of my money. Worst customer service ever,Only giving 1 star because I cannot give 0.  Called and was put on hold for 5 minutes then hung up on.  When I called back I was asked if I can hold again.  When I told them what happened the girl who answered stated they were too busy, I asked I should call order from somewhere else she said that's up to you and hung up again.  Completely rude and incompetent girl that answers your phones.,New to collinsville and searching for a new Chinese delivery restaurant. This is NOT it.  \\n\\nI had the single most disgusting dish of my life from here.  Chicken chow mein. There was nearly no chicken in the dish.  The vegetables consisted of onion and bok choi with a sliver of celery.  Mainly onion. The flavor was non existent.  Just onion and Barry washed bok choi.  There was no sauce but it came with crunchy noodles.   Seriously gross.  It got tossed.  And I'm not a picky person. \\n\\nThe fried chicken (for my little kids) tasted like it was cooked in dirty grease.  Twice.  \\n\\nThe crab Rangoon had a decent flavor on the inside but again, dirty oil flavor. \\n\\nWe also order beef and broccoli.  That wasn't terrible. The beef was super chewy but the flavor wasn't awful. Tons of broccoli. \\n\\nI'm one and done with this place.  It was so bad I won't bother with another chance.,WARNING....do not order food from here.....haven't gotten food here in a long time. Last time, ordered egg foo yung and the bottom patty was melted into the styrofoam container. Ordered crab stix...bit into one, and it was still wrapped in plastic....NEVER AGAIN,Worst Chinese food I've had in a long time. We ordered from them and they gave us none of the food we actually ordered. Tried to be a good sport and all of the food was TERRIBLE. I called and they said it wasn't their problem. Rude staff. Please do not order from here,Found a hair in my food and was only given half of my money back. One of the people was laughing about me finding a hair in my food.  Tried to contact manager, was told that the two english speaking inviduals there were \"considered managers since the other people working that day didn't speak english\". I asked for the owners name, was given the run around and a fake name, researched on the internet and found out the REAL owner's name. Tried to contact the owner, wrote a letter, no response.,New China on Beltline Rd in Collinsville has good food BUT every time I try to place an order for delivery over the phone something terrible ALWAYS happens. One of two things always happens when you order over the phone, either they take your order wrong and you don't get what you ordered when it arrives at your house or the delivery driver cannot find your address and drives around with your order in his/her car for 30+ minutes. \\n\\nThe worst part about the service here is when they make a mistake the managers never want to fix the problem (this has happened three times now over 2 years) and they want to argue with the customers point of view. The managers need to learn that the customer is always right, especially someone who has ordered over 50 times in the last few years. \\n\\nOn my last order when the delivery driver got lost i asked them to remake the food and I would come pick it up because the sweet and sour chicken would be soggy and not good after sitting in the drivers car in the sealed plastic container for over 35 minutes and the manager would not remake the food.\\n\\nSo overall, terrible delivery and even worse managing...,I always get super fresh food here. I've tried others, but I'm always going back here.  I think once maybe I had bad fried rice like maybe the oil was old or something,but I've been going here since it opened and I'm surprised it has low ratings.  It's mostly to go. Personally I don't really like eating there, but my food is always still hot even 30-40 minutes later.  I even think the food is as fresh at lunchtime or dinner.   Plus, love the fact that they deliver to Maryville so I don't have to get out if I'm sick or if there's a foot of snow on the ground.  It's my go to Chinese place.  \\n\\nMy favorites are the General TSO, garlic chicken, broccoli chicken, chicken fried rice and their egg rolls.  Not a fan of their over stuffed crab Rangoon as I like my feeling to be hot and runny they need to fry and more stuff them less.  It's always good and consistent for me.  I'm not expecting high in PF Chang's.  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-a0b397ce-3547-446f-9c8f-8fd78af604b7\">\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>business_id</th>\n",
              "      <th>text</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>-1wnOZFsvsJPEXh_hWcmMA</td>\n",
              "      <td>Tried their chicken adobo tacos tonight. Food looked and tasted fresh. Chicken seasoning was very good. The chips tasted like they were freshly made. Overall it was a wonderful experience. The staff was also super friendly. I'll definitely be back!,Amazing atmosphere only to be outdone by the tasty food. Can't wait for my next meal!,The best burgers in O'Fallon hands down! The Monday special is a fantastic deal. Great staff and family friendly.,Nice clean sports bar.  Had Fish Fry Friday and it was great!!!  New place so come check it out!!!,One of O'fallon's best family friendly neighborhood bar and restaurant. It's nice to have such a gem in the downtown. Prices are very reasonable and whether you are there for a few beers with friends or bringing your kids for a dinner, this place is the perfect. \\n\\nThe food is hand prepared and you can tell they take the time and energy to ensure it's fresh and tasty. Everything is great but a special shout out to the chips and salsa and burgers. Also they have a pretty legit fish fry on Friday's. \\n\\nLastly, whether you are a bud light drinker, prefer the craft brews, or a wino, they have it all.,Just went there for taco Tuesday! They were very busy but still had a few tables available. The way she says were amazing and worked their butts off. Taco plates were only eight dollars each for two shrimp tacos and chips and salsa. They were absolutely delicious this will be my new Tuesday dinner location,Brought my family in for lunch, we got seated and received drinks quickly. Our server was very nice and recommended a couple different items. We ordered and then waited, and waited, and waited. Finally after about 30 min I asked how much longer and did not get an answer. So we waited a few more minutes. Finally our server came over and told us they had moved our ticket up in line and we were next. Unfortunately, after waiting over 45 min the burgers and wraps we had ordered didn't seem worth it. We ended up leaving and never ate. Very disappointing experience.,My boyfriend and I stopped in about 12 am while he was in town working an event.  I have to tell you all the staff were great.  Since our names are Tom and Tracee, we got introduced to the owners who happen to have the same name.  They were very grateful we stopped in.  I also got the opportunity to try St Louis favorite root beer! We had their pizza, which was very delicious! Next time we are in town we will definitely stop by again,Swung in for a quick, late lunch.\\nI was immediately impressed with the crowd in a Monday afternoon.\\nI was under the impression that I would get a cold beer and some so/so bar food.\\nBoy! I was wrong!\\nI asked for a menu and the Bartender asked if I wanted to hear the special.\\nI said \"ok,\" she said \"$5 burger with fries.\" I didn't need the menu any longer.\\nMy drink was then made and was made correctly! (The vodka to soda, to ice, to glass, ratio was perfect!)\\nMy meal arrived as I ordered a second (and final) drink.\\nThe lettuce, tomatoes, pickles, and onions were served on the side. The burger was perfectly grilled as was the bun.\\nThe fries were fresh cut, homemade with skin on!\\nI can't believe this was a $5.00 meal!\\nI will definitely be back!,Was severly dissapointed and underwhelmed. Not a fan of pre-packaged food. My expectations were too high maybe. Portion size was good. Food quality and taste was poor at best...never again. Not even if starving.,Clean and updated bar/restaurant. Great service and great food. Burgers are hand patted and buns are grilled. Delicious! Amber at the bar was fantastic. Fries are fresh cut and plentiful.</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>-2gmbMDzKgYZ_8DOnJtPyw</td>\n",
              "      <td>Used to be my favorite.  Ate there one hot summer day last year. Not the coolest temp in the dinning area and staff looked a bit over warm too. Got my favorite beef and broccoli which tasted good I thought.  Couple hours later at home got sicker than a dog. ER staff said \"tainted food or lack of sanitation\" caused my vomiting and pain.  They took the name of where I ate but I did not file a report.  I Don't Advise eating there. I will never go there again!    It was not worth a trip to the ER and my stomach \\nBeing pumped out.     BEWARE.,The place had great food. This was the tops as far as what I've experienced in Chinese cuisine in the area. The people were nice and the food was reasonably priced. It was quite busy while my family was there. I recommend it.,This place has typical Chinese dishes. average and not at all outstanding food but even the mediocrity of the food is ruined by the owners attitude towards employees and then in turn from all the employees to the customers. I will never go here again.,I order at 3:44 and they said 40 minutes.  So far it has been an hour and no call.  I called\\nStore and no apology from staff. I was told sorry I wasn't here when you placed your order. \\n???customer service???   Really?  It is now after 5pm and I still don't have my ordered food.  I don't mind waiting, but this is silly.  The place is only a few minutes away.    I would have spent\\nmy money someplace else.  I called and the owner was upset with me.  I just called to cancel the order and he said he could not cancel because I paid with credit card.  REALLY!!!  Customer Service????,The man on the phone was friendly and helped me figure out the best portions for my order.  The delivery was fast and the food was the best I've had around here for your typical Chinese delivery.  This is now my go to Chinese!,Food is mediocre and the guy answering the phone was rude!  I've ordered the same thing a few times and it's always different,Awesome, great, fast delivery, food was fantastic, exactly what I ordered and it was hot (that doesn't always happen other places).  The Chicken Fried Rice was superb and the Crab Rangoon was incredible.  Definitely give this place a try...... I'm sure you'll like it.  Try to remember this is Collinsville, IL and they're trying as hard as they can.,just the kind of cruddy \"chinese food\" american's have come to expect that \"real\" chinese deign not to eat. chinese food in china is great. i feel bad seeing what passes as \"healthy\" chinese food in these parts.\\n\\ni got the snow pea/beef offering. they sure don't skimp on the rice. there was more rice than entree. (in china, you get one small bowl of rice...totaling less than 1/4 bulk of the entree) the beef that was stringy and unchewable was passable. the snow peas were good. the brown sauce of the platter had the consistency of old motor oil.\\n\\nthe egg drop soup came hot in a syrofoam cup. it tasted, well...chemically. i told the counter lady and she countered with \"that's the way we always make it\" and offered another choice.\\n\\nmy choice is to not return.,why is the staff always so angry? the profit margin in Chinese shops is huge. lighten up, both the Chinese and the local staff. bad vibes...,The food is cheaply priced, but always good. The inside could use renovating, but who eats Chinese food inside a restaurant anyways?,We ordered 3 different meals for lunch.  Pineapple Chicken , Pork Egg Foo Young and Cashew Chicken.  Comes with choice of fried rice or white.  Also soup or egg roll or crab Rangoon.  Our meal today was hot and delicious, a huge amount of food for two people.  We heated a plate for supper and it was delicious again.  Everything was great, we've bought many meals from them and never had a bad meal yet.  I ordered it on the Internet for the first time and it was simple to pick up as we were coming home.,Order food for delivery, advised I was in a wheelchair they needed extra time to get to the door. Delivery man left before getting to the door then ask me to come and get my refund from the store, instead of placing it back on my debit card. I spoke with manager he told me I was a idiot and hung up on me. Terrible customer service and will never give this restaurant my business again.,In town on a business trip and my usual go to place Peking Garden was closed for the week. The owners were on vacation. So I decided to give this place a whirl.\\n\\nI had the pork chow mein and a few other side items and they were all really really tasty and I would definitely come here again if Peking Garden is closed. \\n\\nI didn't have a problem with the staff like some other reviews had but they really didn't seem to care and I wasn't expecting much and besides I took my order to go.,This is my go to place for cheap delicious Chinese food. \\n\\nI wish I could talk about their menu in full, but the first time I ate from here I got the mushroom chicken and haven't been tempted to try anything else. I go with the fried rice with decent chunks of chicken giant pieces of halved button mushrooms, crunchy snap peas, carrots, and water chestnuts. All of this is served with soy sauce. My only complaint is the rice is sometimes a bit overcooked/dry but I can over look that. Possibly the real reason I keep coming back is the crab rangoon. With your order you get the choice of a side of crab rangoon or egg rolls. There is nothing unique about the crab rangoon, they just serve it with that golden brown crunchy exterior, and the sweet creamy crab filling you expect. For me they are kinda addictive.\\n\\nThere are 3 ways to get your dose of New China: Dine-In, Delivery, or Take Out. I've never dined in, small dining area with one large table that could probably seat 6, delivery in my experiences has been very slow, so I recommend take out. \\n\\nIt might not be the best Chinese food in the area, but for the portion and the price it works for me.,This all occurred on Monday, the 23 of April. First time ever eating from this restaurant, I had ordered pork fried rice and pot stickers. My mother had ordered Lou mien and crab Rangoon's, my sister had the same. It was all take out, I'm not sure if it was delivered. I thought it was a bit odd because the rice was yellow, I never had yellow rice before. Though I know there are different breads of rice. The rice was a little bland, though the pot stickers and the dipping sauce was very tasteful. Later that night I had decided to eat up the rest of my food to eat. The next day towards the evening, do you know what hit me. Instant throwing up and diarrhea. It takes up to 24 to 48 hours for food poisoning to occur in the body. All three of us were hit with food poisoning, my mother, my sister, and I. Be careful from now on eating from this restaurant, I would really consider it especially if you read all these reviews.,Food is pretty good, I liked it a lot better until I started getting the same delivery guy.  I won't order from there anymore unless I'm picking it up myself.  He is always late, and my food smells horribly of cigarette smoke.  Can't even enjoy it anymore.  It's so bad that I have to leave the bag outside or my house stinks of cigarettes.  It's a shame, I would give it 3-1/2 or 4 if not for that.,This food is AWESOME!  Everytime I order it is on time and fresh and excellent!  The beef and broccolli is outstanding!  Shrimp fried rice and crab rangoon are also excellent.  Delivery drivers are also so nice too!,New China does not honor their coupons. Jerks that work there would rather loose a LOT of business than honor a coupon when I was spending 40 bucks on lunch. There are many other places to eat. They will never get another dime of my money. Worst customer service ever,Only giving 1 star because I cannot give 0.  Called and was put on hold for 5 minutes then hung up on.  When I called back I was asked if I can hold again.  When I told them what happened the girl who answered stated they were too busy, I asked I should call order from somewhere else she said that's up to you and hung up again.  Completely rude and incompetent girl that answers your phones.,New to collinsville and searching for a new Chinese delivery restaurant. This is NOT it.  \\n\\nI had the single most disgusting dish of my life from here.  Chicken chow mein. There was nearly no chicken in the dish.  The vegetables consisted of onion and bok choi with a sliver of celery.  Mainly onion. The flavor was non existent.  Just onion and Barry washed bok choi.  There was no sauce but it came with crunchy noodles.   Seriously gross.  It got tossed.  And I'm not a picky person. \\n\\nThe fried chicken (for my little kids) tasted like it was cooked in dirty grease.  Twice.  \\n\\nThe crab Rangoon had a decent flavor on the inside but again, dirty oil flavor. \\n\\nWe also order beef and broccoli.  That wasn't terrible. The beef was super chewy but the flavor wasn't awful. Tons of broccoli. \\n\\nI'm one and done with this place.  It was so bad I won't bother with another chance.,WARNING....do not order food from here.....haven't gotten food here in a long time. Last time, ordered egg foo yung and the bottom patty was melted into the styrofoam container. Ordered crab stix...bit into one, and it was still wrapped in plastic....NEVER AGAIN,Worst Chinese food I've had in a long time. We ordered from them and they gave us none of the food we actually ordered. Tried to be a good sport and all of the food was TERRIBLE. I called and they said it wasn't their problem. Rude staff. Please do not order from here,Found a hair in my food and was only given half of my money back. One of the people was laughing about me finding a hair in my food.  Tried to contact manager, was told that the two english speaking inviduals there were \"considered managers since the other people working that day didn't speak english\". I asked for the owners name, was given the run around and a fake name, researched on the internet and found out the REAL owner's name. Tried to contact the owner, wrote a letter, no response.,New China on Beltline Rd in Collinsville has good food BUT every time I try to place an order for delivery over the phone something terrible ALWAYS happens. One of two things always happens when you order over the phone, either they take your order wrong and you don't get what you ordered when it arrives at your house or the delivery driver cannot find your address and drives around with your order in his/her car for 30+ minutes. \\n\\nThe worst part about the service here is when they make a mistake the managers never want to fix the problem (this has happened three times now over 2 years) and they want to argue with the customers point of view. The managers need to learn that the customer is always right, especially someone who has ordered over 50 times in the last few years. \\n\\nOn my last order when the delivery driver got lost i asked them to remake the food and I would come pick it up because the sweet and sour chicken would be soggy and not good after sitting in the drivers car in the sealed plastic container for over 35 minutes and the manager would not remake the food.\\n\\nSo overall, terrible delivery and even worse managing...,I always get super fresh food here. I've tried others, but I'm always going back here.  I think once maybe I had bad fried rice like maybe the oil was old or something,but I've been going here since it opened and I'm surprised it has low ratings.  It's mostly to go. Personally I don't really like eating there, but my food is always still hot even 30-40 minutes later.  I even think the food is as fresh at lunchtime or dinner.   Plus, love the fact that they deliver to Maryville so I don't have to get out if I'm sick or if there's a foot of snow on the ground.  It's my go to Chinese place.  \\n\\nMy favorites are the General TSO, garlic chicken, broccoli chicken, chicken fried rice and their egg rolls.  Not a fan of their over stuffed crab Rangoon as I like my feeling to be hot and runny they need to fry and more stuff them less.  It's always good and consistent for me.  I'm not expecting high in PF Chang's.</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-a0b397ce-3547-446f-9c8f-8fd78af604b7')\"\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-a0b397ce-3547-446f-9c8f-8fd78af604b7 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-a0b397ce-3547-446f-9c8f-8fd78af604b7');\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": 11
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "def clean_doc(doc): \n",
        "    #split review into individual words\n",
        "    tokens=doc.split()\n",
        "    re_punc = re.compile('[%s]' % re.escape(string.punctuation))\n",
        "    # remove punctuation from each word\n",
        "    tokens = [re_punc.sub('', w) for w in tokens]\n",
        "\n",
        "    #word lemmzatization    \n",
        "    lemm = WordNetLemmatizer()\n",
        "    tokens=[lemm.lemmatize(word) for word in tokens]\n",
        "\n",
        "    # remove remaining tokens that are not alphabetic\n",
        "    tokens = [word for word in tokens if word.isalpha()]\n",
        "    # filter out short tokens\n",
        "    tokens = [word for word in tokens if len(word) > 3]\n",
        "    #lowercase all words\n",
        "    tokens = [word.lower() for word in tokens]\n",
        "    # filter out stop words\n",
        "    stop_words = set(stopwords.words('english'))\n",
        "    tokens = [w for w in tokens if not w in stop_words]     \n",
        "\n",
        "    # filter out common words\n",
        "    tokens = [w for w in tokens if not w in ['louis', 'restaurant', 'also', 'youre']] \n",
        "    # # word stemming    \n",
        "    # ps=PorterStemmer()\n",
        "    # tokens=[ps.stem(word) for word in tokens]\n",
        "\n",
        "    return tokens\n",
        "\n",
        "def final_processed_text(doc):\n",
        "    #this is a function to join the processed text back\n",
        "    ' '.join(doc)\n",
        "    return doc"
      ],
      "metadata": {
        "id": "9aA2s_9J1hao"
      },
      "execution_count": 12,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df['cleaned_text'] = df['text'].apply(lambda x: clean_doc(x))\n",
        "\n",
        "final_processed_text = [' '.join(x) for x in df['cleaned_text'].tolist()]\n",
        "df['final_processed_text'] = final_processed_text     #add to dataframe"
      ],
      "metadata": {
        "id": "cFEYh7_b1hc0"
      },
      "execution_count": 15,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "df.head(2)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "OmWMPf4vt4M9",
        "outputId": "1c5a23fb-d458-41b5-a761-f53bf2297042"
      },
      "execution_count": 16,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              business_id  \\\n",
              "0  -1wnOZFsvsJPEXh_hWcmMA   \n",
              "1  -2gmbMDzKgYZ_8DOnJtPyw   \n",
              "\n",
              "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          text  \\\n",
              "0  Tried their chicken adobo tacos tonight. Food looked and tasted fresh. Chicken seasoning was very good. The chips tasted like they were freshly made. Overall it was a wonderful experience. The staff was also super friendly. I'll definitely be back!,Amazing atmosphere only to be outdone by the tasty food. Can't wait for my next meal!,The best burgers in O'Fallon hands down! The Monday special is a fantastic deal. Great staff and family friendly.,Nice clean sports bar.  Had Fish Fry Friday and it was great!!!  New place so come check it out!!!,One of O'fallon's best family friendly neighborhood bar and restaurant. It's nice to have such a gem in the downtown. Prices are very reasonable and whether you are there for a few beers with friends or bringing your kids for a dinner, this place is the perfect. \\n\\nThe food is hand prepared and you can tell they take the time and energy to ensure it's fresh and tasty. Everything is great but a special shout out to the chips and salsa and burgers. Also they have a pretty legit fish fry on Friday's. \\n\\nLastly, whether you are a bud light drinker, prefer the craft brews, or a wino, they have it all.,Just went there for taco Tuesday! They were very busy but still had a few tables available. The way she says were amazing and worked their butts off. Taco plates were only eight dollars each for two shrimp tacos and chips and salsa. They were absolutely delicious this will be my new Tuesday dinner location,Brought my family in for lunch, we got seated and received drinks quickly. Our server was very nice and recommended a couple different items. We ordered and then waited, and waited, and waited. Finally after about 30 min I asked how much longer and did not get an answer. So we waited a few more minutes. Finally our server came over and told us they had moved our ticket up in line and we were next. Unfortunately, after waiting over 45 min the burgers and wraps we had ordered didn't seem worth it. We ended up leaving and never ate. Very disappointing experience.,My boyfriend and I stopped in about 12 am while he was in town working an event.  I have to tell you all the staff were great.  Since our names are Tom and Tracee, we got introduced to the owners who happen to have the same name.  They were very grateful we stopped in.  I also got the opportunity to try St Louis favorite root beer! We had their pizza, which was very delicious! Next time we are in town we will definitely stop by again,Swung in for a quick, late lunch.\\nI was immediately impressed with the crowd in a Monday afternoon.\\nI was under the impression that I would get a cold beer and some so/so bar food.\\nBoy! I was wrong!\\nI asked for a menu and the Bartender asked if I wanted to hear the special.\\nI said \"ok,\" she said \"$5 burger with fries.\" I didn't need the menu any longer.\\nMy drink was then made and was made correctly! (The vodka to soda, to ice, to glass, ratio was perfect!)\\nMy meal arrived as I ordered a second (and final) drink.\\nThe lettuce, tomatoes, pickles, and onions were served on the side. The burger was perfectly grilled as was the bun.\\nThe fries were fresh cut, homemade with skin on!\\nI can't believe this was a $5.00 meal!\\nI will definitely be back!,Was severly dissapointed and underwhelmed. Not a fan of pre-packaged food. My expectations were too high maybe. Portion size was good. Food quality and taste was poor at best...never again. Not even if starving.,Clean and updated bar/restaurant. Great service and great food. Burgers are hand patted and buns are grilled. Delicious! Amber at the bar was fantastic. Fries are fresh cut and plentiful.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   \n",
              "1  Used to be my favorite.  Ate there one hot summer day last year. Not the coolest temp in the dinning area and staff looked a bit over warm too. Got my favorite beef and broccoli which tasted good I thought.  Couple hours later at home got sicker than a dog. ER staff said \"tainted food or lack of sanitation\" caused my vomiting and pain.  They took the name of where I ate but I did not file a report.  I Don't Advise eating there. I will never go there again!    It was not worth a trip to the ER and my stomach \\nBeing pumped out.     BEWARE.,The place had great food. This was the tops as far as what I've experienced in Chinese cuisine in the area. The people were nice and the food was reasonably priced. It was quite busy while my family was there. I recommend it.,This place has typical Chinese dishes. average and not at all outstanding food but even the mediocrity of the food is ruined by the owners attitude towards employees and then in turn from all the employees to the customers. I will never go here again.,I order at 3:44 and they said 40 minutes.  So far it has been an hour and no call.  I called\\nStore and no apology from staff. I was told sorry I wasn't here when you placed your order. \\n???customer service???   Really?  It is now after 5pm and I still don't have my ordered food.  I don't mind waiting, but this is silly.  The place is only a few minutes away.    I would have spent\\nmy money someplace else.  I called and the owner was upset with me.  I just called to cancel the order and he said he could not cancel because I paid with credit card.  REALLY!!!  Customer Service????,The man on the phone was friendly and helped me figure out the best portions for my order.  The delivery was fast and the food was the best I've had around here for your typical Chinese delivery.  This is now my go to Chinese!,Food is mediocre and the guy answering the phone was rude!  I've ordered the same thing a few times and it's always different,Awesome, great, fast delivery, food was fantastic, exactly what I ordered and it was hot (that doesn't always happen other places).  The Chicken Fried Rice was superb and the Crab Rangoon was incredible.  Definitely give this place a try...... I'm sure you'll like it.  Try to remember this is Collinsville, IL and they're trying as hard as they can.,just the kind of cruddy \"chinese food\" american's have come to expect that \"real\" chinese deign not to eat. chinese food in china is great. i feel bad seeing what passes as \"healthy\" chinese food in these parts.\\n\\ni got the snow pea/beef offering. they sure don't skimp on the rice. there was more rice than entree. (in china, you get one small bowl of rice...totaling less than 1/4 bulk of the entree) the beef that was stringy and unchewable was passable. the snow peas were good. the brown sauce of the platter had the consistency of old motor oil.\\n\\nthe egg drop soup came hot in a syrofoam cup. it tasted, well...chemically. i told the counter lady and she countered with \"that's the way we always make it\" and offered another choice.\\n\\nmy choice is to not return.,why is the staff always so angry? the profit margin in Chinese shops is huge. lighten up, both the Chinese and the local staff. bad vibes...,The food is cheaply priced, but always good. The inside could use renovating, but who eats Chinese food inside a restaurant anyways?,We ordered 3 different meals for lunch.  Pineapple Chicken , Pork Egg Foo Young and Cashew Chicken.  Comes with choice of fried rice or white.  Also soup or egg roll or crab Rangoon.  Our meal today was hot and delicious, a huge amount of food for two people.  We heated a plate for supper and it was delicious again.  Everything was great, we've bought many meals from them and never had a bad meal yet.  I ordered it on the Internet for the first time and it was simple to pick up as we were coming home.,Order food for delivery, advised I was in a wheelchair they needed extra time to get to the door. Delivery man left before getting to the door then ask me to come and get my refund from the store, instead of placing it back on my debit card. I spoke with manager he told me I was a idiot and hung up on me. Terrible customer service and will never give this restaurant my business again.,In town on a business trip and my usual go to place Peking Garden was closed for the week. The owners were on vacation. So I decided to give this place a whirl.\\n\\nI had the pork chow mein and a few other side items and they were all really really tasty and I would definitely come here again if Peking Garden is closed. \\n\\nI didn't have a problem with the staff like some other reviews had but they really didn't seem to care and I wasn't expecting much and besides I took my order to go.,This is my go to place for cheap delicious Chinese food. \\n\\nI wish I could talk about their menu in full, but the first time I ate from here I got the mushroom chicken and haven't been tempted to try anything else. I go with the fried rice with decent chunks of chicken giant pieces of halved button mushrooms, crunchy snap peas, carrots, and water chestnuts. All of this is served with soy sauce. My only complaint is the rice is sometimes a bit overcooked/dry but I can over look that. Possibly the real reason I keep coming back is the crab rangoon. With your order you get the choice of a side of crab rangoon or egg rolls. There is nothing unique about the crab rangoon, they just serve it with that golden brown crunchy exterior, and the sweet creamy crab filling you expect. For me they are kinda addictive.\\n\\nThere are 3 ways to get your dose of New China: Dine-In, Delivery, or Take Out. I've never dined in, small dining area with one large table that could probably seat 6, delivery in my experiences has been very slow, so I recommend take out. \\n\\nIt might not be the best Chinese food in the area, but for the portion and the price it works for me.,This all occurred on Monday, the 23 of April. First time ever eating from this restaurant, I had ordered pork fried rice and pot stickers. My mother had ordered Lou mien and crab Rangoon's, my sister had the same. It was all take out, I'm not sure if it was delivered. I thought it was a bit odd because the rice was yellow, I never had yellow rice before. Though I know there are different breads of rice. The rice was a little bland, though the pot stickers and the dipping sauce was very tasteful. Later that night I had decided to eat up the rest of my food to eat. The next day towards the evening, do you know what hit me. Instant throwing up and diarrhea. It takes up to 24 to 48 hours for food poisoning to occur in the body. All three of us were hit with food poisoning, my mother, my sister, and I. Be careful from now on eating from this restaurant, I would really consider it especially if you read all these reviews.,Food is pretty good, I liked it a lot better until I started getting the same delivery guy.  I won't order from there anymore unless I'm picking it up myself.  He is always late, and my food smells horribly of cigarette smoke.  Can't even enjoy it anymore.  It's so bad that I have to leave the bag outside or my house stinks of cigarettes.  It's a shame, I would give it 3-1/2 or 4 if not for that.,This food is AWESOME!  Everytime I order it is on time and fresh and excellent!  The beef and broccolli is outstanding!  Shrimp fried rice and crab rangoon are also excellent.  Delivery drivers are also so nice too!,New China does not honor their coupons. Jerks that work there would rather loose a LOT of business than honor a coupon when I was spending 40 bucks on lunch. There are many other places to eat. They will never get another dime of my money. Worst customer service ever,Only giving 1 star because I cannot give 0.  Called and was put on hold for 5 minutes then hung up on.  When I called back I was asked if I can hold again.  When I told them what happened the girl who answered stated they were too busy, I asked I should call order from somewhere else she said that's up to you and hung up again.  Completely rude and incompetent girl that answers your phones.,New to collinsville and searching for a new Chinese delivery restaurant. This is NOT it.  \\n\\nI had the single most disgusting dish of my life from here.  Chicken chow mein. There was nearly no chicken in the dish.  The vegetables consisted of onion and bok choi with a sliver of celery.  Mainly onion. The flavor was non existent.  Just onion and Barry washed bok choi.  There was no sauce but it came with crunchy noodles.   Seriously gross.  It got tossed.  And I'm not a picky person. \\n\\nThe fried chicken (for my little kids) tasted like it was cooked in dirty grease.  Twice.  \\n\\nThe crab Rangoon had a decent flavor on the inside but again, dirty oil flavor. \\n\\nWe also order beef and broccoli.  That wasn't terrible. The beef was super chewy but the flavor wasn't awful. Tons of broccoli. \\n\\nI'm one and done with this place.  It was so bad I won't bother with another chance.,WARNING....do not order food from here.....haven't gotten food here in a long time. Last time, ordered egg foo yung and the bottom patty was melted into the styrofoam container. Ordered crab stix...bit into one, and it was still wrapped in plastic....NEVER AGAIN,Worst Chinese food I've had in a long time. We ordered from them and they gave us none of the food we actually ordered. Tried to be a good sport and all of the food was TERRIBLE. I called and they said it wasn't their problem. Rude staff. Please do not order from here,Found a hair in my food and was only given half of my money back. One of the people was laughing about me finding a hair in my food.  Tried to contact manager, was told that the two english speaking inviduals there were \"considered managers since the other people working that day didn't speak english\". I asked for the owners name, was given the run around and a fake name, researched on the internet and found out the REAL owner's name. Tried to contact the owner, wrote a letter, no response.,New China on Beltline Rd in Collinsville has good food BUT every time I try to place an order for delivery over the phone something terrible ALWAYS happens. One of two things always happens when you order over the phone, either they take your order wrong and you don't get what you ordered when it arrives at your house or the delivery driver cannot find your address and drives around with your order in his/her car for 30+ minutes. \\n\\nThe worst part about the service here is when they make a mistake the managers never want to fix the problem (this has happened three times now over 2 years) and they want to argue with the customers point of view. The managers need to learn that the customer is always right, especially someone who has ordered over 50 times in the last few years. \\n\\nOn my last order when the delivery driver got lost i asked them to remake the food and I would come pick it up because the sweet and sour chicken would be soggy and not good after sitting in the drivers car in the sealed plastic container for over 35 minutes and the manager would not remake the food.\\n\\nSo overall, terrible delivery and even worse managing...,I always get super fresh food here. I've tried others, but I'm always going back here.  I think once maybe I had bad fried rice like maybe the oil was old or something,but I've been going here since it opened and I'm surprised it has low ratings.  It's mostly to go. Personally I don't really like eating there, but my food is always still hot even 30-40 minutes later.  I even think the food is as fresh at lunchtime or dinner.   Plus, love the fact that they deliver to Maryville so I don't have to get out if I'm sick or if there's a foot of snow on the ground.  It's my go to Chinese place.  \\n\\nMy favorites are the General TSO, garlic chicken, broccoli chicken, chicken fried rice and their egg rolls.  Not a fan of their over stuffed crab Rangoon as I like my feeling to be hot and runny they need to fry and more stuff them less.  It's always good and consistent for me.  I'm not expecting high in PF Chang's.   \n",
              "\n",
              "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          cleaned_text  \\\n",
              "0  [tried, chicken, adobo, taco, tonight, food, looked, tasted, fresh, chicken, seasoning, good, chip, tasted, like, freshly, made, overall, wonderful, experience, staff, super, friendly, definitely, backamazing, atmosphere, outdone, tasty, food, cant, wait, next, mealthe, best, burger, ofallon, hand, monday, special, fantastic, deal, great, staff, family, friendlynice, clean, sport, fish, friday, great, place, come, check, outone, ofallons, best, family, friendly, neighborhood, nice, downtown, prices, reasonable, whether, beer, friend, bringing, dinner, place, perfect, food, hand, prepared, tell, take, time, energy, ensure, fresh, tasty, everything, great, special, shout, chip, salsa, burger, pretty, legit, fish, fridays, lastly, whether, light, drinker, prefer, craft, brew, wino, alljust, ...]   \n",
              "1  [used, favorite, summer, last, year, coolest, temp, dinning, area, staff, looked, warm, favorite, beef, broccoli, tasted, good, thought, couple, hour, later, home, sicker, staff, said, tainted, food, lack, sanitation, caused, vomiting, pain, took, name, file, report, dont, advise, eating, never, worth, trip, stomach, pumped, bewarethe, place, great, food, experienced, chinese, cuisine, area, people, nice, food, reasonably, priced, quite, busy, family, recommend, itthis, place, typical, chinese, dish, average, outstanding, food, even, mediocrity, food, ruined, owner, attitude, towards, employee, turn, employee, customer, never, againi, order, said, minute, hour, call, called, store, apology, staff, told, sorry, wasnt, placed, order, customer, service, really, still, ...]                          \n",
              "\n",
              "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  final_processed_text  \n",
              "0  tried chicken adobo taco tonight food looked tasted fresh chicken seasoning good chip tasted like freshly made overall wonderful experience staff super friendly definitely backamazing atmosphere outdone tasty food cant wait next mealthe best burger ofallon hand monday special fantastic deal great staff family friendlynice clean sport fish friday great place come check outone ofallons best family friendly neighborhood nice downtown prices reasonable whether beer friend bringing dinner place perfect food hand prepared tell take time energy ensure fresh tasty everything great special shout chip salsa burger pretty legit fish fridays lastly whether light drinker prefer craft brew wino alljust went taco tuesday busy still table available amazing worked butt taco plate eight dollar shrimp taco chip salsa absolutely delicious tuesday dinner locationbrought family lunch seated received drink quickly server nice recommended couple different item ordered waited waited waited finally asked much longer answer waited minute finally server came told moved ticket line next unfortunately waiting burger wrap ordered didnt seem worth ended leaving never disappointing experiencemy boyfriend stopped town working event tell staff great since name tracee introduced owner happen name grateful stopped opportunity favorite root beer pizza delicious next time town definitely stop againswung quick late lunch immediately impressed crowd monday afternoon impression would cold beer soso food wrong asked menu bartender asked wanted hear special said said burger didnt need menu longer drink made made correctly vodka soda glass ratio perfect meal arrived ordered second final drink lettuce tomato pickle onion served side burger perfectly grilled fresh homemade skin cant believe meal definitely backwas severly dissapointed underwhelmed prepackaged food expectation high maybe portion size good food quality taste poor bestnever even starvingclean updated barrestaurant great service great food burgers hand patted grilled delicious amber fantastic fries fresh plentiful                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   \n",
              "1  used favorite summer last year coolest temp dinning area staff looked warm favorite beef broccoli tasted good thought couple hour later home sicker staff said tainted food lack sanitation caused vomiting pain took name file report dont advise eating never worth trip stomach pumped bewarethe place great food experienced chinese cuisine area people nice food reasonably priced quite busy family recommend itthis place typical chinese dish average outstanding food even mediocrity food ruined owner attitude towards employee turn employee customer never againi order said minute hour call called store apology staff told sorry wasnt placed order customer service really still dont ordered food dont mind waiting silly place minute away would spent money someplace else called owner upset called cancel order said could cancel paid credit card really customer servicethe phone friendly helped figure best portion order delivery fast food best around typical chinese delivery chinesefood mediocre answering phone rude ordered thing time always differentawesome great fast delivery food fantastic exactly ordered doesnt always happen place chicken fried rice superb crab rangoon incredible definitely give place sure youll like remember collinsville theyre trying hard canjust kind cruddy chinese food american come expect real chinese deign chinese food china great feel seeing pass healthy chinese food part snow peabeef offering sure dont skimp rice rice entree china small bowl ricetotaling bulk entree beef stringy unchewable passable snow good brown sauce platter consistency motor drop soup came syrofoam tasted wellchemically told counter lady countered thats always make offered another choice choice returnwhy staff always angry profit margin chinese shop huge lighten chinese local staff vibesthe food cheaply priced always good inside could renovating eats chinese food inside anywayswe ordered different meal lunch pineapple chicken pork young cashew chicken comes choice fried rice white soup roll crab rangoon meal today delicious huge amount food people heated plate supper delicious everything great weve bought many meal never meal ordered internet first time simple pick coming homeorder food delivery advised wheelchair needed extra time door delivery left getting door come refund store instead placing back debit card spoke manager told idiot hung terrible customer service never give business againin town business trip usual place peking garden closed week owner vacation decided give place whirl pork chow mein side item really really tasty would definitely come peking garden closed didnt problem staff like review really didnt seem care wasnt expecting much besides took order gothis place cheap delicious chinese food wish could talk menu full first time mushroom chicken havent tempted anything else fried rice decent chunk chicken giant piece halved button mushroom crunchy snap carrot water chestnut served sauce complaint rice sometimes overcookeddry look possibly real reason keep coming back crab rangoon order choice side crab rangoon roll nothing unique crab rangoon serve golden brown crunchy exterior sweet creamy crab filling expect kinda addictive dose china dinein delivery take never dined small dining area large table could probably seat delivery experience slow recommend take might best chinese food area portion price work methis occurred monday april first time ever eating ordered pork fried rice sticker mother ordered mien crab rangoons sister take sure delivered thought rice yellow never yellow rice though know different bread rice rice little bland though sticker dipping sauce tasteful later night decided rest food next towards evening know instant throwing diarrhea take hour food poisoning occur body three food poisoning mother sister careful eating would really consider especially read reviewsfood pretty good liked better started getting delivery wont order anymore unless picking always late food smell horribly cigarette smoke cant even enjoy anymore leave outside house stink cigarette shame would give thatthis food awesome everytime order time fresh excellent beef broccolli outstanding shrimp fried rice crab rangoon excellent delivery driver nice toonew china honor coupon jerks work would rather loose business honor coupon spending buck lunch many place never another dime money worst customer service everonly giving star cannot give called hold minute hung called back asked hold told happened girl answered stated busy asked call order somewhere else said thats hung completely rude incompetent girl answer phonesnew collinsville searching chinese delivery single disgusting dish life chicken chow mein nearly chicken dish vegetable consisted onion choi sliver celery mainly onion flavor existent onion barry washed choi sauce came crunchy noodle seriously gross tossed picky person fried chicken little tasted like cooked dirty grease twice crab rangoon decent flavor inside dirty flavor order beef broccoli wasnt terrible beef super chewy flavor wasnt awful tons broccoli done place wont bother another chancewarningdo order food herehavent gotten food long time last time ordered yung bottom patty melted styrofoam container ordered crab stixbit still wrapped plasticnever againworst chinese food long time ordered gave none food actually ordered tried good sport food terrible called said wasnt problem rude staff please order herefound hair food given half money back people laughing finding hair food tried contact manager told english speaking inviduals considered manager since people working didnt speak english asked owner name given around fake name researched internet found real owner name tried contact owner wrote letter responsenew china beltline collinsville good food every time place order delivery phone something terrible always happens thing always happens order phone either take order wrong dont ordered arrives house delivery driver cannot find address drive around order hisher minute worst part service make mistake manager never want problem happened three time year want argue customer point view manager need learn customer always right especially someone ordered time last year last order delivery driver lost asked remake food would come pick sweet sour chicken would soggy good sitting driver sealed plastic container minute manager would remake food overall terrible delivery even worse managingi always super fresh food tried others always going back think maybe fried rice like maybe somethingbut going since opened surprised rating mostly personally dont really like eating food always still even minute later even think food fresh lunchtime dinner plus love fact deliver maryville dont sick foot snow ground chinese place favorite general garlic chicken broccoli chicken chicken fried rice roll stuffed crab rangoon like feeling runny need stuff always good consistent expecting high changs  "
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-fecfbcf0-f612-4fcb-ab85-b2baa9fb4be2\">\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>business_id</th>\n",
              "      <th>text</th>\n",
              "      <th>cleaned_text</th>\n",
              "      <th>final_processed_text</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>-1wnOZFsvsJPEXh_hWcmMA</td>\n",
              "      <td>Tried their chicken adobo tacos tonight. Food looked and tasted fresh. Chicken seasoning was very good. The chips tasted like they were freshly made. Overall it was a wonderful experience. The staff was also super friendly. I'll definitely be back!,Amazing atmosphere only to be outdone by the tasty food. Can't wait for my next meal!,The best burgers in O'Fallon hands down! The Monday special is a fantastic deal. Great staff and family friendly.,Nice clean sports bar.  Had Fish Fry Friday and it was great!!!  New place so come check it out!!!,One of O'fallon's best family friendly neighborhood bar and restaurant. It's nice to have such a gem in the downtown. Prices are very reasonable and whether you are there for a few beers with friends or bringing your kids for a dinner, this place is the perfect. \\n\\nThe food is hand prepared and you can tell they take the time and energy to ensure it's fresh and tasty. Everything is great but a special shout out to the chips and salsa and burgers. Also they have a pretty legit fish fry on Friday's. \\n\\nLastly, whether you are a bud light drinker, prefer the craft brews, or a wino, they have it all.,Just went there for taco Tuesday! They were very busy but still had a few tables available. The way she says were amazing and worked their butts off. Taco plates were only eight dollars each for two shrimp tacos and chips and salsa. They were absolutely delicious this will be my new Tuesday dinner location,Brought my family in for lunch, we got seated and received drinks quickly. Our server was very nice and recommended a couple different items. We ordered and then waited, and waited, and waited. Finally after about 30 min I asked how much longer and did not get an answer. So we waited a few more minutes. Finally our server came over and told us they had moved our ticket up in line and we were next. Unfortunately, after waiting over 45 min the burgers and wraps we had ordered didn't seem worth it. We ended up leaving and never ate. Very disappointing experience.,My boyfriend and I stopped in about 12 am while he was in town working an event.  I have to tell you all the staff were great.  Since our names are Tom and Tracee, we got introduced to the owners who happen to have the same name.  They were very grateful we stopped in.  I also got the opportunity to try St Louis favorite root beer! We had their pizza, which was very delicious! Next time we are in town we will definitely stop by again,Swung in for a quick, late lunch.\\nI was immediately impressed with the crowd in a Monday afternoon.\\nI was under the impression that I would get a cold beer and some so/so bar food.\\nBoy! I was wrong!\\nI asked for a menu and the Bartender asked if I wanted to hear the special.\\nI said \"ok,\" she said \"$5 burger with fries.\" I didn't need the menu any longer.\\nMy drink was then made and was made correctly! (The vodka to soda, to ice, to glass, ratio was perfect!)\\nMy meal arrived as I ordered a second (and final) drink.\\nThe lettuce, tomatoes, pickles, and onions were served on the side. The burger was perfectly grilled as was the bun.\\nThe fries were fresh cut, homemade with skin on!\\nI can't believe this was a $5.00 meal!\\nI will definitely be back!,Was severly dissapointed and underwhelmed. Not a fan of pre-packaged food. My expectations were too high maybe. Portion size was good. Food quality and taste was poor at best...never again. Not even if starving.,Clean and updated bar/restaurant. Great service and great food. Burgers are hand patted and buns are grilled. Delicious! Amber at the bar was fantastic. Fries are fresh cut and plentiful.</td>\n",
              "      <td>[tried, chicken, adobo, taco, tonight, food, looked, tasted, fresh, chicken, seasoning, good, chip, tasted, like, freshly, made, overall, wonderful, experience, staff, super, friendly, definitely, backamazing, atmosphere, outdone, tasty, food, cant, wait, next, mealthe, best, burger, ofallon, hand, monday, special, fantastic, deal, great, staff, family, friendlynice, clean, sport, fish, friday, great, place, come, check, outone, ofallons, best, family, friendly, neighborhood, nice, downtown, prices, reasonable, whether, beer, friend, bringing, dinner, place, perfect, food, hand, prepared, tell, take, time, energy, ensure, fresh, tasty, everything, great, special, shout, chip, salsa, burger, pretty, legit, fish, fridays, lastly, whether, light, drinker, prefer, craft, brew, wino, alljust, ...]</td>\n",
              "      <td>tried chicken adobo taco tonight food looked tasted fresh chicken seasoning good chip tasted like freshly made overall wonderful experience staff super friendly definitely backamazing atmosphere outdone tasty food cant wait next mealthe best burger ofallon hand monday special fantastic deal great staff family friendlynice clean sport fish friday great place come check outone ofallons best family friendly neighborhood nice downtown prices reasonable whether beer friend bringing dinner place perfect food hand prepared tell take time energy ensure fresh tasty everything great special shout chip salsa burger pretty legit fish fridays lastly whether light drinker prefer craft brew wino alljust went taco tuesday busy still table available amazing worked butt taco plate eight dollar shrimp taco chip salsa absolutely delicious tuesday dinner locationbrought family lunch seated received drink quickly server nice recommended couple different item ordered waited waited waited finally asked much longer answer waited minute finally server came told moved ticket line next unfortunately waiting burger wrap ordered didnt seem worth ended leaving never disappointing experiencemy boyfriend stopped town working event tell staff great since name tracee introduced owner happen name grateful stopped opportunity favorite root beer pizza delicious next time town definitely stop againswung quick late lunch immediately impressed crowd monday afternoon impression would cold beer soso food wrong asked menu bartender asked wanted hear special said said burger didnt need menu longer drink made made correctly vodka soda glass ratio perfect meal arrived ordered second final drink lettuce tomato pickle onion served side burger perfectly grilled fresh homemade skin cant believe meal definitely backwas severly dissapointed underwhelmed prepackaged food expectation high maybe portion size good food quality taste poor bestnever even starvingclean updated barrestaurant great service great food burgers hand patted grilled delicious amber fantastic fries fresh plentiful</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>-2gmbMDzKgYZ_8DOnJtPyw</td>\n",
              "      <td>Used to be my favorite.  Ate there one hot summer day last year. Not the coolest temp in the dinning area and staff looked a bit over warm too. Got my favorite beef and broccoli which tasted good I thought.  Couple hours later at home got sicker than a dog. ER staff said \"tainted food or lack of sanitation\" caused my vomiting and pain.  They took the name of where I ate but I did not file a report.  I Don't Advise eating there. I will never go there again!    It was not worth a trip to the ER and my stomach \\nBeing pumped out.     BEWARE.,The place had great food. This was the tops as far as what I've experienced in Chinese cuisine in the area. The people were nice and the food was reasonably priced. It was quite busy while my family was there. I recommend it.,This place has typical Chinese dishes. average and not at all outstanding food but even the mediocrity of the food is ruined by the owners attitude towards employees and then in turn from all the employees to the customers. I will never go here again.,I order at 3:44 and they said 40 minutes.  So far it has been an hour and no call.  I called\\nStore and no apology from staff. I was told sorry I wasn't here when you placed your order. \\n???customer service???   Really?  It is now after 5pm and I still don't have my ordered food.  I don't mind waiting, but this is silly.  The place is only a few minutes away.    I would have spent\\nmy money someplace else.  I called and the owner was upset with me.  I just called to cancel the order and he said he could not cancel because I paid with credit card.  REALLY!!!  Customer Service????,The man on the phone was friendly and helped me figure out the best portions for my order.  The delivery was fast and the food was the best I've had around here for your typical Chinese delivery.  This is now my go to Chinese!,Food is mediocre and the guy answering the phone was rude!  I've ordered the same thing a few times and it's always different,Awesome, great, fast delivery, food was fantastic, exactly what I ordered and it was hot (that doesn't always happen other places).  The Chicken Fried Rice was superb and the Crab Rangoon was incredible.  Definitely give this place a try...... I'm sure you'll like it.  Try to remember this is Collinsville, IL and they're trying as hard as they can.,just the kind of cruddy \"chinese food\" american's have come to expect that \"real\" chinese deign not to eat. chinese food in china is great. i feel bad seeing what passes as \"healthy\" chinese food in these parts.\\n\\ni got the snow pea/beef offering. they sure don't skimp on the rice. there was more rice than entree. (in china, you get one small bowl of rice...totaling less than 1/4 bulk of the entree) the beef that was stringy and unchewable was passable. the snow peas were good. the brown sauce of the platter had the consistency of old motor oil.\\n\\nthe egg drop soup came hot in a syrofoam cup. it tasted, well...chemically. i told the counter lady and she countered with \"that's the way we always make it\" and offered another choice.\\n\\nmy choice is to not return.,why is the staff always so angry? the profit margin in Chinese shops is huge. lighten up, both the Chinese and the local staff. bad vibes...,The food is cheaply priced, but always good. The inside could use renovating, but who eats Chinese food inside a restaurant anyways?,We ordered 3 different meals for lunch.  Pineapple Chicken , Pork Egg Foo Young and Cashew Chicken.  Comes with choice of fried rice or white.  Also soup or egg roll or crab Rangoon.  Our meal today was hot and delicious, a huge amount of food for two people.  We heated a plate for supper and it was delicious again.  Everything was great, we've bought many meals from them and never had a bad meal yet.  I ordered it on the Internet for the first time and it was simple to pick up as we were coming home.,Order food for delivery, advised I was in a wheelchair they needed extra time to get to the door. Delivery man left before getting to the door then ask me to come and get my refund from the store, instead of placing it back on my debit card. I spoke with manager he told me I was a idiot and hung up on me. Terrible customer service and will never give this restaurant my business again.,In town on a business trip and my usual go to place Peking Garden was closed for the week. The owners were on vacation. So I decided to give this place a whirl.\\n\\nI had the pork chow mein and a few other side items and they were all really really tasty and I would definitely come here again if Peking Garden is closed. \\n\\nI didn't have a problem with the staff like some other reviews had but they really didn't seem to care and I wasn't expecting much and besides I took my order to go.,This is my go to place for cheap delicious Chinese food. \\n\\nI wish I could talk about their menu in full, but the first time I ate from here I got the mushroom chicken and haven't been tempted to try anything else. I go with the fried rice with decent chunks of chicken giant pieces of halved button mushrooms, crunchy snap peas, carrots, and water chestnuts. All of this is served with soy sauce. My only complaint is the rice is sometimes a bit overcooked/dry but I can over look that. Possibly the real reason I keep coming back is the crab rangoon. With your order you get the choice of a side of crab rangoon or egg rolls. There is nothing unique about the crab rangoon, they just serve it with that golden brown crunchy exterior, and the sweet creamy crab filling you expect. For me they are kinda addictive.\\n\\nThere are 3 ways to get your dose of New China: Dine-In, Delivery, or Take Out. I've never dined in, small dining area with one large table that could probably seat 6, delivery in my experiences has been very slow, so I recommend take out. \\n\\nIt might not be the best Chinese food in the area, but for the portion and the price it works for me.,This all occurred on Monday, the 23 of April. First time ever eating from this restaurant, I had ordered pork fried rice and pot stickers. My mother had ordered Lou mien and crab Rangoon's, my sister had the same. It was all take out, I'm not sure if it was delivered. I thought it was a bit odd because the rice was yellow, I never had yellow rice before. Though I know there are different breads of rice. The rice was a little bland, though the pot stickers and the dipping sauce was very tasteful. Later that night I had decided to eat up the rest of my food to eat. The next day towards the evening, do you know what hit me. Instant throwing up and diarrhea. It takes up to 24 to 48 hours for food poisoning to occur in the body. All three of us were hit with food poisoning, my mother, my sister, and I. Be careful from now on eating from this restaurant, I would really consider it especially if you read all these reviews.,Food is pretty good, I liked it a lot better until I started getting the same delivery guy.  I won't order from there anymore unless I'm picking it up myself.  He is always late, and my food smells horribly of cigarette smoke.  Can't even enjoy it anymore.  It's so bad that I have to leave the bag outside or my house stinks of cigarettes.  It's a shame, I would give it 3-1/2 or 4 if not for that.,This food is AWESOME!  Everytime I order it is on time and fresh and excellent!  The beef and broccolli is outstanding!  Shrimp fried rice and crab rangoon are also excellent.  Delivery drivers are also so nice too!,New China does not honor their coupons. Jerks that work there would rather loose a LOT of business than honor a coupon when I was spending 40 bucks on lunch. There are many other places to eat. They will never get another dime of my money. Worst customer service ever,Only giving 1 star because I cannot give 0.  Called and was put on hold for 5 minutes then hung up on.  When I called back I was asked if I can hold again.  When I told them what happened the girl who answered stated they were too busy, I asked I should call order from somewhere else she said that's up to you and hung up again.  Completely rude and incompetent girl that answers your phones.,New to collinsville and searching for a new Chinese delivery restaurant. This is NOT it.  \\n\\nI had the single most disgusting dish of my life from here.  Chicken chow mein. There was nearly no chicken in the dish.  The vegetables consisted of onion and bok choi with a sliver of celery.  Mainly onion. The flavor was non existent.  Just onion and Barry washed bok choi.  There was no sauce but it came with crunchy noodles.   Seriously gross.  It got tossed.  And I'm not a picky person. \\n\\nThe fried chicken (for my little kids) tasted like it was cooked in dirty grease.  Twice.  \\n\\nThe crab Rangoon had a decent flavor on the inside but again, dirty oil flavor. \\n\\nWe also order beef and broccoli.  That wasn't terrible. The beef was super chewy but the flavor wasn't awful. Tons of broccoli. \\n\\nI'm one and done with this place.  It was so bad I won't bother with another chance.,WARNING....do not order food from here.....haven't gotten food here in a long time. Last time, ordered egg foo yung and the bottom patty was melted into the styrofoam container. Ordered crab stix...bit into one, and it was still wrapped in plastic....NEVER AGAIN,Worst Chinese food I've had in a long time. We ordered from them and they gave us none of the food we actually ordered. Tried to be a good sport and all of the food was TERRIBLE. I called and they said it wasn't their problem. Rude staff. Please do not order from here,Found a hair in my food and was only given half of my money back. One of the people was laughing about me finding a hair in my food.  Tried to contact manager, was told that the two english speaking inviduals there were \"considered managers since the other people working that day didn't speak english\". I asked for the owners name, was given the run around and a fake name, researched on the internet and found out the REAL owner's name. Tried to contact the owner, wrote a letter, no response.,New China on Beltline Rd in Collinsville has good food BUT every time I try to place an order for delivery over the phone something terrible ALWAYS happens. One of two things always happens when you order over the phone, either they take your order wrong and you don't get what you ordered when it arrives at your house or the delivery driver cannot find your address and drives around with your order in his/her car for 30+ minutes. \\n\\nThe worst part about the service here is when they make a mistake the managers never want to fix the problem (this has happened three times now over 2 years) and they want to argue with the customers point of view. The managers need to learn that the customer is always right, especially someone who has ordered over 50 times in the last few years. \\n\\nOn my last order when the delivery driver got lost i asked them to remake the food and I would come pick it up because the sweet and sour chicken would be soggy and not good after sitting in the drivers car in the sealed plastic container for over 35 minutes and the manager would not remake the food.\\n\\nSo overall, terrible delivery and even worse managing...,I always get super fresh food here. I've tried others, but I'm always going back here.  I think once maybe I had bad fried rice like maybe the oil was old or something,but I've been going here since it opened and I'm surprised it has low ratings.  It's mostly to go. Personally I don't really like eating there, but my food is always still hot even 30-40 minutes later.  I even think the food is as fresh at lunchtime or dinner.   Plus, love the fact that they deliver to Maryville so I don't have to get out if I'm sick or if there's a foot of snow on the ground.  It's my go to Chinese place.  \\n\\nMy favorites are the General TSO, garlic chicken, broccoli chicken, chicken fried rice and their egg rolls.  Not a fan of their over stuffed crab Rangoon as I like my feeling to be hot and runny they need to fry and more stuff them less.  It's always good and consistent for me.  I'm not expecting high in PF Chang's.</td>\n",
              "      <td>[used, favorite, summer, last, year, coolest, temp, dinning, area, staff, looked, warm, favorite, beef, broccoli, tasted, good, thought, couple, hour, later, home, sicker, staff, said, tainted, food, lack, sanitation, caused, vomiting, pain, took, name, file, report, dont, advise, eating, never, worth, trip, stomach, pumped, bewarethe, place, great, food, experienced, chinese, cuisine, area, people, nice, food, reasonably, priced, quite, busy, family, recommend, itthis, place, typical, chinese, dish, average, outstanding, food, even, mediocrity, food, ruined, owner, attitude, towards, employee, turn, employee, customer, never, againi, order, said, minute, hour, call, called, store, apology, staff, told, sorry, wasnt, placed, order, customer, service, really, still, ...]</td>\n",
              "      <td>used favorite summer last year coolest temp dinning area staff looked warm favorite beef broccoli tasted good thought couple hour later home sicker staff said tainted food lack sanitation caused vomiting pain took name file report dont advise eating never worth trip stomach pumped bewarethe place great food experienced chinese cuisine area people nice food reasonably priced quite busy family recommend itthis place typical chinese dish average outstanding food even mediocrity food ruined owner attitude towards employee turn employee customer never againi order said minute hour call called store apology staff told sorry wasnt placed order customer service really still dont ordered food dont mind waiting silly place minute away would spent money someplace else called owner upset called cancel order said could cancel paid credit card really customer servicethe phone friendly helped figure best portion order delivery fast food best around typical chinese delivery chinesefood mediocre answering phone rude ordered thing time always differentawesome great fast delivery food fantastic exactly ordered doesnt always happen place chicken fried rice superb crab rangoon incredible definitely give place sure youll like remember collinsville theyre trying hard canjust kind cruddy chinese food american come expect real chinese deign chinese food china great feel seeing pass healthy chinese food part snow peabeef offering sure dont skimp rice rice entree china small bowl ricetotaling bulk entree beef stringy unchewable passable snow good brown sauce platter consistency motor drop soup came syrofoam tasted wellchemically told counter lady countered thats always make offered another choice choice returnwhy staff always angry profit margin chinese shop huge lighten chinese local staff vibesthe food cheaply priced always good inside could renovating eats chinese food inside anywayswe ordered different meal lunch pineapple chicken pork young cashew chicken comes choice fried rice white soup roll crab rangoon meal today delicious huge amount food people heated plate supper delicious everything great weve bought many meal never meal ordered internet first time simple pick coming homeorder food delivery advised wheelchair needed extra time door delivery left getting door come refund store instead placing back debit card spoke manager told idiot hung terrible customer service never give business againin town business trip usual place peking garden closed week owner vacation decided give place whirl pork chow mein side item really really tasty would definitely come peking garden closed didnt problem staff like review really didnt seem care wasnt expecting much besides took order gothis place cheap delicious chinese food wish could talk menu full first time mushroom chicken havent tempted anything else fried rice decent chunk chicken giant piece halved button mushroom crunchy snap carrot water chestnut served sauce complaint rice sometimes overcookeddry look possibly real reason keep coming back crab rangoon order choice side crab rangoon roll nothing unique crab rangoon serve golden brown crunchy exterior sweet creamy crab filling expect kinda addictive dose china dinein delivery take never dined small dining area large table could probably seat delivery experience slow recommend take might best chinese food area portion price work methis occurred monday april first time ever eating ordered pork fried rice sticker mother ordered mien crab rangoons sister take sure delivered thought rice yellow never yellow rice though know different bread rice rice little bland though sticker dipping sauce tasteful later night decided rest food next towards evening know instant throwing diarrhea take hour food poisoning occur body three food poisoning mother sister careful eating would really consider especially read reviewsfood pretty good liked better started getting delivery wont order anymore unless picking always late food smell horribly cigarette smoke cant even enjoy anymore leave outside house stink cigarette shame would give thatthis food awesome everytime order time fresh excellent beef broccolli outstanding shrimp fried rice crab rangoon excellent delivery driver nice toonew china honor coupon jerks work would rather loose business honor coupon spending buck lunch many place never another dime money worst customer service everonly giving star cannot give called hold minute hung called back asked hold told happened girl answered stated busy asked call order somewhere else said thats hung completely rude incompetent girl answer phonesnew collinsville searching chinese delivery single disgusting dish life chicken chow mein nearly chicken dish vegetable consisted onion choi sliver celery mainly onion flavor existent onion barry washed choi sauce came crunchy noodle seriously gross tossed picky person fried chicken little tasted like cooked dirty grease twice crab rangoon decent flavor inside dirty flavor order beef broccoli wasnt terrible beef super chewy flavor wasnt awful tons broccoli done place wont bother another chancewarningdo order food herehavent gotten food long time last time ordered yung bottom patty melted styrofoam container ordered crab stixbit still wrapped plasticnever againworst chinese food long time ordered gave none food actually ordered tried good sport food terrible called said wasnt problem rude staff please order herefound hair food given half money back people laughing finding hair food tried contact manager told english speaking inviduals considered manager since people working didnt speak english asked owner name given around fake name researched internet found real owner name tried contact owner wrote letter responsenew china beltline collinsville good food every time place order delivery phone something terrible always happens thing always happens order phone either take order wrong dont ordered arrives house delivery driver cannot find address drive around order hisher minute worst part service make mistake manager never want problem happened three time year want argue customer point view manager need learn customer always right especially someone ordered time last year last order delivery driver lost asked remake food would come pick sweet sour chicken would soggy good sitting driver sealed plastic container minute manager would remake food overall terrible delivery even worse managingi always super fresh food tried others always going back think maybe fried rice like maybe somethingbut going since opened surprised rating mostly personally dont really like eating food always still even minute later even think food fresh lunchtime dinner plus love fact deliver maryville dont sick foot snow ground chinese place favorite general garlic chicken broccoli chicken chicken fried rice roll stuffed crab rangoon like feeling runny need stuff always good consistent expecting high changs</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-fecfbcf0-f612-4fcb-ab85-b2baa9fb4be2')\"\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-fecfbcf0-f612-4fcb-ab85-b2baa9fb4be2 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-fecfbcf0-f612-4fcb-ab85-b2baa9fb4be2');\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": 16
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "combined = pd.merge(df, df_stlouis, on ='business_id')"
      ],
      "metadata": {
        "id": "xKhcQFDj0t3l"
      },
      "execution_count": 17,
      "outputs": []
    },
    {
      "cell_type": "code",
      "source": [
        "combined.head(2)"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/",
          "height": 1000
        },
        "id": "UdlbBD1X1qsj",
        "outputId": "a18a47d9-b8b8-4108-8d89-5907642459db"
      },
      "execution_count": 18,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "              business_id  \\\n",
              "0  -1wnOZFsvsJPEXh_hWcmMA   \n",
              "1  -2gmbMDzKgYZ_8DOnJtPyw   \n",
              "\n",
              "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          text  \\\n",
              "0  Tried their chicken adobo tacos tonight. Food looked and tasted fresh. Chicken seasoning was very good. The chips tasted like they were freshly made. Overall it was a wonderful experience. The staff was also super friendly. I'll definitely be back!,Amazing atmosphere only to be outdone by the tasty food. Can't wait for my next meal!,The best burgers in O'Fallon hands down! The Monday special is a fantastic deal. Great staff and family friendly.,Nice clean sports bar.  Had Fish Fry Friday and it was great!!!  New place so come check it out!!!,One of O'fallon's best family friendly neighborhood bar and restaurant. It's nice to have such a gem in the downtown. Prices are very reasonable and whether you are there for a few beers with friends or bringing your kids for a dinner, this place is the perfect. \\n\\nThe food is hand prepared and you can tell they take the time and energy to ensure it's fresh and tasty. Everything is great but a special shout out to the chips and salsa and burgers. Also they have a pretty legit fish fry on Friday's. \\n\\nLastly, whether you are a bud light drinker, prefer the craft brews, or a wino, they have it all.,Just went there for taco Tuesday! They were very busy but still had a few tables available. The way she says were amazing and worked their butts off. Taco plates were only eight dollars each for two shrimp tacos and chips and salsa. They were absolutely delicious this will be my new Tuesday dinner location,Brought my family in for lunch, we got seated and received drinks quickly. Our server was very nice and recommended a couple different items. We ordered and then waited, and waited, and waited. Finally after about 30 min I asked how much longer and did not get an answer. So we waited a few more minutes. Finally our server came over and told us they had moved our ticket up in line and we were next. Unfortunately, after waiting over 45 min the burgers and wraps we had ordered didn't seem worth it. We ended up leaving and never ate. Very disappointing experience.,My boyfriend and I stopped in about 12 am while he was in town working an event.  I have to tell you all the staff were great.  Since our names are Tom and Tracee, we got introduced to the owners who happen to have the same name.  They were very grateful we stopped in.  I also got the opportunity to try St Louis favorite root beer! We had their pizza, which was very delicious! Next time we are in town we will definitely stop by again,Swung in for a quick, late lunch.\\nI was immediately impressed with the crowd in a Monday afternoon.\\nI was under the impression that I would get a cold beer and some so/so bar food.\\nBoy! I was wrong!\\nI asked for a menu and the Bartender asked if I wanted to hear the special.\\nI said \"ok,\" she said \"$5 burger with fries.\" I didn't need the menu any longer.\\nMy drink was then made and was made correctly! (The vodka to soda, to ice, to glass, ratio was perfect!)\\nMy meal arrived as I ordered a second (and final) drink.\\nThe lettuce, tomatoes, pickles, and onions were served on the side. The burger was perfectly grilled as was the bun.\\nThe fries were fresh cut, homemade with skin on!\\nI can't believe this was a $5.00 meal!\\nI will definitely be back!,Was severly dissapointed and underwhelmed. Not a fan of pre-packaged food. My expectations were too high maybe. Portion size was good. Food quality and taste was poor at best...never again. Not even if starving.,Clean and updated bar/restaurant. Great service and great food. Burgers are hand patted and buns are grilled. Delicious! Amber at the bar was fantastic. Fries are fresh cut and plentiful.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   \n",
              "1  Used to be my favorite.  Ate there one hot summer day last year. Not the coolest temp in the dinning area and staff looked a bit over warm too. Got my favorite beef and broccoli which tasted good I thought.  Couple hours later at home got sicker than a dog. ER staff said \"tainted food or lack of sanitation\" caused my vomiting and pain.  They took the name of where I ate but I did not file a report.  I Don't Advise eating there. I will never go there again!    It was not worth a trip to the ER and my stomach \\nBeing pumped out.     BEWARE.,The place had great food. This was the tops as far as what I've experienced in Chinese cuisine in the area. The people were nice and the food was reasonably priced. It was quite busy while my family was there. I recommend it.,This place has typical Chinese dishes. average and not at all outstanding food but even the mediocrity of the food is ruined by the owners attitude towards employees and then in turn from all the employees to the customers. I will never go here again.,I order at 3:44 and they said 40 minutes.  So far it has been an hour and no call.  I called\\nStore and no apology from staff. I was told sorry I wasn't here when you placed your order. \\n???customer service???   Really?  It is now after 5pm and I still don't have my ordered food.  I don't mind waiting, but this is silly.  The place is only a few minutes away.    I would have spent\\nmy money someplace else.  I called and the owner was upset with me.  I just called to cancel the order and he said he could not cancel because I paid with credit card.  REALLY!!!  Customer Service????,The man on the phone was friendly and helped me figure out the best portions for my order.  The delivery was fast and the food was the best I've had around here for your typical Chinese delivery.  This is now my go to Chinese!,Food is mediocre and the guy answering the phone was rude!  I've ordered the same thing a few times and it's always different,Awesome, great, fast delivery, food was fantastic, exactly what I ordered and it was hot (that doesn't always happen other places).  The Chicken Fried Rice was superb and the Crab Rangoon was incredible.  Definitely give this place a try...... I'm sure you'll like it.  Try to remember this is Collinsville, IL and they're trying as hard as they can.,just the kind of cruddy \"chinese food\" american's have come to expect that \"real\" chinese deign not to eat. chinese food in china is great. i feel bad seeing what passes as \"healthy\" chinese food in these parts.\\n\\ni got the snow pea/beef offering. they sure don't skimp on the rice. there was more rice than entree. (in china, you get one small bowl of rice...totaling less than 1/4 bulk of the entree) the beef that was stringy and unchewable was passable. the snow peas were good. the brown sauce of the platter had the consistency of old motor oil.\\n\\nthe egg drop soup came hot in a syrofoam cup. it tasted, well...chemically. i told the counter lady and she countered with \"that's the way we always make it\" and offered another choice.\\n\\nmy choice is to not return.,why is the staff always so angry? the profit margin in Chinese shops is huge. lighten up, both the Chinese and the local staff. bad vibes...,The food is cheaply priced, but always good. The inside could use renovating, but who eats Chinese food inside a restaurant anyways?,We ordered 3 different meals for lunch.  Pineapple Chicken , Pork Egg Foo Young and Cashew Chicken.  Comes with choice of fried rice or white.  Also soup or egg roll or crab Rangoon.  Our meal today was hot and delicious, a huge amount of food for two people.  We heated a plate for supper and it was delicious again.  Everything was great, we've bought many meals from them and never had a bad meal yet.  I ordered it on the Internet for the first time and it was simple to pick up as we were coming home.,Order food for delivery, advised I was in a wheelchair they needed extra time to get to the door. Delivery man left before getting to the door then ask me to come and get my refund from the store, instead of placing it back on my debit card. I spoke with manager he told me I was a idiot and hung up on me. Terrible customer service and will never give this restaurant my business again.,In town on a business trip and my usual go to place Peking Garden was closed for the week. The owners were on vacation. So I decided to give this place a whirl.\\n\\nI had the pork chow mein and a few other side items and they were all really really tasty and I would definitely come here again if Peking Garden is closed. \\n\\nI didn't have a problem with the staff like some other reviews had but they really didn't seem to care and I wasn't expecting much and besides I took my order to go.,This is my go to place for cheap delicious Chinese food. \\n\\nI wish I could talk about their menu in full, but the first time I ate from here I got the mushroom chicken and haven't been tempted to try anything else. I go with the fried rice with decent chunks of chicken giant pieces of halved button mushrooms, crunchy snap peas, carrots, and water chestnuts. All of this is served with soy sauce. My only complaint is the rice is sometimes a bit overcooked/dry but I can over look that. Possibly the real reason I keep coming back is the crab rangoon. With your order you get the choice of a side of crab rangoon or egg rolls. There is nothing unique about the crab rangoon, they just serve it with that golden brown crunchy exterior, and the sweet creamy crab filling you expect. For me they are kinda addictive.\\n\\nThere are 3 ways to get your dose of New China: Dine-In, Delivery, or Take Out. I've never dined in, small dining area with one large table that could probably seat 6, delivery in my experiences has been very slow, so I recommend take out. \\n\\nIt might not be the best Chinese food in the area, but for the portion and the price it works for me.,This all occurred on Monday, the 23 of April. First time ever eating from this restaurant, I had ordered pork fried rice and pot stickers. My mother had ordered Lou mien and crab Rangoon's, my sister had the same. It was all take out, I'm not sure if it was delivered. I thought it was a bit odd because the rice was yellow, I never had yellow rice before. Though I know there are different breads of rice. The rice was a little bland, though the pot stickers and the dipping sauce was very tasteful. Later that night I had decided to eat up the rest of my food to eat. The next day towards the evening, do you know what hit me. Instant throwing up and diarrhea. It takes up to 24 to 48 hours for food poisoning to occur in the body. All three of us were hit with food poisoning, my mother, my sister, and I. Be careful from now on eating from this restaurant, I would really consider it especially if you read all these reviews.,Food is pretty good, I liked it a lot better until I started getting the same delivery guy.  I won't order from there anymore unless I'm picking it up myself.  He is always late, and my food smells horribly of cigarette smoke.  Can't even enjoy it anymore.  It's so bad that I have to leave the bag outside or my house stinks of cigarettes.  It's a shame, I would give it 3-1/2 or 4 if not for that.,This food is AWESOME!  Everytime I order it is on time and fresh and excellent!  The beef and broccolli is outstanding!  Shrimp fried rice and crab rangoon are also excellent.  Delivery drivers are also so nice too!,New China does not honor their coupons. Jerks that work there would rather loose a LOT of business than honor a coupon when I was spending 40 bucks on lunch. There are many other places to eat. They will never get another dime of my money. Worst customer service ever,Only giving 1 star because I cannot give 0.  Called and was put on hold for 5 minutes then hung up on.  When I called back I was asked if I can hold again.  When I told them what happened the girl who answered stated they were too busy, I asked I should call order from somewhere else she said that's up to you and hung up again.  Completely rude and incompetent girl that answers your phones.,New to collinsville and searching for a new Chinese delivery restaurant. This is NOT it.  \\n\\nI had the single most disgusting dish of my life from here.  Chicken chow mein. There was nearly no chicken in the dish.  The vegetables consisted of onion and bok choi with a sliver of celery.  Mainly onion. The flavor was non existent.  Just onion and Barry washed bok choi.  There was no sauce but it came with crunchy noodles.   Seriously gross.  It got tossed.  And I'm not a picky person. \\n\\nThe fried chicken (for my little kids) tasted like it was cooked in dirty grease.  Twice.  \\n\\nThe crab Rangoon had a decent flavor on the inside but again, dirty oil flavor. \\n\\nWe also order beef and broccoli.  That wasn't terrible. The beef was super chewy but the flavor wasn't awful. Tons of broccoli. \\n\\nI'm one and done with this place.  It was so bad I won't bother with another chance.,WARNING....do not order food from here.....haven't gotten food here in a long time. Last time, ordered egg foo yung and the bottom patty was melted into the styrofoam container. Ordered crab stix...bit into one, and it was still wrapped in plastic....NEVER AGAIN,Worst Chinese food I've had in a long time. We ordered from them and they gave us none of the food we actually ordered. Tried to be a good sport and all of the food was TERRIBLE. I called and they said it wasn't their problem. Rude staff. Please do not order from here,Found a hair in my food and was only given half of my money back. One of the people was laughing about me finding a hair in my food.  Tried to contact manager, was told that the two english speaking inviduals there were \"considered managers since the other people working that day didn't speak english\". I asked for the owners name, was given the run around and a fake name, researched on the internet and found out the REAL owner's name. Tried to contact the owner, wrote a letter, no response.,New China on Beltline Rd in Collinsville has good food BUT every time I try to place an order for delivery over the phone something terrible ALWAYS happens. One of two things always happens when you order over the phone, either they take your order wrong and you don't get what you ordered when it arrives at your house or the delivery driver cannot find your address and drives around with your order in his/her car for 30+ minutes. \\n\\nThe worst part about the service here is when they make a mistake the managers never want to fix the problem (this has happened three times now over 2 years) and they want to argue with the customers point of view. The managers need to learn that the customer is always right, especially someone who has ordered over 50 times in the last few years. \\n\\nOn my last order when the delivery driver got lost i asked them to remake the food and I would come pick it up because the sweet and sour chicken would be soggy and not good after sitting in the drivers car in the sealed plastic container for over 35 minutes and the manager would not remake the food.\\n\\nSo overall, terrible delivery and even worse managing...,I always get super fresh food here. I've tried others, but I'm always going back here.  I think once maybe I had bad fried rice like maybe the oil was old or something,but I've been going here since it opened and I'm surprised it has low ratings.  It's mostly to go. Personally I don't really like eating there, but my food is always still hot even 30-40 minutes later.  I even think the food is as fresh at lunchtime or dinner.   Plus, love the fact that they deliver to Maryville so I don't have to get out if I'm sick or if there's a foot of snow on the ground.  It's my go to Chinese place.  \\n\\nMy favorites are the General TSO, garlic chicken, broccoli chicken, chicken fried rice and their egg rolls.  Not a fan of their over stuffed crab Rangoon as I like my feeling to be hot and runny they need to fry and more stuff them less.  It's always good and consistent for me.  I'm not expecting high in PF Chang's.   \n",
              "\n",
              "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          cleaned_text  \\\n",
              "0  [tried, chicken, adobo, taco, tonight, food, looked, tasted, fresh, chicken, seasoning, good, chip, tasted, like, freshly, made, overall, wonderful, experience, staff, super, friendly, definitely, backamazing, atmosphere, outdone, tasty, food, cant, wait, next, mealthe, best, burger, ofallon, hand, monday, special, fantastic, deal, great, staff, family, friendlynice, clean, sport, fish, friday, great, place, come, check, outone, ofallons, best, family, friendly, neighborhood, nice, downtown, prices, reasonable, whether, beer, friend, bringing, dinner, place, perfect, food, hand, prepared, tell, take, time, energy, ensure, fresh, tasty, everything, great, special, shout, chip, salsa, burger, pretty, legit, fish, fridays, lastly, whether, light, drinker, prefer, craft, brew, wino, alljust, ...]   \n",
              "1  [used, favorite, summer, last, year, coolest, temp, dinning, area, staff, looked, warm, favorite, beef, broccoli, tasted, good, thought, couple, hour, later, home, sicker, staff, said, tainted, food, lack, sanitation, caused, vomiting, pain, took, name, file, report, dont, advise, eating, never, worth, trip, stomach, pumped, bewarethe, place, great, food, experienced, chinese, cuisine, area, people, nice, food, reasonably, priced, quite, busy, family, recommend, itthis, place, typical, chinese, dish, average, outstanding, food, even, mediocrity, food, ruined, owner, attitude, towards, employee, turn, employee, customer, never, againi, order, said, minute, hour, call, called, store, apology, staff, told, sorry, wasnt, placed, order, customer, service, really, still, ...]                          \n",
              "\n",
              "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  final_processed_text  \\\n",
              "0  tried chicken adobo taco tonight food looked tasted fresh chicken seasoning good chip tasted like freshly made overall wonderful experience staff super friendly definitely backamazing atmosphere outdone tasty food cant wait next mealthe best burger ofallon hand monday special fantastic deal great staff family friendlynice clean sport fish friday great place come check outone ofallons best family friendly neighborhood nice downtown prices reasonable whether beer friend bringing dinner place perfect food hand prepared tell take time energy ensure fresh tasty everything great special shout chip salsa burger pretty legit fish fridays lastly whether light drinker prefer craft brew wino alljust went taco tuesday busy still table available amazing worked butt taco plate eight dollar shrimp taco chip salsa absolutely delicious tuesday dinner locationbrought family lunch seated received drink quickly server nice recommended couple different item ordered waited waited waited finally asked much longer answer waited minute finally server came told moved ticket line next unfortunately waiting burger wrap ordered didnt seem worth ended leaving never disappointing experiencemy boyfriend stopped town working event tell staff great since name tracee introduced owner happen name grateful stopped opportunity favorite root beer pizza delicious next time town definitely stop againswung quick late lunch immediately impressed crowd monday afternoon impression would cold beer soso food wrong asked menu bartender asked wanted hear special said said burger didnt need menu longer drink made made correctly vodka soda glass ratio perfect meal arrived ordered second final drink lettuce tomato pickle onion served side burger perfectly grilled fresh homemade skin cant believe meal definitely backwas severly dissapointed underwhelmed prepackaged food expectation high maybe portion size good food quality taste poor bestnever even starvingclean updated barrestaurant great service great food burgers hand patted grilled delicious amber fantastic fries fresh plentiful                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    \n",
              "1  used favorite summer last year coolest temp dinning area staff looked warm favorite beef broccoli tasted good thought couple hour later home sicker staff said tainted food lack sanitation caused vomiting pain took name file report dont advise eating never worth trip stomach pumped bewarethe place great food experienced chinese cuisine area people nice food reasonably priced quite busy family recommend itthis place typical chinese dish average outstanding food even mediocrity food ruined owner attitude towards employee turn employee customer never againi order said minute hour call called store apology staff told sorry wasnt placed order customer service really still dont ordered food dont mind waiting silly place minute away would spent money someplace else called owner upset called cancel order said could cancel paid credit card really customer servicethe phone friendly helped figure best portion order delivery fast food best around typical chinese delivery chinesefood mediocre answering phone rude ordered thing time always differentawesome great fast delivery food fantastic exactly ordered doesnt always happen place chicken fried rice superb crab rangoon incredible definitely give place sure youll like remember collinsville theyre trying hard canjust kind cruddy chinese food american come expect real chinese deign chinese food china great feel seeing pass healthy chinese food part snow peabeef offering sure dont skimp rice rice entree china small bowl ricetotaling bulk entree beef stringy unchewable passable snow good brown sauce platter consistency motor drop soup came syrofoam tasted wellchemically told counter lady countered thats always make offered another choice choice returnwhy staff always angry profit margin chinese shop huge lighten chinese local staff vibesthe food cheaply priced always good inside could renovating eats chinese food inside anywayswe ordered different meal lunch pineapple chicken pork young cashew chicken comes choice fried rice white soup roll crab rangoon meal today delicious huge amount food people heated plate supper delicious everything great weve bought many meal never meal ordered internet first time simple pick coming homeorder food delivery advised wheelchair needed extra time door delivery left getting door come refund store instead placing back debit card spoke manager told idiot hung terrible customer service never give business againin town business trip usual place peking garden closed week owner vacation decided give place whirl pork chow mein side item really really tasty would definitely come peking garden closed didnt problem staff like review really didnt seem care wasnt expecting much besides took order gothis place cheap delicious chinese food wish could talk menu full first time mushroom chicken havent tempted anything else fried rice decent chunk chicken giant piece halved button mushroom crunchy snap carrot water chestnut served sauce complaint rice sometimes overcookeddry look possibly real reason keep coming back crab rangoon order choice side crab rangoon roll nothing unique crab rangoon serve golden brown crunchy exterior sweet creamy crab filling expect kinda addictive dose china dinein delivery take never dined small dining area large table could probably seat delivery experience slow recommend take might best chinese food area portion price work methis occurred monday april first time ever eating ordered pork fried rice sticker mother ordered mien crab rangoons sister take sure delivered thought rice yellow never yellow rice though know different bread rice rice little bland though sticker dipping sauce tasteful later night decided rest food next towards evening know instant throwing diarrhea take hour food poisoning occur body three food poisoning mother sister careful eating would really consider especially read reviewsfood pretty good liked better started getting delivery wont order anymore unless picking always late food smell horribly cigarette smoke cant even enjoy anymore leave outside house stink cigarette shame would give thatthis food awesome everytime order time fresh excellent beef broccolli outstanding shrimp fried rice crab rangoon excellent delivery driver nice toonew china honor coupon jerks work would rather loose business honor coupon spending buck lunch many place never another dime money worst customer service everonly giving star cannot give called hold minute hung called back asked hold told happened girl answered stated busy asked call order somewhere else said thats hung completely rude incompetent girl answer phonesnew collinsville searching chinese delivery single disgusting dish life chicken chow mein nearly chicken dish vegetable consisted onion choi sliver celery mainly onion flavor existent onion barry washed choi sauce came crunchy noodle seriously gross tossed picky person fried chicken little tasted like cooked dirty grease twice crab rangoon decent flavor inside dirty flavor order beef broccoli wasnt terrible beef super chewy flavor wasnt awful tons broccoli done place wont bother another chancewarningdo order food herehavent gotten food long time last time ordered yung bottom patty melted styrofoam container ordered crab stixbit still wrapped plasticnever againworst chinese food long time ordered gave none food actually ordered tried good sport food terrible called said wasnt problem rude staff please order herefound hair food given half money back people laughing finding hair food tried contact manager told english speaking inviduals considered manager since people working didnt speak english asked owner name given around fake name researched internet found real owner name tried contact owner wrote letter responsenew china beltline collinsville good food every time place order delivery phone something terrible always happens thing always happens order phone either take order wrong dont ordered arrives house delivery driver cannot find address drive around order hisher minute worst part service make mistake manager never want problem happened three time year want argue customer point view manager need learn customer always right especially someone ordered time last year last order delivery driver lost asked remake food would come pick sweet sour chicken would soggy good sitting driver sealed plastic container minute manager would remake food overall terrible delivery even worse managingi always super fresh food tried others always going back think maybe fried rice like maybe somethingbut going since opened surprised rating mostly personally dont really like eating food always still even minute later even think food fresh lunchtime dinner plus love fact deliver maryville dont sick foot snow ground chinese place favorite general garlic chicken broccoli chicken chicken fried rice roll stuffed crab rangoon like feeling runny need stuff always good consistent expecting high changs   \n",
              "\n",
              "                name                    address          city state  \\\n",
              "0  1st Street Lounge  119 W 1st St               O'Fallon      IL     \n",
              "1  New China          1099 Belt Line Rd, Unit G  Collinsville  IL     \n",
              "\n",
              "   postal_code   latitude  ...  Chicken Wings  Sports Bars  JapaneseTotal  \\\n",
              "0  62269.0      38.591460  ...  0              0            0               \n",
              "1  62234.0      38.692212  ...  0              0            0               \n",
              "\n",
              "   HasTV_NA RestaurantsPriceRange2_NA RestaurantsReservations_NA garage_NA  \\\n",
              "0  0.0       1.0                       1.0                        1.0        \n",
              "1  0.0       0.0                       0.0                        1.0        \n",
              "\n",
              "   validated_NA  lot_NA  valet_NA  \n",
              "0  1.0           1.0     1.0       \n",
              "1  1.0           1.0     1.0       \n",
              "\n",
              "[2 rows x 72 columns]"
            ],
            "text/html": [
              "\n",
              "  <div id=\"df-b4828d39-8fa8-4d47-a8cf-07c4136bcc3d\">\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>business_id</th>\n",
              "      <th>text</th>\n",
              "      <th>cleaned_text</th>\n",
              "      <th>final_processed_text</th>\n",
              "      <th>name</th>\n",
              "      <th>address</th>\n",
              "      <th>city</th>\n",
              "      <th>state</th>\n",
              "      <th>postal_code</th>\n",
              "      <th>latitude</th>\n",
              "      <th>...</th>\n",
              "      <th>Chicken Wings</th>\n",
              "      <th>Sports Bars</th>\n",
              "      <th>JapaneseTotal</th>\n",
              "      <th>HasTV_NA</th>\n",
              "      <th>RestaurantsPriceRange2_NA</th>\n",
              "      <th>RestaurantsReservations_NA</th>\n",
              "      <th>garage_NA</th>\n",
              "      <th>validated_NA</th>\n",
              "      <th>lot_NA</th>\n",
              "      <th>valet_NA</th>\n",
              "    </tr>\n",
              "  </thead>\n",
              "  <tbody>\n",
              "    <tr>\n",
              "      <th>0</th>\n",
              "      <td>-1wnOZFsvsJPEXh_hWcmMA</td>\n",
              "      <td>Tried their chicken adobo tacos tonight. Food looked and tasted fresh. Chicken seasoning was very good. The chips tasted like they were freshly made. Overall it was a wonderful experience. The staff was also super friendly. I'll definitely be back!,Amazing atmosphere only to be outdone by the tasty food. Can't wait for my next meal!,The best burgers in O'Fallon hands down! The Monday special is a fantastic deal. Great staff and family friendly.,Nice clean sports bar.  Had Fish Fry Friday and it was great!!!  New place so come check it out!!!,One of O'fallon's best family friendly neighborhood bar and restaurant. It's nice to have such a gem in the downtown. Prices are very reasonable and whether you are there for a few beers with friends or bringing your kids for a dinner, this place is the perfect. \\n\\nThe food is hand prepared and you can tell they take the time and energy to ensure it's fresh and tasty. Everything is great but a special shout out to the chips and salsa and burgers. Also they have a pretty legit fish fry on Friday's. \\n\\nLastly, whether you are a bud light drinker, prefer the craft brews, or a wino, they have it all.,Just went there for taco Tuesday! They were very busy but still had a few tables available. The way she says were amazing and worked their butts off. Taco plates were only eight dollars each for two shrimp tacos and chips and salsa. They were absolutely delicious this will be my new Tuesday dinner location,Brought my family in for lunch, we got seated and received drinks quickly. Our server was very nice and recommended a couple different items. We ordered and then waited, and waited, and waited. Finally after about 30 min I asked how much longer and did not get an answer. So we waited a few more minutes. Finally our server came over and told us they had moved our ticket up in line and we were next. Unfortunately, after waiting over 45 min the burgers and wraps we had ordered didn't seem worth it. We ended up leaving and never ate. Very disappointing experience.,My boyfriend and I stopped in about 12 am while he was in town working an event.  I have to tell you all the staff were great.  Since our names are Tom and Tracee, we got introduced to the owners who happen to have the same name.  They were very grateful we stopped in.  I also got the opportunity to try St Louis favorite root beer! We had their pizza, which was very delicious! Next time we are in town we will definitely stop by again,Swung in for a quick, late lunch.\\nI was immediately impressed with the crowd in a Monday afternoon.\\nI was under the impression that I would get a cold beer and some so/so bar food.\\nBoy! I was wrong!\\nI asked for a menu and the Bartender asked if I wanted to hear the special.\\nI said \"ok,\" she said \"$5 burger with fries.\" I didn't need the menu any longer.\\nMy drink was then made and was made correctly! (The vodka to soda, to ice, to glass, ratio was perfect!)\\nMy meal arrived as I ordered a second (and final) drink.\\nThe lettuce, tomatoes, pickles, and onions were served on the side. The burger was perfectly grilled as was the bun.\\nThe fries were fresh cut, homemade with skin on!\\nI can't believe this was a $5.00 meal!\\nI will definitely be back!,Was severly dissapointed and underwhelmed. Not a fan of pre-packaged food. My expectations were too high maybe. Portion size was good. Food quality and taste was poor at best...never again. Not even if starving.,Clean and updated bar/restaurant. Great service and great food. Burgers are hand patted and buns are grilled. Delicious! Amber at the bar was fantastic. Fries are fresh cut and plentiful.</td>\n",
              "      <td>[tried, chicken, adobo, taco, tonight, food, looked, tasted, fresh, chicken, seasoning, good, chip, tasted, like, freshly, made, overall, wonderful, experience, staff, super, friendly, definitely, backamazing, atmosphere, outdone, tasty, food, cant, wait, next, mealthe, best, burger, ofallon, hand, monday, special, fantastic, deal, great, staff, family, friendlynice, clean, sport, fish, friday, great, place, come, check, outone, ofallons, best, family, friendly, neighborhood, nice, downtown, prices, reasonable, whether, beer, friend, bringing, dinner, place, perfect, food, hand, prepared, tell, take, time, energy, ensure, fresh, tasty, everything, great, special, shout, chip, salsa, burger, pretty, legit, fish, fridays, lastly, whether, light, drinker, prefer, craft, brew, wino, alljust, ...]</td>\n",
              "      <td>tried chicken adobo taco tonight food looked tasted fresh chicken seasoning good chip tasted like freshly made overall wonderful experience staff super friendly definitely backamazing atmosphere outdone tasty food cant wait next mealthe best burger ofallon hand monday special fantastic deal great staff family friendlynice clean sport fish friday great place come check outone ofallons best family friendly neighborhood nice downtown prices reasonable whether beer friend bringing dinner place perfect food hand prepared tell take time energy ensure fresh tasty everything great special shout chip salsa burger pretty legit fish fridays lastly whether light drinker prefer craft brew wino alljust went taco tuesday busy still table available amazing worked butt taco plate eight dollar shrimp taco chip salsa absolutely delicious tuesday dinner locationbrought family lunch seated received drink quickly server nice recommended couple different item ordered waited waited waited finally asked much longer answer waited minute finally server came told moved ticket line next unfortunately waiting burger wrap ordered didnt seem worth ended leaving never disappointing experiencemy boyfriend stopped town working event tell staff great since name tracee introduced owner happen name grateful stopped opportunity favorite root beer pizza delicious next time town definitely stop againswung quick late lunch immediately impressed crowd monday afternoon impression would cold beer soso food wrong asked menu bartender asked wanted hear special said said burger didnt need menu longer drink made made correctly vodka soda glass ratio perfect meal arrived ordered second final drink lettuce tomato pickle onion served side burger perfectly grilled fresh homemade skin cant believe meal definitely backwas severly dissapointed underwhelmed prepackaged food expectation high maybe portion size good food quality taste poor bestnever even starvingclean updated barrestaurant great service great food burgers hand patted grilled delicious amber fantastic fries fresh plentiful</td>\n",
              "      <td>1st Street Lounge</td>\n",
              "      <td>119 W 1st St</td>\n",
              "      <td>O'Fallon</td>\n",
              "      <td>IL</td>\n",
              "      <td>62269.0</td>\n",
              "      <td>38.591460</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "    <tr>\n",
              "      <th>1</th>\n",
              "      <td>-2gmbMDzKgYZ_8DOnJtPyw</td>\n",
              "      <td>Used to be my favorite.  Ate there one hot summer day last year. Not the coolest temp in the dinning area and staff looked a bit over warm too. Got my favorite beef and broccoli which tasted good I thought.  Couple hours later at home got sicker than a dog. ER staff said \"tainted food or lack of sanitation\" caused my vomiting and pain.  They took the name of where I ate but I did not file a report.  I Don't Advise eating there. I will never go there again!    It was not worth a trip to the ER and my stomach \\nBeing pumped out.     BEWARE.,The place had great food. This was the tops as far as what I've experienced in Chinese cuisine in the area. The people were nice and the food was reasonably priced. It was quite busy while my family was there. I recommend it.,This place has typical Chinese dishes. average and not at all outstanding food but even the mediocrity of the food is ruined by the owners attitude towards employees and then in turn from all the employees to the customers. I will never go here again.,I order at 3:44 and they said 40 minutes.  So far it has been an hour and no call.  I called\\nStore and no apology from staff. I was told sorry I wasn't here when you placed your order. \\n???customer service???   Really?  It is now after 5pm and I still don't have my ordered food.  I don't mind waiting, but this is silly.  The place is only a few minutes away.    I would have spent\\nmy money someplace else.  I called and the owner was upset with me.  I just called to cancel the order and he said he could not cancel because I paid with credit card.  REALLY!!!  Customer Service????,The man on the phone was friendly and helped me figure out the best portions for my order.  The delivery was fast and the food was the best I've had around here for your typical Chinese delivery.  This is now my go to Chinese!,Food is mediocre and the guy answering the phone was rude!  I've ordered the same thing a few times and it's always different,Awesome, great, fast delivery, food was fantastic, exactly what I ordered and it was hot (that doesn't always happen other places).  The Chicken Fried Rice was superb and the Crab Rangoon was incredible.  Definitely give this place a try...... I'm sure you'll like it.  Try to remember this is Collinsville, IL and they're trying as hard as they can.,just the kind of cruddy \"chinese food\" american's have come to expect that \"real\" chinese deign not to eat. chinese food in china is great. i feel bad seeing what passes as \"healthy\" chinese food in these parts.\\n\\ni got the snow pea/beef offering. they sure don't skimp on the rice. there was more rice than entree. (in china, you get one small bowl of rice...totaling less than 1/4 bulk of the entree) the beef that was stringy and unchewable was passable. the snow peas were good. the brown sauce of the platter had the consistency of old motor oil.\\n\\nthe egg drop soup came hot in a syrofoam cup. it tasted, well...chemically. i told the counter lady and she countered with \"that's the way we always make it\" and offered another choice.\\n\\nmy choice is to not return.,why is the staff always so angry? the profit margin in Chinese shops is huge. lighten up, both the Chinese and the local staff. bad vibes...,The food is cheaply priced, but always good. The inside could use renovating, but who eats Chinese food inside a restaurant anyways?,We ordered 3 different meals for lunch.  Pineapple Chicken , Pork Egg Foo Young and Cashew Chicken.  Comes with choice of fried rice or white.  Also soup or egg roll or crab Rangoon.  Our meal today was hot and delicious, a huge amount of food for two people.  We heated a plate for supper and it was delicious again.  Everything was great, we've bought many meals from them and never had a bad meal yet.  I ordered it on the Internet for the first time and it was simple to pick up as we were coming home.,Order food for delivery, advised I was in a wheelchair they needed extra time to get to the door. Delivery man left before getting to the door then ask me to come and get my refund from the store, instead of placing it back on my debit card. I spoke with manager he told me I was a idiot and hung up on me. Terrible customer service and will never give this restaurant my business again.,In town on a business trip and my usual go to place Peking Garden was closed for the week. The owners were on vacation. So I decided to give this place a whirl.\\n\\nI had the pork chow mein and a few other side items and they were all really really tasty and I would definitely come here again if Peking Garden is closed. \\n\\nI didn't have a problem with the staff like some other reviews had but they really didn't seem to care and I wasn't expecting much and besides I took my order to go.,This is my go to place for cheap delicious Chinese food. \\n\\nI wish I could talk about their menu in full, but the first time I ate from here I got the mushroom chicken and haven't been tempted to try anything else. I go with the fried rice with decent chunks of chicken giant pieces of halved button mushrooms, crunchy snap peas, carrots, and water chestnuts. All of this is served with soy sauce. My only complaint is the rice is sometimes a bit overcooked/dry but I can over look that. Possibly the real reason I keep coming back is the crab rangoon. With your order you get the choice of a side of crab rangoon or egg rolls. There is nothing unique about the crab rangoon, they just serve it with that golden brown crunchy exterior, and the sweet creamy crab filling you expect. For me they are kinda addictive.\\n\\nThere are 3 ways to get your dose of New China: Dine-In, Delivery, or Take Out. I've never dined in, small dining area with one large table that could probably seat 6, delivery in my experiences has been very slow, so I recommend take out. \\n\\nIt might not be the best Chinese food in the area, but for the portion and the price it works for me.,This all occurred on Monday, the 23 of April. First time ever eating from this restaurant, I had ordered pork fried rice and pot stickers. My mother had ordered Lou mien and crab Rangoon's, my sister had the same. It was all take out, I'm not sure if it was delivered. I thought it was a bit odd because the rice was yellow, I never had yellow rice before. Though I know there are different breads of rice. The rice was a little bland, though the pot stickers and the dipping sauce was very tasteful. Later that night I had decided to eat up the rest of my food to eat. The next day towards the evening, do you know what hit me. Instant throwing up and diarrhea. It takes up to 24 to 48 hours for food poisoning to occur in the body. All three of us were hit with food poisoning, my mother, my sister, and I. Be careful from now on eating from this restaurant, I would really consider it especially if you read all these reviews.,Food is pretty good, I liked it a lot better until I started getting the same delivery guy.  I won't order from there anymore unless I'm picking it up myself.  He is always late, and my food smells horribly of cigarette smoke.  Can't even enjoy it anymore.  It's so bad that I have to leave the bag outside or my house stinks of cigarettes.  It's a shame, I would give it 3-1/2 or 4 if not for that.,This food is AWESOME!  Everytime I order it is on time and fresh and excellent!  The beef and broccolli is outstanding!  Shrimp fried rice and crab rangoon are also excellent.  Delivery drivers are also so nice too!,New China does not honor their coupons. Jerks that work there would rather loose a LOT of business than honor a coupon when I was spending 40 bucks on lunch. There are many other places to eat. They will never get another dime of my money. Worst customer service ever,Only giving 1 star because I cannot give 0.  Called and was put on hold for 5 minutes then hung up on.  When I called back I was asked if I can hold again.  When I told them what happened the girl who answered stated they were too busy, I asked I should call order from somewhere else she said that's up to you and hung up again.  Completely rude and incompetent girl that answers your phones.,New to collinsville and searching for a new Chinese delivery restaurant. This is NOT it.  \\n\\nI had the single most disgusting dish of my life from here.  Chicken chow mein. There was nearly no chicken in the dish.  The vegetables consisted of onion and bok choi with a sliver of celery.  Mainly onion. The flavor was non existent.  Just onion and Barry washed bok choi.  There was no sauce but it came with crunchy noodles.   Seriously gross.  It got tossed.  And I'm not a picky person. \\n\\nThe fried chicken (for my little kids) tasted like it was cooked in dirty grease.  Twice.  \\n\\nThe crab Rangoon had a decent flavor on the inside but again, dirty oil flavor. \\n\\nWe also order beef and broccoli.  That wasn't terrible. The beef was super chewy but the flavor wasn't awful. Tons of broccoli. \\n\\nI'm one and done with this place.  It was so bad I won't bother with another chance.,WARNING....do not order food from here.....haven't gotten food here in a long time. Last time, ordered egg foo yung and the bottom patty was melted into the styrofoam container. Ordered crab stix...bit into one, and it was still wrapped in plastic....NEVER AGAIN,Worst Chinese food I've had in a long time. We ordered from them and they gave us none of the food we actually ordered. Tried to be a good sport and all of the food was TERRIBLE. I called and they said it wasn't their problem. Rude staff. Please do not order from here,Found a hair in my food and was only given half of my money back. One of the people was laughing about me finding a hair in my food.  Tried to contact manager, was told that the two english speaking inviduals there were \"considered managers since the other people working that day didn't speak english\". I asked for the owners name, was given the run around and a fake name, researched on the internet and found out the REAL owner's name. Tried to contact the owner, wrote a letter, no response.,New China on Beltline Rd in Collinsville has good food BUT every time I try to place an order for delivery over the phone something terrible ALWAYS happens. One of two things always happens when you order over the phone, either they take your order wrong and you don't get what you ordered when it arrives at your house or the delivery driver cannot find your address and drives around with your order in his/her car for 30+ minutes. \\n\\nThe worst part about the service here is when they make a mistake the managers never want to fix the problem (this has happened three times now over 2 years) and they want to argue with the customers point of view. The managers need to learn that the customer is always right, especially someone who has ordered over 50 times in the last few years. \\n\\nOn my last order when the delivery driver got lost i asked them to remake the food and I would come pick it up because the sweet and sour chicken would be soggy and not good after sitting in the drivers car in the sealed plastic container for over 35 minutes and the manager would not remake the food.\\n\\nSo overall, terrible delivery and even worse managing...,I always get super fresh food here. I've tried others, but I'm always going back here.  I think once maybe I had bad fried rice like maybe the oil was old or something,but I've been going here since it opened and I'm surprised it has low ratings.  It's mostly to go. Personally I don't really like eating there, but my food is always still hot even 30-40 minutes later.  I even think the food is as fresh at lunchtime or dinner.   Plus, love the fact that they deliver to Maryville so I don't have to get out if I'm sick or if there's a foot of snow on the ground.  It's my go to Chinese place.  \\n\\nMy favorites are the General TSO, garlic chicken, broccoli chicken, chicken fried rice and their egg rolls.  Not a fan of their over stuffed crab Rangoon as I like my feeling to be hot and runny they need to fry and more stuff them less.  It's always good and consistent for me.  I'm not expecting high in PF Chang's.</td>\n",
              "      <td>[used, favorite, summer, last, year, coolest, temp, dinning, area, staff, looked, warm, favorite, beef, broccoli, tasted, good, thought, couple, hour, later, home, sicker, staff, said, tainted, food, lack, sanitation, caused, vomiting, pain, took, name, file, report, dont, advise, eating, never, worth, trip, stomach, pumped, bewarethe, place, great, food, experienced, chinese, cuisine, area, people, nice, food, reasonably, priced, quite, busy, family, recommend, itthis, place, typical, chinese, dish, average, outstanding, food, even, mediocrity, food, ruined, owner, attitude, towards, employee, turn, employee, customer, never, againi, order, said, minute, hour, call, called, store, apology, staff, told, sorry, wasnt, placed, order, customer, service, really, still, ...]</td>\n",
              "      <td>used favorite summer last year coolest temp dinning area staff looked warm favorite beef broccoli tasted good thought couple hour later home sicker staff said tainted food lack sanitation caused vomiting pain took name file report dont advise eating never worth trip stomach pumped bewarethe place great food experienced chinese cuisine area people nice food reasonably priced quite busy family recommend itthis place typical chinese dish average outstanding food even mediocrity food ruined owner attitude towards employee turn employee customer never againi order said minute hour call called store apology staff told sorry wasnt placed order customer service really still dont ordered food dont mind waiting silly place minute away would spent money someplace else called owner upset called cancel order said could cancel paid credit card really customer servicethe phone friendly helped figure best portion order delivery fast food best around typical chinese delivery chinesefood mediocre answering phone rude ordered thing time always differentawesome great fast delivery food fantastic exactly ordered doesnt always happen place chicken fried rice superb crab rangoon incredible definitely give place sure youll like remember collinsville theyre trying hard canjust kind cruddy chinese food american come expect real chinese deign chinese food china great feel seeing pass healthy chinese food part snow peabeef offering sure dont skimp rice rice entree china small bowl ricetotaling bulk entree beef stringy unchewable passable snow good brown sauce platter consistency motor drop soup came syrofoam tasted wellchemically told counter lady countered thats always make offered another choice choice returnwhy staff always angry profit margin chinese shop huge lighten chinese local staff vibesthe food cheaply priced always good inside could renovating eats chinese food inside anywayswe ordered different meal lunch pineapple chicken pork young cashew chicken comes choice fried rice white soup roll crab rangoon meal today delicious huge amount food people heated plate supper delicious everything great weve bought many meal never meal ordered internet first time simple pick coming homeorder food delivery advised wheelchair needed extra time door delivery left getting door come refund store instead placing back debit card spoke manager told idiot hung terrible customer service never give business againin town business trip usual place peking garden closed week owner vacation decided give place whirl pork chow mein side item really really tasty would definitely come peking garden closed didnt problem staff like review really didnt seem care wasnt expecting much besides took order gothis place cheap delicious chinese food wish could talk menu full first time mushroom chicken havent tempted anything else fried rice decent chunk chicken giant piece halved button mushroom crunchy snap carrot water chestnut served sauce complaint rice sometimes overcookeddry look possibly real reason keep coming back crab rangoon order choice side crab rangoon roll nothing unique crab rangoon serve golden brown crunchy exterior sweet creamy crab filling expect kinda addictive dose china dinein delivery take never dined small dining area large table could probably seat delivery experience slow recommend take might best chinese food area portion price work methis occurred monday april first time ever eating ordered pork fried rice sticker mother ordered mien crab rangoons sister take sure delivered thought rice yellow never yellow rice though know different bread rice rice little bland though sticker dipping sauce tasteful later night decided rest food next towards evening know instant throwing diarrhea take hour food poisoning occur body three food poisoning mother sister careful eating would really consider especially read reviewsfood pretty good liked better started getting delivery wont order anymore unless picking always late food smell horribly cigarette smoke cant even enjoy anymore leave outside house stink cigarette shame would give thatthis food awesome everytime order time fresh excellent beef broccolli outstanding shrimp fried rice crab rangoon excellent delivery driver nice toonew china honor coupon jerks work would rather loose business honor coupon spending buck lunch many place never another dime money worst customer service everonly giving star cannot give called hold minute hung called back asked hold told happened girl answered stated busy asked call order somewhere else said thats hung completely rude incompetent girl answer phonesnew collinsville searching chinese delivery single disgusting dish life chicken chow mein nearly chicken dish vegetable consisted onion choi sliver celery mainly onion flavor existent onion barry washed choi sauce came crunchy noodle seriously gross tossed picky person fried chicken little tasted like cooked dirty grease twice crab rangoon decent flavor inside dirty flavor order beef broccoli wasnt terrible beef super chewy flavor wasnt awful tons broccoli done place wont bother another chancewarningdo order food herehavent gotten food long time last time ordered yung bottom patty melted styrofoam container ordered crab stixbit still wrapped plasticnever againworst chinese food long time ordered gave none food actually ordered tried good sport food terrible called said wasnt problem rude staff please order herefound hair food given half money back people laughing finding hair food tried contact manager told english speaking inviduals considered manager since people working didnt speak english asked owner name given around fake name researched internet found real owner name tried contact owner wrote letter responsenew china beltline collinsville good food every time place order delivery phone something terrible always happens thing always happens order phone either take order wrong dont ordered arrives house delivery driver cannot find address drive around order hisher minute worst part service make mistake manager never want problem happened three time year want argue customer point view manager need learn customer always right especially someone ordered time last year last order delivery driver lost asked remake food would come pick sweet sour chicken would soggy good sitting driver sealed plastic container minute manager would remake food overall terrible delivery even worse managingi always super fresh food tried others always going back think maybe fried rice like maybe somethingbut going since opened surprised rating mostly personally dont really like eating food always still even minute later even think food fresh lunchtime dinner plus love fact deliver maryville dont sick foot snow ground chinese place favorite general garlic chicken broccoli chicken chicken fried rice roll stuffed crab rangoon like feeling runny need stuff always good consistent expecting high changs</td>\n",
              "      <td>New China</td>\n",
              "      <td>1099 Belt Line Rd, Unit G</td>\n",
              "      <td>Collinsville</td>\n",
              "      <td>IL</td>\n",
              "      <td>62234.0</td>\n",
              "      <td>38.692212</td>\n",
              "      <td>...</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>0.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "      <td>1.0</td>\n",
              "    </tr>\n",
              "  </tbody>\n",
              "</table>\n",
              "<p>2 rows × 72 columns</p>\n",
              "</div>\n",
              "      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-b4828d39-8fa8-4d47-a8cf-07c4136bcc3d')\"\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-b4828d39-8fa8-4d47-a8cf-07c4136bcc3d 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-b4828d39-8fa8-4d47-a8cf-07c4136bcc3d');\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": 18
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "combined.shape"
      ],
      "metadata": {
        "colab": {
          "base_uri": "https://localhost:8080/"
        },
        "id": "VTlugZeg198D",
        "outputId": "d4b93770-893f-4e93-a239-5ae22211a0dd"
      },
      "execution_count": 19,
      "outputs": [
        {
          "output_type": "execute_result",
          "data": {
            "text/plain": [
              "(3181, 72)"
            ]
          },
          "metadata": {},
          "execution_count": 19
        }
      ]
    },
    {
      "cell_type": "code",
      "source": [
        "combined.to_csv('/content/gdrive/MyDrive/yelp_dataset/business_review_combined_version1.csv', index = False)"
      ],
      "metadata": {
        "id": "fLSxZic73hbv"
      },
      "execution_count": 20,
      "outputs": []
    }
  ]
}