how to write the results from the code into the csv file format?

Question

muhammad choudhry 2022-3-10

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1668409-how-to-write-the-results-from-the-code-into-the-csv-file-format

评论： Image Analyst 2022-3-10

Hi,

Code below is producing the result including dates format and I usually use dlmwrite to write the results in csv format but in this case I am getting an error below: (What should I change so I can save the results)

Error:

Error using sprintf

Unable to convert 'duration' value to 'double'.

Error in dlmwrite (line 161)

str = sprintf(format,m(i,:));

Error in ploting_timeoverUy (line 30)

dlmwrite('Uy_timestamps.csv',[dates,all_Uy])

Code:

close all; clear all; clc;
projectdir = 'F:\3-PIV_Experimental_Data\Outlet_110\Data_LaserSheet_D\Data_PIV\5-AverageFilter_VelocitiesExtration\Point_Velocities\Uy';
files = dir( fullfile(projectdir, '*', '*.csv') );
filenames = fullfile({files.folder}, {files.name});
num_files = length(filenames);
all_Uy = zeros(num_files,1);
all_time = zeros(num_files,1);
for i = 1:numel(files)
    filename = filenames{i};
    data = readmatrix(filename);
    all_Uy(i) = data(1,2);
end
Location = 'F:\3-PIV_Experimental_Data\Outlet_110\Data_LaserSheet_D\Data_PIV\5-AverageFilter_VelocitiesExtration\Point_Velocities\Uy';
files = dir(Location);
dirFlags = [files.isdir];
subFolders = files(dirFlags); 
subFolderNames = {subFolders(3:end).name} 
for k = 1 : length(subFolderNames)
    fprintf('Sub folder #%d = %s\n', k, subFolderNames{k});
end
dates = extractBetween(subFolderNames,"Run ",".");
dates = replace(dates,'-',':');
dates = duration(dates,"InputFormat","hh:mm:ss")
dates=dates'
plot(dates,all_Uy, '-*');
dlmwrite('Uy_timestamps.csv',[dates,all_Uy])

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Cris LaPierre 2022-3-10

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1668409-how-to-write-the-results-from-the-code-into-the-csv-file-format#answer_914464

I'd try using writematrix instead.

6 个评论
显示 4更早的评论隐藏 4更早的评论

muhammad choudhry 2022-3-10

cheers, that worked and thanks for the explanation. I will remember that " all the matrix values has to be in the same datatype"

Image Analyst 2022-3-10

That's for dlmwrite and csvwrite(). For tables, each column can be different, or for max flexbility, you can use fprintf() like I showed below in my answer.

请先登录，再进行评论。

Answer 2

Image Analyst 2022-3-10

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1668409-how-to-write-the-results-from-the-code-into-the-csv-file-format#answer_914504

You could do it manually with fprintf():

fid = fopen(fileName, 'wt');
if fid == -1
    warningMessage = sprintf('Error opening file for output:\n%s', fileName);
    uiwait(errordlg(warningMessage));
    return;
end
for k = 1 : length(all_Uy)
    fprintf(fid, '%s, %f\n', dates(k), all_Uy(k));
end
fclose(fid)