Fill in missing values in table with NaNs

I have a really large table and there are lots of empty cells in the data table that were replaced with ' " '

I want to change these values to 'NaN' instead of how they are currently being replaced. Hoping to find a way to code this into a script so people in the future don't have to when they use my data.

[Chunru]

Attach some sample data.

Answer 1

[Image Analyst]

If it currently shows as an empty string, then it can't be a nan. Nans are only for numeric variables, not string variables. Why can't you just leave them as they are? You can always skip processing those rows if you want. Why do you think you need to convert them to nans?

If you have any more questions, then attach your data and code to read it in with the paperclip icon after you read this:

TUTORIAL: How to ask a question (on Answers) and get a fast answer

If it's bigger than 5 MB, just attach the first few hundred rows instead of the whole table.