finding the computation for n columns

Hi
Given a a vector table z with column and row of 1200 and 1200 respectively
I want to compute the following for each rows
z = ( T R S T V............n column)
first column T
K = 3;
c1 = sort(T.distance(1:2:end));
c2 = sort(T.distance(2:2:end));
s1 = sum(c1(1:K))/sum(c2(1:K )) ;
second column R
K = 3;
c1 = sort(R.distance(1:2:end));
c2 = sort(R.distance(2:2:end));
s2 = sum(c1(1:K))/sum(c2(1:K )) ;
disp(s2);
How do I make this computation using a small code for n columns
Thank you in advance
Tino

回答(1 个)

Z=z{:,:};
K = 3;
c1 = sort(Z(1:2:end,:));
c2 = sort(Z(2:2:end,:));
s1 = sum(c1(1:K,:))./sum(c2(1:K,:))

11 个评论

Thanks Madhan
But I am getting this error when I try to compute
J = Z{:,:};
K = 3;
c1 = sort(J(1:2:end,:));
c2 = sort(J(2:2:end,:));
s1 = sum(c1(1:K,:))/sum(c2(1:K,: )) ;
disp(s1);
Error
Brace indexing is not supported for variables of this type.
Error in martingale (line 35)
J = Z{:,:};
Thanks in advance
Hi Madhan
Am still geting the problem
What shall I do
thanks in advance
Brace indexing is not supported for variables of this type.
Error in martingale (line 37)
J = z{:,:};
Attach your table as .mat file.
HI Madhan
I have attached the table below consisting of 1200 rows and 1200 column
the code is to computation for each column
and I am suppose to get 1200 answers
thanks in advance
I'm not able to open your file (try once again) , please don't add an answer just to make a comment
sorry that was an error. Let me add the file again
thanks you in advance
Having trouble opening your file.
Hi Madhan
I had attached the excel file
Hope that is ok
Thanks for your help in advance
Tino
Hi Madhan
Can you see the data now?
Thanks
tino
No , I am not able to , there‘s some problem downloading files in my mac.

请先登录,再进行评论。

类别

帮助中心File Exchange 中查找有关 Communications Toolbox 的更多信息

产品

版本

R2019a

标签

提问:

2019-5-14

Community Treasure Hunt

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

Start Hunting!

Translated by