Find Column Number in Table

73 次查看（过去 30 天）
Robot
Robot 2014-10-7
评论： Robot 2014-10-9
I would like to subset a table into columns before a certain variable and columns after that variable. Is there a way to locate a column number within a table? Is there a more clever way to do this?
load patients
BloodPressure = [Systolic Diastolic];
T = table(Gender,Age,Smoker,BloodPressure,'RowNames',LastName);
A = *findColNumber*(T, 'Age'); % Some function that will locate the column number of 'Age'.
T1 = T(:, 1:A);
T2 = T(:, A+1:end);
'patients' is a standard example data set included in R2014a. Entering the command 'load patients' should load the relevant data.
Thanks!

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

采纳的回答

Mohammad Abouali
Mohammad Abouali 2014-10-8
Table variable have property fields
you can use that to find the column number like this
find(strcmpi(T.Properties.VariableNames,'Age'))
ans =
2
  4 个评论
显示 2更早的评论
Image Analyst
Image Analyst 2014-10-8
编辑：Image Analyst 2014-10-8
Yeah, your T is slightly different than mine. No time now, but tomorrow I'll have to investigate why your code and mine behave differently and have slightly different T's. You'd think they should be the same even though they were gotten in different ways.
Actually I just figured it out. With my code, load() returns T as a structure not a table. So that makes sense.
Robot
Robot 2014-10-9
Thanks for the help!

请先登录，再进行评论。

更多回答（1 个）

Image Analyst
Image Analyst 2014-10-7
You don't need the column number. Just do
ages = T.Age;
  3 个评论
显示 1更早的评论
Image Analyst
Image Analyst 2014-10-8
编辑：Image Analyst 2014-10-8
You can get the age column like this:
T = load('patients')
ageColumn = find(ismember(fieldnames(T), 'Age'))
Image Analyst
Image Analyst 2014-10-8
Actually T is a structure, so I recommend Mohammad's way.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by