This dataset was generously provided by Olist, the largest warehouse in the Brazilian markets. Olist connects small businesses across Brazil to channels seamlessly and with a single contract. These merchants can sell their products through Olist Store and ship them directly to customers using Olist's logistics partners. To learn more, visit our website: www.olist.com

This dataset actually already exists on Kaggle, however I decided to create this version to fix certain things and make it easier to analyze.

Since this data comes from an online store, they are all separate from each other, which allows us to connect them and only the ID code. They also still need to be cleaned and processed, so I created this version, for anyone who wants to do an analysis without worrying about cleaning and how to merge them all into one data set. I also did attribution engineering, I think it's very useful for finding more insights.

1. order_id: Unique identifier of the order.
2. order_item_id: Identifier of the item in the order.
3. customer_id: Customer identifier.
4. customer_unique_id: Unique customer identifier.
5. customer_zip_code_prefix: Customer's ZIP code prefix.
6. customer_city: Customer's city.
7. customer_state: Customer's state.
8. product_id: Product identifier.
9. product_category_name: Name of the product category.
10. product_name_length: Length of the product name.
11. product_description_length: Length of the product description.
12. product_photos_qty: Quantity of product photos.
13. product_weight_g: Product weight in grams.
14. product_length_cm: Product length in centimeters.
15. product_height_cm: Product height in centimeters.
16. product_width_cm: Product width in centimeters.
17. seller_id: Seller identifier.
18. seller_city: Seller's city.
19. seller_state: Seller's state.
20. seller_zip_code_prefix: Seller's ZIP code prefix.
21. payment_type: Payment type.
22. payment_sequential: Payment sequential.
23. payment_installments: Number of payment installments.
24. installments_price: Price of installments.
25. price: Product price.
26. freight_value: Freight value.
27. payment_value: Total payment value.
28. shipping_limit_date: Shipping deadline date.
29. order_purchase_timestamp: Purchase timestamp.
30. order_approved_at: Order approval timestamp.
31. order_delivered_carrier_date: Delivery date to the carrier.
32. order_delivered_customer_date: Delivery date to the customer.
33. order_estimated_delivery_date: Estimated delivery date.
34. shipping_duration: Shipping duration.
35. day_of_purchase: Day of purchase.
36. month_of_purchase: Month of purchase.
37. year_of_purchase: Year of purchase.
38. month/year_of_purchase: Month and year of purchase.
39. order_status: Order status.
40. order_unique_id: Unique order identifier.

Enzo Schitini

Data Scientist • Expert Bubble.io • UX & UI @ Nugus creator