Find Jobs
Hire Freelancers

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

$30-250 AUD

Concluído
Publicado há aproximadamente 3 anos

$30-250 AUD

Pago na entrega
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.
ID do Projeto: 28938012

Sobre o projeto

16 propostas
Projeto remoto
Ativo há 3 anos

Quer ganhar algum dinheiro?

Benefícios de ofertar no Freelancer

Defina seu orçamento e seu prazo
Seja pago pelo seu trabalho
Descreva sua proposta
É grátis para se inscrever e fazer ofertas em trabalhos
Concedido a:
Avatar do Usuário
$0 AUD em 5 dias
4,9 (8 avaliações)
5,6
5,6
16 freelancers estão ofertando em média $307 AUD for esse trabalho
Avatar do Usuário
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 update and if not then insert. We can do it totally with PHP and HTML + JS for web interface and logical part as well. So please let me know if you are interested in my profile so we can discuss more. Thanks
$200 AUD em 7 dias
5,0 (573 avaliações)
7,9
7,9
Avatar do Usuário
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 existing items by inserting their new price . What I deliver 1. import csv fil hardware product listing in mysql DB 2. DB structure with ML implementation & able to create the uploaders / importer / table mapping side of things > Automatically (as best as possible) be sorted and stored in the MySQL database. 3. Support multi-store multi- CSV file 4. DO droplet server for dev work . I am agree with it. PLease note that- I am familira with AWS or Azure serve , no worry about servr host. I will hot on cloud server. Technology would be PHP , JS & MYSQL , Might be Magento or laravel for it. Kindly connect with further discussion.
$755 AUD em 20 dias
5,0 (47 avaliações)
6,0
6,0
Avatar do Usuário
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 Learning(maybe need to use Deep Learning) and I have rich experiences with NLP(Text Classification, Clustering, Summarization, Seniment Analysis, etc.) Best Option to build the app able to upload CSV and prediction is Flask or Django in python because Machine Learning and Deep Learning is base on python language. Of course, if you want PHP, we can call python script externally in PHP Web site. Coluld you share the CSV files with me so that I can understand more details ? Cheers. Vadim N.
$250 AUD em 5 dias
5,0 (13 avaliações)
5,5
5,5
Avatar do Usuário
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 em 7 dias
4,9 (12 avaliações)
4,6
4,6
Avatar do Usuário
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 have finished many projects so far. If you give me your project, I can help you well with your project. Please contact me. I'm ready for your project and can start soon. I will wait for you with your good news. Regards
$200 AUD em 7 dias
4,5 (4 avaliações)
4,7
4,7
Avatar do Usuário
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 could set up a script that will run selected query based on the smart CLi based tools. Let me know if I can assist you with this. Regards umer
$250 AUD em 8 dias
5,0 (3 avaliações)
3,7
3,7
Avatar do Usuário
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 have PhD from Tohoku University and have several journal publications on the subjects. You can see portfolio for my previous projects. I read about your project and am interested in working with you. Please send me a message so that we can discuss more. Best regards.
$140 AUD em 7 dias
5,0 (4 avaliações)
3,6
3,6
Avatar do Usuário
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 Python, Sk-Learn, Pandas, MySQL.
$150 AUD em 7 dias
5,0 (5 avaliações)
3,0
3,0
Avatar do Usuário
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 provide you 100% completed project and maintenance after this without extra payment. I'd be happy to discuss this further and get started for you as soon as possible. Best regards, Sergey.
$70 AUD em 3 dias
5,0 (3 avaliações)
2,0
2,0
Avatar do Usuário
====== 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 regards.
$200 AUD em 2 dias
5,0 (3 avaliações)
2,2
2,2
Avatar do Usuário
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. Please contact me. Thanks. Anton P.
$200 AUD em 5 dias
5,0 (1 avaliação)
1,5
1,5

Sobre o cliente

Bandeira do(a) AUSTRALIA
Caloundra West, Australia
5,0
10
Método de pagamento verificado
Membro desde mar. 28, 2011

Verificação do Cliente

Obrigado! Te enviamos um link por e-mail para que você possa reivindicar seu crédito gratuito.
Algo deu errado ao enviar seu e-mail. Por favor, tente novamente.
Usuários Registrados Total de Trabalhos Publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Carregando pré-visualização
Permissão concedida para Geolocalização.
Sua sessão expirou e você foi desconectado. Por favor, faça login novamente.