Company: guardian
Difficulty: medium
Problem Description You are required to analyze mall customer data based on their spending scores. You are provided with two pandas DataFrames: data_frame1 and data_frame2 . A Result class is pre-defined in the background for returning your final answers. Implement a function to perform the analysis by strictly following these steps: Clean the data: Drop all rows containing any missing (NaN) values in both data_frame1 and data_frame2 independently. Merge: Perform an inner join to merge the two cleaned DataFrames on the Customer_ID column. Calculate Ratio: Using the pandas apply function, create a new column named Ratio representing the Monthly_Income divided by the Spending_Score . Analyze by Gender: Group the merged data by Gender and calculate the mean value of Ratio for each gender. Find the maximum value among these mean ratios, round it to 2 decimal places, and store it in a variable output1 . Analyze by Spending Score: Calculate the mean Monthly_Income of all customers whose Spen