Clear Filters
Clear Filters

Delete Rows With empty elements

1 view (last 30 days)
T
T on 19 Aug 2013
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?
  2 Comments
Azzi Abdelmalek
Azzi Abdelmalek on 19 Aug 2013
Do you want to delete just 3 rows?

Sign in to comment.

Accepted Answer

Azzi Abdelmalek
Azzi Abdelmalek on 19 Aug 2013
data1(any(cellfun(@(x) any(isnan(x)),data1),2),:)=[]
  3 Comments
Azzi Abdelmalek
Azzi Abdelmalek on 19 Aug 2013
Edited: Azzi Abdelmalek on 19 Aug 2013
Why have you changed data1? this has nothing to do with your question
T
T on 19 Aug 2013
Sorry, the original post should have read data2.

Sign in to comment.

More Answers (0)

Categories

Find more on Numeric Types in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!