TypeError: Invalid comparison between dtype=datetime64[ns, tzoffset(None, 19800)] and datetime
Solution 1:
Found the issue, datetime formats being compared were not the same. Just need to convert the dataframe column to the appropriate format.
compressed_set['Close_Date'] =compressed_set['Close_Date'].dt.tz_convert(None)