Create new column based on whether values in another column are NaN or a number

1 次查看（过去 30 天）
Thomas Lees
Thomas Lees 2022-6-13
评论： Thomas Lees 2022-6-13
I have a data set with multiple variables, formatted as a timetable. The timetable is currently 20101 x 616.
The variable of interest ('Event_Z') records the occurence of something that I am interested in. The remaining variables are recorded at intervals of one minute. For minutes where an Event_Z occurred, an interger is recorded; for minutes where no Event_Z occurred, NaN is recorded.
I would like to create a new variable in my dataset ('Event_Z_Yes') with a true/false condition, such that :
  • For minutes where an Event_Z value is present, the value is converted to a '1'
  • For minutes where an Event_Z is not present, the NaN value is converted to a '0'.
How would I do this?

请先登录，再回答此问题。

采纳的回答

dpb
dpb 2022-6-13
tData.Event_Z_Yes=isfinite(tData.Event_Z);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Time Series 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by