<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Row ID</th>
      <th>Order ID</th>
      <th>Order Date</th>
      <th>Ship Date</th>
      <th>Ship Mode</th>
      <th>Customer ID</th>
      <th>Customer Name</th>
      <th>Segment</th>
      <th>Country/Region</th>
      <th>City</th>
      <th>...</th>
      <th>Postal Code</th>
      <th>Region</th>
      <th>Product ID</th>
      <th>Category</th>
      <th>Sub-Category</th>
      <th>Product Name</th>
      <th>Sales</th>
      <th>Quantity</th>
      <th>Discount</th>
      <th>Profit</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>1</td>
      <td>US-2020-103800</td>
      <td>1/3/2020</td>
      <td>1/7/2020</td>
      <td>Standard Class</td>
      <td>DP-13000</td>
      <td>Darren Powers</td>
      <td>Consumer</td>
      <td>United States</td>
      <td>Houston</td>
      <td>...</td>
      <td>77095</td>
      <td>Central</td>
      <td>OFF-PA-10000174</td>
      <td>Office Supplies</td>
      <td>Paper</td>
      <td>Message Book, Wirebound, Four 5 1/2" X 4" Form...</td>
      <td>16.448</td>
      <td>2</td>
      <td>0.2</td>
      <td>5.5512</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2</td>
      <td>US-2020-112326</td>
      <td>1/4/2020</td>
      <td>1/8/2020</td>
      <td>Standard Class</td>
      <td>PO-19195</td>
      <td>Phillina Ober</td>
      <td>Home Office</td>
      <td>United States</td>
      <td>Naperville</td>
      <td>...</td>
      <td>60540</td>
      <td>Central</td>
      <td>OFF-BI-10004094</td>
      <td>Office Supplies</td>
      <td>Binders</td>
      <td>GBC Standard Plastic Binding Systems Combs</td>
      <td>3.540</td>
      <td>2</td>
      <td>0.8</td>
      <td>-5.4870</td>
    </tr>
    <tr>
      <th>2</th>
      <td>3</td>
      <td>US-2020-112326</td>
      <td>1/4/2020</td>
      <td>1/8/2020</td>
      <td>Standard Class</td>
      <td>PO-19195</td>
      <td>Phillina Ober</td>
      <td>Home Office</td>
      <td>United States</td>
      <td>Naperville</td>
      <td>...</td>
      <td>60540</td>
      <td>Central</td>
      <td>OFF-LA-10003223</td>
      <td>Office Supplies</td>
      <td>Labels</td>
      <td>Avery 508</td>
      <td>11.784</td>
      <td>3</td>
      <td>0.2</td>
      <td>4.2717</td>
    </tr>
    <tr>
      <th>3</th>
      <td>4</td>
      <td>US-2020-112326</td>
      <td>1/4/2020</td>
      <td>1/8/2020</td>
      <td>Standard Class</td>
      <td>PO-19195</td>
      <td>Phillina Ober</td>
      <td>Home Office</td>
      <td>United States</td>
      <td>Naperville</td>
      <td>...</td>
      <td>60540</td>
      <td>Central</td>
      <td>OFF-ST-10002743</td>
      <td>Office Supplies</td>
      <td>Storage</td>
      <td>SAFCO Boltless Steel Shelving</td>
      <td>272.736</td>
      <td>3</td>
      <td>0.2</td>
      <td>-64.7748</td>
    </tr>
    <tr>
      <th>4</th>
      <td>5</td>
      <td>US-2020-141817</td>
      <td>1/5/2020</td>
      <td>1/12/2020</td>
      <td>Standard Class</td>
      <td>MB-18085</td>
      <td>Mick Brown</td>
      <td>Consumer</td>
      <td>United States</td>
      <td>Philadelphia</td>
      <td>...</td>
      <td>19143</td>
      <td>East</td>
      <td>OFF-AR-10003478</td>
      <td>Office Supplies</td>
      <td>Art</td>
      <td>Avery Hi-Liter EverBold Pen Style Fluorescent ...</td>
      <td>19.536</td>
      <td>3</td>
      <td>0.2</td>
      <td>4.8840</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 21 columns</p>
</div>

   Row ID        Order ID Order Date  Ship Date       Ship Mode Customer ID  \
0       1  US-2020-103800   1/3/2020   1/7/2020  Standard Class    DP-13000   
1       2  US-2020-112326   1/4/2020   1/8/2020  Standard Class    PO-19195   
2       3  US-2020-112326   1/4/2020   1/8/2020  Standard Class    PO-19195   
3       4  US-2020-112326   1/4/2020   1/8/2020  Standard Class    PO-19195   
4       5  US-2020-141817   1/5/2020  1/12/2020  Standard Class    MB-18085   

   Customer Name      Segment Country/Region          City  ... Postal Code  \
0  Darren Powers     Consumer  United States       Houston  ...       77095   
1  Phillina Ober  Home Office  United States    Naperville  ...       60540   
2  Phillina Ober  Home Office  United States    Naperville  ...       60540   
3  Phillina Ober  Home Office  United States    Naperville  ...       60540   
4     Mick Brown     Consumer  United States  Philadelphia  ...       19143   

    Region       Product ID         Category Sub-Category  \
0  Central  OFF-PA-10000174  Office Supplies        Paper   
1  Central  OFF-BI-10004094  Office Supplies      Binders   
2  Central  OFF-LA-10003223  Office Supplies       Labels   
3  Central  OFF-ST-10002743  Office Supplies      Storage   
4     East  OFF-AR-10003478  Office Supplies          Art   

                                        Product Name    Sales  Quantity  \
0  Message Book, Wirebound, Four 5 1/2" X 4" Form...   16.448         2   
1         GBC Standard Plastic Binding Systems Combs    3.540         2   
2                                          Avery 508   11.784         3   
3                      SAFCO Boltless Steel Shelving  272.736         3   
4  Avery Hi-Liter EverBold Pen Style Fluorescent ...   19.536         3   

   Discount   Profit  
0       0.2   5.5512  
1       0.8  -5.4870  
2       0.2   4.2717  
3       0.2 -64.7748  
4       0.2   4.8840  

[5 rows x 21 columns]

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Category</th>
      <th>Sales</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Furniture</td>
      <td>754747.7613</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Office Supplies</td>
      <td>731893.3140</td>
    </tr>
    <tr>
      <th>2</th>
      <td>Technology</td>
      <td>839893.2790</td>
    </tr>
  </tbody>
</table>
</div>

          Category        Sales
0        Furniture  754747.7613
1  Office Supplies  731893.3140
2       Technology  839893.2790

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Row ID</th>
      <th>Order ID</th>
      <th>Order Date</th>
      <th>Ship Date</th>
      <th>Ship Mode</th>
      <th>Customer ID</th>
      <th>Customer Name</th>
      <th>Segment</th>
      <th>Country/Region</th>
      <th>City</th>
      <th>...</th>
      <th>Region</th>
      <th>Product ID</th>
      <th>Category</th>
      <th>Sub-Category</th>
      <th>Product Name</th>
      <th>Sales</th>
      <th>Quantity</th>
      <th>Discount</th>
      <th>Profit</th>
      <th>YearMonth</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>1</td>
      <td>US-2020-103800</td>
      <td>2020-01-03</td>
      <td>1/7/2020</td>
      <td>Standard Class</td>
      <td>DP-13000</td>
      <td>Darren Powers</td>
      <td>Consumer</td>
      <td>United States</td>
      <td>Houston</td>
      <td>...</td>
      <td>Central</td>
      <td>OFF-PA-10000174</td>
      <td>Office Supplies</td>
      <td>Paper</td>
      <td>Message Book, Wirebound, Four 5 1/2" X 4" Form...</td>
      <td>16.448</td>
      <td>2</td>
      <td>0.2</td>
      <td>5.5512</td>
      <td>2020-01</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2</td>
      <td>US-2020-112326</td>
      <td>2020-01-04</td>
      <td>1/8/2020</td>
      <td>Standard Class</td>
      <td>PO-19195</td>
      <td>Phillina Ober</td>
      <td>Home Office</td>
      <td>United States</td>
      <td>Naperville</td>
      <td>...</td>
      <td>Central</td>
      <td>OFF-BI-10004094</td>
      <td>Office Supplies</td>
      <td>Binders</td>
      <td>GBC Standard Plastic Binding Systems Combs</td>
      <td>3.540</td>
      <td>2</td>
      <td>0.8</td>
      <td>-5.4870</td>
      <td>2020-01</td>
    </tr>
    <tr>
      <th>2</th>
      <td>3</td>
      <td>US-2020-112326</td>
      <td>2020-01-04</td>
      <td>1/8/2020</td>
      <td>Standard Class</td>
      <td>PO-19195</td>
      <td>Phillina Ober</td>
      <td>Home Office</td>
      <td>United States</td>
      <td>Naperville</td>
      <td>...</td>
      <td>Central</td>
      <td>OFF-LA-10003223</td>
      <td>Office Supplies</td>
      <td>Labels</td>
      <td>Avery 508</td>
      <td>11.784</td>
      <td>3</td>
      <td>0.2</td>
      <td>4.2717</td>
      <td>2020-01</td>
    </tr>
    <tr>
      <th>3</th>
      <td>4</td>
      <td>US-2020-112326</td>
      <td>2020-01-04</td>
      <td>1/8/2020</td>
      <td>Standard Class</td>
      <td>PO-19195</td>
      <td>Phillina Ober</td>
      <td>Home Office</td>
      <td>United States</td>
      <td>Naperville</td>
      <td>...</td>
      <td>Central</td>
      <td>OFF-ST-10002743</td>
      <td>Office Supplies</td>
      <td>Storage</td>
      <td>SAFCO Boltless Steel Shelving</td>
      <td>272.736</td>
      <td>3</td>
      <td>0.2</td>
      <td>-64.7748</td>
      <td>2020-01</td>
    </tr>
    <tr>
      <th>4</th>
      <td>5</td>
      <td>US-2020-141817</td>
      <td>2020-01-05</td>
      <td>1/12/2020</td>
      <td>Standard Class</td>
      <td>MB-18085</td>
      <td>Mick Brown</td>
      <td>Consumer</td>
      <td>United States</td>
      <td>Philadelphia</td>
      <td>...</td>
      <td>East</td>
      <td>OFF-AR-10003478</td>
      <td>Office Supplies</td>
      <td>Art</td>
      <td>Avery Hi-Liter EverBold Pen Style Fluorescent ...</td>
      <td>19.536</td>
      <td>3</td>
      <td>0.2</td>
      <td>4.8840</td>
      <td>2020-01</td>
    </tr>
  </tbody>
</table>
<p>5 rows × 22 columns</p>
</div>

   Row ID        Order ID Order Date  Ship Date       Ship Mode Customer ID  \
0       1  US-2020-103800 2020-01-03   1/7/2020  Standard Class    DP-13000   
1       2  US-2020-112326 2020-01-04   1/8/2020  Standard Class    PO-19195   
2       3  US-2020-112326 2020-01-04   1/8/2020  Standard Class    PO-19195   
3       4  US-2020-112326 2020-01-04   1/8/2020  Standard Class    PO-19195   
4       5  US-2020-141817 2020-01-05  1/12/2020  Standard Class    MB-18085   

   Customer Name      Segment Country/Region          City  ...   Region  \
0  Darren Powers     Consumer  United States       Houston  ...  Central   
1  Phillina Ober  Home Office  United States    Naperville  ...  Central   
2  Phillina Ober  Home Office  United States    Naperville  ...  Central   
3  Phillina Ober  Home Office  United States    Naperville  ...  Central   
4     Mick Brown     Consumer  United States  Philadelphia  ...     East   

        Product ID         Category Sub-Category  \
0  OFF-PA-10000174  Office Supplies        Paper   
1  OFF-BI-10004094  Office Supplies      Binders   
2  OFF-LA-10003223  Office Supplies       Labels   
3  OFF-ST-10002743  Office Supplies      Storage   
4  OFF-AR-10003478  Office Supplies          Art   

                                        Product Name    Sales Quantity  \
0  Message Book, Wirebound, Four 5 1/2" X 4" Form...   16.448        2   
1         GBC Standard Plastic Binding Systems Combs    3.540        2   
2                                          Avery 508   11.784        3   
3                      SAFCO Boltless Steel Shelving  272.736        3   
4  Avery Hi-Liter EverBold Pen Style Fluorescent ...   19.536        3   

   Discount   Profit  YearMonth  
0       0.2   5.5512    2020-01  
1       0.8  -5.4870    2020-01  
2       0.2   4.2717    2020-01  
3       0.2 -64.7748    2020-01  
4       0.2   4.8840    2020-01  

[5 rows x 22 columns]

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>YearMonth</th>
      <th>Category</th>
      <th>Sales</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>2020-01</td>
      <td>Furniture</td>
      <td>6307.705</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2020-01</td>
      <td>Office Supplies</td>
      <td>4857.560</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2020-01</td>
      <td>Technology</td>
      <td>3352.790</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2020-02</td>
      <td>Furniture</td>
      <td>1839.658</td>
    </tr>
    <tr>
      <th>4</th>
      <td>2020-02</td>
      <td>Office Supplies</td>
      <td>1071.724</td>
    </tr>
  </tbody>
</table>
</div>

  YearMonth         Category     Sales
0   2020-01        Furniture  6307.705
1   2020-01  Office Supplies  4857.560
2   2020-01       Technology  3352.790
3   2020-02        Furniture  1839.658
4   2020-02  Office Supplies  1071.724

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>YearMonth</th>
      <th>Category</th>
      <th>Sales</th>
      <th>Sales_Previous</th>
      <th>MoM_Change</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>2020-02</td>
      <td>Furniture</td>
      <td>1839.658</td>
      <td>6307.705</td>
      <td>-70.834749</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2020-02</td>
      <td>Office Supplies</td>
      <td>1071.724</td>
      <td>4857.560</td>
      <td>-77.936989</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2020-02</td>
      <td>Technology</td>
      <td>1608.510</td>
      <td>3352.790</td>
      <td>-52.024732</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2020-03</td>
      <td>Furniture</td>
      <td>15816.856</td>
      <td>1839.658</td>
      <td>759.771544</td>
    </tr>
    <tr>
      <th>4</th>
      <td>2020-03</td>
      <td>Office Supplies</td>
      <td>8605.879</td>
      <td>1071.724</td>
      <td>702.993961</td>
    </tr>
  </tbody>
</table>
</div>

  YearMonth         Category      Sales  Sales_Previous  MoM_Change
0   2020-02        Furniture   1839.658        6307.705  -70.834749
1   2020-02  Office Supplies   1071.724        4857.560  -77.936989
2   2020-02       Technology   1608.510        3352.790  -52.024732
3   2020-03        Furniture  15816.856        1839.658  759.771544
4   2020-03  Office Supplies   8605.879        1071.724  702.993961

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>YearMonth</th>
      <th>Region</th>
      <th>Sales</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>2020-01</td>
      <td>Central</td>
      <td>1539.906</td>
    </tr>
    <tr>
      <th>1</th>
      <td>2020-01</td>
      <td>East</td>
      <td>717.334</td>
    </tr>
    <tr>
      <th>2</th>
      <td>2020-01</td>
      <td>South</td>
      <td>9322.092</td>
    </tr>
    <tr>
      <th>3</th>
      <td>2020-01</td>
      <td>West</td>
      <td>2938.723</td>
    </tr>
    <tr>
      <th>4</th>
      <td>2020-02</td>
      <td>Central</td>
      <td>1233.174</td>
    </tr>
  </tbody>
</table>
</div>

  YearMonth   Region     Sales
0   2020-01  Central  1539.906
1   2020-01     East   717.334
2   2020-01    South  9322.092
3   2020-01     West  2938.723
4   2020-02  Central  1233.174

<div>
<style scoped>
    .dataframe tbody tr th:only-of-type {
        vertical-align: middle;
    }

    .dataframe tbody tr th {
        vertical-align: top;
    }

    .dataframe thead th {
        text-align: right;
    }
</style>
<table border="1" class="dataframe">
  <thead>
    <tr style="text-align: right;">
      <th></th>
      <th>Row ID</th>
      <th>Order Date</th>
      <th>Sales</th>
      <th>Quantity</th>
      <th>Discount</th>
      <th>Profit</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>count</th>
      <td>10194.000000</td>
      <td>10194</td>
      <td>10194.000000</td>
      <td>10194.000000</td>
      <td>10194.000000</td>
      <td>10194.000000</td>
    </tr>
    <tr>
      <th>mean</th>
      <td>5097.500000</td>
      <td>2022-04-29 16:37:51.453796608</td>
      <td>228.225854</td>
      <td>3.791838</td>
      <td>0.155385</td>
      <td>28.673417</td>
    </tr>
    <tr>
      <th>min</th>
      <td>1.000000</td>
      <td>2020-01-03 00:00:00</td>
      <td>0.444000</td>
      <td>1.000000</td>
      <td>0.000000</td>
      <td>-6599.978000</td>
    </tr>
    <tr>
      <th>25%</th>
      <td>2549.250000</td>
      <td>2021-05-14 00:00:00</td>
      <td>17.220000</td>
      <td>2.000000</td>
      <td>0.000000</td>
      <td>1.760800</td>
    </tr>
    <tr>
      <th>50%</th>
      <td>5097.500000</td>
      <td>2022-06-25 00:00:00</td>
      <td>53.910000</td>
      <td>3.000000</td>
      <td>0.200000</td>
      <td>8.690000</td>
    </tr>
    <tr>
      <th>75%</th>
      <td>7645.750000</td>
      <td>2023-05-14 00:00:00</td>
      <td>209.500000</td>
      <td>5.000000</td>
      <td>0.200000</td>
      <td>29.297925</td>
    </tr>
    <tr>
      <th>max</th>
      <td>10194.000000</td>
      <td>2023-12-30 00:00:00</td>
      <td>22638.480000</td>
      <td>14.000000</td>
      <td>0.800000</td>
      <td>8399.976000</td>
    </tr>
    <tr>
      <th>std</th>
      <td>2942.898656</td>
      <td>NaN</td>
      <td>619.906839</td>
      <td>2.228317</td>
      <td>0.206249</td>
      <td>232.465115</td>
    </tr>
  </tbody>
</table>
</div>

             Row ID                     Order Date         Sales  \
count  10194.000000                          10194  10194.000000   
mean    5097.500000  2022-04-29 16:37:51.453796608    228.225854   
min        1.000000            2020-01-03 00:00:00      0.444000   
25%     2549.250000            2021-05-14 00:00:00     17.220000   
50%     5097.500000            2022-06-25 00:00:00     53.910000   
75%     7645.750000            2023-05-14 00:00:00    209.500000   
max    10194.000000            2023-12-30 00:00:00  22638.480000   
std     2942.898656                            NaN    619.906839   

           Quantity      Discount        Profit  
count  10194.000000  10194.000000  10194.000000  
mean       3.791838      0.155385     28.673417  
min        1.000000      0.000000  -6599.978000  
25%        2.000000      0.000000      1.760800  
50%        3.000000      0.200000      8.690000  
75%        5.000000      0.200000     29.297925  
max       14.000000      0.800000   8399.976000  
std        2.228317      0.206249    232.465115  

Sales       1.000000
Profit      0.481460
Quantity    0.198457
Discount   -0.027756
Name: Sales, dtype: float64

Analyzing Total Sales by Category in Superstore Dataset

Total sales by category

Continue the analysis

create a KPI card for month over month change in sales by category

Summary of Analysis

Create a dashboard for monitoring sales per region

Monthly Sales by Region Dashboard

Key Findings

What insights do you have about this dataset?

Dataset Summary

Numerical Columns Statistics:

Dates

What are the biggest factors driving sales?

Continue the analysis