Communities - Graph Analysis and Visualization - page 392

really set out to visualize is how the fan community is responding to moves
made by the organization. What player moves have been popular? What
buzz has the involvement of Drake generated?
You can use many approaches to identifying topics in social media. Focus on
what you want to know. In this case, you want to identify buzz about players
and about Drake. A simple approach would be to identify when any of the
comments made have included a mention of them.
Export the graph from Gephi in GraphML to preserve its layout and import
it back into NodeXL. Recall that fan rows in the Vertices worksheet
include a concatenation of all comments made by that fan in the Tweet
column.Totherightoftheexistingcolumns,outsideofthedataimportarea,
add new columns for Drake and for each of the five starting players: Demar
Derozan, Jonas Valanciunas, Kyle Lowry, Amir Johnson, and Terrence
Ross. To search for occurrence of either first or last name, populate a row
atop the new columns for each.
Create a formula in the cells of each new mention column that searches for
the names above the column ( Figure 11-12 ) , recording a 0 if neither is found,
and otherwise marking it with a 1 :
=IF(AND(ISERROR(SEARCH(AL$2,Vertices[[#This
Row],[Tweet]],1)),
ISERROR(SEARCH(AL$1,Vertices[[#This
Row],[Tweet]],1))),0,1)