Sedang Disiapkan

python import from excel (CSV) to mysql

before you read :

this project looks like a piece of cake. BUT if you are not an experienced programmer don't apply as code will have to be pep 8 and in good quality

i need a python function that gets a CSV file and a configuration file

the program will add or change data in DB

the configuration file will have the following sections

1) target_db

2) type: insert only / check and update

3) fields -source, target (list of fields-not all)

4) key fields in CSV (that are in DB) so we know if a record exists or update

4) if update any field put the old record in the "updated" file

5) if inserted: put any record in the "inserted" file

6) if an error is put in the "errors" file



field names are not english may have ",", "'" and "," use encode (try encoding='windows-1255')

target fields name are English

make sure you have all the fields in CSV columns so we know if it is the right CSV

attache are 1 configuration 1 DB structure and 1 excel demo, upon success, you will be given a more complicated CSV

Kemahiran: Python, Excel, Pemprosesan Data, MySQL

Lihat lagi: import remote csv mysql, import excel file mysql using vbnet, import biggest csv mysql, import freeware csv mysql, import excel file mysql database php, import excel files mysql php, import number csv mysql, import excel file mysql export using php, import excel file mysql using java, asp net import excel csv, import excel file mysql php, php import excel file mysql smarty, php tutorial import excel file mysql, import excel csv jsp, import crm csv mysql, classic asp import excel csv, import excel csv file macro access, import excel csv file to mysql database using php

Tentang Majikan:
( 73 ulasan ) HAIFA, Israel

ID Projek: #31892067

Dianugerahkan kepada:


Hello, I know how to do your job, I actually once wrote an article about such a task: [login to view URL] What DB engine are you using? Don't hes Lagi

$150 USD dalam 7 hari
(26 Ulasan)

45 pekerja bebas membida secara purata $167 untuk pekerjaan ini

(533 Ulasan)
(266 Ulasan)

+++++++++++++++++++++++++++++++++++ Hello Jony, Hope you are doing well I have checked about your requirements and my skills are a match. I have relevant 5+ years of expertise in Python, Data Analysis, object detec Lagi

$200 USD dalam 7 hari
(38 Ulasan)

Hi. Hope you are doing well. I have high level expertise in Python. I have read the project requirements carefully and can create a Python script with all those 6 points covered. Will provide you top quality work for s Lagi

$180 USD dalam 2 hari
(90 Ulasan)
(54 Ulasan)
(85 Ulasan)

Hey! I am skilled Python developer. I am familiar with Python and I have a lot of work experiences in Python, Data Processing, MySQL and Excel. I can start right away. I want to discuss for this project in detail. Pl Lagi

$250 USD dalam 5 hari
(11 Ulasan)
(73 Ulasan)

Hi. How are you? As a senior web developer, I can make python script for updating csv data into mysql DB. I can start right now. I hope we can discuss more details via chat. Thanks.

$90 USD dalam 2 hari
(11 Ulasan)

Hi I have worked on several similar projects and can deliver quality work on tight deadlines. I'm interested to hear more about the project. If you award me the project I'd be very happy to discuss this further and get Lagi

$200 USD dalam 7 hari
(7 Ulasan)

Hello, i can create python function that gets a CSV file and a configuration file perfectly I have rich exp in ACM/ICPC and deep understandings of algorithms for Classifications, NLP, Neural Networks,e.t.c I attended Lagi

$50 USD dalam sehari
(29 Ulasan)
(17 Ulasan)

We will do your python work I am writing this proposal in order to work for you in Software and Web Development. We are highly trained professional developers seeking to freelance and earn online. Having a flair in pr Lagi

$200 USD dalam 7 hari
(21 Ulasan)

Hello, How are you? Thanks for your job posting. I will provide the high quality code based on PEP8. Let's discuss in more detail about the job. Regards.

$200 USD dalam 7 hari
(2 Ulasan)

Hi,i'm a data scientist with a BS degree in computer science i will do your task as fast as i can and i will achieve it exactly as you want,don't worry about any thing contact me for discussion

$100 USD dalam 7 hari
(16 Ulasan)

Hi there, I am a talented python dev, and I suppose I can handle this task successfully. Please let me know more details, and Please give me your chance. I look forward to hearing from you. Lagi

$139 USD dalam 7 hari
(3 Ulasan)
(4 Ulasan)

Hello? I have read your description. I can provide the great result that you are asking for as I have rich experience in python with excel and mysql. Could you please open your chat box for me? Let's get a great re Lagi

$155 USD dalam 3 hari
(5 Ulasan)

Hello. I am a python expert. I have read your requirements. This project is PIECE OF CAKE for me. I have already developed similar project but used sqlite for database. I will build interface for your project. I want t Lagi

$150 USD dalam 7 hari
(5 Ulasan)

Hello I have gone through your job description. I am a skilled and experienced in web and mobile development for over 8 years. Also very familiar with the database structure and queries. I am proficient with python sc Lagi

$200 USD dalam 7 hari
(4 Ulasan)