Filter Dataset Equal
This transform allows you to filter the dataset based on the column value.
tags: [“EDA”]
Parameters
The table gives a brief description about each parameter in Filter Dataset equal 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 to be filtred based on the given column value.(Required: True, Multiple: False)
- Output Dataset:
The file name with which the output dataset is created after filtering the dataset based on the column value. (Required: True, Multiple: False)
- Column:
The name of the column to be filtered by a value. (Required: True, Multiple: False, Datatypes: [“STRING”], Options: [“FIELDS”], Datasets: [“df”])
- Value:
A particular column value with which the data in the column must be filtered (Required: True, Multiple: False, Datatypes: [“ANY”], Options: [“CONSTANT”], Datasets: [“df”])
Below is the screenshot with sample input data for this transform.
The output after running the Filter dataset equal transform on the dataset appears as below:
How to use it in Notebook
template=TemplateV2.get_template_by('Filter Dataset Equal')
recipe_Filter_Dataset_Equal= project.addRecipe([car_data, employee_data, temperature_data, only_numeric], name='Filter Dataset Equal')
transform=Transform()
transform.templateId = template.id
transform.name='Filter Dataset Equal'
transform.variables = {
'input_dataset':'car',
'output_dataset':'car_filtred',
'column':"doornumber",
'value':"two"}
recipe_Filter_Dataset_Equal.add_transform(transform)
recipe_Filter_Dataset_Equal.run()
Requirements
pandas