Match different time series with one date vector

조회 수: 3 (최근 30일)
K.P.
K.P. 2021년 5월 2일
편집: K.P. 2021년 7월 13일
Hi Everyone,
I have many different matrices with one column containing dates and one comlumn containing numerical values.
I need one "Master Matrix" that contains one "Master date" vector and where each numerical value from the other matrices is assigned to the associated date. So in the new matrix each column represents one of the old matrices with only one date vector.
How could I do this?
Thank you very much in advance!
  댓글 수: 1
Jonas
Jonas 2021년 5월 2일
i would start collecting all date columns and sort them chronologically and remove double entries (maybe using unique, but i dont know which fornat your date has). the resulting date vector gives you the number of rows of your master matrix. after that you can sort in your numerical vectors column by column and set these rows to NaN to which the data vector does not have a date

댓글을 달려면 로그인하십시오.

채택된 답변

Steven Lord
Steven Lord 2021년 5월 2일
Consider storing your time-based data as timetable arrays and use synchronize to synchronize the timetables to a specific date and/or time vector.

추가 답변 (0개)

카테고리

Help CenterFile Exchange에서 Shifting and Sorting Matrices에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by