Find more Data Mining And Management Remote Jobs posted recently Worldwide

Required Data Science & Analytics,Data Mining & Management freelancer for Scrape of SDWIS job

Posted at - Jan 30, 2021

Toogit Instant Connect Enabled


I need to scrape part of a national database of water quality violation information known as the SDWIS (2013-2018). The query-able database is here: (Removed by Toogit admin)
The database is split into 9 different types of report, and I need specific variables from four of the reports. For now I'm only requesting the information in the violations report, but assuming satisfactory completion I will keep you on contract and request at least three additional reports with negotiated pay for each report. Anyone with good web-scraping skills is welcome to apply. Priority will be given to applicants who offer a sample of the completed task so I can be confident in your ability to scrape the data.

The deliverable for this first contract will be one spreadsheet with all variables in the 'Violations' report for all years and quarters. You will need to create variables for reporting year and quarter so I can identify the origin of each report. The spreadsheet will be quite large, so you may need to break it up into several spreadsheets before sending it over. I will share a workbook, the tab 'Sample Violations' shows what I expect the report to look like. I would also like you to send me the code, preferably Python, you use to pull the data.

In this paragraph I'm going to explain the entire job so you have a good idea of whether you will be able to complete the follow-up contracts. In workbook I show the variables I'll eventually request from each report along with some sample spreadsheets showing what I'm looking for. The final deliverable will be four spreadsheets, one for each type of report, with all available years (2013-2018) and quarters (1-4) appended to the same spreadsheet. In the process of pulling the data for each year and quarter, you'll need to create variables for year and quarter so I can identify the origin of each report. For one of the reports ('Water System Summary'), you'll need to create two categorical variables based on sub-queries in the 'Further Water System Characteristics.' In the spreadsheet I show these variables and the numeric indicators for each category.

Thank you for your interest, and please let me know if you have any questions about the project.

About the recuiterMember since May 20, 2018 Mr. Dinesh Das
from Nordrhein-Westfalen, Germany

Skills & Expertise Required

Data Science & Analytics Data Mining & Management 

Candidate shortlisted and hiredHiring open till - Jan 30, 2022

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$243.49
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Data Mining And Management category.