How to subtract one cell with previous cell in the table in matlab and do it consecutively until the last row?
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Kasih Ditaningtyas Sari Pratiwi
le 4 Nov 2017
Commenté : Kasih Ditaningtyas Sari Pratiwi
le 5 Nov 2017
Hi! I need your help. Actually I can do this in excel, but I am curious about how to do it in Matlab. I attach the picture in excel about the mathematical operation I want to do. I want to calculate the duration in minutes by substracting one cell with previous cell and multiply it by 24*60. I also want to do it consecutively until the last row. Do you know how to do it with matlab code? Suppose I have a table with three variables, the first one for duration, the second one for rainfall intensity (mm/min) and the third one for the duration (minutes) which I want to calculate. Could you please help me? Thank you very much in advance.
Réponse acceptée
Image Analyst
le 4 Nov 2017
diff() will give you the difference between rows of each column in your table, t. For example:
dDate = diff(t.Dates);
dt = diff(t.Rainfall);
dd = diff(t.duration);
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Logical 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!