Excel file with three columns and compare the data
1 回表示 (過去 30 日間)
古いコメントを表示
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 件のコメント
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 日
編集済み: Adam Danz
2019 年 4 月 11 日
"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)
4 件のコメント
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!