dfDemo = session.table("DEMOGRAPHICS") dfServ = session.table("SERVICES") dfJoin = dfDemo.join(dfServ,dfDemo.col("CUSTOMERID") == dfServ.col("CUSTOMERID") ).select(dfDemo.CUSTOMERID.alias('CUSTOMERID'), '*') dfJoin.sample(n=50).to_pandas()
CUSTOMERIDobject
2844-FdB772%
2815-9uDvF2%
48 others96%
l_fqox_CUSTOMERIDobject
2844-FdB772%
2815-9uDvF2%
48 others96%

0

2844-FdB77

2844-FdB77

1

2815-9uDvF

2815-9uDvF

2

9682-Rgdiz

9682-Rgdiz

3

1415-AWNUn

1415-AWNUn

4

5379-aGGsf

5379-aGGsf

5

6808-vN1Za

6808-vN1Za

6

2060-S46z2

2060-S46z2

7

1691-36wdv

1691-36wdv

8

2792-j2a4Y

2792-j2a4Y

9

5586-Njvbm

5586-Njvbm

Hosted onDeepnote