Is there a replacement for this syntax?

Question

with the new update on pandas I can't use this function that I used on on Datacamp learning course - (DAYOFWEEK doesn't exist anymore)

days_of_week = pd.get_dummies(dataframe.index.dayofweek,
                          prefix='weekday',
                          drop_first=True)

How can I change the syntax of my 'formula' to get the same results?

Sorry about the silly question but spent a lot of time here and I'm stuck...

Thanks in advance!

already tried just using the dataframe with index but doesn't get the days of the week on the get dummies\

used datetimeindex but messing up on the formulation as well

`days_of_week = pd.get_dummies(dataframe.index.dayofweek, prefix='weekday', drop_first=True)`

the dataframe is fairly big and need the outputs to get me the weekdays because I'm dealing with stock prices

Guessing it isn't a datetime Index. Do this first: `pd.to_datetime(dataframe.index, errors='coerce').dayofweek` — cs95, Apr 05 '19 at 01:18
[pd.to_datetime(dataframe.index, errors='coerce').dayofweek] worked perfectly!! thanks a lot @coldspeed — Thiago AV, Apr 05 '19 at 12:34

score 0 · Answer 1 · answered Apr 05 '19 at 09:09

0

Try weekday instead of dayofweek.

So

days_of_week = pd.get_dummies(dataframe.index.weekday,
                          prefix='weekday',
                          drop_first=True)

See docs below:

answered Apr 05 '19 at 09:09

Bryce Ramgovind

[pd.to_datetime(dataframe.index, errors='coerce').dayofweek] worked but will check that as well, thanks Bryce!! – Thiago AV Apr 05 '19 at 12:36
@ThiagoAV this also needs the index to be date time which yours is not, this too will not work, unfortunately. – cs95 Apr 05 '19 at 13:54
@coldspeed that's exactly what happened... keeping the other method you suggested! thanks again – Thiago AV Apr 05 '19 at 17:19
Cool @ThiagoAV if you are satisfied with the answer, please accept or up-vote :) – Bryce Ramgovind Apr 08 '19 at 09:04

1 Answers1