Can I insert columns into imported data

Question

0 个投票

I am importing data from an excel file and would like to subtract sequential rows or columns (for example) Can I do this?

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

Answer 1

0 个投票

use diff function, see its help page for right formulation

Answer 2

Walter Roberson 2016-12-8

0 个投票

You can use {} notation using : (colon) for the row numbers and using numeric values for column numbers. You can even

diff(YourTable{:, :}, [], 2)

to find the difference between adjacent columns.

What I do not know at the moment is whether there is a nice way to rearrange columns. You can probably use

YourTable(:, [3 1 4 2])

for example to rearrange columns including header.