problem reading table from spreadsheet
显示 更早的评论
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
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
2020-7-16
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 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
