tablecloth.api.missing — scicloj/tablecloth 7.000-beta-38

drop-missing clj

(drop-missing ds)

(drop-missing ds columns-selector)

Drop rows with missing values

columns-selector selects columns to look at missing values

fill-range-replace clj

(fill-range-replace ds colname max-span)

(fill-range-replace ds colname max-span missing-strategy)

(fill-range-replace ds colname max-span missing-strategy missing-value)

Fill missing up with lacking values. Accepts

• dataset
• column name
• expected step (max-span, milliseconds in case of datetime column)
• (optional) missing-strategy - how to replace missing, default :down (set to nil if none)
• (optional) missing-value - optional value for replace missing

replace-missing clj

(replace-missing ds)

(replace-missing ds strategy)

(replace-missing ds columns-selector strategy)

(replace-missing ds columns-selector strategy value)

Replaces missing values. Accepts

• dataset
• column selector, default: :all
• strategy, default: :nearest
• value (optional)
• single value
• sequence of values (cycled)
• function, applied on column(s) with stripped missings

Strategies are:

:value - replace with given value :up - copy values up :down - copy values down :updown - copy values up and then down for missing values at the end :downup - copy values down and then up for missing values at the beginning :mid or :nearest - copy values around known values :midpoint - use average value from previous and next non-missing :lerp - trying to lineary approximate values, works for numbers and datetime, otherwise applies :nearest. For numbers always results in float datatype.

select-missing clj

(select-missing ds)

(select-missing ds columns-selector)

Select rows with missing values

columns-selector selects columns to look at missing values