A date frame df_data that contains information about the pro…
A date frame df_data that contains information about the products in a certain store. It contains several columns: Product ID: This is a unique numerical value for each product. Cost Price: A float value that represents the cost for each product. Sale Price: A float value that contains the sale price for each product. Product Category: This an integer value that takes one of 4 possible values: 0 for baby cloths, 1 for kids cloths, 2 for women cloths and 3 for men cloths. Answer the following questions: 1- Write a code to display the Cost price for each Product Category. 2- Write a code to find the product ID for the product that was sold the most in each Category (in terms of the number of items sold) 3- Write a code to find the total profit from each category. *hint: use groupby
Read Details