Modularity Example 2 Community Vertex Table
| friends_name |
location |
resolution |
community_id |
num_communities |
modularity_score |
| Alex |
SanFrancisco |
1 |
LosAngeles |
2 |
0.442684 |
| Bob |
LosAngeles |
1 |
LosAngeles |
2 |
0.442684 |
| Casey |
LosAngeles |
1 |
LosAngeles |
2 |
0.442684 |
| Danny |
NewYorkCity |
1 |
Birmingham |
2 |
0.442684 |
| Eve |
Birmingham |
1 |
Birmingham |
2 |
0.442684 |
| Fox |
Austin |
1 |
Birmingham |
2 |
0.442684 |
| Gohar |
Miami |
1 |
LosAngeles |
2 |
0.442684 |
| Harry |
Chicago |
1 |
LosAngeles |
2 |
0.442684 |
This query returns the following table:
SELECT * FROM community_edges;
Modularity Example 2 Community Edge Table community_edges
| src_community_id |
target_community_id |
resolution |
weight |
| LosAngeles |
LosAngeles |
1 |
52 |
| LosAngeles |
Birmingham |
1 |
3 |
| Birmingham |
LosAngeles |
1 |
3 |
| Birmingham |
Birmingham |
1 |
48 |