How to add a column to a table

조회 수: 2 (최근 30일)
Sean St Cyr
Sean St Cyr 2020년 9월 17일
답변: 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
VBBV 2020년 9월 17일
What errors do you get ? Could you show the text in red color ?
Sean St Cyr
Sean St Cyr 2020년 9월 17일
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

댓글을 달려면 로그인하십시오.

답변 (1개)

Star Strider
Star Strider 2020년 9월 17일
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,:));
.

카테고리

Help CenterFile Exchange에서 Tables에 대해 자세히 알아보기

Community Treasure Hunt

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

Start Hunting!

Translated by