select data from an existing dataset based on the weekday
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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?
0 Kommentare
Akzeptierte Antwort
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)
Siehe auch
Kategorien
Mehr zu Language Fundamentals 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!