Use logical indexing to create a new structure containing specific data from an excel file
2 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Cam B
el 20 de Feb. de 2022
Comentada: Stephen23
el 20 de Feb. de 2022
The question asks to create a new structure from a data set for dogs. And do the same for cats. An excel file was given which a multitude of data (101 rows and 15 columns). The columns denoted things such as age, size, name, etc., in which one was designated for "species", which listed either dog or cat. The excel file was converted to a structure with the table2struct function.
file1 = readtable('Random.xlsx'); %use readtable function to load caregiver data
table = table2struct(file1)
How would I go about extracing all the data just for the dogs. No looping.
1 comentario
Stephen23
el 20 de Feb. de 2022
Do NOT call any variable TABLE, because this shadows the inbuilt TABLE function.
Respuesta aceptada
Voss
el 20 de Feb. de 2022
file1 = readtable('Random.xlsx') %use readtable function to load caregiver data
table = table2struct(file1)
dog_data = table(strcmp({table.Species},'Dog'))
[dog_data.Age]
{dog_data.Size}
{dog_data.Name}
[dog_data.Is_A_Good_Boy_or_Girl]
2 comentarios
Voss
el 20 de Feb. de 2022
You're welcome!
file1 = readtable('Random.xlsx'); %use readtable function to load caregiver data
table = table2struct(file1);
% using the full struct array:
nnz(strcmp({table.Species},'Dog'))
% or, after creating the dog struct array:
dog_data = table(strcmp({table.Species},'Dog'));
numel(dog_data)
Más respuestas (0)
Ver también
Categorías
Más información sobre Cell Arrays en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!