Shaping tables

  • Subset
  • Sort
  • Stack
  • Split
  • Transpose
  • Deleting columns
  • Deleting rows
  • Grouping columns
  • Rearranging columns
  • Adding rows
  • Adding columns

Merging data

  • Join
  • Concatenate
  • Update

Metadata

  • Data types
  • Modeling types
  • Standardizing attributes

Anomaly detection

  • Unusual observations
  • Outlier detection

Missing data

  • Imputation
  • Informative missing
  • Missing data pattern

Data cleanup

  • Recoding
  • Editing data values
  • Excluding values
  • Hiding values
  • Finding matching cells

Transforming data

  • Derived variables
  • Feature creation
  • Data transformations
  • Binning data
  • Indicator variable
  • Dummy variable

Data workflow

  • Saving scripts
  • Repeatability
  • Workflow Builder