Eliminate duplicates from a dataset
$100-400 USD
Pagado a la entrega
We are creating a data set containing count of competitors within a 5 mile radius of the target business. For example: Business 1 - 20 competitors within 5 miles. We have approximately 900 locations that require a count of competitors within 5 miles. The data set has already been created. We have the target business and also list all of the competitors around that target business. However, because of the database we are using, the list of competitors around a business contains duplicates. So, the current count is inaccurate because of double counting of competitors. We need to have the duplicates around each target location eliminated so we can get an accurate count of competitors around target business locations. I would like this project completed by the end of the day thursday, Jan 14. The attached pivot table contains a subset of the data to give an example as to what the data set looks like. Columns J and L can be used to eliminate duplicates. For example, in the Raw Data sheet, if the ID in column J appears multiple times for the same target locations, duplicates can be eliminated so that competitor only appears once. However, because not all duplicates have the same ID assigned, column L needs to be reviewed. Column L contains addresses. If the same address appears multiple times, duplicates can be eliminated so the address only appears once. Note that sometimes the address is the same but is labeled differently. For example - 121 First Avenue is the same as 121 1st Avenue. That's why this needs to be done manually - because there are differences in address labels for locations that are duplicates.
The final output should be a pivot table listing all of the target locations along with a number of competitors. i would like a pivot table so the user can click the number to see the names/addresses of target locations if desired. The attached workbook contains three sample worksheets - raw data is an example of what the raw data set looks like. In the full data set, There are approximately 900 target locations and 20,000 potential competitor locations, including duplicates. the pivot table sheet is an example of what i'd like the final pivot table to look like - target business and number of competitors. john ridout competitors sheet shows an example of the data set that needs to be reviewed for each target location. For John Ridout, rows 13/14 are duplicates so one should be eliminated, rows 18/19 duplicates so one should be eliminated and rows 21/22 are duplicates so one should be eliminated. In some cases there could be more then one duplicate that needs to be eliminated. When eliminating duplicates, eliminate the dups that have TEMP in the ID in column J. If all the dups have TEMP, it doesn't matter which is eliminated.
Nº del proyecto: #9294360
Sobre el proyecto
80 freelancers están ofertando un promedio de $212 por este trabajo
Hi, I am good at Excel and attention to detail. Looking forward to work on this project. I would like to discuss it further.
Dear Employer, I clearly understand the project and can complete within a day. - First I would look into Comp_"FuneralHomeID" use duplicate remove option in excel then remove duplcate if any. - Second I loo Más
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
Hi: I am reviewing the file. Please allow me 15 mins to create an analytical plan. I will update the proposal after that. Thanks
Hello We have gone through this project and we are ready to work on this project and to start immediately we are expert in Data Entry & Admin Support, working with professional ethics We will Más
Dear Sir/Madam, I'm happy to help you on this task. I am an expert in advanced excel features and have already done lots of such excel based (Pivot) data analysis tasks for various clients and business. If you are comf Más
I have greatly admired your excel works, I can extract information from thoroughly go through with any documents. I am taking this opportunity to apply and be considered. Besides that, I have versatile experiences abo Más
Hi, I read your project and i am ready with my team to start now. please give me a chance to show our talent. we are working last 4 years under a owner now we just want to grow up ourselves. I think you will Give me Más
Hi sir, I am scraping expert, I have did too many similar projects, please provide me website list that i can give you exact time frame and sample. check my feedback then you will know. Can you tell me more details? Más
Hello I can get you the complete list de-duplicated within the next 24 hours, so that you will have enough time to cross check it before your deadline Thursday. Do let me know if you are interested. I am sure to Más
Dear Sir, I have read your project description. I m interested in this job. let me know one thing the criteria of duplicates? Thanks
Sir, I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences and will deliver flawless work. I am very much able to work on this. ***I am ready Más
Experienced programmer with more than 10 years of development experience here. I have handled production applications with various technologies like .NET, PHP, Classic ASP and many more using databases like MySQL, Micr Más
I have taken a look at your attachment and I just have a couple questions: 1) Are all of the competitors listed within one large sheet? 2) Are there duplicates between competitors that need to be removed? For example J Más
