How to convert similarity ratings data into matrix?

3 次查看（过去 30 天）

Magdalena Kachlicka 2020-7-15

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/565352-how-to-convert-similarity-ratings-data-into-matrix

编辑： Magdalena Kachlicka 2021-4-21

Dear all,

I've collected similarity data on the 7-point Likert scale for a range of items (e.g., A, B, C), where participants were rating all possible combinations of these items. The results have the following format:

A, A, 7

A, B, 4

A, C, 2

B, A, 3

B, B, 7

B, C, 5

C, A, 2

C, B, 6

C, C, 7

As you can see, rating of items in reverse order (e.g., AB and BA) is not always the same.

Is there a way I can transform the data table (item1, item2, rating) into similarity matrix (like the one below)?

A, B, C

A, 7, 4, 2

B, 3, 7, 5

C, 2, 6, 7

3 个评论
显示 1更早的评论隐藏 1更早的评论

Dinesh Yadav 2020-7-21

As parth mentioned can you tell how you have stored data and in which format? It would be easier to answer you question that way.

Magdalena Kachlicka 2021-4-21

编辑：Magdalena Kachlicka 2021-4-21

1001.csv

Somehow I completely missed these responses, sorry! I'm not quite sure what you mean by the data format? The data is a simple table of values from 1-8, as indicated above (also see the attached file for example). In the end, I've used the R function called cast() to do this, but I wonder if there is anything working in a similar way for Matlab too?

请先登录，再进行评论。

请先登录，再回答此问题。