Error in Joining multiple date time duration id date is in cell Array
2 次查看(过去 30 天)
显示 更早的评论
I am working on time series data. I am joining multiple time duration data . I need help, If duration is in cell array then I am unable to join the time series .
I am getting the following error
Error in matlab.internal.tabular.private.numArgumentsFromSubscriptRecurser (line
7)
n = numArgumentsFromSubscript(a, s, ctxt);
Error in tabular/numArgumentsFromSubscript (line 97)
sz =
matlab.internal.tabular.private.numArgumentsFromSubscriptRecurser(x,s,context);
Error in get_fieldnames (line 33)
structtable.Date = duration(structtable.Date.Hour,
structtable.Date.Minute, structtable.Date.Second); %extract h/m/s
and make that a duration.
Error in MainFcn (line 22)
[joinedtimetable] = get_fieldnames(Content);
I have added work bench. Please find the attachment. Please provide the correct file path.
3 个评论
Guillaume
2020-1-8
What is the class and size of
structtable
structtable.Date
when the error occurs?
Completely unrelated and very minor but why the brackets around joinedtimetable in
[joinedtimetable] = get_fieldnames(Content);
They don't do any harm but are completely unnecessary. After all, you don't have brackets around errorMessage in
errorMessage = sprintf('Error: file not found:\n\n%s', fullFileName);
so why there?
采纳的回答
Adam Danz
2020-1-8
编辑:Adam Danz
2020-1-8
In Test2, the table is not being read in correctly. The image below is the result of line 36 in get_vmlog.m. As you can see, the datetime values are cell arrays of strings.
If you look at the content of vmlogLATEST, it's qualitatively different from uiLATEST which is read in correctly. I guess this is why you have two different functions to read in the data.
Sample of uiLATEST
Sample of vmlogLATEST
So, you'll need to adapt get_vmlog() to use similar logic as you're using in get_ui() to read the datetime values.
Create vector of datetime from cell array of string values
To convert the Date values shown in the first screen shot image above to datetime values, add these two lines of code to your get_vmlog.m file after readtable().
I'm guessing you want to convert {'[0616/104015]'} to 10:40:15 following the logic of your previous questions.
Content.vmlog = readtable(filename, opts);
% convert cell array of time strings to datetime
timeStr = regexp(Content.vmlog.Date,'\d{6}','match');
Content.vmlog.Date = datetime([timeStr{:}],'InputFormat','HHmmss','Format','HH:mm:ss')';
6 个评论
Adam Danz
2020-1-9
Glad I could help! But for your next question, I'm affraid I know nothing about LAN Medium Access Control.
更多回答(1 个)
Sylvain Lacaze
2020-1-8
Hi Matlab,
You're overriding yourself:
structtable.Date = duration(structtable.Date.Hour, structtable.Date.Minute, structtable.Date.Second);
In the first iteration of the loop, structtable.Date is a datetime array, but you then step on it, to make it a duration. In the second iteration of the loop, structtable.Date.Hour doesn't exist (Hour is not a property of a duration object).
Did you mean:
structtable.SomeotherVariableNameLikeDuration = duration(structtable.Date.Hour, structtable.Date.Minute, structtable.Date.Second);
HTH,
Sylvain
0 个评论
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!