How to calculate the difference between two date with Pandas in case timedelta is not supported?

最新推荐文章于 2024-09-14 08:25:16 发布

Amber_Luo11

最新推荐文章于 2024-09-14 08:25:16 发布

阅读量186

点赞数 5

文章标签： python

本文链接：https://blog.csdn.net/Amber_Luo11/article/details/139308615

版权

# ``` loan_data['mths_since_earliest_cr_line_date']=round(pd.to_numeric((pd.to_datetime('2017-12-01')-loan_data['earliest_cr_line_date'])/pd.Timedelta(1,unit='M')))

``` --------------------------------------------------------------------------- ``` ValueError Traceback (most recent call last) Cell In[99], line 1 ----> 1 loan_data['mths_since_earliest_cr_line_date']=round(pd.to_numeric((pd.to_datetime('2017-12-01')-loan_data['earliest_cr_line_date'])/pd.Timedelta(1,unit='M'))) File timedeltas.pyx:1821, in pandas._libs.tslibs.timedeltas.Timedelta.__new__() File timedeltas.pyx:827, in pandas._libs.tslibs.timedeltas.disallow_ambiguous_unit() ValueError: Units 'M', 'Y', and 'y' are no longer supported, as they do not represent unambiguous timedelta values durations." ``` please help me and thank you soooo much!!! '2017-12-01'is the enddate,'2017-12-01')-loan_data['earliest_cr_line_date'] is the startdate,i need to calculate the month between two dates.my logic is :calculate the difference between two dates with days and then covert days to month using pd.timedelta method.