В работе

Confirming accuracy of LW scraped location data


We're still working with the Living Wage dataset. In this spreadsheet there are 2759 Google Places locations for 371 companies. Column F, maps_link, will take you to the location on Google Maps. Column J, google_place_id, is the unique ID for the place. Column A, "company_natural_key" is the company name. And column B, company_website_url, is a link to the company website.

This data has been scraped from Google Places API, so it contains lots of false positives (look at row 93: the place_name "Lifeboat" is not a Brewdog pub)


The task is to set column E to either INCLUDE or EXCLUDE.

If the place is a valid location for the company, set column E to INCLUDE.

If it's an invalid location for the company, set it to EXCLUDE.

Otherwise, leave it as UNSPECIFIED

I've run some code to auto-set the value. So 308 are already set to INCLUDE, 15 are already set to EXCLUDE. Which unfortunately leaves 2436 UNSPECIFIED.

But 2194 of the UNSPECIFIED rows are for the 8 big national brands, particularly COOK (which gives an awful set of results because it's such a common word).

To help decide whether a place is valid or not, you could refer to the google_classification column, although it's not always helpful. But you should be able to knock out a lot that way, especially with COOK and the other national brands.

Your ultimate source of truth is always to be to go to the company website, find their store locator, and confirm the locations manually.

If you find that the spreadsheet is missing places, add a note in the comments column.

*National Companies*

Some notes on the big national companies...

In general, these don't have to be perfect. There is subjectivity anyway (e.g. Ikea "collection points" vs Ikea stores). A few too many or a few too few is not a problem.

Majestic Wine

- Wine store

- We expect "200+" locations

- Store locator: [login to view URL]

- Search seems to be pretty good - only a few false positives


- Pub

- We expect ~49 locations

- Store locator: [login to view URL]

- Search seems to work fairly well for these. Modern company, good with their online presence :)


- Fashion store

- We expect ~23 locations

- Store locator: [login to view URL]

- I don't think the Burberry "outlets" are official stores, so remove these.


- This is a shop that sells high quality ready meals

- We expect ~110 locations

- Store locator: [login to view URL]

- This search is terrible and brings back loads. Hard to tell which are valid and which aren't. Will take some effort, I think :(


- Cosmetics store

- We expect ~106 locations

- Store locator: [login to view URL]

- We are getting more like 300 back, so a lot of false positives here


- Cinema

- We expect ~13 locations

- Store locator: [login to view URL]

- They have an "other" category on their cinema list, which come back in the search. I think we should leave these in.


- We expect ~27 locations

- Store locator: [login to view URL]

- Loads of rubbish comes back here, because the stores are so big (e.g. bus tops, and restaurants)

Richer Sounds

- Electronics store (mainly audio/video I think)

- We expect ~53 locations

- Store locator: [login to view URL]

- Looks like search worked ok

*Other points*

There should be only UK locations in the dataset (England, Scotland, Wales, Northern Ireland; Not Republic of Ireland). If you find any outside of the UK, EXCLUDE them

We do not want the companies' head offices. We only want stores/shops/branches where customers interact directly with the business

Квалификация: Excel, Ввод данных, Поиск в Интернете

Показать больше collating data business, google maps import location data, data mining restaurants, scraped rss data, send location data using gprs, crawler location data, data business australia listing, location data entry project, location data voice channel, map display location data, real time data business, service data business layer, unlimited telemarketing data business leads, data business cards, backend data business chennai, location type business iphone, data number restaurants philippines, upload location data iphone website, drupal access node location data, javascript location data mobile

О работодателе:
( 1 отзыв ) Haywards Heath, United Kingdom

ID проекта: #20324831



Hey this is Sourabh Gupta from New Delhi. I would like to provide my services for this project. Placing the bid as discussed, thanks. Regards Sourabh

£8 GBP / час
(114 отзывов(-а))

33 фрилансеров(-а) в среднем готовы выполнить эту работу за £6/час


Hi there. I am a full time web researcher. Updating column E by manually going through store locator pages of listed brands will be done with 100% accuracy. I have years of experience and have completed 500+ data proce Больше

£10 GBP / час
(394 отзывов(-а))

Hi there, I can confirm accuracy of LW scraped location data. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

£5 GBP / час
(422 отзывов(-а))

Hi, I am a web data research expert. I can help to go to the company website, find their store locator, and confirm the locations manually. Please send me the file. Let's discuss and start. Thanks

£5 GBP / час
(885 отзывов(-а))

Hello there, We have reviewed the requirements and we are interested in offering our services. # APPROACH # The Best way to accomplish this is by locating the stores on official website itself. We recently complet Больше

£6 GBP / час
(182 отзывов(-а))

Hello, I can help to validate a list of 2,759 UK locations. I’m willing to give a sample for your review and comment. Please drop a PM if you’re interested. Best regards, Hoang

£10 GBP / час
(159 отзывов(-а))

Hello Sir, I am research and data entry expert, i can help you with this task, I can set column E to either INCLUDE or EXCLUDE based on the location found or not with 100% accuracy and very quickly, i am ready to start Больше

£5 GBP / час
(72 отзывов(-а))

I read the instructions and description thoroughly. Can you share the excel file, let me do few corrections first, I'll send you the sample, then you can tell me whether they are correct. I have done lot of similar wor Больше

£8 GBP / час
(31 отзывов(-а))

Hi dear, I have read your work instruction 3 times but some specification is not clear to me. So if you instruct me as my asking question about my some matter then we can start work. I will wait for your reply. Thanks Больше

£5 GBP / час
(14 отзывов(-а))

Hi There ! I'm interested in your project. I am detail oriented hard worker and honest. I assure that I will provide you Quality Work with 100% accuracy. My main goal is your satisfaction. If i get this chance to help Больше

£5 GBP / час
(38 отзывов(-а))

Hello! I’ve read your job description & I am very much interested in working on your project. I have a good experience of the works. I am the right candidates for this task. I am a quick, reliable and efficient worker Больше

£7 GBP / час
(34 отзывов(-а))

Hi, My name is Fedelito Recillo and I am a full-time freelancer. I see your job post and I am interested. I do believe that with my knowledge, skills and experience I can do the job better than the others. I am willi Больше

£9 GBP / час
(4 отзывов(-а))

Dear Sir/Ma, This project greatly interests me as this is one of my core areas of expertise as a freelancer. I promise I will do this to your maximum satisfaction and deliver quality work within an agreed timeframe. I Больше

£5 GBP / час
(33 отзывов(-а))

Hi Next Employer, I am interested in your project. I hold master degree in Business Administration (Finance). I am experienced data entry operator accountant and auditors having more than 9 years’ experience of data Больше

£5 GBP / час
(13 отзывов(-а))

Hello Please let me do this project. I can start immediately. I am very detail-oriented, hard-working, reliable and responsible. I have excellent experience in admin support, lead generation, web research, data entry.

£5 GBP / час
(3 отзывов(-а))

Hello, I am interested to work on this project. I am details oriented and have enough experience in data entry and web research. I will provide the best quality with 100% accuracy. Can you please share the files so tha Больше

£5 GBP / час
(4 отзывов(-а))

Hello, I have carefully read your project description and totally understand its requirements. I can assure you that I can get it completed within the stipulated time. I place your project as my outmost priority and Больше

£5 GBP / час
(7 отзывов(-а))

Hello there, I have got your job posting. I can assure you that I will be able to assist you in your task with quality work. Allow me to start [login to view URL] let me know further details. Waiting for your reply. Rele Больше

£5 GBP / час
(4 отзывов(-а))

Hi there I am interested in your project. I have completed projects like this. If you like to offer me the project please contact me. Thank you

£5 GBP / час
(5 отзывов(-а))

Dear Mr./Mrs., I believe I am a good fit to finish your project because I have experience working as an Internet Researcher and as a Data Entry Operative. I am tech savvy, attentive to details and hardworking, qualit Больше

£5 GBP / час
(2 отзывов(-а))

I am data entry and web research expert and willing to work with you. I believe that I am the right person you are looking for. I am pretty sure that if you make me a part of your valuable work your work will be done a Больше

£5 GBP / час
(0 отзывов(-а))