清空筛选条件
清空筛选条件

Extracting data from a cell array problem

3 次查看（过去 30 天）
Amy Hassett
Amy Hassett 2020-4-14
评论： Stephen23 2020-4-14
Hi folks,
I have extracted data from an SQLite file into MATLAB, and have it saved as a (1000,4) cell array, wherein the contents of the 4th column are numbers (1, 2 or 3). I am trying to extract rows of data from this cell array on the basis of the contents of the 4th column (see code below), but MATLAB tells me that I cannot perform this particular operation on the contents of a cell.
results_solo = fetch(conn, sqlquery_soloEvents);
AnimalData = 'SELECT ID, RFID, GENOTYPE, NAME FROM ANIMAL';
results_animalData = fetch(conn , AnimalData);
% Create a structure containing our data
for k = 1:size(results_animalData)
data(k).Mice = results_animalData(k,4);
data(k).Genotype = results_animalData(k, 3);
data(k).RFID = results_animalData(k,2);
data(k).ID = cell2mat(results_animalData(k,1));
data(k).Behaviours = results_solo(results_solo(:,4) == k, :);
end
Therefore, I rewrote the code using strcmpi to the following:
for k = 1:size(results_animalData)
data(k).Mice = results_animalData(k,4);
data(k).Genotype = results_animalData(k, 3);
data(k).RFID = results_animalData(k,2);
data(k).ID = cell2mat(results_animalData(k,1));
data(k).Behaviours = results_solo(strcmpi(results_solo(:,4), k), :);
end
But this is not working either. So then I tried to directly access the contents of my cell as follows:
for k = 1:size(results_animalData)
data(k).Mice = results_animalData(k,4);
data(k).Genotype = results_animalData(k, 3);
data(k).RFID = results_animalData(k,2);
data(k).ID = cell2mat(results_animalData(k,1));
data(k).Behaviours = results_solo(results_solo{:,4} == k, :);
end
But that is not working. (it gives an error saying that in the final line I have too many input arguments).
Can someone point me towards what I should do next?

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

采纳的回答

Ameer Hamza
Ameer Hamza 2020-4-14
编辑：Ameer Hamza 2020-4-14
Try this
data(k).Behaviours = results_solo([results_solo{:,4}] == k, :);
%^ add square brackets

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Marine and Underwater Vehicles 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by