完了済み

39074 Data Mining Project

I need the following job completed: I will provide a .sql file containing 4147 company names. Your task is to use the google api or any other methods you want to search for each single company name and store the first 100 Google results into a mysql table. Basically you are responsible to deliver me a new .sql file with 414700 URL's. Additional requirements: You will have to make sure that all URL's are unique (simply set the row as unique and use "insert ignore" to add the found URL's. The structure I want from you is: table name: companies rows: url / company name (both unique) I need this format to check if you have found 100 unique url's per company name. Aditionally I also want you to delete URL's that point to: .xml / .pdf / .rss / .doc Basically you will have to deliver me the [url removed, login to view] file with 414700 records while the above file formats should not appear. If you place a bit tell me how much time it will take to complete the job. Do not post unrealistic bids as this is just data mining - meaning it's not really hard work and with the right tools you don't even need to be on your computer. I will not accept any unrealistic bids and I am not interested in any of your references - I just need the job done quickly. I will not pay you more than your bid so think before you bid. I expect the results provided within the time you name. If you deliver too late I will pick another programmer. Make sure to do the math - I need 100 results per company name so better grab more than 100 because I am sure there will be pdf urls etc. I do sound strict but I need the results I asked for - no questions asked. Being a professional freelancer you should have no problems with my terms. Do not alter my requirements. I asked for a .sql file not csv or other formats. Make sure to test your database before providing the sql file cause I do not have time to fix issues myself.

スキル: その他, データ入力

さらに表示: xml sql freelancer, want to do freelancer project, use of data structure, t sql freelancer, table data structure, simply done freelancer, set myself as a freelancer, set in data structure, set data structure, search data structure, requirements for computer programmer, questions of data structure, project names in freelancer, programmer test questions, programmer names, professional computer programmer, post project on freelancer, pick freelancer, new data structure, need of data structure to programmer

採用者について:
( 37件のレビュー ) Amsterdam, Netherlands

プロジェクトID: #1788633

アワード:

scriptbots

This work will take few hours and then 1-2 days to collect information by script. Happy NEW YEAR! Thanks, /Vincent Vega/

$45 USD 3日以内
(0レビュー)
0.0