Data cleansing and categorization
- or -
Post a project like this2460
£100(approx. $125)
- Posted:
- Proposals: 16
- Remote
- #1646425
- Awarded
ASP.NET Core| MVC | C# | MongoDB | WebAPI | Jquery | Node.js| reactJs |SQL Server | Stripe
Delhi
PHP, Wordpress, Drupal, Magento, Data Entry, Administrative and Technical Support, SEO, Digital Marketing
Kingston
587975394936624653126714013102861371827138486414048051449473171738617378281753029
Description
Experience Level: Intermediate
General information for the business: Consumer Goods
Industry: Food and Beverage
Description of excel work: I have around 12,000 records of consumer products that need to be places in the appropriate categories. Categories are pre-defined but new ones can be created if needed. Categories runs 3 levels deep, with each parent category specifying corresponding child options. Example
Fruit & Vegetables -- Apples -- Red Apples
• I have attached an excel file with 3 tabs:
Lists – All the combinations of current category options, ordered by Leve1 / Level 2 / Level 3
• Ranges -- My attempt at creating an excel dropdown list with levels
• Allocate – 50 products with some samples and the ability to assign categories to each product.
I need quote to walk through all 12k and assign categories.
Once that is done, there are more that 250k products in the database that needs to be reviews and potentially fixed. The initial 12k will be a test run. I need a quote for the work.
Thanks
Extra notes: The data comes out of a SQL Server database. I am open to development that will allow reading from / writing to database directly appose to using excel.
Industry: Food and Beverage
Description of excel work: I have around 12,000 records of consumer products that need to be places in the appropriate categories. Categories are pre-defined but new ones can be created if needed. Categories runs 3 levels deep, with each parent category specifying corresponding child options. Example
Fruit & Vegetables -- Apples -- Red Apples
• I have attached an excel file with 3 tabs:
Lists – All the combinations of current category options, ordered by Leve1 / Level 2 / Level 3
• Ranges -- My attempt at creating an excel dropdown list with levels
• Allocate – 50 products with some samples and the ability to assign categories to each product.
I need quote to walk through all 12k and assign categories.
Once that is done, there are more that 250k products in the database that needs to be reviews and potentially fixed. The initial 12k will be a test run. I need a quote for the work.
Thanks
Extra notes: The data comes out of a SQL Server database. I am open to development that will allow reading from / writing to database directly appose to using excel.
Eduard E.
92% (13)Projects Completed
12
Freelancers worked with
12
Projects awarded
63%
Last project
9 Apr 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Eduard,
Allocating separate range names to each individual dropdown list in your project is not a reasonable way - you would have to create hundreds of them.
I can offer you a simple method of creating dynamical dropdown lists that would be automatically updated without a need of creating additional range names.
Please contact me if you are interested.
Kind regards
Kris
-
how we know which level 1 level 2 and level 3 have to assign to each item
-
Hi! Just wondered if there was a specific time frame in mind for the work to be completed?
464094463601463554
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies