MATLAB: Retrieve data from column plus x

matrix arraymatrix manipulation

I have a large set of data that contains information about numerous different core samples. Each core sample has a different amount of sections, the amount of sections for each specific core is stipulated in column 13. I need to find out the length of each core sample, this information is provided in the final section length. So if the value in column 13 was 6, the length of the core would be found in column 19. As each core has different amount of sections how would I extract information regarding the length of each individual core?

Best Answer

final_len_col = 13 + coredata(:,13);
final_len_idx = sub2idx(size(coredata), 1:size(coredata,1), final_len_col);
final_lengths = coredata(final_len_idx);

This can be abbreviated

final_lengths = coredata((1:size(coredata,1)).' + size(coredata,1) * ((13-1) + coredata(:,13)));

Related Solutions

MATLAB: Handling audio files

Check this out:

% v1, v2 - two vectors are given
len1=length(v1);
len2=length(v2);
%
LEN=min(len1, len2);
V1=v1(1:LEN);
V2=v2(1:LEN);
% V1, V2 are vectors with same length

MATLAB: Number of elements of clusters from dbscan

This example code read data from the excel file. Change column two from text to numeric and then apply dbscan clustering.

data=readtable('Liverxl.xlsx', 'ReadVariableNames', false);
data.Var2 = findgroups(data.Var2); % convert column 
data.Var10(isnan(data.Var10)) = 0; % place 0 in empty cells
minpts=3;
epsilon=30;
data = table2array(data);
[idx, corepts] = dbscan(data,epsilon,minpts);
number_of_clusters = sum(unique(idx)>0);
% remove ouliers
core_data = data(corepts, :);
core_idx = idx(corepts);
% Clusters are saved in a cell array
clusters = splitapply(@(x) {x}, core_data, core_idx);

Tune the value of parameters, minpts and epsilon to change the size and number of elements in clusters.

Best Answer

Related Solutions

MATLAB: Handling audio files

MATLAB: Number of elements of clusters from dbscan

Related Question