Completed

Insert CSV into MySQL using Machine Learning to categorize the rows based off known dataset learning.

The candidate for the job must understand and use Machine Learning, it needs to use something like Azure or AWS to learn from the data.

Problem:

I have a construction / building materials company (hardware, tools, etc) and I need to keep an up to date database of the products we have for sale along with their prices and description. The products are sorted into categories. For instance product 'hammer' belongs in category 'tools' with the 'type' of hammer, a 'description' and the 'price' of the hammer.

There's multiple stores that send a CSV file each month with their hardware and the price they are selling it for. Sometimes its completely new items that need to be inserted, other times it's just a price that needs updating.

I need to be able to upload multiple .csv files and have the rows of data automatically (as best as possible) be sorted and stored in the MySQL database.

There's a base set of data which contains two tables, 'category' table and then 'items' table.

I would like the system to take the .csv files and apply some kind of machine learning rules to the data, compare it to our base set of data, it would then take the new .csv rows and insert them into the 'items' table and then it would tag each row with the associated 'category' that is the closest / best match (based off the learning from the base data set).

This is a small project with similar logic to what I'm after: [login to view URL]

The end goal is to have a simple interface where I can upload all the CSV files as they arrive and then the system will automatically update the main MySQL database by inserting new items (and tagging them to their predicted category) and update existing items by inserting their new price (compare the name of the item to existing items). I need an automated updating system so I don't have to manually check and update thousands of rows. The CSV columns do not always line up to the database columns, so the importer may need a step where the user maps the columns to the database - that is OK - if it can be ML guessed / predicted that would be even more of a bonus.

I have the skills to create the uploaders / importer / table mapping side of things in PHP, the main thing I need is the ML component.

I dont mind what language or service the main process for the ML / sorting procces is written in, so long as it can run on a digitalocean droplet and have a web interface for uploading the .csv files (super basic uploader), then store to MySQL, the rest is whatever you feel is best. ie: ML platform can be AWS or Azure, blah, whichever you think is best.

Bonus if this can be achieved using mostly PHP and JS as I have a better understanding of these languages.

Can provide creds to a DO droplet for dev work etc, will also provide data set for learning, example CSVs and MySQL structure etc to the awarded freelancer.

Skills: MySQL, Machine Learning (ML), PHP, Database Programming, Amazon Web Services

See more: converting csv mysql using php, import csv mysql using web form, perl script insert csv mysql, csv mysql using php, insert csv mysql, import csv mysql using asp, import csv mysql using php, edit delete insert data mysql using php, insert picture mysql using vbnet 2008, insert csv mysql database perl script, insert data mysql using php joomla, insert data mysql using ajax jquery, import csv mysql using codeigniter, insert data mysql using matlab, insert data mysql using ajax, insert data mysql using jquery, insert data mysql using ajax php, insert excel mysql using jsp, excel insert data mysql using jsp, multiple inline insert into mysql using ajax jquery in php

About the Employer:
( 10 reviews ) Caloundra West, Australia

Project ID: #28938012

Awarded to:

(7 Reviews)
5.3

18 freelancers are bidding on average $284 for this job

(1019 Reviews)
8.8
mahamadali

Hello I am experienced PHP + MySQL developer and I am keen to work for your project of web application to manage your items and with their categories with CSV importers with logic of checking if items exist then updat More

$200 AUD in 7 days
(564 Reviews)
7.8
(100 Reviews)
7.0
(43 Reviews)
6.5
Igorter

Hi, I read your description and understood your requirements. I see You want to classify the products and categories from CSV records and update the database from them. This job is Text Classification using Machine Lea More

$250 AUD in 5 days
(12 Reviews)
5.4
ShartraTech

Hi A per my understanding , you need to develop system with simple interface where you can upload all the CSV files , system will automatically update the main MySQL database by inserting new items and update existin More

$755 AUD in 20 days
(23 Reviews)
5.2
elregresodejosec

Hello. I can help you as well I'll provide you good result This is very easy job for me Please contact me Best regards Jose

$250 AUD in 7 days
(7 Reviews)
4.1
natalia080131

Hello sir. As a machine/deep learning expert, I'm glad to see your project. If you check my profile, you can see I have deep knowledge in machine/deep learning algorithms with machine/deep learning tools. I also hav More

$200 AUD in 7 days
(2 Reviews)
3.7
FutureNOWPK

Hello There are two ways to do it. Sanitize and sort data BEFORE inputting into DB. Use SQL smartly to put data. I guess it will be far much easier once i Know what OS are you using for the database server or if we More

$250 AUD in 8 days
(2 Reviews)
3.6
vadimdew777

Hello. How are you today? I have read your job post very carefully and i am sure that I can do your project perfectly. Fast speed and High quality is promise. I can use the PHP and MySQL to complete your project. I hav More

$100 AUD in 7 days
(4 Reviews)
3.8
alnabritenkova

Insert CSV into MySQL using Machine Learning to categorize the rows based off known dataset learning. Hi, I am expert in Python. I have 5 years experience in scraping, machine learning/DL/AL, automation, image processi More

$100 AUD in 1 day
(5 Reviews)
3.5
sajjadtaghvaeifr

Hi, I hope you are doing fine. I have almost 10 years of experience in machine learning algorithms. I can implement various types of artificial intelligence algorithms including yours with Matlab, Python and etc. I hav More

$140 AUD in 7 days
(3 Reviews)
3.0
afzalfarooque

Hi, I can predict the category of items and put the items into respective table from csv file. I have good grasp in Machine Learning Algorithms and their implementation. Looking forward to start the work. I know Pytho More

$150 AUD in 7 days
(4 Reviews)
3.0
globalseo614

Hello, I can help you to Insert CSV into MySQL using Machine Learning to categorize the rows based off known dataset learning. I have gone through your job posting and become very much interested to work with you. I More

$250 AUD in 5 days
(3 Reviews)
2.3
marysindri2020

====== Python Machine Learning Expert ======= I have read your description carefully. I have 8+ years of rich experience in Machine Learning using Python Numpy, Tensorflow. I 'll provide good result in short time. Dear More

$200 AUD in 2 days
(3 Reviews)
2.2
Tonyspychenko

Hi, Thanks for your job posting. I have read your job description and checked the URL you attached. I have good experience in machine learning, AWS, Azure server. I am expert in python and web with 4 years experience. More

$200 AUD in 5 days
(1 Review)
1.5
serzhaksinenko01

Hi Jake, I just read your job posting and it sounds like you need an expert in PHP & CSV & Mysql. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I will More

$70 AUD in 3 days
(1 Review)
1.0