How to add a column to a table

Question

Sean St Cyr 2020-9-17

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/595042-how-to-add-a-column-to-a-table

回答： Star Strider 2020-9-17

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 个评论
显示无隐藏无

VBBV 2020-9-17

What errors do you get ? Could you show the text in red color ?

Sean St Cyr 2020-9-17

在 MATLAB Online 中打开

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

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Star Strider 2020-9-17

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/595042-how-to-add-a-column-to-a-table#answer_495856

在 MATLAB Online 中打开

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,:));