Can I insert columns into imported data

2 ビュー (過去 30 日間)
Shireen Adenwalla
Shireen Adenwalla 2016 年 12 月 8 日
回答済み: Walter Roberson 2016 年 12 月 8 日
I am importing data from an excel file and would like to subtract sequential rows or columns (for example) Can I do this?

回答 (2 件)

Isabella Osetinsky-Tzidaki
Isabella Osetinsky-Tzidaki 2016 年 12 月 8 日
use diff function, see its help page for right formulation

Walter Roberson
Walter Roberson 2016 年 12 月 8 日
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.

カテゴリ

Help Center および File ExchangeTables についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by