Data Filtering and Recoding
A utility for cleaning and transforming data before analysis — the essential pre-analysis steps of subsetting and reclassifying.
Capabilities
| Capability | What it does |
|---|---|
| Filtering | Select subsets based on conditions (e.g. keep only rows where age > 18) |
| Recoding | Transform variable values (e.g. continuous age into age groups, merge categories) |
Use cases
- Subsetting data to a relevant population
- Creating categorical groupings from continuous variables
- Merging rare categories
- Excluding outliers or invalid values
- Preparing data in the right shape for a statistical test
Best practices
- Document all filtering and recoding steps for reproducibility
- Pre-specify data preparation steps before analysis where possible
- Check the filtered dataset size to ensure adequate sample remains
A UniversalChatBot is available for discussion.