Finding difference between two rows

6 Ansichten (letzte 30 Tage)
Karina
Karina am 25 Apr. 2018
Kommentiert: Dooyoung Kim am 28 Jun. 2018
I have a 6696502 x 2 table which shows energy in MW for a period of time. I want to add a column which is the difference in energy for each time period so column 3 row 2 shows the difference in values for row 2 and 1 in column 2.
I have the following code, however it is very slow to compute given my table is so large. if true
if true
% code
for n = 1:countReg
if n == 1
diffReg = 0;
else
diffReg = RegCol(n) - RegCol(n-1);
end
newRegTable.ChangeReg(n) = diffReg;
end
end
Is there any way to do this so it does not take so much time?

Antworten (1)

Guillaume
Guillaume am 25 Apr. 2018
yourtable.ChangeReg = [0; diff(yourtable.NameOfFirstColumn)]

Kategorien

Mehr zu Tables finden Sie in Help Center und File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by