Create 2 excel files using databases

Closed - This job posting has been filled and work has been completed.
Web, Mobile & Software Dev Scripts & Utilities Posted 3 years ago

Fixed Price

Budget: $75
Delivery by March 6, 2013

Start Date

February 3, 2013


Please produce two excel files using databases.

Step 1)
Download the “.com” zonefile  (Warning this file is HUGE! 1.9GB)
Create a sub-set database from this with every “.com” that contains the word “realty”

Step 2)
Download a database with all cities in the world along with population. (over 1,000 people) (population listed) (population listed)

Step 3)
Using both databases above, Break the “realty” list created from the first database into two separate excel files.
a) Exact match Geographic Locations.xls
COLUMN names City, Country, Region, Population, TotalCities, matches
For example matches “Kirkland” population 45,778
In the excel file put these three columns per city: “city, country, region, population”
Do not allow other characters in the city name, only {A through Z and hyphen}.
For cities that have special characters other than A through Z put three versions.
An example would be “rio de janeiro” put three rows:
No spaces version: Row 1) riodejaneiro, Brazil, “6,323,037”
Hyphen version: Row 2) rio-de-janeiro, Brazil, “6,323,037”
First word version: Row 3) rio, Brazil, “6,323,037”
An example for Marriott-Slaterville,UT would be
No spaces version: Row 1) marriottslaterville, USA, UT, “3,037”
Hyphen version: Row 2) marriott-slaterville, USA, UT, “3,037”
First word version: Row 3) marriott, USA, UT, “3,037”
Do not allow duplicate city names. Only allow one row per unique city name.
If there are two cities named moscow, please just list how many cities in the world have that same name in the TotalCities column. Combine populations in the population column. and would only result in one row. However in demand column for Seattle you would put 2 rather than 1.
b) Not exact match.xls
COLUMN names Name, matches
Put “name” in a row, with no “.com”. and would only result in one row. However in matches column for 101 you would put 2 rather than 1.

About the Client

(5.00) 1 review

United States
Mercer Island 10:22 PM

1 Job Posted
100% Hire Rate, 1 Open Job

$74 Total Spent
2 Hires, 0 Active

Member Since Feb 3, 2013