EXTRACT THE DISPLAYED COLUMN VECTORS INTO TABLE AND .CSV FILE
2 views (last 30 days)
Show older comments
Myke Ziz
on 2 Jan 2020
Commented: Walter Roberson
on 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 Comments
Walter Roberson
on 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.
Accepted Answer
Walter Roberson
on 2 Jan 2020
count1 = sum(A(:,1:20));
count0 = size(A,1) - count1;
count = [0 count0; 1 count1];
0 Comments
More Answers (0)
See Also
Categories
Find more on Loops and Conditional Statements in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!