Convert file with negative value and nan to double

Question

Mohamed Asaad 2022-2-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1645005-convert-file-with-negative-value-and-nan-to-double

评论： Jan 2022-2-8

Au_1_E_chem_experiment_SPR_angle_offset_after_PEG.zip

I am using the below code to import data from another file and to convert commas to dots to be able to plot the values from different files on Matlab. This code works for me except for these two attached files where I get an error message "Conversion to double from struct is not possible." Does anyone know why it does not work for these two files and know a solution for that problem?

a1_Au1EchemPEG   =  importdata('Au_1_E_chem_experiment_SPR_angle_offset_after_PEG.dat');
b1_Au1EchemPEG   = strrep(a1_Au1EchemPEG,',','.');
c1_Au1EchemPEG   = cell2mat(cellfun(@str2num,b1_Au1EchemPEG,'un',0));

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

请先登录，再进行评论。

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

Answer 1

Jan 2022-2-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1645005-convert-file-with-negative-value-and-nan-to-double#answer_890790

在 MATLAB Online 中打开

importdata is extremely smart.Try this:

S = fileread('Au_1_E_chem_experiment_SPR_angle_offset_after_PEG.dat');
S = strrep(S, ',', '.');
D = sscanf(S, '%g', [2, inf]);

2 个评论
显示无隐藏无

Mohamed Asaad 2022-2-7

在 MATLAB Online 中打开

Au_1_E_chem_experiment_SPR_angle.zip

Tank you very much! It works for the files that i have atttached in the question.

However, the plot does not work for this new attached file. The code that i have attached in my question worked for this file. Do you know why this is the case?

When i run your code for the the above attached files i get that:

D = 2x2932 double.

But when i run the below code for the new attched file i get:

c1_Au1Echem = [ ]

a1_Au1Echem   = fileread('Au_1_E_chem_experiment_SPR_angle.dat');
b1_Au1Echem   = strrep(a1_Au1Echem,',','.');
c1_Au1Echem   = sscanf(b1_Au1Echem, '%g', [2, inf]);
plot(c1_Au1Echem(1,:), c1_Au1Echem(2,:))
hold on
plot(c1_Au1Echem(1,:), c1_Au1Echem(6,:))

Jan 2022-2-8

@Mohamed Asaad: The new file starts with a header line, which contains the names of the columns. You can open your .dat files with a text editor to check this.

请先登录，再进行评论。