How to make for loop to count items in excel sheet?!
3 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Mariam Sheha
am 25 Mai 2016
Kommentiert: Mariam Sheha
am 28 Mai 2016
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 Kommentare
dpb
am 26 Mai 2016
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.
Akzeptierte Antwort
Walter Roberson
am 26 Mai 2016
num = xlsread('Data1.xlsx');
result = arrayfun(@(ROW) find(num(ROW,:)), (1:size(num,1)).', 'Uniform', 0);
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Logical finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!