EXTRACT THE DISPLAYED COLUMN VECTORS INTO TABLE AND .CSV FILE
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Myke Ziz
le 2 Jan 2020
Commenté : Walter Roberson
le 2 Jan 2020
Hi everyone, I want to extract all the output numbers into a .csv table.
A = table2array(Output)
A(1,:) = [] %delete first row of the double column
for i = 1:20
B = A(:,i);
x = unique(B);
N = numel(x);
count = zeros(N,1);
for k = 1:N
count(k) = sum(B==x(k));
end
disp([ x(:) count ]);
end
I get 2 errors:
1) For the """"disp([ x(:) count ]);"""" I only get in the output the numbers 1 and 0 of the last column of the tabe A, it doesn't maintain the columns before.
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/258508/image.png)
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/258458/image.png)
2) How should I write the script line in order to get a table and a .csv at the end for the """count""" column vectors displayed??
Thank you a lot in advance for your help guys!!
5 commentaires
Walter Roberson
le 2 Jan 2020
for i = 1:20
B = A(:,i);
x = unique(B);
N = numel(x);
for k = 1:N
count(x(k)+1, 1) = x(k);
count(x(k)+1, k+1) = sum(B==x(k));
end
end
disp(count)
This relies on the values in A being non-negative integers.
Réponse acceptée
Walter Roberson
le 2 Jan 2020
count1 = sum(A(:,1:20));
count0 = size(A,1) - count1;
count = [0 count0; 1 count1];
0 commentaires
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Loops and Conditional Statements 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!