how to synchronize structures with date fields in text format

1 次查看（过去 30 天）
Giovanni Barbarossa
评论： 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

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

采纳的回答

Walter Roberson
Walter Roberson 2020-3-28
dateinfo = cellfun(@(S) datetime({S.date}), C, 'uniform', 0);
TT = cellfun(@(S, T) table2timetable(struct2table(S), 'RowTimes', T), C, dateinfo);
  4 个评论
显示 2更早的评论
Giovanni Barbarossa
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
Giovanni Barbarossa 2020-3-29
I got it
TTT = cellfun(@(S) removevars(S,'date'), TT, 'uniform', 0);
Thank you again

请先登录，再进行评论。

更多回答（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!

Translated by