4-2. Frame - Transform

1. Set Index sets a chosen column as the index.

2. Reset Index converts the index back into a column.

3. Data Shift shifts the data of one or multiple selected columns by the specified amount.

---

Data Shift

1. Periods: Enter how much to shift the data in the selected column(s).

1-1. Use a positive value to shift down and a negative value to shift up.

2. Frequency: Set the unit for the value entered in Period.

Ex. Period: 3, Frequency: Day -> Shift by 3 days

2-1. There should be periodic information in the index. If there is no specific periodicity, you can skip setting the frequency.

3. Fill Value: Enter the value to fill the empty spaces created by the data shift.