Question: python analysis using pandas and numpy of sales, inventory and satisfaction cvs files,each in a separate dataframe. Calculate total sales by product and by store.

python analysis using pandas and numpy of sales, inventory and satisfaction cvs files,each in a separate dataframe. Calculate total sales by product and by store. Calculate total revenue by store multiplying quantity sold by unit price. Generate a statistical summary of sales using the describe() method to obtain the mean, median, and other key metrics. If products are classified by categories, calculate the average sales by store and product category. Use groupby() in Pandas to calculate total sales by store or by product category. Calculate the inventory turnover for each store. This is done by dividing total sales by the available stock of each product. Store the results in a new column within the inventory DataFrame. Filter and display stores with critical inventory levels, i.e., stores where the percentage of products sold is less than 10% of the available stock. Use groupby() and mathematical operations to calculate inventory turnover. Apply filters with Pandas to identify stores with critical levels. Conduct an analysis of customer satisfaction in each store. Relate these data to sales performance. Filter stores with low satisfaction levels (< 60%) and make recommendations to improve the performance of these stores. Use Numpy to perform the following calculations on

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!