Cookbook

Welcome to the agate cookbook, a source of how-to’s and use cases.

Basics

• Creating tables from various data types

• Saving data to various data types

• Removing columns from a table

• Filtering rows of data

• Sorting rows of data

• Searching through a table

• Standardize names and values

• Calculating statistics

• Computing new columns

• Handling dates and times

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.