Effacer les filtres
Effacer les filtres

how to reduce the information contained in each field in a struct array?

3 vues (au cours des 30 derniers jours)
I have a very big struct array which can be summarized in something like this:
A = [0 0 0 0 0 0;
1 -1 0 0 0 0;
0 1 -1 1 0 0;
0 0 1 -1 0 -1;
0 0 1 0 -1 0];
structArray.A=A;
structArray.B={'B1[a]' 'B2[b]' 'B3[a]' 'B4[a]' 'B5[b]'}; % correspond to the rows
structArray.C={'C1' 'C2' 'C3' 'C4' 'C5' 'C6'}; % correspond to the columns
structArray.D={'D1' 'D2' 'D3' 'D4' 'D5'}; % correspond to the rows
structArray.E={'E1' 'E2' 'E3' 'E4' 'E5' 'E6'}; % correspond to the columns
If I use:
coolData=regexp(structArray.B,'(?<=\[).+?(?=\])','match')';
coolData=cellfun(@char, coolData);
coolerData=strmatch('a',coolData);
I will obtain all the rows relevant to me (all the rows with an "a" in the structArray.B), in this example:
coolerData =
1
3
4
I want to delete the all the columns from A and the corresponding data on structArray.C and structArray.E (which represent the columns) where the column and the rows obtained in "coolerData" are == to zero (in this example where all the elements in A([1 3 4],columns) are equal 0, therefore, columns 1 and 5) so I can obtain:
A = [ 0 0 0 0;
-1 0 0 0;
1 -1 1 0;
0 1 -1 -1;
0 1 0 0];
structArray.A=A;
structArray.B={'B1[a]' 'B2[b]' 'B3[a]' 'B4[a]' 'B5[b]'}; % correspond to the rows
structArray.C={'C2' 'C3' 'C4' 'C6'}; % correspond to the columns
structArray.D={'D1' 'D2' 'D3' 'D4' 'D5'}; % correspond to the rows
structArray.E={'E2' 'E3' 'E4' 'E6'}; % correspond to the columns
And then I want to delete all the row and the corresponding data on structArray.B and structArray.D (which represent the row) where all the row has only zeros (in this example row 1), so I can obtain:
A = [-1 0 0 0;
1 -1 1 0;
0 1 -1 -1;
0 1 0 0];
structArray.A=A;
structArray.B={'B2[b]' 'B3[a]' 'B4[a]' 'B5[b]'}; % correspond to the rows
structArray.C={'C2' 'C3' 'C4' 'C6'}; % correspond to the columns
structArray.D={'D2' 'D3' 'D4' 'D5'}; % correspond to the rows
structArray.E={'E2' 'E3' 'E4' 'E6'}; % correspond to the columns
I did that with a lot of FOR and IF but it looks ugly and take a lot of time (the size of the matrix I'm using it is 7867x12569) Do you have any suggestions, Thanks,

Réponse acceptée

Guillaume
Guillaume le 18 Jan 2017
Modifié(e) : Guillaume le 19 Jan 2017
Function to filter a scalar structure:
function s = filterstruct(s)
rowstocheck = ~cellfun(@isempty, regexp(s.B, '\[a\]', 'once'));
colstodelete = all(s.A(rowstocheck, :) == 0);
s.A(:, colstodelete) = [];
s.C(colstodelete) = [];
s.E(colstodelete) = [];
rowstodelete = all(s.A == 0, 2);
s.A(rowstodelete, :) = [];
s.B(rowstodelete) = [];
s.D(rowstodelete) = [];
end
To then apply to a structure array:
filteredarray = arrayfun(@filterstruct, structArray);
That is assuming that you do have a structure array. Your example shows a scalar structure, not a structure array.

Plus de réponses (0)

Catégories

En savoir plus sur Structures dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by