How do I create a CSV with 2 columns and headers

Question

Rae Pond 2018-5-11

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400349-how-do-i-create-a-csv-with-2-columns-and-headers

评论： Image Analyst 2018-5-12

Greetings, I am stuck and can sure use some guidance. I have calculated the mean (mean2) and a standard deviation (std2) of a binary image. I am not sure how to create a CSV file that has 2 column headings for each result (mean and std). I have been playing around with these combinations: m=mean2(plant); s=std2(plant); csv('results.csv',m,s); or csv('results.csv',(m,s));

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

sloppydisk 2018-5-11

在 MATLAB Online 中打开

Have you checked out the documentation?

doc csvwrite

should show you how to do it.

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Image Analyst 2018-5-11

3
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400349-how-do-i-create-a-csv-with-2-columns-and-headers#answer_319871

在 MATLAB Online 中打开

Try using fprintf():

% Create random sample data for testing.
numImages = 10; % Whatever
means = 255 * rand(numImages, 2);
stdDevs = 10 * rand(numImages, 2);
fileName = fullfile(pwd, 'Results.csv');
fid = fopen(fileName, 'wt');
% Write headers
fprintf(fid, 'Mean, Standard Deviation\n');
% Write data.
fprintf(fid, '%f, %f\n', means, stdDevs);
fclose(fid);
% Type file to command window:
type(fileName)

2 个评论
显示无隐藏无

Rae Pond 2018-5-12

WOW! Thank you it's exactly what I was looking for

Image Analyst 2018-5-12

Then maybe you can unaccept your answer that doesn't work, and "Accept this Answer" or at least vote for it.

请先登录，再进行评论。

Answer 2

Rae Pond 2018-5-11

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400349-how-do-i-create-a-csv-with-2-columns-and-headers#answer_319864

在 MATLAB Online 中打开

Hello- I looked at the doc csvwrite and redid my code but the values are listed in a single column below one another. Am I missing where it says in the text how to create two separate columns with headings? Thank you

 m= mean2(newplant); %value 0.0300
 s= std2(newplant); %value 0.1706
 i=[m;s];0.1706
 csvwrite('test.csv',i)

2 个评论
显示无隐藏无

sloppydisk 2018-5-11

在 MATLAB Online 中打开

If you write

i=[m;s]

you concatenate the columns downwards.

Instead you should put them next to each other like this:

i=[m s]

This will give you the desired result.

Image Analyst 2018-5-12

It will not because it will not "create a CSV file that has 2 column headings" as the poster requested and like the code in my answer does. This answer gives only numbers.

请先登录，再进行评论。