Remove NA values in ts-boxable objects, turning explicit into implicit missing values.

ts_na_omit(x)

Arguments

x

ts-boxable time series, an object of class ts, xts, zoo, data.frame, data.table, tbl, tbl_ts, tbl_time, tis, irts or timeSeries.

Value

a ts-boxable object of the same class as x, i.e., an object of class ts, xts, zoo, data.frame, data.table, tbl, tbl_ts, tbl_time, tis, irts or timeSeries.

Details

Note that internal NAs in ts time series will not be removed, as this conflicts with the regular structure.

See also

ts_regular, for the opposite, turning implicit into explicit missing values.

Examples

x <- AirPassengers
x[c(2, 4)] <- NA

# A ts object does only know explicit NAs
ts_na_omit(x)
#>      Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
#> 1949 112  NA 132  NA 121 135 148 148 136 119 104 118
#> 1950 115 126 141 135 125 149 170 170 158 133 114 140
#> 1951 145 150 178 163 172 178 199 199 184 162 146 166
#> 1952 171 180 193 181 183 218 230 242 209 191 172 194
#> 1953 196 196 236 235 229 243 264 272 237 211 180 201
#> 1954 204 188 235 227 234 264 302 293 259 229 203 229
#> 1955 242 233 267 269 270 315 364 347 312 274 237 278
#> 1956 284 277 317 313 318 374 413 405 355 306 271 306
#> 1957 315 301 356 348 355 422 465 467 404 347 305 336
#> 1958 340 318 362 348 363 435 491 505 404 359 310 337
#> 1959 360 342 406 396 420 472 548 559 463 407 362 405
#> 1960 417 391 419 461 472 535 622 606 508 461 390 432

# by default, NAs are implicit in data frames
ts_df(x)
#>           time value
#> 1   1949-01-01   112
#> 2   1949-02-01    NA
#> 3   1949-03-01   132
#> 4   1949-04-01    NA
#> 5   1949-05-01   121
#> 6   1949-06-01   135
#> 7   1949-07-01   148
#> 8   1949-08-01   148
#> 9   1949-09-01   136
#> 10  1949-10-01   119
#> 11  1949-11-01   104
#> 12  1949-12-01   118
#> 13  1950-01-01   115
#> 14  1950-02-01   126
#> 15  1950-03-01   141
#> 16  1950-04-01   135
#> 17  1950-05-01   125
#> 18  1950-06-01   149
#> 19  1950-07-01   170
#> 20  1950-08-01   170
#> 21  1950-09-01   158
#> 22  1950-10-01   133
#> 23  1950-11-01   114
#> 24  1950-12-01   140
#> 25  1951-01-01   145
#> 26  1951-02-01   150
#> 27  1951-03-01   178
#> 28  1951-04-01   163
#> 29  1951-05-01   172
#> 30  1951-06-01   178
#> 31  1951-07-01   199
#> 32  1951-08-01   199
#> 33  1951-09-01   184
#> 34  1951-10-01   162
#> 35  1951-11-01   146
#> 36  1951-12-01   166
#> 37  1952-01-01   171
#> 38  1952-02-01   180
#> 39  1952-03-01   193
#> 40  1952-04-01   181
#> 41  1952-05-01   183
#> 42  1952-06-01   218
#> 43  1952-07-01   230
#> 44  1952-08-01   242
#> 45  1952-09-01   209
#> 46  1952-10-01   191
#> 47  1952-11-01   172
#> 48  1952-12-01   194
#> 49  1953-01-01   196
#> 50  1953-02-01   196
#> 51  1953-03-01   236
#> 52  1953-04-01   235
#> 53  1953-05-01   229
#> 54  1953-06-01   243
#> 55  1953-07-01   264
#> 56  1953-08-01   272
#> 57  1953-09-01   237
#> 58  1953-10-01   211
#> 59  1953-11-01   180
#> 60  1953-12-01   201
#> 61  1954-01-01   204
#> 62  1954-02-01   188
#> 63  1954-03-01   235
#> 64  1954-04-01   227
#> 65  1954-05-01   234
#> 66  1954-06-01   264
#> 67  1954-07-01   302
#> 68  1954-08-01   293
#> 69  1954-09-01   259
#> 70  1954-10-01   229
#> 71  1954-11-01   203
#> 72  1954-12-01   229
#> 73  1955-01-01   242
#> 74  1955-02-01   233
#> 75  1955-03-01   267
#> 76  1955-04-01   269
#> 77  1955-05-01   270
#> 78  1955-06-01   315
#> 79  1955-07-01   364
#> 80  1955-08-01   347
#> 81  1955-09-01   312
#> 82  1955-10-01   274
#> 83  1955-11-01   237
#> 84  1955-12-01   278
#> 85  1956-01-01   284
#> 86  1956-02-01   277
#> 87  1956-03-01   317
#> 88  1956-04-01   313
#> 89  1956-05-01   318
#> 90  1956-06-01   374
#> 91  1956-07-01   413
#> 92  1956-08-01   405
#> 93  1956-09-01   355
#> 94  1956-10-01   306
#> 95  1956-11-01   271
#> 96  1956-12-01   306
#> 97  1957-01-01   315
#> 98  1957-02-01   301
#> 99  1957-03-01   356
#> 100 1957-04-01   348
#> 101 1957-05-01   355
#> 102 1957-06-01   422
#> 103 1957-07-01   465
#> 104 1957-08-01   467
#> 105 1957-09-01   404
#> 106 1957-10-01   347
#> 107 1957-11-01   305
#> 108 1957-12-01   336
#> 109 1958-01-01   340
#> 110 1958-02-01   318
#> 111 1958-03-01   362
#> 112 1958-04-01   348
#> 113 1958-05-01   363
#> 114 1958-06-01   435
#> 115 1958-07-01   491
#> 116 1958-08-01   505
#> 117 1958-09-01   404
#> 118 1958-10-01   359
#> 119 1958-11-01   310
#> 120 1958-12-01   337
#> 121 1959-01-01   360
#> 122 1959-02-01   342
#> 123 1959-03-01   406
#> 124 1959-04-01   396
#> 125 1959-05-01   420
#> 126 1959-06-01   472
#> 127 1959-07-01   548
#> 128 1959-08-01   559
#> 129 1959-09-01   463
#> 130 1959-10-01   407
#> 131 1959-11-01   362
#> 132 1959-12-01   405
#> 133 1960-01-01   417
#> 134 1960-02-01   391
#> 135 1960-03-01   419
#> 136 1960-04-01   461
#> 137 1960-05-01   472
#> 138 1960-06-01   535
#> 139 1960-07-01   622
#> 140 1960-08-01   606
#> 141 1960-09-01   508
#> 142 1960-10-01   461
#> 143 1960-11-01   390
#> 144 1960-12-01   432

# make NAs explicit
ts_regular(ts_df(x))
#>           time value
#> 1   1949-01-01   112
#> 2   1949-02-01    NA
#> 3   1949-03-01   132
#> 4   1949-04-01    NA
#> 5   1949-05-01   121
#> 6   1949-06-01   135
#> 7   1949-07-01   148
#> 8   1949-08-01   148
#> 9   1949-09-01   136
#> 10  1949-10-01   119
#> 11  1949-11-01   104
#> 12  1949-12-01   118
#> 13  1950-01-01   115
#> 14  1950-02-01   126
#> 15  1950-03-01   141
#> 16  1950-04-01   135
#> 17  1950-05-01   125
#> 18  1950-06-01   149
#> 19  1950-07-01   170
#> 20  1950-08-01   170
#> 21  1950-09-01   158
#> 22  1950-10-01   133
#> 23  1950-11-01   114
#> 24  1950-12-01   140
#> 25  1951-01-01   145
#> 26  1951-02-01   150
#> 27  1951-03-01   178
#> 28  1951-04-01   163
#> 29  1951-05-01   172
#> 30  1951-06-01   178
#> 31  1951-07-01   199
#> 32  1951-08-01   199
#> 33  1951-09-01   184
#> 34  1951-10-01   162
#> 35  1951-11-01   146
#> 36  1951-12-01   166
#> 37  1952-01-01   171
#> 38  1952-02-01   180
#> 39  1952-03-01   193
#> 40  1952-04-01   181
#> 41  1952-05-01   183
#> 42  1952-06-01   218
#> 43  1952-07-01   230
#> 44  1952-08-01   242
#> 45  1952-09-01   209
#> 46  1952-10-01   191
#> 47  1952-11-01   172
#> 48  1952-12-01   194
#> 49  1953-01-01   196
#> 50  1953-02-01   196
#> 51  1953-03-01   236
#> 52  1953-04-01   235
#> 53  1953-05-01   229
#> 54  1953-06-01   243
#> 55  1953-07-01   264
#> 56  1953-08-01   272
#> 57  1953-09-01   237
#> 58  1953-10-01   211
#> 59  1953-11-01   180
#> 60  1953-12-01   201
#> 61  1954-01-01   204
#> 62  1954-02-01   188
#> 63  1954-03-01   235
#> 64  1954-04-01   227
#> 65  1954-05-01   234
#> 66  1954-06-01   264
#> 67  1954-07-01   302
#> 68  1954-08-01   293
#> 69  1954-09-01   259
#> 70  1954-10-01   229
#> 71  1954-11-01   203
#> 72  1954-12-01   229
#> 73  1955-01-01   242
#> 74  1955-02-01   233
#> 75  1955-03-01   267
#> 76  1955-04-01   269
#> 77  1955-05-01   270
#> 78  1955-06-01   315
#> 79  1955-07-01   364
#> 80  1955-08-01   347
#> 81  1955-09-01   312
#> 82  1955-10-01   274
#> 83  1955-11-01   237
#> 84  1955-12-01   278
#> 85  1956-01-01   284
#> 86  1956-02-01   277
#> 87  1956-03-01   317
#> 88  1956-04-01   313
#> 89  1956-05-01   318
#> 90  1956-06-01   374
#> 91  1956-07-01   413
#> 92  1956-08-01   405
#> 93  1956-09-01   355
#> 94  1956-10-01   306
#> 95  1956-11-01   271
#> 96  1956-12-01   306
#> 97  1957-01-01   315
#> 98  1957-02-01   301
#> 99  1957-03-01   356
#> 100 1957-04-01   348
#> 101 1957-05-01   355
#> 102 1957-06-01   422
#> 103 1957-07-01   465
#> 104 1957-08-01   467
#> 105 1957-09-01   404
#> 106 1957-10-01   347
#> 107 1957-11-01   305
#> 108 1957-12-01   336
#> 109 1958-01-01   340
#> 110 1958-02-01   318
#> 111 1958-03-01   362
#> 112 1958-04-01   348
#> 113 1958-05-01   363
#> 114 1958-06-01   435
#> 115 1958-07-01   491
#> 116 1958-08-01   505
#> 117 1958-09-01   404
#> 118 1958-10-01   359
#> 119 1958-11-01   310
#> 120 1958-12-01   337
#> 121 1959-01-01   360
#> 122 1959-02-01   342
#> 123 1959-03-01   406
#> 124 1959-04-01   396
#> 125 1959-05-01   420
#> 126 1959-06-01   472
#> 127 1959-07-01   548
#> 128 1959-08-01   559
#> 129 1959-09-01   463
#> 130 1959-10-01   407
#> 131 1959-11-01   362
#> 132 1959-12-01   405
#> 133 1960-01-01   417
#> 134 1960-02-01   391
#> 135 1960-03-01   419
#> 136 1960-04-01   461
#> 137 1960-05-01   472
#> 138 1960-06-01   535
#> 139 1960-07-01   622
#> 140 1960-08-01   606
#> 141 1960-09-01   508
#> 142 1960-10-01   461
#> 143 1960-11-01   390
#> 144 1960-12-01   432

# and implicit again
ts_na_omit(ts_regular(ts_df(x)))
#>           time value
#> 1   1949-01-01   112
#> 2   1949-03-01   132
#> 3   1949-05-01   121
#> 4   1949-06-01   135
#> 5   1949-07-01   148
#> 6   1949-08-01   148
#> 7   1949-09-01   136
#> 8   1949-10-01   119
#> 9   1949-11-01   104
#> 10  1949-12-01   118
#> 11  1950-01-01   115
#> 12  1950-02-01   126
#> 13  1950-03-01   141
#> 14  1950-04-01   135
#> 15  1950-05-01   125
#> 16  1950-06-01   149
#> 17  1950-07-01   170
#> 18  1950-08-01   170
#> 19  1950-09-01   158
#> 20  1950-10-01   133
#> 21  1950-11-01   114
#> 22  1950-12-01   140
#> 23  1951-01-01   145
#> 24  1951-02-01   150
#> 25  1951-03-01   178
#> 26  1951-04-01   163
#> 27  1951-05-01   172
#> 28  1951-06-01   178
#> 29  1951-07-01   199
#> 30  1951-08-01   199
#> 31  1951-09-01   184
#> 32  1951-10-01   162
#> 33  1951-11-01   146
#> 34  1951-12-01   166
#> 35  1952-01-01   171
#> 36  1952-02-01   180
#> 37  1952-03-01   193
#> 38  1952-04-01   181
#> 39  1952-05-01   183
#> 40  1952-06-01   218
#> 41  1952-07-01   230
#> 42  1952-08-01   242
#> 43  1952-09-01   209
#> 44  1952-10-01   191
#> 45  1952-11-01   172
#> 46  1952-12-01   194
#> 47  1953-01-01   196
#> 48  1953-02-01   196
#> 49  1953-03-01   236
#> 50  1953-04-01   235
#> 51  1953-05-01   229
#> 52  1953-06-01   243
#> 53  1953-07-01   264
#> 54  1953-08-01   272
#> 55  1953-09-01   237
#> 56  1953-10-01   211
#> 57  1953-11-01   180
#> 58  1953-12-01   201
#> 59  1954-01-01   204
#> 60  1954-02-01   188
#> 61  1954-03-01   235
#> 62  1954-04-01   227
#> 63  1954-05-01   234
#> 64  1954-06-01   264
#> 65  1954-07-01   302
#> 66  1954-08-01   293
#> 67  1954-09-01   259
#> 68  1954-10-01   229
#> 69  1954-11-01   203
#> 70  1954-12-01   229
#> 71  1955-01-01   242
#> 72  1955-02-01   233
#> 73  1955-03-01   267
#> 74  1955-04-01   269
#> 75  1955-05-01   270
#> 76  1955-06-01   315
#> 77  1955-07-01   364
#> 78  1955-08-01   347
#> 79  1955-09-01   312
#> 80  1955-10-01   274
#> 81  1955-11-01   237
#> 82  1955-12-01   278
#> 83  1956-01-01   284
#> 84  1956-02-01   277
#> 85  1956-03-01   317
#> 86  1956-04-01   313
#> 87  1956-05-01   318
#> 88  1956-06-01   374
#> 89  1956-07-01   413
#> 90  1956-08-01   405
#> 91  1956-09-01   355
#> 92  1956-10-01   306
#> 93  1956-11-01   271
#> 94  1956-12-01   306
#> 95  1957-01-01   315
#> 96  1957-02-01   301
#> 97  1957-03-01   356
#> 98  1957-04-01   348
#> 99  1957-05-01   355
#> 100 1957-06-01   422
#> 101 1957-07-01   465
#> 102 1957-08-01   467
#> 103 1957-09-01   404
#> 104 1957-10-01   347
#> 105 1957-11-01   305
#> 106 1957-12-01   336
#> 107 1958-01-01   340
#> 108 1958-02-01   318
#> 109 1958-03-01   362
#> 110 1958-04-01   348
#> 111 1958-05-01   363
#> 112 1958-06-01   435
#> 113 1958-07-01   491
#> 114 1958-08-01   505
#> 115 1958-09-01   404
#> 116 1958-10-01   359
#> 117 1958-11-01   310
#> 118 1958-12-01   337
#> 119 1959-01-01   360
#> 120 1959-02-01   342
#> 121 1959-03-01   406
#> 122 1959-04-01   396
#> 123 1959-05-01   420
#> 124 1959-06-01   472
#> 125 1959-07-01   548
#> 126 1959-08-01   559
#> 127 1959-09-01   463
#> 128 1959-10-01   407
#> 129 1959-11-01   362
#> 130 1959-12-01   405
#> 131 1960-01-01   417
#> 132 1960-02-01   391
#> 133 1960-03-01   419
#> 134 1960-04-01   461
#> 135 1960-05-01   472
#> 136 1960-06-01   535
#> 137 1960-07-01   622
#> 138 1960-08-01   606
#> 139 1960-09-01   508
#> 140 1960-10-01   461
#> 141 1960-11-01   390
#> 142 1960-12-01   432