How to subtract one cell with previous cell in the table in matlab and do it consecutively until the last row?
6 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Kasih Ditaningtyas Sari Pratiwi
el 4 de Nov. de 2017
Comentada: Kasih Ditaningtyas Sari Pratiwi
el 5 de Nov. de 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.
Respuesta aceptada
Image Analyst
el 4 de Nov. de 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);
Más respuestas (0)
Ver también
Categorías
Más información sobre Spreadsheets en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!