Compare matrices with datenum

3 vues (au cours des 30 derniers jours)
David du Preez
David du Preez le 19 Mai 2017
Modifié(e) : Andrei Bobrov le 19 Mai 2017
Hi. I have 2 matrices. The first matrix A, (12x1) contains the monthly average values over 10 years. Row 1 is January, row 2 is February and so on. The second matrix B, is 8760x15. In column one there are hourly datenum values for an entire year and in column 15 there daily values. One value has been assigned for an entire day in column 15.
I want to remove an entire day if its value in column 15 is less than the corresponding monthly value in matrix A.
  2 commentaires
Andrei Bobrov
Andrei Bobrov le 19 Mai 2017
Please attach B - matrix here.
David du Preez
David du Preez le 19 Mai 2017
Here is the correct B. It is just a sample of the matrix. Only has the 2 columns that relate to this question

Connectez-vous pour commenter.

Réponses (1)

Andrei Bobrov
Andrei Bobrov le 19 Mai 2017
Modifié(e) : Andrei Bobrov le 19 Mai 2017
out = B(A(month(B(:,1))) <= B(:,end),:);

Catégories

En savoir plus sur Tables 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!

Translated by