| \n", " | Days for shipping (real) | \n", "Days for shipment (scheduled) | \n", "Benefit per order | \n", "Sales per customer | \n", "Late_delivery_risk | \n", "Category Id | \n", "Customer Id | \n", "Customer Zipcode | \n", "Department Id | \n", "Latitude | \n", "... | \n", "Order Item Quantity | \n", "Sales | \n", "Order Item Total | \n", "Order Profit Per Order | \n", "Order Zipcode | \n", "Product Card Id | \n", "Product Category Id | \n", "Product Description | \n", "Product Price | \n", "Product Status | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "180519.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "180516.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "... | \n", "180519.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "24840.000000 | \n", "180519.000000 | \n", "180519.000000 | \n", "0.0 | \n", "180519.000000 | \n", "180519.0 | \n", "
| mean | \n", "3.497654 | \n", "2.931847 | \n", "21.974989 | \n", "183.107609 | \n", "0.548291 | \n", "31.851451 | \n", "6691.379495 | \n", "35921.126914 | \n", "5.443460 | \n", "29.719955 | \n", "... | \n", "2.127638 | \n", "203.772096 | \n", "183.107609 | \n", "21.974989 | \n", "55426.132327 | \n", "692.509764 | \n", "31.851451 | \n", "NaN | \n", "141.232550 | \n", "0.0 | \n", "
| std | \n", "1.623722 | \n", "1.374449 | \n", "104.433526 | \n", "120.043670 | \n", "0.497664 | \n", "15.640064 | \n", "4162.918106 | \n", "37542.461122 | \n", "1.629246 | \n", "9.813646 | \n", "... | \n", "1.453451 | \n", "132.273077 | \n", "120.043670 | \n", "104.433526 | \n", "31919.279101 | \n", "336.446807 | \n", "15.640064 | \n", "NaN | \n", "139.732492 | \n", "0.0 | \n", "
| min | \n", "0.000000 | \n", "0.000000 | \n", "-4274.979980 | \n", "7.490000 | \n", "0.000000 | \n", "2.000000 | \n", "1.000000 | \n", "603.000000 | \n", "2.000000 | \n", "-33.937553 | \n", "... | \n", "1.000000 | \n", "9.990000 | \n", "7.490000 | \n", "-4274.979980 | \n", "1040.000000 | \n", "19.000000 | \n", "2.000000 | \n", "NaN | \n", "9.990000 | \n", "0.0 | \n", "
| 25% | \n", "2.000000 | \n", "2.000000 | \n", "7.000000 | \n", "104.379997 | \n", "0.000000 | \n", "18.000000 | \n", "3258.500000 | \n", "725.000000 | \n", "4.000000 | \n", "18.265432 | \n", "... | \n", "1.000000 | \n", "119.980003 | \n", "104.379997 | \n", "7.000000 | \n", "23464.000000 | \n", "403.000000 | \n", "18.000000 | \n", "NaN | \n", "50.000000 | \n", "0.0 | \n", "
| 50% | \n", "3.000000 | \n", "4.000000 | \n", "31.520000 | \n", "163.990005 | \n", "1.000000 | \n", "29.000000 | \n", "6457.000000 | \n", "19380.000000 | \n", "5.000000 | \n", "33.144863 | \n", "... | \n", "1.000000 | \n", "199.919998 | \n", "163.990005 | \n", "31.520000 | \n", "59405.000000 | \n", "627.000000 | \n", "29.000000 | \n", "NaN | \n", "59.990002 | \n", "0.0 | \n", "
| 75% | \n", "5.000000 | \n", "4.000000 | \n", "64.800003 | \n", "247.399994 | \n", "1.000000 | \n", "45.000000 | \n", "9779.000000 | \n", "78207.000000 | \n", "7.000000 | \n", "39.279617 | \n", "... | \n", "3.000000 | \n", "299.950012 | \n", "247.399994 | \n", "64.800003 | \n", "90008.000000 | \n", "1004.000000 | \n", "45.000000 | \n", "NaN | \n", "199.990005 | \n", "0.0 | \n", "
| max | \n", "6.000000 | \n", "4.000000 | \n", "911.799988 | \n", "1939.989990 | \n", "1.000000 | \n", "76.000000 | \n", "20757.000000 | \n", "99205.000000 | \n", "12.000000 | \n", "48.781933 | \n", "... | \n", "5.000000 | \n", "1999.989990 | \n", "1939.989990 | \n", "911.799988 | \n", "99301.000000 | \n", "1363.000000 | \n", "76.000000 | \n", "NaN | \n", "1999.989990 | \n", "0.0 | \n", "
8 rows × 29 columns
\n", "| \n", " | 0 | \n", "
|---|---|
| Customer Lname | \n", "8 | \n", "
| Customer Zipcode | \n", "3 | \n", "
| Order Zipcode | \n", "155679 | \n", "
| Product Description | \n", "180519 | \n", "
| \n", " | Days for shipping (real) | \n", "Days for shipment (scheduled) | \n", "Benefit per order | \n", "Sales per customer | \n", "Late_delivery_risk | \n", "Customer Zipcode | \n", "Latitude | \n", "Longitude | \n", "order date (DateOrders) | \n", "Order Item Discount | \n", "Order Item Discount Rate | \n", "Order Item Product Price | \n", "Order Item Profit Ratio | \n", "Order Item Quantity | \n", "Sales | \n", "Order Item Total | \n", "Order Profit Per Order | \n", "Product Price | \n", "Product Status | \n", "shipping date (DateOrders) | \n", "
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| count | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.000000 | \n", "180516.0 | \n", "180516 | \n", "
| mean | \n", "3.497657 | \n", "2.931845 | \n", "21.974593 | \n", "183.107723 | \n", "0.548295 | \n", "35921.126914 | \n", "29.719830 | \n", "-84.915074 | \n", "2016-06-12 17:34:40.783421184 | \n", "20.664413 | \n", "0.101667 | \n", "141.231298 | \n", "0.120644 | \n", "2.127656 | \n", "203.771883 | \n", "183.107723 | \n", "21.974593 | \n", "141.231298 | \n", "0.0 | \n", "2016-06-16 05:32:59.553612544 | \n", "
| min | \n", "0.000000 | \n", "0.000000 | \n", "-4274.979980 | \n", "7.490000 | \n", "0.000000 | \n", "603.000000 | \n", "-33.937553 | \n", "-158.025986 | \n", "2015-01-01 00:00:00 | \n", "0.000000 | \n", "0.000000 | \n", "9.990000 | \n", "-2.750000 | \n", "1.000000 | \n", "9.990000 | \n", "7.490000 | \n", "-4274.979980 | \n", "9.990000 | \n", "0.0 | \n", "2015-01-03 00:00:00 | \n", "
| 25% | \n", "2.000000 | \n", "2.000000 | \n", "7.000000 | \n", "104.379997 | \n", "0.000000 | \n", "725.000000 | \n", "18.265432 | \n", "-98.446312 | \n", "2015-09-21 13:28:00 | \n", "5.400000 | \n", "0.040000 | \n", "50.000000 | \n", "0.080000 | \n", "1.000000 | \n", "119.980003 | \n", "104.379997 | \n", "7.000000 | \n", "50.000000 | \n", "0.0 | \n", "2015-09-25 06:40:30 | \n", "
| 50% | \n", "3.000000 | \n", "4.000000 | \n", "31.520000 | \n", "163.990005 | \n", "1.000000 | \n", "19380.000000 | \n", "33.144863 | \n", "-76.840759 | \n", "2016-06-11 13:06:00 | \n", "14.000000 | \n", "0.100000 | \n", "59.990002 | \n", "0.270000 | \n", "1.000000 | \n", "199.919998 | \n", "163.990005 | \n", "31.520000 | \n", "59.990002 | \n", "0.0 | \n", "2016-06-15 07:29:00 | \n", "
| 75% | \n", "5.000000 | \n", "4.000000 | \n", "64.800003 | \n", "247.399994 | \n", "1.000000 | \n", "78207.000000 | \n", "39.279617 | \n", "-66.370583 | \n", "2017-03-01 08:42:00 | \n", "29.990000 | \n", "0.160000 | \n", "199.990005 | \n", "0.360000 | \n", "3.000000 | \n", "299.950012 | \n", "247.399994 | \n", "64.800003 | \n", "199.990005 | \n", "0.0 | \n", "2017-03-04 20:41:45 | \n", "
| max | \n", "6.000000 | \n", "4.000000 | \n", "911.799988 | \n", "1939.989990 | \n", "1.000000 | \n", "99205.000000 | \n", "48.781933 | \n", "115.263077 | \n", "2018-01-31 23:38:00 | \n", "500.000000 | \n", "0.250000 | \n", "1999.989990 | \n", "0.500000 | \n", "5.000000 | \n", "1999.989990 | \n", "1939.989990 | \n", "911.799988 | \n", "1999.989990 | \n", "0.0 | \n", "2018-02-06 22:14:00 | \n", "
| std | \n", "1.623731 | \n", "1.374449 | \n", "104.434300 | \n", "120.043872 | \n", "0.497664 | \n", "37542.461122 | \n", "9.813676 | \n", "21.432911 | \n", "NaN | \n", "21.800633 | \n", "0.070415 | \n", "139.732278 | \n", "0.466799 | \n", "1.453456 | \n", "132.273070 | \n", "120.043872 | \n", "104.434300 | \n", "139.732278 | \n", "0.0 | \n", "NaN | \n", "