Skip to main content

Table.filter_blank_rows

filter_blank_rowswhentreat_nans_as_blank

Group: Selections
Aliases: drop_missing_rows, dropna

Documentation

Remove rows which are all blank or containing blank values.

Arguments

  • when: If Blank_Selector.Any_Cell, then remove any row containing any blank values. If Blank_Selector.All_Cells, then only remove rows with all blank values.
  • treat_nans_as_blank: If True, then Number.nan is considered as blank.

Remarks

Blank values

Blank values are Nothing, "" and depending on setting Number.nan.