Source
r/visualization•
ArcadeMan

How to make a node and link of the % overlaps between categories? Trying to show the data in a better way than a table of 600 numbers

Is there a way to build a node and link visualization automatically with a table of data with about 20 different segments and their overlap percentages of when they are purchased together?

I was wanting it to look like this image, but with the thickness of the lines representing the percentages, thicker line=higher percentage of being bought together.

Social Graph

Is there an easy way to do this automatically? Are there programs or websites I could upload the data to that would build this type of visualization?

Or is the only way to do this type of thing to build it manually? Or is there a better visualization that I could use for this type of data?

Thanks for any help as I am trying to get this built by Monday and want to do something other than a table of data. If someone has a way to build this type of visualization I can share the data as well and would be very grateful, which usually means free chocolate for you :)

Thanks!

Posted Apr 2, 2016, 10:34 PM UTC

55
captjons•

You can do something similar in Gephi - you just specific the weight of the edges and they show thicker.

2
ArcadeManOP•

Is there a specific graph within Gephi or a sample of something similar that I could open and modify to see how it's built in Gephi?

I downloaded Gephi and am playing around with it but i don't know it at all and not sure where to get started.

1
Boulavogue•

Op, if you find a decent tutorial would you mind sharing? I recently did some similar analysis (I used apriori algorithm to get associations) and it'd be nice to build a visual on the insight

1
captjons•

It would probably be easier if you post or link to some of your data. I should have time tomorrow to put it into a guff friendly format for you.

1
ArcadeManOP•

Thank you for the help, here is the data.

The bottom left and top right sections split by the blank cells are mirrors of each other as this shows the interactions between the 2 groups. Not sure if it matters when visualizing the data but thought I would call out just in case.

Thank you again for all the help!

Weighted Average InteractionsSegment 1Segment 2Segment 3Segment 4Segment 5Segment 6Segment 7Segment 8Segment 9Segment 10Segment 11Segment 12Segment 13Segment 14Segment 15Segment 16Segment 17Segment 18Segment 19Segment 20Segment 21Segment 22Segment 23Segment 24Segment 25
Segment 14.8%4.8%4.7%4.5%6.3%3.7%3.5%4.4%3.3%4.7%1.9%2.1%1.7%1.7%1.8%1.7%1.7%1.2%0.9%0.8%1.1%0.3%0.4%0.1%
Segment 24.8%4.6%8.3%3.2%3.7%2.9%6.8%3.1%10.7%3.8%4.7%3.0%4.0%3.3%4.7%4.3%2.8%2.4%2.1%2.4%0.7%0.6%0.9%0.1%
Segment 34.8%4.6%3.5%3.1%3.5%2.6%4.6%2.1%3.4%9.9%2.3%1.9%2.4%1.6%2.3%1.9%5.4%1.1%1.0%1.1%0.7%0.6%0.4%0.1%
Segment 44.7%8.3%3.5%2.9%3.6%2.8%6.2%3.1%8.4%2.8%2.3%2.7%2.2%4.1%2.4%2.9%1.8%1.8%1.3%1.3%0.6%0.4%0.6%0.1%
Segment 54.5%3.2%3.1%2.9%7.1%4.7%2.4%4.6%2.5%3.9%1.6%2.1%1.6%1.4%1.2%1.2%1.2%0.9%0.8%0.8%0.7%0.3%0.4%0.1%
Segment 66.3%3.7%3.5%3.6%7.1%5.0%2.6%4.1%2.9%5.3%1.7%2.3%1.6%1.4%1.4%1.2%1.2%1.0%0.8%0.8%0.7%0.3%0.3%0.1%
Segment 73.7%2.9%2.6%2.8%4.7%5.0%2.1%4.3%2.5%3.0%1.9%2.8%1.8%1.6%1.0%1.0%1.0%1.0%0.7%0.6%0.5%0.3%0.4%0.1%
Segment 83.5%6.8%4.6%6.2%2.4%2.6%2.1%2.0%5.2%3.2%3.9%2.0%2.8%2.7%3.3%3.3%2.4%1.8%1.7%1.8%0.6%0.7%0.7%0.1%
Segment 94.4%3.1%2.1%3.1%4.6%4.1%4.3%2.0%2.7%2.2%1.4%1.9%1.3%1.4%1.1%1.0%0.8%0.9%0.7%0.6%1.1%0.2%0.3%0.1%
Segment 103.3%10.7%3.4%8.4%2.5%2.9%2.5%5.2%2.7%3.0%3.7%2.6%3.5%3.7%3.4%2.9%2.4%2.2%1.7%2.1%0.6%0.6%0.8%0.2%
Segment 114.7%3.8%9.9%2.8%3.9%5.3%3.0%3.2%2.2%3.0%2.1%1.9%2.1%1.5%2.0%1.6%4.2%1.1%1.1%1.0%0.6%0.5%0.4%0.1%
Segment 121.9%4.7%2.3%2.3%1.6%1.7%1.9%3.9%1.4%3.7%2.1%2.1%5.9%2.0%2.7%2.3%1.7%2.0%1.7%1.8%0.4%1.1%0.8%0.1%
Segment 132.1%3.0%1.9%2.7%2.1%2.3%2.8%2.0%1.9%2.6%1.9%2.1%2.9%2.0%1.4%1.3%1.2%1.4%1.0%0.8%0.4%0.4%0.5%0.1%
Segment 141.7%4.0%2.4%2.2%1.6%1.6%1.8%2.8%1.3%3.5%2.1%5.9%2.9%2.2%2.7%2.0%2.0%2.4%2.0%1.7%0.4%1.1%0.9%0.1%
Segment 151.7%3.3%1.6%4.1%1.4%1.4%1.6%2.7%1.4%3.7%1.5%2.0%2.0%2.2%1.6%2.4%1.4%2.9%1.1%1.3%0.4%0.8%1.4%0.2%
Segment 161.8%4.7%2.3%2.4%1.2%1.4%1.0%3.3%1.1%3.4%2.0%2.7%1.4%2.7%1.6%3.3%2.6%2.6%4.8%2.4%0.6%1.1%1.0%0.3%
Segment 171.7%4.3%1.9%2.9%1.2%1.2%1.0%3.3%1.0%2.9%1.6%2.3%1.3%2.0%2.4%3.3%2.5%2.8%1.7%2.8%0.6%1.1%1.3%0.4%
Segment 181.7%2.8%5.4%1.8%1.2%1.2%1.0%2.4%0.8%2.4%4.2%1.7%1.2%2.0%1.4%2.6%2.5%2.1%1.8%1.8%0.7%1.1%0.9%0.3%
Segment 191.2%2.4%1.1%1.8%0.9%1.0%1.0%1.8%0.9%2.2%1.1%2.0%1.4%2.4%2.9%2.6%2.8%2.1%2.3%1.8%0.5%1.4%2.8%0.5%
Segment 200.9%2.1%1.0%1.3%0.8%0.8%0.7%1.7%0.7%1.7%1.1%1.7%1.0%2.0%1.1%4.8%1.7%1.8%2.3%1.6%0.5%0.9%0.8%0.3%
Segment 210.8%2.4%1.1%1.3%0.8%0.8%0.6%1.8%0.6%2.1%1.0%1.8%0.8%1.7%1.3%2.4%2.8%1.8%1.8%1.6%0.3%1.2%0.9%0.3%
Segment 221.1%0.7%0.7%0.6%0.7%0.7%0.5%0.6%1.1%0.6%0.6%0.4%0.4%0.4%0.4%0.6%0.6%0.7%0.5%0.5%0.3%0.3%0.2%0.2%
Segment 230.3%0.6%0.6%0.4%0.3%0.3%0.3%0.7%0.2%0.6%0.5%1.1%0.4%1.1%0.8%1.1%1.1%1.1%1.4%0.9%1.2%0.3%1.2%0.5%
Segment 240.4%0.9%0.4%0.6%0.4%0.3%0.4%0.7%0.3%0.8%0.4%0.8%0.5%0.9%1.4%1.0%1.3%0.9%2.8%0.8%0.9%0.2%1.2%0.3%
Segment 250.1%0.1%0.1%0.1%0.1%0.1%0.1%0.1%0.1%0.2%0.1%0.1%0.1%0.1%0.2%0.3%0.4%0.3%0.5%0.3%0.3%0.2%0.5%0.3%
1