how to synchronize structures with date fields in text format

2 vues (au cours des 30 derniers jours)
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

Réponse acceptée

Walter Roberson
Walter Roberson le 28 Mar 2020
dateinfo = cellfun(@(S) datetime({S.date}), C, 'uniform', 0);
TT = cellfun(@(S, T) table2timetable(struct2table(S), 'RowTimes', T), C, dateinfo);
  4 commentaires
Giovanni Barbarossa
Giovanni Barbarossa le 29 Mar 2020
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 le 29 Mar 2020
I got it
TTT = cellfun(@(S) removevars(S,'date'), TT, 'uniform', 0);
Thank you again

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by