I have a database of information including the following:
Area Code, City, State, Population, Zip
for every zip code in the USA
I need to have the following information extracted from it. For each Area Code I need to have the top three cities by population extracted with the following information:
Area Code, City, State, Population, CL URL
IMPORTANT: The data is given by zip codes so there is a population size or record for each zip code so you might have 20 zip code records for New York with a separate population size for each so this would have to be combined (to form just one New York) to get an accurate top three list. I have attached an example of the data.
Also note that I need a corresponding Craigslist URL for each entry. This can be extracted from [url removed, login to view] but the url I need is the posting one. So click the city and click the post button and you will see the url.
Programmer must not give or keep the data given to them for this project. I need the data back in delimited format.