Understanding the Issue with agg Function in Pandas DataFrame: How to Convert Object Type to Numeric and Apply Agg Function Correctly

Performing Aggregation over the Past X Months on a Pandas DataFrame with Start/End Date Ranges and a Random Reference Date