My problem here is quite simple but it has been proving difficult. I tried to scrape phone number and location from a website but upon scraping, the values are not placed properly, in the phone number column, it’ll show 100 values, then the 101th line, it’ll show locations value for another 100 leaving the phone number column blank. Then for the 201th value, it’ll switch back to the phone number column leave the location column blank which normally out to be side be side, I have an image to further explain. I thought it was because I was using the free trial then I purchased credit and it’s still the same thing.
Can you possibly help me to generate the right sitemap to scrape just PHONE NUMBER and LOCATIONS ONLY, I have attached the link to the website below as well, thank you so much as I look forward to your assistance and response.
Url: [http://www.whitepages.com/phone/1-405-546]
Sitemap:
{id:"sitemap code"}