Basic analysis for Power BI.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3104e15f",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "d602fa20",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_excel('SuperStoreUS-2015.xlsx', sheet_name = None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "45774b78",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'Orders':       Row ID Order Priority  Discount  Unit Price  Shipping Cost  Customer ID  \\\n",
       " 0      20847           High      0.01        2.84           0.93            3   \n",
       " 1      20228  Not Specified      0.02      500.98          26.00            5   \n",
       " 2      21776       Critical      0.06        9.48           7.29           11   \n",
       " 3      24844         Medium      0.09       78.69          19.99           14   \n",
       " 4      24846         Medium      0.08        3.28           2.31           14   \n",
       " ...      ...            ...       ...         ...            ...          ...   \n",
       " 1947   19842           High      0.01       10.90           7.46         3397   \n",
       " 1948   19843           High      0.10        7.99           5.03         3397   \n",
       " 1949   26208  Not Specified      0.08       11.97           5.81         3399   \n",
       " 1950   24911         Medium      0.10        9.38           4.93         3400   \n",
       " 1951   25914           High      0.10      105.98          13.99         3403   \n",
       " \n",
       "           Customer Name       Ship Mode Customer Segment Product Category  \\\n",
       " 0         Bonnie Potter     Express Air        Corporate  Office Supplies   \n",
       " 1        Ronnie Proctor  Delivery Truck      Home Office        Furniture   \n",
       " 2         Marcus Dunlap     Regular Air      Home Office        Furniture   \n",
       " 3     Gwendolyn F Tyson     Regular Air   Small Business        Furniture   \n",
       " 4     Gwendolyn F Tyson     Regular Air   Small Business  Office Supplies   \n",
       " ...                 ...             ...              ...              ...   \n",
       " 1947        Andrea Shaw     Regular Air   Small Business  Office Supplies   \n",
       " 1948        Andrea Shaw     Regular Air   Small Business       Technology   \n",
       " 1949        Marvin Reid     Regular Air   Small Business  Office Supplies   \n",
       " 1950      Florence Gold     Express Air   Small Business        Furniture   \n",
       " 1951      Tammy Buckley     Express Air         Consumer        Furniture   \n",
       " \n",
       "       ...   Region State or Province         City  Postal Code Order Date  \\\n",
       " 0     ...     West        Washington    Anacortes        98221 2015-01-07   \n",
       " 1     ...     West        California  San Gabriel        91776 2015-06-13   \n",
       " 2     ...     East        New Jersey      Roselle         7203 2015-02-15   \n",
       " 3     ...  Central         Minnesota   Prior Lake        55372 2015-05-12   \n",
       " 4     ...  Central         Minnesota   Prior Lake        55372 2015-05-12   \n",
       " ...   ...      ...               ...          ...          ...        ...   \n",
       " 1947  ...  Central          Illinois     Danville        61832 2015-03-11   \n",
       " 1948  ...  Central          Illinois     Danville        61832 2015-03-11   \n",
       " 1949  ...  Central          Illinois  Des Plaines        60016 2015-03-29   \n",
       " 1950  ...     East     West Virginia     Fairmont        26554 2015-04-04   \n",
       " 1951  ...     West           Wyoming     Cheyenne        82001 2015-02-08   \n",
       " \n",
       "       Ship Date     Profit Quantity ordered new    Sales Order ID  \n",
       " 0    2015-01-08     4.5600                    4    13.01    88522  \n",
       " 1    2015-06-15  4390.3665                   12  6362.85    90193  \n",
       " 2    2015-02-17   -53.8096                   22   211.15    90192  \n",
       " 3    2015-05-14   803.4705                   16  1164.45    86838  \n",
       " 4    2015-05-13   -24.0300                    7    22.23    86838  \n",
       " ...         ...        ...                  ...      ...      ...  \n",
       " 1947 2015-03-12  -116.7600                   18   207.31    87536  \n",
       " 1948 2015-03-12  -160.9520                   22   143.12    87536  \n",
       " 1949 2015-03-31   -41.8700                    5    59.98    87534  \n",
       " 1950 2015-04-04   -24.7104                   15   135.78    87537  \n",
       " 1951 2015-02-11   349.4850                    5   506.50    87530  \n",
       " \n",
       " [1952 rows x 25 columns],\n",
       " 'Returns':       Order ID    Status\n",
       " 0           65  Returned\n",
       " 1          612  Returned\n",
       " 2          614  Returned\n",
       " 3          678  Returned\n",
       " 4          710  Returned\n",
       " ...        ...       ...\n",
       " 1629    182681  Returned\n",
       " 1630    182683  Returned\n",
       " 1631    182750  Returned\n",
       " 1632    182781  Returned\n",
       " 1633    182906  Returned\n",
       " \n",
       " [1634 rows x 2 columns],\n",
       " 'Users':     Region  Manager\n",
       " 0  Central    Chris\n",
       " 1     East     Erin\n",
       " 2    South      Sam\n",
       " 3     West  William}"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "e7499f02",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Orders', 'Returns', 'Users']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "list(df.keys())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "f69520d1",
   "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>Row ID</th>\n",
       "      <th>Order Priority</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Customer ID</th>\n",
       "      <th>Customer Name</th>\n",
       "      <th>Ship Mode</th>\n",
       "      <th>Customer Segment</th>\n",
       "      <th>Product Category</th>\n",
       "      <th>...</th>\n",
       "      <th>Region</th>\n",
       "      <th>State or Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Order Date</th>\n",
       "      <th>Ship Date</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Order ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20847</td>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>2.84</td>\n",
       "      <td>0.93</td>\n",
       "      <td>3</td>\n",
       "      <td>Bonnie Potter</td>\n",
       "      <td>Express Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Anacortes</td>\n",
       "      <td>98221</td>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>2015-01-08</td>\n",
       "      <td>4.5600</td>\n",
       "      <td>4</td>\n",
       "      <td>13.01</td>\n",
       "      <td>88522</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20228</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.02</td>\n",
       "      <td>500.98</td>\n",
       "      <td>26.00</td>\n",
       "      <td>5</td>\n",
       "      <td>Ronnie Proctor</td>\n",
       "      <td>Delivery Truck</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>San Gabriel</td>\n",
       "      <td>91776</td>\n",
       "      <td>2015-06-13</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>4390.3665</td>\n",
       "      <td>12</td>\n",
       "      <td>6362.85</td>\n",
       "      <td>90193</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>21776</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.06</td>\n",
       "      <td>9.48</td>\n",
       "      <td>7.29</td>\n",
       "      <td>11</td>\n",
       "      <td>Marcus Dunlap</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New Jersey</td>\n",
       "      <td>Roselle</td>\n",
       "      <td>7203</td>\n",
       "      <td>2015-02-15</td>\n",
       "      <td>2015-02-17</td>\n",
       "      <td>-53.8096</td>\n",
       "      <td>22</td>\n",
       "      <td>211.15</td>\n",
       "      <td>90192</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>24844</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.09</td>\n",
       "      <td>78.69</td>\n",
       "      <td>19.99</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-14</td>\n",
       "      <td>803.4705</td>\n",
       "      <td>16</td>\n",
       "      <td>1164.45</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>24846</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.08</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.31</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-13</td>\n",
       "      <td>-24.0300</td>\n",
       "      <td>7</td>\n",
       "      <td>22.23</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>24847</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.05</td>\n",
       "      <td>3.28</td>\n",
       "      <td>4.20</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-13</td>\n",
       "      <td>-37.0300</td>\n",
       "      <td>4</td>\n",
       "      <td>13.99</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>24848</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.05</td>\n",
       "      <td>3.58</td>\n",
       "      <td>1.63</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-13</td>\n",
       "      <td>-0.7100</td>\n",
       "      <td>4</td>\n",
       "      <td>14.26</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>18181</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.00</td>\n",
       "      <td>4.42</td>\n",
       "      <td>4.99</td>\n",
       "      <td>15</td>\n",
       "      <td>Timothy Reese</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>Smithtown</td>\n",
       "      <td>11787</td>\n",
       "      <td>2015-04-08</td>\n",
       "      <td>2015-04-09</td>\n",
       "      <td>-59.8200</td>\n",
       "      <td>7</td>\n",
       "      <td>33.47</td>\n",
       "      <td>86837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>20925</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.01</td>\n",
       "      <td>35.94</td>\n",
       "      <td>6.66</td>\n",
       "      <td>15</td>\n",
       "      <td>Timothy Reese</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>Smithtown</td>\n",
       "      <td>11787</td>\n",
       "      <td>2015-05-28</td>\n",
       "      <td>2015-05-28</td>\n",
       "      <td>261.8757</td>\n",
       "      <td>10</td>\n",
       "      <td>379.53</td>\n",
       "      <td>86839</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>26267</td>\n",
       "      <td>High</td>\n",
       "      <td>0.04</td>\n",
       "      <td>2.98</td>\n",
       "      <td>1.58</td>\n",
       "      <td>16</td>\n",
       "      <td>Sarah Ramsey</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>Syracuse</td>\n",
       "      <td>13210</td>\n",
       "      <td>2015-02-12</td>\n",
       "      <td>2015-02-15</td>\n",
       "      <td>2.6300</td>\n",
       "      <td>6</td>\n",
       "      <td>18.80</td>\n",
       "      <td>86836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>26268</td>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>115.99</td>\n",
       "      <td>2.50</td>\n",
       "      <td>16</td>\n",
       "      <td>Sarah Ramsey</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Technology</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>Syracuse</td>\n",
       "      <td>13210</td>\n",
       "      <td>2015-02-12</td>\n",
       "      <td>2015-02-14</td>\n",
       "      <td>652.7331</td>\n",
       "      <td>10</td>\n",
       "      <td>945.99</td>\n",
       "      <td>86836</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>23890</td>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>18</td>\n",
       "      <td>Laurie Hanna</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Helena</td>\n",
       "      <td>59601</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2015-05-16</td>\n",
       "      <td>314.4813</td>\n",
       "      <td>17</td>\n",
       "      <td>455.77</td>\n",
       "      <td>90031</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>24063</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.07</td>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>19</td>\n",
       "      <td>Jim Rodgers</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Technology</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Missoula</td>\n",
       "      <td>59801</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-23</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>18</td>\n",
       "      <td>231.79</td>\n",
       "      <td>90032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>5890</td>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>21</td>\n",
       "      <td>Tony Wilkins Winters</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>New York City</td>\n",
       "      <td>10012</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2015-05-16</td>\n",
       "      <td>384.3800</td>\n",
       "      <td>70</td>\n",
       "      <td>1876.69</td>\n",
       "      <td>41793</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>6062</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.08</td>\n",
       "      <td>5.00</td>\n",
       "      <td>3.39</td>\n",
       "      <td>21</td>\n",
       "      <td>Tony Wilkins Winters</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>New York City</td>\n",
       "      <td>10012</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-22</td>\n",
       "      <td>-17.4900</td>\n",
       "      <td>58</td>\n",
       "      <td>293.06</td>\n",
       "      <td>42949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>6063</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.07</td>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>21</td>\n",
       "      <td>Tony Wilkins Winters</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Technology</td>\n",
       "      <td>...</td>\n",
       "      <td>East</td>\n",
       "      <td>New York</td>\n",
       "      <td>New York City</td>\n",
       "      <td>10012</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-23</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>71</td>\n",
       "      <td>914.29</td>\n",
       "      <td>42949</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>20631</td>\n",
       "      <td>High</td>\n",
       "      <td>0.06</td>\n",
       "      <td>55.48</td>\n",
       "      <td>14.30</td>\n",
       "      <td>24</td>\n",
       "      <td>Edna Thomas</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>Laguna Niguel</td>\n",
       "      <td>92677</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-29</td>\n",
       "      <td>-28.2968</td>\n",
       "      <td>1</td>\n",
       "      <td>67.49</td>\n",
       "      <td>87651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>20632</td>\n",
       "      <td>High</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.68</td>\n",
       "      <td>1.57</td>\n",
       "      <td>24</td>\n",
       "      <td>Edna Thomas</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>Laguna Niguel</td>\n",
       "      <td>92677</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-30</td>\n",
       "      <td>-5.3072</td>\n",
       "      <td>1</td>\n",
       "      <td>2.25</td>\n",
       "      <td>87651</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>23967</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.04</td>\n",
       "      <td>4.14</td>\n",
       "      <td>6.60</td>\n",
       "      <td>27</td>\n",
       "      <td>Guy Gallagher</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>Lakewood</td>\n",
       "      <td>90712</td>\n",
       "      <td>2015-05-02</td>\n",
       "      <td>2015-05-04</td>\n",
       "      <td>8.8940</td>\n",
       "      <td>12</td>\n",
       "      <td>54.78</td>\n",
       "      <td>87652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>23509</td>\n",
       "      <td>High</td>\n",
       "      <td>0.08</td>\n",
       "      <td>34.99</td>\n",
       "      <td>7.73</td>\n",
       "      <td>32</td>\n",
       "      <td>Matthew Berman</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>West</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Grants Pass</td>\n",
       "      <td>97526</td>\n",
       "      <td>2015-02-22</td>\n",
       "      <td>2015-02-23</td>\n",
       "      <td>144.6900</td>\n",
       "      <td>13</td>\n",
       "      <td>424.68</td>\n",
       "      <td>89199</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>20 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Row ID Order Priority  Discount  Unit Price  Shipping Cost  Customer ID  \\\n",
       "0    20847           High      0.01        2.84           0.93            3   \n",
       "1    20228  Not Specified      0.02      500.98          26.00            5   \n",
       "2    21776       Critical      0.06        9.48           7.29           11   \n",
       "3    24844         Medium      0.09       78.69          19.99           14   \n",
       "4    24846         Medium      0.08        3.28           2.31           14   \n",
       "5    24847         Medium      0.05        3.28           4.20           14   \n",
       "6    24848         Medium      0.05        3.58           1.63           14   \n",
       "7    18181       Critical      0.00        4.42           4.99           15   \n",
       "8    20925         Medium      0.01       35.94           6.66           15   \n",
       "9    26267           High      0.04        2.98           1.58           16   \n",
       "10   26268           High      0.05      115.99           2.50           16   \n",
       "11   23890           High      0.05       26.48           6.93           18   \n",
       "12   24063  Not Specified      0.07       12.99           9.44           19   \n",
       "13    5890           High      0.05       26.48           6.93           21   \n",
       "14    6062  Not Specified      0.08        5.00           3.39           21   \n",
       "15    6063  Not Specified      0.07       12.99           9.44           21   \n",
       "16   20631           High      0.06       55.48          14.30           24   \n",
       "17   20632           High      0.02        1.68           1.57           24   \n",
       "18   23967  Not Specified      0.04        4.14           6.60           27   \n",
       "19   23509           High      0.08       34.99           7.73           32   \n",
       "\n",
       "           Customer Name       Ship Mode Customer Segment Product Category  \\\n",
       "0          Bonnie Potter     Express Air        Corporate  Office Supplies   \n",
       "1         Ronnie Proctor  Delivery Truck      Home Office        Furniture   \n",
       "2          Marcus Dunlap     Regular Air      Home Office        Furniture   \n",
       "3      Gwendolyn F Tyson     Regular Air   Small Business        Furniture   \n",
       "4      Gwendolyn F Tyson     Regular Air   Small Business  Office Supplies   \n",
       "5      Gwendolyn F Tyson     Regular Air   Small Business  Office Supplies   \n",
       "6      Gwendolyn F Tyson     Regular Air   Small Business  Office Supplies   \n",
       "7          Timothy Reese     Regular Air   Small Business  Office Supplies   \n",
       "8          Timothy Reese     Regular Air   Small Business  Office Supplies   \n",
       "9           Sarah Ramsey     Regular Air   Small Business  Office Supplies   \n",
       "10          Sarah Ramsey     Regular Air   Small Business       Technology   \n",
       "11          Laurie Hanna     Regular Air   Small Business        Furniture   \n",
       "12           Jim Rodgers     Regular Air   Small Business       Technology   \n",
       "13  Tony Wilkins Winters     Regular Air   Small Business        Furniture   \n",
       "14  Tony Wilkins Winters     Regular Air   Small Business  Office Supplies   \n",
       "15  Tony Wilkins Winters     Regular Air   Small Business       Technology   \n",
       "16           Edna Thomas     Regular Air        Corporate  Office Supplies   \n",
       "17           Edna Thomas     Regular Air        Corporate  Office Supplies   \n",
       "18         Guy Gallagher     Regular Air        Corporate        Furniture   \n",
       "19        Matthew Berman     Regular Air        Corporate  Office Supplies   \n",
       "\n",
       "    ...   Region State or Province           City  Postal Code Order Date  \\\n",
       "0   ...     West        Washington      Anacortes        98221 2015-01-07   \n",
       "1   ...     West        California    San Gabriel        91776 2015-06-13   \n",
       "2   ...     East        New Jersey        Roselle         7203 2015-02-15   \n",
       "3   ...  Central         Minnesota     Prior Lake        55372 2015-05-12   \n",
       "4   ...  Central         Minnesota     Prior Lake        55372 2015-05-12   \n",
       "5   ...  Central         Minnesota     Prior Lake        55372 2015-05-12   \n",
       "6   ...  Central         Minnesota     Prior Lake        55372 2015-05-12   \n",
       "7   ...     East          New York      Smithtown        11787 2015-04-08   \n",
       "8   ...     East          New York      Smithtown        11787 2015-05-28   \n",
       "9   ...     East          New York       Syracuse        13210 2015-02-12   \n",
       "10  ...     East          New York       Syracuse        13210 2015-02-12   \n",
       "11  ...     West           Montana         Helena        59601 2015-05-15   \n",
       "12  ...     West           Montana       Missoula        59801 2015-05-21   \n",
       "13  ...     East          New York  New York City        10012 2015-05-15   \n",
       "14  ...     East          New York  New York City        10012 2015-05-21   \n",
       "15  ...     East          New York  New York City        10012 2015-05-21   \n",
       "16  ...     West        California  Laguna Niguel        92677 2015-01-28   \n",
       "17  ...     West        California  Laguna Niguel        92677 2015-01-28   \n",
       "18  ...     West        California       Lakewood        90712 2015-05-02   \n",
       "19  ...     West            Oregon    Grants Pass        97526 2015-02-22   \n",
       "\n",
       "    Ship Date     Profit Quantity ordered new    Sales Order ID  \n",
       "0  2015-01-08     4.5600                    4    13.01    88522  \n",
       "1  2015-06-15  4390.3665                   12  6362.85    90193  \n",
       "2  2015-02-17   -53.8096                   22   211.15    90192  \n",
       "3  2015-05-14   803.4705                   16  1164.45    86838  \n",
       "4  2015-05-13   -24.0300                    7    22.23    86838  \n",
       "5  2015-05-13   -37.0300                    4    13.99    86838  \n",
       "6  2015-05-13    -0.7100                    4    14.26    86838  \n",
       "7  2015-04-09   -59.8200                    7    33.47    86837  \n",
       "8  2015-05-28   261.8757                   10   379.53    86839  \n",
       "9  2015-02-15     2.6300                    6    18.80    86836  \n",
       "10 2015-02-14   652.7331                   10   945.99    86836  \n",
       "11 2015-05-16   314.4813                   17   455.77    90031  \n",
       "12 2015-05-23  -114.6399                   18   231.79    90032  \n",
       "13 2015-05-16   384.3800                   70  1876.69    41793  \n",
       "14 2015-05-22   -17.4900                   58   293.06    42949  \n",
       "15 2015-05-23  -114.6399                   71   914.29    42949  \n",
       "16 2015-01-29   -28.2968                    1    67.49    87651  \n",
       "17 2015-01-30    -5.3072                    1     2.25    87651  \n",
       "18 2015-05-04     8.8940                   12    54.78    87652  \n",
       "19 2015-02-23   144.6900                   13   424.68    89199  \n",
       "\n",
       "[20 rows x 25 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d1 = df[\"Orders\"]\n",
    "d1.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "7513fafd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1952, 25)\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1952 entries, 0 to 1951\n",
      "Data columns (total 25 columns):\n",
      " #   Column                Non-Null Count  Dtype         \n",
      "---  ------                --------------  -----         \n",
      " 0   Row ID                1952 non-null   int64         \n",
      " 1   Order Priority        1952 non-null   object        \n",
      " 2   Discount              1952 non-null   float64       \n",
      " 3   Unit Price            1952 non-null   float64       \n",
      " 4   Shipping Cost         1952 non-null   float64       \n",
      " 5   Customer ID           1952 non-null   int64         \n",
      " 6   Customer Name         1952 non-null   object        \n",
      " 7   Ship Mode             1952 non-null   object        \n",
      " 8   Customer Segment      1952 non-null   object        \n",
      " 9   Product Category      1952 non-null   object        \n",
      " 10  Product Sub-Category  1952 non-null   object        \n",
      " 11  Product Container     1952 non-null   object        \n",
      " 12  Product Name          1952 non-null   object        \n",
      " 13  Product Base Margin   1936 non-null   float64       \n",
      " 14  Country               1952 non-null   object        \n",
      " 15  Region                1952 non-null   object        \n",
      " 16  State or Province     1952 non-null   object        \n",
      " 17  City                  1952 non-null   object        \n",
      " 18  Postal Code           1952 non-null   int64         \n",
      " 19  Order Date            1952 non-null   datetime64[ns]\n",
      " 20  Ship Date             1952 non-null   datetime64[ns]\n",
      " 21  Profit                1952 non-null   float64       \n",
      " 22  Quantity ordered new  1952 non-null   int64         \n",
      " 23  Sales                 1952 non-null   float64       \n",
      " 24  Order ID              1952 non-null   int64         \n",
      "dtypes: datetime64[ns](2), float64(6), int64(5), object(12)\n",
      "memory usage: 381.4+ KB\n"
     ]
    }
   ],
   "source": [
    "print(d1.shape)\n",
    "d1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "29b5097d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "798758af",
   "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>Row ID</th>\n",
       "      <th>Order Priority</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Customer ID</th>\n",
       "      <th>Customer Name</th>\n",
       "      <th>Ship Mode</th>\n",
       "      <th>Customer Segment</th>\n",
       "      <th>Product Category</th>\n",
       "      <th>...</th>\n",
       "      <th>Region</th>\n",
       "      <th>State or Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Order Date</th>\n",
       "      <th>Ship Date</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Order ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>24844</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.09</td>\n",
       "      <td>78.69</td>\n",
       "      <td>19.99</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-14</td>\n",
       "      <td>803.47050</td>\n",
       "      <td>16</td>\n",
       "      <td>1164.45</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>24846</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.08</td>\n",
       "      <td>3.28</td>\n",
       "      <td>2.31</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-13</td>\n",
       "      <td>-24.03000</td>\n",
       "      <td>7</td>\n",
       "      <td>22.23</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>24847</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.05</td>\n",
       "      <td>3.28</td>\n",
       "      <td>4.20</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-13</td>\n",
       "      <td>-37.03000</td>\n",
       "      <td>4</td>\n",
       "      <td>13.99</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>24848</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.05</td>\n",
       "      <td>3.58</td>\n",
       "      <td>1.63</td>\n",
       "      <td>14</td>\n",
       "      <td>Gwendolyn F Tyson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Minnesota</td>\n",
       "      <td>Prior Lake</td>\n",
       "      <td>55372</td>\n",
       "      <td>2015-05-12</td>\n",
       "      <td>2015-05-13</td>\n",
       "      <td>-0.71000</td>\n",
       "      <td>4</td>\n",
       "      <td>14.26</td>\n",
       "      <td>86838</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>22890</td>\n",
       "      <td>High</td>\n",
       "      <td>0.02</td>\n",
       "      <td>5.98</td>\n",
       "      <td>5.15</td>\n",
       "      <td>62</td>\n",
       "      <td>Pam Gilbert</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Texas</td>\n",
       "      <td>Round Rock</td>\n",
       "      <td>78664</td>\n",
       "      <td>2015-05-09</td>\n",
       "      <td>2015-05-11</td>\n",
       "      <td>2.14000</td>\n",
       "      <td>3</td>\n",
       "      <td>22.85</td>\n",
       "      <td>87407</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1922</th>\n",
       "      <td>23887</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.03</td>\n",
       "      <td>4.98</td>\n",
       "      <td>4.95</td>\n",
       "      <td>3361</td>\n",
       "      <td>Oscar Kenney</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Wisconsin</td>\n",
       "      <td>West Bend</td>\n",
       "      <td>53095</td>\n",
       "      <td>2015-06-09</td>\n",
       "      <td>2015-06-11</td>\n",
       "      <td>-47.99525</td>\n",
       "      <td>19</td>\n",
       "      <td>95.00</td>\n",
       "      <td>91438</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1946</th>\n",
       "      <td>20624</td>\n",
       "      <td>Low</td>\n",
       "      <td>0.00</td>\n",
       "      <td>1270.99</td>\n",
       "      <td>19.99</td>\n",
       "      <td>3397</td>\n",
       "      <td>Andrea Shaw</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>Danville</td>\n",
       "      <td>61832</td>\n",
       "      <td>2015-06-07</td>\n",
       "      <td>2015-06-09</td>\n",
       "      <td>6384.43890</td>\n",
       "      <td>7</td>\n",
       "      <td>9252.81</td>\n",
       "      <td>87535</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>19842</td>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>10.90</td>\n",
       "      <td>7.46</td>\n",
       "      <td>3397</td>\n",
       "      <td>Andrea Shaw</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>Danville</td>\n",
       "      <td>61832</td>\n",
       "      <td>2015-03-11</td>\n",
       "      <td>2015-03-12</td>\n",
       "      <td>-116.76000</td>\n",
       "      <td>18</td>\n",
       "      <td>207.31</td>\n",
       "      <td>87536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>19843</td>\n",
       "      <td>High</td>\n",
       "      <td>0.10</td>\n",
       "      <td>7.99</td>\n",
       "      <td>5.03</td>\n",
       "      <td>3397</td>\n",
       "      <td>Andrea Shaw</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Technology</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>Danville</td>\n",
       "      <td>61832</td>\n",
       "      <td>2015-03-11</td>\n",
       "      <td>2015-03-12</td>\n",
       "      <td>-160.95200</td>\n",
       "      <td>22</td>\n",
       "      <td>143.12</td>\n",
       "      <td>87536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>26208</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.08</td>\n",
       "      <td>11.97</td>\n",
       "      <td>5.81</td>\n",
       "      <td>3399</td>\n",
       "      <td>Marvin Reid</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Central</td>\n",
       "      <td>Illinois</td>\n",
       "      <td>Des Plaines</td>\n",
       "      <td>60016</td>\n",
       "      <td>2015-03-29</td>\n",
       "      <td>2015-03-31</td>\n",
       "      <td>-41.87000</td>\n",
       "      <td>5</td>\n",
       "      <td>59.98</td>\n",
       "      <td>87534</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>566 rows × 25 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Row ID Order Priority  Discount  Unit Price  Shipping Cost  Customer ID  \\\n",
       "3      24844         Medium      0.09       78.69          19.99           14   \n",
       "4      24846         Medium      0.08        3.28           2.31           14   \n",
       "5      24847         Medium      0.05        3.28           4.20           14   \n",
       "6      24848         Medium      0.05        3.58           1.63           14   \n",
       "31     22890           High      0.02        5.98           5.15           62   \n",
       "...      ...            ...       ...         ...            ...          ...   \n",
       "1922   23887         Medium      0.03        4.98           4.95         3361   \n",
       "1946   20624            Low      0.00     1270.99          19.99         3397   \n",
       "1947   19842           High      0.01       10.90           7.46         3397   \n",
       "1948   19843           High      0.10        7.99           5.03         3397   \n",
       "1949   26208  Not Specified      0.08       11.97           5.81         3399   \n",
       "\n",
       "          Customer Name    Ship Mode Customer Segment Product Category  ...  \\\n",
       "3     Gwendolyn F Tyson  Regular Air   Small Business        Furniture  ...   \n",
       "4     Gwendolyn F Tyson  Regular Air   Small Business  Office Supplies  ...   \n",
       "5     Gwendolyn F Tyson  Regular Air   Small Business  Office Supplies  ...   \n",
       "6     Gwendolyn F Tyson  Regular Air   Small Business  Office Supplies  ...   \n",
       "31          Pam Gilbert  Regular Air        Corporate  Office Supplies  ...   \n",
       "...                 ...          ...              ...              ...  ...   \n",
       "1922       Oscar Kenney  Regular Air      Home Office  Office Supplies  ...   \n",
       "1946        Andrea Shaw  Regular Air   Small Business  Office Supplies  ...   \n",
       "1947        Andrea Shaw  Regular Air   Small Business  Office Supplies  ...   \n",
       "1948        Andrea Shaw  Regular Air   Small Business       Technology  ...   \n",
       "1949        Marvin Reid  Regular Air   Small Business  Office Supplies  ...   \n",
       "\n",
       "       Region State or Province         City  Postal Code Order Date  \\\n",
       "3     Central         Minnesota   Prior Lake        55372 2015-05-12   \n",
       "4     Central         Minnesota   Prior Lake        55372 2015-05-12   \n",
       "5     Central         Minnesota   Prior Lake        55372 2015-05-12   \n",
       "6     Central         Minnesota   Prior Lake        55372 2015-05-12   \n",
       "31    Central             Texas   Round Rock        78664 2015-05-09   \n",
       "...       ...               ...          ...          ...        ...   \n",
       "1922  Central         Wisconsin    West Bend        53095 2015-06-09   \n",
       "1946  Central          Illinois     Danville        61832 2015-06-07   \n",
       "1947  Central          Illinois     Danville        61832 2015-03-11   \n",
       "1948  Central          Illinois     Danville        61832 2015-03-11   \n",
       "1949  Central          Illinois  Des Plaines        60016 2015-03-29   \n",
       "\n",
       "      Ship Date      Profit Quantity ordered new    Sales Order ID  \n",
       "3    2015-05-14   803.47050                   16  1164.45    86838  \n",
       "4    2015-05-13   -24.03000                    7    22.23    86838  \n",
       "5    2015-05-13   -37.03000                    4    13.99    86838  \n",
       "6    2015-05-13    -0.71000                    4    14.26    86838  \n",
       "31   2015-05-11     2.14000                    3    22.85    87407  \n",
       "...         ...         ...                  ...      ...      ...  \n",
       "1922 2015-06-11   -47.99525                   19    95.00    91438  \n",
       "1946 2015-06-09  6384.43890                    7  9252.81    87535  \n",
       "1947 2015-03-12  -116.76000                   18   207.31    87536  \n",
       "1948 2015-03-12  -160.95200                   22   143.12    87536  \n",
       "1949 2015-03-31   -41.87000                    5    59.98    87534  \n",
       "\n",
       "[566 rows x 25 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d1[d1[\"Region\"]==\"Central\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "556b6dd8",
   "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>Order ID</th>\n",
       "      <th>Status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>65</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>612</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>614</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>678</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>710</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>740</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>775</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>833</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>902</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>3300</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>3456</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3525</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3589</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>3687</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>3777</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>3783</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>4006</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>4037</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4230</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>4261</td>\n",
       "      <td>Returned</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Order ID    Status\n",
       "0         65  Returned\n",
       "1        612  Returned\n",
       "2        614  Returned\n",
       "3        678  Returned\n",
       "4        710  Returned\n",
       "5        740  Returned\n",
       "6        775  Returned\n",
       "7        833  Returned\n",
       "8        902  Returned\n",
       "9       3300  Returned\n",
       "10      3456  Returned\n",
       "11      3525  Returned\n",
       "12      3589  Returned\n",
       "13      3687  Returned\n",
       "14      3777  Returned\n",
       "15      3783  Returned\n",
       "16      4006  Returned\n",
       "17      4037  Returned\n",
       "18      4230  Returned\n",
       "19      4261  Returned"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2 = df[\"Returns\"]\n",
    "d2.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "a0b333d5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(1634, 2)\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1634 entries, 0 to 1633\n",
      "Data columns (total 2 columns):\n",
      " #   Column    Non-Null Count  Dtype \n",
      "---  ------    --------------  ----- \n",
      " 0   Order ID  1634 non-null   int64 \n",
      " 1   Status    1634 non-null   object\n",
      "dtypes: int64(1), object(1)\n",
      "memory usage: 25.7+ KB\n"
     ]
    }
   ],
   "source": [
    "print(d2.shape)\n",
    "d2.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "e8cab701",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Returned'], dtype=object)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d2[\"Status\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "9a01c5f4",
   "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>Region</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Central</td>\n",
       "      <td>Chris</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>East</td>\n",
       "      <td>Erin</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>South</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>West</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Region  Manager\n",
       "0  Central    Chris\n",
       "1     East     Erin\n",
       "2    South      Sam\n",
       "3     West  William"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "d3 = df[\"Users\"]\n",
    "d3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "29f20385",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(4, 2)\n",
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 4 entries, 0 to 3\n",
      "Data columns (total 2 columns):\n",
      " #   Column   Non-Null Count  Dtype \n",
      "---  ------   --------------  ----- \n",
      " 0   Region   4 non-null      object\n",
      " 1   Manager  4 non-null      object\n",
      "dtypes: object(2)\n",
      "memory usage: 192.0+ bytes\n"
     ]
    }
   ],
   "source": [
    "print(d3.shape)\n",
    "d3.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "8cc10d5e",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "b337067e",
   "metadata": {},
   "outputs": [],
   "source": [
    "result = pd.merge(d1, d3, on=[\"Region\", \"Region\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "c1f0e6c7",
   "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>Row ID</th>\n",
       "      <th>Order Priority</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Customer ID</th>\n",
       "      <th>Customer Name</th>\n",
       "      <th>Ship Mode</th>\n",
       "      <th>Customer Segment</th>\n",
       "      <th>Product Category</th>\n",
       "      <th>...</th>\n",
       "      <th>State or Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Order Date</th>\n",
       "      <th>Ship Date</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Order ID</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>20847</td>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>2.84</td>\n",
       "      <td>0.93</td>\n",
       "      <td>3</td>\n",
       "      <td>Bonnie Potter</td>\n",
       "      <td>Express Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Anacortes</td>\n",
       "      <td>98221</td>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>2015-01-08</td>\n",
       "      <td>4.5600</td>\n",
       "      <td>4</td>\n",
       "      <td>13.01</td>\n",
       "      <td>88522</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20228</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.02</td>\n",
       "      <td>500.98</td>\n",
       "      <td>26.00</td>\n",
       "      <td>5</td>\n",
       "      <td>Ronnie Proctor</td>\n",
       "      <td>Delivery Truck</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>California</td>\n",
       "      <td>San Gabriel</td>\n",
       "      <td>91776</td>\n",
       "      <td>2015-06-13</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>4390.3665</td>\n",
       "      <td>12</td>\n",
       "      <td>6362.85</td>\n",
       "      <td>90193</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>23890</td>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>18</td>\n",
       "      <td>Laurie Hanna</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Helena</td>\n",
       "      <td>59601</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2015-05-16</td>\n",
       "      <td>314.4813</td>\n",
       "      <td>17</td>\n",
       "      <td>455.77</td>\n",
       "      <td>90031</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>24063</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.07</td>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>19</td>\n",
       "      <td>Jim Rodgers</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Technology</td>\n",
       "      <td>...</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Missoula</td>\n",
       "      <td>59801</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-23</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>18</td>\n",
       "      <td>231.79</td>\n",
       "      <td>90032</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>20631</td>\n",
       "      <td>High</td>\n",
       "      <td>0.06</td>\n",
       "      <td>55.48</td>\n",
       "      <td>14.30</td>\n",
       "      <td>24</td>\n",
       "      <td>Edna Thomas</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>California</td>\n",
       "      <td>Laguna Niguel</td>\n",
       "      <td>92677</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-29</td>\n",
       "      <td>-28.2968</td>\n",
       "      <td>1</td>\n",
       "      <td>67.49</td>\n",
       "      <td>87651</td>\n",
       "      <td>William</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>23181</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>315.98</td>\n",
       "      <td>19.99</td>\n",
       "      <td>3380</td>\n",
       "      <td>Eva Decker</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>La Grange</td>\n",
       "      <td>30240</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-22</td>\n",
       "      <td>-4.4800</td>\n",
       "      <td>18</td>\n",
       "      <td>5572.18</td>\n",
       "      <td>88838</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>23182</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.09</td>\n",
       "      <td>276.20</td>\n",
       "      <td>24.49</td>\n",
       "      <td>3380</td>\n",
       "      <td>Eva Decker</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>La Grange</td>\n",
       "      <td>30240</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>3193.2840</td>\n",
       "      <td>11</td>\n",
       "      <td>2941.42</td>\n",
       "      <td>88838</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>23183</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>63.94</td>\n",
       "      <td>14.48</td>\n",
       "      <td>3380</td>\n",
       "      <td>Eva Decker</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>La Grange</td>\n",
       "      <td>30240</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>43.6917</td>\n",
       "      <td>8</td>\n",
       "      <td>522.46</td>\n",
       "      <td>88838</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950</th>\n",
       "      <td>24161</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.05</td>\n",
       "      <td>11.97</td>\n",
       "      <td>5.81</td>\n",
       "      <td>3381</td>\n",
       "      <td>Christopher Norton Patterson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>Macon</td>\n",
       "      <td>31204</td>\n",
       "      <td>2015-03-23</td>\n",
       "      <td>2015-03-25</td>\n",
       "      <td>349.0593</td>\n",
       "      <td>2</td>\n",
       "      <td>25.31</td>\n",
       "      <td>88836</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>25841</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.02</td>\n",
       "      <td>28.53</td>\n",
       "      <td>1.49</td>\n",
       "      <td>3381</td>\n",
       "      <td>Christopher Norton Patterson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>Macon</td>\n",
       "      <td>31204</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>1.9920</td>\n",
       "      <td>18</td>\n",
       "      <td>513.33</td>\n",
       "      <td>88840</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1952 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Row ID Order Priority  Discount  Unit Price  Shipping Cost  Customer ID  \\\n",
       "0      20847           High      0.01        2.84           0.93            3   \n",
       "1      20228  Not Specified      0.02      500.98          26.00            5   \n",
       "2      23890           High      0.05       26.48           6.93           18   \n",
       "3      24063  Not Specified      0.07       12.99           9.44           19   \n",
       "4      20631           High      0.06       55.48          14.30           24   \n",
       "...      ...            ...       ...         ...            ...          ...   \n",
       "1947   23181       Critical      0.03      315.98          19.99         3380   \n",
       "1948   23182       Critical      0.09      276.20          24.49         3380   \n",
       "1949   23183       Critical      0.03       63.94          14.48         3380   \n",
       "1950   24161  Not Specified      0.05       11.97           5.81         3381   \n",
       "1951   25841         Medium      0.02       28.53           1.49         3381   \n",
       "\n",
       "                     Customer Name       Ship Mode Customer Segment  \\\n",
       "0                    Bonnie Potter     Express Air        Corporate   \n",
       "1                   Ronnie Proctor  Delivery Truck      Home Office   \n",
       "2                     Laurie Hanna     Regular Air   Small Business   \n",
       "3                      Jim Rodgers     Regular Air   Small Business   \n",
       "4                      Edna Thomas     Regular Air        Corporate   \n",
       "...                            ...             ...              ...   \n",
       "1947                    Eva Decker     Regular Air      Home Office   \n",
       "1948                    Eva Decker     Regular Air      Home Office   \n",
       "1949                    Eva Decker     Regular Air      Home Office   \n",
       "1950  Christopher Norton Patterson     Regular Air        Corporate   \n",
       "1951  Christopher Norton Patterson     Regular Air      Home Office   \n",
       "\n",
       "     Product Category  ... State or Province           City Postal Code  \\\n",
       "0     Office Supplies  ...        Washington      Anacortes       98221   \n",
       "1           Furniture  ...        California    San Gabriel       91776   \n",
       "2           Furniture  ...           Montana         Helena       59601   \n",
       "3          Technology  ...           Montana       Missoula       59801   \n",
       "4     Office Supplies  ...        California  Laguna Niguel       92677   \n",
       "...               ...  ...               ...            ...         ...   \n",
       "1947  Office Supplies  ...           Georgia      La Grange       30240   \n",
       "1948        Furniture  ...           Georgia      La Grange       30240   \n",
       "1949        Furniture  ...           Georgia      La Grange       30240   \n",
       "1950  Office Supplies  ...           Georgia          Macon       31204   \n",
       "1951  Office Supplies  ...           Georgia          Macon       31204   \n",
       "\n",
       "      Order Date  Ship Date     Profit Quantity ordered new    Sales  \\\n",
       "0     2015-01-07 2015-01-08     4.5600                    4    13.01   \n",
       "1     2015-06-13 2015-06-15  4390.3665                   12  6362.85   \n",
       "2     2015-05-15 2015-05-16   314.4813                   17   455.77   \n",
       "3     2015-05-21 2015-05-23  -114.6399                   18   231.79   \n",
       "4     2015-01-28 2015-01-29   -28.2968                    1    67.49   \n",
       "...          ...        ...        ...                  ...      ...   \n",
       "1947  2015-04-20 2015-04-22    -4.4800                   18  5572.18   \n",
       "1948  2015-04-20 2015-04-21  3193.2840                   11  2941.42   \n",
       "1949  2015-04-20 2015-04-21    43.6917                    8   522.46   \n",
       "1950  2015-03-23 2015-03-25   349.0593                    2    25.31   \n",
       "1951  2015-04-29 2015-04-29     1.9920                   18   513.33   \n",
       "\n",
       "      Order ID  Manager  \n",
       "0        88522  William  \n",
       "1        90193  William  \n",
       "2        90031  William  \n",
       "3        90032  William  \n",
       "4        87651  William  \n",
       "...        ...      ...  \n",
       "1947     88838      Sam  \n",
       "1948     88838      Sam  \n",
       "1949     88838      Sam  \n",
       "1950     88836      Sam  \n",
       "1951     88840      Sam  \n",
       "\n",
       "[1952 rows x 26 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "19efa982",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "Int64Index: 1952 entries, 0 to 1951\n",
      "Data columns (total 26 columns):\n",
      " #   Column                Non-Null Count  Dtype         \n",
      "---  ------                --------------  -----         \n",
      " 0   Row ID                1952 non-null   int64         \n",
      " 1   Order Priority        1952 non-null   object        \n",
      " 2   Discount              1952 non-null   float64       \n",
      " 3   Unit Price            1952 non-null   float64       \n",
      " 4   Shipping Cost         1952 non-null   float64       \n",
      " 5   Customer ID           1952 non-null   int64         \n",
      " 6   Customer Name         1952 non-null   object        \n",
      " 7   Ship Mode             1952 non-null   object        \n",
      " 8   Customer Segment      1952 non-null   object        \n",
      " 9   Product Category      1952 non-null   object        \n",
      " 10  Product Sub-Category  1952 non-null   object        \n",
      " 11  Product Container     1952 non-null   object        \n",
      " 12  Product Name          1952 non-null   object        \n",
      " 13  Product Base Margin   1936 non-null   float64       \n",
      " 14  Country               1952 non-null   object        \n",
      " 15  Region                1952 non-null   object        \n",
      " 16  State or Province     1952 non-null   object        \n",
      " 17  City                  1952 non-null   object        \n",
      " 18  Postal Code           1952 non-null   int64         \n",
      " 19  Order Date            1952 non-null   datetime64[ns]\n",
      " 20  Ship Date             1952 non-null   datetime64[ns]\n",
      " 21  Profit                1952 non-null   float64       \n",
      " 22  Quantity ordered new  1952 non-null   int64         \n",
      " 23  Sales                 1952 non-null   float64       \n",
      " 24  Order ID              1952 non-null   int64         \n",
      " 25  Manager               1952 non-null   object        \n",
      "dtypes: datetime64[ns](2), float64(6), int64(5), object(13)\n",
      "memory usage: 411.8+ KB\n"
     ]
    }
   ],
   "source": [
    "result.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b7332637",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "30005c9e",
   "metadata": {},
   "outputs": [],
   "source": [
    "#result.to_excel(\"dump.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "6c450704",
   "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>Unnamed: 0</th>\n",
       "      <th>Row ID</th>\n",
       "      <th>Order Priority</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Customer ID</th>\n",
       "      <th>Customer Name</th>\n",
       "      <th>Ship Mode</th>\n",
       "      <th>Customer Segment</th>\n",
       "      <th>...</th>\n",
       "      <th>State or Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Order Date</th>\n",
       "      <th>Ship Date</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Order ID</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>20847</td>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>2.84</td>\n",
       "      <td>0.93</td>\n",
       "      <td>3</td>\n",
       "      <td>Bonnie Potter</td>\n",
       "      <td>Express Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>...</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Anacortes</td>\n",
       "      <td>98221</td>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>2015-01-08</td>\n",
       "      <td>4.5600</td>\n",
       "      <td>4</td>\n",
       "      <td>13.01</td>\n",
       "      <td>88522</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>20228</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.02</td>\n",
       "      <td>500.98</td>\n",
       "      <td>26.00</td>\n",
       "      <td>5</td>\n",
       "      <td>Ronnie Proctor</td>\n",
       "      <td>Delivery Truck</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>...</td>\n",
       "      <td>California</td>\n",
       "      <td>San Gabriel</td>\n",
       "      <td>91776</td>\n",
       "      <td>2015-06-13</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>4390.3665</td>\n",
       "      <td>12</td>\n",
       "      <td>6362.85</td>\n",
       "      <td>90193</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>23890</td>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>18</td>\n",
       "      <td>Laurie Hanna</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>...</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Helena</td>\n",
       "      <td>59601</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2015-05-16</td>\n",
       "      <td>314.4813</td>\n",
       "      <td>17</td>\n",
       "      <td>455.77</td>\n",
       "      <td>90031</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>24063</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.07</td>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>19</td>\n",
       "      <td>Jim Rodgers</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>...</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Missoula</td>\n",
       "      <td>59801</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-23</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>18</td>\n",
       "      <td>231.79</td>\n",
       "      <td>90032</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>20631</td>\n",
       "      <td>High</td>\n",
       "      <td>0.06</td>\n",
       "      <td>55.48</td>\n",
       "      <td>14.30</td>\n",
       "      <td>24</td>\n",
       "      <td>Edna Thomas</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>...</td>\n",
       "      <td>California</td>\n",
       "      <td>Laguna Niguel</td>\n",
       "      <td>92677</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-29</td>\n",
       "      <td>-28.2968</td>\n",
       "      <td>1</td>\n",
       "      <td>67.49</td>\n",
       "      <td>87651</td>\n",
       "      <td>William</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>1947</td>\n",
       "      <td>23181</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>315.98</td>\n",
       "      <td>19.99</td>\n",
       "      <td>3380</td>\n",
       "      <td>Eva Decker</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>La Grange</td>\n",
       "      <td>30240</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-22</td>\n",
       "      <td>-4.4800</td>\n",
       "      <td>18</td>\n",
       "      <td>5572.18</td>\n",
       "      <td>88838</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>1948</td>\n",
       "      <td>23182</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.09</td>\n",
       "      <td>276.20</td>\n",
       "      <td>24.49</td>\n",
       "      <td>3380</td>\n",
       "      <td>Eva Decker</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>La Grange</td>\n",
       "      <td>30240</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>3193.2840</td>\n",
       "      <td>11</td>\n",
       "      <td>2941.42</td>\n",
       "      <td>88838</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>1949</td>\n",
       "      <td>23183</td>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>63.94</td>\n",
       "      <td>14.48</td>\n",
       "      <td>3380</td>\n",
       "      <td>Eva Decker</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>La Grange</td>\n",
       "      <td>30240</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>43.6917</td>\n",
       "      <td>8</td>\n",
       "      <td>522.46</td>\n",
       "      <td>88838</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950</th>\n",
       "      <td>1950</td>\n",
       "      <td>24161</td>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.05</td>\n",
       "      <td>11.97</td>\n",
       "      <td>5.81</td>\n",
       "      <td>3381</td>\n",
       "      <td>Christopher Norton Patterson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>Macon</td>\n",
       "      <td>31204</td>\n",
       "      <td>2015-03-23</td>\n",
       "      <td>2015-03-25</td>\n",
       "      <td>349.0593</td>\n",
       "      <td>2</td>\n",
       "      <td>25.31</td>\n",
       "      <td>88836</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>1951</td>\n",
       "      <td>25841</td>\n",
       "      <td>Medium</td>\n",
       "      <td>0.02</td>\n",
       "      <td>28.53</td>\n",
       "      <td>1.49</td>\n",
       "      <td>3381</td>\n",
       "      <td>Christopher Norton Patterson</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>...</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>Macon</td>\n",
       "      <td>31204</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>1.9920</td>\n",
       "      <td>18</td>\n",
       "      <td>513.33</td>\n",
       "      <td>88840</td>\n",
       "      <td>Sam</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1952 rows × 27 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unnamed: 0  Row ID Order Priority  Discount  Unit Price  Shipping Cost  \\\n",
       "0              0   20847           High      0.01        2.84           0.93   \n",
       "1              1   20228  Not Specified      0.02      500.98          26.00   \n",
       "2              2   23890           High      0.05       26.48           6.93   \n",
       "3              3   24063  Not Specified      0.07       12.99           9.44   \n",
       "4              4   20631           High      0.06       55.48          14.30   \n",
       "...          ...     ...            ...       ...         ...            ...   \n",
       "1947        1947   23181       Critical      0.03      315.98          19.99   \n",
       "1948        1948   23182       Critical      0.09      276.20          24.49   \n",
       "1949        1949   23183       Critical      0.03       63.94          14.48   \n",
       "1950        1950   24161  Not Specified      0.05       11.97           5.81   \n",
       "1951        1951   25841         Medium      0.02       28.53           1.49   \n",
       "\n",
       "      Customer ID                 Customer Name       Ship Mode  \\\n",
       "0               3                 Bonnie Potter     Express Air   \n",
       "1               5                Ronnie Proctor  Delivery Truck   \n",
       "2              18                  Laurie Hanna     Regular Air   \n",
       "3              19                   Jim Rodgers     Regular Air   \n",
       "4              24                   Edna Thomas     Regular Air   \n",
       "...           ...                           ...             ...   \n",
       "1947         3380                    Eva Decker     Regular Air   \n",
       "1948         3380                    Eva Decker     Regular Air   \n",
       "1949         3380                    Eva Decker     Regular Air   \n",
       "1950         3381  Christopher Norton Patterson     Regular Air   \n",
       "1951         3381  Christopher Norton Patterson     Regular Air   \n",
       "\n",
       "     Customer Segment  ... State or Province           City Postal Code  \\\n",
       "0           Corporate  ...        Washington      Anacortes       98221   \n",
       "1         Home Office  ...        California    San Gabriel       91776   \n",
       "2      Small Business  ...           Montana         Helena       59601   \n",
       "3      Small Business  ...           Montana       Missoula       59801   \n",
       "4           Corporate  ...        California  Laguna Niguel       92677   \n",
       "...               ...  ...               ...            ...         ...   \n",
       "1947      Home Office  ...           Georgia      La Grange       30240   \n",
       "1948      Home Office  ...           Georgia      La Grange       30240   \n",
       "1949      Home Office  ...           Georgia      La Grange       30240   \n",
       "1950        Corporate  ...           Georgia          Macon       31204   \n",
       "1951      Home Office  ...           Georgia          Macon       31204   \n",
       "\n",
       "     Order Date  Ship Date     Profit Quantity ordered new    Sales Order ID  \\\n",
       "0    2015-01-07 2015-01-08     4.5600                    4    13.01    88522   \n",
       "1    2015-06-13 2015-06-15  4390.3665                   12  6362.85    90193   \n",
       "2    2015-05-15 2015-05-16   314.4813                   17   455.77    90031   \n",
       "3    2015-05-21 2015-05-23  -114.6399                   18   231.79    90032   \n",
       "4    2015-01-28 2015-01-29   -28.2968                    1    67.49    87651   \n",
       "...         ...        ...        ...                  ...      ...      ...   \n",
       "1947 2015-04-20 2015-04-22    -4.4800                   18  5572.18    88838   \n",
       "1948 2015-04-20 2015-04-21  3193.2840                   11  2941.42    88838   \n",
       "1949 2015-04-20 2015-04-21    43.6917                    8   522.46    88838   \n",
       "1950 2015-03-23 2015-03-25   349.0593                    2    25.31    88836   \n",
       "1951 2015-04-29 2015-04-29     1.9920                   18   513.33    88840   \n",
       "\n",
       "      Manager  \n",
       "0     William  \n",
       "1     William  \n",
       "2     William  \n",
       "3     William  \n",
       "4     William  \n",
       "...       ...  \n",
       "1947      Sam  \n",
       "1948      Sam  \n",
       "1949      Sam  \n",
       "1950      Sam  \n",
       "1951      Sam  \n",
       "\n",
       "[1952 rows x 27 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_excel(\"dump.xlsx\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "7c4e8594",
   "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>Row ID</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Customer ID</th>\n",
       "      <th>Product Base Margin</th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Order ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Row ID</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.018215</td>\n",
       "      <td>-0.004427</td>\n",
       "      <td>-0.016027</td>\n",
       "      <td>0.064071</td>\n",
       "      <td>0.000137</td>\n",
       "      <td>0.033578</td>\n",
       "      <td>-0.038468</td>\n",
       "      <td>-0.568939</td>\n",
       "      <td>-0.258827</td>\n",
       "      <td>0.918497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Discount</th>\n",
       "      <td>0.018215</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.008202</td>\n",
       "      <td>0.039908</td>\n",
       "      <td>0.014534</td>\n",
       "      <td>0.018656</td>\n",
       "      <td>-0.025247</td>\n",
       "      <td>-0.061821</td>\n",
       "      <td>-0.009398</td>\n",
       "      <td>-0.030287</td>\n",
       "      <td>0.016719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unit Price</th>\n",
       "      <td>-0.004427</td>\n",
       "      <td>-0.008202</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.198793</td>\n",
       "      <td>-0.008717</td>\n",
       "      <td>0.029086</td>\n",
       "      <td>0.016086</td>\n",
       "      <td>-0.182067</td>\n",
       "      <td>-0.072472</td>\n",
       "      <td>0.443509</td>\n",
       "      <td>0.003292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shipping Cost</th>\n",
       "      <td>-0.016027</td>\n",
       "      <td>0.039908</td>\n",
       "      <td>0.198793</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.016805</td>\n",
       "      <td>0.361952</td>\n",
       "      <td>-0.033903</td>\n",
       "      <td>0.002177</td>\n",
       "      <td>-0.009735</td>\n",
       "      <td>0.322133</td>\n",
       "      <td>-0.014691</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Customer ID</th>\n",
       "      <td>0.064071</td>\n",
       "      <td>0.014534</td>\n",
       "      <td>-0.008717</td>\n",
       "      <td>-0.016805</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.033060</td>\n",
       "      <td>-0.096491</td>\n",
       "      <td>0.008852</td>\n",
       "      <td>-0.027582</td>\n",
       "      <td>-0.015412</td>\n",
       "      <td>0.069118</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Product Base Margin</th>\n",
       "      <td>0.000137</td>\n",
       "      <td>0.018656</td>\n",
       "      <td>0.029086</td>\n",
       "      <td>0.361952</td>\n",
       "      <td>-0.033060</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.002925</td>\n",
       "      <td>-0.059523</td>\n",
       "      <td>0.002578</td>\n",
       "      <td>0.105838</td>\n",
       "      <td>0.009389</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Postal Code</th>\n",
       "      <td>0.033578</td>\n",
       "      <td>-0.025247</td>\n",
       "      <td>0.016086</td>\n",
       "      <td>-0.033903</td>\n",
       "      <td>-0.096491</td>\n",
       "      <td>0.002925</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.033033</td>\n",
       "      <td>-0.015628</td>\n",
       "      <td>-0.019699</td>\n",
       "      <td>0.052141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Profit</th>\n",
       "      <td>-0.038468</td>\n",
       "      <td>-0.061821</td>\n",
       "      <td>-0.182067</td>\n",
       "      <td>0.002177</td>\n",
       "      <td>0.008852</td>\n",
       "      <td>-0.059523</td>\n",
       "      <td>0.033033</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.118363</td>\n",
       "      <td>0.364258</td>\n",
       "      <td>-0.031008</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <td>-0.568939</td>\n",
       "      <td>-0.009398</td>\n",
       "      <td>-0.072472</td>\n",
       "      <td>-0.009735</td>\n",
       "      <td>-0.027582</td>\n",
       "      <td>0.002578</td>\n",
       "      <td>-0.015628</td>\n",
       "      <td>0.118363</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.303099</td>\n",
       "      <td>-0.589746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales</th>\n",
       "      <td>-0.258827</td>\n",
       "      <td>-0.030287</td>\n",
       "      <td>0.443509</td>\n",
       "      <td>0.322133</td>\n",
       "      <td>-0.015412</td>\n",
       "      <td>0.105838</td>\n",
       "      <td>-0.019699</td>\n",
       "      <td>0.364258</td>\n",
       "      <td>0.303099</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.270939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Order ID</th>\n",
       "      <td>0.918497</td>\n",
       "      <td>0.016719</td>\n",
       "      <td>0.003292</td>\n",
       "      <td>-0.014691</td>\n",
       "      <td>0.069118</td>\n",
       "      <td>0.009389</td>\n",
       "      <td>0.052141</td>\n",
       "      <td>-0.031008</td>\n",
       "      <td>-0.589746</td>\n",
       "      <td>-0.270939</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        Row ID  Discount  Unit Price  Shipping Cost  \\\n",
       "Row ID                1.000000  0.018215   -0.004427      -0.016027   \n",
       "Discount              0.018215  1.000000   -0.008202       0.039908   \n",
       "Unit Price           -0.004427 -0.008202    1.000000       0.198793   \n",
       "Shipping Cost        -0.016027  0.039908    0.198793       1.000000   \n",
       "Customer ID           0.064071  0.014534   -0.008717      -0.016805   \n",
       "Product Base Margin   0.000137  0.018656    0.029086       0.361952   \n",
       "Postal Code           0.033578 -0.025247    0.016086      -0.033903   \n",
       "Profit               -0.038468 -0.061821   -0.182067       0.002177   \n",
       "Quantity ordered new -0.568939 -0.009398   -0.072472      -0.009735   \n",
       "Sales                -0.258827 -0.030287    0.443509       0.322133   \n",
       "Order ID              0.918497  0.016719    0.003292      -0.014691   \n",
       "\n",
       "                      Customer ID  Product Base Margin  Postal Code    Profit  \\\n",
       "Row ID                   0.064071             0.000137     0.033578 -0.038468   \n",
       "Discount                 0.014534             0.018656    -0.025247 -0.061821   \n",
       "Unit Price              -0.008717             0.029086     0.016086 -0.182067   \n",
       "Shipping Cost           -0.016805             0.361952    -0.033903  0.002177   \n",
       "Customer ID              1.000000            -0.033060    -0.096491  0.008852   \n",
       "Product Base Margin     -0.033060             1.000000     0.002925 -0.059523   \n",
       "Postal Code             -0.096491             0.002925     1.000000  0.033033   \n",
       "Profit                   0.008852            -0.059523     0.033033  1.000000   \n",
       "Quantity ordered new    -0.027582             0.002578    -0.015628  0.118363   \n",
       "Sales                   -0.015412             0.105838    -0.019699  0.364258   \n",
       "Order ID                 0.069118             0.009389     0.052141 -0.031008   \n",
       "\n",
       "                      Quantity ordered new     Sales  Order ID  \n",
       "Row ID                           -0.568939 -0.258827  0.918497  \n",
       "Discount                         -0.009398 -0.030287  0.016719  \n",
       "Unit Price                       -0.072472  0.443509  0.003292  \n",
       "Shipping Cost                    -0.009735  0.322133 -0.014691  \n",
       "Customer ID                      -0.027582 -0.015412  0.069118  \n",
       "Product Base Margin               0.002578  0.105838  0.009389  \n",
       "Postal Code                      -0.015628 -0.019699  0.052141  \n",
       "Profit                            0.118363  0.364258 -0.031008  \n",
       "Quantity ordered new              1.000000  0.303099 -0.589746  \n",
       "Sales                             0.303099  1.000000 -0.270939  \n",
       "Order ID                         -0.589746 -0.270939  1.000000  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result.corr()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "39170ed6",
   "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>Row ID</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Customer ID</th>\n",
       "      <th>Product Base Margin</th>\n",
       "      <th>Postal Code</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Order ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Row ID</th>\n",
       "      <td>3.549295e+07</td>\n",
       "      <td>3.405028</td>\n",
       "      <td>-10377.341902</td>\n",
       "      <td>-1662.840953</td>\n",
       "      <td>3.783064e+05</td>\n",
       "      <td>0.111795</td>\n",
       "      <td>5.873912e+06</td>\n",
       "      <td>-2.615198e+05</td>\n",
       "      <td>-47017.787398</td>\n",
       "      <td>-3.947334e+06</td>\n",
       "      <td>1.042001e+08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Discount</th>\n",
       "      <td>3.405028e+00</td>\n",
       "      <td>0.000985</td>\n",
       "      <td>-0.101272</td>\n",
       "      <td>0.021807</td>\n",
       "      <td>4.519698e-01</td>\n",
       "      <td>0.000080</td>\n",
       "      <td>-2.326136e+01</td>\n",
       "      <td>-2.213585e+00</td>\n",
       "      <td>-0.004091</td>\n",
       "      <td>-2.432777e+00</td>\n",
       "      <td>9.990091e+00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Unit Price</th>\n",
       "      <td>-1.037734e+04</td>\n",
       "      <td>-0.101272</td>\n",
       "      <td>154827.534308</td>\n",
       "      <td>1362.195244</td>\n",
       "      <td>-3.399539e+03</td>\n",
       "      <td>1.573953</td>\n",
       "      <td>1.858577e+05</td>\n",
       "      <td>-8.174937e+04</td>\n",
       "      <td>-395.566035</td>\n",
       "      <td>4.467346e+05</td>\n",
       "      <td>2.466958e+04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Shipping Cost</th>\n",
       "      <td>-1.662841e+03</td>\n",
       "      <td>0.021807</td>\n",
       "      <td>1362.195244</td>\n",
       "      <td>303.269387</td>\n",
       "      <td>-2.900391e+02</td>\n",
       "      <td>0.857693</td>\n",
       "      <td>-1.733590e+04</td>\n",
       "      <td>4.326944e+01</td>\n",
       "      <td>-2.351589</td>\n",
       "      <td>1.436060e+04</td>\n",
       "      <td>-4.871782e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Customer ID</th>\n",
       "      <td>3.783064e+05</td>\n",
       "      <td>0.451970</td>\n",
       "      <td>-3399.538743</td>\n",
       "      <td>-290.039124</td>\n",
       "      <td>9.822356e+05</td>\n",
       "      <td>-4.487987</td>\n",
       "      <td>-2.807962e+06</td>\n",
       "      <td>1.001145e+04</td>\n",
       "      <td>-379.188792</td>\n",
       "      <td>-3.910055e+04</td>\n",
       "      <td>1.304422e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Product Base Margin</th>\n",
       "      <td>1.117946e-01</td>\n",
       "      <td>0.000080</td>\n",
       "      <td>1.573953</td>\n",
       "      <td>0.857693</td>\n",
       "      <td>-4.487987e+00</td>\n",
       "      <td>0.018784</td>\n",
       "      <td>1.176597e+01</td>\n",
       "      <td>-9.270307e+00</td>\n",
       "      <td>0.004916</td>\n",
       "      <td>3.712493e+01</td>\n",
       "      <td>2.454632e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Postal Code</th>\n",
       "      <td>5.873912e+06</td>\n",
       "      <td>-23.261364</td>\n",
       "      <td>185857.674208</td>\n",
       "      <td>-17335.898146</td>\n",
       "      <td>-2.807962e+06</td>\n",
       "      <td>11.765973</td>\n",
       "      <td>8.621757e+08</td>\n",
       "      <td>1.106815e+06</td>\n",
       "      <td>-6365.411019</td>\n",
       "      <td>-1.480666e+06</td>\n",
       "      <td>2.915381e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Profit</th>\n",
       "      <td>-2.615198e+05</td>\n",
       "      <td>-2.213585</td>\n",
       "      <td>-81749.374525</td>\n",
       "      <td>43.269440</td>\n",
       "      <td>1.001145e+04</td>\n",
       "      <td>-9.270307</td>\n",
       "      <td>1.106815e+06</td>\n",
       "      <td>1.302137e+06</td>\n",
       "      <td>1873.567954</td>\n",
       "      <td>1.064046e+06</td>\n",
       "      <td>-6.737833e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <td>-4.701779e+04</td>\n",
       "      <td>-0.004091</td>\n",
       "      <td>-395.566035</td>\n",
       "      <td>-2.351589</td>\n",
       "      <td>-3.791888e+02</td>\n",
       "      <td>0.004916</td>\n",
       "      <td>-6.365411e+03</td>\n",
       "      <td>1.873568e+03</td>\n",
       "      <td>192.420310</td>\n",
       "      <td>1.076301e+04</td>\n",
       "      <td>-1.557794e+05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sales</th>\n",
       "      <td>-3.947334e+06</td>\n",
       "      <td>-2.432777</td>\n",
       "      <td>446734.613007</td>\n",
       "      <td>14360.599351</td>\n",
       "      <td>-3.910055e+04</td>\n",
       "      <td>37.124932</td>\n",
       "      <td>-1.480666e+06</td>\n",
       "      <td>1.064046e+06</td>\n",
       "      <td>10763.007045</td>\n",
       "      <td>6.553089e+06</td>\n",
       "      <td>-1.320727e+07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Order ID</th>\n",
       "      <td>1.042001e+08</td>\n",
       "      <td>9.990091</td>\n",
       "      <td>24669.582345</td>\n",
       "      <td>-4871.782078</td>\n",
       "      <td>1.304422e+06</td>\n",
       "      <td>24.546320</td>\n",
       "      <td>2.915381e+07</td>\n",
       "      <td>-6.737833e+05</td>\n",
       "      <td>-155779.365038</td>\n",
       "      <td>-1.320727e+07</td>\n",
       "      <td>3.626090e+08</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Row ID   Discount     Unit Price  Shipping Cost  \\\n",
       "Row ID                3.549295e+07   3.405028  -10377.341902   -1662.840953   \n",
       "Discount              3.405028e+00   0.000985      -0.101272       0.021807   \n",
       "Unit Price           -1.037734e+04  -0.101272  154827.534308    1362.195244   \n",
       "Shipping Cost        -1.662841e+03   0.021807    1362.195244     303.269387   \n",
       "Customer ID           3.783064e+05   0.451970   -3399.538743    -290.039124   \n",
       "Product Base Margin   1.117946e-01   0.000080       1.573953       0.857693   \n",
       "Postal Code           5.873912e+06 -23.261364  185857.674208  -17335.898146   \n",
       "Profit               -2.615198e+05  -2.213585  -81749.374525      43.269440   \n",
       "Quantity ordered new -4.701779e+04  -0.004091    -395.566035      -2.351589   \n",
       "Sales                -3.947334e+06  -2.432777  446734.613007   14360.599351   \n",
       "Order ID              1.042001e+08   9.990091   24669.582345   -4871.782078   \n",
       "\n",
       "                       Customer ID  Product Base Margin   Postal Code  \\\n",
       "Row ID                3.783064e+05             0.111795  5.873912e+06   \n",
       "Discount              4.519698e-01             0.000080 -2.326136e+01   \n",
       "Unit Price           -3.399539e+03             1.573953  1.858577e+05   \n",
       "Shipping Cost        -2.900391e+02             0.857693 -1.733590e+04   \n",
       "Customer ID           9.822356e+05            -4.487987 -2.807962e+06   \n",
       "Product Base Margin  -4.487987e+00             0.018784  1.176597e+01   \n",
       "Postal Code          -2.807962e+06            11.765973  8.621757e+08   \n",
       "Profit                1.001145e+04            -9.270307  1.106815e+06   \n",
       "Quantity ordered new -3.791888e+02             0.004916 -6.365411e+03   \n",
       "Sales                -3.910055e+04            37.124932 -1.480666e+06   \n",
       "Order ID              1.304422e+06            24.546320  2.915381e+07   \n",
       "\n",
       "                            Profit  Quantity ordered new         Sales  \\\n",
       "Row ID               -2.615198e+05         -47017.787398 -3.947334e+06   \n",
       "Discount             -2.213585e+00             -0.004091 -2.432777e+00   \n",
       "Unit Price           -8.174937e+04           -395.566035  4.467346e+05   \n",
       "Shipping Cost         4.326944e+01             -2.351589  1.436060e+04   \n",
       "Customer ID           1.001145e+04           -379.188792 -3.910055e+04   \n",
       "Product Base Margin  -9.270307e+00              0.004916  3.712493e+01   \n",
       "Postal Code           1.106815e+06          -6365.411019 -1.480666e+06   \n",
       "Profit                1.302137e+06           1873.567954  1.064046e+06   \n",
       "Quantity ordered new  1.873568e+03            192.420310  1.076301e+04   \n",
       "Sales                 1.064046e+06          10763.007045  6.553089e+06   \n",
       "Order ID             -6.737833e+05        -155779.365038 -1.320727e+07   \n",
       "\n",
       "                          Order ID  \n",
       "Row ID                1.042001e+08  \n",
       "Discount              9.990091e+00  \n",
       "Unit Price            2.466958e+04  \n",
       "Shipping Cost        -4.871782e+03  \n",
       "Customer ID           1.304422e+06  \n",
       "Product Base Margin   2.454632e+01  \n",
       "Postal Code           2.915381e+07  \n",
       "Profit               -6.737833e+05  \n",
       "Quantity ordered new -1.557794e+05  \n",
       "Sales                -1.320727e+07  \n",
       "Order ID              3.626090e+08  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "result.cov()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "id": "b78f198f",
   "metadata": {},
   "outputs": [],
   "source": [
    "fdf = result.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "2f7963ce",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Row ID', 'Order Priority', 'Discount', 'Unit Price', 'Shipping Cost',\n",
       "       'Customer ID', 'Customer Name', 'Ship Mode', 'Customer Segment',\n",
       "       'Product Category', 'Product Sub-Category', 'Product Container',\n",
       "       'Product Name', 'Product Base Margin', 'Country', 'Region',\n",
       "       'State or Province', 'City', 'Postal Code', 'Order Date', 'Ship Date',\n",
       "       'Profit', 'Quantity ordered new', 'Sales', 'Order ID', 'Manager'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdf.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "3298664c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1922"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(fdf['Sales'].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "cf126bb8",
   "metadata": {},
   "outputs": [],
   "source": [
    "fdf= fdf.drop([\"Row ID\", \"Customer ID\" , \"Postal Code\", \"Order ID\", \"Order ID\",\"Customer ID\", \\\n",
    "          'Product Name', \"Customer Name\", 'Postal Code', \"Country\"], axis =1\n",
    "        )"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "id": "3f196a08",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Order Priority', 'Discount', 'Unit Price', 'Shipping Cost',\n",
       "       'Ship Mode', 'Customer Segment', 'Product Category',\n",
       "       'Product Sub-Category', 'Product Container', 'Product Base Margin',\n",
       "       'Region', 'State or Province', 'City', 'Order Date', 'Ship Date',\n",
       "       'Profit', 'Quantity ordered new', 'Sales', 'Manager'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdf.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "id": "03ec45db",
   "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>Order Priority</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Ship Mode</th>\n",
       "      <th>Customer Segment</th>\n",
       "      <th>Product Category</th>\n",
       "      <th>Product Sub-Category</th>\n",
       "      <th>Product Container</th>\n",
       "      <th>Product Base Margin</th>\n",
       "      <th>Region</th>\n",
       "      <th>State or Province</th>\n",
       "      <th>City</th>\n",
       "      <th>Order Date</th>\n",
       "      <th>Ship Date</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Manager</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>2.84</td>\n",
       "      <td>0.93</td>\n",
       "      <td>Express Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Pens &amp; Art Supplies</td>\n",
       "      <td>Wrap Bag</td>\n",
       "      <td>0.54</td>\n",
       "      <td>West</td>\n",
       "      <td>Washington</td>\n",
       "      <td>Anacortes</td>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>2015-01-08</td>\n",
       "      <td>4.5600</td>\n",
       "      <td>4</td>\n",
       "      <td>13.01</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.02</td>\n",
       "      <td>500.98</td>\n",
       "      <td>26.00</td>\n",
       "      <td>Delivery Truck</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Chairs &amp; Chairmats</td>\n",
       "      <td>Jumbo Drum</td>\n",
       "      <td>0.60</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>San Gabriel</td>\n",
       "      <td>2015-06-13</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>4390.3665</td>\n",
       "      <td>12</td>\n",
       "      <td>6362.85</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Office Furnishings</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.49</td>\n",
       "      <td>West</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Helena</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2015-05-16</td>\n",
       "      <td>314.4813</td>\n",
       "      <td>17</td>\n",
       "      <td>455.77</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.07</td>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Office Machines</td>\n",
       "      <td>Medium Box</td>\n",
       "      <td>0.39</td>\n",
       "      <td>West</td>\n",
       "      <td>Montana</td>\n",
       "      <td>Missoula</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-23</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>18</td>\n",
       "      <td>231.79</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>High</td>\n",
       "      <td>0.06</td>\n",
       "      <td>55.48</td>\n",
       "      <td>14.30</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Paper</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.37</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>Laguna Niguel</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-29</td>\n",
       "      <td>-28.2968</td>\n",
       "      <td>1</td>\n",
       "      <td>67.49</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>High</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.68</td>\n",
       "      <td>1.57</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Pens &amp; Art Supplies</td>\n",
       "      <td>Wrap Bag</td>\n",
       "      <td>0.59</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>Laguna Niguel</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-30</td>\n",
       "      <td>-5.3072</td>\n",
       "      <td>1</td>\n",
       "      <td>2.25</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.04</td>\n",
       "      <td>4.14</td>\n",
       "      <td>6.60</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Office Furnishings</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.49</td>\n",
       "      <td>West</td>\n",
       "      <td>California</td>\n",
       "      <td>Lakewood</td>\n",
       "      <td>2015-05-02</td>\n",
       "      <td>2015-05-04</td>\n",
       "      <td>8.8940</td>\n",
       "      <td>12</td>\n",
       "      <td>54.78</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>High</td>\n",
       "      <td>0.08</td>\n",
       "      <td>34.99</td>\n",
       "      <td>7.73</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Pens &amp; Art Supplies</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.59</td>\n",
       "      <td>West</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Grants Pass</td>\n",
       "      <td>2015-02-22</td>\n",
       "      <td>2015-02-23</td>\n",
       "      <td>144.6900</td>\n",
       "      <td>13</td>\n",
       "      <td>424.68</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>17.98</td>\n",
       "      <td>8.51</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Office Machines</td>\n",
       "      <td>Medium Box</td>\n",
       "      <td>0.40</td>\n",
       "      <td>West</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Grants Pass</td>\n",
       "      <td>2015-03-27</td>\n",
       "      <td>2015-03-28</td>\n",
       "      <td>-35.8788</td>\n",
       "      <td>2</td>\n",
       "      <td>40.17</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Medium</td>\n",
       "      <td>0.09</td>\n",
       "      <td>125.99</td>\n",
       "      <td>7.69</td>\n",
       "      <td>Express Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Telephones and Communication</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.59</td>\n",
       "      <td>West</td>\n",
       "      <td>Oregon</td>\n",
       "      <td>Grants Pass</td>\n",
       "      <td>2015-01-20</td>\n",
       "      <td>2015-01-22</td>\n",
       "      <td>209.9970</td>\n",
       "      <td>8</td>\n",
       "      <td>783.55</td>\n",
       "      <td>William</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Order Priority  Discount  Unit Price  Shipping Cost       Ship Mode  \\\n",
       "0           High      0.01        2.84           0.93     Express Air   \n",
       "1  Not Specified      0.02      500.98          26.00  Delivery Truck   \n",
       "2           High      0.05       26.48           6.93     Regular Air   \n",
       "3  Not Specified      0.07       12.99           9.44     Regular Air   \n",
       "4           High      0.06       55.48          14.30     Regular Air   \n",
       "5           High      0.02        1.68           1.57     Regular Air   \n",
       "6  Not Specified      0.04        4.14           6.60     Regular Air   \n",
       "7           High      0.08       34.99           7.73     Regular Air   \n",
       "8           High      0.01       17.98           8.51     Regular Air   \n",
       "9         Medium      0.09      125.99           7.69     Express Air   \n",
       "\n",
       "  Customer Segment Product Category          Product Sub-Category  \\\n",
       "0        Corporate  Office Supplies           Pens & Art Supplies   \n",
       "1      Home Office        Furniture            Chairs & Chairmats   \n",
       "2   Small Business        Furniture            Office Furnishings   \n",
       "3   Small Business       Technology               Office Machines   \n",
       "4        Corporate  Office Supplies                         Paper   \n",
       "5        Corporate  Office Supplies           Pens & Art Supplies   \n",
       "6        Corporate        Furniture            Office Furnishings   \n",
       "7        Corporate  Office Supplies           Pens & Art Supplies   \n",
       "8        Corporate       Technology               Office Machines   \n",
       "9        Corporate       Technology  Telephones and Communication   \n",
       "\n",
       "  Product Container  Product Base Margin Region State or Province  \\\n",
       "0          Wrap Bag                 0.54   West        Washington   \n",
       "1        Jumbo Drum                 0.60   West        California   \n",
       "2         Small Box                 0.49   West           Montana   \n",
       "3        Medium Box                 0.39   West           Montana   \n",
       "4         Small Box                 0.37   West        California   \n",
       "5          Wrap Bag                 0.59   West        California   \n",
       "6         Small Box                 0.49   West        California   \n",
       "7         Small Box                 0.59   West            Oregon   \n",
       "8        Medium Box                 0.40   West            Oregon   \n",
       "9         Small Box                 0.59   West            Oregon   \n",
       "\n",
       "            City Order Date  Ship Date     Profit  Quantity ordered new  \\\n",
       "0      Anacortes 2015-01-07 2015-01-08     4.5600                     4   \n",
       "1    San Gabriel 2015-06-13 2015-06-15  4390.3665                    12   \n",
       "2         Helena 2015-05-15 2015-05-16   314.4813                    17   \n",
       "3       Missoula 2015-05-21 2015-05-23  -114.6399                    18   \n",
       "4  Laguna Niguel 2015-01-28 2015-01-29   -28.2968                     1   \n",
       "5  Laguna Niguel 2015-01-28 2015-01-30    -5.3072                     1   \n",
       "6       Lakewood 2015-05-02 2015-05-04     8.8940                    12   \n",
       "7    Grants Pass 2015-02-22 2015-02-23   144.6900                    13   \n",
       "8    Grants Pass 2015-03-27 2015-03-28   -35.8788                     2   \n",
       "9    Grants Pass 2015-01-20 2015-01-22   209.9970                     8   \n",
       "\n",
       "     Sales  Manager  \n",
       "0    13.01  William  \n",
       "1  6362.85  William  \n",
       "2   455.77  William  \n",
       "3   231.79  William  \n",
       "4    67.49  William  \n",
       "5     2.25  William  \n",
       "6    54.78  William  \n",
       "7   424.68  William  \n",
       "8    40.17  William  \n",
       "9   783.55  William  "
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdf.head(10)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "134f19f4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1952, 19)"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdf.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "39003ccb",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "869"
      ]
     },
     "execution_count": 50,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(fdf[\"City\"].unique())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "id": "e6691061",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1083"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "1952-869"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "id": "770480b1",
   "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>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Product Base Margin</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>2.84</td>\n",
       "      <td>0.93</td>\n",
       "      <td>0.01</td>\n",
       "      <td>4.5600</td>\n",
       "      <td>4</td>\n",
       "      <td>13.01</td>\n",
       "      <td>0.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>500.98</td>\n",
       "      <td>26.00</td>\n",
       "      <td>0.02</td>\n",
       "      <td>4390.3665</td>\n",
       "      <td>12</td>\n",
       "      <td>6362.85</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>0.05</td>\n",
       "      <td>314.4813</td>\n",
       "      <td>17</td>\n",
       "      <td>455.77</td>\n",
       "      <td>0.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>0.07</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>18</td>\n",
       "      <td>231.79</td>\n",
       "      <td>0.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>55.48</td>\n",
       "      <td>14.30</td>\n",
       "      <td>0.06</td>\n",
       "      <td>-28.2968</td>\n",
       "      <td>1</td>\n",
       "      <td>67.49</td>\n",
       "      <td>0.37</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>315.98</td>\n",
       "      <td>19.99</td>\n",
       "      <td>0.03</td>\n",
       "      <td>-4.4800</td>\n",
       "      <td>18</td>\n",
       "      <td>5572.18</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>276.20</td>\n",
       "      <td>24.49</td>\n",
       "      <td>0.09</td>\n",
       "      <td>3193.2840</td>\n",
       "      <td>11</td>\n",
       "      <td>2941.42</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>63.94</td>\n",
       "      <td>14.48</td>\n",
       "      <td>0.03</td>\n",
       "      <td>43.6917</td>\n",
       "      <td>8</td>\n",
       "      <td>522.46</td>\n",
       "      <td>0.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950</th>\n",
       "      <td>11.97</td>\n",
       "      <td>5.81</td>\n",
       "      <td>0.05</td>\n",
       "      <td>349.0593</td>\n",
       "      <td>2</td>\n",
       "      <td>25.31</td>\n",
       "      <td>0.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>28.53</td>\n",
       "      <td>1.49</td>\n",
       "      <td>0.02</td>\n",
       "      <td>1.9920</td>\n",
       "      <td>18</td>\n",
       "      <td>513.33</td>\n",
       "      <td>0.38</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1952 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Unit Price  Shipping Cost  Discount     Profit  Quantity ordered new  \\\n",
       "0           2.84           0.93      0.01     4.5600                     4   \n",
       "1         500.98          26.00      0.02  4390.3665                    12   \n",
       "2          26.48           6.93      0.05   314.4813                    17   \n",
       "3          12.99           9.44      0.07  -114.6399                    18   \n",
       "4          55.48          14.30      0.06   -28.2968                     1   \n",
       "...          ...            ...       ...        ...                   ...   \n",
       "1947      315.98          19.99      0.03    -4.4800                    18   \n",
       "1948      276.20          24.49      0.09  3193.2840                    11   \n",
       "1949       63.94          14.48      0.03    43.6917                     8   \n",
       "1950       11.97           5.81      0.05   349.0593                     2   \n",
       "1951       28.53           1.49      0.02     1.9920                    18   \n",
       "\n",
       "        Sales  Product Base Margin  \n",
       "0       13.01                 0.54  \n",
       "1     6362.85                 0.60  \n",
       "2      455.77                 0.49  \n",
       "3      231.79                 0.39  \n",
       "4       67.49                 0.37  \n",
       "...       ...                  ...  \n",
       "1947  5572.18                 0.38  \n",
       "1948  2941.42                  NaN  \n",
       "1949   522.46                 0.46  \n",
       "1950    25.31                 0.60  \n",
       "1951   513.33                 0.38  \n",
       "\n",
       "[1952 rows x 7 columns]"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdf[[\"Unit Price\", \"Shipping Cost\", \"Discount\",\"Profit\", \"Quantity ordered new\", \"Sales\", \"Product Base Margin\" ]]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "ac397f67",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "5.335675981873112"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(455.77 - 314.4813)/26.48"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "c241143f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.6784"
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "13.01- ((2.84*4)-(2.84*0.01))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "d853fb01",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "770.2512999999999"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# cp+pm*x = x\n",
    "# 26.48+ 0.49*x = x\n",
    "# 26.48 = 0.51x\n",
    "455.77 + 314.4813"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "ba781a09",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "51.92156862745098"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "26.48/.51"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "id": "abbfd4f9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "880.06095"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "(51.921*17)- (51.921*0.05)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "c0f1c907",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Product margin= (selling price – cost of product) / selling price\n",
    "# pm = (x-cp)/x\n",
    "# pm*x =x-cp\n",
    "# cp+pm*x = x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "39042e49",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "3"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "x = 1\n",
    "x += 2\n",
    "x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "b7020624",
   "metadata": {},
   "outputs": [],
   "source": [
    "city = fdf[\"City\"]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "id": "b3f4a216",
   "metadata": {},
   "outputs": [],
   "source": [
    "nd= {}\n",
    "\n",
    "for i in city:\n",
    "    if i in nd:\n",
    "        nd[i] += 1\n",
    "    else:\n",
    "        nd[i] = 1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "612e5f44",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "id": "28f8417a",
   "metadata": {},
   "outputs": [],
   "source": [
    "x = []\n",
    "for i in nd:\n",
    "    if nd.get(i) > 5:\n",
    "        x.append([i, nd.get(i)])\n",
    "        \n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "id": "cd1a0c1e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['New York City', 47],\n",
       " ['Los Angeles', 44],\n",
       " ['Seattle', 21],\n",
       " ['Boston', 19],\n",
       " ['Washington', 15],\n",
       " ['Philadelphia', 12],\n",
       " ['Charlotte', 12],\n",
       " ['Chicago', 11],\n",
       " ['Sanford', 10],\n",
       " ['Miami', 10],\n",
       " ['Atlanta', 9],\n",
       " ['San Diego', 8],\n",
       " ['Columbus', 8],\n",
       " ['Prior Lake', 8],\n",
       " ['Hilton Head Island', 8],\n",
       " ['Twentynine Palms', 7],\n",
       " ['Auburn', 7],\n",
       " ['Newton', 7],\n",
       " ['Norfolk', 7],\n",
       " ['Greenville', 7],\n",
       " ['Redmond', 6],\n",
       " ['Aurora', 6],\n",
       " ['Burlington', 6],\n",
       " ['Troy', 6],\n",
       " ['Detroit', 6],\n",
       " ['Naperville', 6]]"
      ]
     },
     "execution_count": 40,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "def takeSecond(elem):\n",
    "    return elem[1]\n",
    "x.sort(reverse = True, key = takeSecond )\n",
    "x"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "bde212bb",
   "metadata": {},
   "source": [
    "## TOP 4 CITIES THAT PURCHASES \n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "a4de8616",
   "metadata": {},
   "outputs": [],
   "source": [
    "top4 = x[0:4]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "19448a64",
   "metadata": {},
   "source": [
    "# PURCAHSES WITH RESPECT TO REGION"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "a596cacb",
   "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>Order Priority</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Ship Mode</th>\n",
       "      <th>Product Category</th>\n",
       "      <th>Product Sub-Category</th>\n",
       "      <th>Product Container</th>\n",
       "      <th>Product Base Margin</th>\n",
       "      <th>State or Province</th>\n",
       "      <th>...</th>\n",
       "      <th>Order Date</th>\n",
       "      <th>Ship Date</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Manager</th>\n",
       "      <th>Region_Central</th>\n",
       "      <th>Region_East</th>\n",
       "      <th>Region_South</th>\n",
       "      <th>Region_West</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>2.84</td>\n",
       "      <td>0.93</td>\n",
       "      <td>Express Air</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Pens &amp; Art Supplies</td>\n",
       "      <td>Wrap Bag</td>\n",
       "      <td>0.54</td>\n",
       "      <td>Washington</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>2015-01-08</td>\n",
       "      <td>4.5600</td>\n",
       "      <td>4</td>\n",
       "      <td>13.01</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.02</td>\n",
       "      <td>500.98</td>\n",
       "      <td>26.00</td>\n",
       "      <td>Delivery Truck</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Chairs &amp; Chairmats</td>\n",
       "      <td>Jumbo Drum</td>\n",
       "      <td>0.60</td>\n",
       "      <td>California</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-06-13</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>4390.3665</td>\n",
       "      <td>12</td>\n",
       "      <td>6362.85</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Office Furnishings</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.49</td>\n",
       "      <td>Montana</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2015-05-16</td>\n",
       "      <td>314.4813</td>\n",
       "      <td>17</td>\n",
       "      <td>455.77</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.07</td>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Office Machines</td>\n",
       "      <td>Medium Box</td>\n",
       "      <td>0.39</td>\n",
       "      <td>Montana</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-23</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>18</td>\n",
       "      <td>231.79</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>High</td>\n",
       "      <td>0.06</td>\n",
       "      <td>55.48</td>\n",
       "      <td>14.30</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Paper</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.37</td>\n",
       "      <td>California</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-29</td>\n",
       "      <td>-28.2968</td>\n",
       "      <td>1</td>\n",
       "      <td>67.49</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>315.98</td>\n",
       "      <td>19.99</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Binders and Binder Accessories</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.38</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-22</td>\n",
       "      <td>-4.4800</td>\n",
       "      <td>18</td>\n",
       "      <td>5572.18</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>Critical</td>\n",
       "      <td>0.09</td>\n",
       "      <td>276.20</td>\n",
       "      <td>24.49</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Chairs &amp; Chairmats</td>\n",
       "      <td>Large Box</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>3193.2840</td>\n",
       "      <td>11</td>\n",
       "      <td>2941.42</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>63.94</td>\n",
       "      <td>14.48</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Office Furnishings</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.46</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>43.6917</td>\n",
       "      <td>8</td>\n",
       "      <td>522.46</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.05</td>\n",
       "      <td>11.97</td>\n",
       "      <td>5.81</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Pens &amp; Art Supplies</td>\n",
       "      <td>Small Pack</td>\n",
       "      <td>0.60</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-03-23</td>\n",
       "      <td>2015-03-25</td>\n",
       "      <td>349.0593</td>\n",
       "      <td>2</td>\n",
       "      <td>25.31</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>Medium</td>\n",
       "      <td>0.02</td>\n",
       "      <td>28.53</td>\n",
       "      <td>1.49</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Binders and Binder Accessories</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.38</td>\n",
       "      <td>Georgia</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>1.9920</td>\n",
       "      <td>18</td>\n",
       "      <td>513.33</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1952 rows × 21 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Order Priority  Discount  Unit Price  Shipping Cost       Ship Mode  \\\n",
       "0              High      0.01        2.84           0.93     Express Air   \n",
       "1     Not Specified      0.02      500.98          26.00  Delivery Truck   \n",
       "2              High      0.05       26.48           6.93     Regular Air   \n",
       "3     Not Specified      0.07       12.99           9.44     Regular Air   \n",
       "4              High      0.06       55.48          14.30     Regular Air   \n",
       "...             ...       ...         ...            ...             ...   \n",
       "1947       Critical      0.03      315.98          19.99     Regular Air   \n",
       "1948       Critical      0.09      276.20          24.49     Regular Air   \n",
       "1949       Critical      0.03       63.94          14.48     Regular Air   \n",
       "1950  Not Specified      0.05       11.97           5.81     Regular Air   \n",
       "1951         Medium      0.02       28.53           1.49     Regular Air   \n",
       "\n",
       "     Product Category            Product Sub-Category Product Container  \\\n",
       "0     Office Supplies             Pens & Art Supplies          Wrap Bag   \n",
       "1           Furniture              Chairs & Chairmats        Jumbo Drum   \n",
       "2           Furniture              Office Furnishings         Small Box   \n",
       "3          Technology                 Office Machines        Medium Box   \n",
       "4     Office Supplies                           Paper         Small Box   \n",
       "...               ...                             ...               ...   \n",
       "1947  Office Supplies  Binders and Binder Accessories         Small Box   \n",
       "1948        Furniture              Chairs & Chairmats         Large Box   \n",
       "1949        Furniture              Office Furnishings         Small Box   \n",
       "1950  Office Supplies             Pens & Art Supplies        Small Pack   \n",
       "1951  Office Supplies  Binders and Binder Accessories         Small Box   \n",
       "\n",
       "      Product Base Margin State or Province  ... Order Date  Ship Date  \\\n",
       "0                    0.54        Washington  ... 2015-01-07 2015-01-08   \n",
       "1                    0.60        California  ... 2015-06-13 2015-06-15   \n",
       "2                    0.49           Montana  ... 2015-05-15 2015-05-16   \n",
       "3                    0.39           Montana  ... 2015-05-21 2015-05-23   \n",
       "4                    0.37        California  ... 2015-01-28 2015-01-29   \n",
       "...                   ...               ...  ...        ...        ...   \n",
       "1947                 0.38           Georgia  ... 2015-04-20 2015-04-22   \n",
       "1948                  NaN           Georgia  ... 2015-04-20 2015-04-21   \n",
       "1949                 0.46           Georgia  ... 2015-04-20 2015-04-21   \n",
       "1950                 0.60           Georgia  ... 2015-03-23 2015-03-25   \n",
       "1951                 0.38           Georgia  ... 2015-04-29 2015-04-29   \n",
       "\n",
       "         Profit  Quantity ordered new    Sales  Manager Region_Central  \\\n",
       "0        4.5600                     4    13.01  William              0   \n",
       "1     4390.3665                    12  6362.85  William              0   \n",
       "2      314.4813                    17   455.77  William              0   \n",
       "3     -114.6399                    18   231.79  William              0   \n",
       "4      -28.2968                     1    67.49  William              0   \n",
       "...         ...                   ...      ...      ...            ...   \n",
       "1947    -4.4800                    18  5572.18      Sam              0   \n",
       "1948  3193.2840                    11  2941.42      Sam              0   \n",
       "1949    43.6917                     8   522.46      Sam              0   \n",
       "1950   349.0593                     2    25.31      Sam              0   \n",
       "1951     1.9920                    18   513.33      Sam              0   \n",
       "\n",
       "      Region_East  Region_South  Region_West  \n",
       "0               0             0            1  \n",
       "1               0             0            1  \n",
       "2               0             0            1  \n",
       "3               0             0            1  \n",
       "4               0             0            1  \n",
       "...           ...           ...          ...  \n",
       "1947            0             1            0  \n",
       "1948            0             1            0  \n",
       "1949            0             1            0  \n",
       "1950            0             1            0  \n",
       "1951            0             1            0  \n",
       "\n",
       "[1952 rows x 21 columns]"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.get_dummies(data = fdf, columns = [\"Region\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 55,
   "id": "5cb43b60",
   "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>Order Priority</th>\n",
       "      <th>Discount</th>\n",
       "      <th>Unit Price</th>\n",
       "      <th>Shipping Cost</th>\n",
       "      <th>Ship Mode</th>\n",
       "      <th>Customer Segment</th>\n",
       "      <th>Product Category</th>\n",
       "      <th>Product Sub-Category</th>\n",
       "      <th>Product Container</th>\n",
       "      <th>Product Base Margin</th>\n",
       "      <th>...</th>\n",
       "      <th>Order Date</th>\n",
       "      <th>Ship Date</th>\n",
       "      <th>Profit</th>\n",
       "      <th>Quantity ordered new</th>\n",
       "      <th>Sales</th>\n",
       "      <th>Manager</th>\n",
       "      <th>Region_Central</th>\n",
       "      <th>Region_East</th>\n",
       "      <th>Region_South</th>\n",
       "      <th>Region_West</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>High</td>\n",
       "      <td>0.01</td>\n",
       "      <td>2.84</td>\n",
       "      <td>0.93</td>\n",
       "      <td>Express Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Pens &amp; Art Supplies</td>\n",
       "      <td>Wrap Bag</td>\n",
       "      <td>0.54</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-01-07</td>\n",
       "      <td>2015-01-08</td>\n",
       "      <td>4.5600</td>\n",
       "      <td>4</td>\n",
       "      <td>13.01</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.02</td>\n",
       "      <td>500.98</td>\n",
       "      <td>26.00</td>\n",
       "      <td>Delivery Truck</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Chairs &amp; Chairmats</td>\n",
       "      <td>Jumbo Drum</td>\n",
       "      <td>0.60</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-06-13</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>4390.3665</td>\n",
       "      <td>12</td>\n",
       "      <td>6362.85</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>High</td>\n",
       "      <td>0.05</td>\n",
       "      <td>26.48</td>\n",
       "      <td>6.93</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Office Furnishings</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.49</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-05-15</td>\n",
       "      <td>2015-05-16</td>\n",
       "      <td>314.4813</td>\n",
       "      <td>17</td>\n",
       "      <td>455.77</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.07</td>\n",
       "      <td>12.99</td>\n",
       "      <td>9.44</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Small Business</td>\n",
       "      <td>Technology</td>\n",
       "      <td>Office Machines</td>\n",
       "      <td>Medium Box</td>\n",
       "      <td>0.39</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-05-21</td>\n",
       "      <td>2015-05-23</td>\n",
       "      <td>-114.6399</td>\n",
       "      <td>18</td>\n",
       "      <td>231.79</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>High</td>\n",
       "      <td>0.06</td>\n",
       "      <td>55.48</td>\n",
       "      <td>14.30</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Paper</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.37</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-01-28</td>\n",
       "      <td>2015-01-29</td>\n",
       "      <td>-28.2968</td>\n",
       "      <td>1</td>\n",
       "      <td>67.49</td>\n",
       "      <td>William</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</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",
       "      <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",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1947</th>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>315.98</td>\n",
       "      <td>19.99</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Binders and Binder Accessories</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.38</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-22</td>\n",
       "      <td>-4.4800</td>\n",
       "      <td>18</td>\n",
       "      <td>5572.18</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1948</th>\n",
       "      <td>Critical</td>\n",
       "      <td>0.09</td>\n",
       "      <td>276.20</td>\n",
       "      <td>24.49</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Chairs &amp; Chairmats</td>\n",
       "      <td>Large Box</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>3193.2840</td>\n",
       "      <td>11</td>\n",
       "      <td>2941.42</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1949</th>\n",
       "      <td>Critical</td>\n",
       "      <td>0.03</td>\n",
       "      <td>63.94</td>\n",
       "      <td>14.48</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Furniture</td>\n",
       "      <td>Office Furnishings</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.46</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-20</td>\n",
       "      <td>2015-04-21</td>\n",
       "      <td>43.6917</td>\n",
       "      <td>8</td>\n",
       "      <td>522.46</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1950</th>\n",
       "      <td>Not Specified</td>\n",
       "      <td>0.05</td>\n",
       "      <td>11.97</td>\n",
       "      <td>5.81</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Corporate</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Pens &amp; Art Supplies</td>\n",
       "      <td>Small Pack</td>\n",
       "      <td>0.60</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-03-23</td>\n",
       "      <td>2015-03-25</td>\n",
       "      <td>349.0593</td>\n",
       "      <td>2</td>\n",
       "      <td>25.31</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1951</th>\n",
       "      <td>Medium</td>\n",
       "      <td>0.02</td>\n",
       "      <td>28.53</td>\n",
       "      <td>1.49</td>\n",
       "      <td>Regular Air</td>\n",
       "      <td>Home Office</td>\n",
       "      <td>Office Supplies</td>\n",
       "      <td>Binders and Binder Accessories</td>\n",
       "      <td>Small Box</td>\n",
       "      <td>0.38</td>\n",
       "      <td>...</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>2015-04-29</td>\n",
       "      <td>1.9920</td>\n",
       "      <td>18</td>\n",
       "      <td>513.33</td>\n",
       "      <td>Sam</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1952 rows × 22 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Order Priority  Discount  Unit Price  Shipping Cost       Ship Mode  \\\n",
       "0              High      0.01        2.84           0.93     Express Air   \n",
       "1     Not Specified      0.02      500.98          26.00  Delivery Truck   \n",
       "2              High      0.05       26.48           6.93     Regular Air   \n",
       "3     Not Specified      0.07       12.99           9.44     Regular Air   \n",
       "4              High      0.06       55.48          14.30     Regular Air   \n",
       "...             ...       ...         ...            ...             ...   \n",
       "1947       Critical      0.03      315.98          19.99     Regular Air   \n",
       "1948       Critical      0.09      276.20          24.49     Regular Air   \n",
       "1949       Critical      0.03       63.94          14.48     Regular Air   \n",
       "1950  Not Specified      0.05       11.97           5.81     Regular Air   \n",
       "1951         Medium      0.02       28.53           1.49     Regular Air   \n",
       "\n",
       "     Customer Segment Product Category            Product Sub-Category  \\\n",
       "0           Corporate  Office Supplies             Pens & Art Supplies   \n",
       "1         Home Office        Furniture              Chairs & Chairmats   \n",
       "2      Small Business        Furniture              Office Furnishings   \n",
       "3      Small Business       Technology                 Office Machines   \n",
       "4           Corporate  Office Supplies                           Paper   \n",
       "...               ...              ...                             ...   \n",
       "1947      Home Office  Office Supplies  Binders and Binder Accessories   \n",
       "1948      Home Office        Furniture              Chairs & Chairmats   \n",
       "1949      Home Office        Furniture              Office Furnishings   \n",
       "1950        Corporate  Office Supplies             Pens & Art Supplies   \n",
       "1951      Home Office  Office Supplies  Binders and Binder Accessories   \n",
       "\n",
       "     Product Container  Product Base Margin  ... Order Date  Ship Date  \\\n",
       "0             Wrap Bag                 0.54  ... 2015-01-07 2015-01-08   \n",
       "1           Jumbo Drum                 0.60  ... 2015-06-13 2015-06-15   \n",
       "2            Small Box                 0.49  ... 2015-05-15 2015-05-16   \n",
       "3           Medium Box                 0.39  ... 2015-05-21 2015-05-23   \n",
       "4            Small Box                 0.37  ... 2015-01-28 2015-01-29   \n",
       "...                ...                  ...  ...        ...        ...   \n",
       "1947         Small Box                 0.38  ... 2015-04-20 2015-04-22   \n",
       "1948         Large Box                  NaN  ... 2015-04-20 2015-04-21   \n",
       "1949         Small Box                 0.46  ... 2015-04-20 2015-04-21   \n",
       "1950        Small Pack                 0.60  ... 2015-03-23 2015-03-25   \n",
       "1951         Small Box                 0.38  ... 2015-04-29 2015-04-29   \n",
       "\n",
       "         Profit Quantity ordered new    Sales  Manager  Region_Central  \\\n",
       "0        4.5600                    4    13.01  William               0   \n",
       "1     4390.3665                   12  6362.85  William               0   \n",
       "2      314.4813                   17   455.77  William               0   \n",
       "3     -114.6399                   18   231.79  William               0   \n",
       "4      -28.2968                    1    67.49  William               0   \n",
       "...         ...                  ...      ...      ...             ...   \n",
       "1947    -4.4800                   18  5572.18      Sam               0   \n",
       "1948  3193.2840                   11  2941.42      Sam               0   \n",
       "1949    43.6917                    8   522.46      Sam               0   \n",
       "1950   349.0593                    2    25.31      Sam               0   \n",
       "1951     1.9920                   18   513.33      Sam               0   \n",
       "\n",
       "     Region_East  Region_South  Region_West  \n",
       "0              0             0            1  \n",
       "1              0             0            1  \n",
       "2              0             0            1  \n",
       "3              0             0            1  \n",
       "4              0             0            1  \n",
       "...          ...           ...          ...  \n",
       "1947           0             1            0  \n",
       "1948           0             1            0  \n",
       "1949           0             1            0  \n",
       "1950           0             1            0  \n",
       "1951           0             1            0  \n",
       "\n",
       "[1952 rows x 22 columns]"
      ]
     },
     "execution_count": 55,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "d74a5af3",
   "metadata": {},
   "source": [
    "# with respect to product category "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 57,
   "id": "e943a298",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Office Supplies', 'Furniture', 'Technology'], dtype=object)"
      ]
     },
     "execution_count": 57,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "fdf[\"Product Category\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "276b5bc3",
   "metadata": {},
   "outputs": [],
   "source": [
    "#pd.get_dummies()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b699660c",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "ee537648",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "e5ea65b4",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "26d93552",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "40484536",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}