清空筛选条件
清空筛选条件

string inside a table

2 次查看（过去 30 天）
eric capnu
eric capnu 2017-9-20
回答： Jeremy Hughes 2017-9-21
hi guys:
i export csv files from an url by using urlwrite and readtable commands. the resulting table is (or should be) composed of numbers, somehow some table cells has the value '-'. Because of this, the whole column containing that string '-' become into string values, like this:
column1 column2
------- -------
'12' 34
'10' 12
'-' 20
'1.1' 13.1
'34.9' 66
is there a way to avoid it? i mean, the whole table as numbers...
thanks
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2017-9-20
Is it possible that the original data contained "- 20" with a space between the "-" and the "20" ?
eric capnu
eric capnu 2017-9-20
NaN would be a nice choose. And no, it is just '-'.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2017-9-20
YourTable.column1 = str2double(YourTable.column1);

更多回答（1 个）

Jeremy Hughes
Jeremy Hughes 2017-9-21
Try:
>> T = readtable(filename,'TreatAsEmpty',{'-'})
Jeremy

类别

在 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