Azzera filtri
Azzera filtri

how to filter particular set of dates from a column?

1 visualizzazione (ultimi 30 giorni)
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?

Risposta accettata

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

Più risposte (1)

Walter Roberson
Walter Roberson il 28 Ott 2021
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,:)];

Categorie

Scopri di più su Time Series Objects in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by