Change text to numbers in a cell

18 ビュー (過去 30 日間)
Mike Mierlo van
Mike Mierlo van 2020 年 5 月 7 日
コメント済み: Mike Mierlo van 2020 年 5 月 11 日
Hi all,
Lets say I have 4 x 2 cell matrix A:
1 'text one' 'text two'
2 '5' 'text two'
3 'text one' 'text two'
4 '10' 'text two'
I want the result of a 4 x 2 cell matrix A of all doubles, exept for the last column. The 'text one' has to be replaced by 1 (double):
1 1 'text two'
2 5 'text two'
3 1 'text two'
4 10 'text two'
When I use a for-loop and if-statement I get the error that matrix dimensions must agree. Below is my faulty code:
for i = 1:size(A,1)
if A{i,2} == 'text one'
A{i,2} == 1
else
A{i,2} == str2double(A{i,2})
end
end

採用された回答

Akira Agata
Akira Agata 2020 年 5 月 8 日
How about the following?
B = replace(A,'text one','1');
B = cellfun(@str2double,B(:,1:end-1),'UniformOutput',false);
A = [B,A(:,end)];
  3 件のコメント
Mike Mierlo van
Mike Mierlo van 2020 年 5 月 8 日
Now it works. Because I tried some things, my A(:,2) was converted to doubles with NaN's instead of text. Resetting A to the original cell was the solution. thank you!

サインインしてコメントする。

その他の回答 (1 件)

madhan ravi
madhan ravi 2020 年 5 月 7 日
編集済み: madhan ravi 2020 年 5 月 7 日
V = str2double(string(A)); % <2016a
V(isnan(V)) = 1
  4 件のコメント
Mike Mierlo van
Mike Mierlo van 2020 年 5 月 11 日
Madhan Ravi. Yes, I editted it after your answer. Your answer worked perfectly on my simplified problem, but I simplified it so far that your solution did not work on my actual table, that consisted of more text columns too.
Walter Roberson. Yes A has more numeric values too. I solved it by converting them to strings for the needed operation.

サインインしてコメントする。

Community Treasure Hunt

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

Start Hunting!

Translated by