How to create table from struct array
9 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Doaa Alamoudi
le 27 Avr 2021
Commenté : Doaa Alamoudi
le 28 Avr 2021
I would like to create table from imported json table.
The data imported are arranged in struct array, So I ould like to create table by combining fields and value in one table. 

0 commentaires
Réponse acceptée
Stephen23
le 27 Avr 2021
Modifié(e) : Stephen23
le 27 Avr 2021
Note that mixing up meta-data (the date) into fieldnames forces superfluous nesting of structures. This poor data design has already allowed one bug into your data: dates with/without leading zeros has allowed duplicates, e.g. for 2021 both of "Apr1" and "Apr01" are listed, as are both of "Apr2" and "Apr02", and as are both of "Apr4" and "Apr04".
Much better data design would store the date as data in its own right: if you have the choice, store the data in an Nx1 structure with a date field (and store the date as datetime or a datevector or anything more robust than those strings).
But given what you have described:
F1 = struct('A',11,'B',12);
F2 = struct('A',21,'B',22);
F3 = struct('A',31,'B',32);
S = struct('Mar23_2021',F1, 'Apr2_2021',F2, 'Apr10_2021',F3)
F = fieldnames(S);
D = datetime(F,'InputFormat','MMMd_yyyy');
C = struct2cell(S);
T = struct2table(vertcat(C{:}));
T.date = D
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Cell Arrays 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!