Create a csv file with the following datatransaction_id,product,quantity,price1,Product A,5,10.992,Product B,3,20.503,Product A,2,9.994,Product C,4,15.755,Product B,6,22.006,Product A,8,11.507,Product C,3,14.258,Product A,10,12.759,Product B,4,21.0010,Product C,7,16.50analyze sales data for the past month and provide insights to the management team. The sales data is stored in a CSV file named "sales_data.csv", which contains information about sales transactions, including the product sold, quantity, and price. Your goal is to perform various operations on this data using NumPy to extract meaningful insights.Do the follwoing Tasks:Load the sales data from the CSV file into a NumPy array.Calculate the total sales revenue for each product by multiplying the quantity sold with the price.Identify the top-selling product based on the total revenue generated.Compute the average quantity sold per transaction.Determine the correlation coefficient between the quantity sold and the price.Generate random samples to simulate potential fluctuations in sales quantity for the next month.

Write a query to retrieve the seller ID(s) who made the highest total sales based on the total sum of prices for all their sales.Table: Productproduct_id is the primary key of this table. Each row of this table indicates the name and the price of each product. Table: SalesThis table has no primary key, it can have repeated rows. product_id is a foreign key to the Product table.

1.Working with data for the store Four (name_store), write a query to calculate the change in total revenue in each category (category) and in the store in general after the sale of each product (name) on June 2, 2019. Store the results in the category_accum and store_accum variables, respectively. Sort the values by id_product. Print the product prices (price) before the results.The first rows of the resulting table should look like this:STORE_NAME CATEGORY PRODUCT_NAME PRICE CATEGORY_ACCUM STORE_ACCUMFour milk Borden Super Chox Chocolate Drink, 1 gal 2.38 2.38 2.38Four milk Fairlife 2% Chocolate Reduced Fat Milk, 52 oz 3.16 5.54 5.54Four milk Мoo-Moo Select Ingredients Fat Free Milk, 1 gal 2.28 7.82 7.82

Task 8.1 Write a program for reading information from a data file and saving a summary report intoanother data file for the average value, the maximum value, and the minimum value. A data file named'price.dat’ contains the price of different items, the first record in the price data file contains an integer thatspecifies the number of records that follow. Each of the following lines contains an id and thecorresponding price.101 1000.252 55.253 9999.994 33.455 2000.006 1588.887 1699.998 14898.259 13734.2110 13523.24The output of the problems should be saved into another data file, named 'Output.dat'. With the followingdata:Number of price readings: 10Maximum price: 14898.30Minimum price: 33.45Average price: 5853.35

Hari is working for a retail company and has sales data in the form of a list of dictionaries, where each dictionary represents a sale with information about the productname, price, count and date. Help him to use dictionaries by writing a Python program using strings and user-defined functions to analyze sales data. The analysis should include the calculation of total sales revenue for a specific date and finding the best-selling product.Input format:First line represents the number of products, N.Subsequent lines represent productname, price, count and date.Last line represents the date for which the list of products sold on that particular date have to be fetched from the database. Output format:productname of all products which are sold on a particular date (as mentioned in the last line of input) should be displayed, one by one.Last line displays the details of the best-selling product (which is having the highest of price*count).

Create a table named "products" with columns "product_id" (int), "product_name" (varchar), "description" (varchar), "unit_price" (decimal), and "available_stock" (int). Additionally, the table should have constraints such that "product_id" acts as the primary key and "product_name" is unique.The table structure is given below: