MATLAB: Hi, how can I name 561 columns in few steps

datadata importMATLABmatrix manipulationstringvector

I have "AssetName" vector 1×561 and respective matrix of "AssetReturns" 255×561 for each of the 561 Assets. i want to have the same result as–> AssetName = {'pinco','pallo', 'caio', 'sempronio'} just I do not want to type 561 names.. any idea? thanks a lot in advance

Best Answer

tab = array2table(AssetReturns);

tab will now be a table object with column names such as 'Var1', 'Var2'.

If you had a cell array of strings with the names, you could

tab = array2table(AssetReturns, 'VariableNames', TheCellArrayOfNames);

http://www.mathworks.com/matlabcentral/answers/304528-tutorial-why-variables-should-not-be-named-dynamically-eval

Related Solutions

MATLAB: Retrieve column vectors from table with correspondent names

It does sound like varfun is indeed what you need.

For example, to multiply all your columns by 1.5

newtable = varfun(@(col) col*1.5, yourtable)

You can easily include or exclude some particular columns by filtering the strings returned by yourtable.Properties.VariableNames and passing that as 'InputVariables' to varfun if required.

You can also easily rename the columns in the new table, for example, to add 'Wt' to all the names

newtable.Porperties.VariableNames = compose('%sWt', string(newtable.Porperties.VariableNames));

In any case, I would advise against creating new variables, particularly using eval.

MATLAB: Am I unable to start analog data acquisition with the Measurement Computing PCI-DAS4020/12 with InstaCal version 5.61 and the Data Acquisition Toolbox 2.8.1 (R2006a)

Failures with supported versions of InstaCal may occur when the MCC DAQ Adaptor from one version of MATLAB is unintentionally used in another. To diagnose this situation, execute the following command at the MATLAB Command Prompt:

daqsupport

Verify that the listed adaptors match your current version of MATLAB.

Best Answer

Related Solutions

MATLAB: Retrieve column vectors from table with correspondent names

MATLAB: Am I unable to start analog data acquisition with the Measurement Computing PCI-DAS4020/12 with InstaCal version 5.61 and the Data Acquisition Toolbox 2.8.1 (R2006a)

Related Question