Save Cell data to file

Hello,

In the code below, how do I go about saving the cell data to a csv file with the specified headers?

Here is my code:

clc;clear;
A = 1:15;
B = (0.5)*rand(15,1);
C = 1:20;;
D = (0.5)*rand(20,1);
E = (0.5)*rand(20,1);
CELL{1} = A';
CELL{2} = B;
CELL{3} = C';
CELL{4} = D;
CELL{5} = E;

% fileID = fopen('check.dat','w');
% fprintf(fileID,'%6s %6s %6s %6s %6s\r\n','Iter1','b', 'Iter2', 'd', 'e');
% fprintf(fileID,'%6.5f %6.5f %6.5f %6.5f %6.5f\r\n',CELL);
% fclose(fileID);

[Walter Roberson]

What results are you expecting? Your CELL{1} and CELL{2} will be 15 x 1, but your other CELL entries are 20 x 1 . Do you want empty entries for the first two columns for the last 5 rows?

[Walter Roberson]

This seems to be continuing http://uk.mathworks.com/matlabcentral/answers/256535-save-different-size-cells-to-text-file

[monkey_matlab]

I wanted to have the last entries empty in the first two columns. Thanks.

Answer 1

[Walter Roberson]

Create a cell array large enough to hold everything if everything was the same length -- so in this case, 20 by 5. Set all the entries to '' the empty string. Now in the entries that should have a defined value, write in the string corresponding to the number that goes in that position. For example,

Astr = cellstr(num2str(A.', '%6.5f'));
Output(1:length(Astr), 1) = Astr;

Once the entire Output cell array has been populated,

fmt = '%s,%s,%s,%s,%s\n';

OutTranspose = Output .';   %need to transpose it

fprintf(fileID, fmt, OutTranspose{:});

The transpose has to do with row versus column concerns.

[monkey_matlab]

THANK YOU very much!

Answer 2

[Image Analyst]

Try this:

clc;    % Clear the command window.
workspace;  % Make sure the workspace panel is showing.
format long g;
format compact;
A = 1:15;
B = (0.5)*rand(15,1);
C = 1:20;;
D = (0.5)*rand(20,1);
E = (0.5)*rand(20,1);
CELL{1} = A';
CELL{2} = B;
CELL{3} = C';
CELL{4} = D;
CELL{5} = E;

fileID = fopen('check.dat','wt');
fprintf(fileID,'%6s, %6s, %6s, %6s, %6s\n','Iter1','b', 'Iter2', 'd', 'e');
fprintf(fileID,'%6.5f, %6.5f, %6.5f, %6.5f, %6.5f\n',CELL{1});
fprintf(fileID,'%6.5f, %6.5f, %6.5f, %6.5f, %6.5f\n',CELL{2});
fprintf(fileID,'%6.5f, %6.5f, %6.5f, %6.5f, %6.5f\n',CELL{3});
fprintf(fileID,'%6.5f, %6.5f, %6.5f, %6.5f, %6.5f\n',CELL{4});
fprintf(fileID,'%6.5f, %6.5f, %6.5f, %6.5f, %6.5f\n',CELL{5});
fclose(fileID);

[monkey_matlab]

Thank you. However, how do I keep then the last 5 entries empty in the first two columns to match up the other columns? Your solution is still skewing the saved data set. Thank You.

[Image Analyst]

Either see if Walter's solution works, or give an example of what you want to the output, because I don't know what it means to have the last 5 entries empty in the first two columns.

[monkey_matlab]

Hello, this is the output I would like to get...

Iter1 b Iter2 d e f
1, .05120, 1, .8512, .5656, 5632
2, .56355, 2, .5635, .1259, .6321
...
15, .1256, 15, .8632, .4425, .0856
           16, .2265, .4863, .9652
           ...
           20, .1125, .9965, .1256

Thank you for your time.

[Walter Roberson]

Is your goal to have column-oriented output, or is your goal to have a csv file? Because a csv file would look like

"Iter1","b","Iter2","d","e","f"
1,.05120,1,.8512,.5656,5632
2,.56355,2,.5635,.1259,.6321
...
15,.1256,15,.8632,.4425,.0856
,,16,.2265,.4863,.9652
...
,,20,.1125,.9965,.1256