Mapping relationships between a list of twitter accounts?

Dec 17, 2010 at 3:09 AM

Is it posible to input not just a single twitter user, but provide multiple usernames to NodeXL and seek out if there are relationships between a given set of twitter users?

For e.g. suppose we have the following list of twitter users e.g. sanjayshetty, rajch, sanjayvyas considering that these are all valid twitter users. Can one provide this as a list to NodeXL to map out relationships between them?

Thanks in advance for the reply, this is a wonderful tool.

Regards,

Sanjay Shetty

Dec 17, 2010 at 3:19 PM
Edited Dec 17, 2010 at 3:21 PM

Sanjay:

I'm pleased to hear that you've found NodeXL useful.

Our current version doesn't do what you're talking about -- instead, Import from Twitter User Network shows the relationships between one specified Twitter user and his followed/following relationships -- but it sounds like a useful idea.  I've added it to our list of requested features.

Thanks,
    Tony

Coordinator
Dec 17, 2010 at 3:23 PM

Thank you for the useful suggestion.

A manual approach could be to repeat the Twitter User network query for each person in your (short) list and then merge the resulting networks.  This approach could be practical for a small set of user accounts.

-

Marc

Dec 18, 2010 at 4:51 AM

Hi Tony, Marc,

Thanks for the quick response. Marc -> I've already started doing what you've suggested though it's kind of painful to do, as you've mentioned, with a long list. Wondering if there is any way to automate.

Ideal solution would be to enable people to enter a list of twitter usernames in the excel sheet itself and then have NodeXL parse the list.

Thanks.

Regards,

Sanjay Shetty

Jan 16, 2011 at 12:15 PM

Would be an excellent addition - my similar but different problem is that I am trying to work out is the easiest way to use NodeXL's (excellent) capability for downloading user Statistics (# followers, followed etc) for a list of Twitter IDs I have (e.g. spreadsheet of 100+ IDs). Do you know if any way to extend / hack NodeXL's api calling method do that? Closest (manual) approach is to follow all the IDs I am interested in then do an import User network for my ID - not very elegant solution though. Any ideas?

Many thanks in advance (and major kudos to the book),

Daniel 

Jan 17, 2011 at 4:35 PM
Edited Jan 17, 2011 at 4:35 PM

Daniel:

If you're a .NET programmer (or if you know a .NET programmer), you could certainly hack NodeXL to do what you need to do, because the source code is posted on our CodePlex site.  The latest version as of today is at http://nodexl.codeplex.com/releases/view/57817.

However, given that all you need to do is get the statistics for a set of users, that might be gross overkill.  Twitter provides an API called "users/show" that provides statistics for one user.  (It should be called "user/show"; I'm not sure why they used the plural.)  It can be accessed from any programming language that can fetch an HTTP resource and parse the results, whether it's C#, Java, Python, or whatever.  Your simple program would just call users/show once for each user in the list, parse the results, and output them as a delimited file, which could then be opened in Excel.

If you're interested, the Twitter API is documented at http://apiwiki.twitter.com/w/page/22554755/Twitter-REST-API-Method:-users%20show.  You can see what the results look like for one user by opening http://api.twitter.com/1/users/show.xml?screen_name=dougw in a browser.

-- Tony

Jan 18, 2011 at 3:11 PM
Hi Tony - many thanks as always! The links are a great start - you've tipped me to learning Python that's been on my to do list for ages.

Daniel



On 17 Jan 2011, at 17:35, "tcap479" <notifications@codeplex.com> wrote:

From: tcap479

Daniel:

If you're a .NET programmer (or if you know a .NET programmer), you could certainly hack NodeXL to do what you need to do, because the source code is posted on our CodePlex site. The latest version as of today is at http://nodexl.codeplex.com/releases/view/57817.

However, given that all you need to do is get the statistics for a set of users, that might be gross overkill. Twitter provides an API called "users/show" that provides statistics for one user. (It should be called "user/show"; I'm not sure why they used the plural.) It can be accessed from any programming language that can fetch an HTTP resource and parse the results, whether it's C#, Java, Python, or whatever. Your simple program would just call users/show once for each user in the list, parse the results, and output them as a delimited file, which could then be opened in Excel.

If you're interested, the Twitter API is documented at http://apiwiki.twitter.com/w/page/22554755/Twitter-REST-API-Method:-users%20show. You can see what the results look like for one user by opening http://api.twitter.com/1/users/show.xml?screen_name=dougw in a browser.

-- Tony

Feb 1, 2011 at 9:26 PM

Sanjay:

The feature you requested at the start of this discussion will be in version 1.0.1.161 of NodeXL.  From the NodeXL release notes at http://nodexl.codeplex.com/wikipage?title=CompleteReleaseHistory:

"An additional type of Twitter network can now be imported. When you use the new NodeXL, Data, Import, From Twitter List Network item in the Ribbon, you can view the relationships among a set of Twitter users that you specify, or among the users in a Twitter List. (A Twitter List is a group of Twitter users that any Twitter user can create. They are explained at http://support.twitter.com/forums/10711/entries/76460.)"

-- Tony