Hi Kushagra,
A bit late on this but what is the business use case for this merge?
You have two data frames each with one column and you want to UNION them in
a certain way but the correlation is not known. In other words this UNION
is as is?
amount_6m | amount_9m
100 500
200 600
HTH
On Wed, 12 May 2021 at 13:51, kushagra deep <[email protected]>
wrote:
> Hi All,
>
> I have two dataframes
>
> df1
>
> amount_6m
> 100
> 200
> 300
> 400
> 500
>
> And a second data df2 below
>
> amount_9m
> 500
> 600
> 700
> 800
> 900
>
> The number of rows is same in both dataframes.
>
> Can I merge the two dataframes to achieve below df
>
> df3
>
> amount_6m | amount_9m
> 100 500
> 200 600
> 300 700
> 400 800
> 500 900
>
> Thanks in advance
>
> Reg,
> Kushagra Deep
>
>
