Task 4: Amazon wants to find out the most and the least bought items. It likes to increase the sale of least bought item by bundling it with the mos bought item and ready to give special 10% discount for this bundle. The output should be the one as below. In [30]: 1 from IPython.display import Image 2 Image(filename = 'Screenshot_67.jpg") out[30]: Nest bought Iten is StockCode 21731 with 458 in purchased quantity. Least bought iten is StockCode 21165 wdth 1 in purchased quantity overall.These tvo itens can be bundled and previde 1e discou nt on this bundle to increase the sale of Stackcode 21166 In [ ]: 1 #HOw to get the Nost bought items in the stockCode and how many was it in pythor
Task 4: Amazon wants to find out the most and the least bought items. It likes to increase the sale of least bought item by bundling it with the mos bought item and ready to give special 10% discount for this bundle. The output should be the one as below. In [30]: 1 from IPython.display import Image 2 Image(filename = 'Screenshot_67.jpg") out[30]: Nest bought Iten is StockCode 21731 with 458 in purchased quantity. Least bought iten is StockCode 21165 wdth 1 in purchased quantity overall.These tvo itens can be bundled and previde 1e discou nt on this bundle to increase the sale of Stackcode 21166 In [ ]: 1 #HOw to get the Nost bought items in the stockCode and how many was it in pythor
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
1st Edition
ISBN:9780357392676
Author:FREUND, Steven
Publisher:FREUND, Steven
Chapter6: Creating, Sorting, And Querying A Table
Section: Chapter Questions
Problem 12AYK
Related questions
Question
![Task 4: Amazon wants to find out the most and the least bought items. It likes to increase the sale of least bought item by bundling it with the most
bought item and ready to give special 10% discount for this bundle. The output should be the one as below.
In [30]:
1 from IPython.display import Image
2 Image(filename = 'screenshot_67.jpg')
Out [30]:
Most bought iten is StockCode 21731 with 458 in purchased quantity.
Least bought iten is StockCode 21166 wáth 1 in purchased quantity overall.These two itens can be bundled and provide 18es discou
nt on this bundle to increase the sale of Stockcode 21166
In [ ):
1 #HOw to get the Most bought items in the stockCode and how many was it in pythor
2 #HOw to get the Least bought items in the stockcode in python](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F0c1faf28-6598-4562-87ec-f26a5152e57c%2F0bb159d9-1c4f-44e1-b0f3-bccd8d492aa0%2F7c3gmk6_processed.jpeg&w=3840&q=75)
Transcribed Image Text:Task 4: Amazon wants to find out the most and the least bought items. It likes to increase the sale of least bought item by bundling it with the most
bought item and ready to give special 10% discount for this bundle. The output should be the one as below.
In [30]:
1 from IPython.display import Image
2 Image(filename = 'screenshot_67.jpg')
Out [30]:
Most bought iten is StockCode 21731 with 458 in purchased quantity.
Least bought iten is StockCode 21166 wáth 1 in purchased quantity overall.These two itens can be bundled and provide 18es discou
nt on this bundle to increase the sale of Stockcode 21166
In [ ):
1 #HOw to get the Most bought items in the stockCode and how many was it in pythor
2 #HOw to get the Least bought items in the stockcode in python
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
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.Recommended textbooks for you
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:
9780357392676
Author:
FREUND, Steven
Publisher:
CENGAGE L