Find Jobs
Hire Freelancers

excel sheet data bifurcation

₹1500-12500 INR

Closed
Posted over 5 years ago

₹1500-12500 INR

Paid on delivery
I have a excel sheet of companies data. It has columns like Company Activity Word. Now I have such 4,12,718 rows but the data is repetitive. I wanted to extract only unique activity words out of them, For example: 1) AGRI AND DAIRY FARM 2) AGRI AND DAIRY FARMS 3) AGRI AND DAIRY PRODUCTS 4) AGRI AND DAIRY PRODUCTS INDIA For all of the above mentioned names we can assign only one name as AGRI AND DAIRY FARM or I will tell what to assign. Also it will be self explanatory to think about such common names. So the task is to extract Unique names from given sheet.
Project ID: 17400784

About the project

90 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
90 freelancers are bidding on average ₹5,214 INR for this job
User Avatar
Hi, i'm an expert in cleaning Excel data. To find unique Company Activity Words for you, this is what I propose: I review the list and come up with 10-20 "text cleaning rules" that you approve. Then I implement. For example, rules for cleaning the below could include these: Remove initial space, compare without inter-word spaces, hyphens, "&", "and", same first 2 words, plurals, brackets, other punctuations, upper and lower cases, etc. AGRIBIOTECH AGRI BIOTECH AGRI -BIOTECH AGRI & BIOTECH AGRI BIO-TECH AGRI-BIOTECH AGRI-BIO TECH AGRIBIO-TECH I propose 5 days so that there will be enough time to communicate and get feedback from you on the "cleaning rules" and refinement. I have a lot more "text, name, address cleaning rules" based on my long experience. Every set of data is different. I have an eye for the details and patterns. By the way, do you have 400k or 4 million rows of data? Please message me with any questions.
₹7,000 INR in 5 days
5.0 (26 reviews)
7.8
7.8
User Avatar
Hello, I am an experienced Data Analyst with advanced skills in Excel. I can give you quality work. Please check my portfolio in order to see my work. Just give me the opportunity to show you what i can do. Thanks!
₹6,666 INR in 3 days
4.9 (70 reviews)
6.9
6.9
User Avatar
Hi there, my name is Mark. I have 20+ years of MS Access, VBA, Excel experience and will be happy extract the unique values from your data. While I'm new to Freelancers, please review my profile and take advantage of my low bid. Thank you for considering me for your project.
₹1,500 INR in 1 day
5.0 (2 reviews)
6.2
6.2
User Avatar
I can write a formula or a macro to extract unique values from one or more columns I have excellent command on MS Excel. I have completed complex projects in Excel before. For instance - Create a schedule for delivery trucks pick-up and drop for optimal utilization of resources based on various constraints - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites. - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs. - Built a POS and inventory management system. - Built a hotel price comparison that pulls data using the website's API. You can see the reviews of the same in my profile. Thanks, Archana
₹2,500 INR in 1 day
4.8 (84 reviews)
5.9
5.9
User Avatar
Hello, I have checked the attached CSV file and to do this work with 100% accuracy we have to sort the data and check for all similar entries and determine which group should be put into one unique record. As you have more than 400K records so it will be a time taking job if some want to do it correctly. We are a company and we can do it by engaging multiple operators here if you price if relevant. Please contact us for more discussion. Thanks.
₹10,000 INR in 5 days
5.0 (62 reviews)
5.6
5.6
User Avatar
Hi, I have gone through your project details and can help you in getting unique data from huge set of duplicated data quickly and efficiently. Being experienced in working on several data filtration and such related tasks, I feel comfortable in taking up the task. Waiting for your response further to discuss in detail and start on it. thanks.
₹2,250 INR in 2 days
4.7 (89 reviews)
5.7
5.7
User Avatar
hi! let me help you with your project. I have read the details of your need and I am confident that I can deliver it. thanks
₹1,600 INR in 2 days
4.9 (66 reviews)
5.4
5.4
User Avatar
Hey In have read your project description. And I think I can do this work with simple Python code. In have done similar work using python. PS- Price is negotiable thanks.
₹1,500 INR in 2 days
5.0 (32 reviews)
4.8
4.8
User Avatar
Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Server databases. And also I have worked on extraction with websites like Amazon, Cellpex,Costco,etc., hope if awarded with this project I can make it best and better with maximum 100% accuracy and satisfaction. please award me this project and contact me for further details ...Thank you :)
₹5,555 INR in 3 days
5.0 (51 reviews)
4.7
4.7
User Avatar
Hi, I have seen your proposal. I am an excel expert with very good knowledge of VBA. I can write VBA programme for you that will pull specific data on the given conditions. Please come on chat for more details. Awaiting your response. Thank you.
₹1,500 INR in 2 days
4.4 (46 reviews)
4.8
4.8
User Avatar
Hi , We can do your work in just few hours as we are an expert in excel and are planning to develop a tool to parse your information and categorize them as per your need. We are new to freelancing so we are providing our service at the cheapest rate. Let me know in chat if we can work together. Regards, Piku
₹1,500 INR in 1 day
5.0 (1 review)
2.5
2.5
User Avatar
Hello, i'have already did a similar work like this one and i can assure that i will make yours too. Can you please tell me when i extract only the unique data where do you want me to store it ? csv as well ? So don't hesitate to contact me, i'am ready to work right now and i can make you a demonstration as well before awarding.
₹1,600 INR in 1 day
5.0 (2 reviews)
2.4
2.4
User Avatar
Hello, We are team of two person working in the field of Data analysis, Machine Learning ,data cleaning and data imputation Relevant Skills and Experience Excel R language Regular expression We will use Excel with R programming language to clean your data. Happy to work with you. Thank you
₹8,888 INR in 1 day
5.0 (1 review)
2.2
2.2
User Avatar
Hi, I was working as a business development executive in email marketing domain. I was very good in data mining because we have to generate our own data. If you could provide me the details I can send you the sample as well. Awaiting for your reply and looking forward to chat with you. Best Regards, Phani(nick).
₹11,111 INR in 20 days
5.0 (1 review)
1.7
1.7
User Avatar
I would like to take part in this project. My work strategy is to give regular status updates and intermediate version. I will give application where you can install in any window os and you can input the file and do this job anywhere and any time where it will get the input excel or csv file and then will give the required output like unique names and it will give suggestion and you can automatic click button based on suggestion and it will give unique names
₹2,400 INR in 2 days
5.0 (3 reviews)
1.4
1.4
User Avatar
Hi, I have an computer engineering degree and great skills with excel, I can do this job for job for you in just one day if want to work with me just message me.
₹1,750 INR in 1 day
5.0 (1 review)
0.2
0.2
User Avatar
Hello Client, I have read your requirement about - excel sheet data bifurcation and I am sure I can complete it as per the given description . I do have skills like Data Processing, Excel, Web Scraping which you are looking in your project. I Would like to discuss few things over the chat. So please do ping me.
₹1,895 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have 5 year experience with excel it will be done in maximum 4 hours. already know what is to done with such data. have worked with MNC as MIS
₹3,333 INR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Iam a Stat student. Data entry is all about speed, accuracy, and attention to detail. This is also my first project so i will give my 100% to do this project as soon as possible
₹5,555 INR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I would like to help you in finishing this activity ASAP Relevant Skills and Experience I have experience working as Data analyst so I can be helpful for you
₹7,777 INR in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of INDIA
India
0.0
0
Member since Jul 20, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.