How To Extract Data From Previous 2 Years Based On Particular Date In Python?

I have a csv file consisting of last 3 years of timeseries monthly data. Based on today's date, I would like to read only the previous 2 years of data for forecasting the future. D

Solution 1:

You can try the following

>>> from dateutil.relativedelta import relativedelta
>>> df[df.Date > datetime.now() - relativedelta(years=2)]
         Date  Value
122018-01-01      5132018-01-02      6142018-01-03      8152018-01-04      2162018-01-05      5172018-01-06      6

Update

>>> from dateutil.relativedelta import relativedelta
>>> from datetime import date

>>> start_date = pd.Timestamp(datetime.now() - relativedelta(years=2))
>>> end_date = pd.Timestamp(date(date.today().year-1, 12, 31))

>>> df[(df.Date >= start_date) & (df.Date <= end_date)]

---

DateValue122018-01-01      5132018-01-02      6142018-01-03      8152018-01-04      2162018-01-05      5172018-01-06      6