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

Chapter5: Working With Multiple Worksheets And Workbooks

Section: Chapter Questions

Problem 2AYK

See similar textbooks

Similar questions

Assume that the 52 images for a deck of cards are in a DECK folder, with the file naming scheme .gif. Thus, for example, the image for the Ace of Hearts is in a file named 1H.gif, and the image for the King of Spades is in a file named 13S.gif. Furthermore, there is an image file named B.gif for the backside image of all the cards. This will be the card’s image if its faceup variable is False. Using the DiceDemo program as a role model, write a GUI program that allows you to deal and view cards from a deck. Be sure to define a helper method that takes a Card object as an argument and returns its associated image, and remember to turn the cards as you deal them.
PLEASE ONLY USE <iostream> and <fstream> only haves comments with the program The course records are shown below: Each student has 4 assignments. 108194 9 10 10 10 197526 10 10 10 10 197008 10 10 0 10 197746 10 10 9 10 108154 10 0 10 9 Create an input file ‘CSassignments.txt’ using an editor such as Notepad++ with a student number, then a space, then four assignment marks on one line. The assignment marks are whole numbers and are separated by a space. Your C++ program will read from the file ‘CSassignments.txt’ and write to a second file ‘CSgrades.txt’ which includes the average of the student’s four assignments. e.g. 108194 9 10 10 10 9.75 Your C++ program should work with any number of…
Help me create the following function constraints in w04c_ans.py the test case file provided in one of the image is named w04c_test_public.py copy and paste it in notepad ++ for it to look exactly the same. w04c_test_public.py import ioimport textwrapimport unittestfrom unittest.mock import patch # TODO: Replace w04c_ans with the name of your Python file.# Make sure that this file and that file are in the same# folder.from w04c_ans import print_frame, is_valid_num class TestIsValidNum(unittest.TestCase): def test_pt01(self): a_test = is_valid_num('2') self.assertTrue(a_test) def test_pt02(self): a_test = is_valid_num('-5') self.assertFalse(a_test) def test_pt03(self): a_test = is_valid_num('512abc32') self.assertFalse(a_test) class TestPrintFrame(unittest.TestCase): @patch('sys.stdout', new_callable=io.StringIO) def test_pt01(self, mocked_print): print_frame() self.assertEqual(…
Output MUST look like attached image!!! For this assignment, you will write a program that reads employee work data from a text file, and then calculates payroll information based on this file. The text file will contain one line of text for eachemployee. Each line consists of the following data (delimited by spaces or tabs):1) employee’s id2) employee’s hourly wage rate3) hours worked Monday4) hours worked Tuesday5) hours worked Wednesday6) hours worked Thursday7) hours worked Friday ex) txt file attached Your program should first prompt the user to get the location of the input file. Then it will read the data from the file, put it in appropriate arrays (as described below), and output to the screen the following information: (1) the employee ID, total number of hours worked, regular pay, overtime hours, overtime pay, and total paid to each employee (2) the total hours worked by all employees throughout the week; (3) the total amount paid out to all employees for the week; (4) the…
The other half is in the photos Read the paint program below carefully and complete the source code paint.cpp by: 1. write function “myInit” of your own where you must a) setup viewport, b)set clear color to black and clear window, and c) setup matrix mode and viewing 2. Create your right menu containing the following submenus and main entries: a) color menu with eight entries “Red”, “Green”, “Blue”, “Cyan”, “Magenta”, “Yellow”, “White”, and “Black” b) pixel menu with two entries “Increase pixel size” and “Decrease pixel size” c) fill menu with two entries “Fill on” and “Fill off” d) two main entries “clear” and “quit” 3. Compile and run the program. Your complete program must be able to draw line segments, rectangles, triangles, pixels with specified color. It must also be able to accept keyboard input and display the text on the screen when work in text mode. /* paint.cpp */ #define LINE 1 #define RECTANGLE 2 #define TRIANGLE 3 #define POINTS 4 #define TEXT 5 #include…
I need help to get this readEmpFromFile to work in my code linked the way that is described in the image provided void readEmpFromFile() { FILE* ptr; char str[50]; ptr = fopen("test.txt", "a+"); if (NULL == ptr) { printf("file can't be opened \n"); } printf("content of this file are \n"); while (fgets(str, 50, ptr) != NULL) { printf("%s", str); } fclose(ptr); return 0; } I need help to get this readEmpFromFile to work in my code linked the way that is described in the image provided https://onlinegdb.com/jYuB3gpCx
Print this from c++ Screenshot please
//Create a function that returns which chapter is nearest to the page you're on. If two chapters are equidistant, return the chapter with the higher page number.
2. Write a program that will input a user’s choice based on the table in the attached file/image.<see attached image: switchcase.png>
import image def draw_border(pic):'''Returns an image with a black border around it'''pass #You can leave this or remove it#Your code here to draw a black border around the image def main():'''Controls the program'''fname = "https://runestone.academy/runestone/books/published/StudentCSP/_static/swan.jpg"img = image.Image(fname)width = img.getWidth()height = img.getHeight()win = image.ImageWin(width, height)draw_border(img)img.draw(win) main() #Run the program
Create a vector x which ranges in values from -180 to 180 in steps of 10. Then let y = x. These values are in degrees. Find a variable z = cosd(x)’*sind(y); Use surf to plot the surface plot, and label using commands xlabel, ylabel, and zlabel. Add a title.
I am unable to get the same output, The powerball number has to be align with the ticket number as well as the drawing along with the powerball random number as shown on the images. Kindey, would you please test all my code? Thank you. // Lotto Program#include <ctime>#include<iomanip>#include <cstdlib>#include<iostream>using namespace std; // Functions declaration void printMenu();int getSelect(int&);bool isUnique(int[], int, int);void printArray(int[], int);void selection2_output(int ticket[], int); //creating a fixed winner drawing int drawing[] = { 56,34,1,8,12 }; int main(){ int sel; printMenu(); getSelect(sel); return 0; } // Functions implementation // Menu function. void printMenu(){ cout << "\tWelcome to the Lottery\t\n"; cout << " ---------------------------------\n"; cout << " 1. Quick Pick\n"; cout << " 2. Pick Numbers\n"; cout << " 3. Exit\n";} //for selection1 outputvoid…