How to add a column to a table

4 Ansichten (letzte 30 Tage)
Sean St Cyr
Sean St Cyr am 17 Sep. 2020
Beantwortet: Star Strider am 17 Sep. 2020
load ('StreamData.mat')
WL = Stream{:,2};
H = Stream{:,3};
V = Stream{:,4};
FlowRate = WL.*H.*V;
StreamSorted = sortrows(Stream,"FlowRate")
I am trying to take a 6x4 table called Stream from the .mat file and add my calculated value of FlowRate that is a 6x1 matrix and add this to my table with the title Flow Rate. I have tried multiplte things and it stil hasnt worked i get errors.
  2 Kommentare
VBBV
VBBV am 17 Sep. 2020
What errors do you get ? Could you show the text in red color ?
Sean St Cyr
Sean St Cyr am 17 Sep. 2020
Well, They are various errors i was trying with differnt coding, I had added
FlowRate = array2table(FlowRate);
since it was a matrix but im not sure how to add FlowRate to the Table Stream

Melden Sie sich an, um zu kommentieren.

Antworten (1)

Star Strider
Star Strider am 17 Sep. 2020
Try this:
Stream = mat2cell(randi(9,6,4), 6, ones(1,4)); % Create Stream
WL = Stream{:,2};
H = Stream{:,3};
V = Stream{:,4};
FlowRate = WL.*H.*V;
[~,idx] = sort(FlowRate);
StreamTable = table(WL(idx,:),H(idx,:),V(idx,:),FlowRate(idx,:));
.

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