Clear Filters
Clear Filters

getting a specific column from a table

527 views (last 30 days)
Hi Guys So I have a table (T) that I created from a cvs file. It has column headers and I want to assign x = content so x column 1 and y = contents of col 2 (for example)
How do I do that?
It seems so silly to ask but I don't know the syntax.
x & y will be used in my linear regression model.
Thanks!!!

Accepted Answer

Walter Roberson
Walter Roberson on 15 Oct 2015
x = T{1};
y = T{2};
  3 Comments
Peter Perkins
Peter Perkins on 16 Oct 2015
If it's a table as in, you used readtable to read in a CSV file, that syntax won't work. Assuming your variable names in the table are X and Y, the simplest thing is just
x = T.X;
y = T.Y;
Alternatively,
x = T{:,'X'}; % or T{:,1}
y = T{:,'Y'}; % or T{:,2}
will work. There really is documentation for this, see for example, Accessing Data in a Table.
Walter Roberson
Walter Roberson on 16 Oct 2015
Darn, I keep forgetting the : needed for extracting rows. ;(

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!