Why doe the data extracted from excel sheet gets converted to scientific power ?

Question

Sneha Thakur 2019-4-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457363-why-doe-the-data-extracted-from-excel-sheet-gets-converted-to-scientific-power

评论： Star Strider 2019-4-19

Hi

I am extracting a huge data from .csv file. I have to plot the time and the power data/radiation data from this file. I first convert the data into arrays and use plot function. The data is fine if I call it in small numbers but if I call the complete data, it gets converted to scientific power form. Hence, the plot is not correct. Following is the code and attached is the csv file and plots.

data = readtable('rundata2.csv');

AccColumn = {'Ppv','tload'}

Ppv = data(:,AccColumn(1));

tload = data(:,AccColumn(2));

Ppv2 = table2array(Ppv);

tload2 = table2array(tload);

plot(tload2,Ppv2)

Solution:

Ppv2(1:100)

ans =

116.5341

110.1099

... so on

But when a larger data is called

1e-16[0.0003

0.0003

... soon]

2 个评论
显示无隐藏无

madhan ravi 2019-4-19

Why is the plot incorrect?

Sneha Thakur 2019-4-19

Hi Ravi

Plots are not incorrect, But they are in scientific power which I do not want. I want Matlab to extract the original data and plot.

e.g if Ppv = 450, 4000..... it should plot these values and not something like 0.0004*e6, 0.00004 e6....

Thanks

Sneha

请先登录，再进行评论。

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

Answer 1

Steven Lord 2019-4-19

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/457363-why-doe-the-data-extracted-from-excel-sheet-gets-converted-to-scientific-power#answer_371358

To change the way the data is displayed (which will not impact how it is stored) use the format function.

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

Sneha Thakur 2019-4-19

Thanks for your time Strider.

But this does not work either. When I use exponent property, it throws an error:

Code:

format longEng

data = readtable('rundata2.csv');

AccColumn = {'Ppv','tload'}

Ppv = data(:,AccColumn(1));

tload = data(:,AccColumn(2));

Ppv2 = table2array(Ppv);

tload2 = table2array(tload);

plot(tload2,Ppv2)

Ppv2.YAxis.Exponent = 2;

error: Field assignment to a non-structure array

object.

I went through other posts for this error and tried implementing the solutions, But it does not help.

I am searching for other ways to sort out this issue. Thank you for the help.

Please do let me know, if you find something.

Thanks

Sneha Thakur

Star Strider 2019-4-19

The 'Exponent' property is relatively recent, although I do not remember when it was introduced.

You may need to specifically set your 'XTick' and 'XTickLabel' properties to avoid the exponents.

请先登录，再进行评论。

Why doe the data extracted from excel sheet gets converted to scientific power ?

2 个评论
显示无隐藏无

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

Why doe the data extracted from excel sheet gets converted to scientific power ?

2 个评论 显示 无隐藏 无

回答（1 个）

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

另请参阅

类别

标签

Community Treasure Hunt

2 个评论
显示无隐藏无

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