Merge datasets

This function will merge two datasets into one on basis of a common column, i.e. using the inner join operation.

tags: [“Data Preparation”]

Parameters

he table gives a brief description about each parameter in Back fill transform.

Name:

By default, the transform name is populated. You can also add a custom name for the transform.

Input Dataset:

The file name of the input dataset. You can select the dataset that was uploaded from the drop-down list. (Required: True, Multiple: False)

Input Second Dataset:

The other or second Dataset to merge with first or source dataset. (Required: True, Multiple: False)

Output Dataset:

The file name with which the output dataset is created after merging two datasets. (Required: True, Multiple: False)

The sample input for this transform looks as shown in the screenshot.

The output after running the Merge dataset transform on the dataset appears as below:

How to use it in Notebook

template=TemplateV2.get_template_by('Merge datasets')

recipe_Merge_datasets= project.addRecipe([car_data, employee_data, temperature_data, only_numeric], name='Merge datasets')

transform=Transform()
transform.templateId = template.id
transform.name='Merge datasets'
transform.variables = {
'input_dataset':'car',
'input_dataset':'car',
'output_dataset':'car_merge'}
recipe_Merge_datasets.add_transform(transform)
recipe_Merge_datasets.run()

Requirements

pandas