tablesample.merge

In [ ]:
tablesample.merge(tbs: tablesample)

Merges the input tablesample to a target tablesample.

Parameters

Name Type Optional Description
tbs
tablesample
Tablesample to merge.

Returns

self : tablesample.

Example

In [1]:
from verticapy.utilities import tablesample

dataset = tablesample(values = {"index": ["region", "price", "quality"],
                                "Banana": ["Brazil", 2.3, 2],
                                "Manguo": ["Columbia", 6.7, 5],
                                "Apple": ["France", 1.5, 2]},).transpose()

dataset2 = tablesample(values = {"index": ["region2", "price2", "quality2"],
                                 "Banana": ["Portugal", 3.0, 3],
                                 "Manguo": ["Spain", 2.0, 3],
                                 "Apple": ["Germany", 4.0, 4]},).transpose()

display(dataset)
display(dataset2)
region
price
quality
BananaBrazil2.32
ManguoColumbia6.75
AppleFrance1.52
Rows: 1-3 | Columns: 4
region2
price2
quality2
BananaPortugal3.03
ManguoSpain2.03
AppleGermany4.04
Rows: 1-3 | Columns: 4
In [2]:
dataset.merge(dataset2)
Out[2]:
region
price
quality
region2
price2
quality2
BananaBrazil2.32Portugal3.03
ManguoColumbia6.75Spain2.03
AppleFrance1.52Germany4.04
Rows: 1-3 | Columns: 7