Eliminating specific data from a file

Currently I am working with variables that have 1400 data inputs each and some of them come out as NaN. Is there a way to scan the variables to remove the NaNs and create new ones automatically? I tried setting it up with a for and an if cycle but didn’t find much success, will send screenshot of my attempts asap since I don’t have them with me rn.

Answer 1

[Star Strider]

There are functions like fillmissing to interpolate the NaN entries and rmmissing to delete them (the entire row with a NaN entry).

[Lorenzo]

Thank you I’ll try as soon as I get home

[Star Strider]

My pleasure!

[Lorenzo]

Sorry for the late reply, worked like a charm, thank you.

[Star Strider]

As always, my pleasure!