I. Dataset Summary

The electric store sells technology products such as phones, charging cables...

II. Data fields

  1. Order ID: An Order ID is the number system that Amazon uses exclusively to keep track of orders. Each order receives its own Order ID that will not be duplicated. This number can be useful to the seller when attempting to find out certain details about an order such as shipment date or status.
  2. Product: The product that has been sold.
  3. Quantity Ordered: Ordered Quantity is the total item quantity ordered in the initial order (without any changes).
  4. Price Each: The price of each product.
  5. Order Date: This is the date the customer is requesting the order be shipped.
  6. Purchase Address: The purchase order is prepared by the buyer, often through a purchasing department. The purchase order, or PO, usually includes a PO number, which is useful in matching shipments with purchases; a shipping date; billing address; shipping address; and the requested items, quantities, and price.

III. Language: Python

IV. Tasks

  1. What was the best month for sales? How much was earned that month?
  2. What city had the highest number of sales?
  3. What time should we display advertisements to maximize the likelihood of customers buying products?
  4. What time had the highest number of sales?
  5. What products are most often sold together?
  6. What product sold the most?

BACK TO HOMEPAGE