4-1. Frame - Edit

1. Add Column: Add a new column.

2. Add Row: Add a new row.

3. Delete: Enabled when one or multiple columns are selected. It deletes the selected columns.

4. Rename: Rename the column.

5. As Type: Change the type of data entered.

6. To Datetime: Enabled when one or multiple columns are selected. It changes the data in those columns to date format.

7. Replace: Enabled when one or multiple columns are selected. Change a specific value to another.

8. Discretize: Enabled when one column is selected. It divides the data in that column into categories or bins.

---

Add Column

1. New column: Name the column you want to add.

2. Add type: Choose how you want to populate the data in the column you're adding.

   1. Calculate: Fill in the result of an operation between values in a specific variable or column.

   2. Statistics: Populate with statistics for the specific column(s).

   3. Replace: Replaces a specific value in the selected column with another value to fill it.

   4. Condition: Replaces values in the selected column that meet a specific condition with another value.

   5. Apply: Apply more complex conditions.

---

Add Row

1. New row: Set a name for the row, which will be used as the index.

2. Choose how you want to populate the data for the rows you want to add.

   1. Variable: Fill with a specific value.

   2. Column: Fill with values from a specific column.

   3. You can also use +Variable to put the result of an operation between values or columns.

---

To Datetime

1. Target column: This lists the selected column that you want to change to time format.

2. Format: Select the time format to be listed.

3. If Day first, True is selected, the data will be interpreted as day/month/year instead of month/day/year and changed to a time format.

4. Add-sub columns: Add a new column that represents the values in the column changed to time format in a different time type.

---

Replace

1. Column: The selected column is listed.

2. Replace type: Choose how you want to modify the value.

   1. Replace: Replace the Origin value with the Replace value.

   2. Condition: Replace values that meet a specific condition with Replace value.

   3. Apply: Replace value with a value that satisfies a more complex condition.

---

Discretize

1. New column: Name the new column where your work product will be listed.

2. Target column: The name of the selected column is listed.

3. Bins count: Set the number of bins to discretize the data into.

4. Discretize type: Select a discretization type. The number of bins follows the value set in Bins count.

   1. Interval based: Divide the data into equal intervals.

   2. Quantile based: Set and divide bins based on the quantiles of the data distribution.

   3. Direct input: Set the Left edge, Right edge of each section directly.