Find Jobs
Hire Freelancers

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

$10-30 USD

Completed
Posted almost 7 years ago

$10-30 USD

Paid on delivery
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?
Project ID: 14455050

About the project

13 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
4.7 (10 reviews)
5.0
5.0
13 freelancers are bidding on average $42 USD for this job
User Avatar
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 in 1 day
4.2 (51 reviews)
8.8
8.8
User Avatar
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 in 1 day
4.8 (25 reviews)
5.6
5.6
User Avatar
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 in 1 day
5.0 (23 reviews)
4.3
4.3
User Avatar
Hi, You can write data direct to MySQL databases from R. Of course if its accessible for external access. Also in R you can read ladt ID and generate set of next number. With best regards, Igor
$50 USD in 3 days
4.7 (3 reviews)
1.6
1.6
User Avatar
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 in 1 day
5.0 (1 review)
0.0
0.0
User Avatar
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 in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$40 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Zurich, Switzerland
5.0
6
Payment method verified
Member since May 21, 2017

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.