I have 10 XLS files containing data about hospitals, I need the following:
- filter and delete rows so that each hospital is present just once on the database;
- for each hospital, the name should remain exactly the same as the one reported in the database, but I need for each hospital also the following info: address (in most cases this has been already entered), City, Province, Telephone (in most cases present but to be verified, Website, Image_url (a link to an image of the hospital). These info can be recovered by Googling the hospital name.
- each dataset has a varying number of unique hospitals (30-50 hospitals for each XLS)
- you can either to this manually by googling each hospital name or through scraping (in that case, py script required). Please specify in your bid how you plan to do this
66 freelancers are bidding on average $107 for this job
i could write a VBA macro (Visual Basic macro/subroutine) to improve automatic filter on the excel datasheets, it could be used also for future data. I already had experience about
Hi, im an Excel and VBA programmer with over 5 year of experience in developing Office solutions for businesses and individuals. this seems to be an easy job, I hope to be helpful. regards
i will scrap all data by filtering and find all data you require and with very accurate scale.i have good scraping skill that help me on this project and i will do this on reasonable price.
I'm planning to do the required tasks manually. I have just registered here at freelancer.com, however I have sufficient experience in Excel and I am quite sure I can manage the job if you give me a chance.