Task-2:Amazon wants to reward the customer who has done the most number oftransactions, by providing a gift hamper worth 1000 pesos.Find out the customer who has done the most number of transactions [Note: Oneinvoice number corresponds to one transaction]. The output should the one asbelow:Hurray! The most number of transactions is done by Customer ID: 17850. He has made 45 transactions. He will be rewarded with ougift hamper worth 1000 pesos In (26):1 Datal.head(2e0)Out[26]:Desoription GuantityInvoloeDate UnitPrloe CuctomeriDCountryInvoloeNo stookCode85123AWHITE HANGING HEART T-LIGHT HOLDER01/12/2010 8262.5517850.0 Untad Kingdom5363606 O/12/2010 82617850.0 Untad Kingdom171053WHITE METAL LANTERN3.395363668 O/12/2010 82617850.0 Unted Kingdom28440EBCREAM CUPID HEARTS COAT HANGER2.756 01/12/201O 82617800.0 United Kingdom53636684029G KNITTED UNION FLAG HOT WATER BOTTLE3.395363668402SERED WOOLLY HOTTIE WHITE HEART.6 O1/12/2010 8263.3917850.0 Unted Kingdom*********18653638822469HEART OF WICKER SMALL12 0/12/2010 9.591.6516250.0 Unted Kingdom5 HOCK HANGER MAGIC TOADSTOCOL16250.0 Unted Kingdom188536388222421201/12/2010 9.591.6518753638922941CHRISTMAS LIGHTS 10 REINDEER6 01/12/2010 10:038.5012431.0Australia18853638921622VINTAGE UNION JACK CUSHION COVER8 01/12/2010 10:034.9512431.0Australa18853638921791VINTAGE HEADS AND TAILS CARD GAME12 01/12/2010 10:031.2512431.0Australiaa00m A nnme

Please find the answer below with details.

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

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

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter5: Working With Excel Tables, Pivottables, And Pivotcharts

Section: Chapter Questions

Problem 3.3CP

See similar textbooks

Similar questions

After increasing the monthly rent of each large property by $150 in Task 3, StayWell decides to decrease the monthly rent of any property whose monthly rent is more than $1750 by 1%. Update the monthly rents in the LARGE_PROPERTY table accordingly.
A school has 100 lockers and 100 students. All lockers are closed on the first day of school. As the students enter, the first student, denoted as S1, opens every locker. Then the second student, S2, begins with the second locker, denoted as L2, and closes every other locker. Student S3 begins with the third locker and changes every third locker (closes it if it was open and opens it if it was closed). Student S4 begins with locker L4 and changes every fourth locker. Student S5 starts with L5 and changes every fifth locker, and so on, until student S100 changes L100. After all the students have passed through the building and changed the lockers, which lockers are open? Write a program to find your answer and display all open locker numbers separated by exactly one space. (Hint: Use an array of 100 Boolean elements, each of which indicates whether a locker is open (true) or closed (false). Initially, all lockers are closed.)
Saira owns a small business and she frequently makes transactions. Sometimes she makes payments and other times payments are credited in her account. One of her customer Tania purchased a product and credited payment while another payment by Saira was in progress. Now the sequence of transaction is as follows:1. Tania’s account read amount in saira’s account2. Saira’s account read amount in saira’s account3. Tania added Rs. 500/- in original amount (that was lets suppose Rs. 60,000/ 4. Saira’s account subtracted Rs. 2000/- that she debited in someone else’s account form the original amount (that was Rs. 60,000) 5. Tania’s account committed the transaction 6. Saira’s account committed the transaction Draw the above-mentioned sequence in form of a table and see if there is a problem. What this problem is called and how can we avoid such kind of problem? Propose some solutions (at least two) and then explain which one is better and why?
You have a group of friends coming to visit for your high school reunion, and you want to take them out to eat at a local restaurant. You are not sure if any of them have dietary restrictions, but your restaurant choices are as follows: Joe’s Gourmet Burgers—Vegetarian: No, Vegan: No, Gluten-Free: No Main Street Pizza Company—Vegetarian: Yes, Vegan: No, Gluten-Free: Yes Corner Café—Vegetarian: Yes, Vegan: Yes, Gluten-Free: Yes Write a program that asks whether any members of your party are vegetarian, vegan, or gluten-free, to which then displays only the restaurants to which you may take the group.
Task An ATM only has 100, 50 and 20 dollar bills (USD) available to be dispensed. Given an amount between 40 and 10000 dollars (inclusive) and assuming that the ATM wants to use as few bills as possible, determinate the minimal number of 100, 50 and 20 dollar bills the ATM needs to dispense (in that order). Here is the specification for the withdraw method you'll complete: withdraw(amount) Parameters amount: Integer - Amount of money to withdraw. Assume that the amount is always divisible into 100, 50 and 20 bills. Return Value Array (of Integers) - An array of 3 integers representing the number of 100, 50 and 20 dollar bills needed to complete the withdraw (in that order). Constraints 40 ≤ amount ≤ 1000 Can you please help me I will rate! Code is in Python 3.7
Exercise A: In this exercise, you are asking the user to set a alpha numeric password for any website. Put some conditions. Password must be 8 characters long. There must be at-least one uppercase letter There must be at least one number. Then show the user, you have set the correct password or not. Exercise B: This exercise is the extension of the above Exercise. In this exercise we are not checking all the criteria of having a good password. Here ask the user to enter his/her password twice. If both matches, thanks the customer otherwise loop your code until user enters both passwords same.
Correct answer will be upvoted else Multiple Downvoted. Don't submit random answer. Computer science. You found a new line of work as an advertiser in a pet shop, and your present errand is to support deals of feline food. One of the methodologies is to sell jars of food in loads with limits. Assume you chose to sell loads with a jars in a load with a rebate and some client needs to purchase x jars of feline food. Then, at that point, he follows a covetous methodology: he purchases ⌊xa⌋ loads with a markdown; then, at that point, he needs to purchase the leftover (xmoda) jars individually. ⌊xa⌋ is x separated by an adjusted down, xmoda is the remainer of x isolated by a. However, clients are insatiable as a rule, so assuming the client needs to purchase (xmoda) jars individually and it happens that (xmoda)≥a2 he chooses to purchase the entire bunch of a jars (rather than purchasing (xmoda) jars). It makes you, as an advertiser, cheerful since the client purchased more…
Kevin plans to use a Boolean operator since he wants to learn about two separate things. In order to receive accurate search results, Kevin must choose the proper Boolean operator.
Task 12: List the item ID, description, and category for each pair of items that are in the same category. (For example, one such pair would be item FS42 and item PF19, because the category for both items is FSH.) Order the output by category. -- Task # 12SELECT CATEGORY, ITEM_ID, DESCRIPTIONFROM ITEMWHERE EXISTS (SELECT COUNT(*) FROM ITEM I WHERE I._____________ = ITEM._______________ GROUP BY CATEGORYHAVING ___________________)ORDER BY ________________;
Suppose you can buy chocolate bars from a vending machine for $1 each.Inside every chocolate bar is a coupon. You can redeem 7 coupons for 1chocolate bar from the machine.For example, if you have $20, you can initially buy 20 chocolate bars.This gives you 20 coupons. You can redeem 14 coupons for 2 additionalchocolate bars. These 2 chocolate bars have 2 more coupons, so you now have atotal of 8 coupons. This gives you enough to redeem for 1 final chocolate bar.Write a recursive function that would accept the amount of dollars andcoupons as its parameters and output the total number of chocolate bars thatcan be bought (including those redeemed via coupons).Write a test program in C++that would allow the user to enter amount of dollarsand then use the recursive function to compute the number of chocolate barsthe user can buy, and output the number to the screen.
Which of the following statements is incorrect (the respective function does NOT belong to the associated efficiency class)? 1.13n log n + 13 n belongs to O(n^2) 2.5n belongs to O(n^2) 3.4n^2 + 4 n log n belongs to O(2^n) 4.10n^2-10n-21 belongs to O(n log n)
Kevin is interested in gaining information on two separate topics and wants to utilize a Boolean operator to accomplish this. Which Boolean operator should Kevin use to do the search that will get the desired results?