Fill in missing values in table with NaNs
9 views (last 30 days)
Show older comments
BA on 6 Jul 2022
Answered: Image Analyst on 6 Jul 2022
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.
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)
Find more on Numeric Types in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!Start Hunting!