Different Time Table Synchronization
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hey guys !
I want to synchronize different times from different excel spreadsheets. They have both ISO8601 timestamp standard, but the second one
went crazy.
Could anyone offer any solution to this problem?
Thanks.
0 commentaires
Réponses (1)
Rijuta
le 8 Sep 2023
Hi Ercan,
I understand that you want to use MATLAB to synchronize timestamps from different Excel spreadsheets, but the incorrectness of the second spreadsheet is a hindrance. To clean the second spreadsheet, you can apply some data cleaning techniques. Below are a few general steps:
1. If you suspect that some timestamps in the second spreadsheet are outliers or erroneous, you can identify and remove them.
2. If there are missing timestamps in the second spreadsheet, you can interpolate the missing values based on neighbouring timestamps.
3. If the timestamps in the second spreadsheet have formatting issues or inconsistencies, you can use string manipulation functions to correct them.
To get detailed information about Data Cleaning Techniques, please refer to the documentation below:
0 commentaires
Voir également
Catégories
En savoir plus sur Data Import from MATLAB 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!