select data from an existing dataset based on the weekday
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponse acceptée
Azzi Abdelmalek
le 3 Mai 2013
Modifié(e) : Azzi Abdelmalek
le 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'),:)
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Language Fundamentals dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!