So I have a steady need to find the locations of people in large data files (excel sheets with anywhere from 2,000-50,000 contacts). The files include first, last, title, company and I want to scrape their locations from LinkedIn into a new column. Since LinkedIn limits how many searches you can perform, I want to use Bing searches first, then fill in the remaining with LinkedIn directly.
I created a LinkedIn Search URL and Bing search URL for them all in two new columns. The URLs work, I tested them. Here is an example: [login to view URL]
[login to view URL] Ski Resort%09Children's Ski and Snowboard School Supervisor&qs=n&form=QBRE&sp=-1&pq=
I need something simple, reliable and quick that does not cost anything monthly. I believe there are a few ways to do this and I am open to different ways. Possibly with an excel web query.
I believe this can be done using Python, dump to a csv, and then open in excel. Possibly using splinter or selenium with python to do the searching, and optionally use beautiful soup to extract the location information from the search results.
For this project to be successfully completed, I need the process to be:
-A streamlined way to process multiple large files 2,000-50,000 contacts a month
-No monthly fee
-An easy-to understand explanation of how to do this on a regular basis as I've never used Python before
In your bid, please let me know:
-Details of how this can be done
-Previous similar projects you've completed
36 pekerja bebas membida secara purata $141 untuk pekerjaan ini
I’ve 5 years of experience of data entry & MS Excel especially with pivot tables, charts, advance formulas and VBA codes Relevant Skills and Experience MS Excel Proposed Milestones $50 USD - Upon Completion