Btukfyl

I am currently working on a school project where I am comparing two news networks social media pages (CNN & FOX) for tweets mentioning 'Donald Trump' and exporting them into a CSV file to perform a sentiment analysis on. Which I will then analysis and asks certain questions to determine who has a more negative sentiment analysis. as well as some more analysis to be decided later.

I have been able to extract the tweets from CNN and export them into a CSV file, then perform the sentiment analysis on that CSV file. My problem is only grabbing tweets that specifically mention 'Donald Trump'

Here is my python code to scrape the tweets from CNN's twitter page:

(I have taken out my Twitter Auth Keys)
(file name: tweet_dumper.py)

import 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 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("CNN")

What I need to do now is to modify this python code to get tweets mentioning only 'Donald Trumps' name, not just all the tweets from CNN (as the code does currently). Any suggetions would be appreciated.

Link to author for tweet scraper: https://gist.github.com/yanofsky/5436496