How to convert a structure array into vector

131 visualizzazioni (ultimi 30 giorni)
Hello.
I have a structure array (1 x 50000) with 10 fields. The elements in the fields are arrays (1 x 50). I want to convert this structure array into a scalar structure with same fields such that, its size is (50000*50 x 1).
  5 Commenti
Jos (10584)
Jos (10584) il 9 Ago 2019
Modificato: Jos (10584) il 9 Ago 2019
This is not a small example :-)
Provide 1x3 Main structure (the input) and expected out. That would help
SS
SS il 9 Ago 2019
Modificato: SS il 9 Ago 2019
Hi.
The input is something like,
Main(1).fel1=[1,2,3,4,5];
Main(2).fel1=[10,20];
Main(1).fel2=[2,4,6,8,10];
Main(2).fel2=[150,200];
The output should be,
Main(1).fel1=1, Main(2).fel1=2, Main(3).fel1=3.........Main(7).fel1=20
Main(2).fel2=2, Main(2).fel2=4, ..........................Main(7).fel2=200

Accedi per commentare.

Risposta accettata

Stephen23
Stephen23 il 9 Ago 2019
Modificato: Stephen23 il 9 Ago 2019
S(1).F1 = [1,2,3,4,5];
S(2).F1 = [10,20];
S(1).F2 = [2,4,6,8,10];
S(2).F2 = [150,200];
F = fieldnames(S);
C = num2cell(struct2cell(S),3);
C = cellfun(@(c)[c{:}],C,'uni',0);
C = num2cell(vertcat(C{:}));
T = cell2struct(C,F,1)
Giving:
T =
7x1 struct array with fields:
F1
F2
Checking the first field's values:
>> S.F1 % input
ans =
1 2 3 4 5
ans =
10 20
>> T.F1 % output
ans = 1
ans = 2
ans = 3
ans = 4
ans = 5
ans = 10
ans = 20
  3 Commenti
SS
SS il 9 Ago 2019
I have another question. How can this be implemented if, the size of the arrays is not same throughtout. For example, if the input is
Main(1).fel1=[1,2,3,4,5];
Main(2).fel1=[10,20,30];
Main(1).fel2=[2,4,6,8];
Main(2).fel2=[150,200];
The output should be,
Main(1).fel1=1, Main(2).fel1=2, Main(3).fel1=3.........Main(8).fel1=30
Main(2).fel2=2, Main(2).fel2=4, ..........................Main(6).fel2=200
Stephen23
Stephen23 il 9 Ago 2019
"How can this be implemented if, the size of the arrays is not same throughtout."
Something like this should work:
  1. decide what default value/array should go into those fields that are unassigned (e.g. empty numeric, NaN).
  2. measure the sizes of all vectors
  3. preallocate a cell array of the correct size, using your default value.
  4. loop over the fieldnames
  5. concatenate the data (comma-separated lists will likely be useful here), convert to cell.
  6. assign to the cell array using the length of the concatenated data.
  7. convert to structure using struct2cell.

Accedi per commentare.

Più risposte (1)

Jos (10584)
Jos (10584) il 9 Ago 2019
Why on earth store scalar values like that? Why not have a simple, highly efficient M-by-N matrix, rather than a cumbersome M-by-1 structure array, with N fields, each storing a single scalar value.
% a structure array with N = 2 fields. Each field holds overall and in total 7 elements
S(1).F1 = [1,2,3,4,5];
S(2).F1 = [10,20];
S(1).F2 = [2,4,6,8,10];
S(2).F2 = [150,200];
A = arrayfun(@(f) [S.(f{:})].', fieldnames(S), 'un', 0)
A = [A{:}] % a 7-by-2 matrix
  3 Commenti
Jos (10584)
Jos (10584) il 9 Ago 2019
You should store values in a way that make sense to you. What is the relationship between the two fields of a particular element of the structure array (example: what do fel1 and fel2 of Main(k) have in common.) The same holds for the values inside a field. What do Main(J).fel1(K) and Main(J).fel2(K) have in common?
In your example, I (we?) assumed that there is a direct relations ship between the position in the output (either as matrix or a structure) and the position in the input. However, this does not seem to be the case.
Think about that and then describe what kind of output you need for further processing...
Jos (10584)
Jos (10584) il 9 Ago 2019
Modificato: Jos (10584) il 9 Ago 2019
One option is to keep the fields blank, or fille the empty spots in my output with NaNs.
One can use my function PADCAT to pad shorter vectors (being concatenated fields) with NaNs:
S(1).F1 = [1,2,3,4,5];
S(2).F1 = [10,20];
S(1).F2 = 2 ;
S(2).F2 = [150,200];
A = arrayfun(@(f) [S.(f{:})].', fieldnames(S), 'un', 0)
A = padcat(A{:}) % a 7-by-2 matrix
PADCAT can be found on the File Exchange:

Accedi per commentare.

Categorie

Scopri di più su Data Type Conversion in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by