MATLAB: Accessing data from 1st row to nth row from two columns and plotting them

excelgraphgraph plottingimporting excel data

Best Answer

You can use the indexing to specify the the rows and columns you want to extract.

data = rand(20, 5); % example matrix
x = data(2:end, 1);  % row 2 to 15 from column 1
y = data(2:end, 2);  % row 2 to 15 from column 2
plot(x,y);

The above code will extract row 2 to 15 from column 1 and row 2 to 15 from column 2 and plot them.

Related Solutions

MATLAB: Finding Rest of Row

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

MATLAB: Finding average of every nth row

This is the mean over 6 subsequent rows:

x  = rand(9985, 1);
S  = numel(x);
xx = reshape(x(1:S - mod(S, 6)), 6, []);
y  = sum(xx, 1).' / 6;

The trailing rows are ignored.

[EDITED] General method for matrices:

x  = rand(9985, 14);
p  = 6;
n  = size(x, 1);          % Length of first dimension
nc = n - mod(n, p);       % Multiple of p
np = nc / p;              % Length of result
xx = reshape(x(1:nC, :), p, np, []); % [p x np x size(x,2)]
y  = sum(xx, 1) / p;      % Mean over 1st dim
y  = reshape(y, np, []);  % Remove leading dim of length 1

Best Answer

Related Solutions

MATLAB: Finding Rest of Row

MATLAB: Finding average of every nth row

Related Question