4-1. Frame - Edit

  1. Add Column adds a new column next to the last column.

  2. Add Row adds a new row at the end.

  3. Delete allows the deletion of one or multiple selected columns.

  4. Rename allows the renaming of column names.

  5. As Type enables the change of data type for the values in the column.

  6. To Datetime converts one or multiple selected columns to the Datetime format.

  7. Replace allows changing the values in one or multiple selected columns.

  8. Discretize divides the continuous data in the column into intervals or categories. Works for one column only.


Add Column

  1. Enter the name of the column to be added in New Column.

  2. Select the type of the column to be added.

2-1. Calculate: You can simply add specific data to the column or add calculated values between variables using +Variable.

2-2. Statistics: You can add statistical property values between one or multiple columns to the column.

2-3. Replace: You can convert values in a specific column to different values and add them to the column.

2-4. Condition: By providing specific conditions, you can transform values that meet those conditions into different values and add them to the column.

2-5. Apply: Allows for more complex conditions to be applied.


Add Row

  1. Enter the name of the row to be added in New Row. The name will be used as the index.

  2. Select the type of the row to be added.

2-1. Variable: Enter the values to be added to the new row. You can also add calculated values between variables using +Variable.


To Datetime

  1. The name entered in New Column becomes the new name for that column.

  2. Using +Add Column, you can add the transformed values to the last column.


Replace

  1. Choose the method of modification.

1-1. Replace changes the values entered in Origin to the values entered in Replace.

1-2. Condition provides specific conditions and changes values that meet those conditions to different values.

1-3. Apply: Allows for more complex conditions to be applied.


Discretize

  1. New Column: Enter the name for the new column where the results of the operation will be displayed.

  2. Target Column: Displays the selected column for the operation.

  3. Bins Count: Set the number of intervals.

  4. Discretize Type: Choose the type of discretization. Intervals will be created based on the count set in step 3.

4-1. Interval based: The intervals have equal spacing.

4-2. Quantile based: Intervals are set based on the quantiles of the data's distribution.

4-3. Direct Input: Allows direct input to modify labels and interval spacing.

Last updated