How to Filter Rows of Cell Array By Date Range

Question

Brian 2024-7-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2141276-how-to-filter-rows-of-cell-array-by-date-range

回答： the cyclist 2024-7-30

Simplied my problem so it's easier to solve. I have a 4x3 array "a" and want to remove rows not within a specified date range. I would like to do this without a loop that would slow down my code. Any suggestions matlab wizards out there?

%Date Range
MinDate = datetime('14-Jul-2024');
MaxDate = datetime('17-July-2024');
%Cell Array
a = cell(4,3);
random = [1 1
         2 1
         3 3
         4 5];
dates = datetime({'10-Jul-2024'
             '15-Jul-2024'
             '20-Jul-2024'
             '16-Jul-2024'});
a(:,3) = num2cell(dates);
a(:,1:2) = num2cell(random);
%How do I filter a by deleting rows not within Date Range? i.e. delete rows 1 & 3 based on the value of a

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

the cyclist 2024-7-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/2141276-how-to-filter-rows-of-cell-array-by-date-range#answer_1492091

在 MATLAB Online 中打开

Here is one way:

%Date Range
MinDate = datetime('14-Jul-2024');
MaxDate = datetime('17-July-2024');
%Cell Array
a = cell(4,3);
random = [1 1
         2 1
         3 3
         4 5];
dates = datetime({'10-Jul-2024'
             '15-Jul-2024'
             '20-Jul-2024'
             '16-Jul-2024'});
a(:,3) = num2cell(dates);
a(:,1:2) = num2cell(random);
% Filter
a_filtered = a(isbetween([a{:,3}],MinDate,MaxDate),:)
a_filtered = 2x3 cell array
    {[2]}    {[1]}    {[15-Jul-2024]}
    {[4]}    {[5]}    {[16-Jul-2024]}