python-2.7openstack-python-api

extracting tweet from Twitter API using Python


I want to get every tweet of the HousingWire on Twitter (https://twitter.com/HousingWire). I understood how to authenticate into the twitter account but how I can get the tweet of HousingWire?

I know how to stream the data based on the keywords,but I want to stream the HousingWire tweet. how I can do that?

import time
from tweepy import Stream
from tweepy import OAuthHandler
from tweepy.streaming import StreamListener

ckey='' 
csecret=''
atoken=''
asecret=''

class listener(StreamListener):
    def on_data(self,data):
       try:
             print data

            #tweet=data.split(',"text":"')[1].split('","source')[0]
            #print tweet
            #savethis=str(time.time())+'::'+tweet
            savefile=open('tweetdb.txt','a')
            savefile.write(data)
            savefile.write('\n')
            savefile.close()
            return True
      except BaseException,e:
            print 'failed on data',str(e)
            time.sleep(5)   

    def on_error(self,status):
        print status

auth=OAuthHandler(ckey,csecret)
auth.set_access_token(atoken,asecret)
twitterStream=Stream(auth,listener())
twitterStream.filter(track=["stock"])

Solution

  • You can use the below Python script to grab the last 3,240 tweets from HousingWire (Twitter only allows access to that many tweets from a user - no way to grab the complete history). Usage: Simply put their twitter screen name in the script.

    #!/usr/bin/env python
    # encoding: utf-8
    
    import tweepy #https://github.com/tweepy/tweepy
    import csv
    
    #Twitter API credentials
    consumer_key = ""
    consumer_secret = ""
    access_key = ""
    access_secret = ""
    
    
    def get_all_tweets(screen_name):
        #Twitter only allows access to a users most recent 3240 tweets with this method
    
        #authorize twitter, initialize tweepy
        auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
        auth.set_access_token(access_key, access_secret)
        api = tweepy.API(auth)
    
        #initialize a list to hold all the tweepy Tweets
        alltweets = []  
    
        #make initial request for most recent tweets (200 is the maximum allowed count)
        new_tweets = api.user_timeline(screen_name = screen_name,count=200)
    
        #save most recent tweets
        alltweets.extend(new_tweets)
    
        #save the id of the oldest tweet less one
        oldest = alltweets[-1].id - 1
    
        #keep grabbing tweets until there are no tweets left to grab
        while len(new_tweets) > 0:
            print "getting tweets before %s" % (oldest)
    
            #all subsiquent requests use the max_id param to prevent duplicates
            new_tweets = api.user_timeline(screen_name = screen_name,count=200,max_id=oldest)
    
            #save most recent tweets
            alltweets.extend(new_tweets)
    
            #update the id of the oldest tweet less one
            oldest = alltweets[-1].id - 1
    
            print "...%s tweets downloaded so far" % (len(alltweets))
    
        #transform the tweepy tweets into a 2D array that will populate the csv 
        outtweets = [[tweet.id_str, tweet.created_at, tweet.text.encode("utf-8")] for tweet in alltweets]
    
        #write the csv  
        with open('%s_tweets.csv' % screen_name, 'wb') as f:
            writer = csv.writer(f)
            writer.writerow(["id","created_at","text"])
            writer.writerows(outtweets)
    
        pass
    
    
    if __name__ == '__main__':
        #pass in the username of the account you want to download
        get_all_tweets("J_tsar")