Change non-numerics into NaN & split cell array by delimiter

Question

Melissa 2014-12-4

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165346-change-non-numerics-into-nan-split-cell-array-by-delimiter

编辑： Guillaume 2014-12-5

采纳的回答： Guillaume

I have a 3000x1 cell array of depth in centimeters with both letters and numbers

EX:

A = {organic layer, 5~10, 15~20, 30~50, not specified}

I want to change all of the non-numeric bins into NaN and then split this array into both the lower and upper bound of depth so that

Lower Bound = {NaN, 5, 15, 30, NaN}; Upper Bound = {NaN, 10, 20, 50, NaN};

I tried to use numind = cellfun(@isnumeric, A) to find the numeric indices and then from that find all of the indices that ARENT numeric, to replace with NaN, but it simply says that all of the bins are not numeric because of the '~' between the integers.

Is there any way that I could accomplish this?

Thanks, Melissa

6 个评论
显示 4更早的评论隐藏 4更早的评论

Guillaume 2014-12-4

在 MATLAB Online 中打开

There are some cells in your cell array that contain numbers instead of strings. To see which ones:

find(cellfun(@(x) isnumeric(x), Depthcm))

Melissa 2014-12-4

When I use isnumeric, it tells me that none of the cells are numeric, and when I use ischar, it tells me that ALL of the cells are char. How do I overcome this obstacle? I don't know why matlab would be characterizing it as such

Thanks, Melissa

请先登录，再进行评论。

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

Answer 1

Guillaume 2014-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165346-change-non-numerics-into-nan-split-cell-array-by-delimiter#answer_161306

在 MATLAB Online 中打开

Once you've fixed the numeric values in you cell array, with for example:

Depthcm(cellfun(@(x) isnumeric(x), Depthcm)) = {''};

You can get your arrays with:

splitdepth = regexp(Depthcm, '~', 'split');
splitdepth(cellfun(@(c) numel(c) == 1, splitdepth)) = {{'Nan' 'NaN'}};
bounds = str2double(vertcat(splitdepth{:}));

2 个评论
显示无隐藏无

Melissa 2014-12-4

depthcm.mat

The problem I'm having is that, when I use cellfun to find isnumeric, all of the elements are 0, and when I use ischar, it says that all the elements are char. Therefore, I don't really have any way to find which are numeric and which are characters, because for some reason matlab is characterizing all of them as characters. Here is the .mat file attached if it helps

Guillaume 2014-12-5

编辑：Guillaume 2014-12-5

在 MATLAB Online 中打开

I did test my code with your matrix prior to posting:

clear
load('depthcm.mat')
find(cellfun(@(x) isnumeric(x), Depthcm))
ans = 
      2910
      2911
      2913
      2914
      2916
      2917
      2919
      2920

If you get something different, then something is very wrong.

请先登录，再进行评论。

Answer 2

Star Strider 2014-12-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/165346-change-non-numerics-into-nan-split-cell-array-by-delimiter#answer_161212

在 MATLAB Online 中打开

I’m not certain how your cell is organised, but assuming the structure here, this code will at least get you the numbers:

A = {'organic layer', '5~10', '15~20', '30~50', 'not specified'};
B = strrep(A, '~', ' ');
C = str2num(char((B(2:4)')));

producing:

I worked with other options but couldn’t get them to produce this any more efficiently.

3 个评论
显示 1更早的评论隐藏 1更早的评论

Star Strider 2014-12-4

When I use exactly that code and ‘A’, it works without error (or I’d not have posted it).

What’s different about my ‘A’ and your cell array?

(I’m using R2014b, so there could be version differences.)

Melissa 2014-12-4

I just posted the .mat file, I'm not really sure how they are different because they look the same to me? But I'm not very knowledgable about the difference between cell arrays and cell arrays of strings and whatnot.

Any help would be appreciated! Thank you, Melissa

请先登录，再进行评论。