# What are the equations/methods to get some weighted score?

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.