Selecting Mondays from a Timetable or Table using the datetime object

2022 3 8
1 个回答
回答已采纳
更新时间：2022 3 8
9 次查看（30 天）

0 个投票

Hi,
I would like to write a script that scrolls through my five minutes resolved timetable / table to select identifies all the days that are Mondays and then group them based on the datetime variable of the table/timetable.
I have tried several other ways to do it including the one below. Instead, if I specify the the day as 1, it returns all the first days of the periods (in this case months) and not specifically the Mondays.
Day1=HHB1(1==day(HHB1.VarName1),:); % HHB1 is the datetime object
%%
Any help?

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

 采纳的回答

Stephen23
Stephen23 2022-3-8
编辑：Stephen23 2022-3-8

0 个投票

By default DAY returns the day of the month, so you need to specify its second argument like this:
d = day(t,'dayofweek')

4 个评论
显示 2更早的评论 隐藏 2更早的评论

Lewis Waswa
Lewis Waswa 2022-3-8
Thank you for the response @Stephen. However, the I still cannot subscript the dat set to get the day type I need. For instance, if I specify the following
Day1=HHB1(day(HHB1.VarName1,'dayofweek'),:);
The Day1 output is the same as the original dataset HHB1 with a single timestamp for all the entries. How would you recommend one moves from here
Stephen23
Stephen23 2022-3-8
编辑：Stephen23 2022-3-8
idx = day(HHB1.VarName1,'dayofweek')==7;
out = HHB1(idx,:);
Unfortunately MATLAB does not use the international standard of Monday==1: https://en.wikipedia.org/wiki/ISO_8601
Squeezing everything onto one line is not required and does not make the code more efficient. Clarity is better.
Lewis Waswa
Lewis Waswa 2022-3-8
Thank you @Stephen. This returns the data I need.
Stephen23
Stephen23 2022-3-8
@Lewis Waswa: Please remember to click the accept button if my answer helped you.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Startup and Shutdown 的更多信息

产品

版本

R2021b

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by