進行中

MySQL, SQL Job by JennDan

1. Fetch more data from the print page ([url removed, login to view]) and store that data in the database. Pretty much get all the data found on that page. Here's a spreadsheet of the data we want. [url removed, login to view]

2. Automate the fetching so it can use a database of zip codes and go through the zip codes one by one scraping zillow for addresses. Store the addresses in a database table rather than a txt file that gets deleted so that we can run through the database again without having to fetch addresses (or add addresses to a zip code)

3. Ensure that the database has an id for each house so that the same data does not get stored twice in case the script runs over the same zip again. It can be the same house sold in a different year so perhaps identifier could be zillowid+year_sold.

スキル: MySQL, SQL

さらに表示: zillow'com, www zillow com, www zillow, zillow, xlsx, cir, data fetch spreadsheet, deleted project, dropbox page, dropbox script, custom spreadsheet database, custom case, txt xlsx, fetching data, fetching project, project dropbox, data scraping code, zillow data spreadsheet, spreadsheet zillow data, stored project, custom scraping, custom codes, script zillow, zillow spreadsheet, custom database code

採用者について:
( 3件のレビュー ) New Orleans, United States

プロジェクトID: #2435119

アワード:

kernelbd

Hired by the Employer

$200 USD 7日以内
(23レビュー)
5.1