getting a specific column from a table

312 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)

Categories

Find more on Tables in Help Center and File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!