How to add a column to a table

2 visualizaciones (últimos 30 días)
Sean St Cyr
Sean St Cyr el 17 de Sept. de 2020
Respondida: Star Strider el 17 de Sept. de 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 comentarios
VBBV
VBBV el 17 de Sept. de 2020
What errors do you get ? Could you show the text in red color ?
Sean St Cyr
Sean St Cyr el 17 de Sept. de 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

Iniciar sesión para comentar.

Respuestas (1)

Star Strider
Star Strider el 17 de Sept. de 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,:));
.

Categorías

Más información sobre Tables en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by