<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>CustomerID</th>
      <th>ProductID</th>
      <th>Quantity</th>
      <th>Price</th>
      <th>TransactionDate</th>
      <th>PaymentMethod</th>
      <th>StoreLocation</th>
      <th>ProductCategory</th>
      <th>DiscountApplied(%)</th>
      <th>TotalAmount</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>0</th>
      <td>109318</td>
      <td>C</td>
      <td>7</td>
      <td>80.079844</td>
      <td>12/26/2023 12:32</td>
      <td>Cash</td>
      <td>176 Andrew Cliffs\nBaileyfort, HI 93354</td>
      <td>Books</td>
      <td>18.677100</td>
      <td>455.862764</td>
    </tr>
    <tr>
      <th>1</th>
      <td>993229</td>
      <td>C</td>
      <td>4</td>
      <td>75.195229</td>
      <td>8/5/2023 0:00</td>
      <td>Cash</td>
      <td>11635 William Well Suite 809\nEast Kara, MT 19483</td>
      <td>Home Decor</td>
      <td>14.121365</td>
      <td>258.306546</td>
    </tr>
    <tr>
      <th>2</th>
      <td>579675</td>
      <td>A</td>
      <td>8</td>
      <td>31.528816</td>
      <td>3/11/2024 18:51</td>
      <td>Cash</td>
      <td>910 Mendez Ville Suite 909\nPort Lauraland, MO...</td>
      <td>Books</td>
      <td>15.943701</td>
      <td>212.015651</td>
    </tr>
    <tr>
      <th>3</th>
      <td>799826</td>
      <td>D</td>
      <td>5</td>
      <td>98.880218</td>
      <td>10/27/2023 22:00</td>
      <td>PayPal</td>
      <td>87522 Sharon Corners Suite 500\nLake Tammy, MO...</td>
      <td>Books</td>
      <td>6.686337</td>
      <td>461.343769</td>
    </tr>
    <tr>
      <th>4</th>
      <td>121413</td>
      <td>A</td>
      <td>7</td>
      <td>93.188512</td>
      <td>12/22/2023 11:38</td>
      <td>Cash</td>
      <td>0070 Michelle Island Suite 143\nHoland, VA 80142</td>
      <td>Electronics</td>
      <td>4.030096</td>
      <td>626.030484</td>
    </tr>
  </tbody>
</table>
</div>

   CustomerID ProductID  Quantity      Price   TransactionDate PaymentMethod  \
0      109318         C         7  80.079844  12/26/2023 12:32          Cash   
1      993229         C         4  75.195229     8/5/2023 0:00          Cash   
2      579675         A         8  31.528816   3/11/2024 18:51          Cash   
3      799826         D         5  98.880218  10/27/2023 22:00        PayPal   
4      121413         A         7  93.188512  12/22/2023 11:38          Cash   

                                       StoreLocation ProductCategory  \
0            176 Andrew Cliffs\nBaileyfort, HI 93354           Books   
1  11635 William Well Suite 809\nEast Kara, MT 19483      Home Decor   
2  910 Mendez Ville Suite 909\nPort Lauraland, MO...           Books   
3  87522 Sharon Corners Suite 500\nLake Tammy, MO...           Books   
4   0070 Michelle Island Suite 143\nHoland, VA 80142     Electronics   

   DiscountApplied(%)  TotalAmount  
0           18.677100   455.862764  
1           14.121365   258.306546  
2           15.943701   212.015651  
3            6.686337   461.343769  
4            4.030096   626.030484  

<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>ProductID</th>
      <th>Quantity</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <th>2</th>
      <td>C</td>
      <td>125978</td>
    </tr>
    <tr>
      <th>3</th>
      <td>D</td>
      <td>125786</td>
    </tr>
    <tr>
      <th>1</th>
      <td>B</td>
      <td>125070</td>
    </tr>
    <tr>
      <th>0</th>
      <td>A</td>
      <td>124095</td>
    </tr>
  </tbody>
</table>
</div>

  ProductID  Quantity
2         C    125978
3         D    125786
1         B    125070
0         A    124095

stderr

The following objects are masked from ‘package:stats’:

    filter, lag




The following objects are masked from ‘package:base’:

    intersect, setdiff, setequal, union




The following objects are masked from ‘package:base’:

    date, intersect, setdiff, union




The following object is masked from ‘package:ggplot2’:

    last_plot




The following object is masked from ‘package:stats’:

    filter




The following object is masked from ‘package:graphics’:

    layout




HTML widgets cannot be represented in plain text (need html)

Analysis of Retail Transaction Dataset: Top-Selling Products

What are the top-selling products?

Analyise the market trend