how to filter particular set of dates from a column?

3 次查看（过去 30 天）
Suresh R
Suresh R 2021-10-28
评论： Suresh R 2021-10-28
how to filter particular set of dates from a column?
eg
if we have a column like this
19790914
19791219
19800310
19800622
....
20001231
how to remove/filter dates from 19800310 to 19901214. after this in this output how to add one date before 19800310?

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

采纳的回答

KSSV
KSSV 2021-10-28
Convert the dates to datenum and use logical indexing i.e. use inequalitties.

更多回答（1 个）

Walter Roberson
Walter Roberson 2021-10-28
idx = find(19800310 <= column & column <= 19901214);
At this point you can select corresponding values by
selected_data = YourData(idx,:);
and you can reject corresponding values by
other_data = YourData; other_data(idx,:) = [];
If you are selecting and you want to add an entry before 19800310 then
selected_plus = [Additional_data; selected_data];
If you are rejecting and you want to add an entry where 19800310 would have been then
other_plus = [other_data(1:idx(1)-1, :); Additional_Data; other_data(idx(1):end,:)];

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by