In this submission we demonstrate how you can process, and clean time series data stored in Excel sheets, in multiple formats, and with multiple sampling rates in MATLAB. We start with importing data from excel sheets using "import tool". Next, we focus on how to prepare the data to convert to "timetable" datatype.
We further deep dive on preprocessing functions available with timetables including synchronizing the data sets to a common time reference, assessing data quality, and dealing with duplicate & missing data. At the end we show the stacked plot of variables with row times.
Neha Goel (2020). How to Preprocess Time Series Data with MATLAB (https://www.mathworks.com/matlabcentral/fileexchange/73058-how-to-preprocess-time-series-data-with-matlab), MATLAB Central File Exchange. Retrieved .
Hi, This is great thank-you Neha. However, I keep getting errors that "Dot indexing is not supported for variables of this type". The only part of the code I am adjusting is replacing DataAEST with my table name. My table already has the first column with yyyy-MM-dd HH:mm.
My MatLab version is R2018b.
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!