Mastering DatetimeIndex in Pandas: Limitations and Workarounds for Accurate Time-Series Analysis