Difference between successive rows in a column

2022 8 5
1 个回答
更新时间：2022 8 5
4 次查看（30 天）

0 个投票

I have a table with 60 columns and 60,000 rows. I want to find the difference of second row and first row of 40th column, then difference between 3rd and 2nd row, 4th and 3rd row, etc. It goes until it reaches he last row. Also, I need to assign those difference values in the 61st column. Please help me with this.

请先登录，再回答此问题。

回答（1 个）

Fangjun Jiang
Fangjun Jiang 2022-8-5
编辑：Fangjun Jiang 2022-8-5
Ran in:

0 个投票

Ran in:
a=magic(6);
b=diff(a(:,4))
b = 5×1
-5 1 -5 -5 1
a(2:end,end+1)=b
a = 6×7
35 1 6 26 19 24 0 3 32 7 21 23 25 -5 31 9 2 22 27 20 1 8 28 33 17 10 15 -5 30 5 34 12 14 16 -5 4 36 29 13 18 11 1

类别

在 帮助中心 和 File Exchange 中查找有关 Tables 的更多信息

产品

版本

R2022a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by