File Exchange

image thumbnail

How to Preprocess Time Series Data with MATLAB

version 1.0.0 (6.38 MB) by Neha Goel
This submission shows how to preprocess time series data in MATLAB using a PMU data analysis example.


Updated 21 Oct 2019

View License

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.

Cite As

Neha Goel (2021). How to Preprocess Time Series Data with MATLAB (, MATLAB Central File Exchange. Retrieved .

Comments and Ratings (1)


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.

MATLAB Release Compatibility
Created with R2019b
Compatible with R2019b and later releases
Platform Compatibility
Windows macOS Linux

Community Treasure Hunt

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

Start Hunting!