How can I replace "" entries in a table?

3 次查看（过去 30 天）
Kamal Premaratne
Kamal Premaratne 2020-5-28
评论： Kamal Premaratne 2020-5-28
I imported a large table (300 x 450) and some of the blank entries were imported as "". For the purpose of this question, let me take a part of one column:
>> TT = T(end-4:end,end)
TT =
5×1 table
vm2PR
_____
VC02 ""
VC03 ""
VC04 "6"
VC05 "2"
VC06 ""
How do I replace these "" entries with numerical value 0.0 and the "2" and "6" entries as numerical values 2 and 6 respectively? This has to be done for the whole large table (which is named T). Thank you.

请先登录，再回答此问题。

采纳的回答

madhan ravi
madhan ravi 2020-5-28
iX=str2double(TT.vm2PR);
TT.vm2PR(isnan(iX))=0

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by