extract 1 row data of 1 table
1 次查看(过去 30 天)
显示 更早的评论
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!
3 个评论
回答(1 个)
Jatin
2024-8-23
编辑:Jatin
2024-8-23
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:
Hope this helps!
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!