Connected Action
Menu
  • Services
    • Buy a social media network map and report
    • Training
    • Conferences
    • Data Reporting
    • Log in or Join us
    • Customize NodeXL
    • NodeXL
    • Marc Smith
    • About Us
  • Buy maps
    • Twitter Search Network Map and Report
    • Graph Server Twitter Search Network Map and Report
    • Other products and services
  • Sample maps
  • Blog
    • Books
    • NodeXL
    • Events
  • Newsletter
  • Videos
  • Contact
  • Log In

Matrix

How to import matrix data into NodeXL

09JanMay 7, 2015 By Marc Smith

Some network data sets are created or received in the form of a matrix.

A matrix can be directed or undirected.  In this example, we will import a directed network.

First open a blank NodeXL template.

Next open the matrix workbook in the same instance of Excel (just drag it into the title bar of the current NodeXL Excel instance).

Here is a simple asymmetric matrix with weights for tie strengths.
2015-NodeXL-Matrix Data

To import this matrix, switch back to NodeXL and select the Data>Import>From Open Matrix Workbook:
2015-NodeXL-Matrix Import
A matrix may or may not have labels (row and column headers) and the user should define what their data set looks like.
The matrix may represent a directed or undirected network (if it is undirected the matrix must be symmetrical!).
This results in data appearing in the Edges worksheet of NodeXL:
2015-NodeXL-Matrix Edges
This can then be visualized as a network where the edge weights are used to set the thickness of the lines connecting two nodes:
2015-NodeXL-Matrix Data Visualization
Posted in 2015, All posts, NodeXL, SMRF, SNA, Social Media Research Foundation, Social network, Social Network Analysis, Sociology, Visualization Tagged 2015, Edge, How to, HowTo, Import, Matrix, network, NodeXL, SNA, Weight 2 Comments

NodeXL v.79 enters the matrix

24MarMay 7, 2015 By Marc Smith

NodeXL version 79
There is a new version of NodeXL (v.79) available.

Please help build visibility for NodeXL on Digg by digging this link.

Many network analysts store their data in the form of a matrix in which each entity in the network is repeated as row and column headings.  Whenever two entities have a relationship a value is entered in the cell at the intersection of their row and column.  The same data can be represented in the form of an “edge list” in which each pair of entities are represented by the pairs of their names in a single line.  Node lists can be more compact, particularly when netwrks are relatively sparse.  Matrices are a very popular form of data format for network analysts, however, and with the latest release of NodeXL, the add-in now supports the use of this data format.

http://www.codeplex.com/NodeXL/Release/ProjectReleases.aspx

NodeXL Version 1.0.1.79 (2009/3/22)

* You can now import a graph that is stored as an adjacency matrix in another Excel workbook. In the Excel Ribbon, go to NodeXL, Graph, Import, From Open Matrix Workbook.

* You can also export a NodeXL graph to a new Excel workbook as an adjacency matrix. Go to NodeXL, Graph, Export, To New Matrix Workbook.

* The term “Tie Strength” has been replaced with “Edge Weight.”

* Bug fix: Certain sequences could lead to an assertion. The assertion message started with “at ExcelUtil.TryGetSelectedTableRange(…” One such sequence that caused this: Use Excel’s table filtering to filter the Edges table, select the Vertices worksheet, and click Read Worksheet. Another such sequence: Filter the Edges table, select the Vertices worksheet, and click Calculate Graph Metrics.

* Bug fix: Vertex tooltips in the graph pane, which can be added to the graph with the Tooltips column in the Vertices worksheet, were partially obscured by the mouse cursor.

Posted in All posts, Data Mining, NodeXL, Social Media, Social network, Sociology, Visualization Tagged Export, Import, Matrix, network, NodeXL 1 Comment

Connected Action Services

  • Buy a social media network map
  • Log in or Join us
  • My Cart
  • Training
  • Conferences
  • Data Reporting
  • Customize NodeXL
  • Marc Smith
  • About Us

Subscribe to Connected Action

Get updates when there is new content from Connected Action.

Related content:

Twitter Facebookflickrlinkedin
slidesharedeliciousdeliciousVimeo


Social Media Research Foundation

Help support the Social Media Research Foundation

Book: Analyzing Social Media Networks with NodeXL: Insights from a connected world

The book Analyzing Social Media Networks with NodeXL: Insights from a connected world is now available from Morgan-Kaufman and Amazon.

Communities in Cyberspace

Communities in Cyberspace

Recent Posts

  • Buy a map
  • Book: Transparency in Social Media Edited by Sorin Matei, Martha Russell and Elisa Bertino – with a chapter on NodeXL
  • June 5, 2015: Personal Democracy Forum – Talk on taking pictures of virtual crowds
  • Trust issues and Excel: how to open other people’s NodeXL documents
  • May 1st, 2015 at LSU: NodeXL social media networks talk at the “Telling Stories and Using Visuals for Coastal Environmental Communication” workshop

Tags

2009 2010 2011 2013 2014 2015 Analysis Analytics April Chart Conference Data Event Excel graph June Lecture Map March Marc Smith May Media network NodeXL October Paper Presentation Research San Francisco SMRF SMRFoundation SNA social Social Media socialmedia Social Media Research Foundation Social network Sociology Talk Training Twitter University Video Visualization workshop

Categories

Archives

March 2023
M T W T F S S
 12345
6789101112
13141516171819
20212223242526
2728293031  
« Jul    

Transparency in Social Media

2015-07-30-Transparency in Social Media-Structures of Twitter Crowds and COnversations
Transparency in Social Media
Sorin Adam Matei, Martha G. Russell, Elisa Bertino

CÓMO ENCONTRAR LOS HASHTAGS MÁS POTENTES: Para convertir LEADS a VENTAS (SEOHashtag nº 1) (Spanish Edition)

Apply NodeXL in espanol!

CÓMO ENCONTRAR LOS HASHTAGS MÁS POTENTES - Para convertir LEADS a VENTAS (SEOHashtag nº 1) (Spanish Edition)
By: Vivian Francos from #SEOHashtag Comparto algunas de las mejores formas de elegir los hashtags más poderosos y
que puedan generar tráfico a tus redes sociales para aprovechar el poder del
hashtag.
Si quieres aumentar tus interacciones, debes aprender a utilizar los hashtags como herramienta.

https://amzn.to/305Hpsv

Networked


Networked By Lee Rainie and Barry Wellman

Social Media in the Public Sector

2015-07-31Social Media in the Public Sector-Cover
Ines Mergel

Ways of Knowing in HCI

2014-Ways of Knowing in HCI - Olson and Kellogg

The Virtual Community


Virtual Community

The Evolution of Cooperation


The Evolution of Cooperation

Governing the Commons


Governing the Commons

SmartMobs


SmartMobs

Networks, Crowds, and Markets


Networks, Crowds, and Markets

Development of Social Network Analysis


Development of Social Network Analysis: A Study in the Sociology of Science

Search

Services

  • Buy a social media network map
  • Log in or Join us
  • My Cart
  • Training
  • Conferences
  • Data Reporting
  • Customize NodeXL
  • Marc Smith
  • About Us
© 2023 Connected Action
AccessPress Parallax by AccessPress Themes
0

Your Cart