assign categorical value for weekday variables

Question

Sehoon Chang 2020-9-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/599995-assign-categorical-value-for-weekday-variables

评论： Sehoon Chang 2020-9-25

采纳的回答： Steven Lord

在 MATLAB Online 中打开

Dear advisors,

how may i assign categorical value for weekday variables?

I have made a variable 'weekday' from the datetime record from a timetable, which gave me

1..sunday 2..monday 3.. tueday ........ 6..friday 7..saturday

weekday = weekday(timetable.Properties.RowTimes)

I wish to create 'workingday' using 'weekday'.

Within the variable 'workingday', the numbers 2,3,4,5,6 of 'weekday' shall be assigned the categorical value 1 (workingday). 1 and 7 shall be assigned the categorial value of 0 (non-working day).

thank you.

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Steven Lord 2020-9-25

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/599995-assign-categorical-value-for-weekday-variables#answer_500563

在 MATLAB Online 中打开

Since you have a timetable you can use the isweekend function to get true and false values (which you could convert to categorical or leave as logical) from the RowTimes property.

% Make some sample data
T = datetime('today');
thisWeek = T + days(0:6);
% Process each day
for whichDay = 1:numel(thisWeek)
    D = thisWeek(whichDay);
    if isweekend(D)
        fprintf("%s is not a weekday.\n", D)
    else
        fprintf("%s is a weekday.\n", D);
    end
end