4_Slicing_Dicing.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Slicing and Dicing Dataframes\n",
    "\n",
    "You have seen how to do indexing of dataframes using ```df.iloc``` and ```df.loc```. Now, let's see how to subset dataframes based on certain conditions. \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Ord_id</th>\n",
       "      <th>Prod_id</th>\n",
       "      <th>Ship_id</th>\n",
       "      <th>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Order_Quantity</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Product_Base_Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_16</td>\n",
       "      <td>SHP_7609</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>136.81</td>\n",
       "      <td>0.01</td>\n",
       "      <td>23</td>\n",
       "      <td>-30.51</td>\n",
       "      <td>3.60</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ord_5406</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_7549</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>42.27</td>\n",
       "      <td>0.01</td>\n",
       "      <td>13</td>\n",
       "      <td>4.56</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7610</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4701.69</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "      <td>1148.90</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ord_5456</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7625</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>2337.89</td>\n",
       "      <td>0.09</td>\n",
       "      <td>43</td>\n",
       "      <td>729.34</td>\n",
       "      <td>14.30</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ord_5485</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7664</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4233.15</td>\n",
       "      <td>0.08</td>\n",
       "      <td>35</td>\n",
       "      <td>1219.87</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     Ord_id  Prod_id   Ship_id    Cust_id    Sales  Discount  Order_Quantity  \\\n",
       "0  Ord_5446  Prod_16  SHP_7609  Cust_1818   136.81      0.01              23   \n",
       "1  Ord_5406  Prod_13  SHP_7549  Cust_1818    42.27      0.01              13   \n",
       "2  Ord_5446   Prod_4  SHP_7610  Cust_1818  4701.69      0.00              26   \n",
       "3  Ord_5456   Prod_6  SHP_7625  Cust_1818  2337.89      0.09              43   \n",
       "4  Ord_5485  Prod_17  SHP_7664  Cust_1818  4233.15      0.08              35   \n",
       "\n",
       "    Profit  Shipping_Cost  Product_Base_Margin  \n",
       "0   -30.51           3.60                 0.56  \n",
       "1     4.56           0.93                 0.54  \n",
       "2  1148.90           2.50                 0.59  \n",
       "3   729.34          14.30                 0.37  \n",
       "4  1219.87          26.30                 0.38  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# loading libraries and reading the data\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "\n",
    "df = pd.read_csv(\"global_sales_data/market_fact.csv\")\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Subsetting Rows Based on Conditions\n",
    "\n",
    "Often, you want to select rows which satisfy some given conditions. For e.g., select all the orders where the ```Sales > 3000```, or all the orders where ```2000 < Sales < 3000``` and ```Profit < 100```.\n",
    "\n",
    "Arguably, the best way to do these operations is using ```df.loc[]```, since ```df.iloc[]``` would require you to remember the integer column indices, which is tedious.\n",
    "\n",
    "Let's see some examples."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0       False\n",
       "1       False\n",
       "2        True\n",
       "3       False\n",
       "4        True\n",
       "5       False\n",
       "6       False\n",
       "7        True\n",
       "8       False\n",
       "9       False\n",
       "10       True\n",
       "11      False\n",
       "12      False\n",
       "13       True\n",
       "14      False\n",
       "15      False\n",
       "16      False\n",
       "17       True\n",
       "18      False\n",
       "19      False\n",
       "20      False\n",
       "21      False\n",
       "22       True\n",
       "23      False\n",
       "24      False\n",
       "25      False\n",
       "26      False\n",
       "27      False\n",
       "28       True\n",
       "29      False\n",
       "        ...  \n",
       "8369    False\n",
       "8370    False\n",
       "8371     True\n",
       "8372    False\n",
       "8373    False\n",
       "8374    False\n",
       "8375    False\n",
       "8376    False\n",
       "8377    False\n",
       "8378    False\n",
       "8379    False\n",
       "8380    False\n",
       "8381    False\n",
       "8382    False\n",
       "8383     True\n",
       "8384    False\n",
       "8385    False\n",
       "8386    False\n",
       "8387    False\n",
       "8388    False\n",
       "8389    False\n",
       "8390    False\n",
       "8391    False\n",
       "8392    False\n",
       "8393    False\n",
       "8394    False\n",
       "8395    False\n",
       "8396    False\n",
       "8397     True\n",
       "8398    False\n",
       "Name: Sales, Length: 8399, dtype: bool"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Select all rows where Sales > 3000\n",
    "# First, we get a boolean array where True corresponds to rows having Sales > 3000\n",
    "df.Sales > 3000"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Ord_id</th>\n",
       "      <th>Prod_id</th>\n",
       "      <th>Ship_id</th>\n",
       "      <th>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Order_Quantity</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Product_Base_Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7610</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4701.6900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "      <td>1148.90</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ord_5485</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7664</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4233.1500</td>\n",
       "      <td>0.08</td>\n",
       "      <td>35</td>\n",
       "      <td>1219.87</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ord_4725</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6593</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>3410.1575</td>\n",
       "      <td>0.10</td>\n",
       "      <td>48</td>\n",
       "      <td>1137.91</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ord_4743</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_6615</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>4072.0100</td>\n",
       "      <td>0.01</td>\n",
       "      <td>43</td>\n",
       "      <td>1675.98</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ord_2207</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_3093</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>3364.2480</td>\n",
       "      <td>0.10</td>\n",
       "      <td>15</td>\n",
       "      <td>-693.23</td>\n",
       "      <td>61.76</td>\n",
       "      <td>0.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ord_4471</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6228</td>\n",
       "      <td>Cust_1521</td>\n",
       "      <td>13255.9300</td>\n",
       "      <td>0.02</td>\n",
       "      <td>25</td>\n",
       "      <td>4089.27</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_1377</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>3202.2500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>44</td>\n",
       "      <td>991.26</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ord_2573</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3527</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>3594.7435</td>\n",
       "      <td>0.05</td>\n",
       "      <td>38</td>\n",
       "      <td>1016.97</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Ord_5035</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7024</td>\n",
       "      <td>Cust_1710</td>\n",
       "      <td>4917.6900</td>\n",
       "      <td>0.02</td>\n",
       "      <td>42</td>\n",
       "      <td>126.31</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Ord_4546</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6327</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>5208.7800</td>\n",
       "      <td>0.05</td>\n",
       "      <td>34</td>\n",
       "      <td>1547.78</td>\n",
       "      <td>7.07</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Ord_4475</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6234</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>7640.2250</td>\n",
       "      <td>0.07</td>\n",
       "      <td>46</td>\n",
       "      <td>2027.68</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Ord_5188</td>\n",
       "      <td>Prod_14</td>\n",
       "      <td>SHP_7252</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>5177.4000</td>\n",
       "      <td>0.06</td>\n",
       "      <td>12</td>\n",
       "      <td>287.50</td>\n",
       "      <td>49.00</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Ord_5156</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7207</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>8374.1320</td>\n",
       "      <td>0.06</td>\n",
       "      <td>48</td>\n",
       "      <td>2568.10</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Ord_5232</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7306</td>\n",
       "      <td>Cust_1758</td>\n",
       "      <td>21366.5100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3</td>\n",
       "      <td>-11984.40</td>\n",
       "      <td>24.49</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>Ord_250</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_346</td>\n",
       "      <td>Cust_45</td>\n",
       "      <td>8901.7800</td>\n",
       "      <td>0.04</td>\n",
       "      <td>31</td>\n",
       "      <td>2795.36</td>\n",
       "      <td>24.49</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Ord_5423</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7577</td>\n",
       "      <td>Cust_1800</td>\n",
       "      <td>13070.2000</td>\n",
       "      <td>0.07</td>\n",
       "      <td>4</td>\n",
       "      <td>-6923.60</td>\n",
       "      <td>8.73</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>Ord_2432</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3339</td>\n",
       "      <td>Cust_933</td>\n",
       "      <td>3883.4715</td>\n",
       "      <td>0.10</td>\n",
       "      <td>42</td>\n",
       "      <td>707.17</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Ord_2432</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3338</td>\n",
       "      <td>Cust_933</td>\n",
       "      <td>15337.5800</td>\n",
       "      <td>0.10</td>\n",
       "      <td>30</td>\n",
       "      <td>6670.41</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Ord_1649</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_2277</td>\n",
       "      <td>Cust_498</td>\n",
       "      <td>3005.7400</td>\n",
       "      <td>0.02</td>\n",
       "      <td>48</td>\n",
       "      <td>1053.21</td>\n",
       "      <td>3.99</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Ord_4646</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6475</td>\n",
       "      <td>Cust_1603</td>\n",
       "      <td>4083.1900</td>\n",
       "      <td>0.07</td>\n",
       "      <td>43</td>\n",
       "      <td>-1049.85</td>\n",
       "      <td>45.00</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Ord_4646</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6476</td>\n",
       "      <td>Cust_1603</td>\n",
       "      <td>4902.3800</td>\n",
       "      <td>0.05</td>\n",
       "      <td>32</td>\n",
       "      <td>1438.49</td>\n",
       "      <td>7.07</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>Ord_4702</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_6560</td>\n",
       "      <td>Cust_1603</td>\n",
       "      <td>11823.5200</td>\n",
       "      <td>0.10</td>\n",
       "      <td>34</td>\n",
       "      <td>4592.74</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Ord_2973</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4102</td>\n",
       "      <td>Cust_1081</td>\n",
       "      <td>4671.1495</td>\n",
       "      <td>0.07</td>\n",
       "      <td>28</td>\n",
       "      <td>947.31</td>\n",
       "      <td>4.20</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Ord_3009</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4168</td>\n",
       "      <td>Cust_1081</td>\n",
       "      <td>5718.8500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>49</td>\n",
       "      <td>-2426.55</td>\n",
       "      <td>70.20</td>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Ord_2973</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4102</td>\n",
       "      <td>Cust_1480</td>\n",
       "      <td>6264.1855</td>\n",
       "      <td>0.01</td>\n",
       "      <td>34</td>\n",
       "      <td>1312.04</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Ord_2973</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_6073</td>\n",
       "      <td>Cust_1480</td>\n",
       "      <td>5410.9500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>36</td>\n",
       "      <td>2077.91</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Ord_5157</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7208</td>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>5149.0600</td>\n",
       "      <td>0.03</td>\n",
       "      <td>27</td>\n",
       "      <td>605.44</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Ord_5153</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_7202</td>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>3457.5600</td>\n",
       "      <td>0.02</td>\n",
       "      <td>35</td>\n",
       "      <td>-365.44</td>\n",
       "      <td>51.94</td>\n",
       "      <td>0.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Ord_2831</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3893</td>\n",
       "      <td>Cust_1036</td>\n",
       "      <td>18092.6600</td>\n",
       "      <td>0.09</td>\n",
       "      <td>36</td>\n",
       "      <td>7917.76</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Ord_2791</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_3838</td>\n",
       "      <td>Cust_1036</td>\n",
       "      <td>10351.0100</td>\n",
       "      <td>0.08</td>\n",
       "      <td>19</td>\n",
       "      <td>-1331.55</td>\n",
       "      <td>45.70</td>\n",
       "      <td>0.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8125</th>\n",
       "      <td>Ord_4515</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6285</td>\n",
       "      <td>Cust_1546</td>\n",
       "      <td>4976.6000</td>\n",
       "      <td>0.06</td>\n",
       "      <td>32</td>\n",
       "      <td>601.88</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8137</th>\n",
       "      <td>Ord_2267</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_3089</td>\n",
       "      <td>Cust_890</td>\n",
       "      <td>6608.2400</td>\n",
       "      <td>0.09</td>\n",
       "      <td>35</td>\n",
       "      <td>2164.64</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8141</th>\n",
       "      <td>Ord_3368</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4668</td>\n",
       "      <td>Cust_1190</td>\n",
       "      <td>3227.3800</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26</td>\n",
       "      <td>192.31</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8143</th>\n",
       "      <td>Ord_3265</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_4530</td>\n",
       "      <td>Cust_1190</td>\n",
       "      <td>10330.9400</td>\n",
       "      <td>0.07</td>\n",
       "      <td>25</td>\n",
       "      <td>2914.56</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8151</th>\n",
       "      <td>Ord_3214</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_4456</td>\n",
       "      <td>Cust_1187</td>\n",
       "      <td>8316.7600</td>\n",
       "      <td>0.05</td>\n",
       "      <td>30</td>\n",
       "      <td>2108.80</td>\n",
       "      <td>23.19</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8158</th>\n",
       "      <td>Ord_2868</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_3950</td>\n",
       "      <td>Cust_1059</td>\n",
       "      <td>5405.4400</td>\n",
       "      <td>0.07</td>\n",
       "      <td>18</td>\n",
       "      <td>604.46</td>\n",
       "      <td>64.73</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8207</th>\n",
       "      <td>Ord_3433</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_4759</td>\n",
       "      <td>Cust_1180</td>\n",
       "      <td>3601.0700</td>\n",
       "      <td>0.04</td>\n",
       "      <td>50</td>\n",
       "      <td>174.80</td>\n",
       "      <td>14.52</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8210</th>\n",
       "      <td>Ord_2110</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_2885</td>\n",
       "      <td>Cust_802</td>\n",
       "      <td>4502.2600</td>\n",
       "      <td>0.09</td>\n",
       "      <td>38</td>\n",
       "      <td>1272.17</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8211</th>\n",
       "      <td>Ord_2144</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_2925</td>\n",
       "      <td>Cust_802</td>\n",
       "      <td>5318.8900</td>\n",
       "      <td>0.06</td>\n",
       "      <td>48</td>\n",
       "      <td>525.15</td>\n",
       "      <td>8.64</td>\n",
       "      <td>0.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8217</th>\n",
       "      <td>Ord_3359</td>\n",
       "      <td>Prod_10</td>\n",
       "      <td>SHP_7245</td>\n",
       "      <td>Cust_1762</td>\n",
       "      <td>28389.1400</td>\n",
       "      <td>0.07</td>\n",
       "      <td>33</td>\n",
       "      <td>7132.18</td>\n",
       "      <td>44.55</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8219</th>\n",
       "      <td>Ord_5200</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7266</td>\n",
       "      <td>Cust_1762</td>\n",
       "      <td>4815.8620</td>\n",
       "      <td>0.08</td>\n",
       "      <td>47</td>\n",
       "      <td>1316.79</td>\n",
       "      <td>4.20</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8235</th>\n",
       "      <td>Ord_759</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_1036</td>\n",
       "      <td>Cust_245</td>\n",
       "      <td>8549.0400</td>\n",
       "      <td>0.03</td>\n",
       "      <td>42</td>\n",
       "      <td>2861.01</td>\n",
       "      <td>11.54</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8240</th>\n",
       "      <td>Ord_793</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_1090</td>\n",
       "      <td>Cust_245</td>\n",
       "      <td>4452.6500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>30</td>\n",
       "      <td>-265.12</td>\n",
       "      <td>60.00</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8249</th>\n",
       "      <td>Ord_3470</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_4805</td>\n",
       "      <td>Cust_1203</td>\n",
       "      <td>5615.4000</td>\n",
       "      <td>0.07</td>\n",
       "      <td>46</td>\n",
       "      <td>1807.16</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8263</th>\n",
       "      <td>Ord_4954</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6913</td>\n",
       "      <td>Cust_1694</td>\n",
       "      <td>7987.4300</td>\n",
       "      <td>0.03</td>\n",
       "      <td>49</td>\n",
       "      <td>1304.90</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8283</th>\n",
       "      <td>Ord_1741</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2411</td>\n",
       "      <td>Cust_595</td>\n",
       "      <td>15168.8200</td>\n",
       "      <td>0.02</td>\n",
       "      <td>26</td>\n",
       "      <td>-1096.78</td>\n",
       "      <td>147.12</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8286</th>\n",
       "      <td>Ord_1749</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_2424</td>\n",
       "      <td>Cust_595</td>\n",
       "      <td>5176.2700</td>\n",
       "      <td>0.01</td>\n",
       "      <td>38</td>\n",
       "      <td>-743.45</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8292</th>\n",
       "      <td>Ord_1765</td>\n",
       "      <td>Prod_14</td>\n",
       "      <td>SHP_2446</td>\n",
       "      <td>Cust_595</td>\n",
       "      <td>14647.2600</td>\n",
       "      <td>0.07</td>\n",
       "      <td>25</td>\n",
       "      <td>5485.15</td>\n",
       "      <td>24.49</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8298</th>\n",
       "      <td>Ord_2172</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_2960</td>\n",
       "      <td>Cust_787</td>\n",
       "      <td>6648.5800</td>\n",
       "      <td>0.08</td>\n",
       "      <td>19</td>\n",
       "      <td>-555.98</td>\n",
       "      <td>99.00</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8308</th>\n",
       "      <td>Ord_2659</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_3638</td>\n",
       "      <td>Cust_1016</td>\n",
       "      <td>4744.6400</td>\n",
       "      <td>0.04</td>\n",
       "      <td>46</td>\n",
       "      <td>1033.38</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8317</th>\n",
       "      <td>Ord_2770</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3802</td>\n",
       "      <td>Cust_1016</td>\n",
       "      <td>7535.9600</td>\n",
       "      <td>0.08</td>\n",
       "      <td>46</td>\n",
       "      <td>2745.87</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8329</th>\n",
       "      <td>Ord_2160</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_2944</td>\n",
       "      <td>Cust_810</td>\n",
       "      <td>3636.3700</td>\n",
       "      <td>0.06</td>\n",
       "      <td>33</td>\n",
       "      <td>-176.91</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8332</th>\n",
       "      <td>Ord_2101</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2875</td>\n",
       "      <td>Cust_790</td>\n",
       "      <td>10714.7800</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41</td>\n",
       "      <td>-627.64</td>\n",
       "      <td>66.67</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8335</th>\n",
       "      <td>Ord_2070</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2833</td>\n",
       "      <td>Cust_784</td>\n",
       "      <td>3905.7500</td>\n",
       "      <td>0.01</td>\n",
       "      <td>21</td>\n",
       "      <td>55.30</td>\n",
       "      <td>29.21</td>\n",
       "      <td>0.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8343</th>\n",
       "      <td>Ord_2178</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2968</td>\n",
       "      <td>Cust_785</td>\n",
       "      <td>6030.5800</td>\n",
       "      <td>0.09</td>\n",
       "      <td>39</td>\n",
       "      <td>1197.86</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8366</th>\n",
       "      <td>Ord_3593</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_4974</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>12073.0600</td>\n",
       "      <td>0.03</td>\n",
       "      <td>39</td>\n",
       "      <td>5081.87</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8367</th>\n",
       "      <td>Ord_3593</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4975</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>6685.0500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>25</td>\n",
       "      <td>1653.60</td>\n",
       "      <td>24.49</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8371</th>\n",
       "      <td>Ord_2624</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3591</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>4924.1350</td>\n",
       "      <td>0.07</td>\n",
       "      <td>28</td>\n",
       "      <td>1049.54</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8383</th>\n",
       "      <td>Ord_2722</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_3731</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>3508.3300</td>\n",
       "      <td>0.04</td>\n",
       "      <td>21</td>\n",
       "      <td>-546.98</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8397</th>\n",
       "      <td>Ord_5348</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7469</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>3872.8700</td>\n",
       "      <td>0.03</td>\n",
       "      <td>23</td>\n",
       "      <td>565.34</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1359 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Ord_id  Prod_id   Ship_id    Cust_id       Sales  Discount  \\\n",
       "2     Ord_5446   Prod_4  SHP_7610  Cust_1818   4701.6900      0.00   \n",
       "4     Ord_5485  Prod_17  SHP_7664  Cust_1818   4233.1500      0.08   \n",
       "7     Ord_4725   Prod_4  SHP_6593  Cust_1641   3410.1575      0.10   \n",
       "10    Ord_4743   Prod_2  SHP_6615  Cust_1641   4072.0100      0.01   \n",
       "13    Ord_2207  Prod_11  SHP_3093   Cust_839   3364.2480      0.10   \n",
       "17    Ord_4471  Prod_15  SHP_6228  Cust_1521  13255.9300      0.02   \n",
       "22     Ord_996   Prod_5  SHP_1377   Cust_371   3202.2500      0.09   \n",
       "28    Ord_2573   Prod_4  SHP_3527   Cust_931   3594.7435      0.05   \n",
       "40    Ord_5035  Prod_15  SHP_7024  Cust_1710   4917.6900      0.02   \n",
       "57    Ord_4546   Prod_1  SHP_6327  Cust_1474   5208.7800      0.05   \n",
       "64    Ord_4475   Prod_4  SHP_6234  Cust_1474   7640.2250      0.07   \n",
       "79    Ord_5188  Prod_14  SHP_7252  Cust_1749   5177.4000      0.06   \n",
       "82    Ord_5156   Prod_4  SHP_7207  Cust_1749   8374.1320      0.06   \n",
       "84    Ord_5232  Prod_17  SHP_7306  Cust_1758  21366.5100      0.00   \n",
       "107    Ord_250  Prod_15   SHP_346    Cust_45   8901.7800      0.04   \n",
       "121   Ord_5423  Prod_17  SHP_7577  Cust_1800  13070.2000      0.07   \n",
       "124   Ord_2432   Prod_4  SHP_3339   Cust_933   3883.4715      0.10   \n",
       "133   Ord_2432   Prod_3  SHP_3338   Cust_933  15337.5800      0.10   \n",
       "148   Ord_1649   Prod_2  SHP_2277   Cust_498   3005.7400      0.02   \n",
       "163   Ord_4646  Prod_15  SHP_6475  Cust_1603   4083.1900      0.07   \n",
       "164   Ord_4646   Prod_1  SHP_6476  Cust_1603   4902.3800      0.05   \n",
       "165   Ord_4702   Prod_3  SHP_6560  Cust_1603  11823.5200      0.10   \n",
       "168   Ord_2973   Prod_4  SHP_4102  Cust_1081   4671.1495      0.07   \n",
       "169   Ord_3009  Prod_15  SHP_4168  Cust_1081   5718.8500      0.09   \n",
       "170   Ord_2973   Prod_4  SHP_4102  Cust_1480   6264.1855      0.01   \n",
       "171   Ord_2973   Prod_9  SHP_6073  Cust_1480   5410.9500      0.09   \n",
       "183   Ord_5157  Prod_15  SHP_7208  Cust_1753   5149.0600      0.03   \n",
       "185   Ord_5153  Prod_11  SHP_7202  Cust_1753   3457.5600      0.02   \n",
       "189   Ord_2831   Prod_3  SHP_3893  Cust_1036  18092.6600      0.09   \n",
       "191   Ord_2791  Prod_11  SHP_3838  Cust_1036  10351.0100      0.08   \n",
       "...        ...      ...       ...        ...         ...       ...   \n",
       "8125  Ord_4515   Prod_1  SHP_6285  Cust_1546   4976.6000      0.06   \n",
       "8137  Ord_2267   Prod_2  SHP_3089   Cust_890   6608.2400      0.09   \n",
       "8141  Ord_3368  Prod_15  SHP_4668  Cust_1190   3227.3800      0.05   \n",
       "8143  Ord_3265   Prod_1  SHP_4530  Cust_1190  10330.9400      0.07   \n",
       "8151  Ord_3214   Prod_2  SHP_4456  Cust_1187   8316.7600      0.05   \n",
       "8158  Ord_2868  Prod_15  SHP_3950  Cust_1059   5405.4400      0.07   \n",
       "8207  Ord_3433   Prod_8  SHP_4759  Cust_1180   3601.0700      0.04   \n",
       "8210  Ord_2110  Prod_17  SHP_2885   Cust_802   4502.2600      0.09   \n",
       "8211  Ord_2144   Prod_1  SHP_2925   Cust_802   5318.8900      0.06   \n",
       "8217  Ord_3359  Prod_10  SHP_7245  Cust_1762  28389.1400      0.07   \n",
       "8219  Ord_5200   Prod_4  SHP_7266  Cust_1762   4815.8620      0.08   \n",
       "8235   Ord_759   Prod_5  SHP_1036   Cust_245   8549.0400      0.03   \n",
       "8240   Ord_793  Prod_11  SHP_1090   Cust_245   4452.6500      0.09   \n",
       "8249  Ord_3470  Prod_17  SHP_4805  Cust_1203   5615.4000      0.07   \n",
       "8263  Ord_4954  Prod_15  SHP_6913  Cust_1694   7987.4300      0.03   \n",
       "8283  Ord_1741  Prod_11  SHP_2411   Cust_595  15168.8200      0.02   \n",
       "8286  Ord_1749   Prod_1  SHP_2424   Cust_595   5176.2700      0.01   \n",
       "8292  Ord_1765  Prod_14  SHP_2446   Cust_595  14647.2600      0.07   \n",
       "8298  Ord_2172   Prod_1  SHP_2960   Cust_787   6648.5800      0.08   \n",
       "8308  Ord_2659   Prod_8  SHP_3638  Cust_1016   4744.6400      0.04   \n",
       "8317  Ord_2770   Prod_3  SHP_3802  Cust_1016   7535.9600      0.08   \n",
       "8329  Ord_2160  Prod_15  SHP_2944   Cust_810   3636.3700      0.06   \n",
       "8332  Ord_2101  Prod_11  SHP_2875   Cust_790  10714.7800      0.00   \n",
       "8335  Ord_2070  Prod_11  SHP_2833   Cust_784   3905.7500      0.01   \n",
       "8343  Ord_2178   Prod_4  SHP_2968   Cust_785   6030.5800      0.09   \n",
       "8366  Ord_3593   Prod_3  SHP_4974  Cust_1274  12073.0600      0.03   \n",
       "8367  Ord_3593  Prod_15  SHP_4975  Cust_1274   6685.0500      0.09   \n",
       "8371  Ord_2624   Prod_4  SHP_3591  Cust_1006   4924.1350      0.07   \n",
       "8383  Ord_2722   Prod_1  SHP_3731  Cust_1006   3508.3300      0.04   \n",
       "8397  Ord_5348  Prod_15  SHP_7469  Cust_1798   3872.8700      0.03   \n",
       "\n",
       "      Order_Quantity    Profit  Shipping_Cost  Product_Base_Margin  \n",
       "2                 26   1148.90           2.50                 0.59  \n",
       "4                 35   1219.87          26.30                 0.38  \n",
       "7                 48   1137.91           0.99                 0.55  \n",
       "10                43   1675.98           0.99                 0.56  \n",
       "13                15   -693.23          61.76                 0.78  \n",
       "17                25   4089.27          26.00                 0.60  \n",
       "22                44    991.26          19.99                 0.43  \n",
       "28                38   1016.97           2.50                 0.55  \n",
       "40                42    126.31          30.00                 0.71  \n",
       "57                34   1547.78           7.07                 0.59  \n",
       "64                46   2027.68           2.50                 0.59  \n",
       "79                12    287.50          49.00                 0.38  \n",
       "82                48   2568.10           8.99                 0.56  \n",
       "84                 3 -11984.40          24.49                 0.39  \n",
       "107               31   2795.36          24.49                  NaN  \n",
       "121                4  -6923.60           8.73                 0.57  \n",
       "124               42    707.17           8.99                 0.58  \n",
       "133               30   6670.41          19.99                 0.37  \n",
       "148               48   1053.21           3.99                 0.57  \n",
       "163               43  -1049.85          45.00                 0.69  \n",
       "164               32   1438.49           7.07                 0.59  \n",
       "165               34   4592.74          19.99                 0.40  \n",
       "168               28    947.31           4.20                 0.59  \n",
       "169               49  -2426.55          70.20                 0.74  \n",
       "170               34   1312.04          19.99                 0.60  \n",
       "171               36   2077.91          19.99                 0.39  \n",
       "183               27    605.44          30.00                 0.69  \n",
       "185               35   -365.44          51.94                 0.63  \n",
       "189               36   7917.76          19.99                 0.37  \n",
       "191               19  -1331.55          45.70                 0.71  \n",
       "...              ...       ...            ...                  ...  \n",
       "8125              32    601.88          19.99                 0.66  \n",
       "8137              35   2164.64           0.99                 0.55  \n",
       "8141              26    192.31          30.00                 0.64  \n",
       "8143              25   2914.56          19.99                 0.58  \n",
       "8151              30   2108.80          23.19                 0.59  \n",
       "8158              18    604.46          64.73                 0.56  \n",
       "8207              50    174.80          14.52                 0.65  \n",
       "8210              38   1272.17          26.30                 0.38  \n",
       "8211              48    525.15           8.64                 0.78  \n",
       "8217              33   7132.18          44.55                 0.62  \n",
       "8219              47   1316.79           4.20                 0.57  \n",
       "8235              42   2861.01          11.54                 0.59  \n",
       "8240              30   -265.12          60.00                 0.55  \n",
       "8249              46   1807.16          26.30                 0.38  \n",
       "8263              49   1304.90          30.00                 0.62  \n",
       "8283              26  -1096.78         147.12                 0.80  \n",
       "8286              38   -743.45          35.00                 0.84  \n",
       "8292              25   5485.15          24.49                 0.37  \n",
       "8298              19   -555.98          99.00                 0.65  \n",
       "8308              46   1033.38          19.99                 0.52  \n",
       "8317              46   2745.87          19.99                 0.40  \n",
       "8329              33   -176.91          30.00                 0.69  \n",
       "8332              41   -627.64          66.67                 0.65  \n",
       "8335              21     55.30          29.21                 0.76  \n",
       "8343              39   1197.86           8.99                 0.58  \n",
       "8366              39   5081.87          19.99                 0.38  \n",
       "8367              25   1653.60          24.49                  NaN  \n",
       "8371              28   1049.54           8.99                 0.58  \n",
       "8383              21   -546.98          35.00                 0.85  \n",
       "8397              23    565.34          30.00                 0.62  \n",
       "\n",
       "[1359 rows x 10 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Then, we pass this boolean array inside df.loc\n",
    "df.loc[df.Sales > 3000]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Ord_id</th>\n",
       "      <th>Prod_id</th>\n",
       "      <th>Ship_id</th>\n",
       "      <th>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Order_Quantity</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Product_Base_Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7610</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4701.6900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "      <td>1148.90</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ord_5485</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7664</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4233.1500</td>\n",
       "      <td>0.08</td>\n",
       "      <td>35</td>\n",
       "      <td>1219.87</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ord_4725</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6593</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>3410.1575</td>\n",
       "      <td>0.10</td>\n",
       "      <td>48</td>\n",
       "      <td>1137.91</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ord_4743</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_6615</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>4072.0100</td>\n",
       "      <td>0.01</td>\n",
       "      <td>43</td>\n",
       "      <td>1675.98</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ord_2207</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_3093</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>3364.2480</td>\n",
       "      <td>0.10</td>\n",
       "      <td>15</td>\n",
       "      <td>-693.23</td>\n",
       "      <td>61.76</td>\n",
       "      <td>0.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ord_4471</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6228</td>\n",
       "      <td>Cust_1521</td>\n",
       "      <td>13255.9300</td>\n",
       "      <td>0.02</td>\n",
       "      <td>25</td>\n",
       "      <td>4089.27</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_1377</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>3202.2500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>44</td>\n",
       "      <td>991.26</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ord_2573</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3527</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>3594.7435</td>\n",
       "      <td>0.05</td>\n",
       "      <td>38</td>\n",
       "      <td>1016.97</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Ord_5035</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7024</td>\n",
       "      <td>Cust_1710</td>\n",
       "      <td>4917.6900</td>\n",
       "      <td>0.02</td>\n",
       "      <td>42</td>\n",
       "      <td>126.31</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Ord_4546</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6327</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>5208.7800</td>\n",
       "      <td>0.05</td>\n",
       "      <td>34</td>\n",
       "      <td>1547.78</td>\n",
       "      <td>7.07</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Ord_4475</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6234</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>7640.2250</td>\n",
       "      <td>0.07</td>\n",
       "      <td>46</td>\n",
       "      <td>2027.68</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Ord_5188</td>\n",
       "      <td>Prod_14</td>\n",
       "      <td>SHP_7252</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>5177.4000</td>\n",
       "      <td>0.06</td>\n",
       "      <td>12</td>\n",
       "      <td>287.50</td>\n",
       "      <td>49.00</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Ord_5156</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7207</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>8374.1320</td>\n",
       "      <td>0.06</td>\n",
       "      <td>48</td>\n",
       "      <td>2568.10</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Ord_5232</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7306</td>\n",
       "      <td>Cust_1758</td>\n",
       "      <td>21366.5100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3</td>\n",
       "      <td>-11984.40</td>\n",
       "      <td>24.49</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>Ord_250</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_346</td>\n",
       "      <td>Cust_45</td>\n",
       "      <td>8901.7800</td>\n",
       "      <td>0.04</td>\n",
       "      <td>31</td>\n",
       "      <td>2795.36</td>\n",
       "      <td>24.49</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>Ord_5423</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7577</td>\n",
       "      <td>Cust_1800</td>\n",
       "      <td>13070.2000</td>\n",
       "      <td>0.07</td>\n",
       "      <td>4</td>\n",
       "      <td>-6923.60</td>\n",
       "      <td>8.73</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>Ord_2432</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3339</td>\n",
       "      <td>Cust_933</td>\n",
       "      <td>3883.4715</td>\n",
       "      <td>0.10</td>\n",
       "      <td>42</td>\n",
       "      <td>707.17</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>Ord_2432</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3338</td>\n",
       "      <td>Cust_933</td>\n",
       "      <td>15337.5800</td>\n",
       "      <td>0.10</td>\n",
       "      <td>30</td>\n",
       "      <td>6670.41</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>148</th>\n",
       "      <td>Ord_1649</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_2277</td>\n",
       "      <td>Cust_498</td>\n",
       "      <td>3005.7400</td>\n",
       "      <td>0.02</td>\n",
       "      <td>48</td>\n",
       "      <td>1053.21</td>\n",
       "      <td>3.99</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>Ord_4646</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6475</td>\n",
       "      <td>Cust_1603</td>\n",
       "      <td>4083.1900</td>\n",
       "      <td>0.07</td>\n",
       "      <td>43</td>\n",
       "      <td>-1049.85</td>\n",
       "      <td>45.00</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>Ord_4646</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6476</td>\n",
       "      <td>Cust_1603</td>\n",
       "      <td>4902.3800</td>\n",
       "      <td>0.05</td>\n",
       "      <td>32</td>\n",
       "      <td>1438.49</td>\n",
       "      <td>7.07</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>Ord_4702</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_6560</td>\n",
       "      <td>Cust_1603</td>\n",
       "      <td>11823.5200</td>\n",
       "      <td>0.10</td>\n",
       "      <td>34</td>\n",
       "      <td>4592.74</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>Ord_2973</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4102</td>\n",
       "      <td>Cust_1081</td>\n",
       "      <td>4671.1495</td>\n",
       "      <td>0.07</td>\n",
       "      <td>28</td>\n",
       "      <td>947.31</td>\n",
       "      <td>4.20</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>Ord_3009</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4168</td>\n",
       "      <td>Cust_1081</td>\n",
       "      <td>5718.8500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>49</td>\n",
       "      <td>-2426.55</td>\n",
       "      <td>70.20</td>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Ord_2973</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4102</td>\n",
       "      <td>Cust_1480</td>\n",
       "      <td>6264.1855</td>\n",
       "      <td>0.01</td>\n",
       "      <td>34</td>\n",
       "      <td>1312.04</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>Ord_2973</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_6073</td>\n",
       "      <td>Cust_1480</td>\n",
       "      <td>5410.9500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>36</td>\n",
       "      <td>2077.91</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Ord_5157</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7208</td>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>5149.0600</td>\n",
       "      <td>0.03</td>\n",
       "      <td>27</td>\n",
       "      <td>605.44</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>Ord_5153</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_7202</td>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>3457.5600</td>\n",
       "      <td>0.02</td>\n",
       "      <td>35</td>\n",
       "      <td>-365.44</td>\n",
       "      <td>51.94</td>\n",
       "      <td>0.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>Ord_2831</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3893</td>\n",
       "      <td>Cust_1036</td>\n",
       "      <td>18092.6600</td>\n",
       "      <td>0.09</td>\n",
       "      <td>36</td>\n",
       "      <td>7917.76</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>Ord_2791</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_3838</td>\n",
       "      <td>Cust_1036</td>\n",
       "      <td>10351.0100</td>\n",
       "      <td>0.08</td>\n",
       "      <td>19</td>\n",
       "      <td>-1331.55</td>\n",
       "      <td>45.70</td>\n",
       "      <td>0.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8125</th>\n",
       "      <td>Ord_4515</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6285</td>\n",
       "      <td>Cust_1546</td>\n",
       "      <td>4976.6000</td>\n",
       "      <td>0.06</td>\n",
       "      <td>32</td>\n",
       "      <td>601.88</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8137</th>\n",
       "      <td>Ord_2267</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_3089</td>\n",
       "      <td>Cust_890</td>\n",
       "      <td>6608.2400</td>\n",
       "      <td>0.09</td>\n",
       "      <td>35</td>\n",
       "      <td>2164.64</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8141</th>\n",
       "      <td>Ord_3368</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4668</td>\n",
       "      <td>Cust_1190</td>\n",
       "      <td>3227.3800</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26</td>\n",
       "      <td>192.31</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8143</th>\n",
       "      <td>Ord_3265</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_4530</td>\n",
       "      <td>Cust_1190</td>\n",
       "      <td>10330.9400</td>\n",
       "      <td>0.07</td>\n",
       "      <td>25</td>\n",
       "      <td>2914.56</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8151</th>\n",
       "      <td>Ord_3214</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_4456</td>\n",
       "      <td>Cust_1187</td>\n",
       "      <td>8316.7600</td>\n",
       "      <td>0.05</td>\n",
       "      <td>30</td>\n",
       "      <td>2108.80</td>\n",
       "      <td>23.19</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8158</th>\n",
       "      <td>Ord_2868</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_3950</td>\n",
       "      <td>Cust_1059</td>\n",
       "      <td>5405.4400</td>\n",
       "      <td>0.07</td>\n",
       "      <td>18</td>\n",
       "      <td>604.46</td>\n",
       "      <td>64.73</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8207</th>\n",
       "      <td>Ord_3433</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_4759</td>\n",
       "      <td>Cust_1180</td>\n",
       "      <td>3601.0700</td>\n",
       "      <td>0.04</td>\n",
       "      <td>50</td>\n",
       "      <td>174.80</td>\n",
       "      <td>14.52</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8210</th>\n",
       "      <td>Ord_2110</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_2885</td>\n",
       "      <td>Cust_802</td>\n",
       "      <td>4502.2600</td>\n",
       "      <td>0.09</td>\n",
       "      <td>38</td>\n",
       "      <td>1272.17</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8211</th>\n",
       "      <td>Ord_2144</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_2925</td>\n",
       "      <td>Cust_802</td>\n",
       "      <td>5318.8900</td>\n",
       "      <td>0.06</td>\n",
       "      <td>48</td>\n",
       "      <td>525.15</td>\n",
       "      <td>8.64</td>\n",
       "      <td>0.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8217</th>\n",
       "      <td>Ord_3359</td>\n",
       "      <td>Prod_10</td>\n",
       "      <td>SHP_7245</td>\n",
       "      <td>Cust_1762</td>\n",
       "      <td>28389.1400</td>\n",
       "      <td>0.07</td>\n",
       "      <td>33</td>\n",
       "      <td>7132.18</td>\n",
       "      <td>44.55</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8219</th>\n",
       "      <td>Ord_5200</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7266</td>\n",
       "      <td>Cust_1762</td>\n",
       "      <td>4815.8620</td>\n",
       "      <td>0.08</td>\n",
       "      <td>47</td>\n",
       "      <td>1316.79</td>\n",
       "      <td>4.20</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8235</th>\n",
       "      <td>Ord_759</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_1036</td>\n",
       "      <td>Cust_245</td>\n",
       "      <td>8549.0400</td>\n",
       "      <td>0.03</td>\n",
       "      <td>42</td>\n",
       "      <td>2861.01</td>\n",
       "      <td>11.54</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8240</th>\n",
       "      <td>Ord_793</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_1090</td>\n",
       "      <td>Cust_245</td>\n",
       "      <td>4452.6500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>30</td>\n",
       "      <td>-265.12</td>\n",
       "      <td>60.00</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8249</th>\n",
       "      <td>Ord_3470</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_4805</td>\n",
       "      <td>Cust_1203</td>\n",
       "      <td>5615.4000</td>\n",
       "      <td>0.07</td>\n",
       "      <td>46</td>\n",
       "      <td>1807.16</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8263</th>\n",
       "      <td>Ord_4954</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6913</td>\n",
       "      <td>Cust_1694</td>\n",
       "      <td>7987.4300</td>\n",
       "      <td>0.03</td>\n",
       "      <td>49</td>\n",
       "      <td>1304.90</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8283</th>\n",
       "      <td>Ord_1741</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2411</td>\n",
       "      <td>Cust_595</td>\n",
       "      <td>15168.8200</td>\n",
       "      <td>0.02</td>\n",
       "      <td>26</td>\n",
       "      <td>-1096.78</td>\n",
       "      <td>147.12</td>\n",
       "      <td>0.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8286</th>\n",
       "      <td>Ord_1749</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_2424</td>\n",
       "      <td>Cust_595</td>\n",
       "      <td>5176.2700</td>\n",
       "      <td>0.01</td>\n",
       "      <td>38</td>\n",
       "      <td>-743.45</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8292</th>\n",
       "      <td>Ord_1765</td>\n",
       "      <td>Prod_14</td>\n",
       "      <td>SHP_2446</td>\n",
       "      <td>Cust_595</td>\n",
       "      <td>14647.2600</td>\n",
       "      <td>0.07</td>\n",
       "      <td>25</td>\n",
       "      <td>5485.15</td>\n",
       "      <td>24.49</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8298</th>\n",
       "      <td>Ord_2172</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_2960</td>\n",
       "      <td>Cust_787</td>\n",
       "      <td>6648.5800</td>\n",
       "      <td>0.08</td>\n",
       "      <td>19</td>\n",
       "      <td>-555.98</td>\n",
       "      <td>99.00</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8308</th>\n",
       "      <td>Ord_2659</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_3638</td>\n",
       "      <td>Cust_1016</td>\n",
       "      <td>4744.6400</td>\n",
       "      <td>0.04</td>\n",
       "      <td>46</td>\n",
       "      <td>1033.38</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8317</th>\n",
       "      <td>Ord_2770</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3802</td>\n",
       "      <td>Cust_1016</td>\n",
       "      <td>7535.9600</td>\n",
       "      <td>0.08</td>\n",
       "      <td>46</td>\n",
       "      <td>2745.87</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8329</th>\n",
       "      <td>Ord_2160</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_2944</td>\n",
       "      <td>Cust_810</td>\n",
       "      <td>3636.3700</td>\n",
       "      <td>0.06</td>\n",
       "      <td>33</td>\n",
       "      <td>-176.91</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8332</th>\n",
       "      <td>Ord_2101</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2875</td>\n",
       "      <td>Cust_790</td>\n",
       "      <td>10714.7800</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41</td>\n",
       "      <td>-627.64</td>\n",
       "      <td>66.67</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8335</th>\n",
       "      <td>Ord_2070</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2833</td>\n",
       "      <td>Cust_784</td>\n",
       "      <td>3905.7500</td>\n",
       "      <td>0.01</td>\n",
       "      <td>21</td>\n",
       "      <td>55.30</td>\n",
       "      <td>29.21</td>\n",
       "      <td>0.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8343</th>\n",
       "      <td>Ord_2178</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2968</td>\n",
       "      <td>Cust_785</td>\n",
       "      <td>6030.5800</td>\n",
       "      <td>0.09</td>\n",
       "      <td>39</td>\n",
       "      <td>1197.86</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8366</th>\n",
       "      <td>Ord_3593</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_4974</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>12073.0600</td>\n",
       "      <td>0.03</td>\n",
       "      <td>39</td>\n",
       "      <td>5081.87</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8367</th>\n",
       "      <td>Ord_3593</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4975</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>6685.0500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>25</td>\n",
       "      <td>1653.60</td>\n",
       "      <td>24.49</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8371</th>\n",
       "      <td>Ord_2624</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3591</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>4924.1350</td>\n",
       "      <td>0.07</td>\n",
       "      <td>28</td>\n",
       "      <td>1049.54</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8383</th>\n",
       "      <td>Ord_2722</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_3731</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>3508.3300</td>\n",
       "      <td>0.04</td>\n",
       "      <td>21</td>\n",
       "      <td>-546.98</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8397</th>\n",
       "      <td>Ord_5348</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7469</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>3872.8700</td>\n",
       "      <td>0.03</td>\n",
       "      <td>23</td>\n",
       "      <td>565.34</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1359 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Ord_id  Prod_id   Ship_id    Cust_id       Sales  Discount  \\\n",
       "2     Ord_5446   Prod_4  SHP_7610  Cust_1818   4701.6900      0.00   \n",
       "4     Ord_5485  Prod_17  SHP_7664  Cust_1818   4233.1500      0.08   \n",
       "7     Ord_4725   Prod_4  SHP_6593  Cust_1641   3410.1575      0.10   \n",
       "10    Ord_4743   Prod_2  SHP_6615  Cust_1641   4072.0100      0.01   \n",
       "13    Ord_2207  Prod_11  SHP_3093   Cust_839   3364.2480      0.10   \n",
       "17    Ord_4471  Prod_15  SHP_6228  Cust_1521  13255.9300      0.02   \n",
       "22     Ord_996   Prod_5  SHP_1377   Cust_371   3202.2500      0.09   \n",
       "28    Ord_2573   Prod_4  SHP_3527   Cust_931   3594.7435      0.05   \n",
       "40    Ord_5035  Prod_15  SHP_7024  Cust_1710   4917.6900      0.02   \n",
       "57    Ord_4546   Prod_1  SHP_6327  Cust_1474   5208.7800      0.05   \n",
       "64    Ord_4475   Prod_4  SHP_6234  Cust_1474   7640.2250      0.07   \n",
       "79    Ord_5188  Prod_14  SHP_7252  Cust_1749   5177.4000      0.06   \n",
       "82    Ord_5156   Prod_4  SHP_7207  Cust_1749   8374.1320      0.06   \n",
       "84    Ord_5232  Prod_17  SHP_7306  Cust_1758  21366.5100      0.00   \n",
       "107    Ord_250  Prod_15   SHP_346    Cust_45   8901.7800      0.04   \n",
       "121   Ord_5423  Prod_17  SHP_7577  Cust_1800  13070.2000      0.07   \n",
       "124   Ord_2432   Prod_4  SHP_3339   Cust_933   3883.4715      0.10   \n",
       "133   Ord_2432   Prod_3  SHP_3338   Cust_933  15337.5800      0.10   \n",
       "148   Ord_1649   Prod_2  SHP_2277   Cust_498   3005.7400      0.02   \n",
       "163   Ord_4646  Prod_15  SHP_6475  Cust_1603   4083.1900      0.07   \n",
       "164   Ord_4646   Prod_1  SHP_6476  Cust_1603   4902.3800      0.05   \n",
       "165   Ord_4702   Prod_3  SHP_6560  Cust_1603  11823.5200      0.10   \n",
       "168   Ord_2973   Prod_4  SHP_4102  Cust_1081   4671.1495      0.07   \n",
       "169   Ord_3009  Prod_15  SHP_4168  Cust_1081   5718.8500      0.09   \n",
       "170   Ord_2973   Prod_4  SHP_4102  Cust_1480   6264.1855      0.01   \n",
       "171   Ord_2973   Prod_9  SHP_6073  Cust_1480   5410.9500      0.09   \n",
       "183   Ord_5157  Prod_15  SHP_7208  Cust_1753   5149.0600      0.03   \n",
       "185   Ord_5153  Prod_11  SHP_7202  Cust_1753   3457.5600      0.02   \n",
       "189   Ord_2831   Prod_3  SHP_3893  Cust_1036  18092.6600      0.09   \n",
       "191   Ord_2791  Prod_11  SHP_3838  Cust_1036  10351.0100      0.08   \n",
       "...        ...      ...       ...        ...         ...       ...   \n",
       "8125  Ord_4515   Prod_1  SHP_6285  Cust_1546   4976.6000      0.06   \n",
       "8137  Ord_2267   Prod_2  SHP_3089   Cust_890   6608.2400      0.09   \n",
       "8141  Ord_3368  Prod_15  SHP_4668  Cust_1190   3227.3800      0.05   \n",
       "8143  Ord_3265   Prod_1  SHP_4530  Cust_1190  10330.9400      0.07   \n",
       "8151  Ord_3214   Prod_2  SHP_4456  Cust_1187   8316.7600      0.05   \n",
       "8158  Ord_2868  Prod_15  SHP_3950  Cust_1059   5405.4400      0.07   \n",
       "8207  Ord_3433   Prod_8  SHP_4759  Cust_1180   3601.0700      0.04   \n",
       "8210  Ord_2110  Prod_17  SHP_2885   Cust_802   4502.2600      0.09   \n",
       "8211  Ord_2144   Prod_1  SHP_2925   Cust_802   5318.8900      0.06   \n",
       "8217  Ord_3359  Prod_10  SHP_7245  Cust_1762  28389.1400      0.07   \n",
       "8219  Ord_5200   Prod_4  SHP_7266  Cust_1762   4815.8620      0.08   \n",
       "8235   Ord_759   Prod_5  SHP_1036   Cust_245   8549.0400      0.03   \n",
       "8240   Ord_793  Prod_11  SHP_1090   Cust_245   4452.6500      0.09   \n",
       "8249  Ord_3470  Prod_17  SHP_4805  Cust_1203   5615.4000      0.07   \n",
       "8263  Ord_4954  Prod_15  SHP_6913  Cust_1694   7987.4300      0.03   \n",
       "8283  Ord_1741  Prod_11  SHP_2411   Cust_595  15168.8200      0.02   \n",
       "8286  Ord_1749   Prod_1  SHP_2424   Cust_595   5176.2700      0.01   \n",
       "8292  Ord_1765  Prod_14  SHP_2446   Cust_595  14647.2600      0.07   \n",
       "8298  Ord_2172   Prod_1  SHP_2960   Cust_787   6648.5800      0.08   \n",
       "8308  Ord_2659   Prod_8  SHP_3638  Cust_1016   4744.6400      0.04   \n",
       "8317  Ord_2770   Prod_3  SHP_3802  Cust_1016   7535.9600      0.08   \n",
       "8329  Ord_2160  Prod_15  SHP_2944   Cust_810   3636.3700      0.06   \n",
       "8332  Ord_2101  Prod_11  SHP_2875   Cust_790  10714.7800      0.00   \n",
       "8335  Ord_2070  Prod_11  SHP_2833   Cust_784   3905.7500      0.01   \n",
       "8343  Ord_2178   Prod_4  SHP_2968   Cust_785   6030.5800      0.09   \n",
       "8366  Ord_3593   Prod_3  SHP_4974  Cust_1274  12073.0600      0.03   \n",
       "8367  Ord_3593  Prod_15  SHP_4975  Cust_1274   6685.0500      0.09   \n",
       "8371  Ord_2624   Prod_4  SHP_3591  Cust_1006   4924.1350      0.07   \n",
       "8383  Ord_2722   Prod_1  SHP_3731  Cust_1006   3508.3300      0.04   \n",
       "8397  Ord_5348  Prod_15  SHP_7469  Cust_1798   3872.8700      0.03   \n",
       "\n",
       "      Order_Quantity    Profit  Shipping_Cost  Product_Base_Margin  \n",
       "2                 26   1148.90           2.50                 0.59  \n",
       "4                 35   1219.87          26.30                 0.38  \n",
       "7                 48   1137.91           0.99                 0.55  \n",
       "10                43   1675.98           0.99                 0.56  \n",
       "13                15   -693.23          61.76                 0.78  \n",
       "17                25   4089.27          26.00                 0.60  \n",
       "22                44    991.26          19.99                 0.43  \n",
       "28                38   1016.97           2.50                 0.55  \n",
       "40                42    126.31          30.00                 0.71  \n",
       "57                34   1547.78           7.07                 0.59  \n",
       "64                46   2027.68           2.50                 0.59  \n",
       "79                12    287.50          49.00                 0.38  \n",
       "82                48   2568.10           8.99                 0.56  \n",
       "84                 3 -11984.40          24.49                 0.39  \n",
       "107               31   2795.36          24.49                  NaN  \n",
       "121                4  -6923.60           8.73                 0.57  \n",
       "124               42    707.17           8.99                 0.58  \n",
       "133               30   6670.41          19.99                 0.37  \n",
       "148               48   1053.21           3.99                 0.57  \n",
       "163               43  -1049.85          45.00                 0.69  \n",
       "164               32   1438.49           7.07                 0.59  \n",
       "165               34   4592.74          19.99                 0.40  \n",
       "168               28    947.31           4.20                 0.59  \n",
       "169               49  -2426.55          70.20                 0.74  \n",
       "170               34   1312.04          19.99                 0.60  \n",
       "171               36   2077.91          19.99                 0.39  \n",
       "183               27    605.44          30.00                 0.69  \n",
       "185               35   -365.44          51.94                 0.63  \n",
       "189               36   7917.76          19.99                 0.37  \n",
       "191               19  -1331.55          45.70                 0.71  \n",
       "...              ...       ...            ...                  ...  \n",
       "8125              32    601.88          19.99                 0.66  \n",
       "8137              35   2164.64           0.99                 0.55  \n",
       "8141              26    192.31          30.00                 0.64  \n",
       "8143              25   2914.56          19.99                 0.58  \n",
       "8151              30   2108.80          23.19                 0.59  \n",
       "8158              18    604.46          64.73                 0.56  \n",
       "8207              50    174.80          14.52                 0.65  \n",
       "8210              38   1272.17          26.30                 0.38  \n",
       "8211              48    525.15           8.64                 0.78  \n",
       "8217              33   7132.18          44.55                 0.62  \n",
       "8219              47   1316.79           4.20                 0.57  \n",
       "8235              42   2861.01          11.54                 0.59  \n",
       "8240              30   -265.12          60.00                 0.55  \n",
       "8249              46   1807.16          26.30                 0.38  \n",
       "8263              49   1304.90          30.00                 0.62  \n",
       "8283              26  -1096.78         147.12                 0.80  \n",
       "8286              38   -743.45          35.00                 0.84  \n",
       "8292              25   5485.15          24.49                 0.37  \n",
       "8298              19   -555.98          99.00                 0.65  \n",
       "8308              46   1033.38          19.99                 0.52  \n",
       "8317              46   2745.87          19.99                 0.40  \n",
       "8329              33   -176.91          30.00                 0.69  \n",
       "8332              41   -627.64          66.67                 0.65  \n",
       "8335              21     55.30          29.21                 0.76  \n",
       "8343              39   1197.86           8.99                 0.58  \n",
       "8366              39   5081.87          19.99                 0.38  \n",
       "8367              25   1653.60          24.49                  NaN  \n",
       "8371              28   1049.54           8.99                 0.58  \n",
       "8383              21   -546.98          35.00                 0.85  \n",
       "8397              23    565.34          30.00                 0.62  \n",
       "\n",
       "[1359 rows x 10 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# An alternative to df.Sales is df['Sales]\n",
    "# You may want to put the : to indicate that you want all columns\n",
    "# It is more explicit \n",
    "df.loc[df['Sales'] > 3000, :]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Ord_id</th>\n",
       "      <th>Prod_id</th>\n",
       "      <th>Ship_id</th>\n",
       "      <th>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Order_Quantity</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Product_Base_Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ord_5456</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7625</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>2337.8900</td>\n",
       "      <td>0.09</td>\n",
       "      <td>43</td>\n",
       "      <td>729.34</td>\n",
       "      <td>14.30</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Ord_5205</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7274</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>2546.5235</td>\n",
       "      <td>0.09</td>\n",
       "      <td>26</td>\n",
       "      <td>210.00</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Ord_139</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_186</td>\n",
       "      <td>Cust_45</td>\n",
       "      <td>2671.2100</td>\n",
       "      <td>0.06</td>\n",
       "      <td>14</td>\n",
       "      <td>636.18</td>\n",
       "      <td>15.59</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Ord_239</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_332</td>\n",
       "      <td>Cust_45</td>\n",
       "      <td>2157.3085</td>\n",
       "      <td>0.00</td>\n",
       "      <td>38</td>\n",
       "      <td>519.25</td>\n",
       "      <td>5.31</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Ord_1673</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_2314</td>\n",
       "      <td>Cust_498</td>\n",
       "      <td>2027.5500</td>\n",
       "      <td>0.04</td>\n",
       "      <td>14</td>\n",
       "      <td>537.40</td>\n",
       "      <td>13.99</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Ord_1649</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2278</td>\n",
       "      <td>Cust_498</td>\n",
       "      <td>2209.5155</td>\n",
       "      <td>0.06</td>\n",
       "      <td>41</td>\n",
       "      <td>458.62</td>\n",
       "      <td>5.31</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Ord_2273</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_3101</td>\n",
       "      <td>Cust_878</td>\n",
       "      <td>2899.9800</td>\n",
       "      <td>0.10</td>\n",
       "      <td>19</td>\n",
       "      <td>666.01</td>\n",
       "      <td>5.50</td>\n",
       "      <td>0.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Ord_5230</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7304</td>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>2197.4115</td>\n",
       "      <td>0.00</td>\n",
       "      <td>20</td>\n",
       "      <td>305.96</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Ord_5159</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_7210</td>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>2213.9200</td>\n",
       "      <td>0.03</td>\n",
       "      <td>20</td>\n",
       "      <td>768.34</td>\n",
       "      <td>13.99</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>Ord_657</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_899</td>\n",
       "      <td>Cust_209</td>\n",
       "      <td>2343.0760</td>\n",
       "      <td>0.06</td>\n",
       "      <td>24</td>\n",
       "      <td>311.64</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>Ord_1607</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2220</td>\n",
       "      <td>Cust_506</td>\n",
       "      <td>2980.3720</td>\n",
       "      <td>0.02</td>\n",
       "      <td>19</td>\n",
       "      <td>494.63</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>Ord_1521</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_2100</td>\n",
       "      <td>Cust_560</td>\n",
       "      <td>2230.9700</td>\n",
       "      <td>0.06</td>\n",
       "      <td>12</td>\n",
       "      <td>273.27</td>\n",
       "      <td>26.20</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>Ord_4896</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6829</td>\n",
       "      <td>Cust_1674</td>\n",
       "      <td>2827.1425</td>\n",
       "      <td>0.01</td>\n",
       "      <td>35</td>\n",
       "      <td>713.88</td>\n",
       "      <td>4.90</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>Ord_4144</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_5772</td>\n",
       "      <td>Cust_1418</td>\n",
       "      <td>2182.9100</td>\n",
       "      <td>0.10</td>\n",
       "      <td>40</td>\n",
       "      <td>549.45</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>Ord_1621</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_2238</td>\n",
       "      <td>Cust_566</td>\n",
       "      <td>2010.8900</td>\n",
       "      <td>0.09</td>\n",
       "      <td>34</td>\n",
       "      <td>564.07</td>\n",
       "      <td>11.55</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>Ord_3848</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_5335</td>\n",
       "      <td>Cust_1346</td>\n",
       "      <td>2660.6105</td>\n",
       "      <td>0.03</td>\n",
       "      <td>46</td>\n",
       "      <td>618.07</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>Ord_142</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_191</td>\n",
       "      <td>Cust_51</td>\n",
       "      <td>2689.4800</td>\n",
       "      <td>0.04</td>\n",
       "      <td>27</td>\n",
       "      <td>399.93</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536</th>\n",
       "      <td>Ord_4909</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_6846</td>\n",
       "      <td>Cust_227</td>\n",
       "      <td>2180.2300</td>\n",
       "      <td>0.05</td>\n",
       "      <td>37</td>\n",
       "      <td>660.25</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541</th>\n",
       "      <td>Ord_4935</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6886</td>\n",
       "      <td>Cust_1680</td>\n",
       "      <td>2292.1015</td>\n",
       "      <td>0.02</td>\n",
       "      <td>21</td>\n",
       "      <td>398.36</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>Ord_4292</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_5988</td>\n",
       "      <td>Cust_1439</td>\n",
       "      <td>2758.2200</td>\n",
       "      <td>0.00</td>\n",
       "      <td>15</td>\n",
       "      <td>966.81</td>\n",
       "      <td>13.99</td>\n",
       "      <td>0.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Ord_674</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_922</td>\n",
       "      <td>Cust_212</td>\n",
       "      <td>2404.5990</td>\n",
       "      <td>0.08</td>\n",
       "      <td>45</td>\n",
       "      <td>496.89</td>\n",
       "      <td>4.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>Ord_4904</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6841</td>\n",
       "      <td>Cust_1682</td>\n",
       "      <td>2257.8800</td>\n",
       "      <td>0.01</td>\n",
       "      <td>38</td>\n",
       "      <td>474.98</td>\n",
       "      <td>9.71</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>Ord_2069</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2832</td>\n",
       "      <td>Cust_783</td>\n",
       "      <td>2135.9735</td>\n",
       "      <td>0.07</td>\n",
       "      <td>40</td>\n",
       "      <td>239.40</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Ord_2150</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2932</td>\n",
       "      <td>Cust_805</td>\n",
       "      <td>2773.0315</td>\n",
       "      <td>0.04</td>\n",
       "      <td>38</td>\n",
       "      <td>897.87</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>Ord_4826</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_6724</td>\n",
       "      <td>Cust_1588</td>\n",
       "      <td>2168.0500</td>\n",
       "      <td>0.00</td>\n",
       "      <td>5</td>\n",
       "      <td>416.02</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>Ord_2054</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_2808</td>\n",
       "      <td>Cust_828</td>\n",
       "      <td>2192.6300</td>\n",
       "      <td>0.05</td>\n",
       "      <td>37</td>\n",
       "      <td>660.06</td>\n",
       "      <td>3.99</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>Ord_5154</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7204</td>\n",
       "      <td>Cust_1746</td>\n",
       "      <td>2610.8940</td>\n",
       "      <td>0.00</td>\n",
       "      <td>23</td>\n",
       "      <td>516.19</td>\n",
       "      <td>5.63</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>783</th>\n",
       "      <td>Ord_2666</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3652</td>\n",
       "      <td>Cust_1017</td>\n",
       "      <td>2368.1680</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30</td>\n",
       "      <td>1181.30</td>\n",
       "      <td>1.25</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>Ord_4279</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_5971</td>\n",
       "      <td>Cust_1440</td>\n",
       "      <td>2752.6800</td>\n",
       "      <td>0.04</td>\n",
       "      <td>45</td>\n",
       "      <td>430.32</td>\n",
       "      <td>12.78</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>Ord_4269</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_5958</td>\n",
       "      <td>Cust_1440</td>\n",
       "      <td>2405.0000</td>\n",
       "      <td>0.10</td>\n",
       "      <td>39</td>\n",
       "      <td>696.17</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7777</th>\n",
       "      <td>Ord_3414</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_4733</td>\n",
       "      <td>Cust_1196</td>\n",
       "      <td>2167.0500</td>\n",
       "      <td>0.02</td>\n",
       "      <td>36</td>\n",
       "      <td>684.90</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7778</th>\n",
       "      <td>Ord_3363</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_4663</td>\n",
       "      <td>Cust_1196</td>\n",
       "      <td>2040.3900</td>\n",
       "      <td>0.07</td>\n",
       "      <td>50</td>\n",
       "      <td>221.09</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>Ord_2482</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3399</td>\n",
       "      <td>Cust_977</td>\n",
       "      <td>2252.2620</td>\n",
       "      <td>0.10</td>\n",
       "      <td>42</td>\n",
       "      <td>478.11</td>\n",
       "      <td>5.63</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7811</th>\n",
       "      <td>Ord_3215</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4458</td>\n",
       "      <td>Cust_1188</td>\n",
       "      <td>2080.0350</td>\n",
       "      <td>0.10</td>\n",
       "      <td>31</td>\n",
       "      <td>844.90</td>\n",
       "      <td>1.25</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7823</th>\n",
       "      <td>Ord_4370</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_6092</td>\n",
       "      <td>Cust_1492</td>\n",
       "      <td>2325.4200</td>\n",
       "      <td>0.02</td>\n",
       "      <td>25</td>\n",
       "      <td>739.91</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7858</th>\n",
       "      <td>Ord_3232</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_4483</td>\n",
       "      <td>Cust_1200</td>\n",
       "      <td>2206.1700</td>\n",
       "      <td>0.02</td>\n",
       "      <td>4</td>\n",
       "      <td>251.43</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7875</th>\n",
       "      <td>Ord_1762</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_2443</td>\n",
       "      <td>Cust_577</td>\n",
       "      <td>2287.1000</td>\n",
       "      <td>0.07</td>\n",
       "      <td>23</td>\n",
       "      <td>231.49</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7877</th>\n",
       "      <td>Ord_1748</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2421</td>\n",
       "      <td>Cust_577</td>\n",
       "      <td>2503.3265</td>\n",
       "      <td>0.04</td>\n",
       "      <td>45</td>\n",
       "      <td>447.12</td>\n",
       "      <td>8.80</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7884</th>\n",
       "      <td>Ord_710</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_973</td>\n",
       "      <td>Cust_244</td>\n",
       "      <td>2529.3960</td>\n",
       "      <td>0.06</td>\n",
       "      <td>25</td>\n",
       "      <td>371.21</td>\n",
       "      <td>3.00</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7911</th>\n",
       "      <td>Ord_5012</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6993</td>\n",
       "      <td>Cust_1693</td>\n",
       "      <td>2882.7070</td>\n",
       "      <td>0.02</td>\n",
       "      <td>16</td>\n",
       "      <td>303.23</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7927</th>\n",
       "      <td>Ord_2502</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3430</td>\n",
       "      <td>Cust_976</td>\n",
       "      <td>2104.9910</td>\n",
       "      <td>0.09</td>\n",
       "      <td>20</td>\n",
       "      <td>165.45</td>\n",
       "      <td>8.80</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7940</th>\n",
       "      <td>Ord_3277</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4550</td>\n",
       "      <td>Cust_1224</td>\n",
       "      <td>2185.9535</td>\n",
       "      <td>0.10</td>\n",
       "      <td>21</td>\n",
       "      <td>268.01</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7973</th>\n",
       "      <td>Ord_1694</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_2346</td>\n",
       "      <td>Cust_582</td>\n",
       "      <td>2145.0500</td>\n",
       "      <td>0.07</td>\n",
       "      <td>45</td>\n",
       "      <td>1012.67</td>\n",
       "      <td>5.86</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7986</th>\n",
       "      <td>Ord_4788</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6674</td>\n",
       "      <td>Cust_1583</td>\n",
       "      <td>2478.4810</td>\n",
       "      <td>0.09</td>\n",
       "      <td>27</td>\n",
       "      <td>249.10</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8045</th>\n",
       "      <td>Ord_5443</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_7605</td>\n",
       "      <td>Cust_1803</td>\n",
       "      <td>2587.5300</td>\n",
       "      <td>0.02</td>\n",
       "      <td>44</td>\n",
       "      <td>401.85</td>\n",
       "      <td>6.55</td>\n",
       "      <td>0.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8048</th>\n",
       "      <td>Ord_796</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_1095</td>\n",
       "      <td>Cust_247</td>\n",
       "      <td>2780.8800</td>\n",
       "      <td>0.07</td>\n",
       "      <td>27</td>\n",
       "      <td>595.38</td>\n",
       "      <td>24.49</td>\n",
       "      <td>0.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8061</th>\n",
       "      <td>Ord_2020</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_3104</td>\n",
       "      <td>Cust_892</td>\n",
       "      <td>2550.1200</td>\n",
       "      <td>0.01</td>\n",
       "      <td>40</td>\n",
       "      <td>882.45</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8071</th>\n",
       "      <td>Ord_5350</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7473</td>\n",
       "      <td>Cust_1795</td>\n",
       "      <td>2750.1070</td>\n",
       "      <td>0.00</td>\n",
       "      <td>24</td>\n",
       "      <td>600.42</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8147</th>\n",
       "      <td>Ord_3214</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4457</td>\n",
       "      <td>Cust_1187</td>\n",
       "      <td>2143.2155</td>\n",
       "      <td>0.02</td>\n",
       "      <td>37</td>\n",
       "      <td>464.36</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8152</th>\n",
       "      <td>Ord_3337</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_4630</td>\n",
       "      <td>Cust_1187</td>\n",
       "      <td>2477.9900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>30</td>\n",
       "      <td>747.68</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8239</th>\n",
       "      <td>Ord_793</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_1089</td>\n",
       "      <td>Cust_245</td>\n",
       "      <td>2833.1900</td>\n",
       "      <td>0.06</td>\n",
       "      <td>34</td>\n",
       "      <td>1409.87</td>\n",
       "      <td>5.01</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8262</th>\n",
       "      <td>Ord_4954</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6914</td>\n",
       "      <td>Cust_1694</td>\n",
       "      <td>2455.2760</td>\n",
       "      <td>0.04</td>\n",
       "      <td>42</td>\n",
       "      <td>693.06</td>\n",
       "      <td>5.63</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8271</th>\n",
       "      <td>Ord_4679</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6528</td>\n",
       "      <td>Cust_1587</td>\n",
       "      <td>2823.0370</td>\n",
       "      <td>0.10</td>\n",
       "      <td>29</td>\n",
       "      <td>372.40</td>\n",
       "      <td>4.20</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8289</th>\n",
       "      <td>Ord_1749</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2422</td>\n",
       "      <td>Cust_595</td>\n",
       "      <td>2731.7300</td>\n",
       "      <td>0.07</td>\n",
       "      <td>21</td>\n",
       "      <td>310.59</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8304</th>\n",
       "      <td>Ord_2709</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_3709</td>\n",
       "      <td>Cust_1025</td>\n",
       "      <td>2272.5600</td>\n",
       "      <td>0.06</td>\n",
       "      <td>15</td>\n",
       "      <td>111.05</td>\n",
       "      <td>16.01</td>\n",
       "      <td>0.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8338</th>\n",
       "      <td>Ord_2107</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_2882</td>\n",
       "      <td>Cust_785</td>\n",
       "      <td>2409.9600</td>\n",
       "      <td>0.07</td>\n",
       "      <td>32</td>\n",
       "      <td>575.10</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8350</th>\n",
       "      <td>Ord_3570</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4942</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2094.9780</td>\n",
       "      <td>0.06</td>\n",
       "      <td>44</td>\n",
       "      <td>697.29</td>\n",
       "      <td>1.25</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8354</th>\n",
       "      <td>Ord_3592</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4973</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2614.3705</td>\n",
       "      <td>0.07</td>\n",
       "      <td>25</td>\n",
       "      <td>384.01</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8381</th>\n",
       "      <td>Ord_2696</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3691</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>2836.0505</td>\n",
       "      <td>0.01</td>\n",
       "      <td>25</td>\n",
       "      <td>561.13</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8394</th>\n",
       "      <td>Ord_5353</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7479</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>2841.4395</td>\n",
       "      <td>0.08</td>\n",
       "      <td>28</td>\n",
       "      <td>374.63</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>328 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Ord_id  Prod_id   Ship_id    Cust_id      Sales  Discount  \\\n",
       "3     Ord_5456   Prod_6  SHP_7625  Cust_1818  2337.8900      0.09   \n",
       "81    Ord_5205   Prod_4  SHP_7274  Cust_1749  2546.5235      0.09   \n",
       "109    Ord_139  Prod_17   SHP_186    Cust_45  2671.2100      0.06   \n",
       "110    Ord_239   Prod_4   SHP_332    Cust_45  2157.3085      0.00   \n",
       "141   Ord_1673  Prod_17  SHP_2314   Cust_498  2027.5500      0.04   \n",
       "146   Ord_1649   Prod_4  SHP_2278   Cust_498  2209.5155      0.06   \n",
       "176   Ord_2273   Prod_8  SHP_3101   Cust_878  2899.9800      0.10   \n",
       "184   Ord_5230   Prod_4  SHP_7304  Cust_1753  2197.4115      0.00   \n",
       "186   Ord_5159   Prod_5  SHP_7210  Cust_1753  2213.9200      0.03   \n",
       "230    Ord_657   Prod_4   SHP_899   Cust_209  2343.0760      0.06   \n",
       "285   Ord_1607   Prod_4  SHP_2220   Cust_506  2980.3720      0.02   \n",
       "314   Ord_1521  Prod_15  SHP_2100   Cust_560  2230.9700      0.06   \n",
       "349   Ord_4896   Prod_4  SHP_6829  Cust_1674  2827.1425      0.01   \n",
       "395   Ord_4144   Prod_2  SHP_5772  Cust_1418  2182.9100      0.10   \n",
       "404   Ord_1621   Prod_3  SHP_2238   Cust_566  2010.8900      0.09   \n",
       "510   Ord_3848   Prod_4  SHP_5335  Cust_1346  2660.6105      0.03   \n",
       "522    Ord_142   Prod_8   SHP_191    Cust_51  2689.4800      0.04   \n",
       "536   Ord_4909   Prod_2  SHP_6846   Cust_227  2180.2300      0.05   \n",
       "541   Ord_4935   Prod_4  SHP_6886  Cust_1680  2292.1015      0.02   \n",
       "647   Ord_4292   Prod_5  SHP_5988  Cust_1439  2758.2200      0.00   \n",
       "680    Ord_674   Prod_4   SHP_922   Cust_212  2404.5990      0.08   \n",
       "688   Ord_4904   Prod_1  SHP_6841  Cust_1682  2257.8800      0.01   \n",
       "718   Ord_2069   Prod_4  SHP_2832   Cust_783  2135.9735      0.07   \n",
       "720   Ord_2150   Prod_4  SHP_2932   Cust_805  2773.0315      0.04   \n",
       "729   Ord_4826   Prod_3  SHP_6724  Cust_1588  2168.0500      0.00   \n",
       "767   Ord_2054   Prod_2  SHP_2808   Cust_828  2192.6300      0.05   \n",
       "775   Ord_5154   Prod_4  SHP_7204  Cust_1746  2610.8940      0.00   \n",
       "783   Ord_2666   Prod_4  SHP_3652  Cust_1017  2368.1680      0.00   \n",
       "809   Ord_4279   Prod_1  SHP_5971  Cust_1440  2752.6800      0.04   \n",
       "810   Ord_4269   Prod_2  SHP_5958  Cust_1440  2405.0000      0.10   \n",
       "...        ...      ...       ...        ...        ...       ...   \n",
       "7777  Ord_3414   Prod_2  SHP_4733  Cust_1196  2167.0500      0.02   \n",
       "7778  Ord_3363   Prod_6  SHP_4663  Cust_1196  2040.3900      0.07   \n",
       "7788  Ord_2482   Prod_4  SHP_3399   Cust_977  2252.2620      0.10   \n",
       "7811  Ord_3215   Prod_4  SHP_4458  Cust_1188  2080.0350      0.10   \n",
       "7823  Ord_4370   Prod_9  SHP_6092  Cust_1492  2325.4200      0.02   \n",
       "7858  Ord_3232   Prod_3  SHP_4483  Cust_1200  2206.1700      0.02   \n",
       "7875  Ord_1762  Prod_17  SHP_2443   Cust_577  2287.1000      0.07   \n",
       "7877  Ord_1748   Prod_4  SHP_2421   Cust_577  2503.3265      0.04   \n",
       "7884   Ord_710   Prod_4   SHP_973   Cust_244  2529.3960      0.06   \n",
       "7911  Ord_5012   Prod_4  SHP_6993  Cust_1693  2882.7070      0.02   \n",
       "7927  Ord_2502   Prod_4  SHP_3430   Cust_976  2104.9910      0.09   \n",
       "7940  Ord_3277   Prod_4  SHP_4550  Cust_1224  2185.9535      0.10   \n",
       "7973  Ord_1694   Prod_6  SHP_2346   Cust_582  2145.0500      0.07   \n",
       "7986  Ord_4788   Prod_4  SHP_6674  Cust_1583  2478.4810      0.09   \n",
       "8045  Ord_5443   Prod_8  SHP_7605  Cust_1803  2587.5300      0.02   \n",
       "8048   Ord_796   Prod_5  SHP_1095   Cust_247  2780.8800      0.07   \n",
       "8061  Ord_2020   Prod_2  SHP_3104   Cust_892  2550.1200      0.01   \n",
       "8071  Ord_5350   Prod_4  SHP_7473  Cust_1795  2750.1070      0.00   \n",
       "8147  Ord_3214   Prod_4  SHP_4457  Cust_1187  2143.2155      0.02   \n",
       "8152  Ord_3337   Prod_2  SHP_4630  Cust_1187  2477.9900      0.00   \n",
       "8239   Ord_793   Prod_9  SHP_1089   Cust_245  2833.1900      0.06   \n",
       "8262  Ord_4954   Prod_4  SHP_6914  Cust_1694  2455.2760      0.04   \n",
       "8271  Ord_4679   Prod_4  SHP_6528  Cust_1587  2823.0370      0.10   \n",
       "8289  Ord_1749   Prod_4  SHP_2422   Cust_595  2731.7300      0.07   \n",
       "8304  Ord_2709  Prod_11  SHP_3709  Cust_1025  2272.5600      0.06   \n",
       "8338  Ord_2107   Prod_2  SHP_2882   Cust_785  2409.9600      0.07   \n",
       "8350  Ord_3570   Prod_4  SHP_4942  Cust_1266  2094.9780      0.06   \n",
       "8354  Ord_3592   Prod_4  SHP_4973  Cust_1266  2614.3705      0.07   \n",
       "8381  Ord_2696   Prod_4  SHP_3691  Cust_1006  2836.0505      0.01   \n",
       "8394  Ord_5353   Prod_4  SHP_7479  Cust_1798  2841.4395      0.08   \n",
       "\n",
       "      Order_Quantity   Profit  Shipping_Cost  Product_Base_Margin  \n",
       "3                 43   729.34          14.30                 0.37  \n",
       "81                26   210.00           7.69                 0.59  \n",
       "109               14   636.18          15.59                 0.36  \n",
       "110               38   519.25           5.31                 0.57  \n",
       "141               14   537.40          13.99                 0.37  \n",
       "146               41   458.62           5.31                 0.57  \n",
       "176               19   666.01           5.50                 0.49  \n",
       "184               20   305.96           7.69                 0.58  \n",
       "186               20   768.34          13.99                 0.65  \n",
       "230               24   311.64           8.99                 0.58  \n",
       "285               19   494.63           8.99                 0.57  \n",
       "314               12   273.27          26.20                 0.59  \n",
       "349               35   713.88           4.90                 0.56  \n",
       "395               40   549.45           3.50                 0.57  \n",
       "404               34   564.07          11.55                 0.38  \n",
       "510               46   618.07           8.99                 0.56  \n",
       "522               27   399.93          19.99                 0.50  \n",
       "536               37   660.25           3.50                 0.57  \n",
       "541               21   398.36           3.00                 0.59  \n",
       "647               15   966.81          13.99                 0.75  \n",
       "680               45   496.89           4.99                 0.58  \n",
       "688               38   474.98           9.71                 0.57  \n",
       "718               40   239.40           8.99                 0.59  \n",
       "720               38   897.87           0.99                 0.55  \n",
       "729                5   416.02          19.99                 0.35  \n",
       "767               37   660.06           3.99                 0.57  \n",
       "775               23   516.19           5.63                 0.60  \n",
       "783               30  1181.30           1.25                 0.39  \n",
       "809               45   430.32          12.78                 0.58  \n",
       "810               39   696.17           0.99                 0.58  \n",
       "...              ...      ...            ...                  ...  \n",
       "7777              36   684.90           3.50                 0.57  \n",
       "7778              50   221.09          19.99                 0.36  \n",
       "7788              42   478.11           5.63                 0.56  \n",
       "7811              31   844.90           1.25                 0.39  \n",
       "7823              25   739.91          19.99                 0.40  \n",
       "7858               4   251.43          19.99                 0.37  \n",
       "7875              23   231.49          19.99                 0.52  \n",
       "7877              45   447.12           8.80                 0.58  \n",
       "7884              25   371.21           3.00                 0.59  \n",
       "7911              16   303.23           5.00                 0.59  \n",
       "7927              20   165.45           8.80                 0.59  \n",
       "7940              21   268.01           8.99                 0.55  \n",
       "7973              45  1012.67           5.86                 0.35  \n",
       "7986              27   249.10           8.99                 0.58  \n",
       "8045              44   401.85           6.55                 0.68  \n",
       "8048              27   595.38          24.49                 0.61  \n",
       "8061              40   882.45           4.50                 0.56  \n",
       "8071              24   600.42           7.69                 0.58  \n",
       "8147              37   464.36           8.99                 0.55  \n",
       "8152              30   747.68           4.50                 0.59  \n",
       "8239              34  1409.87           5.01                 0.38  \n",
       "8262              42   693.06           5.63                 0.56  \n",
       "8271              29   372.40           4.20                 0.59  \n",
       "8289              21   310.59           8.99                 0.58  \n",
       "8304              15   111.05          16.01                 0.70  \n",
       "8338              32   575.10           4.50                 0.59  \n",
       "8350              44   697.29           1.25                 0.55  \n",
       "8354              25   384.01           7.69                 0.58  \n",
       "8381              25   561.13           8.99                 0.59  \n",
       "8394              28   374.63           7.69                 0.59  \n",
       "\n",
       "[328 rows x 10 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We combine multiple conditions using the & operator\n",
    "# E.g. all orders having 2000 < Sales < 3000 and Profit > 100\n",
    "df.loc[(df.Sales > 2000) & (df.Sales < 3000) & (df.Profit > 100), :]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Ord_id</th>\n",
       "      <th>Prod_id</th>\n",
       "      <th>Ship_id</th>\n",
       "      <th>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Order_Quantity</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Product_Base_Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7610</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4701.6900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "      <td>1148.90</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ord_5456</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7625</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>2337.8900</td>\n",
       "      <td>0.09</td>\n",
       "      <td>43</td>\n",
       "      <td>729.34</td>\n",
       "      <td>14.30</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ord_5485</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7664</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4233.1500</td>\n",
       "      <td>0.08</td>\n",
       "      <td>35</td>\n",
       "      <td>1219.87</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ord_4725</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6593</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>3410.1575</td>\n",
       "      <td>0.10</td>\n",
       "      <td>48</td>\n",
       "      <td>1137.91</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ord_4743</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_6615</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>4072.0100</td>\n",
       "      <td>0.01</td>\n",
       "      <td>43</td>\n",
       "      <td>1675.98</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ord_2207</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_3093</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>3364.2480</td>\n",
       "      <td>0.10</td>\n",
       "      <td>15</td>\n",
       "      <td>-693.23</td>\n",
       "      <td>61.76</td>\n",
       "      <td>0.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Ord_2282</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_3122</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>443.4600</td>\n",
       "      <td>0.06</td>\n",
       "      <td>30</td>\n",
       "      <td>193.12</td>\n",
       "      <td>1.39</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ord_4471</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6228</td>\n",
       "      <td>Cust_1521</td>\n",
       "      <td>13255.9300</td>\n",
       "      <td>0.02</td>\n",
       "      <td>25</td>\n",
       "      <td>4089.27</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_1377</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>3202.2500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>44</td>\n",
       "      <td>991.26</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Ord_2405</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_3300</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>1062.6900</td>\n",
       "      <td>0.01</td>\n",
       "      <td>28</td>\n",
       "      <td>401.80</td>\n",
       "      <td>6.66</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ord_2573</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3527</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>3594.7435</td>\n",
       "      <td>0.05</td>\n",
       "      <td>38</td>\n",
       "      <td>1016.97</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Ord_5040</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_7032</td>\n",
       "      <td>Cust_1710</td>\n",
       "      <td>1637.7800</td>\n",
       "      <td>0.08</td>\n",
       "      <td>38</td>\n",
       "      <td>461.65</td>\n",
       "      <td>4.62</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Ord_5035</td>\n",
       "      <td>Prod_12</td>\n",
       "      <td>SHP_7025</td>\n",
       "      <td>Cust_1710</td>\n",
       "      <td>416.8000</td>\n",
       "      <td>0.01</td>\n",
       "      <td>32</td>\n",
       "      <td>223.38</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Ord_5045</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_7040</td>\n",
       "      <td>Cust_1710</td>\n",
       "      <td>1286.8700</td>\n",
       "      <td>0.05</td>\n",
       "      <td>48</td>\n",
       "      <td>384.38</td>\n",
       "      <td>6.93</td>\n",
       "      <td>0.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Ord_5035</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7024</td>\n",
       "      <td>Cust_1710</td>\n",
       "      <td>4917.6900</td>\n",
       "      <td>0.02</td>\n",
       "      <td>42</td>\n",
       "      <td>126.31</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>Ord_4659</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_6493</td>\n",
       "      <td>Cust_1579</td>\n",
       "      <td>1451.5900</td>\n",
       "      <td>0.06</td>\n",
       "      <td>26</td>\n",
       "      <td>435.11</td>\n",
       "      <td>14.30</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Ord_4682</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6531</td>\n",
       "      <td>Cust_1579</td>\n",
       "      <td>1909.0065</td>\n",
       "      <td>0.01</td>\n",
       "      <td>32</td>\n",
       "      <td>344.13</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>Ord_4410</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_6146</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>605.7700</td>\n",
       "      <td>0.05</td>\n",
       "      <td>42</td>\n",
       "      <td>129.33</td>\n",
       "      <td>5.00</td>\n",
       "      <td>0.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Ord_4546</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6327</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>5208.7800</td>\n",
       "      <td>0.05</td>\n",
       "      <td>34</td>\n",
       "      <td>1547.78</td>\n",
       "      <td>7.07</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>Ord_4410</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_6146</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>1480.9100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44</td>\n",
       "      <td>489.14</td>\n",
       "      <td>8.74</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>Ord_4475</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6234</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>7640.2250</td>\n",
       "      <td>0.07</td>\n",
       "      <td>46</td>\n",
       "      <td>2027.68</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Ord_4607</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_6408</td>\n",
       "      <td>Cust_1474</td>\n",
       "      <td>1463.4200</td>\n",
       "      <td>0.08</td>\n",
       "      <td>26</td>\n",
       "      <td>350.82</td>\n",
       "      <td>3.99</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Ord_5213</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_7284</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>1633.3700</td>\n",
       "      <td>0.08</td>\n",
       "      <td>50</td>\n",
       "      <td>144.69</td>\n",
       "      <td>7.73</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Ord_5188</td>\n",
       "      <td>Prod_14</td>\n",
       "      <td>SHP_7252</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>5177.4000</td>\n",
       "      <td>0.06</td>\n",
       "      <td>12</td>\n",
       "      <td>287.50</td>\n",
       "      <td>49.00</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Ord_5205</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7274</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>2546.5235</td>\n",
       "      <td>0.09</td>\n",
       "      <td>26</td>\n",
       "      <td>210.00</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Ord_5156</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7207</td>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>8374.1320</td>\n",
       "      <td>0.06</td>\n",
       "      <td>48</td>\n",
       "      <td>2568.10</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>Ord_5232</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7306</td>\n",
       "      <td>Cust_1758</td>\n",
       "      <td>21366.5100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>3</td>\n",
       "      <td>-11984.40</td>\n",
       "      <td>24.49</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Ord_5172</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7229</td>\n",
       "      <td>Cust_1758</td>\n",
       "      <td>1239.4445</td>\n",
       "      <td>0.07</td>\n",
       "      <td>22</td>\n",
       "      <td>165.50</td>\n",
       "      <td>3.99</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Ord_5481</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7659</td>\n",
       "      <td>Cust_1820</td>\n",
       "      <td>2700.7800</td>\n",
       "      <td>0.06</td>\n",
       "      <td>29</td>\n",
       "      <td>-793.36</td>\n",
       "      <td>58.20</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Ord_1557</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_2152</td>\n",
       "      <td>Cust_565</td>\n",
       "      <td>1736.5300</td>\n",
       "      <td>0.10</td>\n",
       "      <td>46</td>\n",
       "      <td>457.03</td>\n",
       "      <td>3.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8328</th>\n",
       "      <td>Ord_2169</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_2956</td>\n",
       "      <td>Cust_810</td>\n",
       "      <td>1321.5500</td>\n",
       "      <td>0.10</td>\n",
       "      <td>25</td>\n",
       "      <td>448.24</td>\n",
       "      <td>10.75</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8329</th>\n",
       "      <td>Ord_2160</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_2944</td>\n",
       "      <td>Cust_810</td>\n",
       "      <td>3636.3700</td>\n",
       "      <td>0.06</td>\n",
       "      <td>33</td>\n",
       "      <td>-176.91</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8331</th>\n",
       "      <td>Ord_2148</td>\n",
       "      <td>Prod_10</td>\n",
       "      <td>SHP_2929</td>\n",
       "      <td>Cust_810</td>\n",
       "      <td>2966.1300</td>\n",
       "      <td>0.08</td>\n",
       "      <td>31</td>\n",
       "      <td>-1456.31</td>\n",
       "      <td>57.38</td>\n",
       "      <td>0.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8332</th>\n",
       "      <td>Ord_2101</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2875</td>\n",
       "      <td>Cust_790</td>\n",
       "      <td>10714.7800</td>\n",
       "      <td>0.00</td>\n",
       "      <td>41</td>\n",
       "      <td>-627.64</td>\n",
       "      <td>66.67</td>\n",
       "      <td>0.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8334</th>\n",
       "      <td>Ord_2124</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_2900</td>\n",
       "      <td>Cust_790</td>\n",
       "      <td>926.8500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>34</td>\n",
       "      <td>382.94</td>\n",
       "      <td>1.49</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8335</th>\n",
       "      <td>Ord_2070</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_2833</td>\n",
       "      <td>Cust_784</td>\n",
       "      <td>3905.7500</td>\n",
       "      <td>0.01</td>\n",
       "      <td>21</td>\n",
       "      <td>55.30</td>\n",
       "      <td>29.21</td>\n",
       "      <td>0.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8338</th>\n",
       "      <td>Ord_2107</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_2882</td>\n",
       "      <td>Cust_785</td>\n",
       "      <td>2409.9600</td>\n",
       "      <td>0.07</td>\n",
       "      <td>32</td>\n",
       "      <td>575.10</td>\n",
       "      <td>4.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8342</th>\n",
       "      <td>Ord_2119</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_2895</td>\n",
       "      <td>Cust_785</td>\n",
       "      <td>1623.0900</td>\n",
       "      <td>0.02</td>\n",
       "      <td>28</td>\n",
       "      <td>245.88</td>\n",
       "      <td>13.22</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8343</th>\n",
       "      <td>Ord_2178</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_2968</td>\n",
       "      <td>Cust_785</td>\n",
       "      <td>6030.5800</td>\n",
       "      <td>0.09</td>\n",
       "      <td>39</td>\n",
       "      <td>1197.86</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8344</th>\n",
       "      <td>Ord_2194</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_2991</td>\n",
       "      <td>Cust_785</td>\n",
       "      <td>525.7800</td>\n",
       "      <td>0.03</td>\n",
       "      <td>20</td>\n",
       "      <td>180.64</td>\n",
       "      <td>6.93</td>\n",
       "      <td>0.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8347</th>\n",
       "      <td>Ord_3534</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4894</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>1735.3515</td>\n",
       "      <td>0.08</td>\n",
       "      <td>31</td>\n",
       "      <td>258.62</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8350</th>\n",
       "      <td>Ord_3570</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4942</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2094.9780</td>\n",
       "      <td>0.06</td>\n",
       "      <td>44</td>\n",
       "      <td>697.29</td>\n",
       "      <td>1.25</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8351</th>\n",
       "      <td>Ord_3584</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4961</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2502.6700</td>\n",
       "      <td>0.10</td>\n",
       "      <td>9</td>\n",
       "      <td>-198.80</td>\n",
       "      <td>64.73</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8354</th>\n",
       "      <td>Ord_3592</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_4973</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2614.3705</td>\n",
       "      <td>0.07</td>\n",
       "      <td>25</td>\n",
       "      <td>384.01</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8358</th>\n",
       "      <td>Ord_3582</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_4959</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>539.6600</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "      <td>147.08</td>\n",
       "      <td>5.97</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8359</th>\n",
       "      <td>Ord_3543</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_4906</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>514.2200</td>\n",
       "      <td>0.02</td>\n",
       "      <td>17</td>\n",
       "      <td>187.37</td>\n",
       "      <td>2.99</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8360</th>\n",
       "      <td>Ord_3639</td>\n",
       "      <td>Prod_10</td>\n",
       "      <td>SHP_5038</td>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2173.2600</td>\n",
       "      <td>0.00</td>\n",
       "      <td>35</td>\n",
       "      <td>-465.66</td>\n",
       "      <td>36.61</td>\n",
       "      <td>0.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8362</th>\n",
       "      <td>Ord_3593</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_4975</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>1175.5300</td>\n",
       "      <td>0.03</td>\n",
       "      <td>18</td>\n",
       "      <td>257.59</td>\n",
       "      <td>14.48</td>\n",
       "      <td>0.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8366</th>\n",
       "      <td>Ord_3593</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_4974</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>12073.0600</td>\n",
       "      <td>0.03</td>\n",
       "      <td>39</td>\n",
       "      <td>5081.87</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8367</th>\n",
       "      <td>Ord_3593</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_4975</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>6685.0500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>25</td>\n",
       "      <td>1653.60</td>\n",
       "      <td>24.49</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8369</th>\n",
       "      <td>Ord_3633</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_5031</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>1169.2600</td>\n",
       "      <td>0.02</td>\n",
       "      <td>41</td>\n",
       "      <td>515.62</td>\n",
       "      <td>1.49</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8371</th>\n",
       "      <td>Ord_2624</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3591</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>4924.1350</td>\n",
       "      <td>0.07</td>\n",
       "      <td>28</td>\n",
       "      <td>1049.54</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8375</th>\n",
       "      <td>Ord_2772</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3806</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>1413.8200</td>\n",
       "      <td>0.10</td>\n",
       "      <td>47</td>\n",
       "      <td>226.53</td>\n",
       "      <td>11.63</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8378</th>\n",
       "      <td>Ord_2706</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_3705</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>1361.9100</td>\n",
       "      <td>0.05</td>\n",
       "      <td>20</td>\n",
       "      <td>312.52</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8381</th>\n",
       "      <td>Ord_2696</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3691</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>2836.0505</td>\n",
       "      <td>0.01</td>\n",
       "      <td>25</td>\n",
       "      <td>561.13</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8383</th>\n",
       "      <td>Ord_2722</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_3731</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>3508.3300</td>\n",
       "      <td>0.04</td>\n",
       "      <td>21</td>\n",
       "      <td>-546.98</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8385</th>\n",
       "      <td>Ord_1833</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_2527</td>\n",
       "      <td>Cust_637</td>\n",
       "      <td>611.1600</td>\n",
       "      <td>0.04</td>\n",
       "      <td>46</td>\n",
       "      <td>100.22</td>\n",
       "      <td>4.98</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8394</th>\n",
       "      <td>Ord_5353</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7479</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>2841.4395</td>\n",
       "      <td>0.08</td>\n",
       "      <td>28</td>\n",
       "      <td>374.63</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8397</th>\n",
       "      <td>Ord_5348</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7469</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>3872.8700</td>\n",
       "      <td>0.03</td>\n",
       "      <td>23</td>\n",
       "      <td>565.34</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8398</th>\n",
       "      <td>Ord_5459</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7628</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>603.6900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47</td>\n",
       "      <td>131.39</td>\n",
       "      <td>4.86</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3009 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Ord_id  Prod_id   Ship_id    Cust_id       Sales  Discount  \\\n",
       "2     Ord_5446   Prod_4  SHP_7610  Cust_1818   4701.6900      0.00   \n",
       "3     Ord_5456   Prod_6  SHP_7625  Cust_1818   2337.8900      0.09   \n",
       "4     Ord_5485  Prod_17  SHP_7664  Cust_1818   4233.1500      0.08   \n",
       "7     Ord_4725   Prod_4  SHP_6593  Cust_1641   3410.1575      0.10   \n",
       "10    Ord_4743   Prod_2  SHP_6615  Cust_1641   4072.0100      0.01   \n",
       "13    Ord_2207  Prod_11  SHP_3093   Cust_839   3364.2480      0.10   \n",
       "16    Ord_2282   Prod_9  SHP_3122   Cust_839    443.4600      0.06   \n",
       "17    Ord_4471  Prod_15  SHP_6228  Cust_1521  13255.9300      0.02   \n",
       "22     Ord_996   Prod_5  SHP_1377   Cust_371   3202.2500      0.09   \n",
       "27    Ord_2405   Prod_9  SHP_3300   Cust_931   1062.6900      0.01   \n",
       "28    Ord_2573   Prod_4  SHP_3527   Cust_931   3594.7435      0.05   \n",
       "37    Ord_5040   Prod_2  SHP_7032  Cust_1710   1637.7800      0.08   \n",
       "38    Ord_5035  Prod_12  SHP_7025  Cust_1710    416.8000      0.01   \n",
       "39    Ord_5045   Prod_5  SHP_7040  Cust_1710   1286.8700      0.05   \n",
       "40    Ord_5035  Prod_15  SHP_7024  Cust_1710   4917.6900      0.02   \n",
       "47    Ord_4659   Prod_6  SHP_6493  Cust_1579   1451.5900      0.06   \n",
       "54    Ord_4682   Prod_4  SHP_6531  Cust_1579   1909.0065      0.01   \n",
       "56    Ord_4410   Prod_5  SHP_6146  Cust_1474    605.7700      0.05   \n",
       "57    Ord_4546   Prod_1  SHP_6327  Cust_1474   5208.7800      0.05   \n",
       "62    Ord_4410   Prod_6  SHP_6146  Cust_1474   1480.9100      0.00   \n",
       "64    Ord_4475   Prod_4  SHP_6234  Cust_1474   7640.2250      0.07   \n",
       "70    Ord_4607   Prod_2  SHP_6408  Cust_1474   1463.4200      0.08   \n",
       "77    Ord_5213  Prod_13  SHP_7284  Cust_1749   1633.3700      0.08   \n",
       "79    Ord_5188  Prod_14  SHP_7252  Cust_1749   5177.4000      0.06   \n",
       "81    Ord_5205   Prod_4  SHP_7274  Cust_1749   2546.5235      0.09   \n",
       "82    Ord_5156   Prod_4  SHP_7207  Cust_1749   8374.1320      0.06   \n",
       "84    Ord_5232  Prod_17  SHP_7306  Cust_1758  21366.5100      0.00   \n",
       "88    Ord_5172   Prod_4  SHP_7229  Cust_1758   1239.4445      0.07   \n",
       "98    Ord_5481  Prod_15  SHP_7659  Cust_1820   2700.7800      0.06   \n",
       "102   Ord_1557   Prod_2  SHP_2152   Cust_565   1736.5300      0.10   \n",
       "...        ...      ...       ...        ...         ...       ...   \n",
       "8328  Ord_2169   Prod_6  SHP_2956   Cust_810   1321.5500      0.10   \n",
       "8329  Ord_2160  Prod_15  SHP_2944   Cust_810   3636.3700      0.06   \n",
       "8331  Ord_2148  Prod_10  SHP_2929   Cust_810   2966.1300      0.08   \n",
       "8332  Ord_2101  Prod_11  SHP_2875   Cust_790  10714.7800      0.00   \n",
       "8334  Ord_2124   Prod_3  SHP_2900   Cust_790    926.8500      0.09   \n",
       "8335  Ord_2070  Prod_11  SHP_2833   Cust_784   3905.7500      0.01   \n",
       "8338  Ord_2107   Prod_2  SHP_2882   Cust_785   2409.9600      0.07   \n",
       "8342  Ord_2119   Prod_2  SHP_2895   Cust_785   1623.0900      0.02   \n",
       "8343  Ord_2178   Prod_4  SHP_2968   Cust_785   6030.5800      0.09   \n",
       "8344  Ord_2194   Prod_5  SHP_2991   Cust_785    525.7800      0.03   \n",
       "8347  Ord_3534   Prod_4  SHP_4894  Cust_1266   1735.3515      0.08   \n",
       "8350  Ord_3570   Prod_4  SHP_4942  Cust_1266   2094.9780      0.06   \n",
       "8351  Ord_3584  Prod_15  SHP_4961  Cust_1266   2502.6700      0.10   \n",
       "8354  Ord_3592   Prod_4  SHP_4973  Cust_1266   2614.3705      0.07   \n",
       "8358  Ord_3582   Prod_6  SHP_4959  Cust_1266    539.6600      0.00   \n",
       "8359  Ord_3543   Prod_3  SHP_4906  Cust_1266    514.2200      0.02   \n",
       "8360  Ord_3639  Prod_10  SHP_5038  Cust_1266   2173.2600      0.00   \n",
       "8362  Ord_3593   Prod_5  SHP_4975  Cust_1274   1175.5300      0.03   \n",
       "8366  Ord_3593   Prod_3  SHP_4974  Cust_1274  12073.0600      0.03   \n",
       "8367  Ord_3593  Prod_15  SHP_4975  Cust_1274   6685.0500      0.09   \n",
       "8369  Ord_3633   Prod_3  SHP_5031  Cust_1274   1169.2600      0.02   \n",
       "8371  Ord_2624   Prod_4  SHP_3591  Cust_1006   4924.1350      0.07   \n",
       "8375  Ord_2772   Prod_3  SHP_3806  Cust_1006   1413.8200      0.10   \n",
       "8378  Ord_2706   Prod_2  SHP_3705  Cust_1006   1361.9100      0.05   \n",
       "8381  Ord_2696   Prod_4  SHP_3691  Cust_1006   2836.0505      0.01   \n",
       "8383  Ord_2722   Prod_1  SHP_3731  Cust_1006   3508.3300      0.04   \n",
       "8385  Ord_1833   Prod_3  SHP_2527   Cust_637    611.1600      0.04   \n",
       "8394  Ord_5353   Prod_4  SHP_7479  Cust_1798   2841.4395      0.08   \n",
       "8397  Ord_5348  Prod_15  SHP_7469  Cust_1798   3872.8700      0.03   \n",
       "8398  Ord_5459   Prod_6  SHP_7628  Cust_1798    603.6900      0.00   \n",
       "\n",
       "      Order_Quantity    Profit  Shipping_Cost  Product_Base_Margin  \n",
       "2                 26   1148.90           2.50                 0.59  \n",
       "3                 43    729.34          14.30                 0.37  \n",
       "4                 35   1219.87          26.30                 0.38  \n",
       "7                 48   1137.91           0.99                 0.55  \n",
       "10                43   1675.98           0.99                 0.56  \n",
       "13                15   -693.23          61.76                 0.78  \n",
       "16                30    193.12           1.39                 0.38  \n",
       "17                25   4089.27          26.00                 0.60  \n",
       "22                44    991.26          19.99                 0.43  \n",
       "27                28    401.80           6.66                 0.40  \n",
       "28                38   1016.97           2.50                 0.55  \n",
       "37                38    461.65           4.62                 0.56  \n",
       "38                32    223.38           0.50                 0.38  \n",
       "39                48    384.38           6.93                 0.49  \n",
       "40                42    126.31          30.00                 0.71  \n",
       "47                26    435.11          14.30                 0.37  \n",
       "54                32    344.13           8.99                 0.59  \n",
       "56                42    129.33           5.00                 0.49  \n",
       "57                34   1547.78           7.07                 0.59  \n",
       "62                44    489.14           8.74                 0.40  \n",
       "64                46   2027.68           2.50                 0.59  \n",
       "70                26    350.82           3.99                 0.57  \n",
       "77                50    144.69           7.73                 0.59  \n",
       "79                12    287.50          49.00                 0.38  \n",
       "81                26    210.00           7.69                 0.59  \n",
       "82                48   2568.10           8.99                 0.56  \n",
       "84                 3 -11984.40          24.49                 0.39  \n",
       "88                22    165.50           3.99                 0.59  \n",
       "98                29   -793.36          58.20                 0.58  \n",
       "102               46    457.03           3.99                 0.56  \n",
       "...              ...       ...            ...                  ...  \n",
       "8328              25    448.24          10.75                 0.36  \n",
       "8329              33   -176.91          30.00                 0.69  \n",
       "8331              31  -1456.31          57.38                 0.78  \n",
       "8332              41   -627.64          66.67                 0.65  \n",
       "8334              34    382.94           1.49                 0.38  \n",
       "8335              21     55.30          29.21                 0.76  \n",
       "8338              32    575.10           4.50                 0.59  \n",
       "8342              28    245.88          13.22                 0.56  \n",
       "8343              39   1197.86           8.99                 0.58  \n",
       "8344              20    180.64           6.93                 0.49  \n",
       "8347              31    258.62           8.99                 0.56  \n",
       "8350              44    697.29           1.25                 0.55  \n",
       "8351               9   -198.80          64.73                 0.56  \n",
       "8354              25    384.01           7.69                 0.58  \n",
       "8358              26    147.08           5.97                 0.38  \n",
       "8359              17    187.37           2.99                 0.35  \n",
       "8360              35   -465.66          36.61                 0.61  \n",
       "8362              18    257.59          14.48                 0.46  \n",
       "8366              39   5081.87          19.99                 0.38  \n",
       "8367              25   1653.60          24.49                  NaN  \n",
       "8369              41    515.62           1.49                 0.38  \n",
       "8371              28   1049.54           8.99                 0.58  \n",
       "8375              47    226.53          11.63                 0.37  \n",
       "8378              20    312.52           3.50                 0.59  \n",
       "8381              25    561.13           8.99                 0.59  \n",
       "8383              21   -546.98          35.00                 0.85  \n",
       "8385              46    100.22           4.98                 0.40  \n",
       "8394              28    374.63           7.69                 0.59  \n",
       "8397              23    565.34          30.00                 0.62  \n",
       "8398              47    131.39           4.86                 0.38  \n",
       "\n",
       "[3009 rows x 10 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# The 'OR' operator is represented by a | (Note that 'or' doesn't work with pandas)\n",
    "# E.g. all orders having 2000 < Sales  OR Profit > 100\n",
    "df.loc[(df.Sales > 2000) | (df.Profit > 100), :]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Profit</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>2337.8900</td>\n",
       "      <td>729.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>Cust_1749</td>\n",
       "      <td>2546.5235</td>\n",
       "      <td>210.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Cust_45</td>\n",
       "      <td>2671.2100</td>\n",
       "      <td>636.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>Cust_45</td>\n",
       "      <td>2157.3085</td>\n",
       "      <td>519.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>141</th>\n",
       "      <td>Cust_498</td>\n",
       "      <td>2027.5500</td>\n",
       "      <td>537.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>Cust_498</td>\n",
       "      <td>2209.5155</td>\n",
       "      <td>458.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>Cust_878</td>\n",
       "      <td>2899.9800</td>\n",
       "      <td>666.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>2197.4115</td>\n",
       "      <td>305.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>Cust_1753</td>\n",
       "      <td>2213.9200</td>\n",
       "      <td>768.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>Cust_209</td>\n",
       "      <td>2343.0760</td>\n",
       "      <td>311.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>285</th>\n",
       "      <td>Cust_506</td>\n",
       "      <td>2980.3720</td>\n",
       "      <td>494.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>314</th>\n",
       "      <td>Cust_560</td>\n",
       "      <td>2230.9700</td>\n",
       "      <td>273.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>349</th>\n",
       "      <td>Cust_1674</td>\n",
       "      <td>2827.1425</td>\n",
       "      <td>713.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>395</th>\n",
       "      <td>Cust_1418</td>\n",
       "      <td>2182.9100</td>\n",
       "      <td>549.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>404</th>\n",
       "      <td>Cust_566</td>\n",
       "      <td>2010.8900</td>\n",
       "      <td>564.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>510</th>\n",
       "      <td>Cust_1346</td>\n",
       "      <td>2660.6105</td>\n",
       "      <td>618.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>522</th>\n",
       "      <td>Cust_51</td>\n",
       "      <td>2689.4800</td>\n",
       "      <td>399.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>536</th>\n",
       "      <td>Cust_227</td>\n",
       "      <td>2180.2300</td>\n",
       "      <td>660.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>541</th>\n",
       "      <td>Cust_1680</td>\n",
       "      <td>2292.1015</td>\n",
       "      <td>398.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>647</th>\n",
       "      <td>Cust_1439</td>\n",
       "      <td>2758.2200</td>\n",
       "      <td>966.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Cust_212</td>\n",
       "      <td>2404.5990</td>\n",
       "      <td>496.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>688</th>\n",
       "      <td>Cust_1682</td>\n",
       "      <td>2257.8800</td>\n",
       "      <td>474.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>718</th>\n",
       "      <td>Cust_783</td>\n",
       "      <td>2135.9735</td>\n",
       "      <td>239.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>720</th>\n",
       "      <td>Cust_805</td>\n",
       "      <td>2773.0315</td>\n",
       "      <td>897.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>729</th>\n",
       "      <td>Cust_1588</td>\n",
       "      <td>2168.0500</td>\n",
       "      <td>416.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>Cust_828</td>\n",
       "      <td>2192.6300</td>\n",
       "      <td>660.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>Cust_1746</td>\n",
       "      <td>2610.8940</td>\n",
       "      <td>516.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>783</th>\n",
       "      <td>Cust_1017</td>\n",
       "      <td>2368.1680</td>\n",
       "      <td>1181.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809</th>\n",
       "      <td>Cust_1440</td>\n",
       "      <td>2752.6800</td>\n",
       "      <td>430.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>810</th>\n",
       "      <td>Cust_1440</td>\n",
       "      <td>2405.0000</td>\n",
       "      <td>696.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7777</th>\n",
       "      <td>Cust_1196</td>\n",
       "      <td>2167.0500</td>\n",
       "      <td>684.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7778</th>\n",
       "      <td>Cust_1196</td>\n",
       "      <td>2040.3900</td>\n",
       "      <td>221.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7788</th>\n",
       "      <td>Cust_977</td>\n",
       "      <td>2252.2620</td>\n",
       "      <td>478.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7811</th>\n",
       "      <td>Cust_1188</td>\n",
       "      <td>2080.0350</td>\n",
       "      <td>844.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7823</th>\n",
       "      <td>Cust_1492</td>\n",
       "      <td>2325.4200</td>\n",
       "      <td>739.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7858</th>\n",
       "      <td>Cust_1200</td>\n",
       "      <td>2206.1700</td>\n",
       "      <td>251.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7875</th>\n",
       "      <td>Cust_577</td>\n",
       "      <td>2287.1000</td>\n",
       "      <td>231.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7877</th>\n",
       "      <td>Cust_577</td>\n",
       "      <td>2503.3265</td>\n",
       "      <td>447.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7884</th>\n",
       "      <td>Cust_244</td>\n",
       "      <td>2529.3960</td>\n",
       "      <td>371.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7911</th>\n",
       "      <td>Cust_1693</td>\n",
       "      <td>2882.7070</td>\n",
       "      <td>303.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7927</th>\n",
       "      <td>Cust_976</td>\n",
       "      <td>2104.9910</td>\n",
       "      <td>165.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7940</th>\n",
       "      <td>Cust_1224</td>\n",
       "      <td>2185.9535</td>\n",
       "      <td>268.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7973</th>\n",
       "      <td>Cust_582</td>\n",
       "      <td>2145.0500</td>\n",
       "      <td>1012.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7986</th>\n",
       "      <td>Cust_1583</td>\n",
       "      <td>2478.4810</td>\n",
       "      <td>249.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8045</th>\n",
       "      <td>Cust_1803</td>\n",
       "      <td>2587.5300</td>\n",
       "      <td>401.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8048</th>\n",
       "      <td>Cust_247</td>\n",
       "      <td>2780.8800</td>\n",
       "      <td>595.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8061</th>\n",
       "      <td>Cust_892</td>\n",
       "      <td>2550.1200</td>\n",
       "      <td>882.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8071</th>\n",
       "      <td>Cust_1795</td>\n",
       "      <td>2750.1070</td>\n",
       "      <td>600.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8147</th>\n",
       "      <td>Cust_1187</td>\n",
       "      <td>2143.2155</td>\n",
       "      <td>464.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8152</th>\n",
       "      <td>Cust_1187</td>\n",
       "      <td>2477.9900</td>\n",
       "      <td>747.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8239</th>\n",
       "      <td>Cust_245</td>\n",
       "      <td>2833.1900</td>\n",
       "      <td>1409.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8262</th>\n",
       "      <td>Cust_1694</td>\n",
       "      <td>2455.2760</td>\n",
       "      <td>693.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8271</th>\n",
       "      <td>Cust_1587</td>\n",
       "      <td>2823.0370</td>\n",
       "      <td>372.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8289</th>\n",
       "      <td>Cust_595</td>\n",
       "      <td>2731.7300</td>\n",
       "      <td>310.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8304</th>\n",
       "      <td>Cust_1025</td>\n",
       "      <td>2272.5600</td>\n",
       "      <td>111.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8338</th>\n",
       "      <td>Cust_785</td>\n",
       "      <td>2409.9600</td>\n",
       "      <td>575.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8350</th>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2094.9780</td>\n",
       "      <td>697.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8354</th>\n",
       "      <td>Cust_1266</td>\n",
       "      <td>2614.3705</td>\n",
       "      <td>384.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8381</th>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>2836.0505</td>\n",
       "      <td>561.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8394</th>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>2841.4395</td>\n",
       "      <td>374.63</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>328 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Cust_id      Sales   Profit\n",
       "3     Cust_1818  2337.8900   729.34\n",
       "81    Cust_1749  2546.5235   210.00\n",
       "109     Cust_45  2671.2100   636.18\n",
       "110     Cust_45  2157.3085   519.25\n",
       "141    Cust_498  2027.5500   537.40\n",
       "146    Cust_498  2209.5155   458.62\n",
       "176    Cust_878  2899.9800   666.01\n",
       "184   Cust_1753  2197.4115   305.96\n",
       "186   Cust_1753  2213.9200   768.34\n",
       "230    Cust_209  2343.0760   311.64\n",
       "285    Cust_506  2980.3720   494.63\n",
       "314    Cust_560  2230.9700   273.27\n",
       "349   Cust_1674  2827.1425   713.88\n",
       "395   Cust_1418  2182.9100   549.45\n",
       "404    Cust_566  2010.8900   564.07\n",
       "510   Cust_1346  2660.6105   618.07\n",
       "522     Cust_51  2689.4800   399.93\n",
       "536    Cust_227  2180.2300   660.25\n",
       "541   Cust_1680  2292.1015   398.36\n",
       "647   Cust_1439  2758.2200   966.81\n",
       "680    Cust_212  2404.5990   496.89\n",
       "688   Cust_1682  2257.8800   474.98\n",
       "718    Cust_783  2135.9735   239.40\n",
       "720    Cust_805  2773.0315   897.87\n",
       "729   Cust_1588  2168.0500   416.02\n",
       "767    Cust_828  2192.6300   660.06\n",
       "775   Cust_1746  2610.8940   516.19\n",
       "783   Cust_1017  2368.1680  1181.30\n",
       "809   Cust_1440  2752.6800   430.32\n",
       "810   Cust_1440  2405.0000   696.17\n",
       "...         ...        ...      ...\n",
       "7777  Cust_1196  2167.0500   684.90\n",
       "7778  Cust_1196  2040.3900   221.09\n",
       "7788   Cust_977  2252.2620   478.11\n",
       "7811  Cust_1188  2080.0350   844.90\n",
       "7823  Cust_1492  2325.4200   739.91\n",
       "7858  Cust_1200  2206.1700   251.43\n",
       "7875   Cust_577  2287.1000   231.49\n",
       "7877   Cust_577  2503.3265   447.12\n",
       "7884   Cust_244  2529.3960   371.21\n",
       "7911  Cust_1693  2882.7070   303.23\n",
       "7927   Cust_976  2104.9910   165.45\n",
       "7940  Cust_1224  2185.9535   268.01\n",
       "7973   Cust_582  2145.0500  1012.67\n",
       "7986  Cust_1583  2478.4810   249.10\n",
       "8045  Cust_1803  2587.5300   401.85\n",
       "8048   Cust_247  2780.8800   595.38\n",
       "8061   Cust_892  2550.1200   882.45\n",
       "8071  Cust_1795  2750.1070   600.42\n",
       "8147  Cust_1187  2143.2155   464.36\n",
       "8152  Cust_1187  2477.9900   747.68\n",
       "8239   Cust_245  2833.1900  1409.87\n",
       "8262  Cust_1694  2455.2760   693.06\n",
       "8271  Cust_1587  2823.0370   372.40\n",
       "8289   Cust_595  2731.7300   310.59\n",
       "8304  Cust_1025  2272.5600   111.05\n",
       "8338   Cust_785  2409.9600   575.10\n",
       "8350  Cust_1266  2094.9780   697.29\n",
       "8354  Cust_1266  2614.3705   384.01\n",
       "8381  Cust_1006  2836.0505   561.13\n",
       "8394  Cust_1798  2841.4395   374.63\n",
       "\n",
       "[328 rows x 3 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# E.g. all orders having 2000 < Sales < 3000 and Profit > 100\n",
    "# Also, this time, you only need the Cust_id, Sales and Profit columns\n",
    "df.loc[(df.Sales > 2000) & (df.Sales < 3000) & (df.Profit > 100), ['Cust_id', 'Sales', 'Profit']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Ord_id</th>\n",
       "      <th>Prod_id</th>\n",
       "      <th>Ship_id</th>\n",
       "      <th>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Order_Quantity</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Product_Base_Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_16</td>\n",
       "      <td>SHP_7609</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>136.8100</td>\n",
       "      <td>0.01</td>\n",
       "      <td>23</td>\n",
       "      <td>-30.51</td>\n",
       "      <td>3.60</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Ord_5406</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_7549</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>42.2700</td>\n",
       "      <td>0.01</td>\n",
       "      <td>13</td>\n",
       "      <td>4.56</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7610</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4701.6900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>26</td>\n",
       "      <td>1148.90</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ord_5456</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7625</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>2337.8900</td>\n",
       "      <td>0.09</td>\n",
       "      <td>43</td>\n",
       "      <td>729.34</td>\n",
       "      <td>14.30</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Ord_5485</td>\n",
       "      <td>Prod_17</td>\n",
       "      <td>SHP_7664</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>4233.1500</td>\n",
       "      <td>0.08</td>\n",
       "      <td>35</td>\n",
       "      <td>1219.87</td>\n",
       "      <td>26.30</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Ord_5446</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7608</td>\n",
       "      <td>Cust_1818</td>\n",
       "      <td>164.0200</td>\n",
       "      <td>0.03</td>\n",
       "      <td>23</td>\n",
       "      <td>-47.64</td>\n",
       "      <td>6.15</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Ord_31</td>\n",
       "      <td>Prod_12</td>\n",
       "      <td>SHP_41</td>\n",
       "      <td>Cust_26</td>\n",
       "      <td>14.7600</td>\n",
       "      <td>0.01</td>\n",
       "      <td>5</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Ord_4725</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_6593</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>3410.1575</td>\n",
       "      <td>0.10</td>\n",
       "      <td>48</td>\n",
       "      <td>1137.91</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Ord_4725</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_6593</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>162.0000</td>\n",
       "      <td>0.01</td>\n",
       "      <td>33</td>\n",
       "      <td>45.84</td>\n",
       "      <td>0.71</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Ord_4725</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_6593</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>57.2200</td>\n",
       "      <td>0.07</td>\n",
       "      <td>8</td>\n",
       "      <td>-27.72</td>\n",
       "      <td>6.60</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ord_4743</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_6615</td>\n",
       "      <td>Cust_1641</td>\n",
       "      <td>4072.0100</td>\n",
       "      <td>0.01</td>\n",
       "      <td>43</td>\n",
       "      <td>1675.98</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Ord_1925</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_2637</td>\n",
       "      <td>Cust_708</td>\n",
       "      <td>465.9000</td>\n",
       "      <td>0.05</td>\n",
       "      <td>38</td>\n",
       "      <td>79.34</td>\n",
       "      <td>4.86</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Ord_2978</td>\n",
       "      <td>Prod_16</td>\n",
       "      <td>SHP_4112</td>\n",
       "      <td>Cust_1088</td>\n",
       "      <td>305.0500</td>\n",
       "      <td>0.04</td>\n",
       "      <td>27</td>\n",
       "      <td>23.12</td>\n",
       "      <td>3.37</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Ord_2207</td>\n",
       "      <td>Prod_11</td>\n",
       "      <td>SHP_3093</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>3364.2480</td>\n",
       "      <td>0.10</td>\n",
       "      <td>15</td>\n",
       "      <td>-693.23</td>\n",
       "      <td>61.76</td>\n",
       "      <td>0.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Ord_2207</td>\n",
       "      <td>Prod_10</td>\n",
       "      <td>SHP_3006</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>1410.9300</td>\n",
       "      <td>0.08</td>\n",
       "      <td>10</td>\n",
       "      <td>-317.48</td>\n",
       "      <td>36.09</td>\n",
       "      <td>0.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Ord_2280</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_3114</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>460.6900</td>\n",
       "      <td>0.06</td>\n",
       "      <td>48</td>\n",
       "      <td>-103.48</td>\n",
       "      <td>7.29</td>\n",
       "      <td>0.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Ord_2282</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_3122</td>\n",
       "      <td>Cust_839</td>\n",
       "      <td>443.4600</td>\n",
       "      <td>0.06</td>\n",
       "      <td>30</td>\n",
       "      <td>193.12</td>\n",
       "      <td>1.39</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Ord_4471</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_6228</td>\n",
       "      <td>Cust_1521</td>\n",
       "      <td>13255.9300</td>\n",
       "      <td>0.02</td>\n",
       "      <td>25</td>\n",
       "      <td>4089.27</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Ord_4427</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_6171</td>\n",
       "      <td>Cust_1521</td>\n",
       "      <td>283.1300</td>\n",
       "      <td>0.08</td>\n",
       "      <td>45</td>\n",
       "      <td>-141.26</td>\n",
       "      <td>6.81</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_1378</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>41.9700</td>\n",
       "      <td>0.05</td>\n",
       "      <td>12</td>\n",
       "      <td>-37.03</td>\n",
       "      <td>4.20</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_1378</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>57.1700</td>\n",
       "      <td>0.08</td>\n",
       "      <td>18</td>\n",
       "      <td>-24.03</td>\n",
       "      <td>2.31</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_1378</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>81.2500</td>\n",
       "      <td>0.01</td>\n",
       "      <td>11</td>\n",
       "      <td>-44.54</td>\n",
       "      <td>7.86</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_1377</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>3202.2500</td>\n",
       "      <td>0.09</td>\n",
       "      <td>44</td>\n",
       "      <td>991.26</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Ord_996</td>\n",
       "      <td>Prod_7</td>\n",
       "      <td>SHP_1378</td>\n",
       "      <td>Cust_371</td>\n",
       "      <td>35.6400</td>\n",
       "      <td>0.05</td>\n",
       "      <td>10</td>\n",
       "      <td>-0.71</td>\n",
       "      <td>1.63</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Ord_2573</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3525</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>197.6100</td>\n",
       "      <td>0.08</td>\n",
       "      <td>13</td>\n",
       "      <td>3.46</td>\n",
       "      <td>7.27</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Ord_2335</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_3204</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>38.2600</td>\n",
       "      <td>0.03</td>\n",
       "      <td>22</td>\n",
       "      <td>-2.34</td>\n",
       "      <td>0.70</td>\n",
       "      <td>0.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Ord_2456</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_3367</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>109.5800</td>\n",
       "      <td>0.00</td>\n",
       "      <td>13</td>\n",
       "      <td>31.32</td>\n",
       "      <td>4.00</td>\n",
       "      <td>0.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Ord_2405</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_3300</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>1062.6900</td>\n",
       "      <td>0.01</td>\n",
       "      <td>28</td>\n",
       "      <td>401.80</td>\n",
       "      <td>6.66</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ord_2573</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3527</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>3594.7435</td>\n",
       "      <td>0.05</td>\n",
       "      <td>38</td>\n",
       "      <td>1016.97</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Ord_2478</td>\n",
       "      <td>Prod_12</td>\n",
       "      <td>SHP_3395</td>\n",
       "      <td>Cust_931</td>\n",
       "      <td>139.9800</td>\n",
       "      <td>0.07</td>\n",
       "      <td>33</td>\n",
       "      <td>-140.54</td>\n",
       "      <td>6.89</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8369</th>\n",
       "      <td>Ord_3633</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_5031</td>\n",
       "      <td>Cust_1274</td>\n",
       "      <td>1169.2600</td>\n",
       "      <td>0.02</td>\n",
       "      <td>41</td>\n",
       "      <td>515.62</td>\n",
       "      <td>1.49</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8370</th>\n",
       "      <td>Ord_2696</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_3690</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>62.7800</td>\n",
       "      <td>0.04</td>\n",
       "      <td>20</td>\n",
       "      <td>-17.75</td>\n",
       "      <td>2.03</td>\n",
       "      <td>0.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8371</th>\n",
       "      <td>Ord_2624</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3591</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>4924.1350</td>\n",
       "      <td>0.07</td>\n",
       "      <td>28</td>\n",
       "      <td>1049.54</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8372</th>\n",
       "      <td>Ord_2772</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_3806</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>56.9000</td>\n",
       "      <td>0.03</td>\n",
       "      <td>7</td>\n",
       "      <td>12.64</td>\n",
       "      <td>1.39</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8373</th>\n",
       "      <td>Ord_2600</td>\n",
       "      <td>Prod_16</td>\n",
       "      <td>SHP_3560</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>106.6400</td>\n",
       "      <td>0.10</td>\n",
       "      <td>30</td>\n",
       "      <td>-31.95</td>\n",
       "      <td>1.32</td>\n",
       "      <td>0.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8374</th>\n",
       "      <td>Ord_2658</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_3637</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>1082.6600</td>\n",
       "      <td>0.08</td>\n",
       "      <td>14</td>\n",
       "      <td>-256.93</td>\n",
       "      <td>48.20</td>\n",
       "      <td>0.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8375</th>\n",
       "      <td>Ord_2772</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3806</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>1413.8200</td>\n",
       "      <td>0.10</td>\n",
       "      <td>47</td>\n",
       "      <td>226.53</td>\n",
       "      <td>11.63</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8376</th>\n",
       "      <td>Ord_2624</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_3590</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>1211.0000</td>\n",
       "      <td>0.00</td>\n",
       "      <td>36</td>\n",
       "      <td>-27.99</td>\n",
       "      <td>6.50</td>\n",
       "      <td>0.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8377</th>\n",
       "      <td>Ord_2722</td>\n",
       "      <td>Prod_12</td>\n",
       "      <td>SHP_3729</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>34.0100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>12</td>\n",
       "      <td>10.58</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8378</th>\n",
       "      <td>Ord_2706</td>\n",
       "      <td>Prod_2</td>\n",
       "      <td>SHP_3705</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>1361.9100</td>\n",
       "      <td>0.05</td>\n",
       "      <td>20</td>\n",
       "      <td>312.52</td>\n",
       "      <td>3.50</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8379</th>\n",
       "      <td>Ord_2722</td>\n",
       "      <td>Prod_5</td>\n",
       "      <td>SHP_3730</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>1008.9500</td>\n",
       "      <td>0.04</td>\n",
       "      <td>41</td>\n",
       "      <td>69.31</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8380</th>\n",
       "      <td>Ord_2772</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_3807</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>308.9200</td>\n",
       "      <td>0.04</td>\n",
       "      <td>45</td>\n",
       "      <td>-143.58</td>\n",
       "      <td>7.37</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8381</th>\n",
       "      <td>Ord_2696</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_3691</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>2836.0505</td>\n",
       "      <td>0.01</td>\n",
       "      <td>25</td>\n",
       "      <td>561.13</td>\n",
       "      <td>8.99</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8382</th>\n",
       "      <td>Ord_2658</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3636</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>120.9800</td>\n",
       "      <td>0.00</td>\n",
       "      <td>28</td>\n",
       "      <td>-92.85</td>\n",
       "      <td>5.34</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8383</th>\n",
       "      <td>Ord_2722</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_3731</td>\n",
       "      <td>Cust_1006</td>\n",
       "      <td>3508.3300</td>\n",
       "      <td>0.04</td>\n",
       "      <td>21</td>\n",
       "      <td>-546.98</td>\n",
       "      <td>35.00</td>\n",
       "      <td>0.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8384</th>\n",
       "      <td>Ord_4620</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_6435</td>\n",
       "      <td>Cust_1577</td>\n",
       "      <td>59.6200</td>\n",
       "      <td>0.04</td>\n",
       "      <td>10</td>\n",
       "      <td>-56.30</td>\n",
       "      <td>7.78</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8385</th>\n",
       "      <td>Ord_1833</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_2527</td>\n",
       "      <td>Cust_637</td>\n",
       "      <td>611.1600</td>\n",
       "      <td>0.04</td>\n",
       "      <td>46</td>\n",
       "      <td>100.22</td>\n",
       "      <td>4.98</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8386</th>\n",
       "      <td>Ord_2324</td>\n",
       "      <td>Prod_7</td>\n",
       "      <td>SHP_3189</td>\n",
       "      <td>Cust_851</td>\n",
       "      <td>121.8700</td>\n",
       "      <td>0.07</td>\n",
       "      <td>39</td>\n",
       "      <td>11.32</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8387</th>\n",
       "      <td>Ord_2220</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3019</td>\n",
       "      <td>Cust_851</td>\n",
       "      <td>41.0600</td>\n",
       "      <td>0.04</td>\n",
       "      <td>4</td>\n",
       "      <td>-16.39</td>\n",
       "      <td>6.28</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8388</th>\n",
       "      <td>Ord_4424</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6165</td>\n",
       "      <td>Cust_1519</td>\n",
       "      <td>994.0400</td>\n",
       "      <td>0.03</td>\n",
       "      <td>10</td>\n",
       "      <td>-335.06</td>\n",
       "      <td>35.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8389</th>\n",
       "      <td>Ord_4444</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_6192</td>\n",
       "      <td>Cust_1519</td>\n",
       "      <td>159.4100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44</td>\n",
       "      <td>34.68</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8390</th>\n",
       "      <td>Ord_5435</td>\n",
       "      <td>Prod_16</td>\n",
       "      <td>SHP_7594</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>316.9900</td>\n",
       "      <td>0.04</td>\n",
       "      <td>47</td>\n",
       "      <td>-276.54</td>\n",
       "      <td>8.37</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8391</th>\n",
       "      <td>Ord_5435</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7594</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>1991.8985</td>\n",
       "      <td>0.07</td>\n",
       "      <td>20</td>\n",
       "      <td>88.36</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8392</th>\n",
       "      <td>Ord_5384</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_7519</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>181.5000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>43</td>\n",
       "      <td>-6.24</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8393</th>\n",
       "      <td>Ord_5348</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_7470</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>356.7200</td>\n",
       "      <td>0.07</td>\n",
       "      <td>9</td>\n",
       "      <td>12.61</td>\n",
       "      <td>1.99</td>\n",
       "      <td>0.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8394</th>\n",
       "      <td>Ord_5353</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7479</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>2841.4395</td>\n",
       "      <td>0.08</td>\n",
       "      <td>28</td>\n",
       "      <td>374.63</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8395</th>\n",
       "      <td>Ord_5411</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7555</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>127.1600</td>\n",
       "      <td>0.10</td>\n",
       "      <td>20</td>\n",
       "      <td>-74.03</td>\n",
       "      <td>6.92</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8396</th>\n",
       "      <td>Ord_5388</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7524</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>243.0500</td>\n",
       "      <td>0.02</td>\n",
       "      <td>39</td>\n",
       "      <td>-70.85</td>\n",
       "      <td>5.35</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8397</th>\n",
       "      <td>Ord_5348</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7469</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>3872.8700</td>\n",
       "      <td>0.03</td>\n",
       "      <td>23</td>\n",
       "      <td>565.34</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8398</th>\n",
       "      <td>Ord_5459</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7628</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>603.6900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47</td>\n",
       "      <td>131.39</td>\n",
       "      <td>4.86</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>8399 rows × 10 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Ord_id  Prod_id   Ship_id    Cust_id       Sales  Discount  \\\n",
       "0     Ord_5446  Prod_16  SHP_7609  Cust_1818    136.8100      0.01   \n",
       "1     Ord_5406  Prod_13  SHP_7549  Cust_1818     42.2700      0.01   \n",
       "2     Ord_5446   Prod_4  SHP_7610  Cust_1818   4701.6900      0.00   \n",
       "3     Ord_5456   Prod_6  SHP_7625  Cust_1818   2337.8900      0.09   \n",
       "4     Ord_5485  Prod_17  SHP_7664  Cust_1818   4233.1500      0.08   \n",
       "5     Ord_5446   Prod_6  SHP_7608  Cust_1818    164.0200      0.03   \n",
       "6       Ord_31  Prod_12    SHP_41    Cust_26     14.7600      0.01   \n",
       "7     Ord_4725   Prod_4  SHP_6593  Cust_1641   3410.1575      0.10   \n",
       "8     Ord_4725  Prod_13  SHP_6593  Cust_1641    162.0000      0.01   \n",
       "9     Ord_4725   Prod_6  SHP_6593  Cust_1641     57.2200      0.07   \n",
       "10    Ord_4743   Prod_2  SHP_6615  Cust_1641   4072.0100      0.01   \n",
       "11    Ord_1925   Prod_6  SHP_2637   Cust_708    465.9000      0.05   \n",
       "12    Ord_2978  Prod_16  SHP_4112  Cust_1088    305.0500      0.04   \n",
       "13    Ord_2207  Prod_11  SHP_3093   Cust_839   3364.2480      0.10   \n",
       "14    Ord_2207  Prod_10  SHP_3006   Cust_839   1410.9300      0.08   \n",
       "15    Ord_2280   Prod_5  SHP_3114   Cust_839    460.6900      0.06   \n",
       "16    Ord_2282   Prod_9  SHP_3122   Cust_839    443.4600      0.06   \n",
       "17    Ord_4471  Prod_15  SHP_6228  Cust_1521  13255.9300      0.02   \n",
       "18    Ord_4427   Prod_6  SHP_6171  Cust_1521    283.1300      0.08   \n",
       "19     Ord_996  Prod_13  SHP_1378   Cust_371     41.9700      0.05   \n",
       "20     Ord_996  Prod_13  SHP_1378   Cust_371     57.1700      0.08   \n",
       "21     Ord_996   Prod_6  SHP_1378   Cust_371     81.2500      0.01   \n",
       "22     Ord_996   Prod_5  SHP_1377   Cust_371   3202.2500      0.09   \n",
       "23     Ord_996   Prod_7  SHP_1378   Cust_371     35.6400      0.05   \n",
       "24    Ord_2573   Prod_3  SHP_3525   Cust_931    197.6100      0.08   \n",
       "25    Ord_2335  Prod_13  SHP_3204   Cust_931     38.2600      0.03   \n",
       "26    Ord_2456   Prod_5  SHP_3367   Cust_931    109.5800      0.00   \n",
       "27    Ord_2405   Prod_9  SHP_3300   Cust_931   1062.6900      0.01   \n",
       "28    Ord_2573   Prod_4  SHP_3527   Cust_931   3594.7435      0.05   \n",
       "29    Ord_2478  Prod_12  SHP_3395   Cust_931    139.9800      0.07   \n",
       "...        ...      ...       ...        ...         ...       ...   \n",
       "8369  Ord_3633   Prod_3  SHP_5031  Cust_1274   1169.2600      0.02   \n",
       "8370  Ord_2696  Prod_13  SHP_3690  Cust_1006     62.7800      0.04   \n",
       "8371  Ord_2624   Prod_4  SHP_3591  Cust_1006   4924.1350      0.07   \n",
       "8372  Ord_2772   Prod_9  SHP_3806  Cust_1006     56.9000      0.03   \n",
       "8373  Ord_2600  Prod_16  SHP_3560  Cust_1006    106.6400      0.10   \n",
       "8374  Ord_2658   Prod_5  SHP_3637  Cust_1006   1082.6600      0.08   \n",
       "8375  Ord_2772   Prod_3  SHP_3806  Cust_1006   1413.8200      0.10   \n",
       "8376  Ord_2624   Prod_8  SHP_3590  Cust_1006   1211.0000      0.00   \n",
       "8377  Ord_2722  Prod_12  SHP_3729  Cust_1006     34.0100      0.00   \n",
       "8378  Ord_2706   Prod_2  SHP_3705  Cust_1006   1361.9100      0.05   \n",
       "8379  Ord_2722   Prod_5  SHP_3730  Cust_1006   1008.9500      0.04   \n",
       "8380  Ord_2772   Prod_6  SHP_3807  Cust_1006    308.9200      0.04   \n",
       "8381  Ord_2696   Prod_4  SHP_3691  Cust_1006   2836.0505      0.01   \n",
       "8382  Ord_2658   Prod_3  SHP_3636  Cust_1006    120.9800      0.00   \n",
       "8383  Ord_2722   Prod_1  SHP_3731  Cust_1006   3508.3300      0.04   \n",
       "8384  Ord_4620   Prod_3  SHP_6435  Cust_1577     59.6200      0.04   \n",
       "8385  Ord_1833   Prod_3  SHP_2527   Cust_637    611.1600      0.04   \n",
       "8386  Ord_2324   Prod_7  SHP_3189   Cust_851    121.8700      0.07   \n",
       "8387  Ord_2220   Prod_3  SHP_3019   Cust_851     41.0600      0.04   \n",
       "8388  Ord_4424   Prod_1  SHP_6165  Cust_1519    994.0400      0.03   \n",
       "8389  Ord_4444  Prod_13  SHP_6192  Cust_1519    159.4100      0.00   \n",
       "8390  Ord_5435  Prod_16  SHP_7594  Cust_1798    316.9900      0.04   \n",
       "8391  Ord_5435   Prod_4  SHP_7594  Cust_1798   1991.8985      0.07   \n",
       "8392  Ord_5384   Prod_9  SHP_7519  Cust_1798    181.5000      0.08   \n",
       "8393  Ord_5348   Prod_8  SHP_7470  Cust_1798    356.7200      0.07   \n",
       "8394  Ord_5353   Prod_4  SHP_7479  Cust_1798   2841.4395      0.08   \n",
       "8395  Ord_5411   Prod_6  SHP_7555  Cust_1798    127.1600      0.10   \n",
       "8396  Ord_5388   Prod_6  SHP_7524  Cust_1798    243.0500      0.02   \n",
       "8397  Ord_5348  Prod_15  SHP_7469  Cust_1798   3872.8700      0.03   \n",
       "8398  Ord_5459   Prod_6  SHP_7628  Cust_1798    603.6900      0.00   \n",
       "\n",
       "      Order_Quantity   Profit  Shipping_Cost  Product_Base_Margin  \n",
       "0                 23   -30.51           3.60                 0.56  \n",
       "1                 13     4.56           0.93                 0.54  \n",
       "2                 26  1148.90           2.50                 0.59  \n",
       "3                 43   729.34          14.30                 0.37  \n",
       "4                 35  1219.87          26.30                 0.38  \n",
       "5                 23   -47.64           6.15                 0.37  \n",
       "6                  5     1.32           0.50                 0.36  \n",
       "7                 48  1137.91           0.99                 0.55  \n",
       "8                 33    45.84           0.71                 0.52  \n",
       "9                  8   -27.72           6.60                 0.37  \n",
       "10                43  1675.98           0.99                 0.56  \n",
       "11                38    79.34           4.86                 0.38  \n",
       "12                27    23.12           3.37                 0.57  \n",
       "13                15  -693.23          61.76                 0.78  \n",
       "14                10  -317.48          36.09                 0.77  \n",
       "15                48  -103.48           7.29                 0.45  \n",
       "16                30   193.12           1.39                 0.38  \n",
       "17                25  4089.27          26.00                 0.60  \n",
       "18                45  -141.26           6.81                 0.36  \n",
       "19                12   -37.03           4.20                 0.56  \n",
       "20                18   -24.03           2.31                 0.56  \n",
       "21                11   -44.54           7.86                 0.37  \n",
       "22                44   991.26          19.99                 0.43  \n",
       "23                10    -0.71           1.63                 0.36  \n",
       "24                13     3.46           7.27                 0.38  \n",
       "25                22    -2.34           0.70                 0.56  \n",
       "26                13    31.32           4.00                 0.42  \n",
       "27                28   401.80           6.66                 0.40  \n",
       "28                38  1016.97           2.50                 0.55  \n",
       "29                33  -140.54           6.89                 0.39  \n",
       "...              ...      ...            ...                  ...  \n",
       "8369              41   515.62           1.49                 0.38  \n",
       "8370              20   -17.75           2.03                 0.57  \n",
       "8371              28  1049.54           8.99                 0.58  \n",
       "8372               7    12.64           1.39                 0.36  \n",
       "8373              30   -31.95           1.32                 0.83  \n",
       "8374              14  -256.93          48.20                 0.74  \n",
       "8375              47   226.53          11.63                 0.37  \n",
       "8376              36   -27.99           6.50                 0.79  \n",
       "8377              12    10.58           0.50                 0.39  \n",
       "8378              20   312.52           3.50                 0.59  \n",
       "8379              41    69.31           8.99                 0.50  \n",
       "8380              45  -143.58           7.37                 0.37  \n",
       "8381              25   561.13           8.99                 0.59  \n",
       "8382              28   -92.85           5.34                 0.38  \n",
       "8383              21  -546.98          35.00                 0.85  \n",
       "8384              10   -56.30           7.78                 0.37  \n",
       "8385              46   100.22           4.98                 0.40  \n",
       "8386              39    11.32           1.35                 0.40  \n",
       "8387               4   -16.39           6.28                 0.35  \n",
       "8388              10  -335.06          35.00                  NaN  \n",
       "8389              44    34.68           0.98                 0.52  \n",
       "8390              47  -276.54           8.37                 0.58  \n",
       "8391              20    88.36           7.69                 0.58  \n",
       "8392              43    -6.24           2.50                 0.37  \n",
       "8393               9    12.61           1.99                 0.44  \n",
       "8394              28   374.63           7.69                 0.59  \n",
       "8395              20   -74.03           6.92                 0.37  \n",
       "8396              39   -70.85           5.35                 0.40  \n",
       "8397              23   565.34          30.00                 0.62  \n",
       "8398              47   131.39           4.86                 0.38  \n",
       "\n",
       "[8399 rows x 10 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# You can use the == and != operators \n",
    "df.loc[(df.Sales == 4233.15), :]\n",
    "df.loc[(df.Sales != 1000), :]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<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>Ord_id</th>\n",
       "      <th>Prod_id</th>\n",
       "      <th>Ship_id</th>\n",
       "      <th>Cust_id</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Order_Quantity</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Shipping_Cost</th>\n",
       "      <th>Product_Base_Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>8385</th>\n",
       "      <td>Ord_1833</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_2527</td>\n",
       "      <td>Cust_637</td>\n",
       "      <td>611.1600</td>\n",
       "      <td>0.04</td>\n",
       "      <td>46</td>\n",
       "      <td>100.22</td>\n",
       "      <td>4.98</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8386</th>\n",
       "      <td>Ord_2324</td>\n",
       "      <td>Prod_7</td>\n",
       "      <td>SHP_3189</td>\n",
       "      <td>Cust_851</td>\n",
       "      <td>121.8700</td>\n",
       "      <td>0.07</td>\n",
       "      <td>39</td>\n",
       "      <td>11.32</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8387</th>\n",
       "      <td>Ord_2220</td>\n",
       "      <td>Prod_3</td>\n",
       "      <td>SHP_3019</td>\n",
       "      <td>Cust_851</td>\n",
       "      <td>41.0600</td>\n",
       "      <td>0.04</td>\n",
       "      <td>4</td>\n",
       "      <td>-16.39</td>\n",
       "      <td>6.28</td>\n",
       "      <td>0.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8388</th>\n",
       "      <td>Ord_4424</td>\n",
       "      <td>Prod_1</td>\n",
       "      <td>SHP_6165</td>\n",
       "      <td>Cust_1519</td>\n",
       "      <td>994.0400</td>\n",
       "      <td>0.03</td>\n",
       "      <td>10</td>\n",
       "      <td>-335.06</td>\n",
       "      <td>35.00</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8389</th>\n",
       "      <td>Ord_4444</td>\n",
       "      <td>Prod_13</td>\n",
       "      <td>SHP_6192</td>\n",
       "      <td>Cust_1519</td>\n",
       "      <td>159.4100</td>\n",
       "      <td>0.00</td>\n",
       "      <td>44</td>\n",
       "      <td>34.68</td>\n",
       "      <td>0.98</td>\n",
       "      <td>0.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8390</th>\n",
       "      <td>Ord_5435</td>\n",
       "      <td>Prod_16</td>\n",
       "      <td>SHP_7594</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>316.9900</td>\n",
       "      <td>0.04</td>\n",
       "      <td>47</td>\n",
       "      <td>-276.54</td>\n",
       "      <td>8.37</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8391</th>\n",
       "      <td>Ord_5435</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7594</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>1991.8985</td>\n",
       "      <td>0.07</td>\n",
       "      <td>20</td>\n",
       "      <td>88.36</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8392</th>\n",
       "      <td>Ord_5384</td>\n",
       "      <td>Prod_9</td>\n",
       "      <td>SHP_7519</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>181.5000</td>\n",
       "      <td>0.08</td>\n",
       "      <td>43</td>\n",
       "      <td>-6.24</td>\n",
       "      <td>2.50</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8393</th>\n",
       "      <td>Ord_5348</td>\n",
       "      <td>Prod_8</td>\n",
       "      <td>SHP_7470</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>356.7200</td>\n",
       "      <td>0.07</td>\n",
       "      <td>9</td>\n",
       "      <td>12.61</td>\n",
       "      <td>1.99</td>\n",
       "      <td>0.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8394</th>\n",
       "      <td>Ord_5353</td>\n",
       "      <td>Prod_4</td>\n",
       "      <td>SHP_7479</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>2841.4395</td>\n",
       "      <td>0.08</td>\n",
       "      <td>28</td>\n",
       "      <td>374.63</td>\n",
       "      <td>7.69</td>\n",
       "      <td>0.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8395</th>\n",
       "      <td>Ord_5411</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7555</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>127.1600</td>\n",
       "      <td>0.10</td>\n",
       "      <td>20</td>\n",
       "      <td>-74.03</td>\n",
       "      <td>6.92</td>\n",
       "      <td>0.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8396</th>\n",
       "      <td>Ord_5388</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7524</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>243.0500</td>\n",
       "      <td>0.02</td>\n",
       "      <td>39</td>\n",
       "      <td>-70.85</td>\n",
       "      <td>5.35</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8397</th>\n",
       "      <td>Ord_5348</td>\n",
       "      <td>Prod_15</td>\n",
       "      <td>SHP_7469</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>3872.8700</td>\n",
       "      <td>0.03</td>\n",
       "      <td>23</td>\n",
       "      <td>565.34</td>\n",
       "      <td>30.00</td>\n",
       "      <td>0.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8398</th>\n",
       "      <td>Ord_5459</td>\n",
       "      <td>Prod_6</td>\n",
       "      <td>SHP_7628</td>\n",
       "      <td>Cust_1798</td>\n",
       "      <td>603.6900</td>\n",
       "      <td>0.00</td>\n",
       "      <td>47</td>\n",
       "      <td>131.39</td>\n",
       "      <td>4.86</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        Ord_id  Prod_id   Ship_id    Cust_id      Sales  Discount  \\\n",
       "8385  Ord_1833   Prod_3  SHP_2527   Cust_637   611.1600      0.04   \n",
       "8386  Ord_2324   Prod_7  SHP_3189   Cust_851   121.8700      0.07   \n",
       "8387  Ord_2220   Prod_3  SHP_3019   Cust_851    41.0600      0.04   \n",
       "8388  Ord_4424   Prod_1  SHP_6165  Cust_1519   994.0400      0.03   \n",
       "8389  Ord_4444  Prod_13  SHP_6192  Cust_1519   159.4100      0.00   \n",
       "8390  Ord_5435  Prod_16  SHP_7594  Cust_1798   316.9900      0.04   \n",
       "8391  Ord_5435   Prod_4  SHP_7594  Cust_1798  1991.8985      0.07   \n",
       "8392  Ord_5384   Prod_9  SHP_7519  Cust_1798   181.5000      0.08   \n",
       "8393  Ord_5348   Prod_8  SHP_7470  Cust_1798   356.7200      0.07   \n",
       "8394  Ord_5353   Prod_4  SHP_7479  Cust_1798  2841.4395      0.08   \n",
       "8395  Ord_5411   Prod_6  SHP_7555  Cust_1798   127.1600      0.10   \n",
       "8396  Ord_5388   Prod_6  SHP_7524  Cust_1798   243.0500      0.02   \n",
       "8397  Ord_5348  Prod_15  SHP_7469  Cust_1798  3872.8700      0.03   \n",
       "8398  Ord_5459   Prod_6  SHP_7628  Cust_1798   603.6900      0.00   \n",
       "\n",
       "      Order_Quantity  Profit  Shipping_Cost  Product_Base_Margin  \n",
       "8385              46  100.22           4.98                 0.40  \n",
       "8386              39   11.32           1.35                 0.40  \n",
       "8387               4  -16.39           6.28                 0.35  \n",
       "8388              10 -335.06          35.00                  NaN  \n",
       "8389              44   34.68           0.98                 0.52  \n",
       "8390              47 -276.54           8.37                 0.58  \n",
       "8391              20   88.36           7.69                 0.58  \n",
       "8392              43   -6.24           2.50                 0.37  \n",
       "8393               9   12.61           1.99                 0.44  \n",
       "8394              28  374.63           7.69                 0.59  \n",
       "8395              20  -74.03           6.92                 0.37  \n",
       "8396              39  -70.85           5.35                 0.40  \n",
       "8397              23  565.34          30.00                 0.62  \n",
       "8398              47  131.39           4.86                 0.38  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# You may want to select rows whose column value is in an iterable\n",
    "# For instance, say a colleague gives you a list of customer_ids from a certain region\n",
    "\n",
    "customers_in_bangalore = ['Cust_1798', 'Cust_1519', 'Cust_637', 'Cust_851']\n",
    "\n",
    "# To get all the orders from these customers, use the isin() function\n",
    "# It returns a boolean, which you can use to select rows\n",
    "df.loc[df['Cust_id'].isin(customers_in_bangalore), :]"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}