Skip to main content

DB_Table.remove_blank_columns

remove_blank_columnswhen treat_nans_as_blank

Group: Selections
Aliases: drop_missing_columns, drop_na, select_blank_columns, select_blank_fields, select_missing_columns, select_na

Documentation​

Remove 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​

Remove completely blank columns from a table.​

      table.remove_blank_columns

Remarks​

Blank values​

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