Calculating similarity between users using matlab


by Minaxi
Tags: matlab, similarity, users
Minaxi
Minaxi is offline
#1
Nov19-12, 01:43 PM
P: 1
Hi all,
I am having database of 963 users .
Records of two users are

uid gender occupation age
1 F student 23
2 M teacher 30

Now i need to calculate the similarity of each user with every other as

sim(ui,uj)=0.8*sim(age) + 0.1*sim(gender) + 0.1*sim(occupation)


where sim(age)=1-[(Ai-Aj)/(agemax-agemin)];

agemax is the maximum age and agemin is minimum age of user.

sim(gender)=1 if G1=G2 else 0
sim(occup)=1 if occupation is same .


Kindly tell me the code fir it so that i can get a matrix of similarities.(963*963)
Phys.Org News Partner Science news on Phys.org
Review: With Galaxy S5, Samsung proves less can be more
Making graphene in your kitchen
Study casts doubt on climate benefit of biofuels from corn residue
mikeph
mikeph is online now
#2
Nov22-12, 01:12 PM
P: 1,200
the data import depends on the form of your database, but assuming you can do this and obtain a 4-by-963 cell array, you can do this using a pair of for loops, eg.

sim = zeros(963);
for i = 1:962
    for j = i+1:963
        sim(i,j) = [your specific sim function]
    end
end
this should give you a strictly triangular matrix of the result of every possible pairing.
samh
samh is offline
#3
Dec5-12, 03:47 AM
P: 46
Hi, if I were you I'd encode all attributes as integers, so that all records can be stored as rows in a matrix of type int. I'll assume that you've done this, and your database is a matrix "db" of size [numusers 4]. I'll let you work out the details of that. First, let me give names to the columns:

g = db(:,2); % the genders, assuming male=1 female=2
o = db(:,3); % the occupations, assuming integers
a = db(:,4); % the ages
Now you can compute the pairwise similarity matrix, S, pretty quickly:

G = g*g' ~= 1*2;
O = bsxfun(@minus,o,o') == 0;
A = 1-bsxfun(@minus,a,a')/(agemax-agemin);
S = 0.8*A + 0.1*G + 0.1*O;
This'll give a nice speedup over for-loops when the number of users gets very large.


Register to reply

Related Discussions
Nation of Tool Users? ( ex. Matlab) Career Guidance 2
calculating e, using matlab (how to get answer in double type) Engineering, Comp Sci, & Technology Homework 1
MATLAB code (calculating displacement) Math & Science Software 7
Calculating FT using matlab quad function General Math 1
Calculating variance- matlab discrepancy Math & Science Software 0