Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

If i have such a set of data, how can i get the top 5 days in which the most orders were placed using python?

If i have such a set of data, how can i get the top 5 days in which the most orders were placed using python? image text in transcribed
image text in transcribed
Format Painter Clipboard -A General lili Merge a Center Font $ - % * Conditional Form Formatting to K1163 Alignment > Number B 1 Invoice Stock Code Description C 2 536365 85123A WHITE HANGING HEART T-UGHT HOLDER 3 536365 71053 WHITE METAL LANTERN 4 536365 844068 CREAM CUPID HEARTS COAT HANGER 5 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 536365 84029 RED WOOLLY HOTTIE WHITE HEART 7 536365 22752 SET 7 BABUSHKA NESTING BOXES 8 536365 21730 GLASS STAR FROSTEDT LIGHT HOLDER 9 536366 22633 HAND WARMER UNION JACK 10 535366 22632 HAND WARMER RED POLKA DOT 11 536368 22960 JAM MAKING SET WITH JARS 12 536368 22913 RED COAT RACK PARIS FASHION 13 536368 22912 YELLOW COAT RACK DARIS FASHION 14 536368 22914 BLUE COAT RACK PARIS FASHION 15 536367 34879 ASSORTED COLOUR BIRD ORNAMENT 16 536367 22745 POPPY'S PLAYHOUSE BEDROOM 17 536367 22748 POPPY'S PLAYHOUSE KITCHEN 18 536367 22749 FELTCRAFT PRINCESS CHARLOTTE DOLL 19 536367 22310 IVORY KNITTED MUG COSY 20 536367 84969 BOX OF 6 ASSORTED COLOUR TEASPOONS 21 536367 22623 BOX OF VINTAGE JIGSAW BLOCKS 22 536367 22622 BOX OF VINTAGE ALPHABET BLOCKS 23 536367 21754 HOME BUILDING BLOCK WORD 24 536367 21755 LOVE BULDING BLOCK WORD 25 536367 21777 RECIPE BOX WITH METAL HEART 26 536367 48187 DOORMAT NEW ENGLAND 27 536369 21756 BATH BUILDING BLOCK WORD 28 536370 22728 ALARM CLOCK BAKELIKE PINK 29 526370 22727 ALARM CLOCK BAKELIKE RED 30 536370 22726 ALARM CLOCK BAKELIKE GREEN 31 535370 21724 PANDA AND BUNNIES STICKER SHEET 32 536370 21883 STARS GIFT TAPE 33 536370 10002 INFLATABLE POLITICAL GLOBE 536370 21791 VINTAGE HEADS AND TAILS CARO GAME 35 536370 21035 SET/2 RED RETROSPOT TEA TOWELS 536370 22326 ROUND SNACK BOXES SET OF WOODLAND az 53670 22629 SPACEROY LUNCH BOX 38 536370 22659 LUNCH BOX I LOVE LONDON Year 2010 2011 D G H Quantity InvoiceDate 1 Price Customer Country 6 12/1/2010 8:26 2,35 17850 United Kingdom 6 12/1/2010 8:26 3.39 17850 United Kingdom 8 12/1/2010 8:26 2.75 17850 United Kingdom 6 12/1/2010 8:26 3.39 17850 United Kingdom 6 12/1/2010 8:26 1.39 17850 United Kingdom 2 12/1/2010 8:26 7.65 17850 United Kingdom 6 12/1/2010 8:26 4.25 17850 United Kingdom 6 12/1/2010 8:28 1.85 17850 United Kingdom 6 12/1/2010 8:28 1.85 17850 United Kingdom 6 12/1/2010 8:34 4.25 13047 United Kingdom 3 12/1/2010 8:34 4.95 13047 United Kingdom 3 12/1/2010 8:34 4.95 13047 United Kingdom 3 12/1/2010 2:34 4.95 13017 United Kingdom 32 12/1/2010 8:34 1.09 11047 United Kingdom 12/1/20108:31 2.1 11047 United Kingdom 6 12/1/2010 2.1 11047 United Kingdom # 12/1/2010 11:34 3.5 11017 United Kingdom 6 12/1/2010 3:14 1.65 13047 United Kingdom 0 12/1/2010 8:34 4.25 13017 United Kingdom 2 12/1/2010 8:34 4.95 13047 United Kingdom 2 12/1/2010 8:34 9.95 11017 United Kingdom 1 12/1/2010 8:34 5.95 13017 United Kingdom 3 12/1/2010 14 5.95 1.3047 United Kingdom 4 12/1/2010 8:14 7.95 13017 United Kingdom 4 17/1/2010 8:34 7.95 13047 United Kingdom 17/1/2010 8:35 5.95 13047 United Kingdom 24 12/1/2010 8.45 1.25 12583 France 24 12/1/2010845 3.25 1250 France 12 12/1/2010 8:45 3.79 12583 France 12/11/2010 45 0.85 125) France 24 12/1/2010 8:45 0.66 125 France 12/1/2010 8:45 12583 France 24 12/1/2010 8 1.25 1252 France 12/1/2010 16:45 2.5 12583 France 24 12/1/2010 8:45 2.95 12583 France 24 12/1/2010 8.45 1.35 12583 France 24 12/1/2010 8:45 12583 France L9 Number K1163 13 B c 1 Invoice Stock Code Description 2 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 3 536365 21053 WHITE METAL LANTERN 4 536365 84406B CREAM CUPID HEARTS COAT HANGER 5 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 6 536365 34029 RED WOOLLY HOTTIE WHITE HEART. 7 536365 22752 SET 7 BABUSHKA NESTING BOXES 8 536365 21730 GLASS STAR FROSTEDT-LIGHT HOLDER 9 536366 22633 HAND WARMER UNION JACK 10 536366 22632 HAND WARMER RED POLKA DOT 11 536368 22960 JAM MAKING SET WITH JARS 12 536368 22913 RED COAT RACK PARIS FASHION 536368 22912 YELLOW COAT RACK PARIS FASHION 14 536368 22914 BLUE COAT RACK PARIS FASHION 15 536367 34879 ASSORTED COLOUR BIRD ORNAMENT 15 536267 22745 POPPY'S PLAYHOUSE BEDROOM 17 536367 22748 POPPY'S PLAYHOUSE KITCHEN 18 536367 22749 FELTCRAFT PRINCESS CHARLOTTE DOLL 19 536367 22210 IVORY KNITTED MUG COSY 20 536367 84969 BOX OF 6 ASSORTED COLOUR TEASPOONS 21 536367 22623 BOX OF VINTAGE NIGSAW ILOCKS 22 586367 22622 BOX OF VINTAGE ALPHABET BLOCKS 29 530307 21754 HOME BUILDING BLOCK WORD 24 536367 21755 LOVE BUILDING BLOCK WORD 536307 21777 RECIPE BOX WITH METAL HEART 536167 4117 DOORMAT NEW ENGLAND 21 53000 21756 BATH BUILDING BLOCK WORD 516370 22725 ALARM CLOCK BAKELIKE PINK 516320 22727 ALARM CLOCK BAKELIKE RED 30 516870 22726 ALARM CLOCK BAKELIKE GREEN 31 536320 21724 PANDA AND BUNNIES STICKER SHEET 312 536170 21883 STARS GIFT TAPE 33 536370 10002 INFLATABLE POLITICAL GLOBE 1 5110 21791 VINTAGE HEADS AND TAILS CARD GAME 536170 21035 SET/2 RED FETROSPOT TEA TOWELS 36 536170 22326 ROUND SNACK BOXES SET OF A WOODLAND 27 536570 22629 SPACEROY LUNCH BOX 536310 22659 LUNCH BOXILOVE LONDON D F Quantity InvoiceDate Price 6 12/1/2010 8:26 2255 6 12/1/2010 8:26 3.39 8 12/1/2010 8:26 2.75 6 12/1/2010 8:20 3.39 6 12/1/2010 8:26 3.39 2 12/1/2010 8:20 7.65 6 12/1/2010 8:26 4.25 6 12/1/2010 8:28 185 6 12/1/2010 8:28 1.85 5 12/1/20108:34 4.25 3 12/1/2010 8:34 4.95 3 12/1/2010 8:34 4.95 3 12/1/2010 8:24 4.95 32 12/1/20108:14 1.69 6 12/1/2010 8:34 2.1 6 12/1/2010 8:34 2.1 8 12/1/2010 8:34 3.75 6 12/1/2010 8:14 12/1/20108:34 4.25 1 12/1/2010 2014 4.95 12/1/2010 8:34 3.95 3 12/1/2010 5.85 12/1/2010 3.95 4 12/1/2010 7.95 4 12/1/2010 : 7.95 1 12/1/2010 5.95 24 12/1/2010 1245 1.75 24 12/1/2010 11:45 1.75 12 17/1/2010 8:45 3.75 12 12/1/2010 15 0015 24 13/1/2010 11:45 01.09 4 12/1/2010 8.45 0.85 24 12/1/2010 145 18 12/1/2010 24 22/1/2010 45 M 12/1/M1045 19 M 1.95 13/1/30104 H Customer Country 17850 United Kingdom 17850 United Kingdom 17850 United Kingdom 17850 United Kingdom 17850 United Kingdom 17850 United Kingdom 17850 United Kingdom 17850 United Kingdom 17850 United Kingdom 11047 United Kingdom 17047 United Kingdom 1707 United Kingdom 13047 United Kingdom 2017 United Kingdom 13047 United Kingdom 13047 United Kingdom 13017 United Kingdom 13047 United Kingdom 13047 United Kingdom 13017 United Kingdom 13047 United Kingdom 13047 United Kingdom 11042 nited Kingdom 13047 United Kingdom 11017 United Kingdom 16047 United Kingdom 12583 France 125.83 France 12583 France 1250 France 12 France 125 France 135 France 125 France 1253 France 12 France 12583 France 1.65

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Security

Authors: Alfred Basta, Melissa Zgola

1st Edition

1435453905, 978-1435453906

More Books

Students also viewed these Databases questions