A Ghost Data In Matlab???

3 views (last 30 days)
Tyann Hardyn
Tyann Hardyn on 10 Feb 2022
Commented: Walter Roberson on 10 Feb 2022
Hi, Community
I just found a very very awkward data in matlab, especially when i pointing a variable data (from table data) which is shown as a normal double data when i debug it. BUT when i evaluate the variable data, it become significanly different. Here is the issue :
I cant understand why the 2015 Double data become 0.2015 when i evaluate it. Its works as normal with a same other data.
Its sooo Impossible... I just re try it and its still not works... How i can fix it? Would anyone lend me a hand to explain and solve this Ghost Data? Thanks
  3 Comments
Tyann Hardyn
Tyann Hardyn on 10 Feb 2022
I actually use this code for reading the data :
T_raww = readtable(full,opt_rwks);
T_raww2 = standardizeMissing(T_raww,{99999.00, 0.00, 'N/A'},'DataVariables',{'Var7', 'Var8', 'Var9', 'Var10', 'Var11'});
dataraw = T_raww2(:,{'Var1','Var2','Var3','Var4','Var5','Var6','Var7','Var8','Var9','Var10', 'Var11'});
%Mendapatkan Data Waktu Lemi RAW
tahunraw = dataraw.Var1;
% err_tahun = max(ceil(log10(abs(tahunraw))),1); tahunraw = tahunraw(err_tahun == 4);
bulanraw = dataraw.Var2;
tanggalraw = dataraw.Var3;
jamraw = dataraw.Var4;
menitraw = dataraw.Var5;
detikraw = dataraw.Var6;
But it suddenly formed like that (decimals number) . Its a years, which is definitely contained with 4 integers number without decimals in it.

Sign in to comment.

Accepted Answer

Rik
Rik on 10 Feb 2022
The way data is displayed and the way data is stored are separated in Matlab. If you take a look at this:
[12345.1 2015]
ans = 1×2
1.0e+04 * 1.2345 0.2015
You will see that there is an exponent at the top, and everything is scaled to that factor. The data is still the same, just the way it is printed in the command window is different.
Note that if you want people to be able to reproduce your situation, you should make sure you can use the run code feature. If the online environment can run it, we can at least see what is happening.
  2 Comments
Walter Roberson
Walter Roberson on 10 Feb 2022
You should not be using 'InputFormat' together with multiple numeric inputs to datetime(). InputFormat is only for use with a DateStrings input -- a character vector, or a cell array of character vectors, or a string scalar, or a string array.
If you had numeric data that needed to be broken apart, such as 20100317 needing to be interpreted as March 17, 2010, then you would be passing in a single numeric position and using 'ConvertFrom'.
If you pass in multiple numeric positions and you want to control what the output looks like, then you should be using 'Format' not 'InputFormat' . 'Format' controls what the output looks like; 'InputFormat' controls how characters are to be converted.

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!