Excel file with three columns and compare the data
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
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 Kommentare
Adam Danz
am 9 Apr. 2019
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.
Antworten (1)
Adam Danz
am 9 Apr. 2019
Bearbeitet: Adam Danz
am 11 Apr. 2019
"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 Kommentare
Siehe auch
Kategorien
Mehr zu Spreadsheets finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!