Joining two DataFrames with same columns


#1

Hi there,

I would like to join two DataFrames that have the same column, let’s say:

DataFrameA:
country GDP
Germany 1

DataFrameB:
country GDP
USA 2

The resulting DataFrame should be:
country GDP
Germany 1
USA 2

But through join(DataFrameA,DataFrameB,on = :country, kind= :outer) I get:
country GDP GDP_1
Germany 1 NA
USA NA 2

Is it just another kind of join or a different command altogether?

Thanks a lot!


#2

I think you want vcat() to concatenate your DataFrames.