MATLAB Answers

Getting data from specific columns in a table

329 views (last 30 days)
Curious Mind
Curious Mind on 21 Aug 2018
Commented: Curious Mind on 21 Aug 2018
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.


Sign in to comment.

Accepted Answer

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:
you get an array containing all values of the column named 'y'.
Best regards


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 on 21 Aug 2018
So you use:
B = Table_A(:,2:3)
to get what you want.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!