What is the python code for this Task-6:Company also likes to find out the total purchase amount and the number oftransactions made by each customer in their lifetimeCreate new data frame called "new-dataset", containing the columns['CustomerID', 'TotalPurchaseAmount', 'NumberofTransactions']. Display the last10 rows. Expected output is as follows:CustomerID TotalPurchaseAmount NumberOfTransactions15100350 40715291328.80215311454.6336160293702.1281016098430.60121116250226.14141217420130.85131780934.801417850725.44451518074489.6013 In [39]:1 Data1.head(200)Out[39]:InvoiceNo StockCodeDescription QuantityInvoiceDate UnitPrice CustomerIDCountry6 01/12/2010 8:2617850.0 United Kingdom53636585123AWHITE HANGING HEART T-LIGHT HOLDER2.55153636571053WHITE METAL LANTERN01/12/2010 8:263.3917850.0 United Kingdom253636584406BCREAM CUPID HEARTS COAT HANGER8.01/12/2010 8:262.7517850.0 United Kingdom353636584029G KNITTED UNION FLAG HOT WATER BOTTLE01/12/2010 8:263.3917850.0 United Kingdom453636584029ERED WOOLLY HOTTIE WHITE HEART.01/12/2010 8:263.3917850.0 United Kingdom...19553638822469HEART OF WICKER SMALL1201/12/2010 9:591.6516250.0 United Kingdom196536388222425 HOOK HANGER MAGIC TOADSTOOL1201/12/2010 9:591.6516250.0 United Kingdom19753638922941CHRISTMAS LIGHTS 10 REINDEER6 01/12/2010 10:038.5012431.0Australia19853638921622VINTAGE UNION JACK CUSHION COVER8 01/12/2010 10:034.9512431.0Australia19953638921791VINTAGE HEADS AND TAILS CARD GAME12 01/12/2010 10:031.2512431.0AustraliaActivate Windov

Using tail() method Use pandas.DataFrame.tail(n) to get the last n rows of the DataFrame. It takes…

Task-6: Company also likes to find out the total purchase amount and the number transactions made by each customer in their lifetime Create new data frame called "new-dataset", containing the columi ['CustomerlID', 'TotalPurchaseAmount', 'NumberofTransactions']. Display the la 10 rows. Expected output is as follows: CustomerID TotalPurchaseAmount NumberOrTransactions 15100 350 40 7 15291 328.80 2 15311 454.63 36 16029 3702.12 8 10 16098 430.60 12 11 16250 226.14 14 12 17420 130.85 13 17809 34.80 1 14 17850 725.44 45 15 18074 489.60 13

Task-6: Company also likes to find out the total purchase amount and the number transactions made by each customer in their lifetime Create new data frame called "new-dataset", containing the columi ['CustomerlID', 'TotalPurchaseAmount', 'NumberofTransactions']. Display the la 10 rows. Expected output is as follows: CustomerID TotalPurchaseAmount NumberOrTransactions 15100 350 40 7 15291 328.80 2 15311 454.63 36 16029 3702.12 8 10 16098 430.60 12 11 16250 226.14 14 12 17420 130.85 13 17809 34.80 1 14 17850 725.44 45 15 18074 489.60 13

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.10CP

See similar textbooks

Similar questions

Task-6: Company also likes to find out the total purchase amount and the number of transactions made by each customer in their lifetime Create new data frame called "new-dataset", containing the columns ['CustomerlD', TotalPurchaseAmount', NumberofTransactions']. Display the last 10 rows. Expected output is as follows: CustomeriD TotalPurchaseAmount NumberofTransactions 6 15100 350.40 7 15291 328.80 15311 454.63 36 16029 3702.12 8 10 16098 430.60 12 11 16250 226.14 14 12 17420 130.85 7 13 17809 34.80 1 14 17850 725.44 45 15 18074 489.60 13
2- selects the order line items (orderNumber, orderlinenumber) fromthe “orderdetails” table. Also, display the subtotal (quantityOrdered * priceEach) for eachline item and sorts the result set based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantityordered (itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition“total” greater than 1000.8- Display product code, product name and text description for product.9- Find customer number, customer name, order status and order number, for customerwith their orders…
1- Display contact First name and contact Last name for customers after sorting the customersby their contact Last name in ascending order.2- selects the order line items (orderNumber, orderlinenumber) from the “orderdetails” table.Also, display the subtotal (quantityOrdered * priceEach) for each line item and sorts the resultset based on the subtotal descending .3- Display unique last names from employees table ordered by last name.4- Display customerNumber, customerName and creditLimit for getting the top five customerswho have the highest creditLimit.5- Find customer Name, customer country, sales representative employee number fromcustomers who do not have a sales representative.6- For each order status, display status and count of orders have this status.7- For Each order number in order details table, Display order number, sum of quantity ordered(itemsCount) and sum of (priceEach * quantityOrdered) as total. With condition “total”greater than 1000.8- Display product code, product…
WEEK 3 ASSIGNMENT This assignment contains two parts. You must complete Part I before moving on to Part II. Part I: Using the table you previously worked on, complete the following exercise: Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns. Select a row from your student table where the last name equals "Parker". Select a row from your student table where the ZIP code is less than "68134". Select the student first and last name from the student table order by the state column. Part II: Complete the following exercise: Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state. Using your student table select all students with ZIP codes between “23164” and “98164”. Using your student table select all students where states are in Florida and New York. Using your…
Sales Database: Customers(custId, lastName, firstName, address, phone, creditLimit) Orders(ordNumber, itemNumber, qtyOrdered.) Items(itemNumber, itemName, price) For the Sales Database referenced above, write the SQL command to create the LineItem table, assuming the Orders table and items table already exist.
Task 1: The InstantRide received some traffic violation tickets from the government. The Legal team of InstantRide requires the travel information of the respective drivers along with corresponding Driving License IDs to proceed further. In addition, the team wants to include the drivers without travel information in the system yet for the completion of driver list. Therefore, you need to return DRIVER_FIRST_NAME, DRIVER_LAST_NAME, DRIVER_DRIVING_LICENSE_ID, TRAVEL_START_TIME, TRAVEL_END_TIME information from the DRIVERS and TRAVELS data connected by LEFT JOIN. Task: Query all drivers with and without travel data. (SQL Database Test)
Assignment Two: We will write three procedures on our tables, the first of which I have provided as an example. proclnsertPlayer takes one IN VARCHAR(16) paramater and returns an error code in the second SMALLINT (INOUT) parameter. The procedure checks the parameter and, if there are no errors, inserts the value into tblPlayers. Documentation of errors Condition Error code No errors 1st param Null or zero len playerID taken 1 proclnsertGame will receive two IN VARCHAR(16) interpreted as
Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals. Create a procedure to calculate the VAT. 1 Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ; Test QueryCALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99 5004 2.12 5005 0.89 5006 1.05 5007 0.30 5008 1.51 5009 1.08 5010 1.64
Task 1: The Finance team wants to calculate a VAT (8%) on the amount of the stay reservations in the database. However, the team wants to calculate the VAT after the discounts are applied on the prices. In addition, it is important to remember if there is no discount/offers, then the value is NULL in the TRAVELS table. Create a procedure called VATCalculator to calculate the VAT amount and return with the corresponding travel ID. In addition, execute the procedure to account for NULL values and send the respective result to the team. The VAT value should be rounded to 2 decimals. Remember to redefine the MYSQL delimiter (;) when creating the procedure. This will prevent the commands from executing separately. Create a procedure to calculate the VAT. Make sure you are using the following format to change the delimiter for the procedure: DELIMITER $$-- statements --END $$DELIMITER ; Test Query: CALL VATCalculator() Expected Results TRAVEL_ID VAT 5001 1.24 5002 1.64 5003 0.99…
Microsoft Excel Formula assignment: The objective of this assignment is to create 100 [5x5] tables and each 5 by 5 table will have mix of numbers from 1 to 100. The numbers placed in the 5x5 table have to be randomized and cannot have a matching table (out of the 100 tables). AND each table cannot repeat the same number. I need to create this without having to manually type numbers and create the 5 by 5 tables. Please solve this assignment. simpifly the assignment (If needed) by producing 20 tables to start it out. This assignment demonstates the examples for formulas on excel. TIP: Formulas would help out! Here is two examples for 2 tables.TABLE 1:1 2 3 4 56 7 8 9 1011 12 13 14 1516 17 18 19 2021 22 23 24 25TABLE 2:59 2 3 4 133 72 8 9 6611 22 13 88 1516 17 18 19 529 40 99 30 21
Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters.
Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on increasing the customer satisfaction. They want to learn the travel time for each ride in the system. You need to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF function on the TRAVEL_END_TIME and the TRAVEL_START_TIME.