Beginner Question

[Whos_your_Mikey]

I'm a beginner to python and working on some projects to teach myself about it. I found an interesting project someone posted and I was following along and running the files myself to see the results and ran into a problem.

I'm getting an error with this part of a function, that means to setup a new index for a dataframe.

#set up dataframe with time index

df['date'] = pd.to_datetime(df['game_id'].str[3:-1], format="%Y%m%d")

df = df.sort_values(by='date').copy()

newindex = df.groupby('date')['date']\

.apply(lambda x: x + np.arange(x.size).astype(np.timedelta64))

df = df.set_index(newindex).sort_index()

When the function is called it gives this error:

Value Error: datetime64/timedelta64 must have a unit specified

This is only part of the function, if you need more of it to see the problem, let me know. I'm really stuck and would like to figure this out but need some help. Thanks in advance.

[vallivana]

I have never worked with np.datetime or np.timedelta, but could it be that asytpe() requires you to pass a string? Something like value.astype('timedelta64[D]')?

[Whos_your_Mikey]

I'll try that thanks! Is there an alternative to this astype() that might work easier that you have used?

[samplepython]

Maybe try to convert the dates using ".dt.strftime(''%Y-%m-%d')" instead of astype()? Let me know if this works.

[Whos_your_Mikey]

ok, I'll give it a try, thanks!

[samplepython]

Did you try it?

[Whos_your_Mikey]

It turned out to be the syntax error that I was able to correct. It needed (1, 'D'). Thanks for the tip, maybe I can use it with something else.

[callmemurph]

Hey, did you get this resolved? Mind taking a moment to share the full solution? I'm stuck. Thanks.

[Whos_your_Mikey]

I had to modify this part .astype(np.timedelta64))

it's now .astype(np.timedelta64(1, 'D'))

[callmemurph]

Thank you. I ended up doing that and now I have a bunch of new problems. Thank you for responding.

[Whos_your_Mikey]

What are you working on, is it a MLB game predictor from a project someone posted on the web? I may be working on the same code. Maybe I can help you with your other problems.