How to subtract one cell with previous cell in the table in matlab and do it consecutively until the last row?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
Kasih Ditaningtyas Sari Pratiwi
il 4 Nov 2017
Commentato: Kasih Ditaningtyas Sari Pratiwi
il 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.
Risposta accettata
Image Analyst
il 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);
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!