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

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?

Answer 1

[dpb]

tData.Event_Z_Yes=isfinite(tData.Event_Z);

[Thomas Lees]

Smashing. Thanks very much!