Merge csv with missing values and Unstructured Data set

Question

Hi I am unable to merge csv files which are unstructured. Below is my code:

file1 = read.csv("fileone.csv",header=TRUE,skip=0)
file2 = read.csv("filetwo.csv",header=TRUE,skip=0)

I have data sets something like this:

 Data:file1                                   Date:file2
 City     State                              City    State
Boston      MA                              Dallas     TX
Seattle     WA                              Lowell     MA
Miami       FL
Chicago     IL

I want result like this:

  MergedData
City      State
Boston      MA                              
Seattle     WA                              
Miami       FL
Chicago     IL
Dallas      TX
Lowell      MA

read this, it will help you: https://www.analyticsvidhya.com/blog/2016/06/9-challenges-data-merging-subsetting-r-python-beginner/ — CAppajigowda, Jul 04 '19 at 03:59

score 1 · Accepted Answer · answered Jul 04 '19 at 03:55

1

Try this:

mergedFile =merge(file1,file2,all=TRUE,sort=FALSE)

answered Jul 04 '19 at 03:55

CAppajigowda

458
2
9

It worked thank you! – CallMeCrazy Jul 04 '19 at 04:03

Merge csv with missing values and Unstructured Data set

1 Answers1