convert excel file into adjacency matrix

2 vues (au cours des 30 derniers jours)
melissa mel
melissa mel le 29 Mar 2017
Commenté : Rik le 29 Mar 2017
I have a file containing data (107k records) and I want to convert it into ascendancy matrix is there a way to convert it ? Example
User_Name M_User Total
user 1 user 2 7
user 1 user 3 19
user 1 user 7 5
user 3 user 2 1
user 2 user 7 1
Result
user 1 user 2 user 3 user 7
user 1 0 7 19 5
user 3 0 1 0 0
user 2 0 0 0 1
user 7 0 0 0 0
  1 commentaire
Rik
Rik le 29 Mar 2017
Have you tried the steps from here? Because I believe starting from 2015a there are loads of function that might help here.

Connectez-vous pour commenter.

Réponses (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by