Use logical indexing to create a new structure containing specific data from an excel file

2 次查看（过去 30 天）
Cam B
Cam B 2022-2-20
评论： Stephen23 2022-2-20
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.

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

采纳的回答

Voss
Voss 2022-2-20
Ran in:
file1 = readtable('Random.xlsx') %use readtable function to load caregiver data
file1 = 3×5 table
Age Size Name Species Is_A_Good_Boy_or_Girl ___ __________ ______________ _______ _____________________ 2 {'small' } {'Fido' } {'Dog'} true 4 {'large' } {'Mr Pickles'} {'Cat'} true 9 {'medium'} {'Rex' } {'Dog'} true
table = table2struct(file1)
table = 3×1 struct array with fields:
Age Size Name Species Is_A_Good_Boy_or_Girl
dog_data = table(strcmp({table.Species},'Dog'))
dog_data = 2×1 struct array with fields:
Age Size Name Species Is_A_Good_Boy_or_Girl
[dog_data.Age]
ans = 1×2
2 9
{dog_data.Size}
ans = 1×2 cell array
{'small'} {'medium'}
{dog_data.Name}
ans = 1×2 cell array
{'Fido'} {'Rex'}
[dog_data.Is_A_Good_Boy_or_Girl]
ans = 1×2 logical array
1 1
  2 个评论
Voss
Voss 2022-2-20
Ran in:
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'))
ans = 2
% or, after creating the dog struct array:
dog_data = table(strcmp({table.Species},'Dog'));
numel(dog_data)
ans = 2

请先登录，再进行评论。

更多回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by