Hi ALl, I am trying to create most common cluster from a table containing people technical skills.
For Eg: if I take Java, I want to know what are the most common skill combinations people posses along with Java. If you see the table below:
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Here If I in a graph select Java, I shud get, either in a table or visually in a graph, the below result:
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>How do I go about this?
For Eg: if I take Java, I want to know what are the most common skill combinations people posses along with Java. If you see the table below:
Name | Skill1 | Skill2 | Skill3 | Skill4 | Skill5 |
Person 1 | Java | Oracle | PL/SQL | Angular | Analytics |
Person 2 | Angular | UNIX | Scripting | BigData | Python |
Person 3 | Oracle | PL/SQL | Java | Angular | |
Person 4 | Java | R Programming | |||
Person 5 | Oracle | Machine Learning | UNIX | ||
Person 6 | Python | BigData | Scripting | ||
Person 7 | Java | Angular | Oracle | ||
Person 8 | BigData | NoSQl | Java | Angular |
<colgroup><col width="64" span="6" style="width:48pt"> </colgroup><tbody>
</tbody>
Here If I in a graph select Java, I shud get, either in a table or visually in a graph, the below result:
Expected Outcome | |||
Filter = Java | |||
Cluster | Count | ||
Java,Angular | 4 | ||
Java, Angukar, Oracle | 3 | ||
Java, Angular, Oracle, PL/SQL | 2 | ||
Java, Angular.BigData, NoSQL | 1 | ||
Java, R Programming | 1 | ||
<colgroup><col><col><col span="2"></colgroup><tbody>
</tbody>