Cookbook¶
Welcome to the agate cookbook, a source of how-to’s and use cases.
Basics¶
Coming from other tools¶
- SQL
- Excel
- R
- Underscore.js
- Pandas (coming soon!)
Advanced techniques¶
- Filling missing rows in a dataset
- Renaming and reordering columns
- Transforming data (pivot/normalize/denormalize)
- Setting your locale and working with foreign data
- Ranking a sequence of data
- Creating simple charts
- Mapping columns to common lookup tables
Have a common use case that isn’t covered? Please submit an issue on the GitHub repository.