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 nunber of transactions is done by Custoner 1D: 17850. He has made 45 transactions. He will be rewarded vith ol gift hanper worth 1800 pesos

Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
icon
Related questions
Question

What will be the python code for this 

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 nunber of transactions is done by Customer ID: 17850. He has made 45 transactions. He will be rewarded with o
gift hanper worth 1800 pesos
Transcribed Image Text: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 nunber of transactions is done by Customer ID: 17850. He has made 45 transactions. He will be rewarded with o gift hanper worth 1800 pesos
In [19]:
1 Datal.head(200)
Out [19]:
InvoiceNo StockCode
Description Quantity
InvoiceDate UnitPrice CustomerID
Country
536365
85123A
WHITE HANGING HEART T-LIGHT HOLDER
01/12/2010 8:28
2.55
17850 United Kingdom
1
536365
71053
WHITE METAL LANTERN
01/12/2010 8:26
3.39
17850 United Kingdom
2
536365
84406B
CREAM CUPID HEARTS COAT HANGER
01/12/2010 8:26
2.75
17850 United Kingdom
3
536365
84029G KNITTED UNION FLAG HOT WATER BOTTLE
01/12/2010 8:26
3.39
17850 United Kingdom
4
536365
84029E
RED WOOLLY HOTTIE WHITE HEART.
01/12/2010 8:26
3.39
17850 United Kingdom
194
538388
21115
ROSE CARAVAN DOORSTOP
4
01/12/2010 9:59
6.75
16250 United Kingdom
195
536388
22469
HEART OF WICKER SMALL
12
01/12/2010 9:59
1.65
18250 United Kingdom
196
536388
22242
5 HOOK HANGER MAGIC TOADSTOOL
12
01/12/2010 9:59
1.65
18250 United Kingdom
197
536389
22941
CHRISTMAS LIGHTS 10 REINDEER
6 01/12/2010 10:03
8.50
12431
Australia
198
536389
21822
VINTAGE UNION JACK CUSHION COVER
8 01/12/2010 10:03
4.95
12431
Australia
199 rows x 8 columns
Transcribed Image Text:In [19]: 1 Datal.head(200) Out [19]: InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerID Country 536365 85123A WHITE HANGING HEART T-LIGHT HOLDER 01/12/2010 8:28 2.55 17850 United Kingdom 1 536365 71053 WHITE METAL LANTERN 01/12/2010 8:26 3.39 17850 United Kingdom 2 536365 84406B CREAM CUPID HEARTS COAT HANGER 01/12/2010 8:26 2.75 17850 United Kingdom 3 536365 84029G KNITTED UNION FLAG HOT WATER BOTTLE 01/12/2010 8:26 3.39 17850 United Kingdom 4 536365 84029E RED WOOLLY HOTTIE WHITE HEART. 01/12/2010 8:26 3.39 17850 United Kingdom 194 538388 21115 ROSE CARAVAN DOORSTOP 4 01/12/2010 9:59 6.75 16250 United Kingdom 195 536388 22469 HEART OF WICKER SMALL 12 01/12/2010 9:59 1.65 18250 United Kingdom 196 536388 22242 5 HOOK HANGER MAGIC TOADSTOOL 12 01/12/2010 9:59 1.65 18250 United Kingdom 197 536389 22941 CHRISTMAS LIGHTS 10 REINDEER 6 01/12/2010 10:03 8.50 12431 Australia 198 536389 21822 VINTAGE UNION JACK CUSHION COVER 8 01/12/2010 10:03 4.95 12431 Australia 199 rows x 8 columns
Expert Solution
steps

Step by step

Solved in 4 steps with 4 images

Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY