ShiftAndFill / Manipulation Layer

Shift values within a column and fill empty positions with a constant value. Similar to pandas' shift(fill_value=x) or R's lag()/lead() with replacement.

Examples: Original: [1,2,3,4,5] Shift +2, fill=0: [0,0,1,2,3] Shift -1, fill=999: [2,3,4,5,999]

Common applications:

Time series analysis with defaults
Sequential data with boundary values
Moving window with padding
Pattern analysis with markers
Gap filling in shifted data
Baseline comparison studies
Edge case handling
Cyclic data analysis

Note: Unlike basic shift, empty positions contain specified fill value instead of nulls.

Table

Select

column

Column to shift. Typical scenarios:

Ordered measurements needing offsets
Sequential data requiring alignment
Time-based values for comparison
Series data with known boundaries
Periodic data with default states

ShiftBy

i32

Number of positions to shift. Direction:

Positive: Forward shift (later positions)
Negative: Backward shift (earlier positions)

Common patterns:

±1 for adjacent comparisons
±24 for daily cycles
±30 for monthly patterns
±52 for yearly analysis

FillValue

oneof

ConstString

string

Text to fill empty positions. Examples:

'MISSING' for clear identification
'N/A' for undefined periods
'' (empty string) for blank spaces
'DEFAULT' for standard values

ConstNumeric

f64

Floating-point number for empty positions. Common values:

0.0 for neutral baseline
-1.0 for sentinel values
999.9 for clear markers
1.0 for unity filling

ConstInt64

i64

64-bit integer for empty positions. Common uses:

0 for baseline counts
-1 for undefined states
999999 for obvious markers
Minimum/maximum bounds

ConstUint64

u64

Unsigned 64-bit integer for empty positions. Typical values:

0 for starting point
Maximum value for boundaries
Special codes for identification
Standard quantities

ConstBool

bool

false

Boolean value for empty positions. Common cases:

false for default state
true for active condition
false for unverified periods
true for assumed states

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.