<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>Full Name</th>
      <th>Inventory</th>
      <th>Class</th>
      <th>Type</th>
      <th>Size</th>
      <th>Brand</th>
      <th>Client</th>
      <th>On Hand</th>
      <th>Avg Cost</th>
      <th>Sales Price</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>1CANDLE (Further 9oz Candle)</td>
      <td>Further 9oz Candle</td>
      <td>Candle</td>
      <td>NaN</td>
      <td>NaN</td>
      <td>Further</td>
      <td>x</td>
      <td>12.0</td>
      <td>12.00</td>
      <td>12.0000</td>
    </tr>
    <tr>
      <th>1</th>
      <td>DR-44005 (Corpus Plastic caps, fine ribbed clo...</td>
      <td>Corpus Plastic caps, fine ribbed closure with ...</td>
      <td>Restaurant</td>
      <td>Plastic Caps</td>
      <td>x</td>
      <td>Corpus</td>
      <td>x</td>
      <td>3606.0</td>
      <td>0.04</td>
      <td>0.0400</td>
    </tr>
    <tr>
      <th>2</th>
      <td>Further Label 500ml- Body Wash (Further Label ...</td>
      <td>Further Label 500ml Refillable Amber Bottle- B...</td>
      <td>Body Wash</td>
      <td>Refill Bottle</td>
      <td>500ml</td>
      <td>Further</td>
      <td>x</td>
      <td>238.0</td>
      <td>0.24</td>
      <td>0.2412</td>
    </tr>
    <tr>
      <th>3</th>
      <td>Further Label 500ml-Conditioner (Further Label...</td>
      <td>Further Label 500ml Refillable Amber Bottle- C...</td>
      <td>Conditioner</td>
      <td>Refill Bottle</td>
      <td>500ml</td>
      <td>Further</td>
      <td>x</td>
      <td>238.0</td>
      <td>0.24</td>
      <td>0.0000</td>
    </tr>
    <tr>
      <th>4</th>
      <td>Further Label 500ml-Lotion (Further Label 500m...</td>
      <td>Further Label 500ml Refillable Amber Bottle- L...</td>
      <td>Body Lotion</td>
      <td>Refill Bottle</td>
      <td>500ml</td>
      <td>Further</td>
      <td>x</td>
      <td>310.0</td>
      <td>0.24</td>
      <td>0.2412</td>
    </tr>
  </tbody>
</table>
</div>

                                           Full Name  \
0                       1CANDLE (Further 9oz Candle)   
1  DR-44005 (Corpus Plastic caps, fine ribbed clo...   
2  Further Label 500ml- Body Wash (Further Label ...   
3  Further Label 500ml-Conditioner (Further Label...   
4  Further Label 500ml-Lotion (Further Label 500m...   

                                           Inventory        Class  \
0                                 Further 9oz Candle       Candle   
1  Corpus Plastic caps, fine ribbed closure with ...   Restaurant   
2  Further Label 500ml Refillable Amber Bottle- B...    Body Wash   
3  Further Label 500ml Refillable Amber Bottle- C...  Conditioner   
4  Further Label 500ml Refillable Amber Bottle- L...  Body Lotion   

            Type   Size    Brand Client  On Hand  Avg Cost  Sales Price  
0            NaN    NaN  Further      x     12.0     12.00      12.0000  
1   Plastic Caps      x   Corpus      x   3606.0      0.04       0.0400  
2  Refill Bottle  500ml  Further      x    238.0      0.24       0.2412  
3  Refill Bottle  500ml  Further      x    238.0      0.24       0.0000  
4  Refill Bottle  500ml  Further      x    310.0      0.24       0.2412  

<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>Client</th>
      <th>Class</th>
      <th>On Hand</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Altair</td>
      <td>Key Card</td>
      <td>19000.0000</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Altair</td>
      <td>Umbrella</td>
      <td>350.0000</td>
    </tr>
    <tr>
      <th>2</th>
      <td>Biltmore</td>
      <td>Key Card</td>
      <td>82000.0000</td>
    </tr>
    <tr>
      <th>3</th>
      <td>Courtyard Inn</td>
      <td>Key Card</td>
      <td>17000.0000</td>
    </tr>
    <tr>
      <th>4</th>
      <td>Hotel Saint</td>
      <td>Body Lotion</td>
      <td>231.0000</td>
    </tr>
    <tr>
      <th>5</th>
      <td>Hotel Saint</td>
      <td>Body Wash</td>
      <td>270.0000</td>
    </tr>
    <tr>
      <th>6</th>
      <td>Hotel Saint</td>
      <td>Conditioner</td>
      <td>279.0000</td>
    </tr>
    <tr>
      <th>7</th>
      <td>Margaritaville Times Square</td>
      <td>Key Card</td>
      <td>15000.0000</td>
    </tr>
    <tr>
      <th>8</th>
      <td>Marriott Bonvoy</td>
      <td>Key Card</td>
      <td>30000.0000</td>
    </tr>
    <tr>
      <th>9</th>
      <td>Mosaic</td>
      <td>Key Card</td>
      <td>8000.0000</td>
    </tr>
    <tr>
      <th>10</th>
      <td>Mosaic</td>
      <td>Luggage Tag</td>
      <td>14000.0000</td>
    </tr>
    <tr>
      <th>11</th>
      <td>Renaissance Honolulu</td>
      <td>Umbrella</td>
      <td>200.0000</td>
    </tr>
    <tr>
      <th>12</th>
      <td>Smyth</td>
      <td>Luggage Tag</td>
      <td>8000.0000</td>
    </tr>
    <tr>
      <th>13</th>
      <td>The Elser</td>
      <td>Key Card</td>
      <td>80000.0000</td>
    </tr>
    <tr>
      <th>14</th>
      <td>The Gates</td>
      <td>Key Card</td>
      <td>12000.0000</td>
    </tr>
    <tr>
      <th>15</th>
      <td>The Gregorian</td>
      <td>Key Card</td>
      <td>9000.0000</td>
    </tr>
    <tr>
      <th>16</th>
      <td>The Joseph</td>
      <td>Key Card</td>
      <td>40000.0000</td>
    </tr>
    <tr>
      <th>17</th>
      <td>The Newbury</td>
      <td>Key Card</td>
      <td>21070.0000</td>
    </tr>
    <tr>
      <th>18</th>
      <td>Viceroy</td>
      <td>Key Card</td>
      <td>168000.0000</td>
    </tr>
    <tr>
      <th>19</th>
      <td>Viceroy</td>
      <td>Luggage Tag</td>
      <td>15000.0000</td>
    </tr>
    <tr>
      <th>20</th>
      <td>x</td>
      <td>Body Lotion</td>
      <td>397148.5000</td>
    </tr>
    <tr>
      <th>21</th>
      <td>x</td>
      <td>Body Wash</td>
      <td>94361.0000</td>
    </tr>
    <tr>
      <th>22</th>
      <td>x</td>
      <td>Candle</td>
      <td>12.0000</td>
    </tr>
    <tr>
      <th>23</th>
      <td>x</td>
      <td>Conditioner</td>
      <td>105823.6216</td>
    </tr>
    <tr>
      <th>24</th>
      <td>x</td>
      <td>Hand Wash</td>
      <td>34848.0000</td>
    </tr>
    <tr>
      <th>25</th>
      <td>x</td>
      <td>Key Card</td>
      <td>74000.0000</td>
    </tr>
    <tr>
      <th>26</th>
      <td>x</td>
      <td>Luggage Tag</td>
      <td>28000.0000</td>
    </tr>
    <tr>
      <th>27</th>
      <td>x</td>
      <td>Restaurant</td>
      <td>3606.0000</td>
    </tr>
    <tr>
      <th>28</th>
      <td>x</td>
      <td>Shampoo</td>
      <td>105002.8128</td>
    </tr>
    <tr>
      <th>29</th>
      <td>x</td>
      <td>Umbrella</td>
      <td>500.0000</td>
    </tr>
  </tbody>
</table>
</div>

                         Client        Class      On Hand
0                        Altair     Key Card   19000.0000
1                        Altair     Umbrella     350.0000
2                      Biltmore     Key Card   82000.0000
3                 Courtyard Inn     Key Card   17000.0000
4                   Hotel Saint  Body Lotion     231.0000
5                   Hotel Saint    Body Wash     270.0000
6                   Hotel Saint  Conditioner     279.0000
7   Margaritaville Times Square     Key Card   15000.0000
8               Marriott Bonvoy     Key Card   30000.0000
9                        Mosaic     Key Card    8000.0000
10                       Mosaic  Luggage Tag   14000.0000
11         Renaissance Honolulu     Umbrella     200.0000
12                        Smyth  Luggage Tag    8000.0000
13                    The Elser     Key Card   80000.0000
14                    The Gates     Key Card   12000.0000
15                The Gregorian     Key Card    9000.0000
16                   The Joseph     Key Card   40000.0000
17                  The Newbury     Key Card   21070.0000
18                      Viceroy     Key Card  168000.0000
19                      Viceroy  Luggage Tag   15000.0000
20                            x  Body Lotion  397148.5000
21                            x    Body Wash   94361.0000
22                            x       Candle      12.0000
23                            x  Conditioner  105823.6216
24                            x    Hand Wash   34848.0000
25                            x     Key Card   74000.0000
26                            x  Luggage Tag   28000.0000
27                            x   Restaurant    3606.0000
28                            x      Shampoo  105002.8128
29                            x     Umbrella     500.0000

Vizly: AI-powered data analysis

Analyzing Inventory Data from Excel with Visualization

Visualize inventory distribution by brand.

`Can you tell me the inventory on hand by client and Class`

can you visualize the amount of body wash that we have on hand

Client	Class	On Hand
Altair	Key Card	19000.0000
Altair	Umbrella	350.0000
Biltmore	Key Card	82000.0000
Courtyard Inn	Key Card	17000.0000
Hotel Saint	Body Lotion	231.0000
Hotel Saint	Body Wash	270.0000
Hotel Saint	Conditioner	279.0000
Margaritaville Times Square	Key Card	15000.0000
Marriott Bonvoy	Key Card	30000.0000
Mosaic	Key Card	8000.0000
Mosaic	Luggage Tag	14000.0000
Renaissance Honolulu	Umbrella	200.0000
Smyth	Luggage Tag	8000.0000
The Elser	Key Card	80000.0000
The Gates	Key Card	12000.0000
The Gregorian	Key Card	9000.0000
The Joseph	Key Card	40000.0000
The Newbury	Key Card	21070.0000
Viceroy	Key Card	168000.0000
Viceroy	Luggage Tag	15000.0000
x	Body Lotion	397148.5000
x	Body Wash	94361.0000
x	Candle	12.0000
x	Conditioner	105823.6216
x	Hand Wash	34848.0000
x	Key Card	74000.0000
x	Luggage Tag	28000.0000
x	Restaurant	3606.0000
x	Shampoo	105002.8128
x	Umbrella	500.0000