Remote Data Mining And Management Job In Data Science And Analytics

in R, Combined a few files by a single column

Find more Data Mining And Management remote jobs posted recently Worldwide

I need to have a solution that will allow me to combine about about 10 different Excel worksheets in different files in one worksheet by one column. I will provide an access to the folder where you can set it up.
I prefer to have it done in R, and I need to be able to have this solution on my machine that I can do it myself on regular basis.

Here is the example, please also note that there files have different Symbols, not all Symbols are the same or in the same order.

File 1
Column 1 Column 2 Column 3
Symbol A B

File 2
Column 1 Column 2 Column 3
Symbol Z B

Combined File

Column 1 Column 2 Column 3 Column 4
Symbol A Z B
About the recuiter
Member since Dec 5, 2016
Daniel M.
from Maharashtra, India

Skills & Expertise Required

Microsoft Excel R 

Candidate shortlisted and hiredHiring open till - Mar 30, 2020

Work from Anywhere

40 hrs / week

Fixed Type

Remote Job

$17.39

Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions

Similar Projects

Need to extract lawyers' email addresses from their websites

We need you to get law firms website addresses from various websites (rankings etc.) and then extract from these websites the lawyers email addresses, full names, positions, company name, LinkedIn & Facebook profile URLs (if available). We want to...read more

Clean up Email Database

Please view the link below. I want all three data bases cleaned up and organized into the individual tabs in the Master Worksheet. I have scanned in the original documents and already run them through an OCR program, but it needs more work.

read more

Sourcing Agent

Hi,
we are a native company which want to sell mask to protect people from the coronavirus. So were looking for a sourcing agent who can find us mask with a very great quality and a good price, join to it a packaging with our brand Hatake and...read more

QGIS - GIS analyses of smallholder farm polygons

I need someone to take me through the process of analysing smallholder farm polygons.
I have the data and need to independently be able to process it to identify and count irregularities such as invalid geometries, overlaps and duplicates.

Quant needed to test a long/short stock trading signal in Excel and then Python

The first deliverable is a bug-free spreadsheet that shows if the signal offers a good risk-adjusted return on annual data without even balancing the portfolio by sector or industry. If the annual model performs well, then test a monthly model. If...read more