problem reading table from spreadsheet

Question

abdul rehman 2020-7-16

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565847-problem-reading-table-from-spreadsheet

评论： Walter Roberson 2020-7-16

采纳的回答： Walter Roberson

在 MATLAB Online 中打开

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)

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

Answer 1

Walter Roberson 2020-7-16

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565847-problem-reading-table-from-spreadsheet#answer_466430

在 MATLAB Online 中打开

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 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 2020-7-16

在 MATLAB Online 中打开

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.

请先登录，再进行评论。