Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>The short answer to your question is, yes, of course you can measure influence in some way from Twitter data. On the other hand, you probably should give a decent amount of thought as to how you understand influence as a metric, how this relates to your data, and how you'll measure influence in your data.</p> <p>A few things you might consider:</p> <p>1.) In addition to pulling in tweets for individual users, you probably also want to pull in their profile information (e.g., follower count, total number of tweets, etc.). By combining this data with the metadata from the Tweets, you'll have more to play with.</p> <p>2.) Consider looking at some of the following data points, on a per individual basis:</p> <ul> <li>Share of tweets retweeted: Say you pull in 1000 tweets for an individual; you can establish what percentage of these tweets are retweeted (e.g., what percentage of these tweets are influencing others to retweet).</li> <li>Average # of retweets per retweeted tweet: when the person is retweeted is it just one or two people that retweet him/her, or is it hudnreds?</li> <li>Follower counts: This data point, on its own, tells you something. In general, it's probably the case that someone with more followers is more influential than someone with less.</li> </ul> <p>3.) You also should think about topical relevance. If someone is getting retweeted a lot on Twitter and has a large followership, is it because of tweets related to their profession, or because they write about cats? Depending on your use case and business logic, these sorts of questions can be critical.</p> <p>These are just some starting points. I'd spend some time looking at the Twitter REST API 1.1 documentation and the Twython documentation so you get a better sense of which data points are available, and then think about how these data points might contribute to your measure of influence.</p> <p>Good luck.</p> <p><strong>EDIT</strong> If I understand correctly, vishal1985, in your comment you're asking how to use Twython to collect information about retweets. This could mean one of several things, but I think what you're asking about is how to get to some of the datapoints I listsed (for instance, "share of tweets retweeted" , above). </p> <p>Here, again, I would point you to the Twython and <a href="https://dev.twitter.com/docs/api/1.1" rel="nofollow">Twitter API Documentation</a>, which you really should get to know if you plan on working a lot with this sort of data. But to point you in the right direction, here's how you could determine the percentage of original tweets from an author that get retweeted by others.</p> <pre><code>from twython import Twython from __future__ import division #assuming you're using Python 2.X t = Twython(app_key='...', app_secret='...', oauth_token = '...', oauth_token_secret = '...') #supply your credentials for each of these tweets = t.getUserTimeline(screen_name='justinbieber', include_retweets=False) #see note below retweeted_tweets = 0 for tweet in tweets: if tweet['retweet_count']&gt; 0: #...if at least one person has retweeted the tweet retweeted_tweets += 1 share_tweets_retweeted = retweeted_tweets/len(tweets) #e.g., #number retweeted divided by total number of sampled tweets </code></pre> <p>What these steps do is pull in up to 200 tweets that have appeared in the user's timeline. The <strong>include_retweets=False</strong> part may seem confusing, but it's necessary. What that does is exclude tweets that other people have written that the author you're interested in (in this case Justin Bieber) retweeted, because what you want to know is how many people retweet your author when he or she writes original content. We iterate over the user's timeline, and determine the number of their tweets that were retweeted by at least one person. We then divide that by the total number of sampled tweets, and that gives us the share that gets retweeted.</p> <p>Note that this doesn't take into account pagination (e.g., navigating through multiple pages of a timeline -- you can only request 200 tweets from a timeline at a time, and up to 5000 total), which is something you'd probably want to implement. Hope this helps.</p>
    singulars
    1. This table or related slice is empty.
    1. POAnalyzing influence level
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USBenjamin White
    1. USBenjamin White
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POAnalyzing influence level
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThanks Benjamin for the answer but using twython how to collect retweets .It is easy to get the followers count by Twython
      singulars
      1. PO
      1. USUselesssss
    2. CO@vishal1985, see my edits above, which give you a bit of guidance on how to go about using Twython to get data about retweets. Given that your original question is not really about how to use Twython, but about how to measure influence on Twitter, I'd recommend opening a new question for any questions about Twython itself. I believe my original post answers your original question -- and if you agree, would you mind choosing my answer? :)
      singulars
      1. PO
      1. USBenjamin White
    3. COThanks Benjamin for your effort and great simple explanation.One more thing then if a person has got more retweets can we consider him/her as an inflential person or is some other metrics for that.Please can you clarify this also
      singulars
      1. PO
      1. USUselesssss
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload