This is a project for web data extraction from the site Google Answers.
The detailed project requirement is as follows -
Step 1 – Generate an Excel file with the following 7 coloums (a) Asked By (b) List Price (c) Posted Date & Time (d) Question ID
(e) Answered by (f) Date & Time of answer (g) Character count for answer
Step 2 - Visit http://answers.google.com.
Step 3 - Click on "Arts and Entertainment" hyperlink on the home page. The first page of Arts and Entertainment section says "Showing questions 1 - 25 of about 2748 in Arts and Entertainment". In other words, each webpage shows 25 questions.
Step 4 - You need to click on each of the questions listed, which in turn opens a webpage.
Step 5 - For each question that you open, please select and paste the following information into each of the 6 coloumns created in the excel file, as part of Step 1
Step 5(a) - Copy the name given against "Asked by:" field and paste it into Asked by coloumn in the Excel file
Step 5(b) - Copy the data against the "List Price:" field and paste it into the "List Price" coloumn in the excel file
Step 5(c) - Copy the data against the "Posted:" field and paste it into the "Posted date & time" coloumn in the excel file
Step 5(d) - Copy the data against the "Question ID:" field and paste into the "Question ID" coloumn in the excel file
Step 5 (e) - Copy the data against the "Answered by:" field and paste into the "Answered by" coloumn in the excel file
Step 5 (f) - Copy the data against the "Answered by:" field but the date and time stamp alone, and paste into the "Date & Time of Answer" coloumn in the excel file.
Step 5 (g) - Indicate the character count for the answer including spaces between words.
Repeat Steps 5(a) to 5(g) for each of the questions listed in the "Arts and Entertainment" section of the Google Answers site. Cover all the 2748 questions.
Similary, complete this task for all the categories on Google Answers. They are -
Arts and Entertainment Reference, Education and News
Business and Money
Relationships and Society
Family and Home
Sports and Recreation
42 freelancers are bidding on average $51 for this job
Hi, We are a BPO company, and i have read your instruction, we have a professinal team to help ypu finish this project quickly. please check PMB for details, Thanks!