DataFrame view

Each column header stacks the column name above a tally strip and a distribution strip — an at-a-glance column profile right in the header, as you might see in a SQL client or BI tool previewing a query result set. Hover any strip for its share, value, and count.

transaction_id
column tally: 150 distinct, 0 duplicate, 0 missing of 150 entriesdistinct 100% (150 of 150 entries) (150 appearing once)
pavement sparkline of 150 values1e+04 to 1e+04 p0 to p12 11% (17 of 150 values)1e+04 to 1e+04 p12 to p25 12% (18 of 150 values)1e+04 to 1.01e+04 p25 to p38 12% (18 of 150 values)1.01e+04 to 1.01e+04 p38 to p50 12% (18 of 150 values)1.01e+04 to 1.01e+04 p50 to p62 12% (18 of 150 values)1.01e+04 to 1.01e+04 p62 to p75 12% (18 of 150 values)1.01e+04 to 1.01e+04 p75 to p88 12% (18 of 150 values)1.01e+04 to 1.02e+04 p88 to p100 11% (17 of 150 values)1e+04 p0 1% (1 of 150 values)1e+04 p12 1% (1 of 150 values)1e+04 p25 1% (1 of 150 values)1.01e+04 p38 1% (1 of 150 values)1.01e+04 p50 0% (0 of 150 values)1.01e+04 p62 1% (1 of 150 values)1.01e+04 p75 1% (1 of 150 values)1.01e+04 p88 1% (1 of 150 values)1.02e+04 p100 1% (1 of 150 values)
customer_id
column tally: 47 distinct, 103 duplicate, 0 missing of 150 entriesdistinct 31% (47 of 150 entries) (7 appearing once)duplicate 69% (103 of 150 entries)
pavement sparkline of 150 values1 to 6 p0 to p12 8% (12 of 150 values)6 to 12 p12 to p25 12% (18 of 150 values)12 to 17 p25 to p38 9% (14 of 150 values)17 to 27 p38 to p50 12% (18 of 150 values)27 to 34 p50 to p62 12% (18 of 150 values)34 to 38 p62 to p75 8% (12 of 150 values)38 to 46 p75 to p88 12% (18 of 150 values)46 to 50 p88 to p100 9% (14 of 150 values)1 p0 3% (4 of 150 values)6 p12 2% (3 of 150 values)12 p25 1% (1 of 150 values)17 p38 3% (5 of 150 values)27 p50 0% (0 of 150 values)34 p62 3% (4 of 150 values)38 p75 3% (4 of 150 values)46 p88 1% (2 of 150 values)50 p100 2% (3 of 150 values)
product
column tally: 15 distinct, 135 duplicate, 0 missing of 150 entriesdistinct 10% (15 of 150 entries) (0 appearing once)duplicate 90% (135 of 150 entries)
value proportions of 150 values across 15 distinct values, top 12 shown27-inch Monitor 11% (16 of 150 values)Pen Set 12pk 9% (14 of 150 values)Mechanical Keyboard 9% (14 of 150 values)Stapler Heavy-Duty 8% (12 of 150 values)USB-C Hub 7% (11 of 150 values)Noise-Cancelling Headphones 7% (10 of 150 values)Laptop Pro 6% (9 of 150 values)Monitor Arm 6% (9 of 150 values)Webcam HD 6% (9 of 150 values)Ergonomic Chair 6% (9 of 150 values)Standing Desk Converter 6% (9 of 150 values)Desk Lamp LED 5% (8 of 150 values)other 13% (20 of 150 values) (across 3 distinct values)
category
column tally: 3 distinct, 147 duplicate, 0 missing of 150 entriesdistinct 2% (3 of 150 entries) (0 appearing once)duplicate 98% (147 of 150 entries)
value proportions of 150 values across 3 distinct valuesElectronics 54% (81 of 150 values)Office 28% (42 of 150 values)Furniture 18% (27 of 150 values)
amount
column tally: 149 distinct, 1 duplicate, 0 missing of 150 entriesdistinct 99% (149 of 150 entries) (148 appearing once)duplicate 1% (1 of 150 entries)
pavement sparkline of 150 values4.28 to 12.3 p0 to p12 11% (17 of 150 values)12.3 to 18.1 p12 to p25 12% (18 of 150 values)18.1 to 23.6 p25 to p38 12% (18 of 150 values)23.6 to 31.1 p38 to p50 12% (18 of 150 values)31.1 to 37.8 p50 to p62 12% (18 of 150 values)37.8 to 54.6 p62 to p75 12% (18 of 150 values)54.6 to 81 p75 to p88 12% (18 of 150 values)81 to 287 p88 to p100 11% (17 of 150 values)4.28 p0 1% (1 of 150 values)12.3 p12 1% (1 of 150 values)18.1 p25 1% (1 of 150 values)23.6 p38 1% (1 of 150 values)31.1 p50 0% (0 of 150 values)37.8 p62 1% (1 of 150 values)54.6 p75 1% (1 of 150 values)81 p88 1% (1 of 150 values)287 p100 1% (1 of 150 values)
quantity
column tally: 8 distinct, 142 duplicate, 0 missing of 150 entriesdistinct 5% (8 of 150 entries) (0 appearing once)duplicate 95% (142 of 150 entries)
pavement sparkline of 150 values1 to 2 0% (0 of 150 values)2 to 3 0% (0 of 150 values)3 to 4 0% (0 of 150 values)4 to 5 0% (0 of 150 values)5 to 6 0% (0 of 150 values)6 to 7 0% (0 of 150 values)7 to 8 0% (0 of 150 values)1 p0 to p42 43% (64 of 150 values)2 p43 to p70 28% (42 of 150 values)3 p71 to p82 11% (17 of 150 values)4 p83 to p89 7% (11 of 150 values)5 p90 to p93 4% (6 of 150 values)6 p94 to p97 3% (5 of 150 values)7 p97 to p99 2% (3 of 150 values)8 p99 to p100 1% (2 of 150 values)
date
column tally: 121 distinct, 29 duplicate, 0 missing of 150 entriesdistinct 81% (121 of 150 entries) (94 appearing once)duplicate 19% (29 of 150 entries)
pavement sparkline of 150 values2024-01-01 to 2024-02-28 p0 to p12 11% (17 of 150 values)2024-02-28 to 2024-04-25 p12 to p25 12% (18 of 150 values)2024-04-25 to 2024-06-11 p25 to p38 12% (18 of 150 values)2024-06-11 to 2024-07-26 p38 to p50 12% (18 of 150 values)2024-07-26 to 2024-08-28 p50 to p62 12% (18 of 150 values)2024-08-28 to 2024-09-22 p62 to p75 11% (16 of 150 values)2024-09-22 to 2024-11-14 p75 to p88 12% (18 of 150 values)2024-11-14 to 2024-12-29 p88 to p100 11% (17 of 150 values)2024-01-01 p0 1% (1 of 150 values)2024-02-28 p12 1% (1 of 150 values)2024-04-25 p25 1% (1 of 150 values)2024-06-11 p38 1% (1 of 150 values)2024-07-26 p50 0% (0 of 150 values)2024-08-28 p62 1% (2 of 150 values)2024-09-22 p75 1% (2 of 150 values)2024-11-14 p88 1% (1 of 150 values)2024-12-29 p100 1% (1 of 150 values)
status
column tally: 4 distinct, 146 duplicate, 0 missing of 150 entriesdistinct 3% (4 of 150 entries) (0 appearing once)duplicate 97% (146 of 150 entries)
value proportions of 150 values across 4 distinct valuescompleted 50% (75 of 150 values)refunded 22% (33 of 150 values)pending 20% (30 of 150 values)failed 8% (12 of 150 values)
discount_pct
column tally: 7 distinct, 143 duplicate, 0 missing of 150 entriesdistinct 5% (7 of 150 entries) (0 appearing once)duplicate 95% (143 of 150 entries)
pavement sparkline of 150 values0 to 5 0% (0 of 150 values)5 to 10 0% (0 of 150 values)10 to 15 0% (0 of 150 values)15 to 20 0% (0 of 150 values)20 to 25 0% (0 of 150 values)25 to 30 0% (0 of 150 values)0 p0 to p54 55% (82 of 150 values)5 p55 to p62 8% (12 of 150 values)10 p63 to p68 5% (8 of 150 values)15 p68 to p76 8% (12 of 150 values)20 p77 to p83 7% (11 of 150 values)25 p84 to p93 9% (14 of 150 values)30 p93 to p100 7% (11 of 150 values)
notes
column tally: 6 distinct, 23 duplicate, 121 missing of 150 entriesdistinct 4% (6 of 150 entries) (0 appearing once)duplicate 15% (23 of 150 entries)missing 81% (121 of 150 entries)
value proportions of 29 values across 6 distinct valuesRush delivery 31% (9 of 29 values)Fragile items 24% (7 of 29 values)VIP customer 17% (5 of 29 values)Gift wrap requested 10% (3 of 29 values)Corporate account 10% (3 of 29 values)Return requested 7% (2 of 29 values)
1000110Pen Set 12pkOffice38.0232024-10-27pending0.00
1000217Mechanical KeyboardElectronics31.1122024-01-11pending0.00
100039Laptop ProElectronics6.4762024-12-10completed0.00
1000416Stapler Heavy-DutyOffice23.5842024-05-17refunded5.00
1000548Noise-Cancelling HeadphonesElectronics60.0522024-10-22completed15.00
100063627-inch MonitorElectronics52.6242024-01-21completed10.00VIP customer
100073527-inch MonitorElectronics13.2922024-03-30refunded0.00
1000817Wireless MouseElectronics18.0912024-08-28completed15.00
1000948Stapler Heavy-DutyOffice22.0112024-09-22completed0.00
1001038Mechanical KeyboardElectronics52.1762024-11-29pending10.00Fragile items
1001128Pen Set 12pkOffice52.2312024-08-14failed0.00
1001238Stapler Heavy-DutyOffice25.8522024-05-22completed20.00
1001326Monitor ArmFurniture4.2832024-04-02completed15.00
1001424Desk Lamp LEDOffice57.2522024-10-26pending15.00
1001515Mechanical KeyboardElectronics90.1232024-08-11refunded20.00
100169Notebook A5Office104.6012024-11-21completed10.00
1001733Webcam HDElectronics32.3822024-09-08refunded10.00VIP customer
1001832Laptop ProElectronics46.7412024-02-16completed30.00
100196Laptop ProElectronics25.3022024-08-28completed20.00
1002049Mechanical KeyboardElectronics22.3112024-06-27refunded25.00
10021427-inch MonitorElectronics34.6512024-07-28pending0.00Rush delivery
10022827-inch MonitorElectronics35.6012024-06-19completed5.00
1002310Desk Lamp LEDOffice76.1622024-06-13completed0.00
1002441Notebook A5Office135.4252024-12-09refunded0.00
1002511Laptop ProElectronics37.0722024-02-23refunded0.00
1002644Desk Lamp LEDOffice37.7522024-03-23failed15.00
100272827-inch MonitorElectronics12.2512024-06-17pending30.00
1002839Stapler Heavy-DutyOffice23.4012024-07-29pending5.00VIP customer
100295Pen Set 12pkOffice7.9322024-12-21completed20.00
1003025Stapler Heavy-DutyOffice14.4822024-09-10pending0.00Gift wrap requested
1003125Desk Lamp LEDOffice48.4512024-05-27completed25.00
1003239Webcam HDElectronics10.1022024-12-05completed0.00
100333027-inch MonitorElectronics33.4332024-07-24refunded30.00
1003434External SSD 1TBElectronics26.5122024-10-08refunded0.00
1003517Notebook A5Office20.2712024-01-19completed30.00
1003636Noise-Cancelling HeadphonesElectronics27.5012024-08-20completed0.00
100371Ergonomic ChairFurniture81.0222024-02-15refunded0.00
1003844Standing Desk ConverterFurniture55.5512024-06-10completed0.00
1003947Laptop ProElectronics67.0632024-05-09completed15.00Rush delivery
100408Ergonomic ChairFurniture17.1412024-06-14completed5.00
1004144Ergonomic ChairFurniture18.1022024-02-29failed0.00
1004235Wireless MouseElectronics190.4712024-07-25refunded10.00
1004349Stapler Heavy-DutyOffice33.4582024-09-20refunded0.00
1004418Webcam HDElectronics97.5122024-01-01completed0.00
1004550USB-C HubElectronics12.9512024-12-02pending30.00
1004642Noise-Cancelling HeadphonesElectronics14.4122024-10-04completed20.00
1004722Wireless MouseElectronics62.9812024-08-24refunded30.00Rush delivery
10048827-inch MonitorElectronics45.0612024-07-30completed0.00
1004919Ergonomic ChairFurniture12.0732024-01-28completed0.00
1005028USB-C HubElectronics37.5812024-04-06completed0.00
1005111Mechanical KeyboardElectronics12.3132024-09-22completed0.00
1005230Mechanical KeyboardElectronics12.3972024-07-04failed0.00
100531Webcam HDElectronics70.1232024-11-14completed5.00
1005447Mechanical KeyboardElectronics20.9812024-09-12completed10.00
1005547USB-C HubElectronics21.5132024-11-16completed0.00
1005617Standing Desk ConverterFurniture54.6012024-08-14completed15.00
1005733USB-C HubElectronics28.6022024-01-27completed0.00
1005849Notebook A5Office22.9442024-04-14completed25.00
1005912Noise-Cancelling HeadphonesElectronics50.8622024-05-16completed30.00
1006033Ergonomic ChairFurniture6.9282024-10-08pending0.00Corporate account
100617Laptop ProElectronics28.0042024-03-08completed0.00
1006241Stapler Heavy-DutyOffice31.4912024-05-27pending0.00Rush delivery
1006320External SSD 1TBElectronics80.0812024-08-12refunded0.00
1006441Desk Lamp LEDOffice10.8212024-12-23failed20.00
1006533Mechanical KeyboardElectronics27.3032024-09-05completed0.00
1006639Monitor ArmFurniture21.8412024-03-03completed0.00
1006713Webcam HDElectronics160.1212024-01-15completed5.00
1006810Mechanical KeyboardElectronics26.0912024-11-18completed0.00
1006924Desk Lamp LEDOffice66.7112024-11-07pending0.00
1007049Noise-Cancelling HeadphonesElectronics12.2862024-05-02completed25.00
1007111Standing Desk ConverterFurniture27.5832024-12-29pending0.00
1007235Pen Set 12pkOffice126.8932024-03-22refunded25.00Gift wrap requested
1007350Notebook A5Office15.9412024-06-08completed0.00VIP customer
1007434Monitor ArmFurniture54.7112024-10-09pending0.00
100751Standing Desk ConverterFurniture34.1012024-01-08pending15.00
1007639USB-C HubElectronics15.0622024-10-09completed25.00
1007721Notebook A5Office36.3212024-07-27completed0.00
100783227-inch MonitorElectronics47.6872024-02-17pending10.00
100792Stapler Heavy-DutyOffice50.0112024-04-25refunded25.00
100808Mechanical KeyboardElectronics38.8552024-02-28completed0.00
1008124Laptop ProElectronics63.9412024-08-24pending0.00
1008220Pen Set 12pkOffice5.1712024-03-01completed5.00Fragile items
100831627-inch MonitorElectronics41.1022024-11-27refunded0.00
100844Ergonomic ChairFurniture25.8922024-03-19completed0.00
1008516Noise-Cancelling HeadphonesElectronics35.6732024-09-12failed25.00
1008637Mechanical KeyboardElectronics44.9012024-05-29pending0.00
100876Standing Desk ConverterFurniture59.7842024-09-17completed0.00
10088627-inch MonitorElectronics19.5462024-12-27refunded0.00
1008947Standing Desk ConverterFurniture54.2412024-05-19pending25.00Corporate account
1009032Mechanical KeyboardElectronics64.0512024-07-31completed0.00
100915Webcam HDElectronics19.3522024-09-04completed0.00Fragile items
1009249Noise-Cancelling HeadphonesElectronics47.8822024-08-29pending0.00Gift wrap requested
1009335External SSD 1TBElectronics25.4022024-05-04completed0.00
1009450Pen Set 12pkOffice7.0422024-08-21pending20.00
100959Standing Desk ConverterFurniture4.6242024-10-09completed0.00
100969USB-C HubElectronics54.7212024-03-15refunded5.00
1009743Wireless MouseElectronics86.0252024-07-15completed30.00Rush delivery
1009831USB-C HubElectronics18.1812024-04-07refunded0.00
1009936USB-C HubElectronics29.8622024-11-02completed0.00Return requested
101001127-inch MonitorElectronics37.2822024-09-17pending5.00
1010117Pen Set 12pkOffice62.0822024-03-10completed20.00
1010234Noise-Cancelling HeadphonesElectronics11.2512024-02-05completed0.00
1010339Stapler Heavy-DutyOffice30.3272024-05-21completed0.00
1010428Monitor ArmFurniture81.6312024-07-31pending20.00Fragile items
1010514Pen Set 12pkOffice286.5242024-06-23completed0.00
1010635Pen Set 12pkOffice8.3832024-09-16completed0.00
1010749Mechanical KeyboardElectronics32.2112024-05-16completed5.00Fragile items
1010847Notebook A5Office24.8312024-01-02pending0.00
1010945Pen Set 12pkOffice19.1312024-05-24completed25.00
1011013Wireless MouseElectronics15.2322024-06-01pending0.00
1011146Desk Lamp LEDOffice18.0612024-10-27completed0.00
1011220Stapler Heavy-DutyOffice27.8122024-10-23refunded25.00VIP customer
101132627-inch MonitorElectronics31.5032024-12-03completed0.00
1011443Wireless MouseElectronics69.9922024-09-07completed0.00
1011542External SSD 1TBElectronics40.3912024-03-17refunded0.00
1011624Webcam HDElectronics78.7512024-08-16completed5.00
1011729Noise-Cancelling HeadphonesElectronics8.2212024-10-02completed30.00
1011834Monitor ArmFurniture89.8252024-09-04completed25.00Rush delivery
1011929Pen Set 12pkOffice165.5112024-06-25pending10.00
101208Stapler Heavy-DutyOffice96.2412024-06-19refunded0.00Rush delivery
1012116Desk Lamp LEDOffice18.0712024-10-09failed20.00
101221527-inch MonitorElectronics20.8942024-10-05refunded0.00
101235Pen Set 12pkOffice145.9822024-07-12completed0.00
1012422USB-C HubElectronics130.1242024-08-21pending0.00
101252Standing Desk ConverterFurniture42.2812024-06-13refunded0.00Rush delivery
1012638Ergonomic ChairFurniture15.8712024-04-06pending0.00
1012736Ergonomic ChairFurniture18.3512024-12-23completed15.00Fragile items
1012815Laptop ProElectronics21.4412024-05-02failed30.00
101293827-inch MonitorElectronics5.1912024-10-19failed5.00
1013015Standing Desk ConverterFurniture17.2512024-07-15completed0.00
101311Laptop ProElectronics28.1512024-04-29pending0.00Return requested
101325Ergonomic ChairFurniture22.0642024-07-29failed0.00
1013346USB-C HubElectronics113.2422024-01-23completed15.00Corporate account
1013441Webcam HDElectronics16.7542024-06-11completed25.00Rush delivery
101354Noise-Cancelling HeadphonesElectronics31.0562024-08-30refunded0.00
1013615Mechanical KeyboardElectronics20.9822024-12-27completed25.00
10137527-inch MonitorElectronics52.2422024-07-14pending0.00
101383Monitor ArmFurniture17.8912024-07-16completed0.00
1013922Notebook A5Office132.6322024-12-05refunded0.00
101405Monitor ArmFurniture81.1612024-11-29failed20.00
1014133Stapler Heavy-DutyOffice69.8322024-03-18refunded30.00
1014216USB-C HubElectronics10.3222024-09-10failed0.00
101431827-inch MonitorElectronics13.9822024-01-19refunded0.00
1014443Pen Set 12pkOffice36.3952024-03-05refunded0.00
1014532External SSD 1TBElectronics37.8232024-09-14completed0.00
1014614Webcam HDElectronics10.4522024-10-29refunded0.00
1014735Monitor ArmFurniture32.3412024-06-18completed0.00Fragile items
101489Monitor ArmFurniture5.7912024-02-21refunded0.00
1014947Pen Set 12pkOffice31.0232024-08-13refunded15.00
1015037External SSD 1TBElectronics13.0752024-02-21completed15.00

150 rows · 10 columns — discount_pct is 58 % zeros (frequency rug) · notes is 75 % missing