MATLAB: Delete rows based on whether the value in column 10 of the respective row is equal to one or not

columnscriteriadelete rows

Hi,

I tried to solve the problem described above with the following formula:

      dataset=[dataset,delete];
      rowsToDelete8 = dataset(:,10)==1;
      dataX(rowsToDelete8, :) = [];

where dataset is double and the 10th column is either 1 or 0

While doing this, I get the following error message:

Index of element to remove exceeds matrix dimensions.
Error in deleteSeriesWithOnlyFourElements (line 67)
    dataX(rowsToDelete8, :) = [];

I do not really understand why it's not working

Best Answer

rowsToDelete8 was based on looking at dataset, not dataX, but then you try to use it in dataX, which is evidently not the same size as dataset.

Also, don't use "delete" as the name of a variable like you did in "dataset=[dataset,delete];"

Related Solutions

MATLAB: If loop that is not working properly, row should be deleted based on several criterias but do not

Try it this way

rowsToDelete = data(:,8) > 1.1 | data(:,8) < 0.9;
data(rowsToDelete, :) = [];

Do the same for column #5. You could combine column 5 into the calculation of rowsToDelete if you want.

MATLAB: How to add new column in a dataset array but not at the end

Alexis, I am niot 100% sure from your description exactly what you are trying to do. I'm going to assume that you want to create a new dataset that is a vertical concatenation of the first dataset and the second. But since the first has fewer variables, you need to create the missing variables, and you'd like to fill them with NaN.

You mention wanting to insert variables in the first dataset. You can only create a new variables at the end. So if you want to insert new variables in the middle, you need to take two steps: create them at the end, and then use subscripting to rearrange. Given this ...

   a = dataset(randn(10,1),randn(10,1),'VarNames',{'W' 'X'});

... you can do something like this ...

   a(:,{'Y' 'Z'}) = dataset(NaN(10,1),NaN(10,2));
   a = a(:,[1 3:4 2])

... to rearrange. But there may not be any need to do this. Concatenation for dataset works by matching up variable names, and it doesn't matter what order they are in. So you can concatenate these two arrays

   a = dataset(randn(10,1),randn(10,1),'VarNames',{'X' 'Y'});
   b = dataset(randn(10,1),randn(10,1),'VarNames',{'Y' 'X'});

even though the variables are in a different order.

Best Answer

Related Solutions

MATLAB: If loop that is not working properly, row should be deleted based on several criterias but do not

MATLAB: How to add new column in a dataset array but not at the end

Related Question