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['CustomerlD', TotalPurchaseAmount', NumberofTransactions']. Display thelast 10 rows. Expected output is as follows:CustomeriD TotalPurchaseAmount NumberofTransactions615100350.40715291328.8015311454.6336160293702.1281016098430.60121116250226.14141217420130.857131780934.8011417850725.44451518074489.6013 In (45):1 Datal.head (200)Out[45]:InvoloeNo stookCodeDesoription GuantityInvoloeDate UnitPrioe CuctomerioCountry53636585123AWHITE HANGING HEART T-LIGHT HOLDER01/12/2010 8262.5517850.0 Untad Kingdom53636571063WHITE METAL LANTERNO1/12/2010 8263.3917850.0 United Kingdom253636G844068CREAM CUPID HEARTS COAT HANGER01/12/2010 8262.7517850.0 Unted Kingdom53636584029G KNITTED UNION FLAG HOT WATER BOTTLE01/12/2010 8:263.3917850.0 Untad Kingdom453636584029ERED WOOLLY HOTTIE WHITE HEART.01/12/2010 8263.3917800.0 United Kingdom18653638822469HEART OF WICKER SMALL12 01/12/2010 9.501.6516250.0 Unted Kingdom188536388222425 HOCK HANGER MAGIC TOADSTOOL12 01/12/2010 9.591.6516250.0 Unted Kingdom18753638922941CHRISTMAS LIGHTS 10 REINDEER6 01/12/2010 10:038.5012431.0Australia18853638921622VINTAGE UNION JACK CUSHION COVER8 O112/2010 10.034.9512431.0Australia18853638921701VINTAGE HEADS AND TAILS CARD GAME12 01/12/2010 10:031.2512431.0Australia200 rows x 8 columnsIn (49):1 Datal.tail(200)Out[49]:InvoloeNo atookCodeDecoription QuantityInvolceDate UnitPrioe CuctomerioCountry64170058166722625RED KITCHEN SCALES2 0812/2011 11.568.5016626.0 Unted Kingdom64171058106723356HOT WATER BOTTLE KEEP CALM4 O9122011 11:064.9516626.0 Unted Kingdom64171158156721326 AGED GLASS SILVER T-LIGHT HOLDER144 09/122011 11.560.5516626.0 Unted Kingdom64171258156721479WHITE SKULL HOT WATER BOTTLE4 O9122011 11:564.2516626.0 Unted Kingdom64171358156723356LOVE HOT WATER BOTTLE3 Ce122011 11.565.9516626.0 United Kingdom641B0458158722613PACK OF 20 SPACEBOY NAPKINS12 D9/122011 12:50O.8512680.0France64180558158722899CHLDRENS APRON DOLLY GIRL6 D9/122011 12.502.1012680.0France64180858158723254CHILDRENS CUTLERY DOLLY GIRL4 Da/122011 12.504.1512680.0France6418075815I723256 CHILDRENS CUTLERY CIRCUS PARADE4 D9/122011 12:504.1512680.0France64180358158722138BAKING SET 9 PIECE RETROSPOT3 D/122011 12.504.9512680.0France200 rows x 8 columns

Please find the answer in step 2.

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 ['CustomerID', TotalPurchaseAmount', NumberofTransactions']. Display the last 10 rows. Expected output is as follows:

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 ['CustomerID', TotalPurchaseAmount', NumberofTransactions']. Display the last 10 rows. Expected output is as follows:

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

1st Edition

ISBN:9780357392676

Author:FREUND, Steven

Publisher:FREUND, Steven

Chapter8: Working With Trendlines, Pivottables, Pivotcharts, And Slicers

Section: Chapter Questions

Problem 8EYW

See similar textbooks

Similar questions

Please modify the code below for "Current Date" ********************************************************************** from pandas_datareader import data as pdrimport yfinance as yfin # Work around until# pandas_datareader is fixed.import datetimeimport pandas as pdimport matplotlib.pyplot as pltimport numpy as np# Show all columns.pd.set_option('display.max_columns', None)pd.set_option('display.width', 1000)def getStock(stk, numDays):print(stk)# Only gets up until day before during# trading hoursdt = datetime.date.today()# For some reason, must add 1 day to get current stock prices# during trade hours. (Prices are about 15 min behind actual prices.)dtNow = dt + datetime.timedelta(days=1)dtNowStr = dtNow.strftime("%Y-%m-%d")dtPast = dt + datetime.timedelta(days=-numDays)dtPastStr = dtPast.strftime("%Y-%m-%d")yfin.pdr_override()df = pdr.get_data_yahoo(stk, start=dtPastStr, end=dtNowStr)return df################################################################### CONFIGURATION…
plz help me fix the following trigger problem is in picture CREATE OR REPLACE TRIGGER MEM_BALANCE AFTER UPDATE ON LATE_FEE FOR EACH ROW BEGIN UPDATE DETAILRENTAL SET LATE_FEE = CASE WHEN LATE_FEE = (DETAIL_DUEDATE – DETAIL_RETURNDATE) * DAILY_LATE_FEE WHEN LATE_FEE = (DETAIL_DUEDATE – DETAIL_RETURNDATE) * DAILY_LATE_FEE IS NULL THEN LATE_FEE := 0 WHEN UPDATED_LATE_FEE:= ORIGINAL_LATE_FEE – LATE_FEE WHEN UPDATED_LATE_FEE:= ORIGINAL_LATE_FEE – LATE_FEE IS NOT NULL THEN MEM_BALANCE:= TOTAL_BALNCE – UPDATED_LATE_FEE ELSE NULL END; the database im trying to put the trigger in CREATE TABLE MEMBERSHIP( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY,MEM_FNAME VARCHAR(30) NOT NULL,MEM_LNAME VARCHAR(30) NOT NULL,MEM_STREET VARCHAR(15),MEM_CITY VARCHAR(10),MEM_STATE CHAR(2),MEM_ZIP CHAR(5),MEM_BALANCE NUMBER (2)); ALTER TABLE MEMBERSHIPMODIFY MEM_STREET VARCHAR(25);CREATE TABLE RENTAL( RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENT_NUM_PK PRIMARY KEY,RENT_DATE DATE,MEM_NUM CHAR(3),CONSTRAINT…
CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) ); CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL ); Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.please use MySQL Workbench with screenshots of it for the explanation.
CREATE TABLE MOVIE( mov_id int NOT NULL, mov_title varchar(255) NOT NULL, mov_releaseDate date, gen_id int NOT NULL, PRIMARY KEY (mov_id), FOREIGN KEY (gen_id) REFERENCES GENRE(gen_id) ); CREATE TABLE GENRE( gen_id int NOT NULL, PRIMARY KEY (gen_id), gen_name varchar(255) NOT NULL );Search movies by year. Using the tables above, create a stored procedure, called getMovieByYear, that, given a year, returns all the movies which were released in that year. It displays the movie title, movie’s genre name, and release year.
Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.
2.7 LAB - Alter Movie table The Movie table has the following columns: ID - integer, primary key Title - variable-length string Genre - variable-length string RatingCode - variable-length string Year - integer Write ALTER statements to make the following modifications to the Movie table: Add a Producer column with VARCHAR data type (max 50 chars). Remove the Genre column. Change the Year column's name to ReleaseYear, and change the data type to SMALLINT.
Please check the instructions on the images given. Sample output are also given on the image while the code for modification is provided below. hash.c #include <stdlib.h>#include <stdio.h> struct Node { int val; struct Node * next;}; struct HashTable { int size; struct Node ** table;}; struct Node * create_node(int val);struct HashTable * create_table(int size);void destroy_table(struct HashTable * h);void display_table(struct HashTable *h);int hash_function(int key, int size);void insert(struct HashTable *h, int val);int search(struct HashTable * h, int val);struct Node * delete(struct HashTable * h, int val); void main(){struct HashTable * h = create_table(8);display_table(h); int val_insert[12] = {12, 31, 45, 83, 72, 29, 84, 39, 61, 24, 10, 50}; for (int i=0; i<12; i++) { insert(h,val_insert[i]);}display_table(h); int val_search[4] = {29, 99, 72, 20};for (int i=0; i<4; i++) { int result = search(h,val_search[i]); printf("Search value %2d:…
Task 4: You have been given a spreadsheet that contains details of invoices. The column headers for the spreadsheet are: date, invoice number, invoice amount, invoice tax, invoice total, cust number, cust name, cust street, cust city, cust state, cust postal code, cust nation, product code, product price, product quantity, salesrep number, salesrep first name, salesrep last name, salesrep district, district name, and district size. Create a high fidelity data model. In other words, list the set of tables (=entities) with their respective column headers. If easier, and alternatively, you can draw an ERD diagram. (Optional: Add some sample data).
The file FDICBankFailures contains data on failures of federally insured banks between 2000 and 2012. Create a PivotTable in Excel to answer the following questions. The PivotTable should group the closing dates of the banks into yearly bins and display the counts of bank closures each year in columns of Excel. Row labels should include the bank locations and allow for grouping the locations into states or viewing by city. You should also sort the PivotTable so that the states with the greatest number of total bank failures between 2000 and 2012 appear at the top of the PivotTable. Click on the datafile logo to reference the data. (a) Which state had the greatest number of federally insured bank closings between 2000 and 2012? - Select your answer -(b) How many bank closings occurred in the state of Nevada (NV) in 2010?In what cities did these bank closings occur? - Select your answer -(c) Use the PivotTable’s filter capability to view only bank closings in California (CA),…
The CompanyDataSet contains a table named Sales and a field named Income. Which of the following loops will accumulate the values in the Income field? a. For Each row As CompanyDataSet.Sales.Row In CompanyDataSet.Sales.Rows Sales.Row += row.Income Next row b. For Each row As CompanyDataSet.Sales.Row In CompanyDataSet.Sales.Rows dblTotal += row.Income Next row c. For Each row As CompanyDataSet.Sales.Row In CompanyDataSet.Rows dblTotal += row.Income Next row d. For Each row As CompanyDataSet.Sales In CompanyDataSet.Sales.Rows dblTotal += row.Income Next row
Which of the following creates a matrix with 5 columns and 6 rows? n = size(5,6); y = ones(5,6); a = size(6,5); x = zeros(6,5);
Create Trigger for When a student marks are being inserted, if the marks that are inserted are greater than 50, allow the insertion, but update marks to 50. Marks(Id , Marks) -> Table Fill in the blanks: ___ triggerName Before ___ ON Marks REFERENCING _____ AS nrow FOR EACH ROW WHEN (nrow.marks>50) _____ nrow SET nrow.marks = 50;