Exploratory Data Analysis
Statistical summary of numerical columns across 99,441 order records
Item Price (R$)
8,427 outliersCount112,650
Mean120.65
Median74.99
Std Dev183.63
Q1 / Q339.9 / 134.9
Min / Max0.85 / 6,735
Freight Value (R$)
9,941 outliersCount98,666
Mean22.82
Median17.17
Std Dev21.65
Q1 / Q313.85 / 24.04
Min / Max0 / 1,794.96
Payment Value (R$)
7,981 outliersCount103,886
Mean154.10
Median100.00
Std Dev217.49
Q1 / Q356.79 / 171.84
Min / Max0 / 13,664.08
Review Score
14,575 outliersCount99,224
Mean4.09
Median5.00
Std Dev1.35
Q1 / Q34 / 5
Min / Max1 / 5
Delivery Days
5,022 outliersCount96,470
Mean12.09
Median10.00
Std Dev9.55
Q1 / Q36 / 15
Min / Max0 / 209
Review Score Distribution
Avg: 4.09/5 across 99,224 reviews
Categorical Column Analysis
Order Status
delivered97.0%
shipped1.1%
canceled0.6%
unavailable0.6%
invoiced0.3%
Payment Type
credit card73.9%
boleto19.0%
voucher5.6%
debit card1.5%
Top States
SP42.0%
RJ12.9%
MG11.7%
RS5.5%
PR5.1%
Ask the AI Analyst
"Show the distribution of payment values" or "Show average payment by method"