Confirming accuracy of LW scraped location data

In Progress Posted 4 years ago Paid on delivery
In Progress

*Context*

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)

*Task*

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

Brewdog

- 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 :)

Burberry

- 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.

COOK

- 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 :(

Lush

- 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

Curzon

- 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.

Ikea

- 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 Data Entry Web Search

Project ID: #20324831

About the project

33 proposals Remote project Active 4 years ago

Awarded to:

sourabhg98

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 / hour
(114 Reviews)
5.6

33 freelancers are bidding on average £6/hour for this job

Innovative116

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 More

£10 GBP / hour
(394 Reviews)
8.4
Ibrahim185

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 / hour
(885 Reviews)
8.0
mirniyazuddin92

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 / hour
(422 Reviews)
8.0
Toperfection

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 More

£6 GBP / hour
(182 Reviews)
7.9
hdlong66

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 / hour
(159 Reviews)
6.9
mtanveer2012

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 More

£5 GBP / hour
(72 Reviews)
5.8
sputnikbound

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 More

£8 GBP / hour
(31 Reviews)
5.6
shahidul566

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 More

£5 GBP / hour
(14 Reviews)
5.1
nurmohammad21

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 More

£5 GBP / hour
(38 Reviews)
4.7
Rina247

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 More

£7 GBP / hour
(34 Reviews)
4.5
muritals

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 More

£5 GBP / hour
(33 Reviews)
4.5
zaahidali61

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 More

£5 GBP / hour
(13 Reviews)
4.0
frwebsolutions

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 More

£9 GBP / hour
(4 Reviews)
3.9
thuquylk

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 / hour
(3 Reviews)
2.3
jannat319

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 More

£5 GBP / hour
(4 Reviews)
2.1
chathu1993

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 / hour
(5 Reviews)
0.9
lucianhosliag

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 More

£5 GBP / hour
(2 Reviews)
0.6
techlinesols6

"Hi, Hope you are doing well! Thanks for sharing your project requirement with us. It will be our great pleasure to work on your project. I have checked your requirement, yes we can do it, because we already work on si More

£7 GBP / hour
(0 Reviews)
0.0
shamsshamimss

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 More

£5 GBP / hour
(0 Reviews)
0.0
sazid430

Hello There I am a professional of scraper data from the website I have great knowledge in this field. I am always ready to give my best effort for you. Trust and regular communication are the main weapons of my servi More

£5 GBP / hour
(0 Reviews)
0.0