select data from an existing dataset based on the weekday

3 Ansichten (letzte 30 Tage)
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?

Akzeptierte Antwort

Azzi Abdelmalek
Azzi Abdelmalek am 3 Mai 2013
Bearbeitet: Azzi Abdelmalek am 3 Mai 2013
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'),:)

Weitere Antworten (0)

Kategorien

Mehr zu Line Plots finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by