How to Iterate over the columns of a Matlab table?
166 次查看(过去 30 天)
显示 更早的评论
How can I iterate over the columns of a Matlab table? The Python equivalent and assuming data was a pandas data frame would be:
variable_names=data.keys() #get variable names
for i in variable_names: # iterate over and print all data using variable names
print data[i]
But the corresponding for a Matlab table does not work:
f='Vilar_data.xls';
data=readtable(f);
variables=data.Properties.VariableNames; %get variable names
for i=variables,
data(1:end,{i}) %attemt to iterate over the data by column headings
end
1 个评论
Oleg Komarov
2015-10-25
You need to remove the brackets from {i}, because i will already be a cell containing a string.
采纳的回答
Geoff Hayes
2015-10-25
编辑:Geoff Hayes
2015-10-25
Ciaran - access data in a table illustrates a couple of different ways in which you can access the column data within the table. You can access the column either by its variable index or by its variable name. For example, if you wish to access each column by the variable index, you could something like the following
for k=1:length(variables)
colData = data.(k);
end
In the above, we iterate over each variable and access the column data directly through the variable index.
3 个评论
Maryam Abbaszadeh
2020-9-8
x = [];
x = ['A':'Z'];
for i='A':'Z'
for j='A':'Z'
x = [cellstr(x),[i,j]];
end
end
for i=1:100
app.UITable.ColumnName ={x(i)};
end
i want to change ColumnNames with x characters but it doesn't work with above code
how can I solve this problem?
Image Analyst
2020-9-8
No idea what you want. Please read this link then post your question in a new question along with your desired output.
更多回答(2 个)
Image Analyst
2015-10-25
I would not iterate over variable names, unless they might possibly be created by some weird program that changes what column the data were in. I'd simply just use column number - it's so so much simpler. Run this demo:
% Create sample data (from the help documentation).
LastName = {'Smith';'Johnson';'Williams';'Jones';'Brown'};
Age = [38;43;38;40;49];
Height = [71;69;64;67;64];
Weight = [176;163;131;133;119];
BloodPressure = [124 93; 109 77; 125 83; 117 75; 122 80];
% Create a table, T, as a container for the workspace variables.
T = table(Age,Height,Weight,BloodPressure,'RowNames',LastName)
% Let's see what methods T has
methods(T)
% Now let's iterate over all columns using column number.
for col = 1 : width(T)
fprintf('\nHere is column #%d, which is called %s\n', col, T.Properties.VariableNames{col})
thisColumn = T(:, col) % Extract this one column into its own variable.
% Now do whatever you want with "thisColumn" variable.
end
2 个评论
Image Analyst
2015-10-26
I don't think so. Plus it's way more complicated. Why do you think it's better? My code will work with any table just using a simple index like you're already used to with other variable types. I'm not sure why you imply my code won't "take any table." It certainly will, and in a lot more straightforward manner.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!