MATLAB: Change table of structs into columns of data in a table

MATLABstructstructurestable

I have many tables which contain anywhere from 2000 – 7500 1×1 structs in one column. Each struct contains a value for x, y and z positions. I need to extract these 3 numbers from each struct and have them in their own columns (as just regular floats). The end result will be a table with a column for x values, a column for y values, and a column for z values.

I've attached an example file (.mat).

What is an efficient way to do this?

Best Answer

Based on your example data this will work. All structs must have the exact same fields, otherwise this will fail

flattened = struct2table(vertcat(data{:,1}));

Related Solutions

MATLAB: Convert struct with several fields into long table

Try this

T = array2table(cell2mat(squeeze(struct2cell(trai)).'), 'VariableNames', fieldnames(trai))

MATLAB: Converting nested “summary” structure to table

Here's the loop version. There may be another way, but I didn't have any luck fighting with Matlab's tricky multiple-cell return behaviour

% create minimal test structure
mystruct.Days_from_development = struct('size',[118,1],'Type','double');
mystruct.HIV = struct('size',[52,3],'Type','string');
% get a list of all the fieldnames (i.e. substructures, i.e. names of tables)
table_names = fieldnames(mystruct);
% loop over substructures
for ind=1:length(table_names)
    % get the string for each substructure's name
    tmp = table_names{ind};
    % dump the substructure to a table row
    % by turning it into a 1xN cell array and putting the substructure string as the first cell
    mytable(ind,:) = cell2table([{tmp} struct2cell(mystruct.(tmp))']);
end
% rename the table variables appropriately
mytable.Properties.VariableNames = [{'table_name'};fieldnames(mystruct.(tmp))]

Best Answer

Related Solutions

MATLAB: Convert struct with several fields into long table

MATLAB: Converting nested “summary” structure to table

Related Question