MATLAB Programming Fundamentals - MathWorks

Remove Rows with Missing Times or Missing Data

You can remove missing row times and missing data values using the rmmissing

function. rmmissing removes any timetable row that has a missing row time, missing

data values, or both.

Display the missing row time and missing data values of TT. Then remove all missing

values from TT.

TT

TT=12×4 timetable

Time Temp Rain WindSpeed

____________________ ____ ____ _________

09-Jun-2016 06:01:04 73 0.01 2.3

09-Jun-2016 07:59:23 59 0.08 0.9

09-Jun-2016 09:53:57 59 0.03 3.4

09-Jun-2016 09:53:57 67 0.03 3.4

NaT 56 0 0

09-Jun-2016 09:53:57 67 0.03 3.4

09-Jun-2016 08:49:10 62 0.01 2.7

09-Jun-2016 08:49:10 75.8 0.01 2.7

09-Jun-2016 08:49:10 82 0.01 2.7

09-Jun-2016 05:03:11 66.2 0.05 3

09-Jun-2016 08:49:10 67.2 0.01 2.7

09-Jun-2016 04:12:00 58.8 NaN NaN

TT = rmmissing(TT)

TT=10×4 timetable

Time Temp Rain WindSpeed

____________________ ____ ____ _________

09-Jun-2016 06:01:04 73 0.01 2.3

09-Jun-2016 07:59:23 59 0.08 0.9

09-Jun-2016 09:53:57 59 0.03 3.4

09-Jun-2016 09:53:57 67 0.03 3.4

09-Jun-2016 09:53:57 67 0.03 3.4

09-Jun-2016 08:49:10 62 0.01 2.7

09-Jun-2016 08:49:10 75.8 0.01 2.7

09-Jun-2016 08:49:10 82 0.01 2.7

09-Jun-2016 05:03:11 66.2 0.05 3

10 Timetables