Match timestamps from different data sets

12 visualizzazioni (ultimi 30 giorni)
Mina Stefansen Hamnes
Mina Stefansen Hamnes il 1 Mar 2021
Risposto: dpb il 1 Mar 2021
We have two different .txt files with a lot of data. For one of the files the timestamp is given in 10 minute intervals, 31-12-2018 23:10:00:000;211.21880 However the other file is given with a totally different timestamp, 31-12-2018 23:10:05:374;214.7. Our goal is to match the timestamp of the second file to the one wich is measured every 10 minutes. We have thought that we might have to remove the seconds of the second file to make this possible. In addition, the two sets of data containt different amounts. One of them contains 52000 rows, while the other one contains 622000 rows. We are quite new to the coding world, so we are thankful for every answer that might help us :)

Risposte (1)

dpb
dpb il 1 Mar 2021
See <matlab timetables> for the introduction to using timetables In particular for your particular Q? read the Topic on Resample and Aggregate Data in Timetable

Community Treasure Hunt

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

Start Hunting!

Translated by