changing exponential value into float

Question

Sajitha K.N. 2020-1-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502925-changing-exponential-value-into-float

评论： Walter Roberson 2020-2-2

I normalized 'area' data between zero and one. Then I write that values into xl sheet. But many values are exponential. I want to change that exponential values to float type. Please somebody help.

This is my code:

max_Ar=max(Ar);
min_Ar=min(Ar);
range=(max_Ar-min_Ar)+ eps(max_Ar-min_Ar);
for i=1:100
Area(i)=(Ar(i)-(min_Ar - eps(max_Ar-min_Ar)))/range;
ex = 10^(3-floor(log10(Area(i))));
Area(i)= round(Area(i) * ex) / ex;
end
xlswrite('Tomato_Yellow_Leaf_Curl_Virus.xlsx',Ar(:)) 
xlswrite('Tomato_Yellow_Leaf_Curl_Virus1.xlsx',Area(:))

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

Walter Roberson 2020-2-1

You did not answer my questions.

Sajitha K.N. 2020-2-1

I want to just change it to have as many leading or trailing zeroes as needed.

请先登录，再进行评论。

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

Answer 1

Subhadeep Koley 2020-2-1

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/502925-changing-exponential-value-into-float#answer_413278

在 MATLAB Online 中打开

Hi Sajitha, Try the code below.

clc;
max_Ar = max(Ar);
min_Ar = min(Ar);
range = (max_Ar - min_Ar) + eps(max_Ar - min_Ar);
for i = 1:100
    Area(i) = (Ar(i) - (min_Ar - eps(max_Ar-min_Ar))) / range;
    ex = 10^(3-floor(log10(Area(i))));
    Area(i) = round(Area(i) * ex) / ex;
    
    Area(i) = str2double(sprintf('%f', Area(i)));
    Ar(i) = str2double(sprintf('%f', Ar(i)));
end
xlswrite('Tomato_Yellow_Leaf_Curl_Virus.xlsx', double(Ar(:)));
xlswrite('Tomato_Yellow_Leaf_Curl_Virus1.xlsx', double(Area(:)));