Use For Loop to obtains variable name and value from Table

17 次查看（过去 30 天）
Adrian
Adrian 2023-11-9
回答： Arun 2024-1-4
Hi,
I am having trouble automatically creating varaibales from the below table? at the moment doing this by coding each individual column
Any help much appreciated
  4 个评论
显示 2更早的评论
Dyuman Joshi
Dyuman Joshi 2023-11-9
You can get the variable names from the table and use them to access the data
names = TableName.Properties.VariableNames
dpb
dpb 2023-11-9
编辑：dpb 2023-11-9
Are the names consistent or do they change all over the place from one file to another? If they always relate to a given property but may just have a different trailing subscript such as the example file but are the same variables as far as processing given the initial name string, I often will do a name substitution to a set of convenient predefined names that are succinct but meaningful for coding. The substitution can be done with string pattern matching to ensure positions aren't moved around. Simply change the Properties.VariableNames cell array as @Dyuman Joshi notes above or use the renamevars function.
Doing it this way means you can code the application with a convenient set of variables and not worry about finding stuff dynamically at all. It can be done that way, but why make things more complicated if simpler can work?

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Arun
Arun 2024-1-4
Ran in:
Hi Adrian,
I understand that you want to obtain variable names and data from a table created with automatically created variable names.
This can be done using the table properties or using the “renamevars” function. Here is a code snippet that might be useful:
%creating a sample table
% you can use dataTable = readtable('yourFile.csv','TextType','string')
% Define the number of rows and columns
numRows = 5;
numCols = 4;
% Generate random values for the table
tableData = rand(numRows, numCols);
% Create a table with column names
columnNames = {'Column1', 'Column2', 'Column3', 'Column4'};
dataTable = array2table(tableData, 'VariableNames', columnNames);
%solution to the issue:
%using table properties:
names = dataTable.Properties.VariableNames;
disp(dataTable.(names{1}));
0.9053 0.4372 0.1485 0.6844 0.7502
%Solution 2:
%Using renamevars function
allVars = 1:width(dataTable);
newNames = append("Reading",string(allVars));
dataTable = renamevars(dataTable,allVars,newNames);
disp(dataTable);
Reading1 Reading2 Reading3 Reading4 ________ ________ ________ ________ 0.90528 0.94104 0.29029 0.58789 0.43721 0.95657 0.34875 0.86429 0.14846 0.6348 0.55673 0.29821 0.68438 0.054584 0.77649 0.068242 0.75015 0.041656 0.32132 0.63615
disp(dataTable.Reading1); % here we can see that, data is accessed using variables defined by us.
0.9053 0.4372 0.1485 0.6844 0.7502
For more information regarding "renamevars" function please refer the shared MATLAB Documentation link:
https://www.mathworks.com/help/matlab/ref/table.renamevars.html
I hope this helps.

类别

在 Help Center 和 File Exchange 中查找有关 Tables 的更多信息

标签

产品


版本

R2023a

Community Treasure Hunt

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

Start Hunting!

Translated by