Delete Rows With empty elements

T
T
2013 8 19
1 个回答
回答已采纳
5 次查看（30 天）

0 个投票

Suppose I have a set of data (a 2x9 matrix):
data2 =
[ 1] [0.0095] [5670000] [936] 'Normal' [0] [0] [0] [ NaN]
[ 2] [0.0095] [5670000] [936] 'Normal' [0] [0] [0] [ NaN]
[ 3] [0.0095] [5670000] [936] 'Normal' [0] [0] [0] [ NaN]
[ 4] [0.0095] [5670000] [936] 'Normal' [0] [0] [0] 'some text'
[ 5] [0.0095] [5670000] [936] 'Normal' [0] [0] [0] 'some text'
I want to be able to detect the NaN's and delete the first three columns.
Typically this is done through
data1(find(sum(isnan(data2),2)==0),:)
but isnan is for input arguements of type 'cell'. What else can I try?

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

 采纳的回答

Azzi Abdelmalek
Azzi Abdelmalek 2013-8-19

1 个投票

data1(any(cellfun(@(x) any(isnan(x)),data1),2),:)=[]

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

T
T 2013-8-19
That works but when I try to implement it in a loop, I get an error message when trying to get the index:
data1(any(cellfun(@(x) any(isnan(x)),data1),2),:)=[]
negativeID = [Data2; [{1},{0}]]
a=negativeID(:,1);
find(ismember([a{:}],[Data1{:}])==1)
Data1 ={ 4
5
6
7
8
9
10
11
12
-1
4
5
6
7
8
9
10
11
12
-1
4
5
6
7
8
9
10
11
12
-1
4
5
6
7
8
9
10
11
12
-1}
Data2={[ 4] [0.0119]
[ 5] [0.0119]
[ 6] [0.0143]
[ 7] [0.0143]
[ 8] [0.0187]
[ 9] [0.0256]
[10] [0.0273]
[11] [0.0119]
[12] [0.0143]
[-1] [ 0 ]}
Azzi Abdelmalek
Azzi Abdelmalek 2013-8-19
编辑：Azzi Abdelmalek 2013-8-19
Why have you changed data1? this has nothing to do with your question
T
T 2013-8-19
Sorry, the original post should have read data2.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Cell Arrays 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by