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

2 次查看（过去 30 天）
Melissa
Melissa 2014-12-4
编辑： Guillaume 2014-12-5
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更早的评论
Guillaume
Guillaume 2014-12-4
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
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

请先登录，再进行评论。

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

采纳的回答

Guillaume
Guillaume 2014-12-4
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
Melissa 2014-12-4
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
Guillaume 2014-12-5
编辑：Guillaume 2014-12-5
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.

请先登录，再进行评论。

更多回答（1 个）

Star Strider
Star Strider 2014-12-4
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:
C =
5 10
15 20
30 50
I worked with other options but couldn’t get them to produce this any more efficiently.
  3 个评论
显示 1更早的评论
Star Strider
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
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

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by