Create matrix based off date

2018 5 22
1 个回答
更新时间：2021 8 20
6 次查看（30 天）

0 个投票

Hello,
I have a vector that I want to convert into a matrix based off date. I have one column (X) with date/time (yyyy-MM-dd HH:mm:ss) and a second column (Y) with my data. The data was taken every 30 min for 4 years. I want to create a matrix from my data (column Y) in which each row has data from one day. I have no clue where to begin, any help is greatly appreciated.
Thanks!

回答（1 个）

Walter Roberson
Walter Roberson 2018-5-22

0 个投票

Convert to a timetable() object and use retime()

5 个评论
显示 3更早的评论 隐藏 3更早的评论

Walter Roberson
Walter Roberson 2018-5-22
Oh wait -- is the question about finding max/min/average for the day, or is it about re-arranging the data so that all of the data for one day is in one row?
I’m just asking about rearranging the data so that data for one day is in one row. Thanks!
Walter Roberson
Walter Roberson 2018-5-22
Provided that the data has full days:
reshape(YourData, 48, []).'
Thank you.
Our data is imperfect, however. There are a lot of missing points, filtered points, etc. so I would prefer a method that directly tests the time of day.
actually, that works perfectly. the data is filled, plus I'd need filled data to make a matrix anyways... don't know what I was thinking. Thanks!

此问题已关闭。

标签

关闭：

MATLAB Answer Bot
MATLAB Answer Bot
2021-8-20

Community Treasure Hunt

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

Start Hunting!

Translated by