Customer Analysis

Problem Statement

Customer Analysis Problem Description You are working on a project in which you want to analyze the data of the customers of a mall on the basis of their spending score. You are given two data frames, data_frame1 and data_frame2 , as CSV text. Perform the analysis by following these steps in order: Clean and merge. Drop every row that contains a missing value in any column, in both data frames independently. Then merge the two cleaned data frames with an inner join on Customer_ID . Ratio. Using the pandas apply function, create a new column Ratio equal to Monthly_Income divided by Spending_Score for each merged row. Gender analysis. Group the merged data by Gender and find the mean value of Ratio for each gender. Store the maximum of these mean ratios, rounded to 2 decimal places, in output1 . Score 90 analysis. Find the mean of Monthly_Income over the merged rows whose Spending_Score is exactly 90 , and store it in output2 . Implement the function Customers(input1, input2) , where inp