How to add a column to a table

2 vues (au cours des 30 derniers jours)
Sean St Cyr
Sean St Cyr le 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 commentaires
VBBV
VBBV le 17 Sep 2020
What errors do you get ? Could you show the text in red color ?
Sean St Cyr
Sean St Cyr le 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

Connectez-vous pour commenter.

Réponses (1)

Star Strider
Star Strider le 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,:));
.

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by