I need someone to use this website link, to write a script to scrape the "Rate Center" and "Region" data for each phone number in the CSV file. :
[login to view URL]
1. The script will need to take the first 3 numbers of the phone from the CSV file and enter it in the Search box in the top left of the page labeled "NPA", and take the next 3 numbers of the phone number and enter in the 2nd box labeled "NXX", this box is just to the right of the first box, and then hit enter to start the search, it will post results below. (I have included a sample of what that looks like. the file is called "Search results sample" )
2. In the search results section, in the row that shows "LEVEL 3 Communications, LLC" , from the third column labeled "Rate Centre", scrape the name of the city, (note: if there is more than one row labelled "Level 3 Communications LLC" , its ok, you don't need to list it again as the info will be the same) and 2nd piece of data neede, in the fourth column labeled "Region" scrape the state abbreviation, those two pieces of information need to be added to the CSV file for each of the 2,030 phone numbers and put each piece of data in the appropriately labeled column. The first five phone numbers have already been searched so you can see how its done.
IMPORTANT: TO BE AWARDED THIS JOB YOU MUST COMPLETE THE NEXT FIVE AND SEND ME THE FILE TO BE CONSIDERED, so we can see you understand and know how to do this project.
IMPORTANT ITEM #2: This project is time sensitive. WHEN YOU SEND ME THE FILE I NEED YOU TO TELL ME HOW MANY HOURS THIS WILL TAKE YOU. I need this file completed in the next 15 hours or sooner. So by tomorrow morning at 12pm Pacific Standard Time. (Which is California time.)