EX2_B_21011641_TAT.ipynb

{"cells":[{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"eOZRn_TDoFj4"},"source":["# Ex1 - Filtering and Sorting Data"]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"vnswi-8PoFj7"},"source":["This time we are going to pull data directly from the internet.\n","Special thanks to: https://github.com/justmarkham for sharing the dataset and materials.\n","\n","### Step 1. Import the necessary libraries"]},{"cell_type":"code","execution_count":1,"metadata":{"pycharm":{"name":"#%%\n","is_executing":true},"id":"KuNOBDWRoFj8","executionInfo":{"status":"ok","timestamp":1664086430468,"user_tz":-420,"elapsed":1305,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}}},"outputs":[],"source":["import pandas as pd\n","import numpy as np"]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"2xK1nzvAoFj-"},"source":["### Step 2. Import the dataset from this [address](https://raw.githubusercontent.com/thieu1995/csv-files/main/data/pandas/chipotle.tsv)."]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"i03uFjUxoFj_"},"source":["### Step 3. Assign it to a variable called chipo."]},{"cell_type":"code","execution_count":2,"metadata":{"pycharm":{"name":"#%%\n"},"id":"7rCSHMxuoFj_","executionInfo":{"status":"ok","timestamp":1664086430807,"user_tz":-420,"elapsed":3,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}}},"outputs":[],"source":["data = pd.read_csv('https://raw.githubusercontent.com/thieu1995/csv-files/main/data/pandas/chipotle.tsv', sep='\\t')"]},{"cell_type":"code","source":["data.head(5)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":302},"id":"P0afjfN_n-04","executionInfo":{"status":"ok","timestamp":1664086431893,"user_tz":-420,"elapsed":1089,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"e86922df-63e8-4362-e4f2-25571125f1f6"},"execution_count":3,"outputs":[{"output_type":"execute_result","data":{"text/plain":["   order_id  quantity                              item_name  \\\n","0         1         1           Chips and Fresh Tomato Salsa   \n","1         1         1                                   Izze   \n","2         1         1                       Nantucket Nectar   \n","3         1         1  Chips and Tomatillo-Green Chili Salsa   \n","4         2         2                           Chicken Bowl   \n","\n","                                  choice_description item_price  \n","0                                                NaN     $2.39   \n","1                                       [Clementine]     $3.39   \n","2                                            [Apple]     $3.39   \n","3                                                NaN     $2.39   \n","4  [Tomatillo-Red Chili Salsa (Hot), [Black Beans...    $16.98   "],"text/html":["\n","  <div id=\"df-81582f0a-30f2-415e-ade0-a819f0345b2d\">\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>order_id</th>\n","      <th>quantity</th>\n","      <th>item_name</th>\n","      <th>choice_description</th>\n","      <th>item_price</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>Chips and Fresh Tomato Salsa</td>\n","      <td>NaN</td>\n","      <td>$2.39</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>Izze</td>\n","      <td>[Clementine]</td>\n","      <td>$3.39</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>Nantucket Nectar</td>\n","      <td>[Apple]</td>\n","      <td>$3.39</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>Chips and Tomatillo-Green Chili Salsa</td>\n","      <td>NaN</td>\n","      <td>$2.39</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>Chicken Bowl</td>\n","      <td>[Tomatillo-Red Chili Salsa (Hot), [Black Beans...</td>\n","      <td>$16.98</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-81582f0a-30f2-415e-ade0-a819f0345b2d')\"\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-81582f0a-30f2-415e-ade0-a819f0345b2d 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-81582f0a-30f2-415e-ade0-a819f0345b2d');\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":3}]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"QrVSujdVoFkA"},"source":["### Step 4. How many products cost more than $10.00?"]},{"cell_type":"code","execution_count":4,"metadata":{"pycharm":{"name":"#%%\n"},"id":"R9DzJKjRoFkB","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1664086431894,"user_tz":-420,"elapsed":23,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"097e029d-4ab0-4cdd-b008-9ca0c20e702a"},"outputs":[{"output_type":"stream","name":"stderr","text":["/usr/local/lib/python3.7/dist-packages/ipykernel_launcher.py:4: FutureWarning: The default value of regex will change from True to False in a future version. In addition, single character regular expressions will *not* be treated as literal strings when regex=True.\n","  after removing the cwd from sys.path.\n"]}],"source":["#San pham hon $10.00\n","#Loai bo dau $ va chuyen doi thanh du lieu thich hop\n","\n","data['item_price'] = data['item_price'].str.replace('$','')\n","data['item_price'] = data['item_price'].astype(float)"]},{"cell_type":"code","source":["np.count_nonzero(data.item_price > 10.00)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"XAiJVktdpJNd","executionInfo":{"status":"ok","timestamp":1664086431894,"user_tz":-420,"elapsed":20,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"b57018df-6d02-422b-a7e1-8195971df7ac"},"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["1130"]},"metadata":{},"execution_count":5}]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"uwB1Mzv2oFkB"},"source":["### Step 5. What is the price of each item? \n","###### print a data frame with only two columns item_name and item_price"]},{"cell_type":"code","execution_count":6,"metadata":{"pycharm":{"name":"#%%\n"},"id":"jBMsDNEzoFkC","executionInfo":{"status":"ok","timestamp":1664086431895,"user_tz":-420,"elapsed":19,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}}},"outputs":[],"source":["#Lay min gia mat hang chi cho 1 so luong gia\n","data_1 = data.groupby(by='item_name')[['item_price']].min().reset_index()"]},{"cell_type":"code","source":["data_1"],"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"id":"EOH3mPJQpzTt","executionInfo":{"status":"ok","timestamp":1664086431896,"user_tz":-420,"elapsed":20,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"3aeb2fda-6d5b-4c43-fc5e-e8063422b882"},"execution_count":7,"outputs":[{"output_type":"execute_result","data":{"text/plain":["                                item_name  item_price\n","0                       6 Pack Soft Drink        6.49\n","1                           Barbacoa Bowl        8.69\n","2                        Barbacoa Burrito        8.69\n","3                   Barbacoa Crispy Tacos        8.99\n","4                     Barbacoa Salad Bowl        9.39\n","5                     Barbacoa Soft Tacos        8.99\n","6                           Bottled Water        1.09\n","7                                    Bowl        7.40\n","8                                 Burrito        7.40\n","9                             Canned Soda        1.09\n","10                      Canned Soft Drink        1.25\n","11                          Carnitas Bowl        8.99\n","12                       Carnitas Burrito        8.69\n","13                  Carnitas Crispy Tacos        8.99\n","14                         Carnitas Salad        8.99\n","15                    Carnitas Salad Bowl        9.39\n","16                    Carnitas Soft Tacos        8.99\n","17                           Chicken Bowl        8.19\n","18                        Chicken Burrito        8.19\n","19                   Chicken Crispy Tacos        8.49\n","20                          Chicken Salad        8.19\n","21                     Chicken Salad Bowl        8.75\n","22                     Chicken Soft Tacos        8.49\n","23                                  Chips        1.99\n","24           Chips and Fresh Tomato Salsa        2.29\n","25                    Chips and Guacamole        3.89\n","26      Chips and Mild Fresh Tomato Salsa        3.00\n","27     Chips and Roasted Chili Corn Salsa        2.95\n","28     Chips and Roasted Chili-Corn Salsa        2.39\n","29  Chips and Tomatillo Green Chili Salsa        2.95\n","30    Chips and Tomatillo Red Chili Salsa        2.95\n","31  Chips and Tomatillo-Green Chili Salsa        2.39\n","32    Chips and Tomatillo-Red Chili Salsa        2.39\n","33                           Crispy Tacos        7.40\n","34                                   Izze        3.39\n","35                       Nantucket Nectar        3.39\n","36                                  Salad        7.40\n","37                          Side of Chips        1.69\n","38                             Steak Bowl        8.69\n","39                          Steak Burrito        8.69\n","40                     Steak Crispy Tacos        8.69\n","41                            Steak Salad        8.69\n","42                       Steak Salad Bowl        9.39\n","43                       Steak Soft Tacos        8.99\n","44                            Veggie Bowl        8.49\n","45                         Veggie Burrito        8.49\n","46                    Veggie Crispy Tacos        8.49\n","47                           Veggie Salad        8.49\n","48                      Veggie Salad Bowl        8.75\n","49                      Veggie Soft Tacos        8.49"],"text/html":["\n","  <div id=\"df-914f5f0e-bc79-4911-b0ad-c121937e9ddf\">\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>item_name</th>\n","      <th>item_price</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>6 Pack Soft Drink</td>\n","      <td>6.49</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>Barbacoa Bowl</td>\n","      <td>8.69</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>Barbacoa Burrito</td>\n","      <td>8.69</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>Barbacoa Crispy Tacos</td>\n","      <td>8.99</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>Barbacoa Salad Bowl</td>\n","      <td>9.39</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>Barbacoa Soft Tacos</td>\n","      <td>8.99</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>Bottled Water</td>\n","      <td>1.09</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>Bowl</td>\n","      <td>7.40</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>Burrito</td>\n","      <td>7.40</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>Canned Soda</td>\n","      <td>1.09</td>\n","    </tr>\n","    <tr>\n","      <th>10</th>\n","      <td>Canned Soft Drink</td>\n","      <td>1.25</td>\n","    </tr>\n","    <tr>\n","      <th>11</th>\n","      <td>Carnitas Bowl</td>\n","      <td>8.99</td>\n","    </tr>\n","    <tr>\n","      <th>12</th>\n","      <td>Carnitas Burrito</td>\n","      <td>8.69</td>\n","    </tr>\n","    <tr>\n","      <th>13</th>\n","      <td>Carnitas Crispy Tacos</td>\n","      <td>8.99</td>\n","    </tr>\n","    <tr>\n","      <th>14</th>\n","      <td>Carnitas Salad</td>\n","      <td>8.99</td>\n","    </tr>\n","    <tr>\n","      <th>15</th>\n","      <td>Carnitas Salad Bowl</td>\n","      <td>9.39</td>\n","    </tr>\n","    <tr>\n","      <th>16</th>\n","      <td>Carnitas Soft Tacos</td>\n","      <td>8.99</td>\n","    </tr>\n","    <tr>\n","      <th>17</th>\n","      <td>Chicken Bowl</td>\n","      <td>8.19</td>\n","    </tr>\n","    <tr>\n","      <th>18</th>\n","      <td>Chicken Burrito</td>\n","      <td>8.19</td>\n","    </tr>\n","    <tr>\n","      <th>19</th>\n","      <td>Chicken Crispy Tacos</td>\n","      <td>8.49</td>\n","    </tr>\n","    <tr>\n","      <th>20</th>\n","      <td>Chicken Salad</td>\n","      <td>8.19</td>\n","    </tr>\n","    <tr>\n","      <th>21</th>\n","      <td>Chicken Salad Bowl</td>\n","      <td>8.75</td>\n","    </tr>\n","    <tr>\n","      <th>22</th>\n","      <td>Chicken Soft Tacos</td>\n","      <td>8.49</td>\n","    </tr>\n","    <tr>\n","      <th>23</th>\n","      <td>Chips</td>\n","      <td>1.99</td>\n","    </tr>\n","    <tr>\n","      <th>24</th>\n","      <td>Chips and Fresh Tomato Salsa</td>\n","      <td>2.29</td>\n","    </tr>\n","    <tr>\n","      <th>25</th>\n","      <td>Chips and Guacamole</td>\n","      <td>3.89</td>\n","    </tr>\n","    <tr>\n","      <th>26</th>\n","      <td>Chips and Mild Fresh Tomato Salsa</td>\n","      <td>3.00</td>\n","    </tr>\n","    <tr>\n","      <th>27</th>\n","      <td>Chips and Roasted Chili Corn Salsa</td>\n","      <td>2.95</td>\n","    </tr>\n","    <tr>\n","      <th>28</th>\n","      <td>Chips and Roasted Chili-Corn Salsa</td>\n","      <td>2.39</td>\n","    </tr>\n","    <tr>\n","      <th>29</th>\n","      <td>Chips and Tomatillo Green Chili Salsa</td>\n","      <td>2.95</td>\n","    </tr>\n","    <tr>\n","      <th>30</th>\n","      <td>Chips and Tomatillo Red Chili Salsa</td>\n","      <td>2.95</td>\n","    </tr>\n","    <tr>\n","      <th>31</th>\n","      <td>Chips and Tomatillo-Green Chili Salsa</td>\n","      <td>2.39</td>\n","    </tr>\n","    <tr>\n","      <th>32</th>\n","      <td>Chips and Tomatillo-Red Chili Salsa</td>\n","      <td>2.39</td>\n","    </tr>\n","    <tr>\n","      <th>33</th>\n","      <td>Crispy Tacos</td>\n","      <td>7.40</td>\n","    </tr>\n","    <tr>\n","      <th>34</th>\n","      <td>Izze</td>\n","      <td>3.39</td>\n","    </tr>\n","    <tr>\n","      <th>35</th>\n","      <td>Nantucket Nectar</td>\n","      <td>3.39</td>\n","    </tr>\n","    <tr>\n","      <th>36</th>\n","      <td>Salad</td>\n","      <td>7.40</td>\n","    </tr>\n","    <tr>\n","      <th>37</th>\n","      <td>Side of Chips</td>\n","      <td>1.69</td>\n","    </tr>\n","    <tr>\n","      <th>38</th>\n","      <td>Steak Bowl</td>\n","      <td>8.69</td>\n","    </tr>\n","    <tr>\n","      <th>39</th>\n","      <td>Steak Burrito</td>\n","      <td>8.69</td>\n","    </tr>\n","    <tr>\n","      <th>40</th>\n","      <td>Steak Crispy Tacos</td>\n","      <td>8.69</td>\n","    </tr>\n","    <tr>\n","      <th>41</th>\n","      <td>Steak Salad</td>\n","      <td>8.69</td>\n","    </tr>\n","    <tr>\n","      <th>42</th>\n","      <td>Steak Salad Bowl</td>\n","      <td>9.39</td>\n","    </tr>\n","    <tr>\n","      <th>43</th>\n","      <td>Steak Soft Tacos</td>\n","      <td>8.99</td>\n","    </tr>\n","    <tr>\n","      <th>44</th>\n","      <td>Veggie Bowl</td>\n","      <td>8.49</td>\n","    </tr>\n","    <tr>\n","      <th>45</th>\n","      <td>Veggie Burrito</td>\n","      <td>8.49</td>\n","    </tr>\n","    <tr>\n","      <th>46</th>\n","      <td>Veggie Crispy Tacos</td>\n","      <td>8.49</td>\n","    </tr>\n","    <tr>\n","      <th>47</th>\n","      <td>Veggie Salad</td>\n","      <td>8.49</td>\n","    </tr>\n","    <tr>\n","      <th>48</th>\n","      <td>Veggie Salad Bowl</td>\n","      <td>8.75</td>\n","    </tr>\n","    <tr>\n","      <th>49</th>\n","      <td>Veggie Soft Tacos</td>\n","      <td>8.49</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-914f5f0e-bc79-4911-b0ad-c121937e9ddf')\"\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-914f5f0e-bc79-4911-b0ad-c121937e9ddf 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-914f5f0e-bc79-4911-b0ad-c121937e9ddf');\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":7}]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"gOUSOe6soFkC"},"source":["### Step 6. Sort by the name of the item"]},{"cell_type":"code","execution_count":8,"metadata":{"pycharm":{"name":"#%%\n"},"id":"Kaz9Rxy_oFkC","colab":{"base_uri":"https://localhost:8080/","height":554},"executionInfo":{"status":"ok","timestamp":1664086431897,"user_tz":-420,"elapsed":20,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"280ce407-930b-4420-9e56-74985eedd094"},"outputs":[{"output_type":"execute_result","data":{"text/plain":["      order_id  quantity          item_name  \\\n","0         1360         2  6 Pack Soft Drink   \n","1          148         1  6 Pack Soft Drink   \n","2          749         1  6 Pack Soft Drink   \n","3          754         1  6 Pack Soft Drink   \n","4         1076         1  6 Pack Soft Drink   \n","...        ...       ...                ...   \n","4617       948         1  Veggie Soft Tacos   \n","4618       322         1  Veggie Soft Tacos   \n","4619      1132         1  Veggie Soft Tacos   \n","4620       688         1  Veggie Soft Tacos   \n","4621       567         1  Veggie Soft Tacos   \n","\n","                                     choice_description  item_price  \n","0                                           [Diet Coke]       12.98  \n","1                                           [Diet Coke]        6.49  \n","2                                                [Coke]        6.49  \n","3                                           [Diet Coke]        6.49  \n","4                                                [Coke]        6.49  \n","...                                                 ...         ...  \n","4617  [Roasted Chili Corn Salsa, [Fajita Vegetables,...        8.75  \n","4618  [Fresh Tomato Salsa, [Black Beans, Cheese, Sou...        8.75  \n","4619  [Roasted Chili Corn Salsa (Medium), [Black Bea...        8.49  \n","4620  [Fresh Tomato Salsa, [Fajita Vegetables, Rice,...       11.25  \n","4621  [Fresh Tomato Salsa (Mild), [Pinto Beans, Rice...        8.49  \n","\n","[4622 rows x 5 columns]"],"text/html":["\n","  <div id=\"df-81ff0a08-af28-4b26-9460-60b0335da9bf\">\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>order_id</th>\n","      <th>quantity</th>\n","      <th>item_name</th>\n","      <th>choice_description</th>\n","      <th>item_price</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>1360</td>\n","      <td>2</td>\n","      <td>6 Pack Soft Drink</td>\n","      <td>[Diet Coke]</td>\n","      <td>12.98</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>148</td>\n","      <td>1</td>\n","      <td>6 Pack Soft Drink</td>\n","      <td>[Diet Coke]</td>\n","      <td>6.49</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>749</td>\n","      <td>1</td>\n","      <td>6 Pack Soft Drink</td>\n","      <td>[Coke]</td>\n","      <td>6.49</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>754</td>\n","      <td>1</td>\n","      <td>6 Pack Soft Drink</td>\n","      <td>[Diet Coke]</td>\n","      <td>6.49</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>1076</td>\n","      <td>1</td>\n","      <td>6 Pack Soft Drink</td>\n","      <td>[Coke]</td>\n","      <td>6.49</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>4617</th>\n","      <td>948</td>\n","      <td>1</td>\n","      <td>Veggie Soft Tacos</td>\n","      <td>[Roasted Chili Corn Salsa, [Fajita Vegetables,...</td>\n","      <td>8.75</td>\n","    </tr>\n","    <tr>\n","      <th>4618</th>\n","      <td>322</td>\n","      <td>1</td>\n","      <td>Veggie Soft Tacos</td>\n","      <td>[Fresh Tomato Salsa, [Black Beans, Cheese, Sou...</td>\n","      <td>8.75</td>\n","    </tr>\n","    <tr>\n","      <th>4619</th>\n","      <td>1132</td>\n","      <td>1</td>\n","      <td>Veggie Soft Tacos</td>\n","      <td>[Roasted Chili Corn Salsa (Medium), [Black Bea...</td>\n","      <td>8.49</td>\n","    </tr>\n","    <tr>\n","      <th>4620</th>\n","      <td>688</td>\n","      <td>1</td>\n","      <td>Veggie Soft Tacos</td>\n","      <td>[Fresh Tomato Salsa, [Fajita Vegetables, Rice,...</td>\n","      <td>11.25</td>\n","    </tr>\n","    <tr>\n","      <th>4621</th>\n","      <td>567</td>\n","      <td>1</td>\n","      <td>Veggie Soft Tacos</td>\n","      <td>[Fresh Tomato Salsa (Mild), [Pinto Beans, Rice...</td>\n","      <td>8.49</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>4622 rows × 5 columns</p>\n","</div>\n","      <button class=\"colab-df-convert\" onclick=\"convertToInteractive('df-81ff0a08-af28-4b26-9460-60b0335da9bf')\"\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-81ff0a08-af28-4b26-9460-60b0335da9bf 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-81ff0a08-af28-4b26-9460-60b0335da9bf');\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":8}],"source":["#sort theo ten mat hang\n","data.sort_values(by='item_name', ascending=True).reset_index(drop=True)"]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"_42lYFMboFkC"},"source":["### Step 7. What was the quantity of the most expensive item ordered?"]},{"cell_type":"code","source":["data_2 = np.where(data.item_price == data.item_price.max(), data.quantity, 0)\n"],"metadata":{"id":"hTtEY3-vTDTp","executionInfo":{"status":"ok","timestamp":1664086722133,"user_tz":-420,"elapsed":368,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}}},"execution_count":10,"outputs":[]},{"cell_type":"code","source":["for i in data_2:\n","  if i != 0:\n","    print(\"So luong mat hang Dat nhat dat la : \" ,i)"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"GBi5CCijTEXz","executionInfo":{"status":"ok","timestamp":1664086852036,"user_tz":-420,"elapsed":330,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"3c556a60-492c-4528-929a-c67ab282f5f6"},"execution_count":11,"outputs":[{"output_type":"stream","name":"stdout","text":["So luong mat hang Dat nhat dat la :  15\n"]}]},{"cell_type":"code","source":[],"metadata":{"id":"Wp11JpfqTkwK"},"execution_count":null,"outputs":[]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"IJOr5g8boFkD"},"source":["### Step 8. How many times was a Veggie Salad Bowl ordered?"]},{"cell_type":"code","execution_count":13,"metadata":{"pycharm":{"name":"#%%\n"},"id":"52vE0OzSoFkD","colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"status":"ok","timestamp":1664087107773,"user_tz":-420,"elapsed":547,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"c4f2507e-badc-4f84-b610-6baf3bcf1880"},"outputs":[{"output_type":"stream","name":"stdout","text":["18 lan Veggie Salad Bowl dat hang\n"]}],"source":["data_3 = np.count_nonzero(data.item_name == 'Veggie Salad Bowl')\n","print(data_3,'lan Veggie Salad Bowl dat hang')"]},{"cell_type":"markdown","metadata":{"pycharm":{"name":"#%% md\n"},"id":"PIatPDS_oFkD"},"source":["### Step 9. How many times did someone order more than one Canned Soda?"]},{"cell_type":"code","execution_count":15,"metadata":{"pycharm":{"name":"#%%\n"},"id":"KG6dnTV-oFkD","executionInfo":{"status":"ok","timestamp":1664087175916,"user_tz":-420,"elapsed":5,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}}},"outputs":[],"source":["data_4 = np.count_nonzero((data.item_name == 'Canned Soda') & (data.quantity > 1))"]},{"cell_type":"code","source":["print(data_4,'lan dat hang nhieu hon 1 Canned Soda')"],"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"id":"reBp9bBNUzcW","executionInfo":{"status":"ok","timestamp":1664087231833,"user_tz":-420,"elapsed":336,"user":{"displayName":"Tu Le Hoang Ngoc","userId":"03468960949235735510"}},"outputId":"492e3ff1-ad72-4ca6-d8d1-cbf4f83e0fe4"},"execution_count":16,"outputs":[{"output_type":"stream","name":"stdout","text":["20 lan dat hang nhieu hon 1 Canned Soda\n"]}]},{"cell_type":"code","source":[],"metadata":{"id":"vqFHDFqYUxU4"},"execution_count":null,"outputs":[]}],"metadata":{"kernelspec":{"display_name":"Python 2","language":"python","name":"python2"},"language_info":{"codemirror_mode":{"name":"ipython","version":2},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython2","version":"2.7.11"},"colab":{"provenance":[{"file_id":"https://github.com/thieu1995/pandas/blob/main/02_Filtering_%26_Sorting/Chipotle/Exercises.ipynb","timestamp":1664075165775}],"collapsed_sections":[]}},"nbformat":4,"nbformat_minor":0}