extract 1 row data of 1 table

I want to extract the data of a row in a table, how to do it

exam: Name address age

hang VN 18

nam vn 40

lan vn 23

I want to retrieve the information of a man named Nam

help me!

[Shubham Gupta]

if above mentioned table is a cell array then you can simply use :

output_cell = {exam{3,:}};

I hope this helps !

[Ramesh Bala]

exam1(1,1:length(exam))=exam; -for 1st row and do the same for rest

[hang dong]

I want to find an element in the table

exam: from pos = 11 i can find iwant = 542013

Answer 1

[Jatin]

Hi hang dong,

There are few ways how this can be achieved.

1. If you don’t have fixed value to search on every time, you can use logical vectors to extract the row with value equal to the key and you can get the required output using the syntax given below for your example table:

% Extract the age of the person named 'nam' 
% Use the equality operator to compare strings directly
Age = dataTable.Age(strcmp(dataTable.Name, 'nam')); 

2. If the “Name” column is used every time for accessing table values, you can set the “RowNames” property of the table to the “Name” column and then you can access the table values using a syntax as below:

% Set the 'Names' as row names using the object property 
dataTable.Properties.RowNames = Names; 
% Extract the age of the person named 'nam'
Age = dataTable{'nam', 'Age'}; 

Kindly go through this documentation for more on accessing values from table:

https://www.mathworks.com/help/matlab/matlab_prog/access-data-in-a-table.html

Hope this helps!