<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>Retailer</th>
      <th>Retailer ID</th>
      <th>Invoice Date</th>
      <th>Region</th>
      <th>State</th>
      <th>City</th>
      <th>Product</th>
      <th>Price per Unit</th>
      <th>Units Sold</th>
      <th>Total Sales</th>
      <th>Operating Profit</th>
      <th>Operating Margin</th>
      <th>Sales Method</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Foot Locker</td>
      <td>1185732</td>
      <td>1/1/20</td>
      <td>Northeast</td>
      <td>New York</td>
      <td>New York</td>
      <td>Men's Street Footwear</td>
      <td>$50.00</td>
      <td>1,200</td>
      <td>$600,000</td>
      <td>$300,000</td>
      <td>50%</td>
      <td>In-store</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Foot Locker</td>
      <td>1185732</td>
      <td>1/2/20</td>
      <td>Northeast</td>
      <td>New York</td>
      <td>New York</td>
      <td>Men's Athletic Footwear</td>
      <td>$50.00</td>
      <td>1,000</td>
      <td>$500,000</td>
      <td>$150,000</td>
      <td>30%</td>
      <td>In-store</td>
    </tr>
    <tr>
      <th>2</th>
      <td>Foot Locker</td>
      <td>1185732</td>
      <td>1/3/20</td>
      <td>Northeast</td>
      <td>New York</td>
      <td>New York</td>
      <td>Women's Street Footwear</td>
      <td>$40.00</td>
      <td>1,000</td>
      <td>$400,000</td>
      <td>$140,000</td>
      <td>35%</td>
      <td>In-store</td>
    </tr>
    <tr>
      <th>3</th>
      <td>Foot Locker</td>
      <td>1185732</td>
      <td>1/4/20</td>
      <td>Northeast</td>
      <td>New York</td>
      <td>New York</td>
      <td>Women's Athletic Footwear</td>
      <td>$45.00</td>
      <td>850</td>
      <td>$382,500</td>
      <td>$133,875</td>
      <td>35%</td>
      <td>In-store</td>
    </tr>
    <tr>
      <th>4</th>
      <td>Foot Locker</td>
      <td>1185732</td>
      <td>1/5/20</td>
      <td>Northeast</td>
      <td>New York</td>
      <td>New York</td>
      <td>Men's Apparel</td>
      <td>$60.00</td>
      <td>900</td>
      <td>$540,000</td>
      <td>$162,000</td>
      <td>30%</td>
      <td>In-store</td>
    </tr>
  </tbody>
</table>
</div>

      Retailer  Retailer ID Invoice Date     Region     State      City  \
0  Foot Locker      1185732       1/1/20  Northeast  New York  New York   
1  Foot Locker      1185732       1/2/20  Northeast  New York  New York   
2  Foot Locker      1185732       1/3/20  Northeast  New York  New York   
3  Foot Locker      1185732       1/4/20  Northeast  New York  New York   
4  Foot Locker      1185732       1/5/20  Northeast  New York  New York   

                     Product Price per Unit Units Sold Total Sales  \
0      Men's Street Footwear         $50.00      1,200    $600,000   
1    Men's Athletic Footwear         $50.00      1,000    $500,000   
2    Women's Street Footwear         $40.00      1,000    $400,000   
3  Women's Athletic Footwear         $45.00        850    $382,500   
4              Men's Apparel         $60.00        900    $540,000   

  Operating Profit Operating Margin Sales Method  
0         $300,000              50%     In-store  
1         $150,000              30%     In-store  
2         $140,000              35%     In-store  
3         $133,875              35%     In-store  
4         $162,000              30%     In-store  

<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>Region</th>
      <th>Product</th>
      <th>Units Sold</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Midwest</td>
      <td>Men's Street Footwear</td>
      <td>19005</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Northeast</td>
      <td>Men's Street Footwear</td>
      <td>19855</td>
    </tr>
    <tr>
      <th>2</th>
      <td>South</td>
      <td>Men's Street Footwear</td>
      <td>26200</td>
    </tr>
    <tr>
      <th>3</th>
      <td>Southeast</td>
      <td>Men's Street Footwear</td>
      <td>12165</td>
    </tr>
    <tr>
      <th>4</th>
      <td>West</td>
      <td>Men's Street Footwear</td>
      <td>43000</td>
    </tr>
  </tbody>
</table>
</div>

      Region                Product  Units Sold
0    Midwest  Men's Street Footwear       19005
1  Northeast  Men's Street Footwear       19855
2      South  Men's Street Footwear       26200
3  Southeast  Men's Street Footwear       12165
4       West  Men's Street Footwear       43000

<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>Region</th>
      <th>Total Sales</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>Midwest</td>
      <td>32053000.0</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Northeast</td>
      <td>47782000.0</td>
    </tr>
    <tr>
      <th>2</th>
      <td>South</td>
      <td>58687500.0</td>
    </tr>
    <tr>
      <th>3</th>
      <td>Southeast</td>
      <td>30807500.0</td>
    </tr>
    <tr>
      <th>4</th>
      <td>West</td>
      <td>123341250.0</td>
    </tr>
  </tbody>
</table>
</div>

      Region  Total Sales
0    Midwest   32053000.0
1  Northeast   47782000.0
2      South   58687500.0
3  Southeast   30807500.0
4       West  123341250.0

<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>Sales Method</th>
      <th>Total Sales</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>In-store</td>
      <td>93903000.0</td>
    </tr>
    <tr>
      <th>1</th>
      <td>Outlet</td>
      <td>198768250.0</td>
    </tr>
  </tbody>
</table>
</div>

  Sales Method  Total Sales
0     In-store   93903000.0
1       Outlet  198768250.0

Vizly: AI-powered data analysis

Analysis of Top-Selling Products in Adidas US Sales by Region

What are the top-selling products by region?

What is the total sales revenue by region?

Compare sales by different sales methods