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.


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.

Kemahiran: MySQL, Machine Learning (ML), PHP, Pengaturcaraan Pangkalan Data, Amazon Web Services

Lihat lagi: 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

Tentang Majikan:
( 10 ulasan ) Caloundra West, Australia

ID Projek: #28938012

Dianugerahkan kepada:

(6 Ulasan)

19 pekerja bebas membida secara purata $274 untuk pekerjaan ini

(1017 Ulasan)

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 Lagi

$200 AUD dalam 7 hari
(559 Ulasan)
(98 Ulasan)
(43 Ulasan)

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 Lagi

$250 AUD dalam 5 hari
(12 Ulasan)

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 Lagi

$755 AUD dalam 20 hari
(20 Ulasan)

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 dalam 7 hari
(7 Ulasan)

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 Lagi

$100 AUD dalam 7 hari
(4 Ulasan)

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 Lagi

$250 AUD dalam 8 hari
(2 Ulasan)

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 Lagi

$100 AUD dalam sehari
(5 Ulasan)

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 Lagi

$200 AUD dalam 7 hari
(2 Ulasan)

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 Lagi

$150 AUD dalam 7 hari
(2 Ulasan)

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 Lagi

$250 AUD dalam 5 hari
(3 Ulasan)

====== 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 Lagi

$200 AUD dalam 2 hari
(3 Ulasan)

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 Lagi

$140 AUD dalam 7 hari
(2 Ulasan)

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

$200 AUD dalam 5 hari
(1 Ulasan)

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 Lagi

$70 AUD dalam 3 hari
(1 Ulasan)

Hi. How are you? I am very familiar with the Python. I have 5+ years experienced in machine learning such as support vector machine learning, artificial intelligence. I think your project can be done perfectly by me. I Lagi

$100 AUD dalam 2 hari
(0 Ulasan)