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 <kushagra94d...@gmail.com> 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 > >