Skip to main content

Data Wrangling

Single Line to Multiline

Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 1

Parameter : Chopkey

XXXXXXXXXXXXXXXXXXX


Delimiter to JSON

Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 6

Parameter : Key_data

Key_data adds a new key-value to each record, the user can iterate through the records and add the new key-value to each one.

Parameter : Delimiter

Delimiter is used to separate values in a list, record, or file.

Parameter : Fields

Files is used in to specify headers name.

Parameter : Autodetect_column_names

XXXXXXXXXXXXXXXXXXX

Parameter : Skip_header

XXXXXXXXXXXXXXXXXXX

Parameter : Response_key

XXXXXXXXXXXXXXXXXXX


JSON to Delimiter

Description : xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


Number of Parameters : 6

Parameter : Key_data

Key_data adds a new key-value to each record, the user can iterate through the records and add the new key-value to each one.

Parameter : Delimiter

Delimiter is used to separate values in a list, record, or file.

Parameter : Fields

Files is used in to specify headers name.

Parameter : Autodetect_column_names

XXXXXXXXXXXXXXXXXXX

Parameter : Skip_header

XXXXXXXXXXXXXXXXXXX

Parameter : Response_key

XXXXXXXXXXXXXXXXXXX



Data Aggregation

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Data aggregation operations are used in processing of raw data, It also helps in grouped, summarized, and processed of the data to make it easier to understand and analyze.


Number of Parameters : 3

Parameter : Data AggregationAgg_data_key

XXXXXXXXXXXXXXXXXXX

Parameter : DataGroupby_key

Aggregation

Groupby_key gives key name that the user wants to group by, besically this is a unique identifier in the dataset.

Parameter : Array_key

Array_key gives the key name wherein the user wants to hold the common keys, the user can provide any key name

Parameter : Array_key_nested_columns

XXXXXXXXXXXXXXXXXXX

Parameter : Data Aggregation

XXXXXXXXXXXXXXXXXXX



Unpivot

Description:

Unpivot operations are used in data transformation process.


Number of Parameters : 2

Parameter : Transpose_key_name

Transpose_key_name used in specify name of key which need to be transposed

Parameter : Transpose_value

Transpose_value used in specify the values which need to be transposed


Pivot

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Pivot operations are used in pivoting data that involves converting long data to wide data,it is often used in data analysis to transform data in to easier format. 


Number of Parameters : 23

Parameter : Transpose_key_nameGet_key

XXXXXXXXXXXXXXXXXXXGet key helps in converting multiline data in to single line data.

Parameter : Transpose_key_name

Transpose_key_name specifies name of the key which needs to be transposed.

Parameter : Transpose_value

XXXXXXXXXXXXXXXXXXXTranspose_value specifies which values needs to be transposed.



Single Line to Tuple

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Single Line to Tuple operations is used to convert a single line of data to a tuple.


Number of Parameters : 3

Parameter : Singleline_key

XXXXXXXXXXXXXXXXXXXSingleline_key helps in reading the dataset from a single line.

Parameter : Table_headers

XXXXXXXXXXXXXXXXXXXTable_headers specifies the key name that is available inside the array.

Parameter : Tuple_key

XXXXXXXXXXXXXXXXXXXTuple_key is the key whichis used to save the tuple data




Tuple to Singleline

Description: xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Tuple to Singleline is used in converting a tuple to a single line which involves in taking a tuple object and converting it to a single string of values


Number of Parameters : 3

Parameter : Tuple_key

XXXXXXXXXXXXXXXXXXXTuple_key helps in to reading the existing tuple data.

Parameter : Tuple_key

XXXXXXXXXXXXXXXXXXXHeaders specifies the key name of the new json

Parameter : Tuple_key

XXXXXXXXXXXXXXXXXXXSingleline_key helps in to save new data