Excel file with three columns and compare the data

2 次查看（过去 30 天）

stelios loizidis 2019-4-9

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/455289-excel-file-with-three-columns-and-compare-the-data

编辑： Adam Danz 2019-4-15

Hellow,

I have an excel file with three columns (visitors,lacation,score). I want to find out which visitors went to the same location and what score they made.

Code I wrote:

for j=1:locations
    if (visitors(j)~=0 & locations(j)~=0)
        flag=1;
        score= score + abs(visitors9j0-locations(j))
    end
    if flag==1
        score
    else 
        string("no similarity")
    end
end

5 个评论
显示 3更早的评论隐藏 3更早的评论

stelios loizidis 2019-4-9

在 MATLAB Online 中打开

I entered the data as follows:

visitors=xlsread("data.xlsx","A1:A100")
locations=xlsread("data.xlsx","B1:B100")
scores=xlsread("data.xlsx","C1:C100")
e.g: locations(100X1):

Adam Danz 2019-4-9

Ok, that's clear. I still have 1 more quesiton.

"I want to find out which visitors went to the same location and what score they made."

Does that mean that 1) you want to choose a location (eg: # 70) and then list all visitors who went to that location and their scores or 2) for all locations, you want a list of visitors who have been there?

Also, how do you want this formatted? In a table? a cell array? It would be helpful for you to share an example of your desired output.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

Adam Danz 2019-4-9

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/455289-excel-file-with-three-columns-and-compare-the-data#answer_369814

编辑：Adam Danz 2019-4-11

在 MATLAB Online 中打开

"I want to find out which visitors went to the same location and what score they made."

There are several ways to interpret this and several ways how to organize the data. Here are two interpretations.

% visitorNum: [n x 1] vector; numeric
% location: [n x 1] vector; numeric
% score: [n x 1] vector; numeric
% If you want to list all users who have been to location 3, and their scores (in a table)
targetLocation = 3; 
locIdx = location == targetLocation; 
table(visitorNum(locIdx), score(locIdx), 'VariableNames', {'Visitor', 'Score'})
% If you want to apply this to all locations, loop through each location and store each table 
% in a cell array. 
unqLocations = unique(location); 
tbls = cell(size(unqLocations)); 
for i = 1:length(unqLocations)
    locIdx = location == unqLocations(i); 
    tbls{i} = table(visitorNum(locIdx), score(locIdx), 'VariableNames', {'Visitor', 'Score'}); 
end
% tbls{x} is a table associated with location unqLocations(x)