Problem with indexing in structures

2 次查看（过去 30 天）
Dionisio Mendoza
Dionisio Mendoza 2021-9-6
评论： Dionisio Mendoza 2021-9-8
Ran in:
Hi there!
I am practicing the index on structures. I am trying to find a specific column of a structure using "strcmp".
In the following lines of code I load the file, I make a variable of the headers and in the Genesnumber variable I save the data of the Gene Symbol column belonging to myData
myData=importdata('xd.xlsx','\t')
Error using importdata (line 139)
Unable to open file.
headers=myData.textdata(1,:);
Genesnumber=myData.textdata(:,strcmp('Gene Symbol',headers));
Now I am trying to do the same (extract the data from a specific column) but with the HAGRID header. This HAGRID column in the original file is in column number 2 exactly like the header variable.
So when I test this code the new variable is either empty or with NaN values. That means the column is moving, but I don't know how to fix that little problem.
a=myData.textdata(:,strcmp('HAGRID',headers));
a=myData.data(:,strcmp('HAGRID',headers)); %here change textdata for data

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

采纳的回答

Matt J
Matt J 2021-9-6
编辑：Matt J 2021-9-6
Ran in:
A table would be handier here than a struct:
myData=readtable('https://www.mathworks.com/matlabcentral/answers/uploaded_files/730869/xd.XLSX');
Warning: Column headers from the file were modified to make them valid MATLAB identifiers before creating variable names for the table. The original column headers are saved in the VariableDescriptions property.
Set 'VariableNamingRule' to 'preserve' to use the original column headers as table variable names.
myData.HAGRID
ans = 21×1
139 78 255 187 264 135 35 195 102 138

更多回答（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