I have set of users and the topics they discuss as follows.

User, Topic, Number_of_times_discussed
Jone, movies, 3
Emi, food, 6
Jenne, movies, 1
Ej, tv series, 2
Micheal, tech, 8
Jone, comedy, 1

I also got another list that describes how interesting the topic was to the listeners. This interestingness score is in the range of 0-1. Note that some topics do not have interestingness score provided in the dataset (e.g., comedy).

Topic, Interestingness_score
movies, 0.9
food, 0.1
tvseries, 0.6
tech, 0.8

Now, I want to have a weighted score for each connection that the users have with topics based on the two values I have. The first method I tried was as follows (see weighted_score column).

User, Topic, Number_of_times_discussed, weighted_score
Jone, movies, 3,                           3+(3*0.9)
Emi, food, 6,                              6+(6*0.1)
Jenne, movies, 1,                          1+(1*0.9)
Ej, tv series, 2                           2+(2*0.6)
Micheal, tech, 8                           8+(8*0.8)
Jone, comedy, 1                            1+(1*0) <- since I do not have a interestingness_score for comedy

However, I would like to know if there are more statistical ways to induce the intrestingness_score for each connection to weight them. I am happy to provide more details if needed.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.