problem reading table from spreadsheet
3 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
abdul rehman
le 16 Juil 2020
Commenté : Walter Roberson
le 16 Juil 2020
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 commentaires
Réponse acceptée
Walter Roberson
le 16 Juil 2020
The result of readtable() is already a table . But you might want to
T = readtable("patients.xls");
T.Properties.RowNames = T.LastName;
2 commentaires
Walter Roberson
le 16 Juil 2020
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.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!