Create matrix based off date

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!

Answer 1

[Walter Roberson]

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

[Walter Roberson]

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?

[Devon Fisher-Chavez]

I’m just asking about rearranging the data so that data for one day is in one row. Thanks!

[Walter Roberson]

Provided that the data has full days:

reshape(YourData, 48, []).'

[Devon Fisher-Chavez]

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.

[Devon Fisher-Chavez]

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!