Data Dictionary
| Column Name | Description | Unique Values | Data Type | Missing Values |
|---|---|---|---|---|
| Row ID | Unique identifier for each row | 9800 | int64 | 0 |
| Order ID | Unique identifier for each order | 4922 | object | 0 |
| Order Date | Date when the order was placed | 1230 | object | 0 |
| Ship Date | Date when the order was shipped | 1326 | object | 0 |
| Ship Mode | Method of shipping (e.g., Standard) | 4 | object | 0 |
| Customer ID | Unique identifier for each customer | 793 | object | 0 |
| Customer Name | Name of the customer | 793 | object | 0 |
| Segment | Customer segment (e.g., Consumer) | 3 | object | 0 |
| Country | Country of the customer | 1 | object | 0 |
| City | City of the customer | 529 | object | 0 |
| State | State of the customer | 49 | object | 0 |
| Postal Code | Postal code of the customer | 626 | float64 | 11 |
| Region | Region of the customer | 4 | object | 0 |
| Product ID | Unique identifier for each product | 1861 | object | 0 |
| Category | Main category of the product | 3 | object | 0 |
| Sub-Category | Sub-category of the product | 17 | object | 0 |
| Product Name | Name of the product | 1849 | object | 0 |
| Sales | Total sales amount for the order | 5757 | float64 | 0 |
Dataset Overview
General Information:
Duplicate Values: 0
Total Entries: 9800
Columns: 18
Memory Usage: Approximately 1.3 MB
Purpose:
This structured data dictionary provides a comprehensive overview of the dataset, facilitating easier data analysis and management.