How to replace string by double in cell array

1 次查看（过去 30 天）
Gregory Wurtz
Gregory Wurtz 2020-5-19
评论： Gregory Wurtz 2020-5-20
I am importing an Excel file in Matlab using the readtable command. For some reason, one collumn in the dataset does not load as doubles (all number columns are identically formatted in the Excel file as much as I can tell) but as string characters:
prompting the deficient column:
>>T{3,1}{:,14}
ans =1699×1 cell array
I need to replace the strings in T{3,1}{:,14} with doubles.
The following command returns an error:
>> T{3,1}{:,14}=str2double(T{3,1}{:,14})
Conversion to cell from double is not possible.
If is use:
T{3,1}{:,14}=num2cell(str2double(T{3,1}{:,14}))
the content of the column is no longer a double.
Do you have a solution to this (seemingly trivial) problem?
Thanks
  2 个评论
Walter Roberson
Walter Roberson 2020-5-19
Would it be possible for you to upload the file for testing?
Gregory Wurtz
Gregory Wurtz 2020-5-19
Here is the file with some example columns. The deficient data is in column cc.

请先登录，再进行评论。

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

采纳的回答

Sulaymon Eshkabilov
D1D=readtable('test.xlsx');
D1D.cc=str2double(D1D.cc);

更多回答（2 个）

Sulaymon Eshkabilov
use a command: double()
To get back your strings use the command: char()
  1 个评论
Gregory Wurtz
Gregory Wurtz 2020-5-19
I am not sure how this solves my problem: I would like to replace the string in the cell array with doubles. I included the data in the feed above.
Thanks for your help.

请先登录，再进行评论。

Walter Roberson
Walter Roberson 2020-5-19
filename = 'test.xlsx';
opt = detectImportOptions(filename);
opt = setvaropts(opt, 3, 'Type', 'double');
T = readtable(filename, opt);
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2020-5-19
I tested on your sample file before posting. This code fixes the readtable so that it loads as numeric in the first place avoiding the cell

请先登录，再进行评论。

类别

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

标签

产品


版本

R2020a

Community Treasure Hunt

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

Start Hunting!

Translated by