The database is split into 9 different types of report, and I need specific variables from four of the reports. For now Im 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 Im 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 Ill eventually request from each report along with some sample spreadsheets showing what Im 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, youll 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), youll 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.","employmentType":["FULL_TIME","PART_TIME","CONTRACTOR","TEMPORARY","PER_DIEM"],"jobLocationType":"TELECOMMUTE","hiringOrganization":{"@type":"Organization","name":"Toogit","sameAs":"https://www.toogit.com/","logo":"https://www.toogit.com/images/toogit_logo_initial.png"},"identifier":{"@type":"PropertyValue","name":"Toogit","value":362715},"skills":["Data Science & Analytics","Data Mining & Management"],"applicantLocationRequirements":[{"@type":"Country","name":"IN"},{"@type":"Country","name":"Canada"},{"@type":"Country","name":"USA"},{"@type":"Country","name":"Germany"},{"@type":"Country","name":"Pakistan"},{"@type":"Country","name":"Philippines"},{"@type":"Country","name":"Indonesia"},{"@type":"Country","name":"Sri Lanka"},{"@type":"Country","name":"Nigeria"},{"@type":"Country","name":"China"},{"@type":"Country","name":"Russia"},{"@type":"Country","name":"Bangladesh"}],"validThrough":"2024-08-16T03:18:06+05:30","url":"https://www.toogit.com/freelance-jobs/MzYyNzE1"}
Remote Data Mining And Management Job In Data Science And Analytics
Find more Data Mining And Management remote jobs posted recently Worldwide
Work from Anywhere
40 hrs / weekFixed Type
Remote Job$334.97
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
Looking for someone who has vast knowledge with excel and utilizing formulas. Have a few excel sheets that I need cleaned up and put into the correct format for uploading. May turn into future work mining data from the city/county.
we need to prepare sql queries on our tables.
some report page will be arrange with our coder.
we will guide which tables and column and which results will need.
We will need product pictures and descriptions and titles scraped and formatted into an excel database.
Obviously various sources have various measures for difficulty for scraping and we will discuss that before each scrape.
Fairly...read more