NaN matrix and selection rows with 1

1 次查看（过去 30 天）
Alessandro Camillo
Alessandro Camillo 2023-1-10
回答： Walter Roberson 2023-1-12
use an excel table. some lines belong to two categories (example 1,2) but on matlab I have the symbol NaN. Help. Then in the matrix how can I select together the rows that contain the value 1 with those that have the value 1,2 and 1,3?
<<
>>
  5 个评论
显示 3更早的评论
Walter Roberson
Walter Roberson 2023-1-10
What command did you use to read the file?
Image Analyst
Image Analyst 2023-1-10
If you have any more questions, then attach your .xlsx workbook and code to read it in with the paperclip icon after you read this:
TUTORIAL: How to ask a question (on Answers) and get a fast answer

请先登录，再进行评论。

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

回答（2 个）

Dongyue
Dongyue 2023-1-12
You can use readcell() function:
data = readcell('your_file_name')
After that, you need to do some data preprocessing, such as change all the values in that column to string. Then find out whether '1' is in that string, and use this condition to index the row.
However, the best way I can come up with is that, change the datatype for that column into text in you Excel file, and then use readtable() function to import the data.
Walter Roberson
Walter Roberson 2023-1-12
Ran in:
filename = 'sample_mult.csv';
type(filename)
b; n; CAT. TIP. VEG. 2.17E-05; 3.3722; 1 4.33E-05; 6.7443; 1 7.58E-05; 11.803; 2 0.000119; 18.547; 3 0.000163; 25.291; 1, 2 0.000206; 32.035; 1 0.000249; 38.78; 1, 2, 3 0.000293; 45.524; 3, 2
CATvarname = 'CAT. TIP. VEG.';
opt = detectImportOptions(filename, 'VariableNamingRule', 'Preserve');
opt = setvartype(opt, CATvarname, 'char');
data = readtable(filename, opt);
data.(CATvarname) = cellfun(@str2num, data.(CATvarname), 'uniform', 0);
Now you can
has_class = @(CLASS) cellfun(@(Row) ismember(CLASS, Row), data.(CATvarname));
matches1 = has_class(1)
matches1 = 8×1 logical array
1 1 0 0 1 1 1 0

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by