select data from an existing dataset based on the weekday

조회 수: 3 (최근 30일)
Locks
Locks 2013년 5월 3일
Hi,
I have a matrix with 18 columns and over 100'000 rows and in each rows there are stored different characteristic for a specific data. In column 6 is the date in this form:
for example 730853 for the 02-Jan-2001
Now I would like to create a new matrix that consists only if those rows where the date refers to a Wednesday, is that possible?

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

채택된 답변

Azzi Abdelmalek
Azzi Abdelmalek 2013년 5월 3일
편집: Azzi Abdelmalek 2013년 5월 3일
Example
d1=730853
dates=datestr(d1:d1+100,'ddd-mm-yyyy')
M=[cellstr(dates) num2cell((1:101)')]
M=M(ismember(dates(:,1:3),'Wed','rows'),:)

추가 답변 (0개)

카테고리

Help Center 및 File Exchange에서 MATLAB Report Generator에 대해 자세히 알아보기

태그

Community Treasure Hunt

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

Start Hunting!

Translated by