\n", " | Quantity | \n", "UnitPrice | \n", "CustomerID | \n", "
---|---|---|---|
count | \n", "541909.000000 | \n", "541909.000000 | \n", "406829.000000 | \n", "
mean | \n", "9.552250 | \n", "4.611114 | \n", "15287.690570 | \n", "
std | \n", "218.081158 | \n", "96.759853 | \n", "1713.600303 | \n", "
min | \n", "-80995.000000 | \n", "-11062.060000 | \n", "12346.000000 | \n", "
25% | \n", "1.000000 | \n", "1.250000 | \n", "13953.000000 | \n", "
50% | \n", "3.000000 | \n", "2.080000 | \n", "15152.000000 | \n", "
75% | \n", "10.000000 | \n", "4.130000 | \n", "16791.000000 | \n", "
max | \n", "80995.000000 | \n", "38970.000000 | \n", "18287.000000 | \n", "
\n", " | InvoiceNo | \n", "StockCode | \n", "Description | \n", "Quantity | \n", "InvoiceDate | \n", "UnitPrice | \n", "CustomerID | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "536365 | \n", "85123A | \n", "WHITE HANGING HEART T-LIGHT HOLDER | \n", "6 | \n", "11/29/2018 08:26 | \n", "2.55 | \n", "17850.0 | \n", "
1 | \n", "536365 | \n", "71053 | \n", "WHITE METAL LANTERN | \n", "6 | \n", "11/29/2018 08:26 | \n", "3.39 | \n", "17850.0 | \n", "
2 | \n", "536365 | \n", "84406B | \n", "CREAM CUPID HEARTS COAT HANGER | \n", "8 | \n", "11/29/2018 08:26 | \n", "2.75 | \n", "17850.0 | \n", "
3 | \n", "536365 | \n", "84029G | \n", "KNITTED UNION FLAG HOT WATER BOTTLE | \n", "6 | \n", "11/29/2018 08:26 | \n", "3.39 | \n", "17850.0 | \n", "
4 | \n", "536365 | \n", "84029E | \n", "RED WOOLLY HOTTIE WHITE HEART. | \n", "6 | \n", "11/29/2018 08:26 | \n", "3.39 | \n", "17850.0 | \n", "
\n", " | InvoiceNo | \n", "StockCode | \n", "Description | \n", "Quantity | \n", "InvoiceDate | \n", "UnitPrice | \n", "CustomerID | \n", "
---|---|---|---|---|---|---|---|
541904 | \n", "581587 | \n", "22613 | \n", "PACK OF 20 SPACEBOY NAPKINS | \n", "12 | \n", "12/07/2019 12:50 | \n", "0.85 | \n", "12680.0 | \n", "
541905 | \n", "581587 | \n", "22899 | \n", "CHILDREN'S APRON DOLLY GIRL | \n", "6 | \n", "12/07/2019 12:50 | \n", "2.10 | \n", "12680.0 | \n", "
541906 | \n", "581587 | \n", "23254 | \n", "CHILDRENS CUTLERY DOLLY GIRL | \n", "4 | \n", "12/07/2019 12:50 | \n", "4.15 | \n", "12680.0 | \n", "
541907 | \n", "581587 | \n", "23255 | \n", "CHILDRENS CUTLERY CIRCUS PARADE | \n", "4 | \n", "12/07/2019 12:50 | \n", "4.15 | \n", "12680.0 | \n", "
541908 | \n", "581587 | \n", "22138 | \n", "BAKING SET 9 PIECE RETROSPOT | \n", "3 | \n", "12/07/2019 12:50 | \n", "4.95 | \n", "12680.0 | \n", "
\n", " | InvoiceNo | \n", "StockCode | \n", "Description | \n", "Quantity | \n", "InvoiceDate | \n", "UnitPrice | \n", "CustomerID | \n", "
---|---|---|---|---|---|---|---|
181401 | \n", "552468 | \n", "21136 | \n", "PAINTED METAL PEARS ASSORTED | \n", "8 | \n", "05/07/2019 15:33 | \n", "1.69 | \n", "13141.0 | \n", "
134500 | \n", "547850 | \n", "22284 | \n", "HEN HOUSE DECORATION | \n", "1 | \n", "03/25/2019 12:06 | \n", "1.65 | \n", "14472.0 | \n", "
479735 | \n", "577175 | \n", "22899 | \n", "CHILDREN'S APRON DOLLY GIRL | \n", "6 | \n", "11/16/2019 10:58 | \n", "2.10 | \n", "14849.0 | \n", "
104591 | \n", "545188 | \n", "22554 | \n", "PLASTERS IN TIN WOODLAND ANIMALS | \n", "3 | \n", "02/26/2019 15:19 | \n", "1.65 | \n", "14056.0 | \n", "
444255 | \n", "574722 | \n", "85071A | \n", "BLUE CHARLIE+LOLA PERSONAL DOORSIGN | \n", "4 | \n", "11/04/2019 14:45 | \n", "0.39 | \n", "14502.0 | \n", "
33857 | \n", "539300 | \n", "22629 | \n", "SPACEBOY LUNCH BOX | \n", "1 | \n", "12/14/2018 17:31 | \n", "1.95 | \n", "NaN | \n", "
504418 | \n", "578949 | \n", "22300 | \n", "COFFEE MUG DOG + BALL DESIGN | \n", "6 | \n", "11/25/2019 14:30 | \n", "2.55 | \n", "14954.0 | \n", "
85499 | \n", "543474 | \n", "22470 | \n", "HEART OF WICKER LARGE | \n", "3 | \n", "02/06/2019 15:09 | \n", "2.95 | \n", "14415.0 | \n", "
178184 | \n", "552229 | \n", "20731 | \n", "POSY CANDY BAG | \n", "1 | \n", "05/04/2019 15:40 | \n", "0.83 | \n", "NaN | \n", "
335253 | \n", "566281 | \n", "22297 | \n", "HEART IVORY TRELLIS SMALL | \n", "24 | \n", "09/09/2019 14:15 | \n", "1.25 | \n", "12748.0 | \n", "
176220 | \n", "551997 | \n", "22970 | \n", "LONDON BUS COFFEE MUG | \n", "2 | \n", "05/03/2019 15:47 | \n", "4.96 | \n", "NaN | \n", "
453261 | \n", "575477 | \n", "23522 | \n", "WALL ART DOG AND BALL | \n", "2 | \n", "11/07/2019 16:14 | \n", "5.79 | \n", "NaN | \n", "
200014 | \n", "554110 | \n", "82482 | \n", "WOODEN PICTURE FRAME WHITE FINISH | \n", "6 | \n", "05/20/2019 14:35 | \n", "2.55 | \n", "13468.0 | \n", "
63782 | \n", "541592 | \n", "85173 | \n", "SET/6 FROG PRINCE T-LIGHT CANDLES | \n", "1 | \n", "01/17/2019 15:08 | \n", "2.46 | \n", "NaN | \n", "
111502 | \n", "545721 | \n", "21033 | \n", "JUMBO BAG CHARLIE AND LOLA TOYS | \n", "10 | \n", "03/05/2019 10:52 | \n", "2.95 | \n", "15039.0 | \n", "
238078 | \n", "557896 | \n", "22175 | \n", "PINK OWL SOFT TOY | \n", "1 | \n", "06/21/2019 14:22 | \n", "2.95 | \n", "17611.0 | \n", "
248548 | \n", "558861 | \n", "23052 | \n", "RECYCLED ACAPULCO MAT TURQUOISE | \n", "4 | \n", "07/02/2019 12:19 | \n", "8.25 | \n", "13373.0 | \n", "
476807 | \n", "577034 | \n", "21070 | \n", "VINTAGE BILLBOARD MUG | \n", "36 | \n", "11/15/2019 13:16 | \n", "1.06 | \n", "12847.0 | \n", "
26521 | \n", "538515 | \n", "22550 | \n", "HOLIDAY FUN LUDO | \n", "36 | \n", "12/10/2018 14:43 | \n", "3.39 | \n", "17937.0 | \n", "
313529 | \n", "564510 | \n", "85019B | \n", "BLOSSOM IMAGES NOTEBOOK SET | \n", "24 | \n", "08/23/2019 14:42 | \n", "1.25 | \n", "14194.0 | \n", "
24054 | \n", "538312 | \n", "22576 | \n", "SWALLOW WOODEN CHRISTMAS DECORATION | \n", "3 | \n", "12/08/2018 13:48 | \n", "0.85 | \n", "16727.0 | \n", "
77147 | \n", "542711 | \n", "21485 | \n", "RETROSPOT HEART HOT WATER BOTTLE | \n", "1 | \n", "01/29/2019 13:19 | \n", "4.95 | \n", "17894.0 | \n", "
350402 | \n", "567634 | \n", "22569 | \n", "FELTCRAFT CUSHION BUTTERFLY | \n", "48 | \n", "09/19/2019 13:35 | \n", "3.39 | \n", "12939.0 | \n", "
234166 | \n", "557502 | \n", "20979 | \n", "36 PENCILS TUBE RED RETROSPOT | \n", "1 | \n", "06/18/2019 15:32 | \n", "2.46 | \n", "NaN | \n", "
393211 | \n", "570807 | \n", "22993 | \n", "SET OF 4 PANTRY JELLY MOULDS | \n", "12 | \n", "10/10/2019 12:44 | \n", "1.25 | \n", "13704.0 | \n", "
300672 | \n", "563209 | \n", "23228 | \n", "FILIGREE HEART BIRD WHITE | \n", "6 | \n", "08/12/2019 12:23 | \n", "1.25 | \n", "13527.0 | \n", "
73068 | \n", "542278 | \n", "84688 | \n", "BEACH HUT DESIGN BLACKBOARD | \n", "6 | \n", "01/25/2019 10:43 | \n", "4.25 | \n", "14911.0 | \n", "
432999 | \n", "573902 | \n", "23409 | \n", "PHOTO FRAME LINEN AND LACE LARGE | \n", "6 | \n", "10/30/2019 14:51 | \n", "3.75 | \n", "17428.0 | \n", "
313205 | \n", "564473 | \n", "21495 | \n", "SKULLS AND CROSSBONES WRAP | \n", "25 | \n", "08/23/2019 12:33 | \n", "0.42 | \n", "16722.0 | \n", "
161396 | \n", "550474 | \n", "16235 | \n", "RECYCLED PENCIL WITH RABBIT ERASER | \n", "2 | \n", "04/16/2019 13:58 | \n", "0.42 | \n", "NaN | \n", "
240463 | \n", "558102 | \n", "23239 | \n", "SET OF 4 KNICK KNACK TINS POPPIES | \n", "1 | \n", "06/24/2019 14:06 | \n", "4.15 | \n", "17372.0 | \n", "
328638 | \n", "565796 | \n", "23200 | \n", "JUMBO BAG PEARS | \n", "10 | \n", "09/05/2019 10:07 | \n", "2.08 | \n", "14916.0 | \n", "
129783 | \n", "547390 | \n", "37448 | \n", "CERAMIC CAKE DESIGN SPOTTED MUG | \n", "12 | \n", "03/20/2019 16:08 | \n", "1.49 | \n", "12352.0 | \n", "
509367 | \n", "579297 | \n", "85123a | \n", "WHITE HANGING HEART T-LIGHT HOLDER | \n", "1 | \n", "11/27/2019 11:23 | \n", "6.63 | \n", "NaN | \n", "
407579 | \n", "C571896 | \n", "22494 | \n", "EMERGENCY FIRST AID TIN | \n", "-2 | \n", "10/17/2019 14:18 | \n", "1.25 | \n", "16533.0 | \n", "
252285 | \n", "559107 | \n", "23091 | \n", "ZINC HERB GARDEN CONTAINER | \n", "1 | \n", "07/04/2019 11:22 | \n", "6.25 | \n", "15334.0 | \n", "
225804 | \n", "556733 | \n", "21564 | \n", "PINK HEART SHAPE LOVE BUCKET | \n", "1 | \n", "06/12/2019 11:53 | \n", "2.95 | \n", "16919.0 | \n", "
42440 | \n", "539988 | \n", "21354 | \n", "TOAST ITS - BEST MUM | \n", "2 | \n", "12/21/2018 16:06 | \n", "1.25 | \n", "18116.0 | \n", "
55036 | \n", "540977 | \n", "72801C | \n", "4 ROSE PINK DINNER CANDLES | \n", "1 | \n", "01/10/2019 15:01 | \n", "2.51 | \n", "NaN | \n", "
506725 | \n", "579152 | \n", "22734 | \n", "SET OF 6 RIBBONS VINTAGE CHRISTMAS | \n", "6 | \n", "11/26/2019 13:26 | \n", "2.89 | \n", "12479.0 | \n", "
88392 | \n", "543802 | \n", "22379 | \n", "RECYCLING BAG RETROSPOT | \n", "1 | \n", "02/11/2019 12:03 | \n", "2.10 | \n", "13742.0 | \n", "
111153 | \n", "545713 | \n", "85049g | \n", "CHOCOLATE BOX RIBBONS | \n", "1 | \n", "03/05/2019 10:12 | \n", "2.46 | \n", "NaN | \n", "
456092 | \n", "C575669 | \n", "23462 | \n", "ROCOCO WALL MIRROR WHITE | \n", "-1 | \n", "11/08/2019 15:00 | \n", "19.95 | \n", "12417.0 | \n", "
535119 | \n", "581188 | \n", "23295 | \n", "SET OF 12 MINI LOAF BAKING CASES | \n", "8 | \n", "12/05/2019 16:47 | \n", "0.83 | \n", "17735.0 | \n", "
265599 | \n", "560225 | \n", "22322 | \n", "BIRD DECORATION GREEN POLKADOT | \n", "5 | \n", "07/13/2019 16:27 | \n", "0.83 | \n", "NaN | \n", "
192691 | \n", "553464 | \n", "20725 | \n", "LUNCH BAG RED RETROSPOT | \n", "50 | \n", "05/15/2019 11:07 | \n", "1.65 | \n", "16218.0 | \n", "
23307 | \n", "538197 | \n", "22746 | \n", "POPPY'S PLAYHOUSE LIVINGROOM | \n", "3 | \n", "12/08/2018 10:56 | \n", "2.10 | \n", "14419.0 | \n", "
48614 | \n", "540469 | \n", "22966 | \n", "GINGERBREAD MAN COOKIE CUTTER | \n", "3 | \n", "01/05/2019 14:04 | \n", "1.25 | \n", "12484.0 | \n", "
416153 | \n", "572552 | \n", "21770 | \n", "OPEN CLOSED METAL SIGN | \n", "1 | \n", "10/22/2019 17:07 | \n", "9.96 | \n", "14096.0 | \n", "
450594 | \n", "575176 | \n", "23377 | \n", "PACK OF 12 DOLLY GIRL TISSUES | \n", "1 | \n", "11/06/2019 18:29 | \n", "0.83 | \n", "NaN | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
74614 | \n", "542504 | \n", "37413 | \n", "NaN | \n", "5568 | \n", "01/26/2019 12:03 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
220843 | \n", "556231 | \n", "85123A | \n", "? | \n", "4000 | \n", "06/07/2019 15:04 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
263885 | \n", "560040 | \n", "23343 | \n", "came coded as 20713 | \n", "3100 | \n", "07/12/2019 14:28 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
115807 | \n", "546139 | \n", "84988 | \n", "? | \n", "3000 | \n", "03/07/2019 16:35 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
74615 | \n", "542505 | \n", "79063D | \n", "NaN | \n", "2560 | \n", "01/26/2019 12:04 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
447035 | \n", "574941 | \n", "22197 | \n", "POPCORN HOLDER | \n", "1820 | \n", "11/05/2019 17:42 | \n", "1.95 | \n", "NaN | \n", "3549.0 | \n", "
160541 | \n", "550460 | \n", "47556B | \n", "did a credit and did not tick ret | \n", "1300 | \n", "04/16/2019 13:18 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
203751 | \n", "554550 | \n", "47566B | \n", "incorrectly credited C550456 see 47 | \n", "1300 | \n", "05/23/2019 09:57 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
82795 | \n", "543258 | \n", "84611B | \n", "NaN | \n", "1287 | \n", "02/02/2019 16:06 | \n", "0.00 | \n", "NaN | \n", "0.0 | \n", "
467796 | \n", "576365 | \n", "22197 | \n", "POPCORN HOLDER | \n", "1130 | \n", "11/12/2019 17:55 | \n", "1.95 | \n", "NaN | \n", "2203.5 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
375429 | \n", "569466 | \n", "23270 | \n", "incorrect stock entry. | \n", "-2880 | \n", "10/02/2019 11:42 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
113580 | \n", "545990 | \n", "84598 | \n", "check | \n", "-3000 | \n", "03/06/2019 13:07 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
263884 | \n", "560039 | \n", "20713 | \n", "wrongly marked. 23343 in box | \n", "-3100 | \n", "07/12/2019 14:27 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
323458 | \n", "565304 | \n", "16259 | \n", "NaN | \n", "-3167 | \n", "08/31/2019 12:18 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
341601 | \n", "566768 | \n", "16045 | \n", "NaN | \n", "-3667 | \n", "09/12/2019 17:53 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
431381 | \n", "573596 | \n", "79323W | \n", "Unsaleable, destroyed. | \n", "-4830 | \n", "10/29/2019 15:17 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
115818 | \n", "546152 | \n", "72140F | \n", "throw away | \n", "-5368 | \n", "03/07/2019 17:25 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
225528 | \n", "556687 | \n", "23003 | \n", "Printing smudges/thrown away | \n", "-9058 | \n", "06/12/2019 10:36 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
225529 | \n", "556690 | \n", "23005 | \n", "printing smudges/thrown away | \n", "-9600 | \n", "06/12/2019 10:37 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
225530 | \n", "556691 | \n", "23005 | \n", "printing smudges/thrown away | \n", "-9600 | \n", "06/12/2019 10:37 | \n", "0.0 | \n", "NaN | \n", "-0.0 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
87670 | \n", "543713 | \n", "21556 | \n", "CERAMIC STRAWBERRY MONEY BOX | \n", "2 | \n", "02/09/2019 11:46 | \n", "4.13 | \n", "NaN | \n", "8.26 | \n", "
501978 | \n", "578833 | \n", "23162 | \n", "REGENCY TEA STRAINER | \n", "1 | \n", "11/23/2019 15:23 | \n", "7.46 | \n", "NaN | \n", "7.46 | \n", "
143010 | \n", "548663 | \n", "21930 | \n", "JUMBO STORAGE BAG SKULLS | \n", "2 | \n", "03/30/2019 14:44 | \n", "4.96 | \n", "NaN | \n", "9.92 | \n", "
15924 | \n", "537642 | \n", "22357 | \n", "KINGS CHOICE BISCUIT TIN | \n", "1 | \n", "12/05/2018 15:33 | \n", "8.47 | \n", "NaN | \n", "8.47 | \n", "
295962 | \n", "562843 | \n", "90114 | \n", "SUMMER DAISIES BAG CHARM | \n", "1 | \n", "08/07/2019 17:37 | \n", "2.46 | \n", "NaN | \n", "2.46 | \n", "
355335 | \n", "567921 | \n", "21089 | \n", "damaged | \n", "-7 | \n", "09/20/2019 17:24 | \n", "0.00 | \n", "NaN | \n", "-0.00 | \n", "
138222 | \n", "548191 | \n", "85049D | \n", "BRIGHT BLUES RIBBONS | \n", "2 | \n", "03/27/2019 15:20 | \n", "2.46 | \n", "NaN | \n", "4.92 | \n", "
157759 | \n", "550211 | \n", "82599 | \n", "FANNY'S REST STOPMETAL SIGN | \n", "1 | \n", "04/13/2019 10:41 | \n", "4.13 | \n", "NaN | \n", "4.13 | \n", "
481153 | \n", "C577343 | \n", "BANK CHARGES | \n", "Bank Charges | \n", "-1 | \n", "11/16/2019 15:13 | \n", "27.21 | \n", "NaN | \n", "-27.21 | \n", "
80041 | \n", "543013 | \n", "20724 | \n", "RED RETROSPOT CHARLOTTE BAG | \n", "1 | \n", "01/31/2019 13:35 | \n", "1.63 | \n", "NaN | \n", "1.63 | \n", "
\n", " | index | \n", "invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "622 | \n", "536414 | \n", "22139 | \n", "NaN | \n", "56 | \n", "11/29/2018 11:52 | \n", "0.00 | \n", "NaN | \n", "0.00 | \n", "
1 | \n", "1443 | \n", "536544 | \n", "21773 | \n", "DECORATIVE ROSE BATHROOM BOTTLE | \n", "1 | \n", "11/29/2018 14:32 | \n", "2.51 | \n", "NaN | \n", "2.51 | \n", "
2 | \n", "1444 | \n", "536544 | \n", "21774 | \n", "DECORATIVE CATS BATHROOM BOTTLE | \n", "2 | \n", "11/29/2018 14:32 | \n", "2.51 | \n", "NaN | \n", "5.02 | \n", "
3 | \n", "1445 | \n", "536544 | \n", "21786 | \n", "POLKADOT RAIN HAT | \n", "4 | \n", "11/29/2018 14:32 | \n", "0.85 | \n", "NaN | \n", "3.40 | \n", "
4 | \n", "1446 | \n", "536544 | \n", "21787 | \n", "RAIN PONCHO RETROSPOT | \n", "2 | \n", "11/29/2018 14:32 | \n", "1.66 | \n", "NaN | \n", "3.32 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
378614 | \n", "569653 | \n", "20717 | \n", "STRAWBERRY SHOPPER BAG | \n", "20 | \n", "2019-10-03 12:52:00 | \n", "1.25 | \n", "12451 | \n", "25.00 | \n", "
414085 | \n", "572336 | \n", "22738 | \n", "RIBBON REEL SNOWY VILLAGE | \n", "10 | \n", "2019-10-22 10:29:00 | \n", "1.65 | \n", "13523 | \n", "16.50 | \n", "
402584 | \n", "571505 | \n", "23197 | \n", "SKETCHBOOK MAGNETIC SHOPPING LIST | \n", "24 | \n", "2019-10-15 15:19:00 | \n", "1.45 | \n", "17244 | \n", "34.80 | \n", "
143393 | \n", "548699 | \n", "22479 | \n", "DAISY GARDEN MARKER | \n", "3 | \n", "2019-04-01 11:08:00 | \n", "1.25 | \n", "0 | \n", "3.75 | \n", "
31227 | \n", "538907 | \n", "22835 | \n", "HOT WATER BOTTLE I AM SO POORLY | \n", "4 | \n", "2018-12-13 10:40:00 | \n", "4.65 | \n", "15373 | \n", "18.60 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
540422 | \n", "C581484 | \n", "23843 | \n", "PAPER CRAFT , LITTLE BIRDIE | \n", "-80995 | \n", "2019-12-07 09:27:00 | \n", "2.08 | \n", "16446 | \n", "-168469.6 | \n", "
61624 | \n", "C541433 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "-74215 | \n", "2019-01-16 10:17:00 | \n", "1.04 | \n", "12346 | \n", "-77183.6 | \n", "
225530 | \n", "556691 | \n", "23005 | \n", "printing smudges/thrown away | \n", "-9600 | \n", "2019-06-12 10:37:00 | \n", "0.00 | \n", "0 | \n", "-0.0 | \n", "
225529 | \n", "556690 | \n", "23005 | \n", "printing smudges/thrown away | \n", "-9600 | \n", "2019-06-12 10:37:00 | \n", "0.00 | \n", "0 | \n", "-0.0 | \n", "
4287 | \n", "C536757 | \n", "84347 | \n", "ROTATING SILVER ANGELS T-LIGHT HLDR | \n", "-9360 | \n", "2018-11-30 14:23:00 | \n", "0.03 | \n", "15838 | \n", "-280.8 | \n", "
225528 | \n", "556687 | \n", "23003 | \n", "Printing smudges/thrown away | \n", "-9058 | \n", "2019-06-12 10:36:00 | \n", "0.00 | \n", "0 | \n", "-0.0 | \n", "
115818 | \n", "546152 | \n", "72140F | \n", "throw away | \n", "-5368 | \n", "2019-03-07 17:25:00 | \n", "0.00 | \n", "0 | \n", "-0.0 | \n", "
431381 | \n", "573596 | \n", "79323W | \n", "Unsaleable, destroyed. | \n", "-4830 | \n", "2019-10-29 15:17:00 | \n", "0.00 | \n", "0 | \n", "-0.0 | \n", "
341601 | \n", "566768 | \n", "16045 | \n", "NaN | \n", "-3667 | \n", "2019-09-12 17:53:00 | \n", "0.00 | \n", "0 | \n", "-0.0 | \n", "
323458 | \n", "565304 | \n", "16259 | \n", "NaN | \n", "-3167 | \n", "2019-08-31 12:18:00 | \n", "0.00 | \n", "0 | \n", "-0.0 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
540421 | \n", "581483 | \n", "23843 | \n", "PAPER CRAFT , LITTLE BIRDIE | \n", "80995 | \n", "2019-12-07 09:15:00 | \n", "2.08 | \n", "16446 | \n", "168469.6 | \n", "
540422 | \n", "C581484 | \n", "23843 | \n", "PAPER CRAFT , LITTLE BIRDIE | \n", "-80995 | \n", "2019-12-07 09:27:00 | \n", "2.08 | \n", "16446 | \n", "-168469.6 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
61619 | \n", "541431 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "74215 | \n", "2019-01-16 10:01:00 | \n", "1.04 | \n", "12346 | \n", "77183.60 | \n", "
61624 | \n", "C541433 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "-74215 | \n", "2019-01-16 10:17:00 | \n", "1.04 | \n", "12346 | \n", "-77183.60 | \n", "
186770 | \n", "552882 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "96 | \n", "2019-05-10 10:10:00 | \n", "1.04 | \n", "14646 | \n", "99.84 | \n", "
187196 | \n", "552953 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "4 | \n", "2019-05-10 12:11:00 | \n", "1.25 | \n", "16745 | \n", "5.00 | \n", "
187718 | \n", "553005 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "5 | \n", "2019-05-10 16:29:00 | \n", "1.25 | \n", "14651 | \n", "6.25 | \n", "
187868 | \n", "553009 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "3 | \n", "2019-05-10 16:52:00 | \n", "1.25 | \n", "13601 | \n", "3.75 | \n", "
188644 | \n", "553052 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "48 | \n", "2019-05-11 10:14:00 | \n", "1.04 | \n", "15251 | \n", "49.92 | \n", "
189398 | \n", "553149 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-11 14:16:00 | \n", "1.25 | \n", "14226 | \n", "15.00 | \n", "
189452 | \n", "553152 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-11 14:55:00 | \n", "1.25 | \n", "13089 | \n", "15.00 | \n", "
189591 | \n", "553160 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-11 15:26:00 | \n", "1.25 | \n", "14194 | \n", "15.00 | \n", "
190854 | \n", "553212 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-14 09:42:00 | \n", "1.25 | \n", "15358 | \n", "15.00 | \n", "
191128 | \n", "553339 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "48 | \n", "2019-05-14 12:19:00 | \n", "1.04 | \n", "15125 | \n", "49.92 | \n", "
191165 | \n", "553341 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-14 12:25:00 | \n", "1.25 | \n", "16293 | \n", "15.00 | \n", "
191581 | \n", "553377 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-14 14:58:00 | \n", "1.25 | \n", "14888 | \n", "15.00 | \n", "
192039 | \n", "553389 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "3 | \n", "2019-05-14 16:37:00 | \n", "2.46 | \n", "0 | \n", "7.38 | \n", "
194462 | \n", "553607 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "240 | \n", "2019-05-16 10:47:00 | \n", "1.04 | \n", "16684 | \n", "249.60 | \n", "
194887 | \n", "553678 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-16 13:00:00 | \n", "1.25 | \n", "14009 | \n", "15.00 | \n", "
195455 | \n", "553718 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "1 | \n", "2019-05-16 16:14:00 | \n", "2.46 | \n", "0 | \n", "2.46 | \n", "
195725 | \n", "553739 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-17 09:23:00 | \n", "1.25 | \n", "14895 | \n", "15.00 | \n", "
196707 | \n", "553860 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "2 | \n", "2019-05-17 13:57:00 | \n", "1.25 | \n", "17841 | \n", "2.50 | \n", "
198115 | \n", "554013 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-18 13:13:00 | \n", "1.25 | \n", "13308 | \n", "15.00 | \n", "
198839 | \n", "554070 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "9 | \n", "2019-05-20 11:06:00 | \n", "1.25 | \n", "13555 | \n", "11.25 | \n", "
199427 | \n", "554098 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "6 | \n", "2019-05-20 13:01:00 | \n", "1.25 | \n", "14769 | \n", "7.50 | \n", "
199868 | \n", "554104 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-20 14:03:00 | \n", "1.25 | \n", "12705 | \n", "15.00 | \n", "
201030 | \n", "554261 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "2 | \n", "2019-05-21 12:32:00 | \n", "1.25 | \n", "16033 | \n", "2.50 | \n", "
201099 | \n", "554268 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "1 | \n", "2019-05-21 12:59:00 | \n", "1.25 | \n", "15311 | \n", "1.25 | \n", "
201570 | \n", "554307 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "96 | \n", "2019-05-21 14:59:00 | \n", "1.04 | \n", "12989 | \n", "99.84 | \n", "
202855 | \n", "554504 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "12 | \n", "2019-05-22 15:13:00 | \n", "1.25 | \n", "17719 | \n", "15.00 | \n", "
203207 | \n", "554512 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "4 | \n", "2019-05-22 15:54:00 | \n", "2.46 | \n", "0 | \n", "9.84 | \n", "
203625 | \n", "C554527 | \n", "23166 | \n", "MEDIUM CERAMIC TOP STORAGE JAR | \n", "-9 | \n", "2019-05-22 17:25:00 | \n", "1.04 | \n", "15251 | \n", "-9.36 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
622 | \n", "536414 | \n", "22139 | \n", "NaN | \n", "56 | \n", "2018-11-29 11:52:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
1970 | \n", "536545 | \n", "21134 | \n", "NaN | \n", "1 | \n", "2018-11-29 14:32:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
1971 | \n", "536546 | \n", "22145 | \n", "NaN | \n", "1 | \n", "2018-11-29 14:33:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
1972 | \n", "536547 | \n", "37509 | \n", "NaN | \n", "1 | \n", "2018-11-29 14:33:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
1987 | \n", "536549 | \n", "85226A | \n", "NaN | \n", "1 | \n", "2018-11-29 14:34:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
536981 | \n", "581234 | \n", "72817 | \n", "NaN | \n", "27 | \n", "2019-12-06 10:33:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
538504 | \n", "581406 | \n", "46000M | \n", "POLYESTER FILLER PAD 45x45cm | \n", "240 | \n", "2019-12-06 13:58:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
538505 | \n", "581406 | \n", "46000S | \n", "POLYESTER FILLER PAD 40x40cm | \n", "300 | \n", "2019-12-06 13:58:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
538554 | \n", "581408 | \n", "85175 | \n", "NaN | \n", "20 | \n", "2019-12-06 14:06:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
538919 | \n", "581422 | \n", "23169 | \n", "smashed | \n", "-235 | \n", "2019-12-06 15:24:00 | \n", "0.0 | \n", "0 | \n", "-0.0 | \n", "
2512 rows × 8 columns
\n", "\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
222681 | \n", "C556445 | \n", "M | \n", "Manual | \n", "-1 | \n", "2019-06-08 15:31:00 | \n", "38970.00 | \n", "15098 | \n", "-38970.00 | \n", "
524602 | \n", "C580605 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-12-03 11:36:00 | \n", "17836.46 | \n", "0 | \n", "-17836.46 | \n", "
43702 | \n", "C540117 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-01-03 09:55:00 | \n", "16888.02 | \n", "0 | \n", "-16888.02 | \n", "
43703 | \n", "C540118 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-01-03 09:57:00 | \n", "16453.71 | \n", "0 | \n", "-16453.71 | \n", "
15017 | \n", "537632 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "1 | \n", "2018-12-05 15:08:00 | \n", "13541.33 | \n", "0 | \n", "13541.33 | \n", "
15016 | \n", "C537630 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2018-12-05 15:04:00 | \n", "13541.33 | \n", "0 | \n", "-13541.33 | \n", "
16356 | \n", "C537651 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2018-12-05 15:49:00 | \n", "13541.33 | \n", "0 | \n", "-13541.33 | \n", "
16232 | \n", "C537644 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2018-12-05 15:34:00 | \n", "13474.79 | \n", "0 | \n", "-13474.79 | \n", "
524601 | \n", "C580604 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-12-03 11:35:00 | \n", "11586.50 | \n", "0 | \n", "-11586.50 | \n", "
299982 | \n", "A563185 | \n", "B | \n", "Adjust bad debt | \n", "1 | \n", "2019-08-10 14:50:00 | \n", "11062.06 | \n", "0 | \n", "11062.06 | \n", "
446533 | \n", "C574902 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-11-05 15:21:00 | \n", "8286.22 | \n", "0 | \n", "-8286.22 | \n", "
173277 | \n", "C551685 | \n", "POST | \n", "POSTAGE | \n", "-1 | \n", "2019-05-01 12:51:00 | \n", "8142.75 | \n", "16029 | \n", "-8142.75 | \n", "
173382 | \n", "551697 | \n", "POST | \n", "POSTAGE | \n", "1 | \n", "2019-05-01 13:46:00 | \n", "8142.75 | \n", "16029 | \n", "8142.75 | \n", "
342635 | \n", "C566899 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-09-13 13:53:00 | \n", "7427.97 | \n", "0 | \n", "-7427.97 | \n", "
191386 | \n", "C553355 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-05-14 13:58:00 | \n", "7006.83 | \n", "0 | \n", "-7006.83 | \n", "
173391 | \n", "C551699 | \n", "M | \n", "Manual | \n", "-1 | \n", "2019-05-01 14:12:00 | \n", "6930.00 | \n", "16029 | \n", "-6930.00 | \n", "
287150 | \n", "C562086 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-07-31 12:27:00 | \n", "6721.37 | \n", "0 | \n", "-6721.37 | \n", "
16357 | \n", "C537652 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2018-12-05 15:51:00 | \n", "6706.71 | \n", "0 | \n", "-6706.71 | \n", "
312246 | \n", "C564341 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-08-22 14:53:00 | \n", "6662.51 | \n", "0 | \n", "-6662.51 | \n", "
262414 | \n", "C559917 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-07-11 15:21:00 | \n", "6497.47 | \n", "0 | \n", "-6497.47 | \n", "
383495 | \n", "C570025 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-10-05 10:29:00 | \n", "5942.57 | \n", "0 | \n", "-5942.57 | \n", "
429248 | \n", "C573549 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-10-29 13:23:00 | \n", "5942.57 | \n", "0 | \n", "-5942.57 | \n", "
446434 | \n", "C574897 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-11-05 15:03:00 | \n", "5877.18 | \n", "0 | \n", "-5877.18 | \n", "
191385 | \n", "C553354 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-05-14 13:54:00 | \n", "5876.40 | \n", "0 | \n", "-5876.40 | \n", "
239250 | \n", "C558036 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-06-22 12:31:00 | \n", "5791.18 | \n", "0 | \n", "-5791.18 | \n", "
124741 | \n", "C546987 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-03-16 12:56:00 | \n", "5693.05 | \n", "0 | \n", "-5693.05 | \n", "
96844 | \n", "C544587 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-02-19 15:07:00 | \n", "5575.28 | \n", "0 | \n", "-5575.28 | \n", "
342611 | \n", "C566889 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-09-13 13:50:00 | \n", "5522.14 | \n", "0 | \n", "-5522.14 | \n", "
16313 | \n", "C537647 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2018-12-05 15:41:00 | \n", "5519.25 | \n", "0 | \n", "-5519.25 | \n", "
96845 | \n", "C544589 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "-1 | \n", "2019-02-19 15:11:00 | \n", "5258.77 | \n", "0 | \n", "-5258.77 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
222670 | \n", "556442 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "60 | \n", "2019-06-08 15:22:00 | \n", "4.95 | \n", "15098 | \n", "297.0 | \n", "
222680 | \n", "556444 | \n", "22502 | \n", "PICNIC BASKET WICKER 60 PIECES | \n", "60 | \n", "2019-06-08 15:28:00 | \n", "649.50 | \n", "15098 | \n", "38970.0 | \n", "
222681 | \n", "C556445 | \n", "M | \n", "Manual | \n", "-1 | \n", "2019-06-08 15:31:00 | \n", "38970.00 | \n", "15098 | \n", "-38970.0 | \n", "
222682 | \n", "556446 | \n", "22502 | \n", "PICNIC BASKET WICKER 60 PIECES | \n", "1 | \n", "2019-06-08 15:33:00 | \n", "649.50 | \n", "15098 | \n", "649.5 | \n", "
222692 | \n", "C556448 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "-60 | \n", "2019-06-08 15:39:00 | \n", "4.95 | \n", "15098 | \n", "-297.0 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
622 | \n", "536414 | \n", "22139 | \n", "NaN | \n", "56 | \n", "2018-11-29 11:52:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
282875 | \n", "561663 | \n", "22501 | \n", "incorrectly put back into stock | \n", "-108 | \n", "2019-07-26 16:40:00 | \n", "0.0 | \n", "0 | \n", "-0.0 | \n", "
282882 | \n", "561665 | \n", "22171 | \n", "? | \n", "142 | \n", "2019-07-26 16:55:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
282883 | \n", "561666 | \n", "22502 | \n", "NaN | \n", "30 | \n", "2019-07-26 16:59:00 | \n", "0.0 | \n", "0 | \n", "0.0 | \n", "
282904 | \n", "561668 | \n", "44091A | \n", "NaN | \n", "-2 | \n", "2019-07-26 17:03:00 | \n", "0.0 | \n", "0 | \n", "-0.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
33576 | \n", "539263 | \n", "22580 | \n", "ADVENT CALENDAR GINGHAM SACK | \n", "4 | \n", "2018-12-14 14:36:00 | \n", "0.0 | \n", "16560 | \n", "0.0 | \n", "
279324 | \n", "561284 | \n", "22167 | \n", "OVAL WALL MIRROR DIAMANTE | \n", "1 | \n", "2019-07-24 12:24:00 | \n", "0.0 | \n", "16818 | \n", "0.0 | \n", "
86789 | \n", "543599 | \n", "84535B | \n", "FAIRY CAKES NOTEBOOK A6 SIZE | \n", "16 | \n", "2019-02-08 13:08:00 | \n", "0.0 | \n", "17560 | \n", "0.0 | \n", "
187613 | \n", "553000 | \n", "47566 | \n", "PARTY BUNTING | \n", "4 | \n", "2019-05-10 15:21:00 | \n", "0.0 | \n", "17667 | \n", "0.0 | \n", "
420404 | \n", "572893 | \n", "21208 | \n", "PASTEL COLOUR HONEYCOMB FAN | \n", "5 | \n", "2019-10-24 14:36:00 | \n", "0.0 | \n", "18059 | \n", "0.0 | \n", "
2510 rows × 8 columns
\n", "\n", " | stock_code | \n", "description | \n", "unit_price | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "10002 | \n", "INFLATABLE POLITICAL GLOBE | \n", "0.85 | \n", "824 | \n", "41 | \n", "700.40 | \n", "14.008000 | \n", "
1 | \n", "10002 | \n", "INFLATABLE POLITICAL GLOBE | \n", "1.63 | \n", "9 | \n", "1 | \n", "14.67 | \n", "2.095714 | \n", "
2 | \n", "10002 | \n", "INFLATABLE POLITICAL GLOBE | \n", "1.66 | \n", "27 | \n", "1 | \n", "44.82 | \n", "3.201429 | \n", "
3 | \n", "10080 | \n", "GROOVY CACTUS INFLATABLE | \n", "0.39 | \n", "301 | \n", "19 | \n", "117.39 | \n", "5.590000 | \n", "
4 | \n", "10080 | \n", "GROOVY CACTUS INFLATABLE | \n", "0.85 | \n", "2 | \n", "1 | \n", "1.70 | \n", "1.700000 | \n", "
5 | \n", "10120 | \n", "DOGGY RUBBER | \n", "0.21 | \n", "192 | \n", "25 | \n", "40.32 | \n", "1.390345 | \n", "
6 | \n", "10123C | \n", "HEARTS WRAPPING TAPE | \n", "0.65 | \n", "5 | \n", "3 | \n", "3.25 | \n", "1.083333 | \n", "
7 | \n", "10124A | \n", "SPOTS ON RED BOOKCOVER TAPE | \n", "0.42 | \n", "16 | \n", "5 | \n", "6.72 | \n", "1.344000 | \n", "
8 | \n", "10124G | \n", "ARMY CAMO BOOKCOVER TAPE | \n", "0.42 | \n", "17 | \n", "4 | \n", "7.14 | \n", "1.785000 | \n", "
9 | \n", "10125 | \n", "MINI FUNKY DESIGN TAPES | \n", "0.42 | \n", "260 | \n", "10 | \n", "109.20 | \n", "10.920000 | \n", "
10 | \n", "10125 | \n", "MINI FUNKY DESIGN TAPES | \n", "0.79 | \n", "24 | \n", "1 | \n", "18.96 | \n", "1.580000 | \n", "
11 | \n", "10125 | \n", "MINI FUNKY DESIGN TAPES | \n", "0.81 | \n", "36 | \n", "1 | \n", "29.16 | \n", "2.916000 | \n", "
12 | \n", "10125 | \n", "MINI FUNKY DESIGN TAPES | \n", "0.85 | \n", "965 | \n", "39 | \n", "820.25 | \n", "15.476415 | \n", "
13 | \n", "10125 | \n", "MINI FUNKY DESIGN TAPES | \n", "1.63 | \n", "6 | \n", "1 | \n", "9.78 | \n", "1.956000 | \n", "
14 | \n", "10125 | \n", "MINI FUNKY DESIGN TAPES | \n", "1.66 | \n", "4 | \n", "1 | \n", "6.64 | \n", "2.213333 | \n", "
15 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "0.42 | \n", "2035 | \n", "81 | \n", "854.70 | \n", "9.092553 | \n", "
16 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "0.79 | \n", "58 | \n", "1 | \n", "45.82 | \n", "6.545714 | \n", "
17 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "0.81 | \n", "38 | \n", "1 | \n", "30.78 | \n", "2.798182 | \n", "
18 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "0.83 | \n", "379 | \n", "1 | \n", "314.57 | \n", "6.291400 | \n", "
19 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "0.85 | \n", "331 | \n", "25 | \n", "281.35 | \n", "9.075806 | \n", "
20 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "1.63 | \n", "4 | \n", "1 | \n", "6.52 | \n", "2.173333 | \n", "
21 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "1.66 | \n", "1 | \n", "1 | \n", "1.66 | \n", "1.660000 | \n", "
22 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "0.25 | \n", "46 | \n", "2 | \n", "11.50 | \n", "5.750000 | \n", "
23 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "0.42 | \n", "740 | \n", "21 | \n", "310.80 | \n", "14.127273 | \n", "
24 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "1.06 | \n", "300 | \n", "2 | \n", "318.00 | \n", "159.000000 | \n", "
25 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "1.25 | \n", "902 | \n", "69 | \n", "1127.50 | \n", "11.505102 | \n", "
26 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "1.28 | \n", "132 | \n", "1 | \n", "168.96 | \n", "12.068571 | \n", "
27 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "2.46 | \n", "84 | \n", "2 | \n", "206.64 | \n", "7.653333 | \n", "
28 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "2.51 | \n", "24 | \n", "1 | \n", "60.24 | \n", "4.633846 | \n", "
29 | \n", "11001 | \n", "ASSTD DESIGN RACING CAR PEN | \n", "0.83 | \n", "281 | \n", "1 | \n", "233.23 | \n", "10.140435 | \n", "
30 | \n", "11001 | \n", "ASSTD DESIGN RACING CAR PEN | \n", "1.27 | \n", "284 | \n", "1 | \n", "360.68 | \n", "120.226667 | \n", "
31 | \n", "11001 | \n", "ASSTD DESIGN RACING CAR PEN | \n", "1.69 | \n", "805 | \n", "44 | \n", "1360.45 | \n", "20.305224 | \n", "
32 | \n", "11001 | \n", "ASSTD DESIGN RACING CAR PEN | \n", "3.29 | \n", "51 | \n", "2 | \n", "167.79 | \n", "7.990000 | \n", "
33 | \n", "11001 | \n", "ASSTD DESIGN RACING CAR PEN | \n", "3.36 | \n", "9 | \n", "1 | \n", "30.24 | \n", "5.040000 | \n", "
34 | \n", "15030 | \n", "FAN BLACK FRAME | \n", "0.29 | \n", "143 | \n", "11 | \n", "41.47 | \n", "3.190000 | \n", "
35 | \n", "15034 | \n", "PAPER POCKET TRAVELING FAN | \n", "0.07 | \n", "1657 | \n", "4 | \n", "115.99 | \n", "19.331667 | \n", "
36 | \n", "15034 | \n", "PAPER POCKET TRAVELING FAN | \n", "0.14 | \n", "3377 | \n", "67 | \n", "472.78 | \n", "5.312135 | \n", "
37 | \n", "15034 | \n", "PAPER POCKET TRAVELING FAN | \n", "0.83 | \n", "162 | \n", "1 | \n", "134.46 | \n", "3.361500 | \n", "
38 | \n", "15034 | \n", "PAPER POCKET TRAVELING FAN | \n", "0.85 | \n", "10 | \n", "1 | \n", "8.50 | \n", "1.214286 | \n", "
39 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "0.53 | \n", "600 | \n", "1 | \n", "318.00 | \n", "318.000000 | \n", "
40 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "0.65 | \n", "4200 | \n", "8 | \n", "2730.00 | \n", "341.250000 | \n", "
41 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "0.72 | \n", "8688 | \n", "12 | \n", "6255.36 | \n", "390.960000 | \n", "
42 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "0.75 | \n", "1407 | \n", "52 | \n", "1055.25 | \n", "17.020161 | \n", "
43 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "0.83 | \n", "6999 | \n", "160 | \n", "5809.17 | \n", "22.516163 | \n", "
44 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "1.25 | \n", "52 | \n", "1 | \n", "65.00 | \n", "6.500000 | \n", "
45 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "1.28 | \n", "58 | \n", "1 | \n", "74.24 | \n", "3.712000 | \n", "
46 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "1.63 | \n", "1078 | \n", "1 | \n", "1757.14 | \n", "11.872568 | \n", "
47 | \n", "15039 | \n", "SANDALWOOD FAN | \n", "0.53 | \n", "600 | \n", "3 | \n", "318.00 | \n", "106.000000 | \n", "
48 | \n", "15039 | \n", "SANDALWOOD FAN | \n", "0.85 | \n", "960 | \n", "56 | \n", "816.00 | \n", "11.492958 | \n", "
49 | \n", "15039 | \n", "SANDALWOOD FAN | \n", "1.63 | \n", "470 | \n", "1 | \n", "766.10 | \n", "10.944286 | \n", "
\n", " | unit_price | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|
count | \n", "16281.000000 | \n", "16281.000000 | \n", "16281.000000 | \n", "16281.000000 | \n", "16281.000000 | \n", "
mean | \n", "39.108888 | \n", "325.336466 | \n", "17.669246 | \n", "597.383880 | \n", "39.559728 | \n", "
std | \n", "414.488956 | \n", "1009.532305 | \n", "49.223973 | \n", "1911.086232 | \n", "428.464352 | \n", "
min | \n", "-11062.060000 | \n", "-9360.000000 | \n", "1.000000 | \n", "-22124.120000 | \n", "-17836.460000 | \n", "
25% | \n", "1.450000 | \n", "6.000000 | \n", "1.000000 | \n", "25.500000 | \n", "4.960000 | \n", "
50% | \n", "2.950000 | \n", "34.000000 | \n", "1.000000 | \n", "115.460000 | \n", "10.170000 | \n", "
75% | \n", "5.950000 | \n", "192.000000 | \n", "6.000000 | \n", "435.000000 | \n", "25.270909 | \n", "
max | \n", "17836.460000 | \n", "27636.000000 | \n", "814.000000 | \n", "85738.500000 | \n", "11062.060000 | \n", "
\n", " | quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|
count | \n", "4176.000000 | \n", "4176.000000 | \n", "4176.000000 | \n", "4176.000000 | \n", "
mean | \n", "1268.391523 | \n", "65.313458 | \n", "2329.024654 | \n", "13.507847 | \n", "
std | \n", "2885.717156 | \n", "88.364388 | \n", "7666.730254 | \n", "129.155911 | \n", "
min | \n", "-1194.000000 | \n", "1.000000 | \n", "-221520.500000 | \n", "-6515.308824 | \n", "
25% | \n", "45.000000 | \n", "7.000000 | \n", "106.192500 | \n", "6.069004 | \n", "
50% | \n", "310.000000 | \n", "31.000000 | \n", "601.125000 | \n", "10.732028 | \n", "
75% | \n", "1271.000000 | \n", "88.000000 | \n", "2055.182500 | \n", "17.334659 | \n", "
max | \n", "53751.000000 | \n", "888.000000 | \n", "206245.480000 | \n", "3022.500000 | \n", "
\n", " | stock_code | \n", "description | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|
0 | \n", "10002 | \n", "INFLATABLE POLITICAL GLOBE | \n", "860 | \n", "41 | \n", "759.89 | \n", "10.702676 | \n", "
1 | \n", "10080 | \n", "GROOVY CACTUS INFLATABLE | \n", "303 | \n", "20 | \n", "119.09 | \n", "5.413182 | \n", "
2 | \n", "10120 | \n", "DOGGY RUBBER | \n", "192 | \n", "25 | \n", "40.32 | \n", "1.390345 | \n", "
3 | \n", "10123C | \n", "HEARTS WRAPPING TAPE | \n", "5 | \n", "3 | \n", "3.25 | \n", "1.083333 | \n", "
4 | \n", "10124A | \n", "SPOTS ON RED BOOKCOVER TAPE | \n", "16 | \n", "5 | \n", "6.72 | \n", "1.344000 | \n", "
5 | \n", "10124G | \n", "ARMY CAMO BOOKCOVER TAPE | \n", "17 | \n", "4 | \n", "7.14 | \n", "1.785000 | \n", "
6 | \n", "10125 | \n", "MINI FUNKY DESIGN TAPES | \n", "1295 | \n", "50 | \n", "993.99 | \n", "10.688065 | \n", "
7 | \n", "10133 | \n", "COLOURING PENCILS BROWN TUBE | \n", "2846 | \n", "102 | \n", "1535.40 | \n", "7.793909 | \n", "
8 | \n", "10135 | \n", "COLOURING PENCILS BROWN TUBE | \n", "2228 | \n", "93 | \n", "2203.64 | \n", "12.380000 | \n", "
9 | \n", "11001 | \n", "ASSTD DESIGN RACING CAR PEN | \n", "1430 | \n", "46 | \n", "2152.39 | \n", "17.936583 | \n", "
10 | \n", "15030 | \n", "FAN BLACK FRAME | \n", "143 | \n", "11 | \n", "41.47 | \n", "3.190000 | \n", "
11 | \n", "15034 | \n", "PAPER POCKET TRAVELING FAN | \n", "5206 | \n", "71 | \n", "731.73 | \n", "5.153028 | \n", "
12 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "23082 | \n", "195 | \n", "18064.16 | \n", "34.539503 | \n", "
13 | \n", "15039 | \n", "SANDALWOOD FAN | \n", "2064 | \n", "59 | \n", "1956.54 | \n", "13.219865 | \n", "
14 | \n", "15044A | \n", "PINK PAPER PARASOL | \n", "457 | \n", "54 | \n", "1436.07 | \n", "13.942427 | \n", "
15 | \n", "15044B | \n", "BLUE PAPER PARASOL | \n", "320 | \n", "38 | \n", "943.88 | \n", "15.473443 | \n", "
16 | \n", "15044C | \n", "PURPLE PAPER PARASOL | \n", "310 | \n", "44 | \n", "1014.94 | \n", "11.277111 | \n", "
17 | \n", "15044D | \n", "RED PAPER PARASOL | \n", "642 | \n", "55 | \n", "1814.26 | \n", "21.096047 | \n", "
18 | \n", "15056BL | \n", "EDWARDIAN PARASOL BLACK | \n", "2714 | \n", "143 | \n", "15176.34 | \n", "46.553190 | \n", "
19 | \n", "15056N | \n", "EDWARDIAN PARASOL NATURAL | \n", "3893 | \n", "185 | \n", "21815.24 | \n", "46.914495 | \n", "
\n", " | stock_code | \n", "description | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|
0 | \n", "DOT | \n", "DOTCOM POSTAGE | \n", "705 | \n", "2 | \n", "206245.48 | \n", "291.719208 | \n", "
1 | \n", "22423 | \n", "REGENCY CAKESTAND 3 TIER | \n", "12996 | \n", "888 | \n", "164459.49 | \n", "75.198669 | \n", "
2 | \n", "47566 | \n", "PARTY BUNTING | \n", "18006 | \n", "709 | \n", "98243.88 | \n", "57.151763 | \n", "
3 | \n", "85123A | \n", "WHITE HANGING HEART T-LIGHT HOLDER | \n", "35002 | \n", "859 | \n", "97659.94 | \n", "42.720884 | \n", "
4 | \n", "85099B | \n", "JUMBO BAG RED RETROSPOT | \n", "47256 | \n", "637 | \n", "92175.79 | \n", "42.812722 | \n", "
5 | \n", "23084 | \n", "RABBIT NIGHT LIGHT | \n", "30631 | \n", "451 | \n", "66661.63 | \n", "64.594603 | \n", "
6 | \n", "POST | \n", "POSTAGE | \n", "3003 | \n", "380 | \n", "66230.64 | \n", "52.899872 | \n", "
7 | \n", "22086 | \n", "PAPER CHAIN KIT 50'S CHRISTMAS | \n", "18876 | \n", "616 | \n", "63715.24 | \n", "53.362848 | \n", "
8 | \n", "84879 | \n", "ASSORTED COLOUR BIRD ORNAMENT | \n", "36282 | \n", "680 | \n", "58792.42 | \n", "39.511035 | \n", "
9 | \n", "79321 | \n", "CHILLI LIGHTS | \n", "10222 | \n", "206 | \n", "53746.66 | \n", "79.861308 | \n", "
10 | \n", "23298 | \n", "SPOTTY BUNTING | \n", "8210 | \n", "572 | \n", "42030.67 | \n", "36.046887 | \n", "
11 | \n", "22386 | \n", "JUMBO BAG PINK POLKADOT | \n", "20992 | \n", "373 | \n", "41584.43 | \n", "33.401149 | \n", "
12 | \n", "21137 | \n", "BLACK RECORD COVER FRAME | \n", "11636 | \n", "141 | \n", "40578.21 | \n", "106.504488 | \n", "
13 | \n", "22720 | \n", "SET OF 3 CAKE TINS PANTRY DESIGN | \n", "7329 | \n", "641 | \n", "37378.79 | \n", "25.514532 | \n", "
14 | \n", "23284 | \n", "DOORMAT KEEP CALM AND COME IN | \n", "5262 | \n", "379 | \n", "36532.39 | \n", "49.434899 | \n", "
15 | \n", "22960 | \n", "JAM MAKING SET WITH JARS | \n", "8448 | \n", "575 | \n", "36069.34 | \n", "29.565033 | \n", "
16 | \n", "82484 | \n", "WOOD BLACK BOARD ANT WHITE FINISH | \n", "5988 | \n", "286 | \n", "35795.97 | \n", "51.430991 | \n", "
17 | \n", "20725 | \n", "LUNCH BAG RED RETROSPOT | \n", "18658 | \n", "533 | \n", "34717.66 | \n", "21.364714 | \n", "
18 | \n", "22197 | \n", "POPCORN HOLDER | \n", "36322 | \n", "297 | \n", "33959.26 | \n", "39.441649 | \n", "
19 | \n", "22114 | \n", "HOT WATER BOTTLE TEA AND SYMPATHY | \n", "5658 | \n", "326 | \n", "32663.34 | \n", "50.174101 | \n", "
\n", " | stock_code | \n", "description | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|
0 | \n", "84077 | \n", "WORLD WAR 2 GLIDERS ASSTD DESIGNS | \n", "53751 | \n", "308 | \n", "13560.09 | \n", "25.064861 | \n", "
1 | \n", "85099B | \n", "JUMBO BAG RED RETROSPOT | \n", "47256 | \n", "637 | \n", "92175.79 | \n", "42.812722 | \n", "
2 | \n", "22197 | \n", "POPCORN HOLDER | \n", "36322 | \n", "297 | \n", "33959.26 | \n", "39.441649 | \n", "
3 | \n", "84879 | \n", "ASSORTED COLOUR BIRD ORNAMENT | \n", "36282 | \n", "680 | \n", "58792.42 | \n", "39.511035 | \n", "
4 | \n", "21212 | \n", "PACK OF 72 RETROSPOT CAKE CASES | \n", "36016 | \n", "637 | \n", "21047.07 | \n", "15.396540 | \n", "
5 | \n", "85123A | \n", "WHITE HANGING HEART T-LIGHT HOLDER | \n", "35002 | \n", "859 | \n", "97659.94 | \n", "42.720884 | \n", "
6 | \n", "23084 | \n", "RABBIT NIGHT LIGHT | \n", "30631 | \n", "451 | \n", "66661.63 | \n", "64.594603 | \n", "
7 | \n", "22492 | \n", "MINI PAINT SET VINTAGE | \n", "26437 | \n", "214 | \n", "16810.42 | \n", "43.103641 | \n", "
8 | \n", "22616 | \n", "PACK OF 12 LONDON TISSUES | \n", "26095 | \n", "196 | \n", "7967.82 | \n", "15.176800 | \n", "
9 | \n", "21977 | \n", "PACK OF 60 PINK PAISLEY CAKE CASES | \n", "24719 | \n", "412 | \n", "12170.77 | \n", "13.736761 | \n", "
10 | \n", "22178 | \n", "VICTORIAN GLASS HANGING T-LIGHT | \n", "23825 | \n", "404 | \n", "32508.42 | \n", "30.495704 | \n", "
11 | \n", "15036 | \n", "ASSORTED COLOURS SILK FAN | \n", "23082 | \n", "195 | \n", "18064.16 | \n", "34.539503 | \n", "
12 | \n", "17003 | \n", "BROCADE RING PURSE | \n", "23017 | \n", "137 | \n", "5853.15 | \n", "23.988320 | \n", "
13 | \n", "21915 | \n", "RED HARMONICA IN BOX | \n", "21836 | \n", "351 | \n", "26210.33 | \n", "38.945513 | \n", "
14 | \n", "22386 | \n", "JUMBO BAG PINK POLKADOT | \n", "20992 | \n", "373 | \n", "41584.43 | \n", "33.401149 | \n", "
15 | \n", "22197 | \n", "SMALL POPCORN HOLDER | \n", "20105 | \n", "229 | \n", "17008.66 | \n", "28.020857 | \n", "
16 | \n", "22086 | \n", "PAPER CHAIN KIT 50'S CHRISTMAS | \n", "18876 | \n", "616 | \n", "63715.24 | \n", "53.362848 | \n", "
17 | \n", "20725 | \n", "LUNCH BAG RED RETROSPOT | \n", "18658 | \n", "533 | \n", "34717.66 | \n", "21.364714 | \n", "
18 | \n", "84991 | \n", "60 TEATIME FAIRY CAKE CASES | \n", "18015 | \n", "416 | \n", "9074.27 | \n", "10.650552 | \n", "
19 | \n", "47566 | \n", "PARTY BUNTING | \n", "18006 | \n", "709 | \n", "98243.88 | \n", "57.151763 | \n", "
\n", " | stock_code | \n", "description | \n", "unit_price | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "17836.46 | \n", "-1 | \n", "1 | \n", "-17836.46 | \n", "-17836.460000 | \n", "
1 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "16888.02 | \n", "-1 | \n", "1 | \n", "-16888.02 | \n", "-16888.020000 | \n", "
2 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "16453.71 | \n", "-1 | \n", "1 | \n", "-16453.71 | \n", "-16453.710000 | \n", "
3 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "13541.33 | \n", "-1 | \n", "1 | \n", "-13541.33 | \n", "-4513.776667 | \n", "
4 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "13474.79 | \n", "-1 | \n", "1 | \n", "-13474.79 | \n", "-13474.790000 | \n", "
5 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "11586.50 | \n", "-1 | \n", "1 | \n", "-11586.50 | \n", "-11586.500000 | \n", "
6 | \n", "B | \n", "Adjust bad debt | \n", "11062.06 | \n", "1 | \n", "1 | \n", "11062.06 | \n", "11062.060000 | \n", "
7 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "8286.22 | \n", "-1 | \n", "1 | \n", "-8286.22 | \n", "-8286.220000 | \n", "
8 | \n", "POST | \n", "POSTAGE | \n", "8142.75 | \n", "0 | \n", "1 | \n", "0.00 | \n", "0.000000 | \n", "
9 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "7427.97 | \n", "-1 | \n", "1 | \n", "-7427.97 | \n", "-7427.970000 | \n", "
10 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "7006.83 | \n", "-1 | \n", "1 | \n", "-7006.83 | \n", "-7006.830000 | \n", "
11 | \n", "M | \n", "Manual | \n", "6930.00 | \n", "-1 | \n", "1 | \n", "-6930.00 | \n", "-6930.000000 | \n", "
12 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "6721.37 | \n", "-1 | \n", "1 | \n", "-6721.37 | \n", "-6721.370000 | \n", "
13 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "6706.71 | \n", "-1 | \n", "1 | \n", "-6706.71 | \n", "-6706.710000 | \n", "
14 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "6662.51 | \n", "-1 | \n", "1 | \n", "-6662.51 | \n", "-6662.510000 | \n", "
15 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "6497.47 | \n", "-1 | \n", "1 | \n", "-6497.47 | \n", "-6497.470000 | \n", "
16 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5942.57 | \n", "-2 | \n", "1 | \n", "-11885.14 | \n", "-5942.570000 | \n", "
17 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5877.18 | \n", "-1 | \n", "1 | \n", "-5877.18 | \n", "-5877.180000 | \n", "
18 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5876.40 | \n", "-1 | \n", "1 | \n", "-5876.40 | \n", "-5876.400000 | \n", "
19 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5791.18 | \n", "-1 | \n", "1 | \n", "-5791.18 | \n", "-5791.180000 | \n", "
20 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5693.05 | \n", "-1 | \n", "1 | \n", "-5693.05 | \n", "-5693.050000 | \n", "
21 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5575.28 | \n", "-1 | \n", "1 | \n", "-5575.28 | \n", "-5575.280000 | \n", "
22 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5522.14 | \n", "-1 | \n", "1 | \n", "-5522.14 | \n", "-5522.140000 | \n", "
23 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5519.25 | \n", "-1 | \n", "1 | \n", "-5519.25 | \n", "-5519.250000 | \n", "
24 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5258.77 | \n", "-1 | \n", "1 | \n", "-5258.77 | \n", "-5258.770000 | \n", "
25 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "5225.03 | \n", "-1 | \n", "1 | \n", "-5225.03 | \n", "-5225.030000 | \n", "
26 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "4575.64 | \n", "-1 | \n", "1 | \n", "-4575.64 | \n", "-4575.640000 | \n", "
27 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "4534.24 | \n", "-1 | \n", "1 | \n", "-4534.24 | \n", "-4534.240000 | \n", "
28 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "4527.65 | \n", "-1 | \n", "1 | \n", "-4527.65 | \n", "-4527.650000 | \n", "
29 | \n", "DOT | \n", "DOTCOM POSTAGE | \n", "4505.17 | \n", "1 | \n", "1 | \n", "4505.17 | \n", "4505.170000 | \n", "
\n", " | stock_code | \n", "description | \n", "unit_price | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|---|
30 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "4383.62 | \n", "-1 | \n", "1 | \n", "-4383.62 | \n", "-4383.620000 | \n", "
16190 | \n", "M | \n", "Manual | \n", "0.19 | \n", "-550 | \n", "9 | \n", "-104.50 | \n", "-10.450000 | \n", "
11 | \n", "M | \n", "Manual | \n", "6930.00 | \n", "-1 | \n", "1 | \n", "-6930.00 | \n", "-6930.000000 | \n", "
2522 | \n", "M | \n", "Manual | \n", "9.36 | \n", "-1 | \n", "1 | \n", "-9.36 | \n", "-9.360000 | \n", "
266 | \n", "M | \n", "Manual | \n", "367.38 | \n", "-1 | \n", "1 | \n", "-367.38 | \n", "-367.380000 | \n", "
54 | \n", "M | \n", "Manual | \n", "1715.85 | \n", "-1 | \n", "1 | \n", "-1715.85 | \n", "-1715.850000 | \n", "
15 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "6497.47 | \n", "-1 | \n", "1 | \n", "-6497.47 | \n", "-6497.470000 | \n", "
1863 | \n", "M | \n", "Manual | \n", "12.75 | \n", "-1 | \n", "3 | \n", "-12.75 | \n", "-2.550000 | \n", "
337 | \n", "M | \n", "Manual | \n", "269.70 | \n", "-1 | \n", "1 | \n", "-269.70 | \n", "-269.700000 | \n", "
904 | \n", "POST | \n", "POSTAGE | \n", "75.00 | \n", "-1 | \n", "1 | \n", "-75.00 | \n", "-75.000000 | \n", "
2361 | \n", "D | \n", "Discount | \n", "10.06 | \n", "-1 | \n", "1 | \n", "-10.06 | \n", "-10.060000 | \n", "
4000 | \n", "S | \n", "SAMPLES | \n", "6.15 | \n", "-1 | \n", "1 | \n", "-6.15 | \n", "-6.150000 | \n", "
1078 | \n", "POST | \n", "POSTAGE | \n", "30.53 | \n", "-1 | \n", "1 | \n", "-30.53 | \n", "-30.530000 | \n", "
3201 | \n", "85068 | \n", "CREAM SWEETHEART SHELF + HOOKS | \n", "7.95 | \n", "-1 | \n", "1 | \n", "-7.95 | \n", "-7.950000 | \n", "
12 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "6721.37 | \n", "-1 | \n", "1 | \n", "-6721.37 | \n", "-6721.370000 | \n", "
5379 | \n", "79320 | \n", "FLAMINGO LIGHTS | \n", "4.95 | \n", "-1 | \n", "1 | \n", "-4.95 | \n", "-4.950000 | \n", "
908 | \n", "M | \n", "Manual | \n", "71.46 | \n", "-1 | \n", "1 | \n", "-71.46 | \n", "-71.460000 | \n", "
2181 | \n", "M | \n", "Manual | \n", "10.95 | \n", "-4 | \n", "2 | \n", "-43.80 | \n", "-14.600000 | \n", "
115 | \n", "M | \n", "Manual | \n", "869.55 | \n", "-1 | \n", "1 | \n", "-869.55 | \n", "-869.550000 | \n", "
279 | \n", "BANK CHARGES | \n", "Bank Charges | \n", "326.68 | \n", "-1 | \n", "1 | \n", "-326.68 | \n", "-326.680000 | \n", "
1673 | \n", "M | \n", "Manual | \n", "14.95 | \n", "-1 | \n", "3 | \n", "-14.95 | \n", "-4.983333 | \n", "
202 | \n", "M | \n", "Manual | \n", "544.40 | \n", "-1 | \n", "1 | \n", "-544.40 | \n", "-544.400000 | \n", "
4654 | \n", "M | \n", "Manual | \n", "5.70 | \n", "-1 | \n", "1 | \n", "-5.70 | \n", "-5.700000 | \n", "
26 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "4575.64 | \n", "-1 | \n", "1 | \n", "-4575.64 | \n", "-4575.640000 | \n", "
2368 | \n", "S | \n", "SAMPLES | \n", "10.00 | \n", "-1 | \n", "1 | \n", "-10.00 | \n", "-10.000000 | \n", "
964 | \n", "S | \n", "SAMPLES | \n", "50.99 | \n", "-1 | \n", "1 | \n", "-50.99 | \n", "-50.990000 | \n", "
1382 | \n", "M | \n", "Manual | \n", "17.55 | \n", "-1 | \n", "1 | \n", "-17.55 | \n", "-17.550000 | \n", "
4708 | \n", "S | \n", "SAMPLES | \n", "5.44 | \n", "-1 | \n", "1 | \n", "-5.44 | \n", "-5.440000 | \n", "
845 | \n", "BANK CHARGES | \n", "Bank Charges | \n", "95.38 | \n", "-1 | \n", "1 | \n", "-95.38 | \n", "-95.380000 | \n", "
1297 | \n", "POST | \n", "POSTAGE | \n", "20.47 | \n", "-1 | \n", "1 | \n", "-20.47 | \n", "-20.470000 | \n", "
1578 | \n", "CRUK | \n", "CRUK Commission | \n", "15.96 | \n", "-1 | \n", "1 | \n", "-15.96 | \n", "-15.960000 | \n", "
876 | \n", "S | \n", "SAMPLES | \n", "83.06 | \n", "-1 | \n", "1 | \n", "-83.06 | \n", "-83.060000 | \n", "
401 | \n", "M | \n", "Manual | \n", "233.25 | \n", "-1 | \n", "1 | \n", "-233.25 | \n", "-233.250000 | \n", "
686 | \n", "BANK CHARGES | \n", "Bank Charges | \n", "149.16 | \n", "-1 | \n", "1 | \n", "-149.16 | \n", "-149.160000 | \n", "
1 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "16888.02 | \n", "-1 | \n", "1 | \n", "-16888.02 | \n", "-16888.020000 | \n", "
5380 | \n", "POST | \n", "POSTAGE | \n", "4.90 | \n", "-1 | \n", "1 | \n", "-4.90 | \n", "-4.900000 | \n", "
2170 | \n", "POST | \n", "POSTAGE | \n", "11.00 | \n", "-1 | \n", "1 | \n", "-11.00 | \n", "-11.000000 | \n", "
3857 | \n", "S | \n", "SAMPLES | \n", "6.70 | \n", "-1 | \n", "1 | \n", "-6.70 | \n", "-6.700000 | \n", "
16130 | \n", "D | \n", "Discount | \n", "0.20 | \n", "-48 | \n", "1 | \n", "-9.60 | \n", "-9.600000 | \n", "
961 | \n", "CRUK | \n", "CRUK Commission | \n", "52.24 | \n", "-1 | \n", "1 | \n", "-52.24 | \n", "-52.240000 | \n", "
877 | \n", "BANK CHARGES | \n", "Bank Charges | \n", "82.89 | \n", "-1 | \n", "1 | \n", "-82.89 | \n", "-82.890000 | \n", "
998 | \n", "D | \n", "Discount | \n", "42.50 | \n", "-1 | \n", "1 | \n", "-42.50 | \n", "-42.500000 | \n", "
869 | \n", "22827 | \n", "RUSTIC SEVENTEEN DRAWER SIDEBOARD | \n", "85.00 | \n", "-1 | \n", "1 | \n", "-85.00 | \n", "-85.000000 | \n", "
949 | \n", "BANK CHARGES | \n", "Bank Charges | \n", "56.93 | \n", "-1 | \n", "1 | \n", "-56.93 | \n", "-56.930000 | \n", "
16277 | \n", "D | \n", "Discount | \n", "0.01 | \n", "-720 | \n", "1 | \n", "-7.20 | \n", "-7.200000 | \n", "
6527 | \n", "POST | \n", "POSTAGE | \n", "3.95 | \n", "-1 | \n", "2 | \n", "-3.95 | \n", "-1.316667 | \n", "
1639 | \n", "D | \n", "Discount | \n", "15.07 | \n", "-1 | \n", "1 | \n", "-15.07 | \n", "-15.070000 | \n", "
225 | \n", "BANK CHARGES | \n", "Bank Charges | \n", "475.69 | \n", "-1 | \n", "1 | \n", "-475.69 | \n", "-475.690000 | \n", "
753 | \n", "S | \n", "SAMPLES | \n", "128.56 | \n", "-1 | \n", "1 | \n", "-128.56 | \n", "-128.560000 | \n", "
27 | \n", "AMAZONFEE | \n", "AMAZON FEE | \n", "4534.24 | \n", "-1 | \n", "1 | \n", "-4534.24 | \n", "-4534.240000 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "
---|---|---|---|---|---|---|---|---|
222682 | \n", "556446 | \n", "22502 | \n", "PICNIC BASKET WICKER 60 PIECES | \n", "1 | \n", "2019-06-08 15:33:00 | \n", "649.50 | \n", "15098 | \n", "649.50 | \n", "
170645 | \n", "551339 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "1 | \n", "2019-04-25 17:18:00 | \n", "10.79 | \n", "0 | \n", "10.79 | \n", "
224313 | \n", "556515 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "1 | \n", "2019-06-11 10:45:00 | \n", "10.79 | \n", "0 | \n", "10.79 | \n", "
234244 | \n", "557502 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "2 | \n", "2019-06-18 15:32:00 | \n", "10.79 | \n", "0 | \n", "21.58 | \n", "
232567 | \n", "557324 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "2 | \n", "2019-06-18 09:41:00 | \n", "10.79 | \n", "0 | \n", "21.58 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
182710 | \n", "552563 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "16 | \n", "2019-05-08 11:54:00 | \n", "4.95 | \n", "17597 | \n", "79.20 | \n", "
182457 | \n", "552547 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "16 | \n", "2019-05-08 10:34:00 | \n", "4.95 | \n", "13098 | \n", "79.20 | \n", "
152290 | \n", "549585 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "32 | \n", "2019-04-09 09:54:00 | \n", "4.95 | \n", "14616 | \n", "158.40 | \n", "
181862 | \n", "552514 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "19 | \n", "2019-05-07 16:30:00 | \n", "4.95 | \n", "0 | \n", "94.05 | \n", "
359476 | \n", "568188 | \n", "22502 | \n", "PICNIC BASKET WICKER SMALL | \n", "1 | \n", "2019-09-23 14:33:00 | \n", "2.00 | \n", "16049 | \n", "2.00 | \n", "
472 rows × 8 columns
\n", "\n", " | stock_code | \n", "description | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|
0 | \n", "22423 | \n", "REGENCY CAKESTAND 3 TIER | \n", "12996 | \n", "888 | \n", "164459.49 | \n", "75.198669 | \n", "
1 | \n", "47566 | \n", "PARTY BUNTING | \n", "18006 | \n", "709 | \n", "98243.88 | \n", "57.151763 | \n", "
2 | \n", "85123A | \n", "WHITE HANGING HEART T-LIGHT HOLDER | \n", "35002 | \n", "859 | \n", "97659.94 | \n", "42.720884 | \n", "
3 | \n", "85099B | \n", "JUMBO BAG RED RETROSPOT | \n", "47256 | \n", "637 | \n", "92175.79 | \n", "42.812722 | \n", "
4 | \n", "23084 | \n", "RABBIT NIGHT LIGHT | \n", "30631 | \n", "451 | \n", "66661.63 | \n", "64.594603 | \n", "
5 | \n", "22086 | \n", "PAPER CHAIN KIT 50'S CHRISTMAS | \n", "18876 | \n", "616 | \n", "63715.24 | \n", "53.362848 | \n", "
6 | \n", "84879 | \n", "ASSORTED COLOUR BIRD ORNAMENT | \n", "36282 | \n", "680 | \n", "58792.42 | \n", "39.511035 | \n", "
7 | \n", "79321 | \n", "CHILLI LIGHTS | \n", "10222 | \n", "206 | \n", "53746.66 | \n", "79.861308 | \n", "
8 | \n", "23298 | \n", "SPOTTY BUNTING | \n", "8210 | \n", "572 | \n", "42030.67 | \n", "36.046887 | \n", "
9 | \n", "22386 | \n", "JUMBO BAG PINK POLKADOT | \n", "20992 | \n", "373 | \n", "41584.43 | \n", "33.401149 | \n", "
\n", " | stock_code | \n", "description | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|
0 | \n", "84077 | \n", "WORLD WAR 2 GLIDERS ASSTD DESIGNS | \n", "53751 | \n", "308 | \n", "13560.09 | \n", "25.064861 | \n", "
1 | \n", "85099B | \n", "JUMBO BAG RED RETROSPOT | \n", "47256 | \n", "637 | \n", "92175.79 | \n", "42.812722 | \n", "
2 | \n", "22197 | \n", "POPCORN HOLDER | \n", "36322 | \n", "297 | \n", "33959.26 | \n", "39.441649 | \n", "
3 | \n", "84879 | \n", "ASSORTED COLOUR BIRD ORNAMENT | \n", "36282 | \n", "680 | \n", "58792.42 | \n", "39.511035 | \n", "
4 | \n", "21212 | \n", "PACK OF 72 RETROSPOT CAKE CASES | \n", "36016 | \n", "637 | \n", "21047.07 | \n", "15.396540 | \n", "
5 | \n", "85123A | \n", "WHITE HANGING HEART T-LIGHT HOLDER | \n", "35002 | \n", "859 | \n", "97659.94 | \n", "42.720884 | \n", "
6 | \n", "23084 | \n", "RABBIT NIGHT LIGHT | \n", "30631 | \n", "451 | \n", "66661.63 | \n", "64.594603 | \n", "
7 | \n", "22492 | \n", "MINI PAINT SET VINTAGE | \n", "26437 | \n", "214 | \n", "16810.42 | \n", "43.103641 | \n", "
8 | \n", "22616 | \n", "PACK OF 12 LONDON TISSUES | \n", "26095 | \n", "196 | \n", "7967.82 | \n", "15.176800 | \n", "
9 | \n", "21977 | \n", "PACK OF 60 PINK PAISLEY CAKE CASES | \n", "24719 | \n", "412 | \n", "12170.77 | \n", "13.736761 | \n", "
\n", " | stock_code | \n", "description | \n", "unit_price | \n", "quantity | \n", "num_of_customers | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|---|---|---|
0 | \n", "22656 | \n", "VINTAGE BLUE KITCHEN CABINET | \n", "295.0 | \n", "3 | \n", "2 | \n", "885.0 | \n", "295.000000 | \n", "
1 | \n", "22655 | \n", "VINTAGE RED KITCHEN CABINET | \n", "295.0 | \n", "3 | \n", "5 | \n", "885.0 | \n", "126.428571 | \n", "
2 | \n", "22655 | \n", "VINTAGE RED KITCHEN CABINET | \n", "265.5 | \n", "-1 | \n", "1 | \n", "-265.5 | \n", "-265.500000 | \n", "
3 | \n", "22826 | \n", "LOVE SEAT ANTIQUE WHITE METAL | \n", "195.0 | \n", "8 | \n", "9 | \n", "1560.0 | \n", "130.000000 | \n", "
4 | \n", "22826 | \n", "LOVE SEAT ANTIQUE WHITE METAL | \n", "175.0 | \n", "2 | \n", "1 | \n", "350.0 | \n", "350.000000 | \n", "
5 | \n", "22656 | \n", "VINTAGE BLUE KITCHEN CABINET | \n", "175.0 | \n", "-1 | \n", "1 | \n", "-175.0 | \n", "-175.000000 | \n", "
6 | \n", "22827 | \n", "RUSTIC SEVENTEEN DRAWER SIDEBOARD | \n", "165.0 | \n", "15 | \n", "17 | \n", "2475.0 | \n", "130.263158 | \n", "
7 | \n", "22828 | \n", "REGENCY MIRROR WITH SHUTTERS | \n", "165.0 | \n", "4 | \n", "4 | \n", "660.0 | \n", "165.000000 | \n", "
8 | \n", "C2 | \n", "CARRIAGE | \n", "150.0 | \n", "1 | \n", "1 | \n", "150.0 | \n", "150.000000 | \n", "
9 | \n", "22827 | \n", "RUSTIC SEVENTEEN DRAWER SIDEBOARD | \n", "145.0 | \n", "18 | \n", "6 | \n", "2610.0 | \n", "290.000000 | \n", "
\n", " | sales_total | \n", "sales_above | \n", "sales_below | \n", "percent_above | \n", "percent_below | \n", "
---|---|---|---|---|---|
0 | \n", "20000.0 | \n", "537442.06 | \n", "9202580.46 | \n", "5.52 | \n", "94.48 | \n", "
1 | \n", "10000.0 | \n", "1467462.59 | \n", "8272559.93 | \n", "15.07 | \n", "84.93 | \n", "
2 | \n", "7500.0 | \n", "2068389.18 | \n", "7671633.34 | \n", "21.24 | \n", "78.76 | \n", "
3 | \n", "5000.0 | \n", "3395942.69 | \n", "6344079.83 | \n", "34.87 | \n", "65.13 | \n", "
4 | \n", "4500.0 | \n", "3712038.28 | \n", "6027984.24 | \n", "38.11 | \n", "61.89 | \n", "
5 | \n", "4000.0 | \n", "4076211.92 | \n", "5663810.60 | \n", "41.85 | \n", "58.15 | \n", "
6 | \n", "3000.0 | \n", "4972323.63 | \n", "4767698.89 | \n", "51.05 | \n", "48.95 | \n", "
7 | \n", "2000.0 | \n", "6035255.75 | \n", "3704766.77 | \n", "61.96 | \n", "38.04 | \n", "
8 | \n", "1000.0 | \n", "7520351.09 | \n", "2219671.43 | \n", "77.21 | \n", "22.79 | \n", "
\n", " | quantity | \n", "sales_above | \n", "sales_below | \n", "percent_above | \n", "percent_below | \n", "
---|---|---|---|---|---|
0 | \n", "20000.0 | \n", "66941.98 | \n", "9673080.54 | \n", "0.69 | \n", "99.31 | \n", "
1 | \n", "10000.0 | \n", "392919.72 | \n", "9347102.80 | \n", "4.03 | \n", "95.97 | \n", "
2 | \n", "7500.0 | \n", "704203.02 | \n", "9035819.50 | \n", "7.23 | \n", "92.77 | \n", "
3 | \n", "5000.0 | \n", "1372403.85 | \n", "8367618.67 | \n", "14.09 | \n", "85.91 | \n", "
4 | \n", "4000.0 | \n", "1854922.01 | \n", "7885100.51 | \n", "19.04 | \n", "80.96 | \n", "
5 | \n", "3000.0 | \n", "2480569.52 | \n", "7259453.00 | \n", "25.47 | \n", "74.53 | \n", "
6 | \n", "1500.0 | \n", "4168348.60 | \n", "5571673.92 | \n", "42.80 | \n", "57.20 | \n", "
\n", " | unit_price | \n", "sales_above | \n", "sales_below | \n", "percent_above | \n", "percent_below | \n", "
---|---|---|---|---|---|
0 | \n", "500.00 | \n", "0.00 | \n", "9740022.52 | \n", "0.00 | \n", "100.00 | \n", "
1 | \n", "250.00 | \n", "1504.50 | \n", "9738518.02 | \n", "0.02 | \n", "99.98 | \n", "
2 | \n", "100.00 | \n", "20599.50 | \n", "9719423.02 | \n", "0.21 | \n", "99.79 | \n", "
3 | \n", "50.00 | \n", "37119.52 | \n", "9702903.00 | \n", "0.38 | \n", "99.62 | \n", "
4 | \n", "25.00 | \n", "86589.57 | \n", "9653432.95 | \n", "0.89 | \n", "99.11 | \n", "
5 | \n", "10.00 | \n", "797854.35 | \n", "8942168.17 | \n", "8.19 | \n", "91.81 | \n", "
6 | \n", "5.00 | \n", "2259786.11 | \n", "7480236.41 | \n", "23.20 | \n", "76.80 | \n", "
7 | \n", "3.00 | \n", "4305784.64 | \n", "5434237.88 | \n", "44.21 | \n", "55.79 | \n", "
8 | \n", "2.00 | \n", "6103645.45 | \n", "3636377.07 | \n", "62.67 | \n", "37.33 | \n", "
9 | \n", "1.00 | \n", "8659263.90 | \n", "1080758.62 | \n", "88.90 | \n", "11.10 | \n", "
10 | \n", "0.75 | \n", "9057681.00 | \n", "682341.52 | \n", "92.99 | \n", "7.01 | \n", "
11 | \n", "0.50 | \n", "9346640.70 | \n", "393381.82 | \n", "95.96 | \n", "4.04 | \n", "
12 | \n", "0.25 | \n", "9703772.53 | \n", "36249.99 | \n", "99.63 | \n", "0.37 | \n", "
\n", " | customer_id | \n", "orders | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|
0 | \n", "0 | \n", "1410 | \n", "1506879.59 | \n", "11.451323 | \n", "
1 | \n", "14646 | \n", "73 | \n", "278778.02 | \n", "135.197876 | \n", "
2 | \n", "18102 | \n", "60 | \n", "259657.30 | \n", "602.453132 | \n", "
3 | \n", "17450 | \n", "49 | \n", "189575.53 | \n", "559.219853 | \n", "
4 | \n", "14911 | \n", "243 | \n", "132893.24 | \n", "22.558690 | \n", "
5 | \n", "12415 | \n", "24 | \n", "123638.18 | \n", "159.739251 | \n", "
6 | \n", "14156 | \n", "65 | \n", "114335.77 | \n", "80.859809 | \n", "
7 | \n", "17511 | \n", "45 | \n", "88138.20 | \n", "82.065363 | \n", "
8 | \n", "16684 | \n", "30 | \n", "65920.12 | \n", "235.429000 | \n", "
9 | \n", "13694 | \n", "57 | \n", "62961.54 | \n", "108.367539 | \n", "
10 | \n", "16029 | \n", "66 | \n", "60369.93 | \n", "232.192038 | \n", "
11 | \n", "15311 | \n", "118 | \n", "59284.19 | \n", "23.924209 | \n", "
12 | \n", "13089 | \n", "118 | \n", "57322.13 | \n", "30.934771 | \n", "
13 | \n", "15061 | \n", "54 | \n", "54250.34 | \n", "132.641418 | \n", "
14 | \n", "14096 | \n", "17 | \n", "53258.43 | \n", "10.453078 | \n", "
15 | \n", "17949 | \n", "49 | \n", "53215.74 | \n", "700.207105 | \n", "
16 | \n", "15769 | \n", "29 | \n", "51823.72 | \n", "352.542313 | \n", "
17 | \n", "14298 | \n", "45 | \n", "50862.44 | \n", "31.013683 | \n", "
18 | \n", "14088 | \n", "14 | \n", "50415.49 | \n", "85.449983 | \n", "
19 | \n", "17841 | \n", "169 | \n", "39861.49 | \n", "5.110447 | \n", "
\n", " | customer_id | \n", "orders | \n", "sales_total | \n", "sales_average | \n", "
---|---|---|---|---|
0 | \n", "0 | \n", "1410 | \n", "1506879.59 | \n", "11.451323 | \n", "
4 | \n", "14911 | \n", "243 | \n", "132893.24 | \n", "22.558690 | \n", "
19 | \n", "17841 | \n", "169 | \n", "39861.49 | \n", "5.110447 | \n", "
11 | \n", "15311 | \n", "118 | \n", "59284.19 | \n", "23.924209 | \n", "
12 | \n", "13089 | \n", "118 | \n", "57322.13 | \n", "30.934771 | \n", "
1 | \n", "14646 | \n", "73 | \n", "278778.02 | \n", "135.197876 | \n", "
10 | \n", "16029 | \n", "66 | \n", "60369.93 | \n", "232.192038 | \n", "
6 | \n", "14156 | \n", "65 | \n", "114335.77 | \n", "80.859809 | \n", "
2 | \n", "18102 | \n", "60 | \n", "259657.30 | \n", "602.453132 | \n", "
9 | \n", "13694 | \n", "57 | \n", "62961.54 | \n", "108.367539 | \n", "
13 | \n", "15061 | \n", "54 | \n", "54250.34 | \n", "132.641418 | \n", "
15 | \n", "17949 | \n", "49 | \n", "53215.74 | \n", "700.207105 | \n", "
3 | \n", "17450 | \n", "49 | \n", "189575.53 | \n", "559.219853 | \n", "
7 | \n", "17511 | \n", "45 | \n", "88138.20 | \n", "82.065363 | \n", "
17 | \n", "14298 | \n", "45 | \n", "50862.44 | \n", "31.013683 | \n", "
8 | \n", "16684 | \n", "30 | \n", "65920.12 | \n", "235.429000 | \n", "
16 | \n", "15769 | \n", "29 | \n", "51823.72 | \n", "352.542313 | \n", "
5 | \n", "12415 | \n", "24 | \n", "123638.18 | \n", "159.739251 | \n", "
14 | \n", "14096 | \n", "17 | \n", "53258.43 | \n", "10.453078 | \n", "
18 | \n", "14088 | \n", "14 | \n", "50415.49 | \n", "85.449983 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "first_order_date | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "536365 | \n", "85123A | \n", "WHITE HANGING HEART T-LIGHT HOLDER | \n", "6 | \n", "2018-11-29 08:26:00 | \n", "2.55 | \n", "17850 | \n", "15.30 | \n", "2018-11-29 08:26:00 | \n", "
1 | \n", "536365 | \n", "71053 | \n", "WHITE METAL LANTERN | \n", "6 | \n", "2018-11-29 08:26:00 | \n", "3.39 | \n", "17850 | \n", "20.34 | \n", "2018-11-29 08:26:00 | \n", "
2 | \n", "536365 | \n", "84406B | \n", "CREAM CUPID HEARTS COAT HANGER | \n", "8 | \n", "2018-11-29 08:26:00 | \n", "2.75 | \n", "17850 | \n", "22.00 | \n", "2018-11-29 08:26:00 | \n", "
3 | \n", "536365 | \n", "84029G | \n", "KNITTED UNION FLAG HOT WATER BOTTLE | \n", "6 | \n", "2018-11-29 08:26:00 | \n", "3.39 | \n", "17850 | \n", "20.34 | \n", "2018-11-29 08:26:00 | \n", "
4 | \n", "536365 | \n", "84029E | \n", "RED WOOLLY HOTTIE WHITE HEART. | \n", "6 | \n", "2018-11-29 08:26:00 | \n", "3.39 | \n", "17850 | \n", "20.34 | \n", "2018-11-29 08:26:00 | \n", "
\n", " | invoice_no | \n", "stock_code | \n", "description | \n", "quantity | \n", "invoice_date | \n", "unit_price | \n", "customer_id | \n", "total_price | \n", "first_order_date | \n", "first_order_month | \n", "order_month | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|
529821 | \n", "580754 | \n", "21670 | \n", "BLUE SPOT CERAMIC DRAWER KNOB | \n", "6 | \n", "2019-12-04 10:05:00 | \n", "3.29 | \n", "0 | \n", "19.74 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-12-01 | \n", "
226155 | \n", "556781 | \n", "22846 | \n", "BREAD BIN DINER STYLE RED | \n", "1 | \n", "2019-06-12 12:47:00 | \n", "16.95 | \n", "13384 | \n", "16.95 | \n", "2019-06-12 12:47:00 | \n", "2019-06-01 | \n", "2019-06-01 | \n", "
508499 | \n", "579196 | \n", "21080 | \n", "SET/20 RED RETROSPOT PAPER NAPKINS | \n", "4 | \n", "2019-11-26 15:54:00 | \n", "0.83 | \n", "14096 | \n", "3.32 | \n", "2019-08-28 10:49:00 | \n", "2019-08-01 | \n", "2019-11-01 | \n", "
48623 | \n", "540469 | \n", "21289 | \n", "LARGE STRIPES CHOCOLATE GIFT BAG | \n", "16 | \n", "2019-01-05 14:04:00 | \n", "1.25 | \n", "12484 | \n", "20.00 | \n", "2019-01-05 14:04:00 | \n", "2019-01-01 | \n", "2019-01-01 | \n", "
477015 | \n", "577046 | \n", "22754 | \n", "SMALL RED BABUSHKA NOTEBOOK | \n", "12 | \n", "2019-11-15 13:46:00 | \n", "0.85 | \n", "12449 | \n", "10.20 | \n", "2019-06-03 15:37:00 | \n", "2019-06-01 | \n", "2019-11-01 | \n", "
519073 | \n", "580136 | \n", "16169E | \n", "WRAP 50'S CHRISTMAS | \n", "1 | \n", "2019-11-29 19:42:00 | \n", "0.42 | \n", "17841 | \n", "0.42 | \n", "2018-11-29 14:30:00 | \n", "2018-11-01 | \n", "2019-11-01 | \n", "
233151 | \n", "557442 | \n", "84931B | \n", "BLUE SCOTTIE DOG W FLOWER PATTERN | \n", "2 | \n", "2019-06-18 12:53:00 | \n", "2.55 | \n", "14808 | \n", "5.10 | \n", "2019-06-18 12:53:00 | \n", "2019-06-01 | \n", "2019-06-01 | \n", "
356016 | \n", "567981 | \n", "21243 | \n", "PINK POLKADOT PLATE | \n", "2 | \n", "2019-09-21 11:22:00 | \n", "3.29 | \n", "0 | \n", "6.58 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-09-01 | \n", "
108005 | \n", "545475 | \n", "21094 | \n", "SET/6 RED SPOTTY PAPER PLATES | \n", "96 | \n", "2019-03-01 10:59:00 | \n", "0.64 | \n", "12415 | \n", "61.44 | \n", "2019-01-04 11:12:00 | \n", "2019-01-01 | \n", "2019-03-01 | \n", "
169573 | \n", "551193 | \n", "21746 | \n", "SMALL RED RETROSPOT WINDMILL | \n", "4 | \n", "2019-04-25 11:05:00 | \n", "1.25 | \n", "17954 | \n", "5.00 | \n", "2018-12-01 14:18:00 | \n", "2018-12-01 | \n", "2019-04-01 | \n", "
381698 | \n", "569887 | \n", "23356 | \n", "LOVE HOT WATER BOTTLE | \n", "3 | \n", "2019-10-04 15:28:00 | \n", "5.95 | \n", "13882 | \n", "17.85 | \n", "2019-10-04 15:28:00 | \n", "2019-10-01 | \n", "2019-10-01 | \n", "
345057 | \n", "567140 | \n", "22429 | \n", "ENAMEL MEASURING JUG CREAM | \n", "8 | \n", "2019-09-14 14:47:00 | \n", "4.25 | \n", "15410 | \n", "34.00 | \n", "2019-03-21 10:15:00 | \n", "2019-03-01 | \n", "2019-09-01 | \n", "
74959 | \n", "542536 | \n", "20677 | \n", "PINK POLKADOT BOWL | \n", "2 | \n", "2019-01-26 13:37:00 | \n", "2.46 | \n", "0 | \n", "4.92 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-01-01 | \n", "
324195 | \n", "565396 | \n", "22111 | \n", "SCOTTIE DOG HOT WATER BOTTLE | \n", "1 | \n", "2019-08-31 16:39:00 | \n", "10.79 | \n", "0 | \n", "10.79 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-08-01 | \n", "
344584 | \n", "567085 | \n", "20750 | \n", "RED RETROSPOT MINI CASES | \n", "2 | \n", "2019-09-14 12:38:00 | \n", "7.95 | \n", "12434 | \n", "15.90 | \n", "2018-12-12 11:12:00 | \n", "2018-12-01 | \n", "2019-09-01 | \n", "
70938 | \n", "542107 | \n", "22720 | \n", "SET OF 3 CAKE TINS PANTRY DESIGN | \n", "1 | \n", "2019-01-23 13:38:00 | \n", "4.95 | \n", "16222 | \n", "4.95 | \n", "2019-01-23 13:38:00 | \n", "2019-01-01 | \n", "2019-01-01 | \n", "
497703 | \n", "578463 | \n", "23368 | \n", "SET 12 COLOUR PENCILS DOLLY GIRL | \n", "16 | \n", "2019-11-22 12:30:00 | \n", "0.65 | \n", "12757 | \n", "10.40 | \n", "2019-05-10 19:01:00 | \n", "2019-05-01 | \n", "2019-11-01 | \n", "
155172 | \n", "549975 | \n", "20702 | \n", "PINK PADDED MOBILE | \n", "3 | \n", "2019-04-11 14:38:00 | \n", "4.25 | \n", "16175 | \n", "12.75 | \n", "2019-04-11 14:38:00 | \n", "2019-04-01 | \n", "2019-04-01 | \n", "
66050 | \n", "541711 | \n", "21976 | \n", "PACK OF 60 MUSHROOM CAKE CASES | \n", "120 | \n", "2019-01-19 11:18:00 | \n", "0.42 | \n", "14646 | \n", "50.40 | \n", "2018-12-18 10:09:00 | \n", "2018-12-01 | \n", "2019-01-01 | \n", "
496587 | \n", "578347 | \n", "20782 | \n", "CAMOUFLAGE EAR MUFF HEADPHONES | \n", "1 | \n", "2019-11-22 09:26:00 | \n", "10.79 | \n", "0 | \n", "10.79 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-11-01 | \n", "
422173 | \n", "573068 | \n", "22728 | \n", "ALARM CLOCK BAKELIKE PINK | \n", "2 | \n", "2019-10-25 13:56:00 | \n", "3.75 | \n", "17545 | \n", "7.50 | \n", "2019-10-25 13:48:00 | \n", "2019-10-01 | \n", "2019-10-01 | \n", "
433204 | \n", "573905 | \n", "23254 | \n", "CHILDRENS CUTLERY DOLLY GIRL | \n", "1 | \n", "2019-10-30 15:06:00 | \n", "4.15 | \n", "16971 | \n", "4.15 | \n", "2019-10-30 15:06:00 | \n", "2019-10-01 | \n", "2019-10-01 | \n", "
188251 | \n", "553017 | \n", "20676 | \n", "RED RETROSPOT BOWL | \n", "5 | \n", "2019-05-10 19:01:00 | \n", "1.25 | \n", "12757 | \n", "6.25 | \n", "2019-05-10 19:01:00 | \n", "2019-05-01 | \n", "2019-05-01 | \n", "
359141 | \n", "568177 | \n", "23366 | \n", "SET 12 COLOURING PENCILS DOILY | \n", "16 | \n", "2019-09-23 13:30:00 | \n", "0.65 | \n", "13536 | \n", "10.40 | \n", "2019-09-23 13:30:00 | \n", "2019-09-01 | \n", "2019-09-01 | \n", "
109457 | \n", "545638 | \n", "21430 | \n", "SET/3 RED GINGHAM ROSE STORAGE BOX | \n", "24 | \n", "2019-03-02 12:26:00 | \n", "3.39 | \n", "13113 | \n", "81.36 | \n", "2018-12-06 13:07:00 | \n", "2018-12-01 | \n", "2019-03-01 | \n", "
228587 | \n", "556932 | \n", "21422 | \n", "PORCELAIN ROSE SMALL | \n", "1 | \n", "2019-06-13 15:41:00 | \n", "1.63 | \n", "0 | \n", "1.63 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-06-01 | \n", "
387833 | \n", "570388 | \n", "22045 | \n", "SPACEBOY GIFT WRAP | \n", "25 | \n", "2019-10-08 12:37:00 | \n", "0.42 | \n", "14911 | \n", "10.50 | \n", "2018-11-29 14:05:00 | \n", "2018-11-01 | \n", "2019-10-01 | \n", "
500771 | \n", "578808 | \n", "21775 | \n", "DECORATIVE FLORE BATHROOM BOTTLE | \n", "3 | \n", "2019-11-23 13:23:00 | \n", "1.25 | \n", "16327 | \n", "3.75 | \n", "2018-12-03 12:43:00 | \n", "2018-12-01 | \n", "2019-11-01 | \n", "
128726 | \n", "547358 | \n", "21086 | \n", "SET/6 RED SPOTTY PAPER CUPS | \n", "4 | \n", "2019-03-20 12:25:00 | \n", "0.65 | \n", "15998 | \n", "2.60 | \n", "2018-12-10 13:32:00 | \n", "2018-12-01 | \n", "2019-03-01 | \n", "
182346 | \n", "552539 | \n", "21175 | \n", "GIN + TONIC DIET METAL SIGN | \n", "12 | \n", "2019-05-08 10:17:00 | \n", "2.55 | \n", "0 | \n", "30.60 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-05-01 | \n", "
348661 | \n", "567461 | \n", "21239 | \n", "PINK POLKADOT CUP | \n", "3 | \n", "2019-09-18 12:31:00 | \n", "1.63 | \n", "0 | \n", "4.89 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-09-01 | \n", "
66421 | \n", "541794 | \n", "22327 | \n", "ROUND SNACK BOXES SET OF 4 SKULLS | \n", "1 | \n", "2019-01-19 13:21:00 | \n", "2.95 | \n", "17238 | \n", "2.95 | \n", "2018-12-01 15:05:00 | \n", "2018-12-01 | \n", "2019-01-01 | \n", "
505691 | \n", "579094 | \n", "22326 | \n", "ROUND SNACK BOXES SET OF4 WOODLAND | \n", "6 | \n", "2019-11-26 10:56:00 | \n", "2.95 | \n", "12668 | \n", "17.70 | \n", "2018-12-17 12:46:00 | \n", "2018-12-01 | \n", "2019-11-01 | \n", "
507164 | \n", "579167 | \n", "23333 | \n", "IVORY WICKER HEART MEDIUM | \n", "6 | \n", "2019-11-26 14:06:00 | \n", "1.25 | \n", "16800 | \n", "7.50 | \n", "2019-11-26 14:06:00 | \n", "2019-11-01 | \n", "2019-11-01 | \n", "
19895 | \n", "537900 | \n", "85172 | \n", "HYACINTH BULB T-LIGHT CANDLES | \n", "32 | \n", "2018-12-07 10:45:00 | \n", "0.42 | \n", "15983 | \n", "13.44 | \n", "2018-11-29 12:15:00 | \n", "2018-11-01 | \n", "2018-12-01 | \n", "
227657 | \n", "556890 | \n", "21929 | \n", "JUMBO BAG PINK VINTAGE PAISLEY | \n", "20 | \n", "2019-06-13 12:48:00 | \n", "2.08 | \n", "17581 | \n", "41.60 | \n", "2018-11-30 14:47:00 | \n", "2018-11-01 | \n", "2019-06-01 | \n", "
421536 | \n", "572997 | \n", "21803 | \n", "CHRISTMAS TREE STAR DECORATION | \n", "36 | \n", "2019-10-25 11:24:00 | \n", "0.42 | \n", "17878 | \n", "15.12 | \n", "2019-10-25 11:24:00 | \n", "2019-10-01 | \n", "2019-10-01 | \n", "
493910 | \n", "578255 | \n", "21985 | \n", "PACK OF 12 HEARTS DESIGN TISSUES | \n", "5 | \n", "2019-11-21 12:58:00 | \n", "0.39 | \n", "14675 | \n", "1.95 | \n", "2019-11-21 12:58:00 | \n", "2019-11-01 | \n", "2019-11-01 | \n", "
388167 | \n", "570420 | \n", "82580 | \n", "BATHROOM METAL SIGN | \n", "1 | \n", "2019-10-08 13:33:00 | \n", "0.55 | \n", "17841 | \n", "0.55 | \n", "2018-11-29 14:30:00 | \n", "2018-11-01 | \n", "2019-10-01 | \n", "
69335 | \n", "541969 | \n", "22169 | \n", "FAMILY ALBUM WHITE PICTURE FRAME | \n", "1 | \n", "2019-01-22 13:46:00 | \n", "16.63 | \n", "0 | \n", "16.63 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-01-01 | \n", "
161596 | \n", "550477 | \n", "22378 | \n", "WALL TIDY RETROSPOT | \n", "3 | \n", "2019-04-16 14:01:00 | \n", "2.10 | \n", "17338 | \n", "6.30 | \n", "2018-12-11 12:57:00 | \n", "2018-12-01 | \n", "2019-04-01 | \n", "
380764 | \n", "569834 | \n", "22554 | \n", "PLASTERS IN TIN WOODLAND ANIMALS | \n", "12 | \n", "2019-10-04 13:00:00 | \n", "1.65 | \n", "14383 | \n", "19.80 | \n", "2019-06-27 10:18:00 | \n", "2019-06-01 | \n", "2019-10-01 | \n", "
460699 | \n", "575930 | \n", "21174 | \n", "POTTERING IN THE SHED METAL SIGN | \n", "1 | \n", "2019-11-09 17:58:00 | \n", "4.13 | \n", "0 | \n", "4.13 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-11-01 | \n", "
443118 | \n", "574690 | \n", "22664 | \n", "TOY TIDY DOLLY GIRL DESIGN | \n", "5 | \n", "2019-11-04 13:11:00 | \n", "2.10 | \n", "12638 | \n", "10.50 | \n", "2019-11-04 13:11:00 | \n", "2019-11-01 | \n", "2019-11-01 | \n", "
120930 | \n", "546684 | \n", "21535 | \n", "RED RETROSPOT SMALL MILK JUG | \n", "24 | \n", "2019-03-14 09:47:00 | \n", "2.55 | \n", "16152 | \n", "61.20 | \n", "2019-03-14 09:47:00 | \n", "2019-03-01 | \n", "2019-03-01 | \n", "
160687 | \n", "550468 | \n", "22549 | \n", "PICTURE DOMINOES | \n", "12 | \n", "2019-04-16 13:43:00 | \n", "1.45 | \n", "16700 | \n", "17.40 | \n", "2018-12-06 16:34:00 | \n", "2018-12-01 | \n", "2019-04-01 | \n", "
406636 | \n", "571824 | \n", "23494 | \n", "VINTAGE DOILY DELUXE SEWING KIT | \n", "3 | \n", "2019-10-17 11:49:00 | \n", "5.95 | \n", "12472 | \n", "17.85 | \n", "2018-11-29 14:33:00 | \n", "2018-11-01 | \n", "2019-10-01 | \n", "
539936 | \n", "581450 | \n", "22720 | \n", "SET OF 3 CAKE TINS PANTRY DESIGN | \n", "3 | \n", "2019-12-06 17:54:00 | \n", "4.95 | \n", "16794 | \n", "14.85 | \n", "2019-06-10 14:15:00 | \n", "2019-06-01 | \n", "2019-12-01 | \n", "
516546 | \n", "579927 | \n", "22984 | \n", "CARD GINGHAM ROSE | \n", "12 | \n", "2019-11-29 09:20:00 | \n", "0.42 | \n", "12572 | \n", "5.04 | \n", "2019-10-17 08:20:00 | \n", "2019-10-01 | \n", "2019-11-01 | \n", "
123219 | \n", "546892 | \n", "22241 | \n", "GARLAND WOODEN HAPPY EASTER | \n", "1 | \n", "2019-03-15 18:20:00 | \n", "2.46 | \n", "0 | \n", "2.46 | \n", "2018-11-29 14:32:00 | \n", "2018-11-01 | \n", "2019-03-01 | \n", "
\n", " | num_of_orders | \n", "num_of_customers | \n", "sales_total | \n", "
---|---|---|---|
first_order_month | \n", "\n", " | \n", " | \n", " |
2018-11-01 | \n", "4533 | \n", "205 | \n", "2.791599e+06 | \n", "
2018-12-01 | \n", "7012 | \n", "743 | \n", "3.109304e+06 | \n", "
2019-01-01 | \n", "2821 | \n", "473 | \n", "1.075818e+06 | \n", "
2019-02-01 | \n", "1692 | \n", "365 | \n", "5.095876e+05 | \n", "
2019-03-01 | \n", "1735 | \n", "414 | \n", "5.661178e+05 | \n", "
2019-04-01 | \n", "989 | \n", "285 | \n", "2.895956e+05 | \n", "
2019-05-01 | \n", "936 | \n", "291 | \n", "2.784896e+05 | \n", "
2019-06-01 | \n", "703 | \n", "225 | \n", "2.063646e+05 | \n", "
2019-07-01 | \n", "530 | \n", "201 | \n", "1.591624e+05 | \n", "
2019-08-01 | \n", "392 | \n", "162 | \n", "1.625227e+05 | \n", "
2019-09-01 | \n", "675 | \n", "289 | \n", "2.186757e+05 | \n", "
2019-10-01 | \n", "707 | \n", "376 | \n", "2.162994e+05 | \n", "
2019-11-01 | \n", "432 | \n", "302 | \n", "1.319079e+05 | \n", "
2019-12-01 | \n", "34 | \n", "31 | \n", "2.457762e+04 | \n", "
order_month | \n", "2018-11-01 | \n", "2018-12-01 | \n", "2019-01-01 | \n", "2019-02-01 | \n", "2019-03-01 | \n", "2019-04-01 | \n", "2019-05-01 | \n", "2019-06-01 | \n", "2019-07-01 | \n", "2019-08-01 | \n", "2019-09-01 | \n", "2019-10-01 | \n", "2019-11-01 | \n", "2019-12-01 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
first_order_month | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2018-11-01 | \n", "205.0 | \n", "93.0 | \n", "80.0 | \n", "70.0 | \n", "77.0 | \n", "79.0 | \n", "83.0 | \n", "81.0 | \n", "72.0 | \n", "76.0 | \n", "81.0 | \n", "80.0 | \n", "99.0 | \n", "39.0 | \n", "
2018-12-01 | \n", "NaN | \n", "743.0 | \n", "295.0 | \n", "236.0 | \n", "289.0 | \n", "250.0 | \n", "298.0 | \n", "264.0 | \n", "263.0 | \n", "261.0 | \n", "280.0 | \n", "296.0 | \n", "387.0 | \n", "161.0 | \n", "
2019-01-01 | \n", "NaN | \n", "NaN | \n", "473.0 | \n", "110.0 | \n", "130.0 | \n", "113.0 | \n", "157.0 | \n", "134.0 | \n", "127.0 | \n", "126.0 | \n", "141.0 | \n", "158.0 | \n", "177.0 | \n", "45.0 | \n", "
2019-02-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "365.0 | \n", "90.0 | \n", "66.0 | \n", "103.0 | \n", "99.0 | \n", "86.0 | \n", "85.0 | \n", "100.0 | \n", "99.0 | \n", "110.0 | \n", "24.0 | \n", "
2019-03-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "414.0 | \n", "77.0 | \n", "110.0 | \n", "83.0 | \n", "103.0 | \n", "78.0 | \n", "102.0 | \n", "107.0 | \n", "113.0 | \n", "32.0 | \n", "
2019-04-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "285.0 | \n", "65.0 | \n", "61.0 | \n", "62.0 | \n", "58.0 | \n", "66.0 | \n", "66.0 | \n", "78.0 | \n", "17.0 | \n", "
2019-05-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "291.0 | \n", "67.0 | \n", "49.0 | \n", "49.0 | \n", "62.0 | \n", "72.0 | \n", "84.0 | \n", "15.0 | \n", "
2019-06-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "225.0 | \n", "50.0 | \n", "43.0 | \n", "58.0 | \n", "60.0 | \n", "72.0 | \n", "14.0 | \n", "
2019-07-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "201.0 | \n", "45.0 | \n", "40.0 | \n", "47.0 | \n", "55.0 | \n", "19.0 | \n", "
2019-08-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "162.0 | \n", "34.0 | \n", "43.0 | \n", "47.0 | \n", "16.0 | \n", "
2019-09-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "289.0 | \n", "88.0 | \n", "97.0 | \n", "31.0 | \n", "
2019-10-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "376.0 | \n", "104.0 | \n", "37.0 | \n", "
2019-11-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "302.0 | \n", "23.0 | \n", "
2019-12-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "31.0 | \n", "
\n", " | \n", " | revenue | \n", "num_of_customers | \n", "
---|---|---|---|
first_order_month | \n", "order_month | \n", "\n", " | \n", " |
2018-11-01 | \n", "2018-11-01 | \n", "103249.92 | \n", "205 | \n", "
2018-12-01 | \n", "288927.89 | \n", "93 | \n", "|
2019-01-01 | \n", "201104.98 | \n", "80 | \n", "|
2019-02-01 | \n", "122481.67 | \n", "70 | \n", "|
2019-03-01 | \n", "188820.36 | \n", "77 | \n", "|
2019-04-01 | \n", "110959.43 | \n", "79 | \n", "|
2019-05-01 | \n", "181814.92 | \n", "83 | \n", "|
2019-06-01 | \n", "159306.76 | \n", "81 | \n", "|
2019-07-01 | \n", "198619.92 | \n", "72 | \n", "|
2019-08-01 | \n", "185200.43 | \n", "76 | \n", "
\n", " | \n", " | revenue | \n", "num_of_customers | \n", "revenue_per_customer | \n", "
---|---|---|---|---|
first_order_month | \n", "order_month | \n", "\n", " | \n", " | \n", " |
2018-11-01 | \n", "2018-11-01 | \n", "103249.92 | \n", "205 | \n", "503.658146 | \n", "
2018-12-01 | \n", "288927.89 | \n", "93 | \n", "3106.751505 | \n", "|
2019-01-01 | \n", "201104.98 | \n", "80 | \n", "2513.812250 | \n", "|
2019-02-01 | \n", "122481.67 | \n", "70 | \n", "1749.738143 | \n", "|
2019-03-01 | \n", "188820.36 | \n", "77 | \n", "2452.212468 | \n", "
order_month | \n", "2018-11-01 | \n", "2018-12-01 | \n", "2019-01-01 | \n", "2019-02-01 | \n", "2019-03-01 | \n", "2019-04-01 | \n", "2019-05-01 | \n", "2019-06-01 | \n", "2019-07-01 | \n", "2019-08-01 | \n", "2019-09-01 | \n", "2019-10-01 | \n", "2019-11-01 | \n", "2019-12-01 | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
first_order_month | \n", "\n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " | \n", " |
2018-11-01 | \n", "503.658146 | \n", "3106.751505 | \n", "2513.812250 | \n", "1749.738143 | \n", "2452.212468 | \n", "1404.549747 | \n", "2190.541205 | \n", "1966.750123 | \n", "2758.610000 | \n", "2436.847763 | \n", "2428.364198 | \n", "2969.289125 | \n", "4946.200505 | \n", "3261.504359 | \n", "
2018-12-01 | \n", "NaN | \n", "493.394118 | \n", "691.084339 | \n", "696.352712 | \n", "723.754533 | \n", "567.085600 | \n", "841.306879 | \n", "815.689356 | \n", "803.970722 | \n", "970.578123 | \n", "1109.974214 | \n", "1124.566791 | \n", "914.069871 | \n", "592.175280 | \n", "
2019-01-01 | \n", "NaN | \n", "NaN | \n", "469.320825 | \n", "514.782636 | \n", "502.203846 | \n", "419.405398 | \n", "617.751720 | \n", "585.060448 | \n", "603.758898 | \n", "684.126746 | \n", "535.173830 | \n", "746.551392 | \n", "745.179718 | \n", "465.561333 | \n", "
2019-02-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "413.594548 | \n", "280.583778 | \n", "460.032727 | \n", "425.118544 | \n", "322.990606 | \n", "374.810000 | \n", "453.589647 | \n", "494.392500 | \n", "468.381010 | \n", "508.164182 | \n", "197.993333 | \n", "
2019-03-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "416.745749 | \n", "301.293117 | \n", "523.536818 | \n", "430.806145 | \n", "480.659709 | \n", "541.381282 | \n", "532.999216 | \n", "600.243271 | \n", "523.734690 | \n", "235.308125 | \n", "
2019-04-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "393.485758 | \n", "380.790769 | \n", "363.614590 | \n", "331.168387 | \n", "368.477759 | \n", "392.663030 | \n", "416.196667 | \n", "400.702436 | \n", "233.914118 | \n", "
2019-05-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "412.786632 | \n", "268.635224 | \n", "401.065714 | \n", "346.586327 | \n", "443.159839 | \n", "472.353750 | \n", "443.804524 | \n", "331.350000 | \n", "
2019-06-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "382.773289 | \n", "285.003400 | \n", "284.189070 | \n", "475.182931 | \n", "425.922500 | \n", "506.441667 | \n", "299.322857 | \n", "
2019-07-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "440.266323 | \n", "241.316444 | \n", "406.657250 | \n", "399.262766 | \n", "364.312182 | \n", "249.515789 | \n", "
2019-08-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "399.519630 | \n", "458.548235 | \n", "740.920000 | \n", "838.770000 | \n", "683.005000 | \n", "
2019-09-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "511.196647 | \n", "301.554659 | \n", "347.474021 | \n", "345.099677 | \n", "
2019-10-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "426.481170 | \n", "442.203942 | \n", "269.008378 | \n", "
2019-11-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "418.951126 | \n", "234.117391 | \n", "
2019-12-01 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "792.826452 | \n", "
\n", " | first_order_month | \n", "order_month | \n", "revenue | \n", "num_of_customers | \n", "revenue_per_customer | \n", "cohort_lifetime | \n", "
---|---|---|---|---|---|---|
0 | \n", "2018-11 | \n", "2018-11-01 | \n", "103249.92 | \n", "205 | \n", "503.658146 | \n", "0 | \n", "
1 | \n", "2018-11 | \n", "2018-12-01 | \n", "288927.89 | \n", "93 | \n", "3106.751505 | \n", "1 | \n", "
2 | \n", "2018-11 | \n", "2019-01-01 | \n", "201104.98 | \n", "80 | \n", "2513.812250 | \n", "2 | \n", "
3 | \n", "2018-11 | \n", "2019-02-01 | \n", "122481.67 | \n", "70 | \n", "1749.738143 | \n", "3 | \n", "
4 | \n", "2018-11 | \n", "2019-03-01 | \n", "188820.36 | \n", "77 | \n", "2452.212468 | \n", "4 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
100 | \n", "2019-10 | \n", "2019-11-01 | \n", "45989.21 | \n", "104 | \n", "442.203942 | \n", "1 | \n", "
101 | \n", "2019-10 | \n", "2019-12-01 | \n", "9953.31 | \n", "37 | \n", "269.008378 | \n", "2 | \n", "
102 | \n", "2019-11 | \n", "2019-11-01 | \n", "126523.24 | \n", "302 | \n", "418.951126 | \n", "0 | \n", "
103 | \n", "2019-11 | \n", "2019-12-01 | \n", "5384.70 | \n", "23 | \n", "234.117391 | \n", "1 | \n", "
104 | \n", "2019-12 | \n", "2019-12-01 | \n", "24577.62 | \n", "31 | \n", "792.826452 | \n", "0 | \n", "
105 rows × 6 columns
\n", "\n", " | customer_id | \n", "invoice_no | \n", "unit_price | \n", "total_price | \n", "
---|---|---|---|---|
0 | \n", "0 | \n", "1410 | \n", "4.468638 | \n", "1506879.59 | \n", "
1 | \n", "12347 | \n", "7 | \n", "2.644011 | \n", "4310.00 | \n", "
2 | \n", "12348 | \n", "4 | \n", "0.692963 | \n", "1437.24 | \n", "
3 | \n", "12349 | \n", "1 | \n", "4.237500 | \n", "1457.55 | \n", "
4 | \n", "12350 | \n", "1 | \n", "1.581250 | \n", "294.40 | \n", "
\n", " | customer_id | \n", "invoice_no | \n", "unit_price | \n", "total_price | \n", "
---|---|---|---|---|
count | \n", "4362.00000 | \n", "4362.000000 | \n", "4362.000000 | \n", "4.362000e+03 | \n", "
mean | \n", "15297.41105 | \n", "5.316598 | \n", "3.406677 | \n", "2.232926e+03 | \n", "
std | \n", "1736.71147 | \n", "23.134383 | \n", "5.973947 | \n", "2.423915e+04 | \n", "
min | \n", "0.00000 | \n", "1.000000 | \n", "0.122500 | \n", "-1.192200e+03 | \n", "
25% | \n", "13814.25000 | \n", "1.000000 | \n", "2.171436 | \n", "2.930250e+02 | \n", "
50% | \n", "15299.50000 | \n", "3.000000 | \n", "2.845251 | \n", "6.432150e+02 | \n", "
75% | \n", "16777.75000 | \n", "5.000000 | \n", "3.740464 | \n", "1.584745e+03 | \n", "
max | \n", "18287.00000 | \n", "1410.000000 | \n", "295.000000 | \n", "1.506880e+06 | \n", "