Task 5: How to get the overall average purchase-amount among all transactions [ one transaction indicates one invoice number] in Python.

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
1 Datal.head(200)
InvoiceNo StockCode
Description Quantity
InvoiceDate UnitPrice CustomerlD
Country
536385
85123A
WHITE HANGING HEART T-LIGHT HOLDER
01/12/2010 8:28
2.55
17850 United Kingdom
536365
71053
WHITE METAL LANTERN
6
01/12/2010 8:26
3.39
17850 United Kingdom
2
536365
84406B
CREAM CUPID HEARTS COAT HANGER
01/12/2010 8:28
2.75
17850 United Kingdom
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
536388
21115
ROSE CARAVAN DOORSTOP
4
01/12/2010 9:59
6.75
18250 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
21622
VINTAGE UNION JACK CUSHION COVER
8 01/12/2010 10:03
4.95
12431
Australia
199 rows x 8 columns
Task 5: How to get the overall average purchase-amount among all transactions [ one transaction indicates one invoice number] in Python.
Transcribed Image Text:1 Datal.head(200) InvoiceNo StockCode Description Quantity InvoiceDate UnitPrice CustomerlD Country 536385 85123A WHITE HANGING HEART T-LIGHT HOLDER 01/12/2010 8:28 2.55 17850 United Kingdom 536365 71053 WHITE METAL LANTERN 6 01/12/2010 8:26 3.39 17850 United Kingdom 2 536365 84406B CREAM CUPID HEARTS COAT HANGER 01/12/2010 8:28 2.75 17850 United Kingdom 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 536388 21115 ROSE CARAVAN DOORSTOP 4 01/12/2010 9:59 6.75 18250 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 21622 VINTAGE UNION JACK CUSHION COVER 8 01/12/2010 10:03 4.95 12431 Australia 199 rows x 8 columns Task 5: How to get the overall average purchase-amount among all transactions [ one transaction indicates one invoice number] in Python.
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

Blurred answer
Similar questions
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