Create new column based on whether values in another column are NaN or a number
1 visualización (últimos 30 días)
Mostrar comentarios más antiguos
Thomas Lees
el 13 de Jun. de 2022
Comentada: Thomas Lees
el 13 de Jun. de 2022
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?
0 comentarios
Respuesta aceptada
Más respuestas (0)
Ver también
Categorías
Más información sobre Time Series en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!