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

In Progress Posted Apr 10, 2013 Paid on delivery
In Progress Paid on delivery

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.

MySQL PHP Twitter Web Scraping

Project ID: #4408878

About the project

6 proposals Remote project Active Apr 12, 2013