How to give the name of each column of a matlab file with the data in 8 columns

whos -file alujasto_10_22_lagi.mat

  Name              Size             Bytes  Class     Attributes

  alujasto      10000x8             640000  double              

Hi,

I am trying to give the name of each column of attached .mat file like A, B, C,...... . There are 8 columns of data. Your help will be highly appreciated. Is it going to be the same procedure if I have a .txt file?

Thanks

Dharma

Answer 1

[Walter Roberson]

See array2table

If you need to assign each one to a separate variable (not recommended) then

S = load('alujasto_10_22_lagi.mat');
temp = num2cell(S.alujasto, 1);
[A, B, C, D, E, F, G, H] = temp{:};

Is it going to be the same procedure if I have a .txt file?

See readtable. If the columns do not already have headers, then after you do

T = readtable(YourFileName);

then

T.Properties.VariableNames = {'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H'};

[Dharma Khatiwada]

Thank you very much Walter!

[Dharma Khatiwada]

Hi Walter,

Just quick follow-up with your answer. How do I save T (with name of column header provided) as .xls file?

Thank you

[Walter Roberson]

writetable(T, filename)

[Dharma Khatiwada]

Hi Walter,

One more question.

I am trying to multiply first column (A) of table T by a number 'k' and saving the table with new value of first column. How do I do that?

I want to multiply each element of column A with the same number for the scaling.

Thank you!

Dharma

[Walter Roberson]

newT = T;
newT.A = newT.A * k;
writetable(newT, filename)

[Pedro Alves]

Thank you!