How do I create a CSV with 2 columns and headers
25 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Rae Pond
el 11 de Mayo de 2018
Comentada: Image Analyst
el 12 de Mayo de 2018
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 comentario
sloppydisk
el 11 de Mayo de 2018
Have you checked out the documentation?
doc csvwrite
should show you how to do it.
Respuesta aceptada
Image Analyst
el 11 de Mayo de 2018
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 comentarios
Image Analyst
el 12 de Mayo de 2018
Then maybe you can unaccept your answer that doesn't work, and "Accept this Answer" or at least vote for it.
Más respuestas (1)
Rae Pond
el 11 de Mayo de 2018
2 comentarios
sloppydisk
el 11 de Mayo de 2018
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
el 12 de Mayo de 2018
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.
Ver también
Categorías
Más información sobre Data Import and Export en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!