*DATASET_ADD_STATIC_COLUMN

Description: Combine datasets based on primary keys

Syntax: dataset_add_static_column(dataset1,col_name,column_value)

Inputs
ID Name Type Default Remarks
1 Dataset1 dataset   Dataset1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Col Name scalar    
3 Column Value scalar    
Outputs
ID Name Type Remarks
1 dataset_add_static_column_output_1 dataset  

*DATASET_SUBTRACT

Description: Subtract two datasets and return the difference

Syntax: dataset_subtract(dataset_1,dataset_2,diff_type,vector_diff_type,mapper_input,columns,add_diff_as_new_column)

Inputs
ID Name Type Default Remarks
1 Dataset 1 dataset   Dataset 1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Dataset 2 dataset   Dataset 2 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Type Of Difference for Scalars select    
4 Type Of Difference for Vectors select    
5 Choose Mapper mapper   Mapping definition
6 Choose Columns to Subtract textarea   Columns to Subract
7 Add Difference as New Column select    
Outputs
ID Name Type Remarks
1 dataset_subtract_output_1 dataset  

*DATASET_JOIN

Description: Join datasets based on primary keys

Syntax: dataset_join(dataset1,dataset2,join_type,primarykeys,datset1_columns_to_include,datset2_columns_to_include,prefixfordataset1columns,prefixfordataset2columns)

Inputs
ID Name Type Default Remarks
1 Dataset1 dataset   Dataset1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Dataset2 dataset   Dataset2 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Join Type select    
4 Primary Keys scalar    
5 Datset1 Columns To Include textarea   Dataset1 columns to include
6 Datset2 Columns To Include textarea   Dataset2 columns to include
7 Dataset1 Column Prefix scalar    
8 D2CP scalar   Dataset 2 Column prefix
Outputs
ID Name Type Remarks
1 dataset_join_output_1 dataset  

*DATASET_COMBINE_COLUMN

Description: Combine datasets based on primary keys

Syntax: dataset_combine_column(dataset1,dataset2,primarykeys,columntocombine)

Inputs
ID Name Type Default Remarks
1 Dataset1 dataset   Dataset1 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Dataset2 dataset   Dataset2 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Primary Keys scalar    
4 Column To Combine scalar    
Outputs
ID Name Type Remarks
1 dataset_combine_column_output_1 dataset  

*DATASET_GET_MIN_SAMPLE_SIZE

Description: Compute minimum sample size

Syntax: dataset_get_min_sample_size(dataset_1,columns,confidence,margin_error,z_score_type)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns scalar   Columns whose norm is to be completed
3 Confidence select   Confidence level
4 Margin Of Error select   Confidence level
5 Z Score Type select   Type of z_score
Outputs
ID Name Type Remarks
1 dataset_sample_size_output_1 dataset  

*DATASET_WRITE_TO_FILE

Description: Write dataset to file

Syntax: dataset_write_to_file(responsetoextractfrom,file_name)

Inputs
ID Name Type Default Remarks
1 Response To Extract From dataset   Dataset to be written into file <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 File Name scalar   File name the written dataset will be saved as
Outputs
ID Name Type Remarks
1 dataset_write_to_file_output_1 dataset  

*DATASET_GET_NORM

Description: Compute the norm of a dataset

Syntax: dataset_get_norm(dataset_1,norm_type)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset whose norm is to be completed <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Norm Type select   Type of norm
Outputs
ID Name Type Remarks
1 dataset_norm_output_1 scalar  

*DATASET_NORMALIZE

Description: Normalize columns in the dataset

Syntax: dataset_normalize(dataset_1,columns,normalization_type)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset whose norm is to be completed <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns scalar   Columns whose norm is to be completed
3 Normalization Type select   Type of normalization. Default standard is more robust
Outputs
ID Name Type Remarks
1 dataset_normalization_output_1 dataset  

*DATASET_COMBINE_SCALARS

Description: Combine scalars

Syntax: dataset_combine_scalars(headers,header_delimiter,row_delimiter,responsetoextractfrom)

Inputs
ID Name Type Default Remarks
1 Headers scalar    
2 Header Delimiter select    
3 Row Delimiter select    
4 Response To Extract From scalar   Response to extract from
Outputs
ID Name Type Remarks
1 dataset_combine_scalars_output_1 dataset  

*DATASET_ADD_COLUMN_BY_EXPRESSION

Description: Add column by expression

Syntax: dataset_add_column_by_expression(dataset,new_columnname,expression)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 New Column name textarea    
3 Expression textarea    
Outputs
ID Name Type Remarks
1 dataset_add_column_by_expression_output_1 dataset  

*DATASET_GET_GROUPED_SUMMARY

Description: Get dataset summary

Syntax: dataset_get_grouped_summary(dataset,group_by,columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Group By scalar   Group by these columns
3 Choose Columns scalar   Restrict the schema generation to these columns
Outputs
ID Name Type Remarks
1 dataset_get_summary_output_1 dataset  

*DATASET_GET_CURVES_FROM_COLUMN

Description: Get curves from a column

Syntax: dataset_get_curves_from_column(dataset_1,curve_columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Curve Column scalar   Column that contains the curves
Outputs
ID Name Type Remarks
1 dataset_get_curves_from_column_output_1 vector  

*DATASET_GET_NUMERIC_COLUMN_STATS

Description: Get Stats for numeric columns

Syntax: dataset_get_numeric_column_stats(dataset_1,numeric_columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Numeric Columns scalar   Column that contains the curves
Outputs
ID Name Type Remarks
1 dataset_stats_1 dataset  

*DATASET_GET_SUMMARY

Description: Get dataset summary

Syntax: dataset_get_summary(dataset,columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Columns scalar   Restrict the schema generation to these columns
Outputs
ID Name Type Remarks
1 dataset_get_summary_output_1 dataset  

*DATASET_GET_SCHEMA

Description: Get schema for the columns

Syntax: dataset_get_schema(dataset,columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Columns scalar   Restrict the schema generation to these columns
Outputs
ID Name Type Remarks
1 dataset_get_schema_output_1 dataset  

*DATASET_UNIFY_KEYS

Description: Unify columns in the dataset

Syntax: dataset_unify_keys(dataset,null_replacement_type)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Null Replacement Type select    
Outputs
ID Name Type Remarks
1 dataset_add_column_by_expression_output_1 dataset  

*DATASET_ADD_ROW

Description: Dataset Add Row

Syntax: dataset_add_row(dataset,records,position)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 records dataset    
3 Position select    
Outputs
ID Name Type Remarks
1 dataset_add_row_output_1 dataset  

*DATASET_COMPUTE_STAR_RATING

Description: Compute the Occupant injury star-rating based on the dataset with values for HICd and Peak value sof Chest, Femur and Neck values

Syntax: dataset_compute_star_rating(dataset,new_colname,hi_cd,peak_chest_deflectioninmm,peak_femur_loadink_n,peak_neck_ni_jink_n,peak_neck_tensionink_n,peak_neck_compressionink_n,occupant_type,unit_system)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset with Occupant Injury values <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 New Column Name textarea    
3 HICd scalar    
4 Peak Chest Deflection in mm scalar    
5 Peak Femur Load in kN scalar    
6 Peak Neck NIJ in kN scalar    
7 Peak Neck Tension in kN scalar    
8 Peak Neck Compression in kN scalar    
9 Occupant Type select    
10 Unit System select    
Outputs
ID Name Type Remarks
1 dataset_compute_star_rating_output_1 dataset  

*DATASET_RENAME_CURVES_IN_COLUMN

Description: Dataset Rename Curves In Column

Syntax: dataset_rename_curves_in_column(dataset_1,curve_col,name_by)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Curve Column textarea   Curve Column whose names are to be changed. All curves will have the names specified by the columns below
3 Name By textarea   Values of this column will be used for naming the curve
Outputs
ID Name Type Remarks
1 dataset_rename_columns_output_1 dataset  

*DATASET_TO_KEYVALUE

Description: Dataset To Keyvalue

Syntax: dataset_to_keyvalue(dataset_1)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be converted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_to_keyvalue_output_1 keyvalue  

*DATASET_GET_PROGRESSIVE_CRUSH_FACTOR

Description: Dataset Get Progressive Crush Factor

Syntax: dataset_get_progressive_crush_factor(dataset_1)

Inputs
ID Name Type Default Remarks
1 Crush Dataset dataset   Dataset from *CURVES_GET_CRASHWORTHINESS that contains the crush information <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_get_progressive_crush_factor_output_1 scalar  

*DATASET_ADD_CURVES_TO_COLUMN

Description: Add curves to a column

Syntax: dataset_add_curves_to_column(dataset_1,new_column_name,curves)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar   New column name
3 Curves vector   Curves to be added <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#curveinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_add_curves_to_column_output_1 dataset  

*DATASET_DATASET_TO_COLUMNS

Description: Use Dataset Values to Add New Columns

Syntax: dataset_dataset_to_columns(dataset_1,column_name,sub_columns,prefix,drop_columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Dataset Column Name scalar   Column that contains the dataset
3 Limit to these columns in the Dataset textarea   By default all columns of the dataset is chosen
4 Prefix textarea   Curves to be added <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#curveinput’> <i class=’fa fa-external-link’> </i> View more </a>
5 Drop dataset column select    
Outputs
ID Name Type Remarks
1 dataset_add_curves_to_column_output_1 dataset  

*DATASET_GET_CELL_VALUE_VECTOR

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_vector(datasetname,row_index,col_index)

Inputs
ID Name Type Default Remarks
1 Dataset Name dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Row Index scalar   First row starts at 0
3 Col Index scalar   First column starts at 0
Outputs
ID Name Type Remarks
1 dataset_get_cell_value_output_1 vector  

*DATASET_GET_CELL_VALUE_KEYVALUE

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_keyvalue(datasetname,row_index,col_index)

Inputs
ID Name Type Default Remarks
1 Dataset Name dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Row Index scalar   First row starts at 0
3 Col Index scalar   First column starts at 0
Outputs
ID Name Type Remarks
1 dataset_get_cell_value_output_1 keyvalue  

*DATASET_GET_CELL_VALUE_DATASET

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_dataset(datasetname,row_index,col_index)

Inputs
ID Name Type Default Remarks
1 Dataset Name dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Row Index scalar   First row starts at 0
3 Col Index scalar   First column starts at 0
Outputs
ID Name Type Remarks
1 dataset_get_cell_value_dataset_output_1 dataset  

*DATASET_GET_CELL_VALUE

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value(datasetname,row_index,col_index,missing_value)

Inputs
ID Name Type Default Remarks
1 Dataset Name dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Row Index scalar   First row starts at 0
3 Col Index scalar   First column starts at 0
4 Missing Value scalar   If the dataset does not have the row or column number
Outputs
ID Name Type Remarks
1 dataset_get_cell_value_output_1 scalar  

*DATASET_CREATE_FROM_KEYVALUES

Description: Create dataset based on the key values provided

Syntax: dataset_create_from_keyvalues(keyvalue)

Inputs
ID Name Type Default Remarks
1 Key Value Input keyvalue   Keyvalue to be used for combining <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_create_from_keyvalues_output_1 dataset  

*DATASET_COLUMNS_TO_DATASET

Description: Use Column Values to Add New Dataset Column

Syntax: dataset_columns_to_dataset(dataset_1,new_column_name,prefix,drop_columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 New Column Name scalar   New Column Name
3 Prefix textarea   Curves to be added <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#curveinput’> <i class=’fa fa-external-link’> </i> View more </a>
4 Drop dataset column select    
Outputs
ID Name Type Remarks
1 dataset_add_curves_to_column_output_1 dataset  

*DATASET_UNIQUE

Description: Checks dataset for unique column name

Syntax: dataset_unique(datasetname,column_name)

Inputs
ID Name Type Default Remarks
1 Dataset Name dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar   Column name of the dataset to be checked
Outputs
ID Name Type Remarks
1 dataset_unique_output_1 set  

*DATASET_GET_CELL_VALUE_IMAGE

Description: Get the cell value from given dataset

Syntax: dataset_get_cell_value_image(datasetname,row_index,col_index)

Inputs
ID Name Type Default Remarks
1 Dataset Name dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Row Index scalar   First row starts at 0
3 Col Index scalar   First column starts at 0
Outputs
ID Name Type Remarks
1 dataset_get_cell_value_output_1 image  

*DATASET_SET_CELL_VALUE

Description: Set the cell value from given dataset

Syntax: dataset_set_cell_value(datasetname,row_index,col_index,new_value)

Inputs
ID Name Type Default Remarks
1 Dataset Name dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Row Index scalar   First row starts at 0
3 Col Index scalar   First column starts a 0
4 New Value scalar    
Outputs
ID Name Type Remarks
1 dataset_get_cell_value_output_1 dataset  

*DATASET_JOIN_ROW

Description: Join a row to all rows of the destination dataset

Syntax: dataset_join_row(source_dataset,dest_dataset,source_column,source_row_index)

Inputs
ID Name Type Default Remarks
1 Source dataset   Source dataset from which the row will be joined to the destination. If the source contains more than 1 row, the first row will be chosen <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Destination Dataset dataset   All rows will have the same values as the first row in the source_dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Source Columns scalar   Columns to add from source dataset
4 Source Dataset Index scalar   Specify the row index if a particular row from the destination is to be joined. The default is first.
Outputs
ID Name Type Remarks
1 dataset_join_row_output_1 dataset  

*DATASET_RANDOM_SAMPLER

Description: Creates a random dataset

Syntax: dataset_random_sampler(source_dataset,num_samples,reset_index)

Inputs
ID Name Type Default Remarks
1 Source dataset   Source dataset from which the random sampling is to be taken <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Number Of Samples scalar   Number of samples to create
3 Reset Index select   Resets the indexes of rows in case they need to be treated as a new dataset
Outputs
ID Name Type Remarks
1 dataset_random_sampler_output_1 dataset  

*DATASET_COMPUTE_PARETO_FRONT_SORTER

Description: Compute sorted pareto front from provided dataset

Syntax: dataset_compute_pareto_front_sorter(dataset1,columns,criteria,constraints,targets,limit)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   This is the dataset containing records to find the optimal records. <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Columns scalar   These columns specified will be used to find the optimum
3 Objective scalar   For multiple columns, the criteria can be specified as a list separated by a commas as min,max with one objective per column
4 Constraints dataset   Constraints that includes needle, condition, and target column to use. Example: needle=var1, condition=gt, target=2.0 will allow var1 to be always greater than 2.0 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
5 Targets textarea   Targets values for selected columns can be specified in the case of parameter identification. Multiple targets can be specified as target1:20,target2:30…
6 Limit scalar   Number of optimum records to return. The default is 1
Outputs
ID Name Type Remarks
1 dataset_compute_pareto_front_sorter_output_1 dataset  

*DATASET_COMPUTE_PARETO_FRONT_OPTIMAL

Description: Compute pareto front optimal from provided dataset

Syntax: dataset_compute_pareto_front_optimal(pareto_dataset,columns,criteria,constraints,targets)

Inputs
ID Name Type Default Remarks
1 Pareto Dataset dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns scalar   CSV values are supported
3 Criteria scalar   Min or Max. Must be equal to the number of cols specified above
4 Constraints dataset   Constaints to limit the design <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
5 Targets textarea   Multiple targets can be specified as target1:20,target2:30…
Outputs
ID Name Type Remarks
1 dataset_compute_pareto_front_optimal_output_1 dataset  

*DATASET_UNIQUENUM

Description: Compute the unique number of occurences in values

Syntax: dataset_uniquenum(response,column_name)

Inputs
ID Name Type Default Remarks
1 Response keyvalue   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar   Column name of the dataset to be checked
Outputs
ID Name Type Remarks
1 dataset_uniquenum_output_1 scalar  

*DATASET_CROSSPLOTCOLUMNS

Description: Crossplot two columns from a dataset

Syntax: dataset_crossplotcolumns(src_dataset,x-column,y-column,sort_x_values)

Inputs
ID Name Type Default Remarks
1 Src Dataset dataset   Provide Dataset here <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 X-Column scalar   Column name as x values
3 Y-Column scalar   Column name as y values
4 Sort X Values select    
Outputs
ID Name Type Remarks
1 dataset_crossplotcolumns_output_1 vector  

*DATASET_COMPUTE_DERIVATIVES

Description: Dataset Compute Derivatives

Syntax: dataset_compute_derivatives(dataset_1,inputs,targets,build_ffd,value_type,normalize)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Inputs scalar    
3 Targets scalar    
4 Build FFD If Not One select   Learn from the dataset and build a FFD dataset
5 Value Type select   Value of derivative to report from neibhoring points. Default uses the average values of derivatives from all neibhoring points
6 Normalize The Data select   Normalize the data prior to computing the derivatives
Outputs
ID Name Type Remarks
1 dataset_compute_derivatives_output_1 dataset  

*DATASET_GET_CONTEXT

Description: Dataset Get Context

Syntax: dataset_get_context(dataset_1,context_text)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Context Template textarea    
Outputs
ID Name Type Remarks
1 Context textarea  

*DATASET_REMOVE_UNIQUE_COLUMNS

Description: Dataset Remove Unique Columns

Syntax: dataset_remove_unique_columns(dataset_1,uniqueness_ratio)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Uniqueness Ratio scalar    
Outputs
ID Name Type Remarks
1 dataset_remove_unique_columns_output_1 dataset  

*DATASET_ADD_COLUMN_BY_REGEXP

Description: Dataset Add Column By Regexp

Syntax: dataset_add_column_by_regexp(dataset,new_column_name,column_name,regexp,index)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 New Column Name scalar    
3 Column For Regex scalar    
4 Regular Expression scalar   Ex: (d+)_mm will collect all digits appearing in front of _mm
5 Choose Index scalar   By default it chooses the first occuring pattern
Outputs
ID Name Type Remarks
1 dataset_add_column_by_regexp_output_1 dataset  

*DATASET_QUERY

Description: Dataset Query

Syntax: dataset_query(dataset,query,remove_non_alphanumeric)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Query textarea   You can use column names and C-style syntax as COL1 >= VALUE
3 Remove Non-Alphanumeric select    
Outputs
ID Name Type Remarks
1 dataset_query_output_1 dataset  

*DATASET_TRIM_COLUMN_NAMES_AND_VALUES

Description: Dataset Trim Column Names And Values

Syntax: dataset_trim_column_names_and_values(dataset_1)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_trim_column_names_and_values_output_1 dataset  

*DATASET_ENCODER

Description: Dataset Encoder

Syntax: dataset_encoder(dataset_1,encoder_type,columns,mapper_input)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Encoder Type select    
3 Columns To Encode scalar    
4 Specify Encoding encoder   Encoding Information for each columns
Outputs
ID Name Type Remarks
1 dataset_encoder_output_1 dataset  

*DATASET_REPLACE_COLUMN_NAMES

Description: Search and replace column names

Syntax: dataset_replace_column_names(dataset,search,replace)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be replace column names <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Search scalar   Search String
3 Replace scalar   Replace String
Outputs
ID Name Type Remarks
1 Replaced Dataset dataset  

*DATASET_GET_MAP_STRING

Description: Get map string for a set of columns

Syntax: dataset_get_map_string(dataset,cols)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to use <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns scalar    
Outputs
ID Name Type Remarks
1 Mapped String dataset  

*DATASET_GROUP_AND_AGGREGATE_BY

Description: Dataset Group And Aggregate By

Syntax: dataset_group_and_aggregate_by(dataset,groupby,aggregateby,aggregation_type)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Choose Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Group By scalar    
3 Aggregate By scalar    
4 Aggregation Type select    
Outputs
ID Name Type Remarks
1 dataset_group_and_aggregate_by_output_1 dataset  

*DATASET_SQL_QUERY

Description: Dataset Sql Query

Syntax: dataset_sql_query(dataset,query,primary_keys)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 SQL Query textarea   Ex. SELECT MAX(columname) FROM TABLENAME WHERE C2 < 20. It is mandatory to use TABLENAME which will be replaced with the temporary table name
3 Optional Primary Keys textarea    
Outputs
ID Name Type Remarks
1 dataset_sql_query_output_1 dataset  

*DATASET_SPLIT_ROWS

Description: Split rows to colums

Syntax: dataset_split_rows(dataset,primary_key,columns_to_split,name_col,value_col)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Primary Key textarea   Primary key of the dataset
3 Columns textarea    
4 Name Column scalar    
5 Value Column scalar    
Outputs
ID Name Type Remarks
1 Dataset dataset  

*DATASET_DROP_COLUMNS

Description: Dataset Drop Columns

Syntax: dataset_drop_columns(dataset_1,column_names_regex)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 CSV Column Names scalar    
Outputs
ID Name Type Remarks
1 dataset_drop_columns_output_1 dataset  

*DATASET_COMPUTE_AVERAGES

Description: Dataset Compute Averages

Syntax: dataset_compute_averages(dataset_1,columns)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns scalar   Default is for all columns
Outputs
ID Name Type Remarks
1 Average Dataset dataset  

*DATASET_TO_CURVE

Description: Convert a Dataset to Column

Syntax: dataset_to_curve(dataset_1)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 Curve vector  

*DATASET_TO_DOE_PARAMETERS

Description: Dataset To Doe Parameters

Syntax: dataset_to_doe_parameters(dataset_1,columns,dataset_2)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset that contains the column to be digitized <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Columns scalar   Columns which are required to be converted to parameters
3 Configuration dataset   You can specify any additional configurations for each variable as needed in this to overwrite default values <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_to_doe_parameters_output_1 dataset  

*DATASET_ADD_COLUMN_TRANSFORMING_CURVES

Description: Dataset Add Column Transforming Curves

Syntax: dataset_add_column_transforming_curves(dataset_1,new_column_name)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset that contains the column to be digitized <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 New Column Name scalar   New Column name to format
Outputs
ID Name Type Remarks
1 dataset_add_column_transforming_curves_output_1 dataset  

*DATASET_FORMAT_COLUMN

Description: Dataset Format Column

Syntax: dataset_format_column(dataset_1,column_name,format_string)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar   Column name to format. Multiple columns can be provided by using comma as a delimiter
3 Format String scalar   Format string. Multiple columns can be provided by using comma as a delimiter
Outputs
ID Name Type Remarks
1 dataset_format_column_output_1 dataset  

*DATASET_DIGITIZE_COLUMN

Description: Dataset Digitize Column

Syntax: dataset_digitize_column(dataset_1,column_name,num_points)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset that contains the column to be digitized <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar   Column name to format
3 Digitize Points scalar   Number of points to digitize
Outputs
ID Name Type Remarks
1 dataset_digitize_column_output_1 dataset  

*DATASET_REPLACE_COLUMN_VALUE_BY_CONDITION

Description: Dataset Replace Column Value By Condition

Syntax: dataset_replace_column_value_by_condition(dataset,columntoreplace,replacements)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column To Check scalar   Column name of the dataset to be checked
3 Replacements textarea   Conditions using dataset columns such as COL NAME = “abc” => NEW_VALUE
Outputs
ID Name Type Remarks
1 dataset_replace_column_value_by_condition_output_1 dataset  

*DATASET_FILTER_CURVE_COLUMN

Description: Dataset Filter Curve Column

Syntax: dataset_filter_curve_column(dataset,columnstocheck,lookup_type,condition,target_value,reverse)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns To Check scalar   Column name of the dataset to be checked
3 Lookup Type select    
4 Condition select    
5 Target Value scalar   Value to check. For between the value can be seperated as min:max
6 Reverse Matched select    
Outputs
ID Name Type Remarks
1 dataset_filter_curve_column_o1 dataset  

*DATASET_SYNC_CURVE_COLUMNS

Description: Sync X values for the selected columns

Syntax: dataset_sync_curve_columns(dataset_1,target_column,sync_type,monotonic,digitize)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset containing the column <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column textarea    
3 Sync Type select    
4 Monotonic select    
5 Digitize scalar    
Outputs
ID Name Type Remarks
1 Synced Dataset dataset  

*DATASET_GET_CURVE_FROM_COLUMN

Description: Curve from Column

Syntax: dataset_get_curve_from_column(dataset_1,col_name)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Curves <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name float    
Outputs
ID Name Type Remarks
1 dataset_get_curve_from_column vector  

*DATASET_GET_ROW_FOR_CALIBRATION

Description: Dataset Row selector for calibration

Syntax: dataset_get_row_for_calibration(dataset_1,col,criteria,data_type)

Inputs
ID Name Type Default Remarks
1 Dataset with Test Data dataset   <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#curveinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column to use for selection textarea   Column that contains the curve or number to use for selection. If curve, it will return the curve matching the criteria specified below. If its numeric column, the row whose value is closest to the STDDEV is returned
3 Selection Criteria dataset   The default criteria is min if not specifed
4 Type of data to Use select   The data used in pareto-front
Outputs
ID Name Type Remarks
1 curves_get_curve_for_calibration_output_1 dataset  

*DATASET_GET_MAX_BIN_RANGE

Description: Bin values based on Column and return the bin that has the most number of items

Syntax: dataset_get_max_bin_range(dataset_1,target_column,num_of_bins,min_max)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset containing the column <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column textarea    
3 Num Of Bins textarea   Number of BinsNew column name
4 Bin Bound Type select    
Outputs
ID Name Type Remarks
1 Bin Value scalar  

*DATASET_GENERATE_NUMERIC_PARAMETERS

Description: Generates a generic numeric paramaters

Syntax: dataset_generate_numeric_parameters(columns,num_items,min_value,max_value,default_value)

Inputs
ID Name Type Default Remarks
1 Column Prefixes textarea   Multiple column prefixes can be separated by a comma
2 Number of parameters per column textarea    
3 Min Parameter Value textarea    
4 Max Parameter Value textarea    
5 Default Parameter Value textarea    
Outputs
ID Name Type Remarks
1 Parameters dataset  

*DATASET_SIMULATED_ANNEALING_OPTIMIZER

Description: Find the optimize X based on the simulated annealing

Syntax: dataset_simulated_annealing_optimizer(dataset_1,inputs,targets,num_iterations,step_size,initial_temperature,model_type,model_params,shrink_factor,return_type,normalize,target_value,objective,grid_search,constraints,mathmodel_id,stopping_criteria)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Curve which contains the x and y points <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Inputs textarea   Columns that are inputs for the dataset
3 Targets textarea   Columns that represents the Targets
4 Number Of Iterations scalar    
5 Step Size scalar    
6 Initial Temperature scalar    
7 Model Type select    
8 Model Parameters form-input-table    
9 Shrink Factor scalar    
10 Return Type select    
11 Data Normalization Type select    
12 Target Value textarea   Target value for optimum
13 Objective select    
14 Grid Search select    
15 Constraints dataset   Dataset with constraints. The expected columns are needle, condition, target. Where needle is the column that is meet the condition specified by target. Ex needle=variable1 condition=gt and target=10.0 <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
16 Mathmodel remote_lookup    
17 STOP RATIO scalar   When convergence is not improving after STOP_RATIO*NUM_ITERATIONS, the optimization is terminated. If STOP < 0, the optimization is stopped when convergence is not improving within abs(STOP_RATIO) steps
Outputs
ID Name Type Remarks
1 dataset_simulated_annealing_optimizer_output_1 dataset  

*DATASET_RUN_SENTIMENT_ANALYSIS

Description: Run sentiment analysis on a dataset column

Syntax: dataset_run_sentiment_analysis(dataset_1,target_column,new_col_name,positive_threshold,positive_words,negative_words)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset containing the column <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column textarea    
3 New Column Name textarea    
4 Positive Threshold Value textarea    
5 Additional Positive Words textarea    
6 Additional Negative Words textarea    
Outputs
ID Name Type Remarks
1 dataset_run_sentiment_analysis_output_1 dataset  

*DATASET_CURVE_COLUMN_TO_MATRIX

Description: Convert a curve column to a matrix

Syntax: dataset_curve_column_to_matrix(dataset_1,cols,matrix_cols,new_col_name)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset which contains a curve column
2 Curve Column select    
3 Number of Columns for Matrix scalar   Curve y-points will be split into this number of columns for the Matrix
4 Column Name scalar   Matrix output for the curve
Outputs
ID Name Type Remarks
1 Transformed Dataset dataset  

*DATASET_REMOVE_OUTLIERS

Description: Dataset Remove Outliers

Syntax: dataset_remove_outliers(dataset,columnstocheck,num_iterations)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns To Check scalar   Column name of the dataset to be checked
3 Number Of Iterations scalar   Number of iterations
Outputs
ID Name Type Remarks
1 dataset_remove_outliers_output_1 dataset  

*DATASET_GET_SOBOL

Description: Dataset Get Sobol

Syntax: dataset_get_sobol(dataset,inputs,targets,num_sampling)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Inputs scalar    
3 Targets scalar    
4 Number Of Sampling scalar    
Outputs
ID Name Type Remarks
1 dataset_sobol_output_1 dataset  

*DATASET_FILTER_COLUMNS_BY_CORRELATION

Description: Dataset Filter Columns By Correlation

Syntax: dataset_filter_columns_by_correlation(dataset,columnstocheck,min_corr,max_corr,targetcolumn)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Columns To Check scalar   Column name of the dataset to be checked
3 Min Correlation Value scalar    
4 Max Correlation Value scalar    
5 Target Column scalar   Target column to check for correlation. If undefined, each columns will be checked
Outputs
ID Name Type Remarks
1 dataset_filter_columns_by_correlation_output_1 dataset  

*DATASET_SET_COLUMN_VALUE_BY_CONDITION

Description: Dataset Set Column Value By Condition

Syntax: dataset_set_column_value_by_condition(dataset,columntocheck,conditions,columntoset,new_value)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column To Check scalar   Column name of the dataset to be checked
3 Conditions labelcondition   Conditions to be satisfied in order for values to be included
4 Column To Set scalar    
5 New Value scalar    
Outputs
ID Name Type Remarks
1 dataset_set_column_value_by_condition_output_1 dataset  

*DATASET_GET_COLUMN_VALUE_BY_CONDITION

Description: Dataset Get Column Value By Condition

Syntax: dataset_get_column_value_by_condition(dataset,columntocheck,conditions,columntoreturn)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column To Check scalar   Column name of the dataset to be checked
3 Conditions labelcondition   Conditions to be satisfied in order for values to be included
4 Column To Return scalar    
Outputs
ID Name Type Remarks
1 dataset_get_column_value_by_condition_output_1 scalar  

*DATASET_REDUCE

Description: Reduce Dataset to single column and unify keys

Syntax: dataset_reduce(dataset)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to reduce <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 Dataset Reduced dataset  

*DATASET_SCAN_OUT_OF_RANGE_ROWS

Description: Scan the dataset and compare its column values to a reference dataset and flag if they are in or out of range of the reference values

Syntax: dataset_scan_out_of_range_rows(dataset,dataset_ref,cols)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to scan <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Reference Dataset dataset   Dataset to scan <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Columns To Scan select    
Outputs
ID Name Type Remarks
1 Dataset Scanned dataset  

*DATASET_DROP_COLUMNS

Description: Dataset Drop Columns

Syntax: dataset_drop_columns(dataset_1,column_names_regex)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 CSV Column Names scalar    
Outputs
ID Name Type Remarks
1 dataset_drop_columns_output_1 dataset  

*DATASET_GET_DEFINE_TABLE

Description: Dataset Get Define Table

Syntax: dataset_get_define_table(dataset_1,value_column,curve_column)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Value Column scalar    
3 Curve Column scalar    
Outputs
ID Name Type Remarks
1 dataset_get_define_table_output_1 define_table  

*DATASET_SET_CONSTANT_VALUE_BY_COLUMN

Description: Dataset Set Constant Value By Column

Syntax: dataset_set_constant_value_by_column(dataset_1,column_name,col_value)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar   Column name of the dataset to be checked
3 New Value scalar    
Outputs
ID Name Type Remarks
1 dataset_set_constant_value_by_column_output_1 dataset  

*DATASET_MERGE

Description: Dataset Merge

Syntax: dataset_merge(dataset1,dataset2)

Inputs
ID Name Type Default Remarks
1 Source Dataset dataset   Dataset to be added to <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Dataset 2 dataset   Dataset to be added <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_merge_output_1 dataset  

*DATASET_SELECT_ROW

Description: Dataset Select Row

Syntax: dataset_select_row(dataset_1,columns,selection_type)

Inputs
ID Name Type Default Remarks
1 Dataset to select from dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column scalar   Column whose values will be used. For curve columns, the curve values will be used
3 Selection Type select   Selection type
Outputs
ID Name Type Remarks
1 dataset_merge_output_1 dataset  

*DATASET_GET_COLUMN_RATIO

Description: Dataset Get Column Ratio

Syntax: dataset_get_column_ratio(dataset1,dataset2,column_name)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Column Name scalar   Column name of the dataset to be checked
Outputs
ID Name Type Remarks
1 dataset_get_column_ratio_output_1 dataset  

*DATASET_EXTEND_ROWS

Description: Dataset Extend Rows

Syntax: dataset_extend_rows(dataset_1,num_rows)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to extend <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Num Of Rows string   Number of rows to extend the dataset using the last row
Outputs
ID Name Type Remarks
1 Extended Dataset dataset  

*DATASET_GET_ROWS_BY_CONDITION

Description: Dataset Get Rows By Condition

Syntax: dataset_get_rows_by_condition(dataset,columntocheck,operator,value)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column To Check scalar   Column name of the dataset to be checked
3 Operator select    
4 Value scalar   Expected value
Outputs
ID Name Type Remarks
1 dataset_get_rows_by_condition_output_1 dataset  

*DATASET_GET_COLUMN_VALUES

Description: Dataset Get Column Values

Syntax: dataset_get_column_values(dataset_1,column_names,col_delimiter,row_delimiter,type_of_value_to_return)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Names scalar   Column name of the dataset to be checked
3 Col Delimiter scalar   Delimiter used to separate columns
4 Row Delimiter scalar   Delimiter used to separate rows
5 Type Of Value To Return select   Type of value to return
Outputs
ID Name Type Remarks
1   scalar  

*DATASET_GET_COLUMN_NAMES

Description: Dataset Get Column Names

Syntax: dataset_get_column_names(dataset_1,search_type,target_value)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Search Type select   Type of search
3 Target string    
Outputs
ID Name Type Remarks
1 dataset_get_column_names_output_1 scalar  

*DATASET_SORT_BY_COLUMN

Description: Dataset Sort By Column

Syntax: dataset_sort_by_column(dataset_1,choose_column,order_type,regex)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column textarea   Column to be used for sorting
3 Choose Order select    
4 Regex textarea   _d+ will use all digits following an underscore
Outputs
ID Name Type Remarks
1 dataset_sort_by_column_output_1 dataset  

*DATASET_SORT_COLUMN_NAMES

Description: Dataset Sort Column Names

Syntax: dataset_sort_column_names(dataset_1,choose_column,regex,order_type)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Columns textarea   Column to be used for sorting
3 Regex textarea   _d+ will use all digits following an underscore
4 Choose Order select    
Outputs
ID Name Type Remarks
1 Dataset sorted dataset  

*DATASET_RENAME_COLUMNS

Description: Dataset Rename Columns

Syntax: dataset_rename_columns(dataset_1,mapper_input,custom_input)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Mapper mapper   Mapping definition
3 Custom Map Names textarea   Custom Mapping definition. See <a href=’https://www.d3view.com/docs/master/workflows/Glossary.html#mapdefinitionsinput’ target=’_blank’ class=’btn btn-sm btn-default’> <i class=’fa fa-external-link’> </i> Example </a>
Outputs
ID Name Type Remarks
1 dataset_rename_columns_output_1 dataset  

*DATASET_RENAME_COLUMN

Description: Dataset Rename Column

Syntax: dataset_rename_column(dataset_1,from,to)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 From textarea   From column
3 To textarea   To column
Outputs
ID Name Type Remarks
1 dataset_rename_column_output_1 dataset  

*DATASET_SCALE_COLUMN

Description: Dataset Scale Column

Syntax: dataset_scale_column(dataset_1,col_to_scale,scale_factor)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column scalar   Column whose value will be used to scale
3 Scale Factor textarea   Scale factor use scale the column with
Outputs
ID Name Type Remarks
1 Dataset with Scaled Column dataset  

*DATASET_FILTER

Description: Dataset Filter

Syntax: dataset_filter(dataset_1,filter)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be filtered <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Filter filters   Choose filter conditions
Outputs
ID Name Type Remarks
1 dataset_filter_output_1 dataset  

*DATASET_SORT_BY_DATASET

Description: Dataset Sort By Dataset

Syntax: dataset_sort_by_dataset(dataset_1,dataset_2,primary_key,sort_column,use_abs_value,order,limit)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Dataset 2 dataset   Column in this dataset to be used for sorting <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Primary Key scalar   Column to be used for joining
4 Sort Column scalar   Column to be used for sorting
5 Choose Abs Value select    
6 Choose Order select    
7 Limit scalar   If less than zero, a factor of the max-min is used to determine which rows are to be included
Outputs
ID Name Type Remarks
1 dataset_sort_by_dataset_output_1 dataset  

*DATASET_FILTER_BY_COLUMN_DIFF

Description: Dataset Filter By Column Diff

Syntax: dataset_filter_by_column_diff(dataset_1,choose_column,ratio,include_exclude)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column textarea   Column to be used for sorting
3 Ratio textarea    
4 Include Or Exclude select    
Outputs
ID Name Type Remarks
1 dataset_filter_by_column_diff_output_1 dataset  

*DATASET_SORT_BY_KEYVALUE

Description: Dataset Sort By Keyvalue

Syntax: dataset_sort_by_keyvalue(dataset_1,keyvalue_data,primary_key,use_abs_value,order,limit)

Inputs
ID Name Type Default Remarks
1 Choose Dataset dataset   Dataset to be sorted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Key Value keyvalue   Sorts the dataset using the value of the keyvalue input <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Primary Key scalar   Primary key for the dataset
4 Choose Abs Value select    
5 Choose Order select    
6 Limit scalar    
Outputs
ID Name Type Remarks
1 dataset_sort_by_keyvalue_output_1 dataset  

*DATASET_GET_ROW_BY_CONDITION

Description: Dataset Get Row By Condition

Syntax: dataset_get_row_by_condition(dataset,columntocheck,operator,value)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column To Check scalar   Column name of the dataset to be checked
3 Operator select    
4 Value scalar   Expected value
Outputs
ID Name Type Remarks
1 dataset_get_row_by_condition_output_1 keyvalue  

*DATASET_REGRESSION_PREDICT

Description: Dataset Regression Predict

Syntax: dataset_regression_predict(dataset,meta-model,new_column_name)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Meta-Model keyvalue   Meta-Model <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#keyvalueinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 New Column Name textarea   New Column Name. By Default its the name as trained
Outputs
ID Name Type Remarks
1 dataset_regression_predict_output_1 keyvalue  

*DATASET_CURVE_TO_BILINEAR_COLUMNS

Description: Dataset Curve To Bilinear Columns

Syntax: dataset_curve_to_bilinear_columns(dataset_1,column_name,num_points,prefix,remove_curve_column,sync_curves)

Inputs
ID Name Type Default Remarks
1 Dataset With Columns dataset   Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Curve Column Name scalar   Column name to format
3 Number Of Points scalar    
4 Prefix textarea   Points will be named as PREFIX_ID…
5 Remove Curve Column select   Remove curve column after extraction
6 Sync Curves select   Sync curves so all curves have the save x-values with start and ending being the same
Outputs
ID Name Type Remarks
1 dataset_curve_to_bilinear_columns_output_1 dataset  

*DATASET_RECONSTRUCT_BILINEAR_CURVE

Description: Dataset Reconstruct Bilinear Curve

Syntax: dataset_reconstruct_bilinear_curve(dataset_1,new_column_name)

Inputs
ID Name Type Default Remarks
1 Dataset With Columns dataset   Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 New Column Name scalar    
Outputs
ID Name Type Remarks
1 Datataset dataset  

*DATASET_COLUMNS_TO_CURVES

Description: Dataset Columns To Curves

Syntax: dataset_columns_to_curves(dataset_1,new_col_name,x_point_column,y_point_column)

Inputs
ID Name Type Default Remarks
1 Dataset With Columns dataset   Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 New Column Name scalar    
3 X Column Prefix scalar   Column Prefix with X-Points
4 Y Column Prefix scalar   Column Prefix with Y-Points
Outputs
ID Name Type Remarks
1 dataset_curve_to_columns_output_1 dataset  

*DATASET_CURVE_TO_COLUMNS

Description: Dataset Curve To Columns

Syntax: dataset_curve_to_columns(dataset_1,column_name,num_points,prefix,remove_curve_column,sync_curves,include_x,x_prefix)

Inputs
ID Name Type Default Remarks
1 Dataset With Columns dataset   Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Curve Column Name scalar   Column name to format
3 Number Of Points scalar    
4 Prefix textarea   Points will be named as PREFIX_ID…
5 Remove Curve Column select   Remove curve column after extraction
6 Sync Curves select   Sync curves so all curves have the save x-values with start and ending being the same
7 Include X Values select    
8 X Prefix textarea   Points will be named as PREFIX_ID…
Outputs
ID Name Type Remarks
1 dataset_curve_to_columns_output_1 dataset  

*DATASET_GET_ROW_NEAR_ORIGIN

Description: Dataset Get Row Near Origin

Syntax: dataset_get_row_near_origin(dataset,column_name,num_rows)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset Input <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar   Column name to format
3 Num Rows scalar   Positive numbers return values to the right of the smallest while negative will return to the left
Outputs
ID Name Type Remarks
1 dataset_get_row_near_origin_output_1 dataset  

*DATASET_GET_COLUMN_WITH_NOISE

Description: Dataset Get Column With Noise

Syntax: dataset_get_column_with_noise(dataset_1,column_name,noise_factor)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar    
3 Noise Factor scalar   Noise factor. Larger number yields smaller noise
Outputs
ID Name Type Remarks
1 Dataset with Noise dataset  

*DATASET_KEEP_COLUMNS

Description: Dataset Keep Columns

Syntax: dataset_keep_columns(dataset_1,column_names_regex)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 CSV Column Names scalar    
Outputs
ID Name Type Remarks
1 dataset_keep_columns_output_1 dataset  

*DATASET_COLUMN_TO_CURVE

Description: Dataset Column To Curve

Syntax: dataset_column_to_curve(dataset_1,col_name,format,new_column_name)

Inputs
ID Name Type Default Remarks
1 Dataset With Columns dataset   Dataset that contains the curve data <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Choose Column scalar    
3 format select    
4 New Column Name scalar    
Outputs
ID Name Type Remarks
1 Dataset dataset  

*DATASET_RECONSTRUCT_CURVE_FROM_PREDICTIONS

Description: Dataset Reconstruct Curve From Predictions

Syntax: dataset_reconstruct_curve_from_predictions(dataset_1,raw_column_name,dataset,prediction_points,reconstruction_type,sync_x_values,x_prediction_points)

Inputs
ID Name Type Default Remarks
1 Original Dataset dataset   This dataset contains the points that will be original dataset with curves <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Original Curve Column scalar   Column name to format
3 Prediction Dataset dataset   This dataset contains the prediction curve points <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
4 Prediction Points scalar   Column names that contains the prediction points
5 Type Of Reconstruction select    
6 Sync X-values select    
7 X Prediction Points scalar   Column names that contains the x-predicted points
Outputs
ID Name Type Remarks
1 dataset_reconstruct_curve_from_predictions_output_1 dataset  

*DATASET_GET_NUM_ROWS

Description: Get number of rows from a dataset

Syntax: dataset_get_num_rows(dataset)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 dataset_get_num_rows_output_1 scalar  

*DATASET_GET_NUM_ROWS_BY_CONDITION

Description: Get number of rows from a dataset

Syntax: dataset_get_num_rows_by_condition(dataset,columntocheck,conditions)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column To Check scalar   Column name of the dataset to be checked
3 Conditions labelcondition   Conditions to be satisfied in order for values to be included
Outputs
ID Name Type Remarks
1 dataset_get_num_rows_by_condition_output_1 scalar  

*DATASET_REGRESSION_BUILD

Description: Dataset Regression Build

Syntax: dataset_regression_build(dataset,independent_column,dependent_columns,order)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Independent Column textarea    
3 Dependent Columns textarea    
4 Order scalar    
Outputs
ID Name Type Remarks
1 dataset_regression_build_output_1 keyvalue  

*DATASET_SORT_BY_ROW

Description: Dataset Sort By Row

Syntax: dataset_sort_by_row(dataset,compare_row,diff_type,order,limit,return_type,columns,normalize)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Compare Dataset dataset   First row of this dataset will be used fof computing the difference <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 Diff Type select   Method of difference computation
4 Order select   Order of the returning dataset
5 Limit scalar   Limit the returning dataset rows to this number
6 Return Type select   Type of returning dataset
7 Columns To Match scalar   These columns will be used to compute the diference and find the closest match
8 Normalize select   Normalize columns before sorting
Outputs
ID Name Type Remarks
1 Dataset dataset  

*DATASET_ADD_COLUMN

Description: Dataset Add Column

Syntax: dataset_add_column(dataset,col_name,values)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Column Name scalar    
3 Values scalar   CSV values one for each now
Outputs
ID Name Type Remarks
1 Dataset dataset  

*DATASET_GET_NUM_COLUMNS

Description: Dataset Get Num Columns

Syntax: dataset_get_num_columns(dataset)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset to be checked <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
Outputs
ID Name Type Remarks
1 Number of Columns scalar  

*DATASET_CREATE_EMPTY

Description: Dataset Create Empty

Syntax: dataset_create_empty(num_rows,num_cols,col_prefix,initial_value)

Inputs
ID Name Type Default Remarks
1 Number Of Rows scalar    
2 Number Of Columns scalar    
3 Col Prefix scalar   If CSV, the column names will be used as provided
4 Initial Value scalar    
Outputs
ID Name Type Remarks
1 Dataset dataset  

*DATASET_ADD_COLUMN_FROM_CURVE_LOOKUP

Description: Dataset Add Column From Curve Lookup

Syntax: dataset_add_column_from_curve_lookup(dataset,curve,new_col,start_column,end_column,lookup_type)

Inputs
ID Name Type Default Remarks
1 Dataset dataset   Dataset that contains the columns to use as start and end of the curve <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#datasetinput’> <i class=’fa fa-external-link’> </i> View more </a>
2 Curve vector   Curve whose values are extracted <a class=’btn btn-xs btn-default’ target=’_blank’ href=’https://www.d3view.com/docs/master/workflows/Glossary.html#curveinput’> <i class=’fa fa-external-link’> </i> View more </a>
3 New Column Name scalar    
4 Column That Contains The X-Start scalar   Curve will be clipped between X-START and Y-START specified
5 Column That Contains The Y-Start scalar   Curve will be clipped between X-START and Y-START specified
6 Lookup Type select    
Outputs
ID Name Type Remarks
1 Dataset with new Column dataset