Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
This is a python script to download all the tweets of a hashtag into a csv file.
import tweepy
import csv
import pandas as pd
import sys
# API credentials here
consumer_key = 'INSERT CONSUMER KEY HERE'
consumer_secret = 'INSERT CONSUMER SECRET HERE'
access_token = 'INSERT ACCESS TOKEN HERE'
access_token_secret = 'INSERT ACCESS TOKEN SECRET HERE'
auth = tweepy.OAuthHandler(consumer_key, consumer_secret)
auth.set_access_token(access_token, access_token_secret)
api = tweepy.API(auth,wait_on_rate_limit=True,wait_on_rate_limit_notify=True)
# Search word/hashtag value
HashValue = ""
# search start date value. the search will start from this date to the current date.
StartDate = ""
# getting the search word/hashtag and date range from user
HashValue = input("Enter the hashtag you want the tweets to be downloaded for: ")
StartDate = input("Enter the start date in this format yyyy-mm-dd: ")
# Open/Create a file to append data
csvFile = open(HashValue+'.csv', 'a')
#Use csv Writer
csvWriter = csv.writer(csvFile)
for tweet in tweepy.Cursor(api.search,q=HashValue,count=20,lang="en",since=StartDate, tweet_mode='extended').items():
print (tweet.created_at, tweet.full_text)
csvWriter.writerow([tweet.created_at, tweet.full_text.encode('utf-8')])
print ("Scraping finished and saved to "+HashValue+".csv")
#sys.exit()
@sxshateri

This comment has been minimized.

Copy link
Owner Author

commented Jun 13, 2019

This script is written in python 3. Please make sure you have installed Tweepy and Pandas before running the script.

@meylanwongkar

This comment has been minimized.

Copy link

commented Jun 25, 2019

how can i save the tweets with header using pandas?

@sxshateri

This comment has been minimized.

Copy link
Owner Author

commented Jun 25, 2019

how can i save the tweets with header using pandas?

what exactly do you mean by "header"? are you referring to the header row of the csv file?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.