lfill
Syntax
lfill(obj)
Arguments
obj is a vector or a table with only numeric columns.
Details
If obj is a vector: linearly fill the NULL values between 2 non-NULL numeric values in obj.
If obj is a table with only numeric columns: for each column of the table, linearly fill the NULL values between 2 non-NULL numeric values.
lfill does not change obj, whereas lfill! changes obj.
Examples
$ a= NULL 1.5 NULL NULL 4.5
$ a.lfill();
[NULL,1.5,2.5,3.5,4.5]
$ b=1 NULL NULL 6
$ b.lfill();
[1,3,4,6]
$ t=table(1 NULL NULL 4 5 6 as id,2.1 2.2 NULL NULL 2.4 2.6 as val);
$ select * from lfill(t);
id |
val |
---|---|
1 |
2.1 |
2 |
2.2 |
3 |
2.266667 |
4 |
2.333333 |
5 |
2.4 |
6 |
2.6 |