A Ghost Data In Matlab???

9 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
Rik
Rik on 10 Feb 2022
@Andres, you should expand your comment a bit (explaining the difference between data and the display of that data) and post it as an answer.
Tyann Hardyn
Tyann Hardyn on 10 Feb 2022
Edited: 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
Tyann Hardyn
Tyann Hardyn on 10 Feb 2022
Alright, Sir. Thanks for your great explanation.... Hmm, i just think if it is only different in command window display, then why the years data (2015 arrays) cant be detected in datetime(tahunraw, bulanraw, tanggalraw, 'InputFormat', 'yyyy-MM-dd', 'Format', 'yyyy-MM-dd'). It cause error on the middle of my function iteration and it said, " the input data must be integer " because its totally changed, from 2015 to become 0.2015....
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)

Categories

Find more on Software Development Tools in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!