Question

using MATLAB

Function Name: hahaYes Inputs: 1. 2. (char) The filename of an Excel file containing word counts from various works (cell) A 2xN cell array of words and how many times they occur in the unknown work Outputs: 1. (cell) A 1x3 vector of the closest matches to the unknown work Background You do not understand this reference Function Description: The Excel file that you are given contains data on how many times certain words appear in different works (these might be speeches, episodes of TV shows, books, etc.). Each column of the spreadsheet will represent a different word, which are listed in the first row. Each row will represent a different work, which are listed in the first column. You are also given a cell array containing a few words and how many times they appear in an unknown work. The goal is to find the works in the Excel sheet that most closely match the data you have in the input cell array. To do this, find the absolute error between the number of times the word appeared in the unknown work and the known works in the Excel sheet. The absolute error is then: abs(< unknown> - <known>) Once you have found the absolute error over every word in the second input, find the 3 works with the lowest absolute error, and output the names of those works in a 3x1 cell array, in order of their error rankings (the closest match should be listed first in the output) Example hahaYesExample.xlsx Work Survivor Drag Race World of Dance 0 Redemption Island Slay 18 2 1 23 1 15 out hahayes ('hahaYesExample.xlsx', {'Island', 14; 'Redemption', 5} >> out -('Survivor'; 'World of Dance'; 'Drag Race') Notes: The Excel file will contain at least 3 works, and is guaranteed to have a column for each word in the input cell array .

Answer 1

The output mentioned in the question as an example is not correct according to the question as the absolute error is found the minimum for work 'Survivor' (1 for Redemption and 4 for Island) twice and then 'Drag Race' (5 for Redemption). Also, there is a clash between how the input is expected in the question(example: input is said to be a 2XN cell in written but in the example code it is given as an NX2 cell). There are a lot of such ambiguities in the question. The required code is given below:

function out = hahaYes(File_name,Cell)

% reads the values in matrix A and the heading in text
[A text] = xlsread(File_name);

% to calculate size of the Cell that is given as input
[r_cell c_cell] = size(Cell);

% to calculate size of the matrix A
[r_excel c_excel] = size(A);

l = 1;

% logic to calculate the absolute error
for i = 1:r_cell
for j = 2:c_excel+1
if strcmp(Cell{i,1},text{1,j}) == 1
pos_excel(l) = j;
l = l+1;
for k = 1:r_excel
data(k,i) = abs(Cell{i,2} - A(k,j-1));
end
end
end
end

min1 = Inf;
min2 = Inf;
min3 = Inf;
pos = zeros(3,2);

% To find the position of first minimum
for i = 1:r_cell
for j = 1:c_cell
if data(i,j) < min1
min1 = data(i,j);
pos(1,1) = i;
pos(1,2) = j;
end
end
end

% To find the position of second minimum
for i = 1:r_cell
for j = 1:c_cell
if data(i,j) < min2 && data(i,j) > min1
min2 = data(i,j);
pos(2,1) = i;
pos(2,2) = j;
end
end
end

% To find the position of third minimum
for i = 1:r_cell
for j = 1:c_cell
if data(i,j) > min2 && data(i,j) < min3
min3 = data(i,j);
pos(3,1) = i;
pos(3,2) = j;
end
end
end

% returning the output
for i = 1:3
out{i,1} = text{pos(i,1)+1,1};
end

end