How to make for loop to count items in excel sheet?!

4 次查看（过去 30 天）
Mariam Sheha
Mariam Sheha 2016-5-25
评论： Mariam Sheha 2016-5-28
Hello every body;
i am having data listed in excel sheet contains 980 row and 30 column
Each row consists of zeroes and ones, I want to make a for loop to consider all ones adjacent to each row and name it by the number of each column. so finally i will have only one column that contains the different items correspond to 1 i.e --> Row1: [4,12,13,15,16,18,19,20,22,24,27]
can anyone help me to do such operation please??! Thanks A lot
  2 个评论
dpb
dpb 2016-5-26
Not until we can understand what it is you're asking for, no...
Give a small sample, 2 or 3 rows with a half-dozen columns should be more than enough to illustrate. Paste the data and the desired results as code and how you get the latter from the former.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2016-5-26
num = xlsread('Data1.xlsx');
result = arrayfun(@(ROW) find(num(ROW,:)), (1:size(num,1)).', 'Uniform', 0);

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Loops and Conditional Statements 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by