The use case is to calculate PSI/CSI values . And yes the union is one to one row as you showed.
On Tue, May 18, 2021, 20:39 Mich Talebzadeh <mich.talebza...@gmail.com> wrote: > > 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 >> >>
