Create the matrix with aligned dates

Question

0 个投票

hi,i've this problem to solve

i've a matrix of date (see pics) A (row) * B(columns)

i used datetime in this matrix

Each date vector can start and end at a different time

I want to synchronize the dates so that each row corresponds to the same date (

example:

Or if it becomes complicated to shift them up or down n boxes, place them side by side with an index (see pics below)

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

shamal 2023-6-4

编辑：shamal 2023-6-4

>> A=load("TEST_A.mat");

>> D=load("TEST_B.mat");

>> TEST_sYNCRONIZE

Incorrect number or types of inputs or outputs for function 'synchronize'.

Error in TEST_sYNCRONIZE (line 7)

synchronize(A,D,'union','linear')

i try to union array with different size but it give me error..

According to the documentation it says to use the 'union' and 'linear' command if the vectors don't have linear dimensions

I was wrong.. i don't know the reason but i have to use A.A and D.D to recall the data But it doesn't work the same

shamal 2023-6-6

移动：the cyclist 2023-6-6

SyncronizedData.mat

hi, i attach file .m with data to syncronized

i try to syncronized it but it give me error

Someone can help me? thanks

i want this result (see pics below)

请先登录，再进行评论。

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

Follow Question

Answer 1

the cyclist 2023-6-6

在 MATLAB Online 中打开

1 个投票

SyncronizedData.mat

load SyncronizedData.mat
for nc = 2:width(J)
    [tf,loc] = ismember(J(:,nc),J(:,nc-1));
    tmp = J(:,nc);
    J(:,nc) = {'NaT'};
    J(loc(tf),nc) = tmp(tf);
end
J(all(strcmp(J,'NaT'),2),:)=[]
J = 7×3 cell array
    {'13-Jan-2008'}    {'13-Jan-2008'}    {'NaT'        }
    {'14-Jan-2008'}    {'14-Jan-2008'}    {'NaT'        }
    {'15-Jan-2008'}    {'15-Jan-2008'}    {'15-Jan-2008'}
    {'16-Jan-2008'}    {'16-Jan-2008'}    {'16-Jan-2008'}
    {'17-Jan-2008'}    {'17-Jan-2008'}    {'17-Jan-2008'}
    {'18-Jan-2008'}    {'18-Jan-2008'}    {'18-Jan-2008'}
    {'19-Jan-2008'}    {'19-Jan-2008'}    {'19-Jan-2008'}

2 个评论
显示无隐藏无

shamal 2023-6-7

I'm having trouble replicating your results

load SyncronizedData.mat

J =

struct with fields:

J: {9×3 cell}

>> J.J

ans =

9×3 cell array

{'NaT' } {'NaT' } {'NaT' }

{'13-Jan-2008'} {'13-Jan-2008'} {'NaT' }

{'14-Jan-2008'} {'14-Jan-2008'} {'NaT' }

{'15-Jan-2008'} {'15-Jan-2008'} {'15-Jan-2008'}

{'16-Jan-2008'} {'16-Jan-2008'} {'16-Jan-2008'}

{'17-Jan-2008'} {'17-Jan-2008'} {'17-Jan-2008'}

{'18-Jan-2008'} {'18-Jan-2008'} {'18-Jan-2008'}

{'19-Jan-2008'} {'19-Jan-2008'} {'19-Jan-2008'}

{'NaT' } {'NaT' } {'NaT' }

should I use J.J instead of J?

the cyclist 2023-6-7

I'm not sure why you save something different in the file you upload than you did in the file you are using. But, yes, it looks like J.J should work.

请先登录，再进行评论。

Create the matrix with aligned dates

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

回答（1 个）

2 个评论
显示无隐藏无

类别

标签

Community Treasure Hunt

Create the matrix with aligned dates

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

回答（1 个）

2 个评论 显示 无 隐藏 无

类别

标签

另请参阅

Community Treasure Hunt

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

2 个评论
显示无隐藏无