Convert cell array with different datatypes to numeric
7 次查看(过去 30 天)
显示 更早的评论
Hi everybody,
I am dealing with a cell array, where single numbers are saved as strings in the cells and some cells are empty. So cell2mat does not work. I want to convert the vector to double while keeping the numbers and replacing the empty cells with NaN.
What would be the fastest way to do this?
Best
0 个评论
采纳的回答
Stephen23
2015-3-11
编辑:Stephen23
2015-3-11
As you only have "single numbers" in the cells, then you can use str2double directly on the cell array:
>> A = {'123',[],'4','5678',[],'90'};
>> str2double(A)
ans = [123,NaN,4,5678,NaN,90]
The documentation states: "If str does not represent a valid scalar value, str2double returns NaN."
3 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Data Type Conversion 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!