Fill in missing values in table with NaNs

9 次查看（过去 30 天）
BA
BA 2022-7-6
回答： Image Analyst 2022-7-6
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
Image Analyst 2022-7-6
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.

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by