Advice on uploading to mySQL (output as *.csv created by R)

$10-30 USD

Đã hoàn thành

Đã đăng vào

gần 7 năm trước

$10-30 USD

Thanh toán khi bàn giao

My goal: regularily update my mySQL-db with csv-data created from R. Given situation: - I have a R-script that generates a *.csv output. - This output is used to update a master-csv. - The [login to view URL] is then uploaded into a truncated mySQL-db via phpMyAdmin. - the [login to view URL] contains an empty column for the db to fill in an auto-incremented id. - the [login to view URL] represents the current state of the db. Questions: - is csv the best format for transferring data between R and mySQL or is there a better one? - Which configurations do I have to apply in R to the csv-file (or better format) to preserve data integrity? - The reason I truncate the db beforehand is to re-create the auto-increment for the new output-data. Is there a better solution?

Database Administration

MySQL

R Programming Language

Mã dự án: 14455050

Về dự án

12 đề xuất

Dự án từ xa

Hoạt động 7 năm trước

Bạn muốn kiếm tiền?

Địa chỉ email

Lợi ích khi chào giá trên Freelancer

Thiết lập ngân sách và thời gian

Nhận thanh toán cho công việc

Phác thảo đề xuất của bạn

Miễn phí đăng ký và cháo giá cho công việc

Đã trao cho:

@chrisvwn

I can assist you to find the best upload method for your data based on size of data, network reliability, required upload speed, etc. There are options for direct upload from R into the DB. Relevant Skills and Experience I have just completed a script that scrapes data from PDF and uploads it into DB via various methods depending on the network reliability. Proposed Milestones $50 USD - On completion

$50 USD trong 1 ngày

4,9

(30 nhận xét)

6,5

12 freelancer chào giá trung bình $42 USD cho công việc này

@schoudhary1553

Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. Here is the reason. Why you should pick me? a) I am a very expert and have the same kind of experience of 5 years. b) I work very hard (16+ hours a day and 7 days a week) and also very fast so... it will be done very soon than most of the other providers c) And most important part is my policy: "I will give you (to my client) life time support (as long as you keep relation with me). And fix any bugs/problem without any cost. So, don't ever worry about me” Please sir, leave a reply ASAP, as I am waiting for your kind reply

$100 USD trong 1 ngày

4,9

(83 nhận xét)

6,8

@vinaysinghh

i am mysql dba having more then 10 yrs of exp Relevant Skills and Experience i am mysql dba having more then 10 yrs of exp Proposed Milestones $25 USD - d

$25 USD trong 1 ngày

4,6

(56 nhận xét)

5,4

@CodeRaiser

Hello Show me CSV file example so we can have more detailed talk Cheers Vlad Relevant Skills and Experience mysql/csv/ Proposed Milestones $25 USD - the job Additional Services Offered $30 USD - script to import data into csv

$25 USD trong 1 ngày

5,0

(29 nhận xét)

4,6

@achiever003

I have more than 7 years of experience in development and mysql as well. Relevant Skills and Experience I have worked on so many project till now so i have deep knowledge of mysql as well so i think i am able to complete your work more quickly with accuracy. Proposed Milestones $40 USD - Advice on uploading to mySQL Please let me know when we can start the project.

$40 USD trong 1 ngày

5,0

(1 nhận xét)

0,0

@juhiharshit

Hi, Let me answer one question The process you are following seems a bit long. You can use mysql Package in R and directly access Mysql on the server. Server connect using SSH. So an easy job for me. Relevant Skills and Experience Database administration, OLAP Cube, Unix, Cloud networking, I short all it takes to be a data engineer Proposed Milestones $20 USD - On partial 50 percent completing

$45 USD trong 2 ngày