Skip to main content

DB_Table.select_blank_columns

select_blank_columnswhen treat_nans_as_blank

Group: Selections
Aliases: select_blank_fields, select_missing_columns, select_na

Documentation​

Select columns which are either all blank or contain blank values. If no rows are present, all columns are considered blank.

Arguments​

  • when: By default, only columns consisting of all blank cells are selected. If set to Blank_Selector.Any_Cell, columns with one or more blank values are selected.
  • treat_nans_as_blank: specified whether Number.nan is considered as blank. By default, it is not.

Examples​

Select completely blank columns from a table.​

      table.select_blank_columns

Remarks​

Blank values​

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