In Progress

Collect climate data for 350 cities

The project is to fill in the blank columns in this spreadsheet:

[url removed, login to view]

The spreadsheet contains a list of airports a long with the city and country the airport is located in. The country is in ISO 2-letter format (e.g. CN = China, US = United States, etc.)

There are two tabs in the spreadsheet, one for climate, which has a separate row for each month of the year for each airport, and another one with just one row per airport.

For the Climate tab: fill in the average low temperature, precipitation amount, average days with precipitation, snowfall amount, and average days with snowfall

For the Traffic tab: fill in the number of passengers per year (use 2013 estimated or 2012 actual data).

All of this information is generally available on the web. For example for the city of Chicago you can get climate data here:

[url removed, login to view] (click [show] under the Data section).

Most major cities have a Wikipedia entry like this. For the rest you can search the web.

For the Traffic tab you will need to search airport statistics. In general the website of each airport will have this data. Example:

[url removed, login to view]

You may also find lists of airport statistics:

[url removed, login to view]

[url removed, login to view]'s_busiest_airports_by_passenger_traffic

Please list the link of the data source (where you found the data) in each row in the Ref column.

Skills: Data Entry, Excel, Web Scraping, Web Search

See more: www faa gov, www docs google com, wiki website us, united air, one key data, letter format, faa gov, example for project, country tabs com, cn web world, 12 month spreadsheet, www.docs.google.com, where is google docs, google excel docs, google docs sharing, www data entry gov, investor for, google spreadsheet data entry 2, fill data in spreadsheet, data en, climate, china data entry, chicago format, CCC, web information collect

About the Employer:
( 65 reviews ) Stamford, United States

Project ID: #5272328

Awarded to:

pakee

Hello, I have read your description carefully and i can do this with 100% accuracy and guarantee. plz send me your excel sheet and let me do sample for you right now Thanx

$77 USD in 5 days
(40 Reviews)
4.8

64 freelancers are bidding on average $131 for this job

dataworker2009

Hello, We are professional team of data entry operators having vast knowledge of all type of data entry work with research skills. We provide high quality and time committed service with full of accuracy as my all More

$128 USD in 3 days
(323 Reviews)
7.4
weblazer

Good day! Im Sonny Aldave one of the top virtual assistant provider in [url removed, login to view] from the Philippines. I did similar to this project and the client was very happy with my work. I hope you will consider me for this More

$185 USD in 3 days
(85 Reviews)
7.3
hossionsumon

Dear sir/Mam, Let's start work right now and finished asap.I've lot's of experience similar project.I look forward to hearing from you. Thanks Summon

$154 USD in 3 days
(187 Reviews)
6.9
diamond247

Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job, i have gone through your project description, its really a More

$144 USD in 3 days
(111 Reviews)
6.7
SigmaVisual

Dear Client, I can help in your project. We have already experience of working on similar projects. Please see below to get idea of our experience: Amazon/Ebay Bots: [url removed, login to view] More

$144 USD in 3 days
(50 Reviews)
6.5
uumairkhalid

Hi.. Expert web scraper/Data Minor here. I have done too many similar project in past. I assure you 100% accurate and good quality work. I have too too scraping experience. you can see my experience here: https://www. More

$157 USD in 3 days
(92 Reviews)
6.2
YourAssistant

Hi, I would be glad of having the opportunity to work on this project. I have read your job specifications carefully; please let me let you know that I have 10+ years of experience in this kind of work Please notic More

$111 USD in 3 days
(109 Reviews)
6.1
sonarkaushik

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than More

$147 USD in 4 days
(80 Reviews)
6.0
pandey2008

Hello sir,I have 8 member team and good experience and we can start the work right now and also all communication and work will be high quality. all work will be done on my office and also without any [url removed, login to view]

$84 USD in 3 days
(126 Reviews)
5.9
vsolcorp

Hello, Sir I am from vSol CORP. We are 19 people team, worked on more than 500 completed projects. We provide round the clock service. I have checked your project requirement. We are professional web researcher a More

$151 USD in 4 days
(60 Reviews)
5.9
TypingxpertRehan

ok it will be done in 2 days positively. no worries i have seen spreadsheet it is surely do-able thank you..........!

$252 USD in 2 days
(68 Reviews)
5.7
binaryromel

Hi there, I'm expert in Web Scraping, Web Research, Data Mining, Advance Excel. Please check my feedback as I've done several similar job in freelancer. I'm ready to start immediately. Please PM me. Thank you, F More

$120 USD in 3 days
(71 Reviews)
5.8
kunal2008

Traffic has 347 rows and Climate has 4153 rows. I can complete it no problem but I have doubt about the project cost. I expect at least 500$ to complete this project. Let me know if my expectation is OK for you. kunal

$277 USD in 10 days
(41 Reviews)
5.6
zeitate

Hello. I can start and finish this job in just a couple of days. I'm not currently working on other projects so I can dedicate all of my time to yours. I have a lot of patience and a keen eye for details. Regards and h More

$75 USD in 4 days
(20 Reviews)
5.5
uumarkhalid31

hi, i am expert in web scraping and interested in this project, let me do this work with perfection, accuracy and according to your requirements, plz contact with me ASAP thanks

$147 USD in 3 days
(48 Reviews)
5.5
Venicebrooks

Greetings, Our highly experience web research team is ready to assist. I have been doing data entry/mining work for some 10+ and have gained extensive knowledge that would be of value to this your project. Please no More

$166 USD in 7 days
(18 Reviews)
5.3
FirstChoiceWeb

Hello, Read and understood project details. We have a lot of experience of data scarping and data entry. We can do this job very well also we are ready to do sample entries. Hope to getting consider for this. Regards

$105 USD in 5 days
(33 Reviews)
4.7
ravi666

hello Sir i have 5+ team sir i done this type job last [url removed, login to view] my team ready now and this job with in 2 days.

$83 USD in 2 days
(23 Reviews)
4.3
guadacredhot

My name is Guadalupe.I am real person in [url removed, login to view], and I want a real project like yours.I am very interested in your project. I would like to with you. I have experience in [url removed, login to view] in this kind of projects More

$77 USD in 3 days
(15 Reviews)
3.8
mdreju

Hello there! I am very interested in your job posting that includes appropriate criteria that I possess. So I can firmly believe that I am the perfect candidate for this project. I am honest, persevering and detail-ori More

$50 USD in 1 day
(3 Reviews)
3.5