There is a test question in this description.
We have a list of professional certifications that we want to fill in gaps and add to it (see certification image). Our list is about 700 and we have several sources we want to add it (see certification-sources image).
each certification needs to have fields (certification, certification name, Agency, Agency website, category/industry)
Each new section should get an updated batch ID, this is so it can be sorted later on (certification+batch ID). If sorted, you can find data from source #2 and complete the record in source #1. After merged, you can remove duplicates. Note: this is the smart way to add entire tables from wikipedia and other sources to quickly fill in information that is missing.
When all sources have been merged, then it is time to fill in missing websites and Categories. If you are smart, you will create a google search URL as a column, so you can simply click on a link and do a search on something like "American College of Healthcare Architects". This method will help you quickly find the missing websites.
Note: if you are the type of researcher that expects to cut/paste every item, you will not succeed. You should be able to copy/paste tables into a google sheet, do some basic =Concatenate() (to create google search) functions, sort and remove duplicates. In addition, this is not a pure scraping project as there are many sources of tables that are different.
Here is an example google search built with =Concatenate() function
[login to view URL]
Follow this format and finding stuff will be easy.
We need attention to detail. To show you have it, put your favorite color as all caps as the first word in your bid. If you don't do this, your bid will be ignored.
We will share our google sheet with the winning bidder. A sample of one of the sources is listed below. It is easy to copy paste each table into temp sheet, arrange columns and then add to main sheet.
[login to view URL]
White Dear sir, Honestly say to you, I am new for this type of work but I sure to say you, I am very serious about this work. If you want to do this work i can surely say i am right person for your work. Let's talk abo Daha Fazla
RED Greetings, I have experienced in admin tasks, especially data entry. Would be happy to discuss further on the details/type of data at your earliest convenience. Regards, Mei
Bu iş için 17 freelancer ortalamada $130 teklif veriyor
Hi sir, Ok understood, I have read the project description and checked the attached file, everything is clear and ready to prepare a sample for a quick test. Please contact me to discuss further details!