Đang Thực Hiện

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

Kĩ năng: Python, Excel, Xử lí dữ liệu, MySQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 73 nhận xét ) HAIFA, Israel

ID dự án: #31892067

Được trao cho:


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 Thêm

$150 USD trong 7 ngày
(26 Đánh Giá)

45 freelancer chào giá trung bình$167 cho công việc này

(533 Nhận xét)
(266 Nhận xét)

+++++++++++++++++++++++++++++++++++ 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 Thêm

$200 USD trong 7 ngày
(38 Nhận xét)

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 Thêm

$180 USD trong 2 ngày
(90 Nhận xét)
(54 Nhận xét)
(85 Nhận xét)

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 Thêm

$250 USD trong 5 ngày
(11 Nhận xét)
(73 Nhận xét)

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 trong 2 ngày
(11 Nhận xét)

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 Thêm

$200 USD trong 7 ngày
(7 Nhận xét)

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 Thêm

$50 USD trong 1 ngày
(29 Nhận xét)
(17 Nhận xét)

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 Thêm

$200 USD trong 7 ngày
(21 Nhận xét)

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 trong 7 ngày
(2 Nhận xét)

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 trong 7 ngày
(16 Nhận xét)

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. Thêm

$139 USD trong 7 ngày
(3 Nhận xét)
(4 Nhận xét)

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 Thêm

$155 USD trong 3 ngày
(5 Nhận xét)

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 Thêm

$150 USD trong 7 ngày
(5 Nhận xét)

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 Thêm

$200 USD trong 7 ngày
(4 Nhận xét)