struct2table and data preservation
Afficher commentaires plus anciens
I am working with time sensitive data which is in struct form. I imported my data directly using struct2table function so I will be able to use the 'sortrows' function specifically for the table data structure. I then decided to reverser the process by using table2struct, I am wondering if the sequence/sorting will be preserved after converting back to struct. I sorted by date/time. I want to know if the conversion will mess with the sorting.
3 commentaires
Walter Roberson
le 4 Fév 2020
If you are sorting a table by date/time then it might possibly make more sense to use a timetable than a plain table, depending on the processing you are doing.
When you convert the resulting timetable to plain table, and then table2struct, the order would be sorted by the time key.
If for some reason you need to get back the original order, then before sorting add a column that is the row index; then you could sort by that to get your original order.
Stephen23
le 5 Fév 2020
Mohammad Sami
le 5 Fév 2020
You can also avoid converting to and from the table. You can sort directly as follows.
Assuming that time is of type date/time or numeric
[~,index] = sort([mystruct.time]);
mysortedstruct = mystruct(index);
Réponses (0)
Catégories
En savoir plus sur Data Type Conversion dans Centre d'aide et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!