Amazon wants to reward the customer who has done the most number of transactions, by providing a gift hamper worth 1000 pesos. Find out the customer who has done the most number of transactions [Note: One invoice number corresponds to one transaction]. The output should the one as below: Hurray! The most number of transactions is done by Customer I0: 17850. He has made 45 transactions. He will be rewarded with ou gift hanper worth 1000 pesos

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
Task-2:
Amazon wants to reward the customer who has done the most number of
transactions, by providing a gift hamper worth 1000 pesos.
Find out the customer who has done the most number of transactions [Note: One
invoice number corresponds to one transaction]. The output should the one as
below:
Hurray! The most number of transactions is done by Customer ID: 17850. He has made 45 transactions. He will be rewarded with ou
gift hamper worth 1000 pesos
Transcribed Image Text:Task-2: Amazon wants to reward the customer who has done the most number of transactions, by providing a gift hamper worth 1000 pesos. Find out the customer who has done the most number of transactions [Note: One invoice number corresponds to one transaction]. The output should the one as below: Hurray! The most number of transactions is done by Customer ID: 17850. He has made 45 transactions. He will be rewarded with ou gift hamper worth 1000 pesos
In (26):
1 Datal.head(2e0)
Out[26]:
Desoription Guantity
InvoloeDate UnitPrloe CuctomeriD
Country
InvoloeNo stookCode
85123A
WHITE HANGING HEART T-LIGHT HOLDER
01/12/2010 826
2.55
17850.0 Untad Kingdom
536360
6 O/12/2010 826
17850.0 Untad Kingdom
1
71053
WHITE METAL LANTERN
3.39
536366
8 O/12/2010 826
17850.0 Unted Kingdom
2
8440EB
CREAM CUPID HEARTS COAT HANGER
2.75
6 01/12/201O 826
17800.0 United Kingdom
536366
84029G KNITTED UNION FLAG HOT WATER BOTTLE
3.39
536366
8402SE
RED WOOLLY HOTTIE WHITE HEART.
6 O1/12/2010 826
3.39
17850.0 Unted Kingdom
***
***
***
186
536388
22469
HEART OF WICKER SMALL
12 0/12/2010 9.59
1.65
16250.0 Unted Kingdom
5 HOCK HANGER MAGIC TOADSTOCOL
16250.0 Unted Kingdom
188
536388
22242
12
01/12/2010 9.59
1.65
187
536389
22941
CHRISTMAS LIGHTS 10 REINDEER
6 01/12/2010 10:03
8.50
12431.0
Australia
188
536389
21622
VINTAGE UNION JACK CUSHION COVER
8 01/12/2010 10:03
4.95
12431.0
Australa
188
536389
21791
VINTAGE HEADS AND TAILS CARD GAME
12 01/12/2010 10:03
1.25
12431.0
Australia
a00m A nnme
Transcribed Image Text:In (26): 1 Datal.head(2e0) Out[26]: Desoription Guantity InvoloeDate UnitPrloe CuctomeriD Country InvoloeNo stookCode 85123A WHITE HANGING HEART T-LIGHT HOLDER 01/12/2010 826 2.55 17850.0 Untad Kingdom 536360 6 O/12/2010 826 17850.0 Untad Kingdom 1 71053 WHITE METAL LANTERN 3.39 536366 8 O/12/2010 826 17850.0 Unted Kingdom 2 8440EB CREAM CUPID HEARTS COAT HANGER 2.75 6 01/12/201O 826 17800.0 United Kingdom 536366 84029G KNITTED UNION FLAG HOT WATER BOTTLE 3.39 536366 8402SE RED WOOLLY HOTTIE WHITE HEART. 6 O1/12/2010 826 3.39 17850.0 Unted Kingdom *** *** *** 186 536388 22469 HEART OF WICKER SMALL 12 0/12/2010 9.59 1.65 16250.0 Unted Kingdom 5 HOCK HANGER MAGIC TOADSTOCOL 16250.0 Unted Kingdom 188 536388 22242 12 01/12/2010 9.59 1.65 187 536389 22941 CHRISTMAS LIGHTS 10 REINDEER 6 01/12/2010 10:03 8.50 12431.0 Australia 188 536389 21622 VINTAGE UNION JACK CUSHION COVER 8 01/12/2010 10:03 4.95 12431.0 Australa 188 536389 21791 VINTAGE HEADS AND TAILS CARD GAME 12 01/12/2010 10:03 1.25 12431.0 Australia a00m A nnme
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 4 images

Blurred answer
Knowledge Booster
Single source shortest path
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education