A (simple) way to use ismember between datetime arrays with different formats

Question

Sim 2024년 6월 21일

0
링크

이 질문에 대한 바로 가기 링크

https://kr.mathworks.com/matlabcentral/answers/2130876-a-simple-way-to-use-ismember-between-datetime-arrays-with-different-formats

댓글: Sim 2024년 6월 21일

Is there a (simple) way to use ismember between datetime arrays with different formats?

In the following example, I want to find the dates that are present both in A and in B, regardless the time (i.e. hours, minutes, seconds):

% Input
A = datetime(...
   ['19-Jun-2023',
   '20-Jun-2023',
   '21-Jun-2023',
   '22-Jun-2023',
   '23-Jun-2023',
   '24-Jun-2023',
   '25-Jun-2023']);
tmp = [{'23-Jun-2023 19:00:00'}
    {'24-Jun-2023 16:00:00'}
    {'24-Jun-2023 11:00:00'}
    {'19-Jun-2023 16:00:00'}
    {'20-Jun-2023 10:00:00'}
    {'21-Jun-2023 10:00:00'}
    {'22-Jun-2023 09:00:00'}
    {'23-Jun-2023 14:00:00'}
    {'19-Jun-2023 17:00:00'}
    {'20-Jun-2023 11:00:00'}
    {'21-Jun-2023 17:00:00'}
    {'22-Jun-2023 15:00:00'}
    {'23-Jun-2023 06:00:00'}
    {'24-Jun-2023 11:00:00'}
    {'25-Jun-2023 19:00:00'}
    {'20-Jun-2023 11:00:00'}
    {'21-Jun-2023 09:00:00'}
    {'23-Jun-2023 12:00:00'}
    {'25-Jun-2023 17:00:00'}
    {'23-Jun-2023 12:00:00'}
    {'22-Jun-2023 07:00:00'}];
B = datetime(tmp, 'InputFormat', 'dd-MMM-yyyy HH:mm:ss');
ismember(A,B)
ans = 7x1 logical array
   0
   0
   0
   0
   0
   0
   0

댓글 수: 2
없음 표시없음 숨기기

Stephen23 2024년 6월 21일

편집: Stephen23 2024년 6월 21일

The format is completely irrelevant. What matters is the date and time. If you want to ignore the time-of-day then use DATESHIFT before calling ISMEMBER.

Sim 2024년 6월 21일

편집: Sim 2024년 6월 21일

MATLAB Online에서 열기

Thanks a lot! I think I found that kind of solution at the same moment you wrote it :-)

I used:

dateshift(B, 'start', 'day');

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

이 질문에 답변하려면 로그인하십시오.

Answer 1

Benjamin Kraus 2024년 6월 21일

1
링크

이 답변에 대한 바로 가기 링크

https://kr.mathworks.com/matlabcentral/answers/2130876-a-simple-way-to-use-ismember-between-datetime-arrays-with-different-formats#answer_1475531

MATLAB Online에서 열기

I think the function you are looking for is dateshift.

A = datetime(...
   ['19-Jun-2023',
   '20-Jun-2023',
   '21-Jun-2023',
   '22-Jun-2023',
   '23-Jun-2023',
   '24-Jun-2023',
   '25-Jun-2023']);
tmp = [{'23-Jun-2023 19:00:00'}
    {'24-Jun-2023 16:00:00'}
    {'24-Jun-2023 11:00:00'}
    {'19-Jun-2023 16:00:00'}
    {'20-Jun-2023 10:00:00'}
    {'21-Jun-2023 10:00:00'}
    {'22-Jun-2023 09:00:00'}
    {'23-Jun-2023 14:00:00'}
    {'19-Jun-2023 17:00:00'}
    {'20-Jun-2023 11:00:00'}
    {'21-Jun-2023 17:00:00'}
    {'22-Jun-2023 15:00:00'}
    {'23-Jun-2023 06:00:00'}
    {'24-Jun-2023 11:00:00'}
    {'25-Jun-2023 19:00:00'}
    {'20-Jun-2023 11:00:00'}
    {'21-Jun-2023 09:00:00'}
    {'23-Jun-2023 12:00:00'}
    {'25-Jun-2023 17:00:00'}
    {'23-Jun-2023 12:00:00'}
    {'22-Jun-2023 07:00:00'}];
B = datetime(tmp, 'InputFormat', 'dd-MMM-yyyy HH:mm:ss');
ismember(A,dateshift(B,'start','day'))
ans = 7x1 logical array
   1
   1
   1
   1
   1
   1
   1

댓글 수: 1
이전 댓글 -1개 표시이전 댓글 -1개 숨기기

Sim 2024년 6월 21일

Thanks a lot @Benjamin Kraus! :-)

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

Answer 2

Sim 2024년 6월 21일

0
링크

이 답변에 대한 바로 가기 링크

https://kr.mathworks.com/matlabcentral/answers/2130876-a-simple-way-to-use-ismember-between-datetime-arrays-with-different-formats#answer_1475526

MATLAB Online에서 열기

Maybe I found a way, but I am not sure about "dateshift(B, 'start', 'day')":

% Input
A = datetime(...
   ['19-Jun-2023',
   '20-Jun-2023',
   '21-Jun-2023',
   '22-Jun-2023',
   '23-Jun-2023',
   '24-Jun-2023',
   '25-Jun-2023']);
tmp = [{'23-Jun-2023 19:00:00'}
    {'24-Jun-2023 16:00:00'}
    {'24-Jun-2023 11:00:00'}
    {'19-Jun-2023 16:00:00'}
    {'20-Jun-2023 10:00:00'}
    {'21-Jun-2023 10:00:00'}
    {'22-Jun-2023 09:00:00'}
    {'23-Jun-2023 14:00:00'}
    {'19-Jun-2023 17:00:00'}
    {'20-Jun-2023 11:00:00'}
    {'21-Jun-2023 17:00:00'}
    {'22-Jun-2023 15:00:00'}
    {'23-Jun-2023 06:00:00'}
    {'24-Jun-2023 11:00:00'}
    {'25-Jun-2023 19:00:00'}
    {'20-Jun-2023 11:00:00'}
    {'21-Jun-2023 09:00:00'}
    {'23-Jun-2023 12:00:00'}
    {'25-Jun-2023 17:00:00'}
    {'23-Jun-2023 12:00:00'}
    {'22-Jun-2023 07:00:00'}];
% Solution
B = datetime(tmp, 'InputFormat', 'dd-MMM-yyyy HH:mm:ss','Format', 'dd-MMM-yyyy');
B2 = dateshift(B, 'start', 'day');
ismember(B2,A)
ans = 21x1 logical array
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1
   1