Get data from Twitter using Tweepy and store in csv file

by

This will do the job!

I will recommend you to use csv from Python. Open a file and write to it during your loop like this:

#!/usr/bin/python
import tweepy
import csv #Import csv
auth = tweepy.auth.OAuthHandler('XXXXXX', 'XXXXXXX')
auth.set_access_token('XXX-XXX', 'XXX')

api = tweepy.API(auth)

# Open/create a file to append data to
csvFile = open('result.csv', 'a')

#Use csv writer
csvWriter = csv.writer(csvFile)

for tweet in tweepy.Cursor(api.search,
                           q = "google",
                           since = "2014-02-14",
                           until = "2014-02-15",
                           lang = "en").items():

    # Write a row to the CSV file. I use encode UTF-8
    csvWriter.writerow([tweet.created_at, tweet.text.encode('utf-8')])
    print tweet.created_at, tweet.text
csvFile.close()

More Related Contents:

  1. Avoid Twitter API limitation with Tweepy
  2. Importing Tweets via Python using Tweepy
  3. Writing a Python list of lists to a csv file
  4. Reading a huge .csv file
  5. Skip the headers when editing a csv file using Python
  6. Read and Write CSV files including unicode with Python 2.7
  7. Python parse CSV ignoring comma with double-quotes
  8. How can I get tweets older than a week (using tweepy or other python libraries)
  9. portable way to write csv file in python 2 or python 3
  10. How to add a location filter to tweepy module
  11. Use Multiple Character Delimiter in Python Pandas read_csv
  12. How can I use io.StringIO() with the csv module?
  13. Managing Tweepy API Search
  14. Python Pandas – Read csv file containing multiple tables
  15. How to count top 10 most common values in a dict in python
  16. A simple maths operation on a CSV column using python [closed]
  17. How to write a python code which copies a unique column from an output file to a .csv file
  18. How to uninstall Python 2.7 on a Mac OS X 10.6.4?
  19. Compare two CSV files and search for similar items
  20. Using multiple Python engines (32Bit/64bit and 2.7/3.5)
  21. Login to website using urllib2 – Python 2.7
  22. Python Pandas: How to read only first n rows of CSV files in?
  23. python: deque vs list performance comparison
  24. How to set proxy authentication (user & password) using Python + Selenium
  25. How to unzip gz file using Python
  26. How to completely traverse a complex dictionary of unknown depth?
  27. how to skip blank line while reading CSV file using python
  28. How to use PyCharm to debug Scrapy projects
  29. Pandas to_csv call is prepending a comma
  30. How Postgresql COPY TO STDIN With CSV do on conflic do update?

Leave a Comment