problem reading table from spreadsheet

1 次查看（过去 30 天）
abdul rehman
abdul rehman 2020-7-16
评论： Walter Roberson 2020-7-16
When I use eg by matlab and load data by following everything works
load patients
whos
e.g this code
T = table(Age,Gender,Height,Weight,Smoker,...
'RowNames',LastName)
-----
But when i use my own excel sheet same data no code works, pleas guide my code is as follows
T=readtable("patients.xls");
T = table(Age,Gender,Height,Weight,Smoker,...
'RowNames',LastName)

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2020-7-16
The result of readtable() is already a table . But you might want to
T = readtable("patients.xls");
T.Properties.RowNames = T.LastName;
  2 个评论
abdul rehman
abdul rehman 2020-7-16
Thanks Its working, can you help me in one more thing please. I want the complete row where Lastname is Williams and age is 38.
Thanks
Walter Roberson
Walter Roberson 2020-7-16
When you set RowNames, the entries must be unique. You are setting LastName as the RowNames, so the last names must be unique. Therefore the combination lastname Williams and age 38 is either just the same as the entry for williams, or else is empty (in the case the age is wrong.)
T('Williams', :)
Using RowNames is what allows you to use a character vector or scalar string object as the first index into a table... but it does require uniqueness.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by