0
$\begingroup$

I have a dataset with data like this:

Day Revenue 1 1.2 2 1.5 3 1.1 4 1.34

I want to do a time series model on it, but am getting this error:

ValueError: view limit minimum -35.45 is less than 1 and is an invalid Matplotlib date value. This often happens if you pass a non-datetime value to an axis that has datetime units

When I plt, it assigns all of the date to 1/1/1970. I understand why, because it's not a date time field. Out of curiosity, I tried converting the Day column to a datetime, but it assigned every day to 1/1/70. Is there a way to either convert the column to a datetime field and have it assign a new date starting with a specific date (say 1/1/2017, 1/2/2017, etc) or is there a work around when you just have the day counts (1,2,3,4)?

Improve this question
$\endgroup$

1 Answer 1

Reset to default
0
$\begingroup$

You can use timedelta function from datetime to achieve this, starting from a known date.

Example code can be something like,

from datetime import datetime, timedelta start = datetime.strptime('2021-01-01', '%Y-%m-%d') all_dates = [start + timedelta(x) for x in range(10)] print(all_dates)

Replace the range(10) above with the sequence of the actual days in your dataset.

Improve this answer
$\endgroup$

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.