|
1 | 1 | #4-1. Frame - Edit |
2 | 2 |
|
| 3 | +<figure><imgsrc="../../.gitbook/assets/image (205).png"alt=""width="402"><figcaption></figcaption></figure> |
3 | 4 |
|
4 | | - |
5 | | -<figure><imgsrc="../../.gitbook/assets/image (90).png"alt=""><figcaption></figcaption></figure> |
6 | | - |
7 | | -1._**Add Column**_ adds a new column next to the last column. |
8 | | -2._**Add Row**_ adds a new row at the end. |
9 | | -3._**Delete**_ allows the deletion of one or multiple selected columns. |
10 | | -4._**Rename**_ allows the renaming of column names. |
11 | | -5._**As Type**_ enables the change of data type for the values in the column. |
12 | | -6._**To Datetime**_ converts one or multiple selected columns to the Datetime format. |
13 | | -7._**Replace**_ allows changing the values in one or multiple selected columns. |
14 | | -8._**Discretize**_ divides the continuous data in the column into intervals or categories. Works for one column only. |
| 5 | +1._**Add Column**_: Add a new column. |
| 6 | +2._**Add Row**_: Add a new row. |
| 7 | +3._**Delete**_: Enabled when one or multiple columns are selected. It deletes the selected columns. |
| 8 | +4._**Rename**_: Rename the column. |
| 9 | +5._**As Type**_: Change the type of data entered. |
| 10 | +6._**To Datetime**_: Enabled when one or multiple columns are selected. It changes the data in those columns to date format. |
| 11 | +7._**Replace**_: Enabled when one or multiple columns are selected. Change a specific value to another. |
| 12 | +8._**Discretize**_: Enabled when one column is selected. It divides the data in that column into categories or bins. |
15 | 13 |
|
16 | 14 |
|
17 | 15 |
|
18 | 16 | *** |
19 | 17 |
|
20 | 18 | ###Add Column |
21 | 19 |
|
| 20 | +<figure><imgsrc="../../.gitbook/assets/image (206).png"alt=""width="452"><figcaption></figcaption></figure> |
22 | 21 |
|
23 | | - |
24 | | -<figure><imgsrc="../../.gitbook/assets/image (91).png"alt=""width="563"><figcaption></figcaption></figure> |
25 | | - |
26 | | -1. Enter the name of the column to be added in_**New Column**_. |
27 | | -2. Select the type of the column to be added. |
28 | | - |
29 | | -  2-1._**Calculate**_: You can simply add specific data to the column or add calculated values between variables using_**+Variable**_. |
30 | | - |
31 | | -  2-2._**Statistics**_: You can add statistical property values between one or multiple columns to the column. |
32 | | - |
33 | | -  2-3._**Replace**_: You can convert values in a specific column to different values and add them to the column. |
34 | | - |
35 | | -  2-4._**Condition**_: By providing specific conditions, you can transform values that meet those conditions into different values and add them to the column. |
36 | | - |
37 | | -  2-5._**Apply**_: Allows for more complex conditions to be applied. |
| 22 | +1._**New column**_: Name the column you want to add. |
| 23 | +2._**Add type**_: Choose how you want to populate the data in the column you're adding. |
| 24 | +1._**Calculate**_: Fill in the result of an operation between values in a specific variable or column. |
| 25 | +2._**Statistics**_: Populate with statistics for the specific column(s). |
| 26 | +3._**Replace**_: Replaces a specific value in the selected column with another value to fill it. |
| 27 | +4._**Condition**_: Replaces values in the selected column that meet a specific condition with another value. |
| 28 | +5._**Apply**_: Apply more complex conditions. |
38 | 29 |
|
39 | 30 |
|
40 | 31 |
|
41 | 32 | *** |
42 | 33 |
|
43 | 34 | ###Add Row |
44 | 35 |
|
| 36 | +<figure><imgsrc="../../.gitbook/assets/image (207).png"alt=""width="407"><figcaption></figcaption></figure> |
45 | 37 |
|
46 | | - |
47 | | -<figure><imgsrc="../../.gitbook/assets/image (92).png"alt=""width="563"><figcaption></figcaption></figure> |
48 | | - |
49 | | -1. Enter the name of the row to be added in_**New Row**_. The name will be used as the index. |
50 | | -2. Select the type of the row to be added. |
51 | | - |
52 | | -  2-1._**Variable**_: Enter the values to be added to the new row. You can also add calculated values between variables using_**+Variable**_. |
| 38 | +1._**New row**_: Set a name for the row, which will be used as the index. |
| 39 | +2. Choose how you want to populate the data for the rows you want to add. |
| 40 | +1._**Variable**_: Fill with a specific value. |
| 41 | +2._**Column**_: Fill with values from a specific column.  |
| 42 | +3. You can also use_**+Variable** to_ put the result of an operation between values or columns. |
53 | 43 |
|
54 | 44 |
|
55 | 45 |
|
56 | 46 | *** |
57 | 47 |
|
58 | 48 | ###To Datetime |
59 | 49 |
|
| 50 | +<figure><imgsrc="../../.gitbook/assets/image (208).png"alt=""width="479"><figcaption></figcaption></figure> |
60 | 51 |
|
61 | | - |
62 | | -<figure><imgsrc="../../.gitbook/assets/image (93).png"alt=""width="563"><figcaption></figcaption></figure> |
63 | | - |
64 | | -1. The name entered in_**New Column**_ becomes the new name for that column. |
65 | | -2. Using_**+Add Column**_, you can add the transformed values to the last column. |
| 52 | +1._**Target column**_: This lists the selected column that you want to change to time format. |
| 53 | +2._**Format**_: Select the time format to be listed. |
| 54 | +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. |
| 55 | +4._**Add-sub columns**_: Add a new column that represents the values in the column changed to time format in a different time type. |
66 | 56 |
|
67 | 57 |
|
68 | 58 |
|
69 | 59 | *** |
70 | 60 |
|
71 | 61 | ###Replace |
72 | 62 |
|
| 63 | +<figure><imgsrc="../../.gitbook/assets/image (209).png"alt=""width="464"><figcaption></figcaption></figure> |
73 | 64 |
|
74 | | - |
75 | | -<figure><imgsrc="../../.gitbook/assets/image (94).png"alt=""width="563"><figcaption></figcaption></figure> |
76 | | - |
77 | | -1. Choose the method of modification. |
78 | | - |
79 | | -  1-1._**Replace**_ changes the values entered in_**Origin**_ to the values entered in_**Replace**_. |
80 | | - |
81 | | -  1-2._**Condition**_ provides specific conditions and changes values that meet those conditions to different values. |
82 | | - |
83 | | -  1-3._**Apply**_: Allows for more complex conditions to be applied. |
| 65 | +1._**Column**_: The selected column is listed. |
| 66 | +2._**Replace type**_: Choose how you want to modify the value. |
| 67 | +1._**Replace**_: Replace the_**Origin value**_ with the_**Replace value**_. |
| 68 | +2._**Condition**_: Replace values that meet a specific condition with_**Replace value**_. |
| 69 | +3._**Apply**_: Replace value with a value that satisfies a more complex condition. |
84 | 70 |
|
85 | 71 |
|
86 | 72 |
|
87 | 73 | *** |
88 | 74 |
|
89 | 75 | ###Discretize |
90 | 76 |
|
| 77 | +<figure><imgsrc="../../.gitbook/assets/image (210).png"alt=""width="404"><figcaption></figcaption></figure> |
91 | 78 |
|
92 | | - |
93 | | -<figure><imgsrc="../../.gitbook/assets/image (95).png"alt=""width="563"><figcaption></figcaption></figure> |
94 | | - |
95 | | -1._**New Column**_: Enter the name for the new column where the results of the operation will be displayed. |
96 | | -2._**Target Column**_: Displays the selected column for the operation. |
97 | | -3._**Bins Count**_: Set the number of intervals. |
98 | | -4._**Discretize Type**_: Choose the type of discretization. Intervals will be created based on the count set in step 3. |
99 | | - |
100 | | -  4-1._**Interval based:**_ The intervals have equal spacing. |
101 | | - |
102 | | -  4-2._**Quantile based**_: Intervals are set based on the quantiles of the data's distribution.  |
103 | | - |
104 | | -  4-3._**Direct Input**_: Allows direct input to modify labels and interval spacing. |
| 79 | +1._**New column**:_ Name the new column where your work product will be listed. |
| 80 | +2._**Target column**_: The name of the selected column is listed. |
| 81 | +3._**Bins count**_: Set the number of bins to discretize the data into. |
| 82 | +4._**Discretize type**_: Select a discretization type. The number of bins follows the value set_in**Bins count**._ |
| 83 | +1._**Interval based**_: Divide the data into equal intervals. |
| 84 | +2._**Quantile based**_: Set and divide bins based on the quantiles of the data distribution. |
| 85 | +3._**Direct input**_: Set the_**Left edge**_,_**Right edge**_ of each section directly. |
105 | 86 |
|