# 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.