From Edge List to Adjacency Matrix with COUNTIFS
This lesson is part of the course
In this lesson
You turn a chat export into an adjacency matrix with COUNTIFS, count the ties and measure how many of them are mutual.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- From Edge List to Adjacency Matrix with COUNTIFS Locked
- Degree, In-Degree & Out-Degree: Who Is the Hub? Locked
- Weighted Degree (Strength) & Network Density Locked
- Shortest Paths by Hand: a Dijkstra Step Table Locked
- Two-Step Reach & Common Neighbours with Matrix Multiplication Locked
- Closeness Centrality from a Distance Matrix Locked
- PageRank by Iteration: Damping 0.85 in a Step Table Locked
- Bridges, Communities & the Degree Distribution Locked