Clear Filters
Clear Filters

Fill in missing values in table with NaNs

8 views (last 30 days)
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.

Accepted Answer

Image Analyst
Image Analyst on 6 Jul 2022
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:
If it's bigger than 5 MB, just attach the first few hundred rows instead of the whole table.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!