Task 3: Amazon wants to find the best customer and likes to reward 50% discount on his next purchase. Find the Customer with the highestamount of total purchase amount. The output should the one as below:]:1 from IPython.display import Image2 Image(filename = "Screenshot_72.jpg')]:Custoner ID:16229 is the best custoner since he has spent a lot on our business. His total purchase amount is 3702.12 pesos.5e1discount will be given on his next purchase In [19]:1 Datal.head(200)Out [19]:InvoiceNo StockCodeDescription QuantityInvoiceDate UnitPrice CustomerIDCountry53636585123AWHITE HANGING HEART T-LIGHT HOLDER01/12/2010 8:282.5517850 United Kingdom153636571053WHITE METAL LANTERN01/12/2010 8:263.3917850 United Kingdom253636584406BCREAM CUPID HEARTS COAT HANGER01/12/2010 8:262.7517850 United Kingdom353636584029G KNITTED UNION FLAG HOT WATER BOTTLE01/12/2010 8:263.3917850 United Kingdom453636584029ERED WOOLLY HOTTIE WHITE HEART.01/12/2010 8:263.3917850 United Kingdom19453838821115ROSE CARAVAN DOORSTOP401/12/2010 9:596.7516250 United Kingdom19553638822469HEART OF WICKER SMALL1201/12/2010 9:591.6518250 United Kingdom196536388222425 HOOK HANGER MAGIC TOADSTOOL1201/12/2010 9:591.6518250 United Kingdom19753638922941CHRISTMAS LIGHTS 10 REINDEER6 01/12/2010 10:038.5012431Australia19853638921822VINTAGE UNION JACK CUSHION COVER8 01/12/2010 10:034.9512431Australia199 rows x 8 columns

The solution for the above given question is given below:

Task 3: Amazon wants to find the best customer and likes to reward 50% discount on his next purchase. Find the Customer with the highest amount of total purchase amount. The output should the one as below: 1 from IPython.display import Image 2 Image(filename = "Screenshot_72.jpg") Custoner ID:15229 is the best custoner since he has spent a lot on our business. His total purchase anount is 3702.12 pesos.Sen discount will be given on his next purchase

Task 3: Amazon wants to find the best customer and likes to reward 50% discount on his next purchase. Find the Customer with the highest amount of total purchase amount. The output should the one as below: 1 from IPython.display import Image 2 Image(filename = "Screenshot_72.jpg") Custoner ID:15229 is the best custoner since he has spent a lot on our business. His total purchase anount is 3702.12 pesos.Sen discount will be given on his next purchase

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

ELéarning What happens when the user clicks on submit button in the form ? O d. NOT all fields of the form will be automatically stored in the $_POST array. O b. all fields of the form will be automatically stored in the $ POST arroay. all fields of the form stored in the $ POST array and the user must enter the values. all fields of the form will be automatically stored in the $_GET array.
Using netbeans, fix the given code below and run it using netbeans. Show the screenshot result. It should be the same as the result picture given below
If quoting is set to csv.QUOTE_MINIMAL (a)then .writerow() will quote fields only if they contain the delimiter or the quotechar. (b)then .writerow() will quote all fields. (c)then .writerow() will quote all fields containing text data and convert all numeric fields to the float data type. (d)then .writerow() will escape delimiters instead of quoting them. In this case, you also Choose which one is correct.
First Column: Merge column 1, column 2 and column 3. Set the background color as "blue" and align the contents to the right. Insert a Search Form. Insert a suitable input type to select items like SUBJECTS, COURSES, CV HELP and JOB MARKET. Set any name for the form field. Insert a suitable input type to enter the search text. Set any name for the text field and the maximum length is 40. Insert a submit button with a value SEARCH COURSES. • Set a form validation using JAVASCRIPT. If the form field (search) is empty. display an alert message and return false to prevent the form from being submitted.
body { font-family: Georgia, serif; font-size: 100%; line-height: 175%; margin: 0 15% 0; background-color:rgb(210,220,157); background-image: url("/Users/332bo/Desktop/Week_9_Lab/images/bullseye.png"); /* Rounded Shape image */ background-repeat: no-repeat; background-size: contain; } header { margin-top: 0; padding: 3em 1em 2em 1em; text-align: center; border-radius:4px; background-color:hsl(0, 14%, 95%); background-image: url("/Users/332bo/Desktop/Week_9_Lab/images/purpledot.png"); background-repeat: repeat-x; } a { text-decoration: none; color:rgb(153,51,153); } a: visited { color: hsl(300, 13%, 51%); } a: hover { background-color: #fff; } a:focus { background-color: #fff; } a:active{color:#ff00ff;} h1 { font: bold 1.5em Georgia, serif; text-shadow: 0.1em 0.1em 0.2em gray; color: rgb(153,51,153);} h2 { font-size: 1em; text-transform: uppercase; letter-spacing: 0.5em; text-align: center; color:rgb(204,102,0); }dt { font-weight: bold; } strong { font-style: italic; } ul {…
Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20
Create a word document with name as your student id number and save inside the folder “FCS-your student id number”. Enable the extension of the files and show the file extension by attaching the screenshot below.
Add the table body section and within the table body, create the layout of the crossword puzzle subject to the following conditions: The table will contain 9 rows and 8 columns. Within each row will be a number of table data cells. If the cell is a blank cell shown in Figure 6–49, assign it the class name blank. If a blank cell covers multiple rows and/or columns, make that cell a spanning cell and adjust the number of cells in subsequent rows and columns accordingly to preserve the table layout. Several cells contain numbers that will be used as crossword puzzle clues. Number the appropriate cells from 1 up to 26 to match the layout in Figure 6–49.
Which of the following is true if the property value of a name-value pair added by an element with an itemprop attribute is a time element? a) The value is the element’s datetime value b) The value is the value of the element’s content attribute, if any, or the empty string if there is no such attribute c) The value is the value of the element’s value attribute, if it has one, or the empty string otherwise d) The value is the element’s textContent
10. Using the INDEX function only, write a formula in cell H10 to find the state name having the minimum "Sum of Percentage". The formula should include the value(row number) that is calculated in G10. Thank you screenshot attached
Auto filter in MS Excel is used for different options of auto filter on all the dataSelect one:a. Trueb. False
plym fury 77 73 2500 ford thundbd 84 10 17000 fiat 600 65 115 450 chevy nova 80 50 3500 ford mustang 66 45 1700 Using awk exclusively, write the command to display the fourth field of cars.txt, but only when the second field contains the pattern "nova".