Can I insert columns into imported data
1 view (last 30 days)
Show older comments
I am importing data from an excel file and would like to subtract sequential rows or columns (for example) Can I do this?
0 Comments
Answers (2)
Isabella Osetinsky-Tzidaki
on 8 Dec 2016
use diff function, see its help page for right formulation
0 Comments
Walter Roberson
on 8 Dec 2016
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.
0 Comments
See Also
Categories
Find more on Tables in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!