Hi,
I want to use the formula d = sqrt((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2) to calculate two distances. Each distance is between two points in 3D space twice. Once from point A to point B, and one is from point A to point C. I have a data set with cell array where each cell contains tables.
he tables in the cells are built up so that the x, y and z positional coordinates of point A are in column 1, 2 and 3. The x, y, and z positional coordinates of point B are in columns 4, 5, and 6. And the x, y, and z positional coordinates of point C are in columns 7, 8 and 9.
I have the code below:
results_distances = cell(size(results_nooutliers));

% Initialize a cell array to store the distances
results_distances = cell(size(results_nooutliers));

% Loop through each cell in the results_no_outliers array
for i = 1:numel(results_nooutliers)
% Get the current table for the participant
this_cell = results_nooutliers{i};

% Check for empty cells
if isempty(this_cell)
continue; % Skip empty cells
end

% Initialize arrays to store distances for right hand and left hand
distances_A_B = zeros(size(this_cell, 1), 1);
distances_A_C = zeros(size(this_cell, 1), 1);

% Calculate distances for each row in the table
for row = 1:size(this_cell, 1)

% Calculate distance for left hand
distances_A_B(row) = sqrt((this_cell{row, 4} – this_cell{row, 1})^2 + …
(this_cell{row, 5} – this_cell{row, 2})^2 + …
(this_cell{row, 6} – this_cell{row, 3})^2);

% Calculate distance for right hand
distances_A_C(row) = sqrt((this_cell{row, 7} – this_cell{row, 1})^2 + …
(this_cell{row, 8} – this_cell{row, 2})^2 + …
(this_cell{row, 9} – this_cell{row, 3})^2);

end

% Store distances for the current participant in a table
results_distances{i} = table(distances_A_B, distances_A_C, ‘VariableNames’, {‘A_B_Distance’, ‘A_C_Distance’});
end

When running I get the error:
Undefined function ‘minus’ for input arguments of type ‘table’.

Can anybody tell me what I am doing incorrectly?
I have attached a small sample of my data set (it is much longer in actuality).
Thanks for the help!Hi,
I want to use the formula d = sqrt((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2) to calculate two distances. Each distance is between two points in 3D space twice. Once from point A to point B, and one is from point A to point C. I have a data set with cell array where each cell contains tables.
he tables in the cells are built up so that the x, y and z positional coordinates of point A are in column 1, 2 and 3. The x, y, and z positional coordinates of point B are in columns 4, 5, and 6. And the x, y, and z positional coordinates of point C are in columns 7, 8 and 9.
I have the code below:
results_distances = cell(size(results_nooutliers));

% Initialize a cell array to store the distances
results_distances = cell(size(results_nooutliers));

% Loop through each cell in the results_no_outliers array
for i = 1:numel(results_nooutliers)
% Get the current table for the participant
this_cell = results_nooutliers{i};

% Check for empty cells
if isempty(this_cell)
continue; % Skip empty cells
end

% Initialize arrays to store distances for right hand and left hand
distances_A_B = zeros(size(this_cell, 1), 1);
distances_A_C = zeros(size(this_cell, 1), 1);

% Calculate distances for each row in the table
for row = 1:size(this_cell, 1)

% Calculate distance for left hand
distances_A_B(row) = sqrt((this_cell{row, 4} – this_cell{row, 1})^2 + …
(this_cell{row, 5} – this_cell{row, 2})^2 + …
(this_cell{row, 6} – this_cell{row, 3})^2);

% Calculate distance for right hand
distances_A_C(row) = sqrt((this_cell{row, 7} – this_cell{row, 1})^2 + …
(this_cell{row, 8} – this_cell{row, 2})^2 + …
(this_cell{row, 9} – this_cell{row, 3})^2);

end

% Store distances for the current participant in a table
results_distances{i} = table(distances_A_B, distances_A_C, ‘VariableNames’, {‘A_B_Distance’, ‘A_C_Distance’});
end

When running I get the error:
Undefined function ‘minus’ for input arguments of type ‘table’.

Can anybody tell me what I am doing incorrectly?
I have attached a small sample of my data set (it is much longer in actuality).
Thanks for the help! Hi,
I want to use the formula d = sqrt((x2 – x1)^2 + (y2 – y1)^2 + (z2 – z1)^2) to calculate two distances. Each distance is between two points in 3D space twice. Once from point A to point B, and one is from point A to point C. I have a data set with cell array where each cell contains tables.
he tables in the cells are built up so that the x, y and z positional coordinates of point A are in column 1, 2 and 3. The x, y, and z positional coordinates of point B are in columns 4, 5, and 6. And the x, y, and z positional coordinates of point C are in columns 7, 8 and 9.
I have the code below:
results_distances = cell(size(results_nooutliers));

% Initialize a cell array to store the distances
results_distances = cell(size(results_nooutliers));

% Loop through each cell in the results_no_outliers array
for i = 1:numel(results_nooutliers)
% Get the current table for the participant
this_cell = results_nooutliers{i};

% Check for empty cells
if isempty(this_cell)
continue; % Skip empty cells
end

% Initialize arrays to store distances for right hand and left hand
distances_A_B = zeros(size(this_cell, 1), 1);
distances_A_C = zeros(size(this_cell, 1), 1);

% Calculate distances for each row in the table
for row = 1:size(this_cell, 1)

% Calculate distance for left hand
distances_A_B(row) = sqrt((this_cell{row, 4} – this_cell{row, 1})^2 + …
(this_cell{row, 5} – this_cell{row, 2})^2 + …
(this_cell{row, 6} – this_cell{row, 3})^2);

% Calculate distance for right hand
distances_A_C(row) = sqrt((this_cell{row, 7} – this_cell{row, 1})^2 + …
(this_cell{row, 8} – this_cell{row, 2})^2 + …
(this_cell{row, 9} – this_cell{row, 3})^2);

end

% Store distances for the current participant in a table
results_distances{i} = table(distances_A_B, distances_A_C, ‘VariableNames’, {‘A_B_Distance’, ‘A_C_Distance’});
end

When running I get the error:
Undefined function ‘minus’ for input arguments of type ‘table’.

Can anybody tell me what I am doing incorrectly?
I have attached a small sample of my data set (it is much longer in actuality).
Thanks for the help! tables, rows, cell array, error, function, distances MATLAB Answers — New Questions

​