MATLAB: How to create column names

column names

I have a 1×49 cell array (header_file) that contains the column names of a 1998×49 double data array (data_file). How do I make the 49 values in the header_file be the 49 column names in the data_file?

Best Answer

Can you use a structure instead with fieldnames of the column names?

1. Read the names in as strings.

2. Read the data into an array.

3. Use setfield to assign fieldnames to the structure and set the value to the appropriate column of the array.

Related Solutions

MATLAB: Convert an 18×1 cell array in a 3×6 cell array

reshape(cell_array,3,[])

MATLAB: How to loop through variables names

I managed to solve this issue. Thanks to the input from neil jerome. I have to import the layers per file, I was able to create a loop for the readtable command and was able to transfer the tables inside the struc to arrays inside the struct. see the code beneath

clc;
clear all ;
n=44;
for i=1:n
 structName(i).data=readtable(sprintf('layer%d.dat',i));
end
for i=1:n
 structName(i).data.Properties.VariableNames = {'NODE','SX','SY', 'SZ', 'SXY','SYZ','SXZ','Var8','Var9','Var10','Var11'};
end
for i=1:n
    structName(i).data= removevars(structName(i).data,{'SY', 'SZ', 'SXY','SYZ','SXZ','Var8','Var9','Var10','Var11'});
end
for i=1:n
    structName(i).data=structName(i).data(~any(ismissing(structName(i).data),2),:);
    
end
for i=1:n
    structName(i).data_new1=zeros(224,2);
end 
for i=1:n
    structName(i).data_new=table2array(structName(i).data);
end 
figure;
hold on
for ii = 1:n
 plot(structName(ii).data_new(:,1),structName(ii).data_new(:,2));
end
E = (structName(1).data_new(:,1));
for i=1:n
    E(:,i+1)=(structName(i).data_new(:,2));
end
%multiply every layer*layerthickness
P=zeros(224,2);
P(:,1)=structName(1).data_new(:,1);
for i=1:224
    P(i,2)=sum(E(i,2:n)*0.23)/(0.23*n);
end
figure;
plot(P(:,1),P(:,2))

Best Answer

Related Solutions

MATLAB: Convert an 18×1 cell array in a 3×6 cell array

MATLAB: How to loop through variables names

Related Question