Importing month into Matlab is not recognized

Question

Sander Bovee 2019-10-30

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/488259-importing-month-into-matlab-is-not-recognized

评论： Peter Perkins 2019-10-30

采纳的回答： Roofus Milton

TEST.txt

在 MATLAB Online 中打开

Goodday,

I'm trying to import a txt/CSV file into matlab by using datastore. (Also see attached txt file)

NO.,Time,ms,"V","V","Hz","Hz","A1234567890","ALP1-4","AO1234"
1,2019/10/10 11:09:15,  0,+ 1.883,+ 24.00,       78,       37,LLLLLLLLLL,LLLL,LLLL
2,2019/10/10 11:09:15,200,+ 1.886,+ 24.00,       78,       37,LLLLLLLLLL,LLLL,LLLL

So in order to import with the correct format, my script is:

dat = datastore('TEST.txt')
dat.SelectedVariableNames = dat.SelectedVariableNames([1:7]);
dat.SelectedFormats{1} = '%f';
dat.SelectedFormats{2} = '%{YYYY/MM/DD HH:mm:ss}D';
dat.SelectedFormats{3} = '%f';
dat.SelectedFormats{4} = '+%f';
dat.SelectedFormats{5} = '+%f';
dat.SelectedFormats{6} = '%f';
dat.SelectedFormats{7} = '%f';

However when i run a preview (or import) the data i get the following result:

 Number         Date_Time         ms      CH1     CH2    Pulse1    Pulse2
    ______    ___________________    ___    _____    ___    ______    ______
     2019/01/10 11:09:15      0    1.883    24       78        37  
     2019/01/10 11:09:15    200    1.886    24       78        37  
     2019/01/10 11:09:15    400    1.883    24       78        36  
     2019/01/10 11:09:15    600    1.884    24       79        37  
     2019/01/10 11:09:15    800    1.886    24       78        37  
     2019/01/10 11:09:16      0    1.883    24       78        36  
     2019/01/10 11:09:16    200    1.882    24       79        37  

The month has been set to januari instead of oktober and i don't understand why matlab does not reconizing the month from the original data correctly.

Any help would be much appreciated.

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

请先登录，再进行评论。

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

Answer 1

Roofus Milton 2019-10-30

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/488259-importing-month-into-matlab-is-not-recognized#answer_398953

在 MATLAB Online 中打开

Sander-

Simply change the capitalizations of your date format.

https://www.mathworks.com/help/matlab/ref/datetime.html

% location of data file
filePath = "TEST.txt";
% variables from sample code and file
variableNames = ["Number", "Date_Time", "ms", "CH1", "CH2", "Pulse1", "Pulse2", "Var8", "Var9", "Var10"];
% variable format strings
variableFormats = ["%f", "%{yyyy/MM/dd HH:mm:ss}D", "%f", "+%f", "+%f", "%f", "%f", "%s", "%s", "%s"];
% initialize the datastore object
dat = datastore(filePath, ...
    "VariableNames", variableNames, ...
    "TextscanFormats", variableFormats, ...
    "TextType", "string");

% store sample data
sampleData = preview(dat);
% test date parts
dateParts = [year(sampleData.Date_Time), month(sampleData.Date_Time), day(sampleData.Date_Time), ...
    hour(sampleData.Date_Time), minute(sampleData.Date_Time), second(sampleData.Date_Time)]

2 个评论
显示无隐藏无

Sander Bovee 2019-10-30

Thanks !

Peter Perkins 2019-10-30

Just to be clear: DD is day of year. It occurs after the MM in your format, and so month is read as 10, but then day of year is read as 10 and overwrites the month value.

请先登录，再进行评论。