MATLAB: How to select particular rows from a matrix

matrix manipulation

Dear all,
I have a panel data set(countries, years) of dimension 20000 by 200. My goal is
1) to choose those countries that correspond to a specific period (1970-2013) AND
2) for which period there are no NaN values Is there a way to do that? Here is a sample matrix Many thanks in advance.
 A={  'country'     'year'  'v1'   'v2' 'v3'     'v4'    'v5' 'v6'  'v7'    'v8'    'v9'    'v10'       'v11'  'v12'
    'Albania'    [1919]    [0]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
    'Albania'    [1920]    [1]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
    'Albania'    [1921]    [0]    [0]    [0]    [0]    [0]    [ 0]    [1]    [0]    [ NaN]    [  1]    [  0]    [  0]
    'Albania'    [1922]    [0]    [0]    [0]    [0]    [0]    [ 0]    [1]    [0]    [ NaN]    [  1]    [  0]    [  0]
    'Albania'    [1923]    [0]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
    'Albania'    [1924]    [1]    [0]    [1]    [0]    [0]    [ 0]    [2]    [1]    [ NaN]    [  1]    [  2]    [  0]
 'Albania'    [1933]    [0]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
 };

Best Answer

Try converting it to a table to make it easier:
A={  'country'     'year'  'v1'   'v2' 'v3'     'v4'    'v5' 'v6'  'v7'    'v8'    'v9'    'v10'       'v11'  'v12'
  'Albania'    [1919]    [0]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
  'Albania'    [1920]    [1]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
  'Albania'    [1921]    [0]    [0]    [0]    [0]    [0]    [ 0]    [1]    [0]    [ NaN]    [  1]    [  0]    [  0]
  'Albania'    [1922]    [0]    [0]    [0]    [0]    [0]    [ 0]    [1]    [0]    [ 42]    [  1]    [  0]    [  0]
  'Albania'    [1923]    [0]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
  'Albania'    [1924]    [1]    [0]    [1]    [0]    [0]    [ 0]    [2]    [1]    [ NaN]    [  1]    [  2]    [  0]
  'Albania'    [1933]    [0]    [0]    [0]    [0]    [0]    [ 0]    [0]    [0]    [ NaN]    [  1]    [  0]    [  0]
  };
t = cell2table(A(2:end,:), 'VariableNames', A(1,:))
yearsInRange = t.year >= 1921 & t.year <= 1923
nonNanRows = ~isnan(t.v9)
% Find out where both are true:
% year in range, and v9 column is not nan
rowsToKeep = yearsInRange & nonNanRows;
% Extract only those rows
newTable = t(rowsToKeep,:)
Echoed to the command window, you can see the steps:
t = 
     country     year    v1    v2    v3    v4    v5    v6    v7    v8    v9     v10    v11    v12
    _________    ____    __    __    __    __    __    __    __    __    ___    ___    ___    ___
    'Albania'    1919    0     0     0     0     0     0     0     0     NaN    1      0      0  
    'Albania'    1920    1     0     0     0     0     0     0     0     NaN    1      0      0  
    'Albania'    1921    0     0     0     0     0     0     1     0     NaN    1      0      0  
    'Albania'    1922    0     0     0     0     0     0     1     0      42    1      0      0  
    'Albania'    1923    0     0     0     0     0     0     0     0     NaN    1      0      0  
    'Albania'    1924    1     0     1     0     0     0     2     1     NaN    1      2      0  
    'Albania'    1933    0     0     0     0     0     0     0     0     NaN    1      0      0  
yearsInRange =
  7×1 logical array
   0
   0
   1
   1
   1
   0
   0
nonNanRows =
  7×1 logical array
   0
   0
   0
   1
   0
   0
   0
newTable = 
     country     year    v1    v2    v3    v4    v5    v6    v7    v8    v9    v10    v11    v12
    _________    ____    __    __    __    __    __    __    __    __    __    ___    ___    ___
    'Albania'    1922    0     0     0     0     0     0     1     0     42    1      0      0  
>>
Related Question