Finding Rest of Row

10 views (last 30 days)
Anjali Parmar
Anjali Parmar on 19 Feb 2020
Commented: Anjali Parmar on 19 Feb 2020
Hello! Matlab newbie here. So I have a bunch of data in rows/columns. If I have a variable assigned to something in a specific row in column 1, how do I find the values in the rest of the row in the rest of the columns (there's like five total)? I appreciate any help!

Accepted Answer

Gifari Zulkarnaen
Gifari Zulkarnaen on 19 Feb 2020
Do you mean like vlookup in excel? Try this:
data = randi(1,4,5); % Just an example matrix
first = data(randi(4),1); % Example of desired number in first column
index = data(:,1) == first; % Find in which row is your desired number located
rest = data(index,2:end); % Get the rest of columns of that row

More Answers (0)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!