Closed

Script to find Twitter handles and then search them for key words

This project was awarded to iDivya for $231 AUD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$100 - $250 AUD
Total Bids
6
Project Description

Hello.

There are two separate tasks within this project. Your bid should of course cover both tasks.

Task 1

We need you to, using the Twitter API and Search feature as much as possible, write a script to obtain a list of Twitter users. We will provide you with a list of search terms. For example, the set of search terms may be this:

Search Terms=[Kings of Leon, Sydney FC, Keith Urban, The Black Eyed Peas]

You need to write a script which will do the following:
1. Search for each Search Terms element, one at a time
2. Taking the top (first) search result, capture the following information and write it to an Excel file the following information:
a. Twitter Name (e.g. Kings of Leon)
b. Twitter Handle (e.g. @KingsofLeon)
c. Verified (If Verified [which is demonstrated by a white tick inside a blue star], enter “Yes”, otherwise enter “No”)
3. Taking the top (second) search result, capture the same information as in step 2.
4. Repeat steps 1-3, until every element in Search Terms has been searched for.

Note, how exactly you loop through those steps is of course up to you - we just need to make sure we have searched through all search terms, and have captured the output in the Excel sheet.

The Excel spreadsheet would then have only 3 columns. Column A would be Twitter Name, Column B would be Twitter Handle and Column C would be Verified.

Once Task 1 is completed, and we have our fully functioning and accurate Excel database of Twitter accounts, we can then move on to Task 2.

Task 2

We require someone to, using the Twitter API and Twitter Search as much as possible, create a script which will search a series of pre-defined Twitter accounts (the results of Task 1 above) for a series of pre-defined keywords. The script will then need to place this information into a simple SQL database. We will provide more details of what exactly we need here to the winning bidder.

For example, the set of Twitter accounts (found in Task 1) may be the following:
Twitter Accounts=[@kingsofleon, @SydneyFC, @KeithUrban, @bep]

And the set of keywords may be the following:
Keywords=[Australia, Sydney, happy, silly, event, today, soon, announced]

Your script would then need to be able to search through all the Tweets from the Twitter Accounts and test if any element in Keywords are found within the Tweets. We would run this script on some periodic basis (probably daily), and so the script would need to only report any new Tweets that have been generated since the last time the script was run.

In your bid, please write “I am a human” somewhere, and also the write the capital of France in capital letters at the end of your bid.

Please also ask any clarifying questions before submitting a bid, by sending us a message.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online