Retail Insights: A Comprehensive Sales Dataset

The provided dataset is a synthetic dataset which represents sales information for a company, containing 5000 entries with 24 columns. The data encompasses various aspects of sales transactions, including order details, customer information, product details, pricing, and shipping information. Below is a detailed breakdown of each column:

Column Descriptions:

1. Order No: Unique identifier for each order.
2. Order Date: Date when the order was placed.
3. Customer Name: Name of the customer placing the order.
4. Address: Customer's address (one entry appears to be missing).
5. City: City where the customer is located.
6. State: State where the customer is located.
7. Customer Type: Type of customer (e.g., retail, wholesale).
8. Account Manager: Name of the account manager handling the order.
9. Order Priority: Priority level of the order.
10. Product Name: Name of the product being sold.
11. Product Category: Category to which the product belongs.
12. Product Container: Container type for the product.
13. Ship Mode: Mode of shipping for the order.
14. Ship Date: Date when the order was shipped.
15. Cost Price: Cost price of the product.
16. Retail Price: Retail price at which the product is sold.
17. Profit Margin: Margin between retail and cost prices.
18. Order Quantity: Quantity of products ordered.
19. Sub Total: Subtotal cost of the order.
20. Discount %: Percentage of discount applied to the order.
21. Discount $: Dollar amount of the discount.
22. Order Total: Total cost of the order after applying discounts.
23. Shipping Cost: Cost associated with shipping the order.
24. Total: Overall total cost, including product cost, discounts, and shipping.

Dataset Characteristics:
The dataset is diverse, containing both categorical and numerical data. It includes temporal information with "Order Date" and "Ship Date" in datetime format. Some columns like "Cost Price," "Retail Price," and others related to monetary values are currently stored as objects, which may need conversion for accurate numerical analysis. The dataset provides a comprehensive snapshot of the sales process, making it suitable for various analytical and exploratory tasks.