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

Q: Do you believe in doppelgangers? Well they are very much possible with characters! Check if the two…

A: The program is written in C Language. Check the program screenshot for the correct indentation.…

Q: Sir I am trying to get user input for two numbers to perform arithmetic Operations but I am getting…

A: The solution to the given problem is below.

Q: In input you are provided with two words of the same length. Each word contains only lower-case…

A: Note: AS programming language is not mentioned so i am answering it in python language. Given: In…

Q: In Python what is the difference between 'w' and 'w+'?

A: Answer is given below .

Q: (Towers of Hanoi) Every budding computer scientist must grapple with certain classic problems, and…

A: Tower of Hanoi is a mathematical puzzle where we have three rods and n disks. The objective of the…

Q: In Python, what is the purpose of the zip() function?

A: Answer: Zip is predefined function in python. The detailed explanation is in step 2.

Q: do you know and assembly code if yes give me and example and tell me what it does

A: Please refer below for your reference: Below is an assembly code to add two 8 bit numbers :

Q: List three python math functions and explain what they are used for?

A: The three python math functions and their  use ceil(x)   factorial(x) fmod(x, y)

Q: What did Böhm and Jocopini prove about flowcharts?

A: Flow chart is a step by step process which contains sequence of statements represented using flows.…

Q: list four of the primitive operation

A: We are going to understand primitive operations in java  and will also understand its examples.…

Q: Ram works in sales department where he has to check the items and vendors names and make a list of…

A: The program makes use of dictionary, sets and list. List are collection of items that store multiple…

Q: What is unusual about Python’s design of compound statements?

A: Compound statements contain a group of other statements. In most of the other languages we use {} to…

Q: Add a main function to the following python code and organize the program using mainline logic.…

A: - Adding main in code.

Q: Code the circuit below. Write the code as blocks in functions that will perform each gate. There…

A: Introduction Python Function:The function in Python is a set of related statements that perform out…

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.  

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.