MATLAB Answers

Getting data from specific columns in a table

318 views (last 30 days)
Curious Mind
Curious Mind on 21 Aug 2018
Commented: Curious Mind on 21 Aug 2018
Hello:
I have table_1 and say it has 6 columns. I would to love to have a code that will enable me to get data from a specific column(s) by using the column number or numbers.So lets say I want data from columns 2 and 3, the code should enable me to enter 2 and 3 and then it will search the table and return the data associated with the specified column(s).
Thank you guys.

  0 Comments

Sign in to comment.

Accepted Answer

Stephan
Stephan on 21 Aug 2018
Edited: Stephan on 21 Aug 2018
You get data from a table by using the dot-notation. Therefore use the name of the column. If your columns are named 1...6 use
table_new = table_old.2
to get data from the column named '2'.
Here is an example:
A = table(['a'; 'b'; 'c'],[1; 2; 3],'VariableNames',{'x', 'y'})
If you use:
A.y
you get an array containing all values of the column named 'y'.
Best regards
Stephan

  9 Comments

Show 6 older comments
Curious Mind
Curious Mind on 21 Aug 2018
Oh sorry for the confusion. It's my fault. I'm new to this so i used the terms wrongly
Stephan
Stephan on 21 Aug 2018
So you use:
B = Table_A(:,2:3)
to get what you want.

Sign in to comment.

More Answers (0)

Sign in to answer this question.


Translated by