how to synchronize structures with date fields in text format

2 次查看（过去 30 天）

Giovanni Barbarossa 2020-3-28

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513650-how-to-synchronize-structures-with-date-fields-in-text-format

评论： Giovanni Barbarossa 2020-3-29

I have a 31x1 cell array C. Each cell of C contains a structure of variable dimensions (41x1 to 50x1) but all structures have the same number of fields. Each structure has a ‘date’ field. The dates in each ‘date’ field are in text format.

I want to transform each structure in C into a timetable so I can synchronize them. I tried struct2table and then table2timetable but it does not work because the dates are not in datetime format. How do I change the format of the dates in the ‘date” field of each structure, so I can convert the structures in timetables and then synchronize them?

Thank you

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

请先登录，再进行评论。

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

采纳的回答

Walter Roberson 2020-3-28

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/513650-how-to-synchronize-structures-with-date-fields-in-text-format#answer_422604

在 MATLAB Online 中打开

dateinfo = cellfun(@(S) datetime({S.date}), C, 'uniform', 0);
TT = cellfun(@(S, T) table2timetable(struct2table(S), 'RowTimes', T), C, dateinfo);

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

Giovanni Barbarossa 2020-3-29

Thank you very much! Now it works but it leaves behind the previous 'date' field with dates in text format. How can I remove the previous 'date' field from all timetables? Thanks again

Giovanni Barbarossa 2020-3-29