How to convert similarity ratings data into matrix?

2 次查看（过去 30 天）
Magdalena Kachlicka
编辑： 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更早的评论
Dinesh Yadav
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
Magdalena Kachlicka 2021-4-21
编辑：Magdalena Kachlicka 2021-4-21
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?

请先登录，再进行评论。

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

回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Logical 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by