how to filter particular set of dates from a column?

조회 수: 1 (최근 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.
  댓글 수: 3
KSSV
KSSV 2021년 10월 28일
DEfine the date and append.
A = rand(1,3) ;
A = [rand A]
Suresh R
Suresh R 2021년 10월 28일
thank you!!

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

추가 답변 (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 CenterFile Exchange에서 Time Series Objects에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by